PRCH CARD INFOSORT (720)    SORT TEMPLATE (.401)

Name Value
NAME PRCH CARD INFOSORT
DESCRIPTION
Sort template for every card by user and station number.
SORT FIELD DATA
  • FILE OR SUBFILE NO.:   440.5
    GET CODE:   S Y(1)=$S($D(^PRC(440.5,D0,0)):^(0),1:"") S X=$S('$D(^VA(200,+$P(Y(1),U,8),0)):"",1:$P(^(0),U,1)) I D0>0 S DISX(1)=X
    QUERY CONDITION:   I (DISX(1)]]"Lz")&(DISX(1)']]"N")
    DESCRIPTION OF SORT:   CARD HOLDER from M to N
    SEARCH EFFICIENCY RATING:   4.6250
    PROBABILITY RATING:   0.8222
    DATA TYPE FOR SORTING:   FREE TEXT
    COMPUTED FIELD CODE:   S Y(1)=$S($D(^PRC(440.5,D0,0)):^(0),1:"") S X=$S('$D(^VA(200,+$P(Y(1),U,8),0)):"",1:$P(^(0),U,1)) I D0>0 S DISX(1)=X
    FIELD NAME:   CARD HOLDER
    SORT QUALIFIERS BEFORE FIELD:   @#"7
    FROM VALUE INTERNAL:   Lz
    FROM VALUE EXTERNAL:   M
    TO VALUE INTERNAL:   N
    TO VALUE EXTERNAL:   N
    CROSS REFERENCE DATA:   ^PRC(440.5,"H",^PRC(440.5,^2
    POINT TO CROSS REFERENCE:   ^VA(200,"B",
  • FILE OR SUBFILE NO.:   440.5
    GET CODE:   S DISX(2)=$P($G(^PRC(440.5,D0,0)),U,11)
    QUERY CONDITION:   I DISX(2)'=""
    DESCRIPTION OF SORT:   PURCHASE CARD NAME not null
    SEARCH EFFICIENCY RATING:   0.2857
    PROBABILITY RATING:   0.2222
    DATA TYPE FOR SORTING:   FREE TEXT
    FIELD NO.:   10
    FIELD NAME:   PURCHASE CARD NAME
    SORT QUALIFIERS BEFORE FIELD:   @
    CROSS REFERENCE DATA:   ^PRC(440.5,"G",^PRC(440.5,^2
  • FILE OR SUBFILE NO.:   440.5
    GET CODE:   S Y(1)=$S($D(^PRC(440.5,D0,2)):^(2),1:"") S X=$S('$D(^PRC(411,+$P(Y(1),U,3),0)):"",1:$P(^(0),U,1)) I D0>0 S DISX(3)=X
    QUERY CONDITION:   I DISX(3)'=""
    DESCRIPTION OF SORT:   STATION NUMBER not null
    DATA TYPE FOR SORTING:   FREE TEXT
    COMPUTED FIELD CODE:   S Y(1)=$S($D(^PRC(440.5,D0,2)):^(2),1:"") S X=$S('$D(^PRC(411,+$P(Y(1),U,3),0)):"",1:$P(^(0),U,1)) I D0>0 S DISX(3)=X
    FIELD NO.:   10
    FIELD NAME:   STATION NUMBER
    SORT QUALIFIERS BEFORE FIELD:   "15
    CROSS REFERENCE DATA:   ^PRC(440.5,"G",^PRC(440.5,^2
DATE CREATED 2001-04-09 07:53:00
READ ACCESS @
FILE PURCHASE CARD INFORMATION
WRITE ACCESS @
DATE LAST USED 2008-10-29 00:00:00