Tables [dbo].[PatientAPIRegistrationStatus]
FHIR API Registration Status of Patients
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDescription
Cluster Primary Key PK_PatientAPIRegistrationStatus_ID: IDID[dbo].[uniqueid]9NOT NULL1 - 1Key to the PatientAPIRegistrationStatus table
Indexes NIX_PatientAPIRegistrationStatus_PatientIDForeign Keys FK_PatientAPIRegistrationStatus_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientIDPatientID[dbo].[uniqueid]9NOT NULLPatient. Link to Patient_Member.ID.
Foreign Keys FK_PatientAPIRegistrationStatus_APIRegistrationStatusDE: [dbo].[API_RegistrationStatus_DE].APIRegistrationStatusDEAPIRegistrationStatusDE[dbo].[dict_id]5NOT NULLStatus. Link to API_RegistrationStatus_DE.ID.
InviteProcessingstatusID[dbo].[dict_id]5NOT NULLFHIR API Registration status received from API
InviteRequestIDvarchar(36)36NULL allowedUnique requestID received from FHIR API.
ProcessStatuschar(1)1NOT NULLTransaction status:
N - New [ Waiting for processing]
P - In-Progress [ Getting Status from FHIR API Call
C:- Completed [Registration Status updated in Touchworks from FHIR API]
Indexes NIX_PatientAPIRegistrationStatus_CreatedDTTMCreatedDTTMdatetime8NOT NULLCreated date & time when record added
LastUpdatedDTTMdatetime8NULL allowedFHIR API Registration Status modified date & time