Patient ID associated to the service request. Link to Person.ID
EncounterID
[dbo].[uniqueid]
9
NULL allowed
Encounter ID associated to the service request. Link to Encounter.ID
ProviderID
[dbo].[uniqueid]
9
NULL allowed
Provider ID associated to the service request. Link to Provider.ID
UserID
[dbo].[uniqueid]
9
NOT NULL
User ID who created the service request. Link to IDX_User.ID
(2)
CreatedDTTM
datetime
8
NOT NULL
(getdate())
Data and time when the data was inserted / added.
ServiceTransactionTypeDE
[dbo].[dict_id]
5
NOT NULL
Transaction Type. Link to Service_Transaction_Type_DE.ID
ExternalID
varchar(255)
255
NULL allowed
External message ID
ItemCurrentID
[dbo].[uniqueid]
9
NOT NULL
ID of the clinical item associated to the request
ItemType
varchar(2)
2
NOT NULL
Clinical item type
ItemDE
[dbo].[dict_id]
5
NOT NULL
Dictionary ID of clinical item associated to the request
RequestContent
varchar(max)
max
NOT NULL
Request message content
RequestEndpoint
varchar(2048)
2048
NULL allowed
Request message endpoint URL
WebServer
varchar(2048)
2048
NULL allowed
Request message web server URL
RequestSubmitDTTM
datetime
8
NULL allowed
Date/Time the request was submitted
RequestStatus
varchar(50)
50
NOT NULL
Status descripton of the request
ErrorDescription
varchar(max)
max
NULL allowed
Error Description text
(2)
LastUpdatedDTTM
datetime
8
NOT NULL
(getdate())
Date/Time the request was last updated
RequestStatusCode
int
4
NULL allowed
Specific values based on the request type. For example, in PDMP when we are building the PDMP request we potentially can get status codes from the stored proc that retrieves the data - 901, 902, 903… Or we get HTTP status code from the FHIR bundler we are using to build the request - 200, 400, 403 (http status codes).