Tables [dbo].[Patient_Correspondence]
Patient correspondence data
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Cluster Primary Key PK_Patient_Correspondence: IDIndexes TWstat_Patient_Correspondence_BackwardLinkID_ID, TWstat_Patient_Correspondence_CreateDTTM_ID, TWstat_Patient_Correspondence_ForwardLinkID_ID, TWstat_Patient_Correspondence_LastUpdateDTTM_ID, TWstat_Patient_Correspondence_PatientRequestAppGroup_ID, TWstat_Patient_Correspondence_PatientRequestURLhash_ID, TWstat_Patient_Correspondence_PracticeInitiatedFLAG_ID, TWstat_Patient_Correspondence_RequestType_ID, TWstat_Patient_Correspondence_Status_ID, TWstat_Patient_Correspondence_Subject_ID, TWstat_Patient_Correspondence_UpdatedByUserID_ID(11)ID[dbo].[uniqueid]9NOT NULL1 - 1Key to Patient_Correspondence table
Indexes xPatientIDForeign Keys FK_Patient_Correspondence_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientIDPatientID[dbo].[uniqueid]9NOT NULLPatient. Link to Patient_Member.ID
Indexes xRemoteRequestIDPatientRequestXID[dbo].[uniqueid]9NOT NULLRemote system's request ID
Indexes xRemoteRequestID, TWstat_Patient_Correspondence_PatientRequestURLhash_ID(2)PatientRequestURLhashint4NULL allowedLong URL, hashed into an INT
Indexes xRemoteRequestID, TWstat_Patient_Correspondence_PatientRequestAppGroup_ID(2)PatientRequestAppGroupvarchar(32)32NULL allowedAn ODBC name for a server+database
Indexes TWstat_Patient_Correspondence_CreateDTTM_IDCreateDTTMdatetime8NULL allowedDate & time of the entry
Indexes TWstat_Patient_Correspondence_LastUpdateDTTM_IDLastUpdateDTTMdatetime8NULL allowedDate & time when the entry was updated
Indexes TWstat_Patient_Correspondence_UpdatedByUserID_IDUpdatedByUserID[dbo].[uniqueid]9NULL allowed User who created/updated the entry. Link to IDX_User.ID.
Indexes TWstat_Patient_Correspondence_RequestType_IDRequestType[dbo].[dict_id]5NULL allowedRequest type. Link to IDX_Task_Action_DE.ID
Indexes TWstat_Patient_Correspondence_Status_IDStatuschar(1)1NULL allowedP = Pending, C = Complete
Indexes TWstat_Patient_Correspondence_Subject_IDSubjectvarchar(200)200NULL allowedSubject of Patient correspondence
XMLstringvarchar(max)maxNULL allowedThe original request's XML
Indexes TWstat_Patient_Correspondence_BackwardLinkID_IDBackwardLinkID[dbo].[uniqueid]9NOT NULL((-1))backward link to linked request
Indexes TWstat_Patient_Correspondence_ForwardLinkID_IDForwardLinkID[dbo].[uniqueid]9NOT NULL((-1))ForwardLinkID = -1 for a new request
ForwardLinkID = ID when a request is updated
Indexes Patient_Correspondence_Orig_IndexOriginatingLinkID[dbo].[uniqueid]9NOT NULL((-1))OriginatingLinkID = -1 for a new request
OriginatingLinkID = ID when a request is updated
Indexes TWstat_Patient_Correspondence_PracticeInitiatedFLAG_IDCheck Constraints CK_Patient_Correspondence_PracticeInitiatedFLAG_Yes_Or_No : ([PracticeInitiatedFLAG]='N' OR [PracticeInitiatedFLAG]='Y')PracticeInitiatedFLAG[dbo].[BOOL]1NULL allowedDid the practice initiate this Y/N?