Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| pkAmt | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each monthly amount record |
||||
| AuthID | int | 4 | √ | null |
|
|
Authorization reference - Links to Authorize table for the service authorization |
||||
| Rate | money | 21,4 | √ | null |
|
|
Monthly rate - Rate per unit for services in this month |
||||
| Month | int | 4 | √ | null |
|
|
Month - Month number (1-12) for this rate period |
||||
| Year | int | 4 | √ | null |
|
|
Year - Year for this rate period |
||||
| Weeks | int | 4 | √ | null |
|
|
Number of weeks - Number of weeks in this month for calculation |
||||
| Total | money | 21,4 | √ | null |
|
|
Total amount - Calculated total amount for the month |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_AuthMonthlyAmount | Primary key | Asc | pkAmt |
| IX_AuthID | Performance | Asc | AuthID |
| IX_MMYY | Performance | Asc/Asc | Month + Year |
Relationships
Close relationships within degrees of separation
