Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| ScanID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each scanned early intervention data record |
||||
| HeaderID | int | 4 | √ | null |
|
|
Header reference - Links to the scanned form header record |
||||
| StaffID | varchar | 30 | √ | null |
|
|
Staff identifier - ID of the staff member from the scanned form |
||||
| AgencyPatientID | varchar | 30 | √ | null |
|
|
Agency patient identifier - Patient ID as used by the agency from scanned form |
||||
| ServiceType | varchar | 5 | √ | null |
|
|
Service type - Type of early intervention service from the scanned form |
||||
| ModifierType | varchar | 5 | √ | null |
|
|
Modifier type - Service modifier from the scanned form |
||||
| DateService | varchar | 50 | √ | null |
|
|
Service date - Date of service from the scanned form (as text) |
||||
| ActivePayroll | varchar | 5 | √ | null |
|
|
Active payroll indicator - Indicates if this service is active for payroll processing |
||||
| ClaimID | int | 4 | √ | null |
|
|
Claim reference - Links to the generated or matched claim record |
||||
| ErrorCode | varchar | 10 | √ | null |
|
|
Error code - Error code if there were issues processing the scanned data |
||||
| ScanStatus | int | 4 | √ | null |
|
|
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 | √ | (getdate()) |
|
|
Verification date - Date when the scanned data was verified |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK__ScanEIData__4420F751 | Primary key | Asc | ScanID |
Relationships
Close relationships within degrees of separation
