FormActionSecurity


Description

Form action security controls - Security configuration table managing access permissions for form actions and operations. This table defines action-level security, team-based access controls, and visibility options to ensure appropriate form permissions, maintain data security, and support role-based access control for healthcare documentation workflows.

Columns

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

Security rule primary key - Unique identifier for each form action security rule
ActionName varchar 255 null

Action name - Descriptive name of the form action being secured
ActionCode varchar 255 null

Action code - System code identifying the specific form action
VisibilityOption varchar 20 null

Visibility setting - Controls visibility of the action (Show, Hide, Conditional)
TeamsList varchar 2147483647 √ null

Authorized teams - Comma-separated list of teams authorized for this action
UpdatedDate datetime 16,3 √ null

Last update date - Date when this security rule was last modified
UpdatedBy int 4 √ null

Updated by user - UserID of the person who last updated this security rule

Indexes

Constraint Name Type Sort Column(s)
PK__FormActi__3214EC27B53F725B Primary key Asc ID

Relationships

Close relationships within degrees of separation