PENDING APPT EXCLUDING FUTURE (781)    SORT TEMPLATE (.401)

Name Value
NAME PENDING APPT EXCLUDING FUTURE
DESCRIPTION
This template allows to print a list of pending appointments in the APPT 
DATE order, to be evaluated for possible finalizing.
SORT FIELD DATA
  • FILE OR SUBFILE NO.:   409.69
    GET CODE:   S DISX(1)=$P($G(^SDWL(409.6,D0,1,D1,0)),U,5)
    QUERY CONDITION:   I DISX(1)="Y"
    DESCRIPTION OF SORT:   RETENTION FLAG equals Y (YES - to be sent when 'Final')
    DATA TYPE FOR SORTING:   SET OF CODES
    MULTIPLE FIELD DATA:
    • MULT.FILE OR SUBFILE NO.:   409.6
      NODE:   1
    FIELD NO.:   4
    FIELD NAME:   RETENTION FLAG
    FROM VALUE INTERNAL:   Xz
    FROM VALUE EXTERNAL:   Y
    FROM VALUE PRINTABLE:   Y (YES - to be sent when 'Final')
    TO VALUE INTERNAL:   Y
    TO VALUE EXTERNAL:   Y
    TO VALUE PRINTABLE:   Y (YES - to be sent when 'Final')
    CROSS REFERENCE DATA:   ^SDWL(409.6,"AE",^SDWL(409.6,^2
  • FILE OR SUBFILE NO.:   409.69
    GET CODE:   S DISX(2)=$P($G(^SDWL(409.6,D0,1,D1,0)),U,2)
    QUERY CONDITION:   I (DISX(2)]]3020900.999999)&(DISX(2)']]3030929.24)
    DESCRIPTION OF SORT:   APPT DATE from Sep 1,2002 to Sep 29,2003@24:00
    DATA TYPE FOR SORTING:   DATE/TIME
    MULTIPLE FIELD DATA:
    • MULT.FILE OR SUBFILE NO.:   409.6
      NODE:   1
    FIELD NO.:   1
    FIELD NAME:   APPT DATE
    FROM VALUE INTERNAL:   3020900.999999
    FROM VALUE EXTERNAL:   Sep 1,2002
    FROM VALUE PRINTABLE:   Sep 1,2002
    TO VALUE INTERNAL:   3030929.24
    TO VALUE EXTERNAL:   Sep 29,2003@2400
    TO VALUE PRINTABLE:   Sep 29,2003@24:00
  • FILE OR SUBFILE NO.:   409.69
    GET CODE:   S DISX(3)=$P($G(^SDWL(409.6,D0,1,D1,0)),U,9)
    QUERY CONDITION:   I 1
    DESCRIPTION OF SORT:   All APPOINTMENT TYPE (includes nulls)
    DATA TYPE FOR SORTING:   SET OF CODES
    MULTIPLE FIELD DATA:
    • MULT.FILE OR SUBFILE NO.:   409.6
      NODE:   1
    FIELD NO.:   8
    FIELD NAME:   APPOINTMENT TYPE
    FROM VALUE INTERNAL:   ?z
    FROM VALUE EXTERNAL:   @
    TO VALUE INTERNAL:   z
  • FILE OR SUBFILE NO.:   409.69
    GET CODE:   S DISX(4)=$P($G(^SDWL(409.6,D0,1,D1,0)),U,6)
    QUERY CONDITION:   I 1
    DESCRIPTION OF SORT:   All EVENT REASON (includes nulls)
    DATA TYPE FOR SORTING:   SET OF CODES
    MULTIPLE FIELD DATA:
    • MULT.FILE OR SUBFILE NO.:   409.6
      NODE:   1
    FIELD NO.:   5
    FIELD NAME:   EVENT REASON
    FROM VALUE INTERNAL:   ?z
    FROM VALUE EXTERNAL:   @
    TO VALUE INTERNAL:   z
DATE CREATED 2003-09-29 10:03:00
READ ACCESS @
FILE PATIENT APPOINTMENT INFO LOG
WRITE ACCESS @
DATE LAST USED 2003-10-02 00:00:00