| SORT FIELD DATA |
-
- FILE OR SUBFILE NO.: 409.3
- GET CODE: S Y(1)=$S($D(^SDWL(409.3,D0,0)):^(0),1:"") S X=$P($G(^DIC(4,+$P(Y(1),U,3),0)),U) I D0>0 S DISX(1)=X
- QUERY CONDITION: I DISX(1)'=""
- DESCRIPTION OF SORT: INSTITUTION not null
- DATA TYPE FOR SORTING: FREE TEXT
- COMPUTED FIELD CODE: S Y(1)=$S($D(^SDWL(409.3,D0,0)):^(0),1:"") S X=$P($G(^DIC(4,+$P(Y(1),U,3),0)),U) I D0>0 S DISX(1)=X
- FIELD NAME: INSTITUTION
- SORT QUALIFIERS BEFORE FIELD: "2
- CROSS REFERENCE DATA: ^SDWL(409.3,"C",^SDWL(409.3,^2
- POINT TO CROSS REFERENCE: ^DIC(4,"B",
-
- FILE OR SUBFILE NO.: 409.3
- GET CODE: S DISX(2)=$P($G(^SDWL(409.3,D0,0)),U,16)
- QUERY CONDITION: I (DISX(2)]]3041019.999999)&(DISX(2)']]3080929.24)
- DESCRIPTION OF SORT: DESIRED DATE OF APPOINTMENT from Oct 20,2004 to Sep 29,2008@24:00
- DATA TYPE FOR SORTING: DATE/TIME
- FIELD NO.: 22
- FIELD NAME: DESIRED DATE OF APPOINTMENT
- SORT QUALIFIERS BEFORE FIELD: @
- FROM VALUE INTERNAL: 3041019.999999
- FROM VALUE EXTERNAL: Oct 20,2004
- FROM VALUE PRINTABLE: Oct 20,2004
- TO VALUE INTERNAL: 3080929.24
- TO VALUE EXTERNAL: Sep 29,2008@2400
- TO VALUE PRINTABLE: Sep 29,2008@24:00
-
- FILE OR SUBFILE NO.: 409.3
- GET CODE: S DISX(3)=$P($G(^SDWL(409.3,D0,0)),U,17)
- QUERY CONDITION: I DISX(3)="O"
- DESCRIPTION OF SORT: CURRENT STATUS equals O (OPEN)
- DATA TYPE FOR SORTING: SET OF CODES
- FIELD NO.: 23
- FIELD NAME: CURRENT STATUS
- SORT QUALIFIERS BEFORE FIELD: @
- FROM VALUE INTERNAL: Nz
- FROM VALUE EXTERNAL: O
- FROM VALUE PRINTABLE: O (OPEN)
- TO VALUE INTERNAL: O
- TO VALUE EXTERNAL: OPEN
- TO VALUE PRINTABLE: O (OPEN)
|
