Tables [dbo].[Patient_SecGroup]
Table containing the Security / Access Group associations for Patients
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Cluster Primary Key CIX_Patient_SecGroup_PatientID_OrgID: PatientID\OrgIDIndexes NIX_Patient_SecGroup_AccessGroupID_OrgID, NIX_Patient_SecGroup_OrgID_AccessGroupID, TWstat_Patient_SecGroup_AccessGroupID_OrgID_PatientID, TWstat_Patient_SecGroup_PatientID_OrgID(4)OrgID[dbo].[dict_id]5NOT NULLOrganization. Link to Organization.ID
Cluster Primary Key CIX_Patient_SecGroup_PatientID_OrgID: PatientID\OrgIDIndexes TWstat_Patient_SecGroup_AccessGroupID_OrgID_PatientID, TWstat_Patient_SecGroup_PatientID_OrgID(2)Foreign Keys FK_Patient_SecGroup_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientIDPatientID[dbo].[uniqueid]9NOT NULLPatient. Link to Person.ID
Indexes NIX_Patient_SecGroup_AccessGroupID_OrgID, NIX_Patient_SecGroup_OrgID_AccessGroupID, TWstat_Patient_SecGroup_AccessGroupID_OrgID_PatientID(3)Foreign Keys FK_Patient_SecGroup_AccessGroup: [dbo].[Access_Group].AccessGroupIDAccessGroupID[dbo].[dict_id]5NOT NULLAccess Group ID, Link to Access_Group.ID
DTTMInsertdatetime8NOT NULL(getdate())Date this Access Group association was inserted
DTTMUpdatedatetime8NOT NULL(getdate())Date this Access Group association was Last Updated