ANRVAD (649)    SORT TEMPLATE (.401)

Name Value
NAME ANRVAD
SORT FIELD DATA
  • FILE OR SUBFILE NO.:   2
    GET CODE:   S DISX(1)=$E($G(^DPT(D0,.1)),1,30)
    QUERY CONDITION:   I DISX(1)'=""
    DESCRIPTION OF SORT:   WARD LOCATION not null
    DATA TYPE FOR SORTING:   FREE TEXT
    RELATIONAL JUMP FIELD DATA:
    • RELATIONAL START FILE NO.:   2040
      NEXT SUBSCRIPT:   100
      TO FILE OR SUBFILE:   2
      GLOBAL REFERENCE:   DPT(
      MULTIVALUED FLAG:   NOT MULTI-VALUED
      RELATIONAL CODE:   S I(0,0)=D0 S Y(1)=$S($D(^ANRV(2040,D0,0)):^(0),1:"") S X=$P(Y(1),U,1),X=X S D(0)=+X
    FIELD NO.:   .1
    FIELD NAME:   WARD LOCATION
    SORT QUALIFIERS BEFORE FIELD:   "
    SORT QUALIFIERS AFTER FIELD:   ;S1
  • FILE OR SUBFILE NO.:   2040
    GET CODE:   X DPP(2,"OVF0",9.2) S X=$P(Y(101),U,1) S D0=I(0,0) I D0>0 S DISX(2)=X
    QUERY CONDITION:   I 1
    DESCRIPTION OF SORT:   All NAME:ROOM-BED (includes nulls)
    DATA TYPE FOR SORTING:   FREE TEXT
    COMPUTED FIELD CODE:   X DPP(2,"OVF0",9.2) S X=$P(Y(101),U,1) S D0=I(0,0) I D0>0 S DISX(2)=X
    OVERFLOW DATA:
    • FIRST SUBSCRIPT FOR OVERFLOW:   OVF0
      SECOND SUBSCRIPT FOR OVERFLOW:   9.2
      OVERFLOW CODE:   S I(0,0)=$S($D(D0):D0,1:""),Y(1)=$S($D(^ANRV(2040,D0,0)):^(0),1:""),D0=$P(Y(1),U,1) S:'$D(^DPT(+D0,0)) D0=-1 S Y(101)=$S($D(^DPT(D0,.101)):^(.101),1:"")
    FIELD NAME:   NAME:ROOM-BED
    SORT QUALIFIERS BEFORE FIELD:   @"
    FROM VALUE INTERNAL:   ?z
    TO VALUE INTERNAL:   z
DATE CREATED 1989-11-02 16:51:00
FILE VIST ROSTER
DATE LAST USED 1998-05-07 00:00:00