fieldSecurity


Description

Field-level security controls - Security configuration table managing field-level access permissions and visibility controls. This table defines field-specific security rules, group-based access controls, and permission levels to ensure appropriate data access, maintain field-level security, and support role-based access control for sensitive healthcare information.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
fieldID int identity 4 √ null

Field security primary key - Unique identifier for each field security rule
fieldName varchar 100 null

Field name - Name of the field being secured
subtab int 4 null

Sub-tab reference - Links to sub-tab or form section containing the field
groupID int 4 √ null

Group reference - Links to user group for access control
access int 4 √ null

Access level - Numeric access level (Read, Write, Hidden, etc.)

Indexes

Constraint Name Type Sort Column(s)
PK_fieldSecurity Primary key Asc fieldID

Relationships

Close relationships within degrees of separation