Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| ScanID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each scanned service coordination data record |
||||
| HeaderID | int | 4 | null |
|
|
Header reference - Links to the scanned form header record |
|||||
| Dateservice | varchar | 30 | √ | null |
|
|
Service date - Date of service from the scanned form (as text) |
||||
| StartTime | varchar | 20 | √ | null |
|
|
Start time - Service start time from the scanned form (as text) |
||||
| EndTime | varchar | 20 | √ | null |
|
|
End time - Service end time from the scanned form (as text) |
||||
| ClaimID | int | 4 | √ | null |
|
|
Claim reference - Links to the generated or matched claim record |
||||
| SubClaimID | int | 4 | √ | null |
|
|
Sub-claim reference - Links to the sub-claim record if applicable |
||||
| ErrorCode | varchar | 10 | √ | null |
|
|
Error code - Error code if there were issues processing the scanned data |
||||
| ScanStatus | int | 4 | √ | (5) |
|
|
Scan status - Current processing status of the scanned data |
||||
| PageRecord | int | 4 | √ | null |
|
|
Page record - Page number or record number within the scanned document |
||||
| VerBy | int | 4 | √ | null |
|
|
Verified by user - UserID of the person who verified the scanned data |
||||
| VerDate | smalldatetime | 16 | √ | null |
|
|
Verification date - Date when the scanned data was verified |
||||
| minutes | int | 4 | √ | null |
|
|
Service minutes - Duration of service in minutes from the scanned form |
||||
| Attcode | varchar | 5 | √ | null |
|
|
Attendance code - Attendance or participation code from the scanned form |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_ScanSCData | Primary key | Asc | ScanID |
| Header_Indx | Performance | Asc | HeaderID |
| IX_ScanSCData | Performance | Asc | ScanStatus |
Relationships
Close relationships within degrees of separation
