Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| pkID | int identity | 4 | √ | null |
|
|
Custom rate primary key - Unique identifier for each custom rate record |
|
| fkPayrollID | int | 4 | √ | null |
|
|
Payroll reference - Links to payroll record for rate calculations |
|
| DateCreated | datetime | 16,3 | √ | null |
|
|
Creation date - Date when this custom rate record was created |
|
| CreatedBy | int | 4 | √ | null |
|
|
Created by user - UserID of the person who created this record |
|
| DateUpdated | datetime | 16,3 | √ | null |
|
|
Last update date - Date when this record was last modified |
|
| UpdatedBy | int | 4 | √ | null |
|
|
Updated by user - UserID of the person who last updated this record |
|
| DeletedDate | datetime | 16,3 | √ | null |
|
|
Deletion date - Date when this record was soft deleted |
|
| StipendOptions | nvarchar | 510 | √ | null |
|
|
Stipend configuration - JSON or text configuration for stipend calculation options |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK__ClaimSer__40A359E351AE97B5 | Primary key | Asc | pkID |
Relationships
Close relationships within degrees of separation
