Tables [dbo].[Services_Transaction_Request]
Request data for PDMP, PPT+, eCoupon
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Cluster Primary Key PK_Services_Transaction_Request: IDID[dbo].[uniqueid]9NOT NULL1 - 1Key to the Services_Transaction_Request table
Indexes NIX_Services_Transaction_Request_PatientID_RequestStatus_WithIncludesPatientID[dbo].[uniqueid]9NOT NULLPatient ID associated to the service request. Link to Person.ID
EncounterID[dbo].[uniqueid]9NULL allowedEncounter ID associated to the service request. Link to Encounter.ID
ProviderID[dbo].[uniqueid]9NULL allowedProvider ID associated to the service request. Link to Provider.ID
Foreign Keys FK_Services_Transaction_Request_UserID: [dbo].[IDX_User].UserIDUserID[dbo].[uniqueid]9NOT NULLUser ID who created the service request. Link to IDX_User.ID
Indexes NIX_Services_Transaction_Request_CreatedDTTM, NIX_Services_Transaction_Request_PatientID_RequestStatus_WithIncludes(2)CreatedDTTMdatetime8NOT NULL(getdate())Data and time when the data was inserted / added.
Foreign Keys FK_Services_Transaction_Request_ServiceTransactionTypeDE: [dbo].[Service_Transaction_Type_DE].ServiceTransactionTypeDEServiceTransactionTypeDE[dbo].[dict_id]5NOT NULLTransaction Type. Link to Service_Transaction_Type_DE.ID
Indexes NIX_Services_Transaction_Request_ExternalIDExternalIDvarchar(255)255NULL allowedExternal message ID
ItemCurrentID[dbo].[uniqueid]9NOT NULLID of the clinical item associated to the request
ItemTypevarchar(2)2NOT NULLClinical item type
ItemDE[dbo].[dict_id]5NOT NULLDictionary ID of clinical item associated to the request
RequestContentvarchar(max)maxNOT NULLRequest message content
RequestEndpointvarchar(2048)2048NULL allowedRequest message endpoint URL
WebServervarchar(2048)2048NULL allowedRequest message web server URL
Indexes NIX_Services_Transaction_Request_PatientID_RequestStatus_WithIncludesRequestSubmitDTTMdatetime8NULL allowedDate/Time the request was submitted
Indexes NIX_Services_Transaction_Request_PatientID_RequestStatus_WithIncludesRequestStatusvarchar(50)50NOT NULLStatus descripton of the request
ErrorDescriptionvarchar(max)maxNULL allowedError Description text
Indexes NIX_Services_Transaction_Request_LastUpdatedDTTM, NIX_Services_Transaction_Request_PatientID_RequestStatus_WithIncludes(2)LastUpdatedDTTMdatetime8NOT NULL(getdate())Date/Time the request was last updated
RequestStatusCodeint4NULL allowedSpecific 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).