Table 37: Available Data Filters APPOINTMENT ARRAY Format Examples of code to set array with DATA TO BE ENTRY filter values FILTERED APPOINTMENT ARRAY(1) Range of S ARRAY(1)="3030101;3030101" (one DATE/TIME appointment day) date/times, "from" S ARRAY(1)="3040101" (appts after and "to" date/time 2003) separated by S ARRAY(1)=";3031231" (all appts thru semicolon. Dates 3031231) must be FileMan S ARRAY(1)=DT (all appts from today format forward) S ARRAY(1)=DT_";3041231" (all appts from today through 3041231) ARRAY(1)="from date; to date" CLINIC IEN ARRAY(2) List of valid clinic S ARRAY(2)=300 IENs (each S ARRAY(2)="300;301;304" separated by a S ARRAY(2)="^GBL(" semicolon) or a S ARRAY(2)="^GBL(""DFN""" global root or a local S ARRAY(2)="^GBL(""DFN""," root. Clinic must exist on Hospital S ARRAY(2)="LOCAL(" Location file. S ARRAY(2)="LOCAL(""DFN""" S ARRAY(2)="LOCAL(""DFN""," ARRAY (2) ="ien1; ien2" etc. ARRAY(2)="^global(" ARRAY(2)="local(" ARRAY(2)="local(#" ARRAY(2)="local(#," APPOINTMENT ARRAY(3) List of valid S ARRAY(3)="I" STATUS Appointment Status S ARRAY(3)="R;I;NT" values, each S ARRAY(3)="CC;CCR;CP;CPR" separated by a semicolon. Valid values: R (Scheduled/Kept) I (Inpatient)
Table 37: Available Data Filters APPOINTMENT DATA TO BE FILTERED ARRAY ENTRY Format Examples of code to set array with filter values APPOINTMENT DATE/TIME ARRAY(1) Range of appointment date/times, "from" and "to" date/time separated by semicolon. Dates must be FileMan format ARRAY(1)="from date; to date" S ARRAY(1)="3030101;3030101" (one day) S ARRAY(1)="3040101" (appts after 2003) S ARRAY(1)=";3031231" (all appts thru 3031231) S ARRAY(1)=DT (all appts from today forward) S ARRAY(1)=DT_";3041231" (all appts from today through 3041231) CLINIC IEN ARRAY(2) List of valid clinic IENs (each separated by a semicolon) or a global root or a local root. Clinic must exist on Hospital Location file. ARRAY (2) ="ien1; ien2" etc. ARRAY(2)="^global(" ARRAY(2)="local(" ARRAY(2)="local(#" ARRAY(2)="local(#," S ARRAY(2)=300 S ARRAY(2)="300;301;304" S ARRAY(2)="^GBL(" S ARRAY(2)="^GBL(""DFN""" S ARRAY(2)="^GBL(""DFN""," S ARRAY(2)="LOCAL(" S ARRAY(2)="LOCAL(""DFN""" S ARRAY(2)="LOCAL(""DFN""," APPOINTMENT STATUS ARRAY(3) List of valid Appointment Status values, each separated by a semicolon. Valid values: R (Scheduled/Kept) I (Inpatient) S ARRAY(3)="I" S ARRAY(3)="R;I;NT" S ARRAY(3)="CC;CCR;CP;CPR"
pimstm.docx