PRCH P/C ORACLE UNREC SORT (719)    SORT TEMPLATE (.401)

Sort for the option 'PRCH P/C ORACLE', used by the Purchase Card
Coordinator.

• 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)]]661.999999)&(DISX(2)']]688)
  DESCRIPTION OF SORT:   STATION NUMBER from 662 to 688
  SEARCH EFFICIENCY RATING:   0.2979
  PROBABILITY RATING:   0.2979
  DATA TYPE FOR SORTING:   FREE TEXT
  FIELD NO.:   7
  FIELD NAME:   STATION NUMBER
  FROM VALUE INTERNAL:   661.999999
  FROM VALUE EXTERNAL:   662
  TO VALUE INTERNAL:   688
  TO VALUE EXTERNAL:   688