Key | Name | Data Type | Max Length (Bytes) | Nullability | Identity | Default | Description |
---|
 | ID | numeric(8,0) | 5 | NOT NULL | 1 - 1 | | Key to the Access_Group table. |
 (3) | EntryCode | [dbo].[code] | 10 | NOT NULL | | | Unique alphanumeric code. Brief but cryptic. |
 | EntryName | [dbo].[name] | 255 | NOT NULL | | | Unique alphanumeric "friendly" display name |
 | EntryMnemonic | [dbo].[code] | 10 | NOT NULL | | | Entrymnemonic |
![Check Constraints CK_Access_Group_IsInactiveFlag_Yes_Or_No : ([IsInactiveFlag]='N' OR [IsInactiveFlag]='Y') Check Constraints CK_Access_Group_IsInactiveFlag_Yes_Or_No : ([IsInactiveFlag]='N' OR [IsInactiveFlag]='Y')](../../../../Images/c-constraint.png) | IsInactiveFlag | [dbo].[BOOL] | 1 | NOT NULL | | | Y=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') Check Constraints CK_Access_Group_IsEnforcedFlag_Yes_Or_No : ([IsEnforcedFlag]='N' OR [IsEnforcedFlag]='Y')](../../../../Images/c-constraint.png) | IsEnforcedFlag | [dbo].[BOOL] | 1 | NOT NULL | | | Y=row is readonly; N=row is modifiable |
 ![Check Constraints CK_Access_Group_IsCurrentFlag_Yes_Or_No : ([IsCurrentFlag]='N' OR [IsCurrentFlag]='Y') Check Constraints CK_Access_Group_IsCurrentFlag_Yes_Or_No : ([IsCurrentFlag]='N' OR [IsCurrentFlag]='Y')](../../../../Images/c-constraint.png) | IsCurrentFlag | [dbo].[BOOL] | 1 | NOT NULL | | | Usually 'Y' but occasionally used to subordinate rows. |
| EffectiveDT | datetime | 8 | NOT NULL | | | Time of last modification (not "when this row goes into effect") |
 (4) | IntOrganizationID | [dbo].[dict_id] | 5 | NOT NULL | | | not used |
 | AccessTypes | numeric(4,0) | 5 | NULL allowed | | (0) | Access type. A numerical code. For example 9 will mean the "Patient Security". |
| KeepPrivate | bit | 1 | NOT NULL | | ((0)) | Hide the patient if the user does not have access to this access group? |