SC PROVIDER FLAGGED BULLE (886)    SORT TEMPLATE (.401)

Name Value
NAME SC PROVIDER FLAGGED BULLE
SORT FIELD DATA
  • FILE OR SUBFILE NO.:   404.52
    GET CODE:   S DISX(1)=$P($G(^SCTM(404.52,D0,0)),U,10)
    QUERY CONDITION:   I DISX(1)'=""
    DESCRIPTION OF SORT:   DATE FLAGGED FOR INACTIVATION not null
    SEARCH EFFICIENCY RATING:   100.0000
    PROBABILITY RATING:   1.0000
    DATA TYPE FOR SORTING:   DATE/TIME
    FIELD NO.:   .091
    FIELD NAME:   DATE FLAGGED FOR INACTIVATION
    SORT QUALIFIERS BEFORE FIELD:   @
    CROSS REFERENCE DATA:   ^SCTM(404.52,"AFLAG",^SCTM(404.52,^2
  • FILE OR SUBFILE NO.:   404.51
    GET CODE:   S Y(201)=$S($D(^SCTM(404.51,D0,0)):^(0),1:"") S X=$P($G(^DIC(4,+$P(Y(201),U,7),0)),U) I D0>0 S DISX(2)=X
    QUERY CONDITION:   I DISX(2)'=""
    DESCRIPTION OF SORT:   INSTITUTION not null
    DATA TYPE FOR SORTING:   FREE TEXT
    COMPUTED FIELD CODE:   S Y(201)=$S($D(^SCTM(404.51,D0,0)):^(0),1:"") S X=$P($G(^DIC(4,+$P(Y(201),U,7),0)),U) 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
    • 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
    FIELD NAME:   INSTITUTION
    SORT QUALIFIERS BEFORE FIELD:   ""@".07
  • 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(3)=X
    QUERY CONDITION:   I DISX(3)'=""
    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(3)=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",
  • 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(4)=X
    QUERY CONDITION:   I DISX(4)'=""
    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(4)=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",
DATE CREATED 2004-03-30 10:48:00
READ ACCESS @
FILE POSITION ASSIGNMENT HISTORY
WRITE ACCESS @
DATE LAST USED 2005-06-15 00:00:00