QlOptionSecurity


Description

Query/report option security management controlling access to specific report options and query parameters based on user security levels. This security table manages access control for report options, query parameters, and securable items, supporting role-based access control for reporting features, query customization, and data access restrictions for healthcare reporting and analytics.

Columns

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

Primary key - Unique identifier for each security configuration record
fkReportID int 4 √ null
Reports.ReportID FK_QlOptionSecurity_Reports R

Report reference - Links to the report that this security configuration applies to
fkOptionID int 4 √ null
Categories.pkCategoryID FK_QlOptionSecurity_Categories R

Option reference - Links to the specific report option or parameter being secured
fkSecurableID int 4 √ null
SecurableItems.pkSecurableID FK_QlOptionSecurity_SecurableItems R

Securable reference - Links to the securable item or security group that controls access
SecurableID int 4 √ null

Security identifier - Additional security identifier for access control and permission management

Indexes

Constraint Name Type Sort Column(s)
PK_QlOptionSecurity Primary key Asc pkSecurityID

Relationships

Close relationships within degrees of separation