ENCMR (87)    SORT TEMPLATE (.401)

Name Value
NAME ENCMR
SORT FIELD DATA
  • FILE OR SUBFILE NO.:   6914
    GET CODE:   S Y(1)=$S($D(^ENG(6914,D0,2)):^(2),1:"") S X=$S('$D(^ENG(6914.1,+$P(Y(1),U,9),0)):"",1:$P(^(0),U,1)) I D0>0 S DISX(1)=X
    QUERY CONDITION:   I DISX(1)=200
    DESCRIPTION OF SORT:   CMR equals 200
    SEARCH EFFICIENCY RATING:   9.7143
    PROBABILITY RATING:   0.9067
    DATA TYPE FOR SORTING:   FREE TEXT
    COMPUTED FIELD CODE:   S Y(1)=$S($D(^ENG(6914,D0,2)):^(2),1:"") S X=$S('$D(^ENG(6914.1,+$P(Y(1),U,9),0)):"",1:$P(^(0),U,1)) I D0>0 S DISX(1)=X
    FIELD NAME:   CMR
    SORT QUALIFIERS BEFORE FIELD:   '"19
    FROM VALUE INTERNAL:   199.99999
    FROM VALUE EXTERNAL:   200
    TO VALUE INTERNAL:   200
    TO VALUE EXTERNAL:   200
    CROSS REFERENCE DATA:   ^ENG(6914,"AD",^ENG(6914,^2
    POINT TO CROSS REFERENCE:   ^ENG(6914.1,"B",
  • FILE OR SUBFILE NO.:   6914
    GET CODE:   S Y(1)=$S($D(^ENG(6914,D0,2)):^(2),1:"") S X=$S('$D(^ENCSN(6917,+$P(Y(1),U,8),0)):"",1:$P(^(0),U,1)) I D0>0 S DISX(2)=X
    QUERY CONDITION:   I 1
    DESCRIPTION OF SORT:   All CATEGORY STOCK NUMBER (includes nulls)
    DATA TYPE FOR SORTING:   FREE TEXT
    COMPUTED FIELD CODE:   S Y(1)=$S($D(^ENG(6914,D0,2)):^(2),1:"") S X=$S('$D(^ENCSN(6917,+$P(Y(1),U,8),0)):"",1:$P(^(0),U,1)) I D0>0 S DISX(2)=X
    FIELD NAME:   CATEGORY STOCK NUMBER
    SORT QUALIFIERS BEFORE FIELD:   @"18
    FROM VALUE INTERNAL:   ?z
    FROM VALUE EXTERNAL:   @
    TO VALUE INTERNAL:   z
  • FILE OR SUBFILE NO.:   6914
    GET CODE:   X DPP(3,"OVF0",9.3) S X=$S('$D(^ENG("SP",+$P(Y(1),U,5),0)):"",1:$P(^(0),U,1)),Y(8)=X S X="-",X=$P(Y(8),X) S Y=X,X=Y(7),X=X_Y I D0>0 S DISX(3)=X
    QUERY CONDITION:   I 1
    DESCRIPTION OF SORT:   All $P(LOCATION,""-"",3)_"":""_$P(LOCATION,""-"",2)_"":""_$P(LOCATION,""-"") (includes nulls)
    DATA TYPE FOR SORTING:   FREE TEXT
    COMPUTED FIELD CODE:   X DPP(3,"OVF0",9.3) S X=$S('$D(^ENG("SP",+$P(Y(1),U,5),0)):"",1:$P(^(0),U,1)),Y(8)=X S X="-",X=$P(Y(8),X) S Y=X,X=Y(7),X=X_Y I D0>0 S DISX(3)=X
    OVERFLOW DATA:
    • FIRST SUBSCRIPT FOR OVERFLOW:   OVF0
      SECOND SUBSCRIPT FOR OVERFLOW:   9.2
      OVERFLOW CODE:   S Y(1)=$S($D(^ENG(6914,D0,3)):^(3),1:"") S X=$S('$D(^ENG("SP",+$P(Y(1),U,5),0)):"",1:$P(^(0),U,1)),Y(2)=X S X="-",Y(3)=X S X=3,X=$P(Y(2),Y(3),X)_":",Y(4)=X
    • FIRST SUBSCRIPT FOR OVERFLOW:   OVF0
      SECOND SUBSCRIPT FOR OVERFLOW:   9.3
      OVERFLOW CODE:   X DPP(3,"OVF0",9.2) S X=$S('$D(^ENG("SP",+$P(Y(1),U,5),0)):"",1:$P(^(0),U,1)),Y(5)=X S X="-",Y(6)=X S X=2,X=$P(Y(5),Y(6),X) S Y=X,X=Y(4),X=X_Y_":",Y(7)=X
    FIELD NAME:   $P(LOCATION,"-",3)_":"_$P(LOCATION,"-",2)_":"_$P(LOCATION,"-")
    SORT QUALIFIERS BEFORE FIELD:   @"
    FROM VALUE INTERNAL:   ?z
    FROM VALUE EXTERNAL:   @
    TO VALUE INTERNAL:   z
DATE CREATED 1997-01-07 11:24:00
FILE EQUIPMENT INV.
DATE LAST USED 1997-07-01 00:00:00