Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| PayrollID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each payroll preview record |
|
| ClaimId | int | 4 | √ | null |
|
|
Claim reference - Links to the service claim for which payroll is being calculated |
|
| Rate | money | 21,4 | √ | null |
|
|
Preview rate - Calculated payroll rate for preview and review |
|
| UserID | int | 4 | √ | null |
|
|
Provider reference - Links to the service provider receiving payment |
|
| DateCalculated | smalldatetime | 16 | √ | null |
|
|
Calculation date - Date when the payroll preview was calculated |
|
| fkPIID | int | 4 | √ | null |
|
|
Payroll invoice reference - Links to the payroll invoice if applicable |
|
| StatusId | int | 4 | √ | null |
|
|
Preview status - Current status of the payroll preview referencing iCS2.dbo.StatusType for centralized status management |
|
| ErrorCode | varchar | 15 | √ | null |
|
|
Error code - Error code if there were issues with the payroll calculation |
|
| DateReceived | datetime | 16,3 | √ | null |
|
|
Received date - Date when the claim data was received for payroll processing |
|
| Comments | varchar | 1000 | √ | null |
|
|
Preview comments - Comments or notes about the payroll preview |
|
| EnteredBy | int | 4 | √ | null |
|
|
Entered by user - UserID of the person who created the payroll preview |
|
| PayrollType | int | 4 | √ | null |
|
|
Payroll type - Type of payroll calculation (Regular, Overtime, etc.) |
|
| NumHour | int | 4 | √ | null |
|
|
Number of hours - Number of hours worked for this payroll entry |
|
| DateService | datetime | 16,3 | √ | null |
|
|
Service date - Date when the service was provided |
|
| SiteID | int | 4 | √ | null |
|
|
Service site - Site where the service was provided |
|
| DateEntered | datetime | 16,3 | √ | (getdate()) |
|
|
Entry date - Date when the payroll preview record was created |
|
| UpdatedBy | int | 4 | √ | null |
|
|
Updated by user - UserID of the person who last modified the preview |
|
| DateUpdated | datetime | 16,3 | √ | null |
|
|
Update date - Date when the preview was last modified |
|
| fkCodeID | int | 4 | √ | null |
|
|
Account code reference - Links to the account code used for payroll calculation |
|
| fkConfigID | int | 4 | √ | null |
|
|
Configuration reference - Links to the payroll configuration used |
|
| fkProgramID | int | 4 | √ | null |
|
|
Program reference - Links to the program type for payroll calculation |
|
| Miles | decimal | 12,1 | √ | null |
|
|
Mileage - Number of miles traveled for mileage reimbursement |
|
| DateExported | datetime | 16,3 | √ | null |
|
|
Export date - Date when the payroll data was exported to external payroll system |
|
| DeletedBy | int | 4 | √ | null |
|
|
Deleted by user - UserID of the person who deleted the payroll preview |
|
| DeletedDate | datetime | 16,3 | √ | null |
|
|
Deletion date - Date when the payroll preview was soft-deleted |
Relationships
Close relationships within degrees of separation
