Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| RateID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each manual payroll rate |
|
| Rates | money | 21,4 | √ | null |
|
|
Rate amount - Monetary rate or compensation amount for the payroll category |
|
| DateEffective | datetime | 16,3 | √ | null |
|
|
Effective date - Date when this payroll rate becomes effective |
|
| RateName | nvarchar | 1073741823 | √ | null |
|
|
Rate name - Descriptive name for the payroll rate or compensation type |
|
| StipendType | int | 4 | √ | null |
|
|
Stipend type reference - Links to stipend type classification |
|
| MeetingType | int | 4 | √ | null |
|
|
Meeting type reference - Links to meeting type that this rate applies to |
|
| PayGroup | int | 4 | √ | null |
|
|
Pay group reference - Links to payroll group classification |
|
| DateEnd | datetime | 16,3 | √ | null |
|
|
End date - Date when this payroll rate expires or is no longer effective |
|
| CreatedBy | int | 4 | √ | null |
|
|
Creator reference - Links to AccessUser table for the user who created this rate |
|
| DateCreated | datetime | 16,3 | √ | null |
|
|
Creation timestamp - Date and time when this payroll rate was created |
|
| UpdatedBy | int | 4 | √ | null |
|
|
Updater reference - Links to AccessUser table for the user who last updated this rate |
|
| DateUpdated | datetime | 16,3 | √ | null |
|
|
Update timestamp - Date and time when this payroll rate was last modified |
|
| DeletedDate | datetime | 16,3 | √ | null |
|
|
Deletion timestamp - Date and time when this payroll rate was deleted |
|
| PayrollType | nvarchar | 100 | √ | null |
|
|
Payroll type - Classification of payroll type (e.g., ‘Hourly’, ‘Stipend’, ‘Per Session’) |
|
| Minutes | int | 4 | √ | null |
|
|
Duration in minutes - Time duration in minutes for time-based payroll calculations |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_ManualPayrollRates | Primary key | Asc | RateID |
Relationships
Close relationships within degrees of separation
