SDEC RESOURCE (3489)    REMOTE PROCEDURE (8994)

Name Value
NAME SDEC RESOURCE
TAG RESOURCE
ROUTINE SDEC
RETURN VALUE TYPE GLOBAL ARRAY
AVAILABILITY RESTRICTED
INACTIVE ACTIVE
WORD WRAP ON FALSE
DESCRIPTION
Returns Recordset with ALL RESOURCE names.
Inactive RESOURCES are NOT filtered out.
INPUT PARAMETER
  • SDECDUZ
    PARAMETER TYPE:   LITERAL
    REQUIRED:   NO
    SEQUENCE NUMBER:   1
    DESCRIPTION:   
    User ID pointer to NEW PERSON file 200
    Defaults to current user.
    Checks that THIS user has the proper SECURITY KEY
    
  • SDACT
    PARAMETER TYPE:   LITERAL
    REQUIRED:   NO
    SEQUENCE NUMBER:   2
    DESCRIPTION:   
    Active Flag:
     1 or YES will return only active resources
     0, NO, or NULL will include inactive resources
    
  • SDTYPE
    PARAMETER TYPE:   LITERAL
    REQUIRED:   NO
    SEQUENCE NUMBER:   3
    DESCRIPTION:   
    null will return all resource types
                 H will only return HOSPITAL LOCATION (clinic) resources
                 P will only return NEW PERSON (Provider) resources
                 A will only return SDEC ADDITIONAL RESOURCE resources
                PH will only return prohibited clinics
    
  • MAXREC
    PARAMETER TYPE:   LITERAL
    REQUIRED:   NO
    SEQUENCE NUMBER:   4
    DESCRIPTION:   
    Max records returned
    
  • LASTSUBI
    PARAMETER TYPE:   LITERAL
    REQUIRED:   NO
    SEQUENCE NUMBER:   5
    DESCRIPTION:   
    last subscripts from previous call
    
  • SDIEN
    PARAMETER TYPE:   LITERAL
    REQUIRED:   NO
    SEQUENCE NUMBER:   6
    DESCRIPTION:   
    pointer to SDEC RESOURCE file
    only 1 record will be returned if SDIEN is present
    
  • SDECP
    PARAMETER TYPE:   LITERAL
    REQUIRED:   NO
    SEQUENCE NUMBER:   7
    DESCRIPTION:   
    Partial name text
    
RETURN PARAMETER DESCRIPTION
Returns a global array in which each array entry contains data from
                     5, 10, 15, 20, 30, 60
 
    5. HOSPITAL_LOCATION_ID
    6. <NOT USED> LETTER_TEXT
    7. <NOT USED> NO_SHOW_LETTER
    8. <NOT USED> CLINIC_CANCELLATION_LETTER
    9. VIEW - User can VIEW 1=YES; 0=NO
   10. OVERBOOK - User can OVERBOOK  1=YES; 0=NO
   11. MODIFY_SCHEDULE - User can Modify Schedule  1=YES; 0=NO
   12. MODIFY_APPOINTMENTS User can modify appointments  1=YES; 0=NO
    the SDEC RESOURCE file for each HOSPITAL LOCATION (clinic).
   13. RESOURCETYPE - 3 pipe pieces:
           1. type H, P, or A
           2. IEN - pointer to [H] HOSPITAL LOCATION, [P] NEW PERSON,
                    or [A] SDEC ADDITIONAL RESOURCE file
           3. Name - name from the appropriate type file
   14. DATE      - Date/Time entered in external format
   15. USERIEN   - Entered By User ID pointer to NEW PERSON file 200
   16. USERNAME  - Entered By User name from NEW PERSON file
   17. DATE1     - Inactive Date/Time in external format
   18. USERIEN1  - Inactivating User ID pointer to NEW PERSON file
    1. RESOURCEID - Pointer to the SDEC RESOURCE file
   19. USERNAME1 - Inactivating User Name from NEW PERSON file
   20. DATE2     - Reactivated Date/Time in external format
   21. USERIEN2  - Reactivating User ID pointer to NEW PERSON file
   22. USERNAME2 - Reactivating User Name from NEW PERSON file
   23. CLINNAME  - Clinic Name from HOSPITAL LOCATION file 44
   24. PROVCLIN  - Boolean indicating 'this' P type resource is a
                   provider for a clinic
                   0 = not a provider
                   1 = is a provider
   25. PRIVLOC   - Boolean indicating presence of privileged users for
    2. RESOURCE_NAME - NAME from SDEC RESOURCE file
                   hospital location
   26. PRHBLOC   - Boolean indicating if location is a Prohibit Access 
                   clinic
   27. LASTSUB   - Last subscript in return data. Used in next call to
                   SDEC RESOURCE to get additional record
   28. ABBR      - Abbreviation
   29. DEFAULTVIEW - Default view
   30. TIMEZONE  - Time Zone 
    3. INACTIVE   - inactive clinic - INACTIVE is now tied to the
                    HOSPITAL LOCATION. i.e. Is this HOSPITAL LOCATION
                    inactive for this Resource - Returned values will
                    be NO YES
    4. TIMESCALE - Valid Values: