Tables [dbo].[Patient_Community_Audit]
Audit record of changes ot the Patient_Community table
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Cluster Primary Key PK_Patient_Community_Audit_ID: IDID[dbo].[uniqueid]9NOT NULL1 - 1Key to the Pateint_Community_Audit table
Indexes NIX_Patient_Community_Audit_PatientIDForeign Keys FK_Patient_Community_Audit_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientIDPatientID[dbo].[uniqueid]9NOT NULL((0))Patient Idetifier - Link to Person.ID
Foreign Keys FK_Patient_Community_Audit_CommStatusDE: [dbo].[Community_Status_DE].CommStatusDECommStatusDE[dbo].[dict_id]5NOT NULL((0))Community Status - Link to Community_Status_DE.ID
OrgIDnumeric(18,0)9NOT NULL((0))Organziation Identifier - link to Organization.ID
WhoDidItID[dbo].[uniqueid]9NOT NULL((0))UserID of editting user - Link to IDX_User.ID
LastUpdateDTTMdatetime8NULL allowedDatetime of the change event
Check Constraints CK_Patient_Community_Audit_CommStatusFLAG_Yes_Or_No : ([CommStatusFLAG]='N' OR [CommStatusFLAG]='Y')CommStatusFLAG[dbo].[BOOL]1NOT NULL('N')Comm Status Change FLAG (Y/N)?
Foreign Keys FK_Patient_Community_Audit_CommunityID: [dbo].[CED_Endpoints].CommunityIDCommunityID[dbo].[uniqueid]9NOT NULLCommunity Identifier - Link to CED_Endpoints.ID