Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Claimid | int | 4 | √ | null |
|
|
Claim reference - Links to the service claim for which rates are being calculated |
||||
| Rate | money | 21,4 | √ | null |
|
|
Calculated rate - Calculated payroll rate for the service claim |
||||
| UserID | int | 4 | √ | null |
|
|
Provider reference - Links to the service provider (AccessUser) receiving payment |
||||
| DateCalculated | smalldatetime | 16 | √ | null |
|
|
Calculation date - Date when the rate calculation was performed |
||||
| fkPIID | int | 4 | √ | null |
|
|
Payroll invoice reference - Links to the payroll invoice containing this rate calculation |
||||
| statusid | int | 4 | √ | null |
|
|
Processing status - Current status of the rate calculation processing, references iCS2.dbo.StatusType for centralized status management |
||||
| ErrorCode | varchar | 15 | √ | null |
|
|
Error code - Error code if there were issues with rate calculation |
||||
| DateReceived | datetime | 16,3 | √ | null |
|
|
Received date - Date when the claim data was received for processing |
||||
| Comments | varchar | 1000 | √ | null |
|
|
Processing comments - Comments or notes about the rate calculation |
||||
| EnteredBy | int | 4 | √ | null |
|
|
Entered by user - UserID of the person who entered the rate calculation |
||||
| PayrollType | int | 4 | √ | null |
|
|
Payroll type - Type of payroll calculation (Regular, Overtime, etc.) |
||||
| PayrollID | int identity | 4 | √ | null |
|
|
Payroll identifier - Unique identifier for this payroll calculation record |
||||
| NumHour | int | 4 | √ | null |
|
|
Number of hours - Number of hours worked for this claim |
||||
| 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 rate calculation record was created |
||||
| UpdatedBy | int | 4 | √ | null |
|
|
Updated by user - UserID of the person who last modified the record |
||||
| DateUpdated | datetime | 16,3 | √ | null |
|
|
Update date - Date when the record was last modified |
||||
| fkCodeID | int | 4 | √ | null |
|
|
Account code reference - Links to the account code used for this rate calculation |
||||
| fkConfigID | int | 4 | √ | null |
|
|
Configuration reference - Links to the rate configuration used |
||||
| fkProgramID | int | 4 | √ | null |
|
|
Program reference - Links to the program type for rate calculation |
||||
| Miles | decimal | 12,1 | √ | null |
|
|
Mileage - Number of miles traveled for mileage reimbursement |
||||
| DateExported | datetime | 16,3 | √ | null |
|
|
Export date - Date when the rate calculation was exported to external systems |
||||
| DeletedBy | int | 4 | √ | null |
|
|
Deleted by user - UserID of the person who deleted the rate calculation record |
||||
| deleteddate | datetime | 16,3 | √ | null |
|
|
Deletion date - Date when the rate calculation record was deleted (soft delete) |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK__claimserviceRate__2FD0B138 | Primary key | Asc | PayrollID |
| ID_ClaimID | Performance | Asc | Claimid |
| IX_ClaimID | Performance | Asc | DateCalculated |
| IX_ClaimServiceRate | Performance | Asc | DateReceived |
| IX_ErrorCode | Performance | Asc | ErrorCode |
| IX_InvoiceID | Performance | Asc | fkPIID |
| IX_Status | Performance | Asc | statusid |
| IX_UserID | Performance | Asc | UserID |
Relationships
Close relationships within degrees of separation
