ANRV DECEASED LIST (655)    SORT TEMPLATE (.401)

Name Value
NAME ANRV DECEASED LIST
SORT FIELD DATA
  • FILE OR SUBFILE NO.:   2
    GET CODE:   S Y(101)=$S($D(^DPT(D0,.35)):^(.35),1:"") S X=$P(Y(101),U,1)'="" I D0>0 S DISX(1)=X
    QUERY CONDITION:   I DISX(1)
    DESCRIPTION OF SORT:   DATE OF DEATH'=""""
    DATA TYPE FOR SORTING:   FREE TEXT
    COMPUTED FIELD CODE:   S Y(101)=$S($D(^DPT(D0,.35)):^(.35),1:"") S X=$P(Y(101),U,1)'="" I D0>0 S DISX(1)=X
    RELATIONAL JUMP FIELD DATA:
    • RELATIONAL START FILE NO.:   2040
      NEXT SUBSCRIPT:   100
      TO FILE OR SUBFILE:   2
      GLOBAL REFERENCE:   DPT(
      MULTIVALUED FLAG:   NOT MULTI-VALUED
      RELATIONAL CODE:   S I(0,0)=D0 S Y(1)=$S($D(^ANRV(2040,D0,0)):^(0),1:"") S X=$P(Y(1),U,1),X=X S D(0)=+X
    FIELD NAME:   DATE OF DEATH'=""
    SORT QUALIFIERS BEFORE FIELD:   ""@B
    SORT QUALIFIERS AFTER FIELD:   ;L1
  • FILE OR SUBFILE NO.:   2040
    GET CODE:   X DPP(2,"OVF0",9.2) S X=$P(Y(101),U,1) S D0=I(0,0) I D0>0 S DISX(2)=X
    QUERY CONDITION:   I DISX(2)'=""
    DESCRIPTION OF SORT:   NAME:DATE OF DEATH not null
    DATA TYPE FOR SORTING:   DATE/TIME
    COMPUTED FIELD CODE:   X DPP(2,"OVF0",9.2) S X=$P(Y(101),U,1) S D0=I(0,0) I D0>0 S DISX(2)=X
    OVERFLOW DATA:
    • FIRST SUBSCRIPT FOR OVERFLOW:   OVF0
      SECOND SUBSCRIPT FOR OVERFLOW:   9.2
      OVERFLOW CODE:   S I(0,0)=$S($D(D0):D0,1:""),Y(1)=$S($D(^ANRV(2040,D0,0)):^(0),1:""),D0=$P(Y(1),U,1) S:'$D(^DPT(+D0,0)) D0=-1 S Y(101)=$S($D(^DPT(D0,.35)):^(.35),1:"")
    FIELD NAME:   NAME:DATE OF DEATH
    SORT QUALIFIERS BEFORE FIELD:   @"
    COMPUTED FIELD TYPE:   D
  • FILE OR SUBFILE NO.:   2040
    GET CODE:   S Y(1)=$S($D(^ANRV(2040,D0,0)):^(0),1:"") S X=$S('$D(^DPT(+$P(Y(1),U,1),0)):"",1:$P(^(0),U,1)) I D0>0 S DISX(3)=X
    QUERY CONDITION:   I DISX(3)'=""
    DESCRIPTION OF SORT:   NAME 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(^ANRV(2040,D0,0)):^(0),1:"") S X=$S('$D(^DPT(+$P(Y(1),U,1),0)):"",1:$P(^(0),U,1)) I D0>0 S DISX(3)=X
    FIELD NAME:   NAME
    SORT QUALIFIERS BEFORE FIELD:   @".01
    CROSS REFERENCE DATA:   ^ANRV(2040,"B",^ANRV(2040,^2
    POINT TO CROSS REFERENCE:   ^DPT("B",
DATE CREATED 1993-06-01 13:40:00
FILE VIST ROSTER
DATE LAST USED 1998-04-30 00:00:00