Key | Name | Data Type | Max Length (Bytes) | Nullability | Identity | Default | Description |
---|
 | ID | [dbo].[uniqueid] | 9 | NOT NULL | 1 - 1 | | Key to the Patient_Consent table. |
 ![Foreign Keys FK_Patient_Consent_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientID Foreign Keys FK_Patient_Consent_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientID](../../../../Images/fk.png) | PatientID | [dbo].[uniqueid] | 9 | NOT NULL | | | Patient. Link to Patient_Member.ID. |
![Foreign Keys FK_Patient_Consent_PatientConsentDE: [dbo].[Patient_Consent_DE].PatientConsentDE Foreign Keys FK_Patient_Consent_PatientConsentDE: [dbo].[Patient_Consent_DE].PatientConsentDE](../../../../Images/fk.png) | PatientConsentDE | [dbo].[dict_id] | 5 | NOT NULL | | | Consent. Link to Patient_Consent_DE.ID. |
![Foreign Keys FK_Patient_Consent_AnswerDE: [dbo].[Answer_DE].AnswerDE Foreign Keys FK_Patient_Consent_AnswerDE: [dbo].[Answer_DE].AnswerDE](../../../../Images/fk.png) | AnswerDE | [dbo].[dict_id] | 5 | NOT NULL | | | Answer. Link to Answer_DE.ID. |
| CareTeamMemberID | [dbo].[uniqueid] | 9 | NOT NULL | | | Care Team Member Identifier. |
![Check Constraints CKCareTeamMemberType : ([CareTeamMemberType]='P' OR [CareTeamMemberType]='R' OR [CareTeamMemberType]='') Check Constraints CKCareTeamMemberType : ([CareTeamMemberType]='P' OR [CareTeamMemberType]='R' OR [CareTeamMemberType]='')](../../../../Images/c-constraint.png) | CareTeamMemberType | char(1) | 1 | NOT NULL | | | Care team member type. Possible values are P, R or '' |
![Foreign Keys FK_Patient_Consent_DoumentID: [dbo].[Document].DocumentID Foreign Keys FK_Patient_Consent_DoumentID: [dbo].[Document].DocumentID](../../../../Images/fk.png) | DocumentID | [dbo].[uniqueid] | 9 | NULL allowed | | | Document. Link to Document.DocumentID. |
| EffectiveDT | date | 3 | NULL allowed | | | Effective date |
| ExpirationDT | date | 3 | NULL allowed | | | Expiration date |
| Comments | varchar(8000) | 8000 | NOT NULL | | | Comments |
| IsInactiveFLAG | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | True if patient consent is inactive |
| IsEnterInErrorFLAG | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | True if record is marked as enter in error |
| CreatedByID | [dbo].[uniqueid] | 9 | NOT NULL | | | User ID who created the patient consent. Link to IDX_User.ID. |
| CreateDTTM | datetime | 8 | NOT NULL | | | Date and time when patient consent was created. |
| LastUpdateDTTM | datetime | 8 | NOT NULL | | | Date and time when patient consent was last modified |
| ModifiedByID | [dbo].[uniqueid] | 9 | NOT NULL | | | UserID who modified the patient consent. Link to IDX_User.ID. |