SORT FIELD DATA |
-
- FILE OR SUBFILE NO.: 440.6
- GET CODE: S DISX(1)=$P($G(^PRCH(440.6,D0,0)),U,6)
- QUERY CONDITION: I DISX(1)'=""
- DESCRIPTION OF SORT: STATEMENT DATE not null
- SEARCH EFFICIENCY RATING: 0.0000
- PROBABILITY RATING: 0.0000
- DATA TYPE FOR SORTING: DATE/TIME
- FIELD NO.: 5
- FIELD NAME: STATEMENT DATE
- SORT QUALIFIERS BEFORE FIELD: +#
- SORT QUALIFIERS AFTER FIELD: ;C1
- CROSS REFERENCE DATA: ^PRCH(440.6,"D",^PRCH(440.6,^2
-
- FILE OR SUBFILE NO.: 440.6
- GET CODE: X DPP(2,"OVF0",9.2) S X=$S('$D(^VA(200,+$P(Y(101),U,9),0)):"",1:$P(^(0),U,1)) S D0=I(0,0) I D0>0 S DISX(2)=X
- QUERY CONDITION: I (DISX(2)]]"@z")&(DISX(2)']]"Z")
- DESCRIPTION OF SORT: CREDIT CARD NUMBER IN 440.5:APPROVING OFFICIAL from A to Z
- DATA TYPE FOR SORTING: FREE TEXT
- COMPUTED FIELD CODE: X DPP(2,"OVF0",9.2) S X=$S('$D(^VA(200,+$P(Y(101),U,9),0)):"",1:$P(^(0),U,1)) S D0=I(0,0) I D0>0 S DISX(2)=X
- OVERFLOW DATA:
-
-
- FIRST SUBSCRIPT FOR OVERFLOW: OVF0
- SECOND SUBSCRIPT FOR OVERFLOW: 9.2
- OVERFLOW CODE: S I(0,0)=$G(D0),Y(1)=$S($D(^PRCH(440.6,D0,0)):^(0),1:"") S X=$P(Y(1),U,4) K DIC S DIC="^PRC(440.5,",DIC(0)="MF" D ^DIC S (D,D0)=+Y S Y(101)=$S($D(^PRC(440.5,D0,0)):^(0),1:"")
- FIELD NAME: CREDIT CARD NUMBER IN 440.5:APPROVING OFFICIAL
- SORT QUALIFIERS BEFORE FIELD: +"
- SORT QUALIFIERS AFTER FIELD: ;"APPROVING OFFICIAL: ";C1
- 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 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(3)=X
- QUERY CONDITION: I (DISX(3)]]"@z")&(DISX(3)']]"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(3)=X
- FIELD NAME: CARD HOLDER
- SORT QUALIFIERS BEFORE FIELD: +"16
- SORT QUALIFIERS AFTER FIELD: ;C1
- 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(4)=$P($G(^PRCH(440.6,D0,0)),U,4)
- QUERY CONDITION: I DISX(4)'=""
- DESCRIPTION OF SORT: CREDIT CARD NUMBER not null
- SEARCH EFFICIENCY RATING: 0.0000
- PROBABILITY RATING: 0.0000
- DATA TYPE FOR SORTING: FREE TEXT
- FIELD NO.: 3
- FIELD NAME: CREDIT CARD NUMBER
- SORT QUALIFIERS BEFORE FIELD: @+
-
- FILE OR SUBFILE NO.: 440.6
- GET CODE: S DISX(5)=$P($G(^PRCH(440.6,D0,0)),U,8)
- QUERY CONDITION: I DISX(5)=662
- DESCRIPTION OF SORT: STATION NUMBER equals 662
- SEARCH EFFICIENCY RATING: 0.9894
- PROBABILITY RATING: 0.9894
- DATA TYPE FOR SORTING: FREE TEXT
- FIELD NO.: 7
- FIELD NAME: STATION NUMBER
- SORT QUALIFIERS AFTER FIELD: ;C1
- FROM VALUE INTERNAL: 661.999999
- FROM VALUE EXTERNAL: 662
- TO VALUE INTERNAL: 662
- TO VALUE EXTERNAL: 662
|