PRCH WORKLOAD1 (625)    SORT TEMPLATE (.401)

This sort template is used to track how quickly users
complete purchase card orders.

• FILE OR SUBFILE NO.:   442
  GET CODE:   S Y(1)=$S($D(^PRC(442,D0,0)):^(0),1:"") S X=$S('$D(^PRCD(442.5,+$P(Y(1),U,2),0)):"",1:$P(^(0),U,1)) I D0>0 S DISX(1)=X
  QUERY CONDITION:   I (DISX(1)]]"PURCHASE CARCz")&(DISX(1)']]"PURCHASE CARZ")
  DESCRIPTION OF SORT:   METHOD OF PROCESSING from PURCHASE CARD to PURCHASE CARZ
  SEARCH EFFICIENCY RATING:   0.8704
  PROBABILITY RATING:   0.4653
  DATA TYPE FOR SORTING:   FREE TEXT
  COMPUTED FIELD CODE:   S Y(1)=$S($D(^PRC(442,D0,0)):^(0),1:"") S X=$S('$D(^PRCD(442.5,+$P(Y(1),U,2),0)):"",1:$P(^(0),U,1)) I D0>0 S DISX(1)=X
  FIELD NAME:   METHOD OF PROCESSING
  SORT QUALIFIERS BEFORE FIELD:   @".02
  FROM VALUE INTERNAL:   PURCHASE CARCz
  FROM VALUE EXTERNAL:   PURCHASE CARD
  TO VALUE INTERNAL:   PURCHASE CARZ
  TO VALUE EXTERNAL:   PURCHASE CARZ
  CROSS REFERENCE DATA:   ^PRC(442,"F",^PRC(442,^2
  POINT TO CROSS REFERENCE:   ^PRCD(442.5,"B",
• FILE OR SUBFILE NO.:   442
  GET CODE:   S Y(1)=$S($D(^PRC(442,D0,23)):^(23),1:"") S X=$S('$D(^VA(200,+$P(Y(1),U,22),0)):"",1:$P(^(0),U,1)) I D0>0 S DISX(2)=X
  QUERY CONDITION:   I (DISX(2)]]"@z")&(DISX(2)']]"Z")
  DESCRIPTION OF SORT:   PURCHASE CARD HOLDER from A to Z
  DATA TYPE FOR SORTING:   FREE TEXT
  COMPUTED FIELD CODE:   S Y(1)=$S($D(^PRC(442,D0,23)):^(23),1:"") S X=$S('$D(^VA(200,+$P(Y(1),U,22),0)):"",1:$P(^(0),U,1)) I D0>0 S DISX(2)=X
  FIELD NAME:   PURCHASE CARD HOLDER
  SORT QUALIFIERS BEFORE FIELD:   "61
  FROM VALUE INTERNAL:   @z
  FROM VALUE EXTERNAL:   A
  TO VALUE INTERNAL:   Z
  TO VALUE EXTERNAL:   Z
• FILE OR SUBFILE NO.:   442
  GET CODE:   S DISX(3)=$P($G(^PRC(442,D0,12)),U,3)
  QUERY CONDITION:   I (DISX(3)]]3010100.999999)&(DISX(3)']]3010409.24)
  DESCRIPTION OF SORT:   VALIDATION DATE/TIME from Jan 1,2001 to Apr 9,2001@24:00
  SEARCH EFFICIENCY RATING:   0.9010
  PROBABILITY RATING:   0.9010
  DATA TYPE FOR SORTING:   DATE/TIME
  FIELD NO.:   17
  FIELD NAME:   VALIDATION DATE/TIME
  SORT QUALIFIERS BEFORE FIELD:   @
  FROM VALUE INTERNAL:   3010100.999999
  FROM VALUE EXTERNAL:   1.1.01
  FROM VALUE PRINTABLE:   Jan 1,2001
  TO VALUE INTERNAL:   3010409.24
  TO VALUE EXTERNAL:   T@2400
  TO VALUE PRINTABLE:   Apr 9,2001@24:00
• FILE OR SUBFILE NO.:   440.5
  GET CODE:   S Y(101)=$S($D(^PRC(440.5,D0,2)):^(2),1:"") S X=$S('$D(^PRC(411,+$P(Y(101),U,3),0)):"",1:$P(^(0),U,1)) I D0>0 S DISX(4)=X
  QUERY CONDITION:   I (DISX(4)]]661.999999)&(DISX(4)']]688)
  DESCRIPTION OF SORT:   STATION NUMBER from 662 to 688
  DATA TYPE FOR SORTING:   FREE TEXT
  COMPUTED FIELD CODE:   S Y(101)=$S($D(^PRC(440.5,D0,2)):^(2),1:"") S X=$S('$D(^PRC(411,+$P(Y(101),U,3),0)):"",1:$P(^(0),U,1)) I D0>0 S DISX(4)=X

  RELATIONAL JUMP FIELD DATA:

  • RELATIONAL START FILE NO.:   442
    NEXT SUBSCRIPT:   100
    TO FILE OR SUBFILE:   440.5
    GLOBAL REFERENCE:   PRC(440.5,
    MULTIVALUED FLAG:   NOT MULTI-VALUED
    RELATIONAL CODE:   S I(0,0)=D0 S Y(1)=$S($D(^PRC(442,D0,23)):^(23),1:"") S X=$P(Y(1),U,8),X=X S D(0)=+X

  FIELD NAME:   STATION NUMBER
  SORT QUALIFIERS BEFORE FIELD:   "+@"15
  FROM VALUE INTERNAL:   661.999999
  FROM VALUE EXTERNAL:   662
  TO VALUE INTERNAL:   688
  TO VALUE EXTERNAL:   688