Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.PatientAPIRegistrationStatus
Touchworks 25.2
[dbo].[PatientAPIRegistrationStatus]
MS_Description
FHIR API Registration Status of Patients
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Identity
Description
ID
[dbo].[uniqueid]
9
NOT NULL
1 - 1
Key to the PatientAPIRegistrationStatus table
PatientID
[dbo].[uniqueid]
9
NOT NULL
Patient. Link to Patient_Member.ID.
APIRegistrationStatusDE
[dbo].[dict_id]
5
NOT NULL
Status. Link to API_RegistrationStatus_DE.ID.
InviteProcessingstatusID
[dbo].[dict_id]
5
NOT NULL
FHIR API Registration status received from API
InviteRequestID
varchar(36)
36
NULL allowed
Unique requestID received from FHIR API.
ProcessStatus
char(1)
1
NOT NULL
Transaction 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]
CreatedDTTM
datetime
8
NOT NULL
Created date & time when record added
LastUpdatedDTTM
datetime
8
NULL allowed
FHIR API Registration Status modified date & time