Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| Claimid | int | 4 | √ | null |
|
|
Claim reference - Links to Claim table for the associated claim |
|
| Rate | money | 21,4 | √ | null |
|
|
Service rate - Rate per unit for the service provided |
|
| DateCalculated | smalldatetime | 16 | √ | null |
|
|
Calculation date - Date when the rate was calculated |
|
| DateReceived | datetime | 16,3 | √ | null |
|
|
Received date - Date when rate information was received |
|
| Comments | varchar | 1000 | √ | null |
|
|
Rate comments - Notes about the rate calculation |
|
| DateService | datetime | 16,3 | √ | null |
|
|
Service date - Date when the service was provided |
|
| DateEntered | datetime | 16,3 | √ | null |
|
|
Entry date - Date when the record was entered |
|
| DateExported | Unknown | 0 | null |
|
|
Export date - Date when data was exported to payroll system |
||
| DateUpdated | datetime | 16,3 | √ | null |
|
|
Update date - Date of the last modification |
|
| DeletedBy | Unknown | 0 | null |
|
|
Deleted by user - UserID of the person who deleted the record |
||
| deleteddate | Unknown | 0 | null |
|
|
Deletion date - Date when the record was deleted |
||
| UserID | int | 4 | √ | null |
|
|
Provider reference - Links to AccessUser table for the healthcare provider |
|
| fkPIID | int | 4 | √ | null |
|
|
Payroll invoice reference - Links to PayrollInvoice table |
|
| statusid | int | 4 | √ | null |
|
|
Status ID - Status of the rate calculation |
|
| ErrorCode | varchar | 15 | √ | null |
|
|
Error code - Error code if calculation failed |
|
| EnteredBy | int | 4 | √ | null |
|
|
Entered by user - UserID of the person who entered the rate |
|
| PayrollType | int | 4 | √ | null |
|
|
Payroll type - Type of payroll calculation |
|
| PayrollID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each deleted rate record |
|
| NumHour | int | 4 | √ | null |
|
|
Number of hours - Hours worked for rate calculation |
|
| SiteID | int | 4 | √ | null |
|
|
Site reference - Links to AgencySite table for service location |
|
| UpdatedBy | int | 4 | √ | null |
|
|
Updated by user - UserID of the person who last updated the record |
|
| fkCodeID | int | 4 | √ | null |
|
|
Account code reference - Links to AccountCodes table |
|
| fkConfigID | int | 4 | √ | null |
|
|
Configuration reference - Links to configuration settings |
|
| fkProgramID | int | 4 | √ | null |
|
|
Program reference - Links to program type |
|
| Miles | decimal | 12,1 | √ | null |
|
|
Mileage - Miles traveled for service delivery |
Relationships
Close relationships within degrees of separation
