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
|