RateCodeRulePayroll


Description

Rate code rule payroll management defining payroll-specific rate code rules and configurations for staff compensation calculations. This table manages payroll rate code rules including claim type associations, rate titles, rate codes, payment source usage flags, and audit tracking, supporting flexible payroll rate management, compensation calculations, and payroll rule configuration for healthcare staff payment processing.

Columns

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

Primary key - Unique identifier for each payroll rate code rule
fkCPID int 4 √ null

Claim type program reference - Links to claim type program configuration that this payroll rate rule applies to
fkRateTitle varchar 20 √ null

Rate title reference - Reference to the rate title or rate category for this payroll rule
fkRateCode varchar 10 √ null

Rate code reference - Reference to the specific rate code used for payroll calculations
LastUpdate datetime 16,3 √ null

Last update timestamp - Date and time when this payroll rate rule was last modified
UpdatedBy int 4 √ null

Updated by user - Links to AccessUser table for the user who last updated this payroll rate rule
CreatedDate datetime 16,3 √ null

Creation timestamp - Date and time when this payroll rate rule was created
CreatedBy int 4 √ null

Created by user - Links to AccessUser table for the user who created this payroll rate rule
DeletedDate datetime 16,3 √ null

Deletion timestamp - Date and time when this payroll rate rule was soft deleted
UsePaysource bit 1 √ null

Use payment source flag - Boolean indicating whether payment source should be considered in payroll rate calculations

Indexes

Constraint Name Type Sort Column(s)
PK__RateCodeRulePayr__5ABB0F3D Primary key Asc RuleID

Relationships

Close relationships within degrees of separation