SORT FIELD DATA |
-
- FILE OR SUBFILE NO.: 404.51
- GET CODE: S Y(101)=$S($D(^SCTM(404.51,D0,0)):^(0),1:"") S X=$S('$D(^DIC(4,+$P(Y(101),U,7),0)):"",1:$P(^(0),U,1)) I D0>0 S DISX(1)=X
- QUERY CONDITION: I DISX(1)'=""
- DESCRIPTION OF SORT: INSTITUTION not null
- DATA TYPE FOR SORTING: FREE TEXT
- COMPUTED FIELD CODE: S Y(101)=$S($D(^SCTM(404.51,D0,0)):^(0),1:"") S X=$S('$D(^DIC(4,+$P(Y(101),U,7),0)):"",1:$P(^(0),U,1)) I D0>0 S DISX(1)=X
- RELATIONAL JUMP FIELD DATA:
-
-
- RELATIONAL START FILE NO.: 404.57
- NEXT SUBSCRIPT: 100
- TO FILE OR SUBFILE: 404.51
- GLOBAL REFERENCE: SCTM(404.51,
- MULTIVALUED FLAG: NOT MULTI-VALUED
- RELATIONAL CODE: S I(0,0)=D0 S Y(1)=$S($D(^SCTM(404.57,D0,0)):^(0),1:"") S X=$P(Y(1),U,2),X=X S D(0)=+X
- FIELD NAME: INSTITUTION
- SORT QUALIFIERS BEFORE FIELD: "#".07
-
- FILE OR SUBFILE NO.: 404.57
- GET CODE: S Y(1)=$S($D(^SCTM(404.57,D0,0)):^(0),1:"") S X=$S('$D(^SCTM(404.51,+$P(Y(1),U,2),0)):"",1:$P(^(0),U,1)) I D0>0 S DISX(2)=X
- QUERY CONDITION: I DISX(2)'=""
- DESCRIPTION OF SORT: TEAM not null
- SEARCH EFFICIENCY RATING: 0.0104
- PROBABILITY RATING: 0.0103
- DATA TYPE FOR SORTING: FREE TEXT
- COMPUTED FIELD CODE: S Y(1)=$S($D(^SCTM(404.57,D0,0)):^(0),1:"") S X=$S('$D(^SCTM(404.51,+$P(Y(1),U,2),0)):"",1:$P(^(0),U,1)) I D0>0 S DISX(2)=X
- FIELD NAME: TEAM
- SORT QUALIFIERS BEFORE FIELD: ".02
- CROSS REFERENCE DATA: ^SCTM(404.57,"C",^SCTM(404.57,^2
- POINT TO CROSS REFERENCE: ^SCTM(404.51,"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
- SEARCH EFFICIENCY RATING: 0
- PROBABILITY RATING: 0
- DATA TYPE FOR SORTING: FREE TEXT
- FIELD NO.: .01
- FIELD NAME: POSITION
- CROSS REFERENCE DATA: ^SCTM(404.57,"B",^SCTM(404.57,^2
|