SD-PAIT REJECTED APPT (787)    SORT TEMPLATE (.401)

Name Value
NAME SD-PAIT REJECTED APPT
DESCRIPTION
This template will generate rejected appointments that are still in 
pending status, ready to be transmitted.
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 Y(1)=$S($D(^SDWL(409.6,D0,1,D1,0)):^(0),1:"") S X=$P($G(^SCPT(404.472,+$P(Y(1),U,8),0)),U) I D1>0 S DISX(2)=X
    QUERY CONDITION:   I DISX(2)'=""
    DESCRIPTION OF SORT:   ERROR MESSAGE not null
    DATA TYPE FOR SORTING:   FREE TEXT
    COMPUTED FIELD CODE:   S Y(1)=$S($D(^SDWL(409.6,D0,1,D1,0)):^(0),1:"") S X=$P($G(^SCPT(404.472,+$P(Y(1),U,8),0)),U) I D1>0 S DISX(2)=X
    MULTIPLE FIELD DATA:
    • MULT.FILE OR SUBFILE NO.:   409.6
      NODE:   1
    FIELD NAME:   ERROR MESSAGE
    SORT QUALIFIERS BEFORE FIELD:   "7
  • FILE OR SUBFILE NO.:   409.69
    GET CODE:   S Y(1)=$S($D(^SDWL(409.6,D0,1,D1,0)):^(0),1:"") S X=$P($G(^DPT(+$P(Y(1),U,1),0)),U) I D1>0 S DISX(3)=X
    QUERY CONDITION:   I DISX(3)'=""
    DESCRIPTION OF SORT:   PATIENT not null
    DATA TYPE FOR SORTING:   FREE TEXT
    COMPUTED FIELD CODE:   S Y(1)=$S($D(^SDWL(409.6,D0,1,D1,0)):^(0),1:"") S X=$P($G(^DPT(+$P(Y(1),U,1),0)),U) I D1>0 S DISX(3)=X
    MULTIPLE FIELD DATA:
    • MULT.FILE OR SUBFILE NO.:   409.6
      NODE:   1
    FIELD NAME:   PATIENT
    SORT QUALIFIERS BEFORE FIELD:   ".01
  • FILE OR SUBFILE NO.:   409.69
    GET CODE:   S DISX(4)=$P($G(^SDWL(409.6,D0,1,D1,0)),U,2)
    QUERY CONDITION:   I DISX(4)'=""
    DESCRIPTION OF SORT:   APPT DATE not null
    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
DATE CREATED 2004-04-15 16:02:00
READ ACCESS @
FILE PATIENT APPOINTMENT INFO LOG
WRITE ACCESS @
DATE LAST USED 2008-05-07 00:00:00