PRCH PC AUDIT SORT (718)    SORT TEMPLATE (.401)

Name Value
NAME PRCH PC AUDIT SORT
DESCRIPTION
Sort for the option 'PRCH PC AUDIT'.
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,8)
    QUERY CONDITION:   I DISX(2)=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 BEFORE FIELD:   #
    FROM VALUE INTERNAL:   661.999999
    FROM VALUE EXTERNAL:   662
    TO VALUE INTERNAL:   662
    TO VALUE EXTERNAL:   662
  • FILE OR SUBFILE NO.:   440.6
    GET CODE:   S DISX(3)=$P($G(^PRCH(440.6,D0,0)),U)
    QUERY CONDITION:   I DISX(3)'=""
    DESCRIPTION OF SORT:   ORACLE DOCUMENT ID not null
    SEARCH EFFICIENCY RATING:   0
    PROBABILITY RATING:   0
    DATA TYPE FOR SORTING:   FREE TEXT
    FIELD NO.:   .01
    FIELD NAME:   ORACLE DOCUMENT ID
    SORT QUALIFIERS BEFORE FIELD:   @
    CROSS REFERENCE DATA:   ^PRCH(440.6,"B",^PRCH(440.6,^2
DATE CREATED 2001-04-06 14:50:00
READ ACCESS @
FILE PURCHASE CARD ORDER RECONCILE
WRITE ACCESS @
DATE LAST USED 2001-04-11 00:00:00