SDEC REQGET (3571)    REMOTE PROCEDURE (8994)

Name Value
NAME SDEC REQGET
TAG REQGET
ROUTINE SDEC
RETURN VALUE TYPE GLOBAL ARRAY
AVAILABILITY RESTRICTED
INACTIVE ACTIVE
WORD WRAP ON FALSE
DESCRIPTION
GET entries with an ACTIVITY of RECEIVED, but do have have an ACTIVITY of 
SCHEDULED from the REQUEST/CONSULTATING file 123
INPUT PARAMETER
  • SDBEG
    PARAMETER TYPE:   LITERAL
    REQUIRED:   NO
    SEQUENCE NUMBER:   1
    DESCRIPTION:   
    Begin date in external format
    Default to all dates
    
  • SDECEND
    PARAMETER TYPE:   LITERAL
    REQUIRED:   NO
    SEQUENCE NUMBER:   2
    DESCRIPTION:   
    End date in external format.
    default to all dates
    
  • MAXREC
    PARAMETER TYPE:   LITERAL
    REQUIRED:   NO
    SEQUENCE NUMBER:   3
    DESCRIPTION:   
    Maximum number of records to return
    
  • LASTSUB
    PARAMETER TYPE:   LITERAL
    REQUIRED:   NO
    SEQUENCE NUMBER:   4
    DESCRIPTION:   
    Last subscripts from previous call;
    Used to collect the data in multiple background calls.
    
RETURN PARAMETER DESCRIPTION
Global Array in which each array entry contains
   7. CLINNAME - NAME from HOSPITAL LOCATION file 
  47. PETHN - Patient Ethnicity names separated by pipe | 
  48. PRHBLOC - Boolean indicating if location is a 
      Prohibit Access clinic 
  49. EARLIEST - EARLIEST DATE in Fileman format 
  50. BADADD = BAD ADDRESS INDICATOR (.121) 
     1=UNDELIVERABLE 
     2=HOMELESS 
     3=OTHER 
     4=ADDRESS NOT FOUND 
  51. OPHONE = Office phone (.132) 
   8. DATE OF REQUEST external format 
  52. NOK - Primary Next of Kin (.211) 
  53. KNAME - Primary Next of Kin name 
  54. KREL - Primary Next of Kin Relationship to Patient (.212) 
  55. KPHONE - Primary Next of Kin Phone (.219) 
  56. KSTREET - Primary Next of Kin Street Address [Line 1] 
                       (.213) 
  57. KSTREET2 - Primary Next of Kin Street Address [Line 2] 
                        (.214) 
  58. KSTREET3 - Primary Next of Kin Street Address [Line 3] 
                        (.215) 
   9. PRIO - URGENCY NAME from PROTOCOL file OR 'Earliest Date' 
  59. KCITY - Primary Next of Kin City (.216) 
  60. KSTATE - Primary Next of Kin State (.217) 
  61. KZIP - Primary Next of Kin Zip (.218) 
  62. NOK2 - Secondary Next of Kin (.2191) 
  63. K2NAME - Secondary Next of Kin name (.2191) 
  64. K2REL - Secondary Next of Kin Relationship to Patient 
                     (.2192) 
  65. K2PHONE - Secondary Next of Kin Phone (.2199) 
  66. K2STREET - Secondary Next of Kin Street Address [Line 1] 
                        (.2193) 
             in external format 
  67. K2STREET2 - Secondary Next of Kin Street Address [Line 2] 
                         (.2194) 
  68. K2STREET3 - Secondary Next of Kin Street Address [Line 3] 
                         (.2195) 
  69. K2CITY - Secondary Next of Kin City (.2196) 
  70. K2STATE - Secondary Next of Kin State (.2197) 
  71. K2ZIP - Secondary Next of Kin Zip (.2198) 
  72. PCOUNTY - Patient County (.117) 
  73. PMARITAL - Patient Marital Status 
  74. PRELIGION - Patient Religious Preference 
  10. USERIEN - ATTENTION - Pointer to NEW PERSON file 
  75. PTACTIVE - Patient Temporary Address Active? (.12105) 
  76. PTADDRESS1 - Patient Temporary Address Line 1 (.1211) 
  77. PTADDRESS2 - Patient Temporary Address Line 2 (.1212) 
  78. PTADDRESS3 - Patient Temporary Address Line 3 (.1213) 
  79. PTCITY - Patient Temporary City (.1214) 
  80. PTSTATE - Patient Temporary State (.1215) 
  81. PTZIP - Patient Temporary Zip (.1216) 
  82. PTZIP+4 - Patient Temporary Zip+4 (.12112) 
  83. PTCOUNTRY - Patient Temporary Country (.1223) 
  84. PTCOUNTY - Patient Temporary County (.12111) 
  11. USERNAME - ATTENTION - NAME from NEW PERSON file 
  85. PTPHONE - Patient Temporary Phone (.1219) 
  86. PTSTART - Patient Temporary Address Start Date (.1217) 
  87. PTEND - Patient Temporary Address End Date (.1218) 
  88. PCELL - Patient Cell Phone (.134) 
  89. PPAGER - Patient Pager Number (.135) 
  90. PEMAIL - Patient Email Address (.133) 
  91. PF_FFF - Patient FUGITIVE FELON FLAG 1=YES 
  92. PF_VCD - Patient VETERAN CATASTROPHICALLY DISABLED? 
                       Y=YES N=NO 
  93. PFNATIONAL - Patient national Flags 
  12. PROVIEN - SENDING PROVIDER IEN - Pointer to NEW PERSON file 
                         (PRF ASSIGNMENT/PRF NATIONAL FLAG) separated by 
