ECX PRO RENTAL SORT (935)    SORT TEMPLATE (.401)

Name Value
NAME ECX PRO RENTAL SORT
DESCRIPTION
 
STATION not null
SORT FIELD DATA
  • FILE OR SUBFILE NO.:   4
    GET CODE:   S DISX(1)=$P($G(^DIC(4,D0,99)),U)
    QUERY CONDITION:   I DISX(1)'=""
    DESCRIPTION OF SORT:   STATION NUMBER not null
    DATA TYPE FOR SORTING:   FREE TEXT
    RELATIONAL JUMP FIELD DATA:
    • RELATIONAL START FILE NO.:   660
      NEXT SUBSCRIPT:   100
      TO FILE OR SUBFILE:   4
      GLOBAL REFERENCE:   DIC(4,
      MULTIVALUED FLAG:   NOT MULTI-VALUED
      RELATIONAL CODE:   S I(0,0)=D0 S Y(1)=$S($D(^RMPR(660,D0,0)):^(0),1:"") S X=$P(Y(1),U,10),X=X S D(0)=+X
    FIELD NO.:   99
    FIELD NAME:   STATION NUMBER
    SORT QUALIFIERS BEFORE FIELD:   "
    SORT QUALIFIERS AFTER FIELD:   ;C20;"DIVISION: "
  • FILE OR SUBFILE NO.:   660
    GET CODE:   S DISX(2)=$P($G(^RMPR(660,D0,0)),U,12)
    QUERY CONDITION:   I (DISX(2)]]3191100.999999)&(DISX(2)']]3191130.24)
    DESCRIPTION OF SORT:   DELIVERY DATE from NOV 1,2019 to NOV 30,2019@24:00
    SEARCH EFFICIENCY RATING:   100.0000
    PROBABILITY RATING:   1.0000
    DATA TYPE FOR SORTING:   DATE/TIME
    FIELD NO.:   10
    FIELD NAME:   DELIVERY DATE
    SORT QUALIFIERS BEFORE FIELD:   @
    FROM VALUE INTERNAL:   3191100.999999
    FROM VALUE EXTERNAL:   3191101
    FROM VALUE PRINTABLE:   NOV 1,2019
    TO VALUE INTERNAL:   3191130.24
    TO VALUE EXTERNAL:   3191130@2400
    TO VALUE PRINTABLE:   NOV 30,2019@24:00
    CROSS REFERENCE DATA:   ^RMPR(660,"CT",^RMPR(660,^2
  • FILE OR SUBFILE NO.:   660
    GET CODE:   S DISX(3)=$P($G(^RMPR(660,D0,0)),U,4)
    QUERY CONDITION:   I DISX(3)=5
    DESCRIPTION OF SORT:   TYPE OF TRANSACTION equals 5 (RENTAL)
    SEARCH EFFICIENCY RATING:   0.9890
    PROBABILITY RATING:   0.9890
    DATA TYPE FOR SORTING:   SET OF CODES
    FIELD NO.:   2
    FIELD NAME:   TYPE OF TRANSACTION
    SORT QUALIFIERS BEFORE FIELD:   @
    FROM VALUE INTERNAL:   4.999999
    FROM VALUE EXTERNAL:   5
    FROM VALUE PRINTABLE:   5 (RENTAL)
    TO VALUE INTERNAL:   5
    TO VALUE EXTERNAL:   5
    TO VALUE PRINTABLE:   5 (RENTAL)
DATE CREATED 2022-05-18 10:02:00
READ ACCESS @
FILE RECORD OF PROS APPLIANCE/REPAIR
WRITE ACCESS @
DATE LAST USED 2022-06-17 00:00:00