SDWL30DAY (867)    SORT TEMPLATE (.401)

Name Value
NAME SDWL30DAY
DESCRIPTION
Sort template for 30 day report.
SORT FIELD DATA
  • FILE OR SUBFILE NO.:   409.3
    GET CODE:   S Y(1)=$S($D(^SDWL(409.3,D0,0)):^(0),1:"") S X=$P($G(^DIC(4,+$P(Y(1),U,3),0)),U) 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(1)=$S($D(^SDWL(409.3,D0,0)):^(0),1:"") S X=$P($G(^DIC(4,+$P(Y(1),U,3),0)),U) I D0>0 S DISX(1)=X
    FIELD NAME:   INSTITUTION
    SORT QUALIFIERS BEFORE FIELD:   "2
    CROSS REFERENCE DATA:   ^SDWL(409.3,"C",^SDWL(409.3,^2
    POINT TO CROSS REFERENCE:   ^DIC(4,"B",
  • FILE OR SUBFILE NO.:   409.3
    GET CODE:   S DISX(2)=$P($G(^SDWL(409.3,D0,0)),U,16)
    QUERY CONDITION:   I (DISX(2)]]3041019.999999)&(DISX(2)']]3080929.24)
    DESCRIPTION OF SORT:   DESIRED DATE OF APPOINTMENT from Oct 20,2004 to Sep 29,2008@24:00
    DATA TYPE FOR SORTING:   DATE/TIME
    FIELD NO.:   22
    FIELD NAME:   DESIRED DATE OF APPOINTMENT
    SORT QUALIFIERS BEFORE FIELD:   @
    FROM VALUE INTERNAL:   3041019.999999
    FROM VALUE EXTERNAL:   Oct 20,2004
    FROM VALUE PRINTABLE:   Oct 20,2004
    TO VALUE INTERNAL:   3080929.24
    TO VALUE EXTERNAL:   Sep 29,2008@2400
    TO VALUE PRINTABLE:   Sep 29,2008@24:00
  • FILE OR SUBFILE NO.:   409.3
    GET CODE:   S DISX(3)=$P($G(^SDWL(409.3,D0,0)),U,17)
    QUERY CONDITION:   I DISX(3)="O"
    DESCRIPTION OF SORT:   CURRENT STATUS equals O (OPEN)
    DATA TYPE FOR SORTING:   SET OF CODES
    FIELD NO.:   23
    FIELD NAME:   CURRENT STATUS
    SORT QUALIFIERS BEFORE FIELD:   @
    FROM VALUE INTERNAL:   Nz
    FROM VALUE EXTERNAL:   O
    FROM VALUE PRINTABLE:   O (OPEN)
    TO VALUE INTERNAL:   O
    TO VALUE EXTERNAL:   OPEN
    TO VALUE PRINTABLE:   O (OPEN)
DATE CREATED 2006-10-19 16:07:00
READ ACCESS @
FILE SD WAIT LIST
WRITE ACCESS @
DATE LAST USED 2006-10-19 00:00:00