Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| pkClassRateID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each rate record, auto-incrementing integer |
|
| fkClassID | int | 4 | null |
|
|
Program reference - Foreign key linking to Plans.pkClassID for the program this rate applies to (required field) |
||
| RateType | nvarchar | 400 | √ | null |
|
|
Rate classification - Type or category of rate (e.g., Hourly, Daily, Weekly, Monthly, Per Session) |
|
| Interval | int | 4 | √ | null |
|
|
Billing interval - Numeric interval for billing frequency (e.g., 1=weekly, 2=bi-weekly) |
|
| Amount | decimal | 20,2 | √ | null |
|
|
Rate amount - Monetary amount for this rate |
|
| EffectiveDate | date | 20 | √ | null |
|
|
Rate effective date - Date when this rate becomes effective |
|
| InactiveDate | date | 20 | √ | null |
|
|
Rate end date - Date when this rate becomes inactive |
|
| DateCreated | datetime | 16,3 | √ | null |
|
|
Creation timestamp - When this rate was first created |
|
| CreatedBy | int | 4 | √ | null |
|
|
Creator user ID - Reference to user who created this rate |
|
| DateUpdated | datetime | 16,3 | √ | null |
|
|
Last modification timestamp - When this rate was most recently updated |
|
| UpdatedBy | int | 4 | √ | null |
|
|
Last modifier - User ID who made the most recent update |
|
| Deleted | bit | 1 | null |
|
|
Soft delete flag - Boolean indicating if rate is logically deleted (required field) |
||
| ScheduleJson | nvarchar | 1073741823 | √ | null |
|
|
Schedule configuration - JSON configuration defining when this rate applies (days, times, conditions) |
|
| Calculation | nvarchar | 200 | √ | null |
|
|
Rate calculation method - Method used to calculate the final rate (e.g., Fixed, Percentage, Tiered) |
|
| BillTo | int | 4 | √ | null |
|
|
Billing target - Reference to entity responsible for payment of this rate |
|
| IsArchived | bit | 1 | √ | null |
|
|
Archive status - Boolean indicating if rate is archived but retained for historical billing |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_ClassRates | Primary key | Asc | pkClassRateID |