Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| uploadID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each scan upload session |
||||
| userID | int | 4 | null |
|
|
User reference - UserID of the person who performed the upload |
|||||
| agencyID | int | 4 | null |
|
|
Agency reference - Agency ID associated with the upload session |
|||||
| DateEntered | datetime | 16,3 | (getdate()) |
|
|
Entry date - Date when the upload session was initiated |
|||||
| comments | varchar | 100 | √ | null |
|
|
Upload comments - Comments or notes about the upload session |
||||
| milliSecs | nvarchar | 40 | null |
|
|
Millisecond timestamp - Precise timestamp in milliseconds for upload tracking |
|||||
| claimStatus | int | 4 | null |
|
|
Claim status - Status of claims processing for this upload |
|||||
| checkForErrors | varchar | 10 | null |
|
|
Error check flag - Flag indicating whether to check for errors during processing |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK__ScanUploadHistor__741A2336 | Primary key | Asc | uploadID |
Relationships
Close relationships within degrees of separation
