Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| pkClassRateID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each plan rate configuration |
||||
| fkClassID | int | 4 | null |
|
|
Class reference - Links to Plans table for the educational class or program |
|||||
| RateType | nvarchar | 400 | √ | null |
|
|
Rate type - Type of rate structure (e.g., ‘Hourly’, ‘Daily’, ‘Weekly’, ‘Monthly’, ‘Per Session’) |
||||
| Interval | int | 4 | √ | null |
|
|
Billing interval - Billing frequency or interval for rate application (e.g., 1=Daily, 7=Weekly, 30=Monthly) |
||||
| Amount | decimal | 20,2 | √ | null |
|
|
Rate amount - Monetary amount for this rate configuration |
||||
| EffectiveDate | date | 20 | √ | null |
|
|
Effective date - Date when this rate becomes effective |
||||
| InactiveDate | date | 20 | √ | null |
|
|
Inactive date - Date when this rate expires or becomes inactive |
||||
| DateCreated | datetime | 16,3 | √ | null |
|
|
Creation timestamp - Date and time when this rate was created |
||||
| CreatedBy | int | 4 | √ | null |
|
|
Creator reference - Links to AccessUser table for the user who created this rate |
||||
| DateUpdated | datetime | 16,3 | √ | null |
|
|
Update timestamp - Date and time when this rate was last modified |
||||
| UpdatedBy | int | 4 | √ | null |
|
|
Updater reference - Links to AccessUser table for the user who last updated this rate |
||||
| Deleted | bit | 1 | null |
|
|
Deletion flag - Soft delete flag for audit trail purposes |
|||||
| ScheduleJson | nvarchar | 1073741823 | √ | null |
|
|
Schedule configuration - JSON data containing detailed schedule and billing configuration |
||||
| Calculation | nvarchar | 200 | √ | null |
|
|
Calculation method - Method or formula used for rate calculation |
||||
| IsArchived | bit | 1 | √ | null |
|
|
Archive flag - Indicates if this rate configuration has been archived |
||||
| BillTo | int | 4 | √ | null |
|
|
Bill to reference - Links to entity responsible for payment of this rate |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_ClassRates | Primary key | Asc | pkClassRateID |
Relationships
Close relationships within degrees of separation
