Tables [dbo].[Access_Group]
This is a list of all the security classifications in the application. A security application is just a name that you associate multiple security codes with. For example a classification called "Nurse" may have security coes for "Chart-Edit", "Chart-View", "Chart-Print" and "Can Prescribe". Users are allowed to create there own security classifications.
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Primary Key PK_Access_Group_ID: IDIDnumeric(8,0)5NOT NULL1 - 1Key to the Access_Group table.
Cluster Key XAK2Access_Group: EntryCode\IntOrganizationIDIndexes TWstat_Access_Group_AccessTypes_EntryCode_IntOrganizationID, TWstat_Access_Group_EntryMnemonic_EntryCode_IntOrganizationID, TWstat_Access_Group_IsCurrentFlag_EntryCode_IntOrganizationID(3)EntryCode[dbo].[code]10NOT NULLUnique alphanumeric code.  Brief but cryptic.
Indexes XAK1Access_GroupEntryName[dbo].[name]255NOT NULLUnique alphanumeric "friendly" display name
Indexes TWstat_Access_Group_EntryMnemonic_EntryCode_IntOrganizationIDEntryMnemonic[dbo].[code]10NOT NULLEntrymnemonic
Check Constraints CK_Access_Group_IsInactiveFlag_Yes_Or_No : ([IsInactiveFlag]='N' OR [IsInactiveFlag]='Y')IsInactiveFlag[dbo].[BOOL]1NOT NULLY=row is not active; N=row is active.  (Rows are inactivated rather than deleted for history)
Check Constraints CK_Access_Group_IsEnforcedFlag_Yes_Or_No : ([IsEnforcedFlag]='N' OR [IsEnforcedFlag]='Y')IsEnforcedFlag[dbo].[BOOL]1NOT NULLY=row is readonly;  N=row is modifiable
Indexes TWstat_Access_Group_IsCurrentFlag_EntryCode_IntOrganizationIDCheck Constraints CK_Access_Group_IsCurrentFlag_Yes_Or_No : ([IsCurrentFlag]='N' OR [IsCurrentFlag]='Y')IsCurrentFlag[dbo].[BOOL]1NOT NULLUsually 'Y' but occasionally used to subordinate rows.
EffectiveDTdatetime8NOT NULLTime of last modification  (not "when this row goes into effect")
Cluster Key XAK2Access_Group: EntryCode\IntOrganizationIDIndexes XAK1Access_Group, TWstat_Access_Group_AccessTypes_EntryCode_IntOrganizationID, TWstat_Access_Group_EntryMnemonic_EntryCode_IntOrganizationID, TWstat_Access_Group_IsCurrentFlag_EntryCode_IntOrganizationID(4)IntOrganizationID[dbo].[dict_id]5NOT NULLnot used
Indexes TWstat_Access_Group_AccessTypes_EntryCode_IntOrganizationIDAccessTypesnumeric(4,0)5NULL allowed(0)Access type. A numerical code. For example 9 will mean the "Patient Security".
KeepPrivatebit1NOT NULL((0))Hide the patient if the user does not have access to this access group?