XIP ZIP CODE LIST (836)    SORT TEMPLATE (.401)

Name Value
NAME XIP ZIP CODE LIST
SORT FIELD DATA
  • FILE OR SUBFILE NO.:   5.12
    GET CODE:   S DISX(1)=$P($G(^XIP(5.12,D0,0)),U)
    QUERY CONDITION:   I DISX(1)=26452
    DESCRIPTION OF SORT:   MAIL CODE equals 26452
    SEARCH EFFICIENCY RATING:   100.0000
    PROBABILITY RATING:   1.0000
    DATA TYPE FOR SORTING:   FREE TEXT
    FIELD NO.:   .01
    FIELD NAME:   MAIL CODE
    SORT QUALIFIERS BEFORE FIELD:   @
    SORT QUALIFIERS AFTER FIELD:   ;S1
    FROM VALUE INTERNAL:   26451.999999
    FROM VALUE EXTERNAL:   26452
    TO VALUE INTERNAL:   26452
    TO VALUE EXTERNAL:   26452
    CROSS REFERENCE DATA:   ^XIP(5.12,"B",^XIP(5.12,^2
  • FILE OR SUBFILE NO.:   5.12
    GET CODE:   X DPP(2,"OVF0",9.2) S X=$S(Y(3):Y(4),Y(5):X) I D0>0 S DISX(2)=X
    QUERY CONDITION:   I DISX(2)'=""
    DESCRIPTION OF SORT:   $S((#5)=(#6):0,1:1) not null
    DATA TYPE FOR SORTING:   FREE TEXT
    COMPUTED FIELD CODE:   X DPP(2,"OVF0",9.2) S X=$S(Y(3):Y(4),Y(5):X) I D0>0 S DISX(2)=X
    OVERFLOW DATA:
    • FIRST SUBSCRIPT FOR OVERFLOW:   OVF0
      SECOND SUBSCRIPT FOR OVERFLOW:   9.2
      OVERFLOW CODE:   S Y(1)=$S($D(^XIP(5.12,D0,0)):^(0),1:"") S X=$P(Y(1),U,6),Y(2)=$G(X) S X=$P(Y(1),U,7),Y=X,X=Y(2),X=X=Y,Y(3)=$G(X) S X=0,Y(4)=$G(X) S X=1,Y(5)=$G(X) S X=1
    FIELD NAME:   $S((#5)=(#6):0,1:1)
    SORT QUALIFIERS BEFORE FIELD:   @"
DATE CREATED 2004-04-30 07:03:00
READ ACCESS @
FILE POSTAL CODE
WRITE ACCESS @
DATE LAST USED 2004-05-03 00:00:00