SDEC REQGET

TITLEVALUE
NAMESDEC REQGET
DESCRIPTIONGET entries with an ACTIVITY of RECEIVED, but do have have an ACTIVITY of
SCHEDULED from the REQUEST/CONSULTATING file 123
TAGREQGET
ROUTINESDEC
INPUT PARAMETERSSEQUENCE NUMBER1
INPUT PARAMETERSDBEG
DESCRIPTIONBegin date in external format
Default to all dates
PARAMETER TYPELITERAL
REQUIREDNO
MAXIMUM DATA LENGTH
INPUT PARAMETERSSEQUENCE NUMBER2
INPUT PARAMETERSDECEND
DESCRIPTIONEnd date in external format.
default to all dates
PARAMETER TYPELITERAL
REQUIREDNO
MAXIMUM DATA LENGTH
INPUT PARAMETERSSEQUENCE NUMBER3
INPUT PARAMETERMAXREC
DESCRIPTIONMaximum number of records to return
PARAMETER TYPELITERAL
REQUIREDNO
MAXIMUM DATA LENGTH
INPUT PARAMETERSSEQUENCE NUMBER4
INPUT PARAMETERLASTSUB
DESCRIPTIONLast subscripts from previous call;
Used to collect the data in multiple background calls.
PARAMETER TYPELITERAL
REQUIREDNO
MAXIMUM DATA LENGTH
RETURN VALUE TYPEGLOBAL ARRAY
RETURN PARAMETER DESCRIPTIONGlobal Array in which each array entry contains
REQUEST/CONSULTATION data from the REQUEST/CONSULTATION file 123
Data is separated by ^:
1. IEN - Pointer to REQUEST/CONSULTATION file 123
2. File entry Date external form
3. Patient IEN - Pointer to PATIENT file
4. Patient Name NAME from PATIENT file
5. To Service - SERVICE NAME text from REQUEST SERVICES file 123.5
6. CLINIEN - pointer to HOSPITAL LOCATION file
7. CLINNAME - NAME from HOSPITAL LOCATION file
8. DATE OF REQUEST external format
9. PRIO - URGENCY NAME from PROTOCOL file OR 'Earliest Date'
in external format
10. USERIEN - ATTENTION - Pointer to NEW PERSON file
11. USERNAME - ATTENTION - NAME from NEW PERSON file
12. PROVIEN - SENDING PROVIDER IEN - Pointer to NEW PERSON file
13. PROVNAME - SENDING PROVIDER NAME - NAME from NEW PERSON file
14. REQUEST TYPE - valid values are:
CONSULT
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
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:
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
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
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 - | | |
|
39. SENSITIVE - Sensitive Record Access data
separated by pipe |:
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
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.
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
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)
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)
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)
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
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)
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
(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
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
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
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
AVAILABILITYRESTRICTED
INACTIVEACTIVE
CLIENT MANAGER
WORD WRAP ONFALSE
VERSION
SUPPRESS RDV USER SETUP
APP PROXY ALLOWED