LR CAP ELROY (648)    SORT TEMPLATE (.401)

Name Value
NAME LR CAP ELROY
SORT FIELD DATA
  • FILE OR SUBFILE NO.:   67.901
    GET CODE:   S Y(1)=$S($D(^LRO(67.9,D0,1,D1,0)):^(0),1:""),Y=$P(Y(1),U,1) X:$D(^DD(67.901,.01,2)) ^(2) S X=Y I D1>0 S DISX(1)=X
    QUERY CONDITION:   I (DISX(1)]]"REFz")&(DISX(1)']]"Z")
    DESCRIPTION OF SORT:   DIVISION from REG to Z
    DATA TYPE FOR SORTING:   FREE TEXT
    COMPUTED FIELD CODE:   S Y(1)=$S($D(^LRO(67.9,D0,1,D1,0)):^(0),1:""),Y=$P(Y(1),U,1) X:$D(^DD(67.901,.01,2)) ^(2) S X=Y I D1>0 S DISX(1)=X
    MULTIPLE FIELD DATA:
    • MULT.FILE OR SUBFILE NO.:   67.9
      NODE:   1
    FIELD NAME:   DIVISION
    SORT QUALIFIERS BEFORE FIELD:   ".01
    FROM VALUE INTERNAL:   REFz
    FROM VALUE EXTERNAL:   REG
    TO VALUE INTERNAL:   Z
    TO VALUE EXTERNAL:   Z
  • FILE OR SUBFILE NO.:   67.911
    GET CODE:   S DISX(2)=$P($G(^LRO(67.9,D0,1,D1,1,D2,0)),U)
    QUERY CONDITION:   I (DISX(2)]]2970099.99999)&(DISX(2)']]2980407)
    DESCRIPTION OF SORT:   MONTH from 1/0/97 to 4/7/98
    DATA TYPE FOR SORTING:   DATE/TIME
    MULTIPLE FIELD DATA:
    • MULT.FILE OR SUBFILE NO.:   67.9
      NODE:   1
    • MULT.FILE OR SUBFILE NO.:   67.901
      NODE:   1
    FIELD NO.:   .01
    FIELD NAME:   MONTH
    SORT QUALIFIERS BEFORE FIELD:   '
    FROM VALUE INTERNAL:   2970099.99999
    FROM VALUE EXTERNAL:   1-97
    FROM VALUE PRINTABLE:   1/0/97
    TO VALUE INTERNAL:   2980407
    TO VALUE EXTERNAL:   T
    TO VALUE PRINTABLE:   4/7/98
  • FILE OR SUBFILE NO.:   67.9114
    GET CODE:   S DISX(3)=$P($G(^LRO(67.9,D0,1,D1,1,D2,1,D3,0)),U)
    QUERY CONDITION:   I (DISX(3)]]79999.99999)&(DISX(3)']]99999)
    DESCRIPTION OF SORT:   WKLD CODE from 80000 to 99999
    DATA TYPE FOR SORTING:   FREE TEXT
    MULTIPLE FIELD DATA:
    • MULT.FILE OR SUBFILE NO.:   67.9
      NODE:   1
    • MULT.FILE OR SUBFILE NO.:   67.901
      NODE:   1
    • MULT.FILE OR SUBFILE NO.:   67.911
      NODE:   1
    FIELD NO.:   .01
    TEXT SORT FLAG:   TREAT RANGE LIKE TEXT
    FIELD NAME:   WKLD CODE
    SORT QUALIFIERS BEFORE FIELD:   +
    SORT QUALIFIERS AFTER FIELD:   ;S1
    FROM VALUE INTERNAL:   79999.99999
    FROM VALUE EXTERNAL:   80000
    TO VALUE INTERNAL:   99999
    TO VALUE EXTERNAL:   99999
DATE CREATED 1998-03-26 11:44:00
FILE LAB MONTHLY WORKLOADS
DATE LAST USED 1998-04-07 00:00:00