Tables [dbo].[Patient_Consent]
Patient consents
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Primary Key PK_Patient_Consent_ID: IDID[dbo].[uniqueid]9NOT NULL1 - 1Key to the Patient_Consent table.
Cluster Key CIX_Patient_Consent_PatientID: PatientIDForeign Keys FK_Patient_Consent_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientIDPatientID[dbo].[uniqueid]9NOT NULLPatient. Link to Patient_Member.ID.
Foreign Keys FK_Patient_Consent_PatientConsentDE: [dbo].[Patient_Consent_DE].PatientConsentDEPatientConsentDE[dbo].[dict_id]5NOT NULLConsent. Link to Patient_Consent_DE.ID.
Foreign Keys FK_Patient_Consent_AnswerDE: [dbo].[Answer_DE].AnswerDEAnswerDE[dbo].[dict_id]5NOT NULLAnswer. Link to Answer_DE.ID.
CareTeamMemberID[dbo].[uniqueid]9NOT NULLCare Team Member Identifier.
Check Constraints CKCareTeamMemberType : ([CareTeamMemberType]='P' OR [CareTeamMemberType]='R' OR [CareTeamMemberType]='')CareTeamMemberTypechar(1)1NOT NULLCare team member type. Possible values are P, R or ''
Foreign Keys FK_Patient_Consent_DoumentID: [dbo].[Document].DocumentIDDocumentID[dbo].[uniqueid]9NULL allowedDocument. Link to Document.DocumentID.
EffectiveDTdate3NULL allowedEffective date
ExpirationDTdate3NULL allowedExpiration date
Commentsvarchar(8000)8000NOT NULLComments
IsInactiveFLAG[dbo].[BOOL]1NOT NULL('N')True if patient consent is inactive
IsEnterInErrorFLAG[dbo].[BOOL]1NOT NULL('N')True if record is marked as enter in error
CreatedByID[dbo].[uniqueid]9NOT NULLUser ID who created the patient consent. Link to IDX_User.ID.
CreateDTTMdatetime8NOT NULLDate and time when patient consent was created.
LastUpdateDTTMdatetime8NOT NULLDate and time when patient consent was last modified
ModifiedByID[dbo].[uniqueid]9NOT NULLUserID who modified the patient consent. Link to IDX_User.ID.