SORT FIELD DATA |
-
- FILE OR SUBFILE NO.: 67.901
- GET CODE: S Y(1)=$S($D(^LRO(67.9,D0,1,D1,0)):^(0),1:""),Y=$P(Y(1),U,1) X:$D(^DD(67.901,.01,2)) ^(2) S X=Y I D1>0 S DISX(1)=X
- QUERY CONDITION: I (DISX(1)]]"REFz")&(DISX(1)']]"Z")
- DESCRIPTION OF SORT: DIVISION from REG to Z
- DATA TYPE FOR SORTING: FREE TEXT
- COMPUTED FIELD CODE: S Y(1)=$S($D(^LRO(67.9,D0,1,D1,0)):^(0),1:""),Y=$P(Y(1),U,1) X:$D(^DD(67.901,.01,2)) ^(2) S X=Y I D1>0 S DISX(1)=X
- MULTIPLE FIELD DATA:
-
-
- MULT.FILE OR SUBFILE NO.: 67.9
- NODE: 1
- FIELD NAME: DIVISION
- SORT QUALIFIERS BEFORE FIELD: ".01
- FROM VALUE INTERNAL: REFz
- FROM VALUE EXTERNAL: REG
- TO VALUE INTERNAL: Z
- TO VALUE EXTERNAL: Z
-
- FILE OR SUBFILE NO.: 67.911
- GET CODE: S DISX(2)=$P($G(^LRO(67.9,D0,1,D1,1,D2,0)),U)
- QUERY CONDITION: I (DISX(2)]]2970099.99999)&(DISX(2)']]2980407)
- DESCRIPTION OF SORT: MONTH from 1/0/97 to 4/7/98
- DATA TYPE FOR SORTING: DATE/TIME
- MULTIPLE FIELD DATA:
-
-
- MULT.FILE OR SUBFILE NO.: 67.9
- NODE: 1
-
- MULT.FILE OR SUBFILE NO.: 67.901
- NODE: 1
- FIELD NO.: .01
- FIELD NAME: MONTH
- SORT QUALIFIERS BEFORE FIELD: '
- FROM VALUE INTERNAL: 2970099.99999
- FROM VALUE EXTERNAL: 1-97
- FROM VALUE PRINTABLE: 1/0/97
- TO VALUE INTERNAL: 2980407
- TO VALUE EXTERNAL: T
- TO VALUE PRINTABLE: 4/7/98
-
- FILE OR SUBFILE NO.: 67.9114
- GET CODE: S DISX(3)=$P($G(^LRO(67.9,D0,1,D1,1,D2,1,D3,0)),U)
- QUERY CONDITION: I (DISX(3)]]79999.99999)&(DISX(3)']]99999)
- DESCRIPTION OF SORT: WKLD CODE from 80000 to 99999
- DATA TYPE FOR SORTING: FREE TEXT
- MULTIPLE FIELD DATA:
-
-
- MULT.FILE OR SUBFILE NO.: 67.9
- NODE: 1
-
- MULT.FILE OR SUBFILE NO.: 67.901
- NODE: 1
-
- MULT.FILE OR SUBFILE NO.: 67.911
- NODE: 1
- FIELD NO.: .01
- TEXT SORT FLAG: TREAT RANGE LIKE TEXT
- FIELD NAME: WKLD CODE
- SORT QUALIFIERS BEFORE FIELD: +
- SORT QUALIFIERS AFTER FIELD: ;S1
- FROM VALUE INTERNAL: 79999.99999
- FROM VALUE EXTERNAL: 80000
- TO VALUE INTERNAL: 99999
- TO VALUE EXTERNAL: 99999
|