SORT FIELD DATA |
-
- FILE OR SUBFILE NO.: 404.51
- GET CODE: X DPP(1,"OVF200",9.3) S X=$P(Y(204),Y(205),Y(206),X) S Y=X,X=Y(203),X=X_Y I D0>0 S DISX(1)=X
- QUERY CONDITION: I DISX(1)'=""
- DESCRIPTION OF SORT: ($P(INSTITUTION,"","")_"" ""_$P(INSTITUTION,"","",2,9)) not null
- DATA TYPE FOR SORTING: FREE TEXT
- COMPUTED FIELD CODE: X DPP(1,"OVF200",9.3) S X=$P(Y(204),Y(205),Y(206),X) S Y=X,X=Y(203),X=X_Y I D0>0 S DISX(1)=X
- RELATIONAL JUMP FIELD DATA:
-
-
- RELATIONAL START FILE NO.: 404.52
- NEXT SUBSCRIPT: 100
- TO FILE OR SUBFILE: 404.57
- GLOBAL REFERENCE: SCTM(404.57,
- MULTIVALUED FLAG: NOT MULTI-VALUED
- RELATIONAL CODE: S I(0,0)=D0 S Y(1)=$S($D(^SCTM(404.52,D0,0)):^(0),1:"") S X=$P(Y(1),U,1),X=X S D(0)=+X
-
- RELATIONAL START FILE NO.: 404.57
- NEXT SUBSCRIPT: 200
- TO FILE OR SUBFILE: 404.51
- GLOBAL REFERENCE: SCTM(404.51,
- MULTIVALUED FLAG: NOT MULTI-VALUED
- RELATIONAL CODE: S I(100,0)=D0 S Y(101)=$S($D(^SCTM(404.57,D0,0)):^(0),1:"") S X=$P(Y(101),U,2),X=X S D(0)=+X
- OVERFLOW DATA:
-
-
- FIRST SUBSCRIPT FOR OVERFLOW: OVF200
- SECOND SUBSCRIPT FOR OVERFLOW: 9.2
- OVERFLOW CODE: S Y(201)=$S($D(^SCTM(404.51,D0,0)):^(0),1:"") S X=$S('$D(^DIC(4,+$P(Y(201),U,7),0)):"",1:$P(^(0),U,1)),Y(202)=X S X=",",X=$P(Y(202),X)_" ",Y(203)=X
-
- FIRST SUBSCRIPT FOR OVERFLOW: OVF200
- SECOND SUBSCRIPT FOR OVERFLOW: 9.3
- OVERFLOW CODE: X DPP(1,"OVF200",9.2) S X=$S('$D(^DIC(4,+$P(Y(201),U,7),0)):"",1:$P(^(0),U,1)),Y(204)=X S X=",",Y(205)=X S X=2,Y(206)=X S X=9
- FIELD NAME: ($P(INSTITUTION,",")_" "_$P(INSTITUTION,",",2,9))
- SORT QUALIFIERS BEFORE FIELD: ""+#"
- SORT QUALIFIERS AFTER FIELD: ;"INSTITUTION: "
-
- FILE OR SUBFILE NO.: 404.52
- GET CODE: S Y(1)=$S($D(^SCTM(404.52,D0,0)):^(0),1:"") S X=$S('$D(^VA(200,+$P(Y(1),U,3),0)):"",1:$P(^(0),U,1)) I D0>0 S DISX(2)=X
- QUERY CONDITION: I DISX(2)'=""
- DESCRIPTION OF SORT: PRACTITIONER not null
- DATA TYPE FOR SORTING: FREE TEXT
- COMPUTED FIELD CODE: S Y(1)=$S($D(^SCTM(404.52,D0,0)):^(0),1:"") S X=$S('$D(^VA(200,+$P(Y(1),U,3),0)):"",1:$P(^(0),U,1)) I D0>0 S DISX(2)=X
- FIELD NAME: PRACTITIONER
- SORT QUALIFIERS BEFORE FIELD: +".03
- CROSS REFERENCE DATA: ^SCTM(404.52,"C",^SCTM(404.52,^2
- POINT TO CROSS REFERENCE: ^VA(200,"B",
-
- FILE OR SUBFILE NO.: 404.57
- GET CODE: S DISX(3)=$P($G(^SCTM(404.57,D0,0)),U)
- QUERY CONDITION: I DISX(3)'=""
- DESCRIPTION OF SORT: POSITION not null
- DATA TYPE FOR SORTING: FREE TEXT
- RELATIONAL JUMP FIELD DATA:
-
-
- RELATIONAL START FILE NO.: 404.52
- NEXT SUBSCRIPT: 100
- TO FILE OR SUBFILE: 404.57
- GLOBAL REFERENCE: SCTM(404.57,
- MULTIVALUED FLAG: NOT MULTI-VALUED
- RELATIONAL CODE: S I(0,0)=D0 S Y(1)=$S($D(^SCTM(404.52,D0,0)):^(0),1:"") S X=$P(Y(1),U,1),X=X S D(0)=+X
- FIELD NO.: .01
- FIELD NAME: POSITION
- SORT QUALIFIERS BEFORE FIELD: "
-
- FILE OR SUBFILE NO.: 404.52
- GET CODE: D @("SCREEN"_U_"SCMCTSK") I D0>0 S DISX(4)=X
- QUERY CONDITION: I DISX(4)=1
- DESCRIPTION OF SORT: D @(""SCREEN""_U_""SCMCTSK"") equals 1
- DATA TYPE FOR SORTING: FREE TEXT
- COMPUTED FIELD CODE: D @("SCREEN"_U_"SCMCTSK") I D0>0 S DISX(4)=X
- FIELD NAME: D @("SCREEN"_U_"SCMCTSK")
- SORT QUALIFIERS BEFORE FIELD: @"
- FROM VALUE INTERNAL: .999999
- FROM VALUE EXTERNAL: 1
- TO VALUE INTERNAL: 1
- TO VALUE EXTERNAL: 1
|