SORT FIELD DATA |
-
- FILE OR SUBFILE NO.: 440.6
- GET CODE: S Y(1)=$S($D(^PRCH(440.6,D0,0)):^(0),1:"") S X=$S('$D(^VA(200,+$P(Y(1),U,17),0)):"",1:$P(^(0),U,1)) I D0>0 S DISX(1)=X
- QUERY CONDITION: I (DISX(1)]]"@z")&(DISX(1)']]"Z")
- DESCRIPTION OF SORT: CARD HOLDER from A to Z
- DATA TYPE FOR SORTING: FREE TEXT
- COMPUTED FIELD CODE: S Y(1)=$S($D(^PRCH(440.6,D0,0)):^(0),1:"") S X=$S('$D(^VA(200,+$P(Y(1),U,17),0)):"",1:$P(^(0),U,1)) I D0>0 S DISX(1)=X
- FIELD NAME: CARD HOLDER
- SORT QUALIFIERS BEFORE FIELD: @"16
- FROM VALUE INTERNAL: @z
- FROM VALUE EXTERNAL: A
- TO VALUE INTERNAL: Z
- TO VALUE EXTERNAL: Z
-
- FILE OR SUBFILE NO.: 440.6
- GET CODE: S DISX(2)=$P($G(^PRCH(440.6,D0,0)),U,7)
- QUERY CONDITION: I (DISX(2)]]2900100.999999)&(DISX(2)']]3000915)
- DESCRIPTION OF SORT: TRANSACTION DATE from Jan 1,1990 to Sep 15,2000
- SEARCH EFFICIENCY RATING: 0.0000
- PROBABILITY RATING: 0.0000
- DATA TYPE FOR SORTING: DATE/TIME
- FIELD NO.: 6
- FIELD NAME: TRANSACTION DATE
- SORT QUALIFIERS BEFORE FIELD: @
- FROM VALUE INTERNAL: 2900100.999999
- FROM VALUE EXTERNAL: 1.1.90
- FROM VALUE PRINTABLE: Jan 1,1990
- TO VALUE INTERNAL: 3000915
- TO VALUE EXTERNAL: T
- TO VALUE PRINTABLE: Sep 15,2000
-
- FILE OR SUBFILE NO.: 440.6
- GET CODE: S Y(1)=$S($D(^PRCH(440.6,D0,1)):^(1),1:"") S X=$P(Y(1),U,6),Y(2)=X S X=$P(Y(1),U,7),X1=X,X2=+1,X="" D C^%DTC:X1 S X=X,X1=Y(2) D ^XUWORKDY S X=X>5 I D0>0 S DISX(3)=X
- QUERY CONDITION: I DISX(3)
- DESCRIPTION OF SORT: XUWORKDAY(#46,#47+1)>5
- DATA TYPE FOR SORTING: FREE TEXT
- COMPUTED FIELD CODE: S Y(1)=$S($D(^PRCH(440.6,D0,1)):^(1),1:"") S X=$P(Y(1),U,6),Y(2)=X S X=$P(Y(1),U,7),X1=X,X2=+1,X="" D C^%DTC:X1 S X=X,X1=Y(2) D ^XUWORKDY S X=X>5 I D0>0 S DISX(3)=X
- FIELD NAME: XUWORKDAY(#46,#47+1)>5
- SORT QUALIFIERS BEFORE FIELD: @"@B
- SORT QUALIFIERS AFTER FIELD: ;L1
-
- FILE OR SUBFILE NO.: 440.6
- GET CODE: S DISX(4)=$P($G(^PRCH(440.6,D0,0)),U,8)
- QUERY CONDITION: I DISX(4)'=""
- DESCRIPTION OF SORT: STATION NUMBER not null
- SEARCH EFFICIENCY RATING: 0.0000
- PROBABILITY RATING: 0.0000
- DATA TYPE FOR SORTING: FREE TEXT
- FIELD NO.: 7
- FIELD NAME: STATION NUMBER
- SORT QUALIFIERS BEFORE FIELD: @
|