RateType


Description

Rate type classifications defining different types of rates used in billing and payroll calculations for healthcare services. This lookup table manages rate type categories and descriptions, supporting rate classification, billing configuration, and payroll management for different types of compensation and billing structures in healthcare organizations.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
RateTypeID int identity 4 √ null
Invoice.fkRateTypeID FK_Invoice_RateType R
PatientAdministration.fkRateTypeID FK_PatientAdministration_RateType R

Primary key - Unique identifier for each rate type
RateType varchar 100 √ null

Rate type name - Descriptive name of the rate type (e.g., ‘Hourly’, ‘Per Visit’, ‘Flat Rate’, ‘Contract’)

Indexes

Constraint Name Type Sort Column(s)
PK_RateType Primary key Asc RateTypeID

Relationships

Close relationships within degrees of separation