SCMC FTEE AND PANEL SIZE (914)    SORT TEMPLATE (.401)

Name Value
NAME SCMC FTEE AND PANEL SIZE
DESCRIPTION
Patient FTEE for Active assignments and Panel Size.
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
DATE CREATED 2003-04-21 09:10:00
READ ACCESS @
FILE POSITION ASSIGNMENT HISTORY
WRITE ACCESS @
DATE LAST USED 2005-08-25 00:00:00