PRCH CO AO AUDIT (634)    SORT TEMPLATE (.401)

Name Value
NAME PRCH CO AO AUDIT
DESCRIPTION
This is the sort template for the coordinator official approval official
audit report.
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
DATE CREATED 2000-12-04 09:48:00
READ ACCESS @
FILE PURCHASE CARD ORDER RECONCILE
WRITE ACCESS @
DATE LAST USED 2001-04-09 00:00:00