PayrollRatesSetting_VW

Primary key - Unique identifier for the payroll rate configuration

Rate amount - Monetary amount for the payroll rate (hourly, per session, or per unit)

Effective date - Date when this payroll rate becomes effective

Rate group name - Name of the rate group this configuration belongs to

Rate comments - Additional notes or comments about this payroll rate configuration

Patient identifier - Foreign key to specific patient if this is a patient-specific rate

Service type identifier - Foreign key linking to iCS2.dbo.ServiceType for centralized service type definitions and standardized service codes

Modifier identifier - Foreign key linking to iCS2.dbo.Modifier for centralized billing modifier definitions and standardized modifier codes

Procedure code - Foreign key linking to specific procedure code this rate applies to

User identifier - Foreign key linking to specific healthcare provider this rate applies to

Pay group - Foreign key linking to pay group classification for this rate

End date - Date when this payroll rate expires or becomes inactive

Rate status - Current status of the payroll rate (Active, Inactive, Pending, etc.)

Minimum minutes - Minimum number of minutes required for this rate to apply

Claim type foreign key - Links to claim type configuration that uses this rate

Maximum minutes - Maximum number of minutes this rate applies to (for tiered rates)

Created by user - User ID of the person who created this rate configuration

Creation date - Timestamp when this rate configuration was created

Updated by user - User ID of the person who last modified this rate configuration

Update date - Timestamp when this rate configuration was last modified

Payment source - Code identifying the funding source or insurance that uses this rate

Group size - Number of participants in group sessions for group rate calculations

Claim information - Additional claim-related information for this rate

Program name - Name of the program or service line this rate applies to

Modifier description - Description of the billing modifier associated with this rate

Rate rule - Business rule or calculation method applied to this rate

Pay group name - Descriptive name of the pay group classification

Payment source name - Descriptive name of the payment source or funding entity

Modifier information - Detailed information about the billing modifier

Procedure information - Detailed information about the procedure code

Service information - Detailed information about the service type