SCMC PENDING UNASSIGN (870)    SORT TEMPLATE (.401)

Name Value
NAME SCMC PENDING UNASSIGN
SORT FIELD DATA
  • FILE OR SUBFILE NO.:   404.51
    GET 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)) 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(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)) I D0>0 S DISX(1)=X
    RELATIONAL JUMP FIELD DATA:
    • RELATIONAL START FILE NO.:   404.42
      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(^SCPT(404.42,D0,0)):^(0),1:"") S X=$P(Y(101),U,3),X=X S D(0)=+X
    • RELATIONAL START FILE NO.:   404.43
      NEXT SUBSCRIPT:   100
      TO FILE OR SUBFILE:   404.42
      GLOBAL REFERENCE:   SCPT(404.42,
      MULTIVALUED FLAG:   NOT MULTI-VALUED
      RELATIONAL CODE:   S I(0,0)=D0 S Y(1)=$S($D(^SCPT(404.43,D0,0)):^(0),1:"") S X=$P(Y(1),U,1),X=X S D(0)=+X
    FIELD NAME:   INSTITUTION
    SORT QUALIFIERS BEFORE FIELD:   ""#".07
  • FILE OR SUBFILE NO.:   404.42
    GET CODE:   S Y(101)=$S($D(^SCPT(404.42,D0,0)):^(0),1:"") S X=$S('$D(^DPT(+$P(Y(101),U,1),0)):"",1:$P(^(0),U,1)) I D0>0 S DISX(2)=X
    QUERY CONDITION:   I DISX(2)'=""
    DESCRIPTION OF SORT:   PATIENT not null
    DATA TYPE FOR SORTING:   FREE TEXT
    COMPUTED FIELD CODE:   S Y(101)=$S($D(^SCPT(404.42,D0,0)):^(0),1:"") S X=$S('$D(^DPT(+$P(Y(101),U,1),0)):"",1:$P(^(0),U,1)) I D0>0 S DISX(2)=X
    RELATIONAL JUMP FIELD DATA:
    • RELATIONAL START FILE NO.:   404.43
      NEXT SUBSCRIPT:   100
      TO FILE OR SUBFILE:   404.42
      GLOBAL REFERENCE:   SCPT(404.42,
      MULTIVALUED FLAG:   NOT MULTI-VALUED
      RELATIONAL CODE:   S I(0,0)=D0 S Y(1)=$S($D(^SCPT(404.43,D0,0)):^(0),1:"") S X=$P(Y(1),U,1),X=X S D(0)=+X
    FIELD NAME:   PATIENT
    SORT QUALIFIERS BEFORE FIELD:   @"".01
BY(0) UTILITY("SCMCTSK",$J,
L(0) 1
DATE CREATED 2003-07-17 10:01:00
READ ACCESS @
FILE PATIENT TEAM POSITION ASSIGNMENT
WRITE ACCESS @
DATE LAST USED 2004-03-16 00:00:00