PayrollExceptionRuleType


Description

Payroll exception rule type definitions defining types and rules for payroll exception processing and validation. This lookup table manages exception rule types including descriptions, field mappings, qualifiers, and table references, supporting systematic payroll exception processing, rule-based validation, and flexible exception handling for healthcare staff compensation management.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ExcepType varchar 10 null
PayrollException.fkExcepTypeID FK__PayrollEx__fkExc__793F965D C

Primary key - Unique identifier for each payroll exception rule type
ExcepDescription varchar 255 √ null

Exception description - Detailed description of the payroll exception rule type
FieldName varchar 50 √ null

Field name - Database field name associated with this exception rule type
FieldQuantifier varchar 30 √ null

Field qualifier - Qualifier or condition for the field associated with this exception rule
Tablename varchar 50 √ null

Table name - Database table name where this exception rule type applies

Indexes

Constraint Name Type Sort Column(s)
PK__PayrollException__5CA357AF Primary key Asc ExcepType

Relationships

Close relationships within degrees of separation