SDEC APPSDGET (3592)    REMOTE PROCEDURE (8994)

Name Value
NAME SDEC APPSDGET
TAG APPSDGET
ROUTINE SDEC
RETURN VALUE TYPE GLOBAL ARRAY
AVAILABILITY RESTRICTED
INACTIVE ACTIVE
WORD WRAP ON FALSE
DESCRIPTION
GET appointment entries from SDEC APPOINTMENT file 409.84
  all records returned if all input is null
INPUT PARAMETER
  • MAXREC
    PARAMETER TYPE:   LITERAL
    REQUIRED:   NO
    SEQUENCE NUMBER:   1
    DESCRIPTION:   
    Max records returned default to all
    
  • LASTSUB
    PARAMETER TYPE:   LITERAL
    REQUIRED:   NO
    SEQUENCE NUMBER:   2
    DESCRIPTION:   
    last subscripts from previous call
    
  • SDBEG
    PARAMETER TYPE:   LITERAL
    REQUIRED:   NO
    SEQUENCE NUMBER:   3
    DESCRIPTION:   
    Begin Date range in external format
    Default to all dates
    
  • SDEND
    PARAMETER TYPE:   LITERAL
    REQUIRED:   NO
    SEQUENCE NUMBER:   4
    DESCRIPTION:   
    End Date range in external format
    Default to all dates
    
  • NOTEFLG
    PARAMETER TYPE:   LITERAL
    REQUIRED:   NO
    SEQUENCE NUMBER:   5
    DESCRIPTION:   
    1=do NOT return NOTE text
    0=return NOTE text
    
  • SDRES
    PARAMETER TYPE:   LITERAL
    REQUIRED:   NO
    SEQUENCE NUMBER:   6
    DESCRIPTION:   
    Resource ID pointer to SDEC RESOURCE file
    Default to all resources
    
  • DFN
    PARAMETER TYPE:   LITERAL
    REQUIRED:   NO
    SEQUENCE NUMBER:   7
    DESCRIPTION:   
    pointer to PATIENT file 2
    Default to all patients
    
  • SDID
    PARAMETER TYPE:   LITERAL
    REQUIRED:   NO
    SEQUENCE NUMBER:   8
    DESCRIPTION:   
    external ID (free-text)
    
RETURN PARAMETER DESCRIPTION
 ; Successful Return:
 ; 6. DFN - Patient ID
 ; 7. NAME - Patient NAME
 ; 8. SDEC_ACCESS_TYPE_IEN - access type ID pointer to
 ;                           SDEC ACCESS TYPE file
 ; 9. SDEC_ACCESS_TYPE_NAME - access type NAME from
 ;                            SDEC ACCESS TYPE file
 ; 10. RESOURCEID - Pointer to the SDEC RESOURCE file
 ; 11. RESOURCE_NAME - NAME from SDEC RESOURCE file
 ; 12. USERIEN - DATA ENTRY CLERK id pointer to NEW PERSON file
 ; 13. USERNAME - DATA ENTRY CLERK name from NEW PERSON file
 ; Global Array in which each array entry contains data from the
 ; 14. DATE3 - DATE APPT MADE in external format
 ; 15. NOSHOW - NOSHOW flag 1=YES; 0=NO default to no
 ; 16. DATE4 - NOSHOW DATETIME in external format
 ; 17. USERIEN1 - NOSHOW BY USER id pointer to NEW PERSON file
 ; 18. USERNAME1 - NOSHOW BY USER name from NEW PERSON file
 ; 19. DATE5 - REBOOK DATETIME in external format
 ; 20. DATE6 - CANCEL DATETIME in external format
 ; 21. USERIEN2 - CANCELLED BY USER id pointer to NEW PERSON file
 ; 22. USERNAME2 - CANCELLED BY USER name from NEW PERSON file
 ; 23. CANCELLATION_REASONS_IEN - CANCELLATION REASON id pointer
 ; SDEC APPOINTMENT file 409.84.
 ;                            to CANCELLATION REASONS file 409.2
 ; 24. CANCELLATION_REASONS_NAME - CANCELLATION REASON name from
 ;                            CANCELLATION REASONS file
 ; 25. WALKIN - WALKIN flag y=YES; n=NO default to NO
 ; 26. CHECKOUT - CHECKOUT date/time in external format
 ; 27. V_PROVIDER_IEN - V PROVIDER IEN id pointer to
 ;                      V PROVIDER file
 ; 28. V_PROVIDER_NAME - V PROVIDER name from V PROVIDER FILE
 ; 29. PROVIEN - PROVIDER id pointer to NEW PERSON file
 ; 30. PROVNAME - PROVIDER name from NEW PERSON file
 ; Data is separated by ^:
 ; 31. STATUS - STATUS set of codes
 ;              valid values in external form are:
 ;                NO-SHOW
 ;                CLINIC
 ;                NO-SHOW & AUTO RE-BOOK
 ;                CANCELLED BY CLINIC & AUTO RE-BOOK
 ;                INPATIENT APPOINTMENT
 ;                CANCELLED BY PATIENT
 ;                CANCELLED BY PATIENT & AUTO-REBOOK
 ;                NO ACTION TAKEN
 ; 1. IEN - pointer to SDEC APPOINTMENT file
 ; 32. APPTLEN - LENGTH OF APPT numeric 5-120
 ; 33. APPT_STAT_IEN - PREV APPT STATUS id pointer to
 ;                     APPOINTMENT STATUS file 409.63
 ; 34. APPT_STAT_NAME - PREV APPT STATUS name from
 ;                      APPOINTMENT STATUS file
 ; 35. DAPTDT - DESIRED DATE OF APPOINTMENT in external format
 ; 36. SDID - EXTERNAL ID free-text
 ; 37. SDAPTYP - APPT REQUEST TYPE - variable pointer pointer
 ;               to one of these files:
 ;                SD WAIT LIST - E|<WL IEN> E|123
 ; 2. DATE1 - STARTTIME in external format
 ;                REQUEST/CONSULTATION - C|<CONSULT IEN> C|123
 ;                RECALL REMINDERS - R|^<RECALL IEN> R|123
 ; 38. NOTE - NOTE free-text converted from Word Processing
 ;            field. May contain Carriage return/line feed
 ;            characters
 ; 3. DATE2 - ENDTIME in external format
 ; 4. CHECKIN_TIME - CHECKIN date/time in external format
 ; 5. DATE - CHECK IN TIME ENTERED - date/time in external format