SORT FIELD DATA |
-
- FILE OR SUBFILE NO.: 404.52
- GET CODE: S DISX(1)=$P($G(^SCTM(404.52,D0,0)),U,11)
- QUERY CONDITION: I DISX(1)'=""
- DESCRIPTION OF SORT: INACTIVATED AUTOMATICALLY not null
- SEARCH EFFICIENCY RATING: 0.8300
- PROBABILITY RATING: 0.8300
- DATA TYPE FOR SORTING: SET OF CODES
- FIELD NO.: .11
- FIELD NAME: INACTIVATED AUTOMATICALLY
-
- FILE OR SUBFILE NO.: 404.57
- GET CODE: X DPP(2,"OVF100",9.2) S X=$P($G(^DIC(4,+$P(Y(201),U,7),0)),U) S D0=I(100,0) I D0>0 S DISX(2)=X
- QUERY CONDITION: I DISX(2)'=""
- DESCRIPTION OF SORT: TEAM:INST not null
- DATA TYPE FOR SORTING: FREE TEXT
- COMPUTED FIELD CODE: X DPP(2,"OVF100",9.2) S X=$P($G(^DIC(4,+$P(Y(201),U,7),0)),U) S D0=I(100,0) I D0>0 S DISX(2)=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
- OVERFLOW DATA:
-
-
- FIRST SUBSCRIPT FOR OVERFLOW: OVF100
- SECOND SUBSCRIPT FOR OVERFLOW: 9.2
- OVERFLOW CODE: S I(100,0)=$G(D0),Y(101)=$S($D(^SCTM(404.57,D0,0)):^(0),1:""),D0=$P(Y(101),U,2) S:'D0!'$D(^SCTM(404.51,+D0,0)) D0=-1 S Y(201)=$S($D(^SCTM(404.51,D0,0)):^(0),1:"")
- FIELD NAME: TEAM:INST
- SORT QUALIFIERS BEFORE FIELD: ""
-
- FILE OR SUBFILE NO.: 404.52
- GET CODE: S Y(1)=$S($D(^SCTM(404.52,D0,0)):^(0),1:"") S X=$P($G(^VA(200,+$P(Y(1),U,3),0)),U) I D0>0 S DISX(3)=X
- QUERY CONDITION: I DISX(3)'=""
- DESCRIPTION OF SORT: PRACTITIONER not null
- SEARCH EFFICIENCY RATING: 0.0000
- PROBABILITY RATING: 0.0000
- DATA TYPE FOR SORTING: FREE TEXT
- COMPUTED FIELD CODE: S Y(1)=$S($D(^SCTM(404.52,D0,0)):^(0),1:"") S X=$P($G(^VA(200,+$P(Y(1),U,3),0)),U) I D0>0 S DISX(3)=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.52
- GET CODE: S Y(1)=$S($D(^SCTM(404.52,D0,0)):^(0),1:"") S X=$P($G(^SCTM(404.57,+$P(Y(1),U,1),0)),U) I D0>0 S DISX(4)=X
- QUERY CONDITION: I DISX(4)'=""
- DESCRIPTION OF SORT: TEAM POSITION not null
- SEARCH EFFICIENCY RATING: 0.0300
- PROBABILITY RATING: 0.0300
- DATA TYPE FOR SORTING: FREE TEXT
- COMPUTED FIELD CODE: S Y(1)=$S($D(^SCTM(404.52,D0,0)):^(0),1:"") S X=$P($G(^SCTM(404.57,+$P(Y(1),U,1),0)),U) I D0>0 S DISX(4)=X
- FIELD NAME: TEAM POSITION
- SORT QUALIFIERS BEFORE FIELD: ".01
- CROSS REFERENCE DATA: ^SCTM(404.52,"B",^SCTM(404.52,^2
- POINT TO CROSS REFERENCE: ^SCTM(404.57,"B",
|