| 
        Each | piece contains the following ;; pieces: 
        1. PRFAID - PRF Assignment ID pointer to PRF ASSIGNMENT file 
(#26.13)
        2. PRFSTAT - PRF Assignment Status 0=INACTIVE 1=ACTIVE 
        3. PRFNID - PRF National Flag ID pointer to PRF NATIONAL FLAG 
file 
                    (#26.15) 
        4. PRFNNAME - PRF National Flag name 
  13. PROVNAME - SENDING PROVIDER NAME - NAME from NEW PERSON file 
        5. PRFNSTAT - PRF National Flag status 0=INACTIVE 1=ACTIVE 
 94. PFLOCAL - Patient Local Flags 
                      (PRF ASSIGNMENT/PRF Local FLAG) separated by | 
        Each | piece contains the following ;; pieces: 
        1. PRFAID - PRF Assignment ID pointer to PRF ASSIGNMENT file 
(#26.13)
        2. PRFSTAT - PRF Assignment Status 0=INACTIVE 1=ACTIVE 
        3. PRFLID - PRF Local Flag ID pointer to PRF LOCAL FLAG file 
(#26.11)
        4. PRFLNAME - PRF Local Flag name 
  14. REQUEST TYPE - valid values are: 
        5. PRFLSTAT - PRF Local Flag status 0=INACTIVE 1=ACTIVE 
 95. SUBGRP - value from the ENROLLMENT SUBGROUP field of the
              PATIENT ENROLLMENT file (#27.11) 
              Valid values are a b c d e g 
 96. CAT8G  - Category 8g flag - True if PriGRP ='Group 8' AND SUBGRP-'g'
 97. SIMILAR = Similar Patients 
      MESSSAGE | Patients 
       Patients separated by ;; 
        Each ;; piece contains the following ~ pieces 
        DFN ~ NAME ~ DOB ~ SSN
                     CONSULT 
 98. PHONE CALL ATTEMPTS MADE
 99. DATE OF LAST LETTER ATTEMPT SENT
100. COVID 19 PRIORITY 
101. EMAIL CONTACT ATTEMPTS MADE
102. TEXT CONTACT ATTEMPT MADE
103. SECURE MESSAGES CONTACT ATTEMPTS MADE
   REQUEST/CONSULTATION data from the REQUEST/CONSULTATION file 123
                     PROCEDURE 
  15. SERVICE RENDERED AS IN OR OUT - valid values are: 
             inpatient 
             outpatient 
  16. COMM - [NOT USED] REASON FOR REQUEST - text converted from WP and 
may
                        contain $C(13,10) carriage return/line feed
  17. REQUEST PROCESSING ACTIVITY SEPARATED BY PIPE | 
      Each pipe piece contains the following ";;" pieces: 
       1. REQUEST PROCESSING ACTIVITY pointer to multiple entry 
   Data is separated by ^:
       2. DATE/TIME OF ACTION ENTRY - external format 
       3. ACTIVITY - text 
  18. HRN 
  19. DOB 
  20. SSN (last 4)
  21. GENDER 
  22. INSTIEN 
  23. INSTNAME 
  24. PRIGRP - ENROLLMENT PRIORITY text from PATIENT ENROLLMENT file 
               Valid Values: 
   1. IEN - Pointer to REQUEST/CONSULTATION file 123 
                  GROUP 1 
                  GROUP 2 
                  GROUP 3 
                  GROUP 4 
                  GROUP 5 
                  GROUP 6 
                  GROUP 7 
                  GROUP 8 
  25. ELIGIEN - Pointer to MAS ELIGIBILITY CODE file 8.1 
  26. ELIGNAME - NAME from MAS ELIGIBILITY CODE file 
   2. File entry Date external form 
  27. SVCCONN - SERVICE CONNECTED field from PATIENT ENROLLMENT file 
                Valid values: 
                 YES 
                 NO 
  28. SVCCONNP - SERVICE CONNECTED PERCENTAGE field from 
                 PATIENT ENROLLMENT file 
                 Numeric between 0-100 
  29. TYPEIEN - Pointer to TYPE OF PATIENT file 391 
  30. TYPENAME - NAME from TYPE OF PATIENT file 391 
  31. PADDRES1 - Patient Address line 1 
   3. Patient IEN - Pointer to PATIENT file 
  32. PADDRES2 - Patient Address line 2 
  33. PADDRES3 - Patient Address line 3 
  34. PCITY - Patient City 
  35. PSTATE - Patient state name 
  36. PCOUNTRY - Patient country pointer to COUNTRY CODE file 
  37. PZIP4 - Patient Zip+4 
  38. GAF - <text> | <GAF score> | <GAF date> | <diagnosis by IEN> 
           | <diagnosis by name> 
  39. SENSITIVE - Sensitive Record Access data 
                 separated by pipe |: 
   4. Patient Name NAME from PATIENT file 
   1. return code: 
        -1 -RPC/API failed 
            Required variable not defined 
         0 -No display/action required 
            Not accessing own, employee, or sensitive record 
         1 -Display warning message 
            Sensitive and DG SENSITIVITY key holder 
            or Employee and DG SECURITY OFFICER key holder 
        2 -Display warning message/require OK to continue 
            Sensitive and not a DG SENSITIVITY key holder 
   5. To Service - SERVICE NAME text from REQUEST SERVICES file 123.5
            Employee and not a DG SECURITY OFFICER key holder 
         3 -Access to record denied 
            Accessing own record 
         4 -Access to Patient (#2) file records denied 
            SSN not defined 
    2. display text/message 
    3. display text/message 
   4. display text/message 
  40. LASTSUB - last subscripts of data in the return. 
                Will only be in the last record of the return. 
   6. CLINIEN - pointer to HOSPITAL LOCATION file 
                Pass this as LASTSUB in the next call to continue 
                collecting data. 
  41. STOP    - list of pointers by pipe to CLINIC STOP file 40.7 
  42. PTPHONE - Patient Phone number - Free-text 4-20 characters 
  43. URGENCY - pointer to PROTOCOL file 101 
          ID from the URGENCY field 5 in REQUEST/CONSULTATION file 123 
  44. PRACE - Patient Race pointer to RACE file 10 | separates entries 
  45. PRACEN - Patient Race name from RACE file | separates entries 
  46. PETH - Patient Ethnicity list separated by pipe | 
             Pointer to ETHNICITY file 10.2