| SORT FIELD DATA |
-
- FILE OR SUBFILE NO.: 5
- GET CODE: S Y(1)=$S($D(^DIC(5,D0,0)):^(0),1:"") S X=$P(Y(1),U,5),X=X S X=X=1 I D0>0 S DISX(1)=X
- QUERY CONDITION: I (DISX(1)]]0)&(DISX(1)']]1)
- DESCRIPTION OF SORT: INTERNAL(#2.1)=1
- DATA TYPE FOR SORTING: FREE TEXT
- COMPUTED FIELD CODE: S Y(1)=$S($D(^DIC(5,D0,0)):^(0),1:"") S X=$P(Y(1),U,5),X=X S X=X=1 I D0>0 S DISX(1)=X
- FIELD NAME: INTERNAL(#2.1)=1
- SORT QUALIFIERS BEFORE FIELD: @"B
- SORT QUALIFIERS AFTER FIELD: ;L1
-
- FILE OR SUBFILE NO.: 5
- GET CODE: S DISX(2)=$P($G(^DIC(5,D0,0)),U)
- QUERY CONDITION: I (DISX(2)]]"@z")&(DISX(2)']]"Z")
- DESCRIPTION OF SORT: NAME from A to Z
- SEARCH EFFICIENCY RATING: 0.0000
- PROBABILITY RATING: 0.0000
- DATA TYPE FOR SORTING: FREE TEXT
- FIELD NO.: .01
- FIELD NAME: NAME
- SORT QUALIFIERS BEFORE FIELD: @
- FROM VALUE INTERNAL: @z
- FROM VALUE EXTERNAL: A
- TO VALUE INTERNAL: Z
- TO VALUE EXTERNAL: Z
- CROSS REFERENCE DATA: ^DIC(5,"B",^DIC(5,^2
-
- FILE OR SUBFILE NO.: 5.01
- GET CODE: S DISX(3)=$P($G(^DIC(5,D0,1,D1,0)),U,5)
- QUERY CONDITION: I DISX(3)=""
- DESCRIPTION OF SORT: INACTIVE DATE is null
- DATA TYPE FOR SORTING: DATE/TIME
- MULTIPLE FIELD DATA:
-
-
- MULT.FILE OR SUBFILE NO.: 5
- NODE: 1
- FIELD NO.: 5
- FIELD NAME: INACTIVE DATE
- SORT QUALIFIERS BEFORE FIELD: @
- FROM VALUE INTERNAL: ?z
- FROM VALUE EXTERNAL: @
- TO VALUE INTERNAL: @
- TO VALUE EXTERNAL: @
-
- FILE OR SUBFILE NO.: 5.01
- GET CODE: S DISX(4)=$P($G(^DIC(5,D0,1,D1,0)),U)
- QUERY CONDITION: I DISX(4)'=""
- DESCRIPTION OF SORT: COUNTY not null
- DATA TYPE FOR SORTING: FREE TEXT
- MULTIPLE FIELD DATA:
-
-
- MULT.FILE OR SUBFILE NO.: 5
- NODE: 1
- FIELD NO.: .01
- FIELD NAME: COUNTY
|
