Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| arcSCID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each archived service coordination scan record |
|
| arcHeaderID | int | 4 | √ | null |
|
|
Archive header reference - Links to ScanArchiveHeader table for the associated archive header |
|
| ScanID | int | 4 | null |
|
|
Scan identifier - Identifier for the original scan record being archived |
||
| headerID | int | 4 | null |
|
|
Header identifier - Identifier for the original document header |
||
| Dateservice | varchar | 30 | √ | null |
|
|
Service date - Date when the service coordination session occurred |
|
| StartTime | varchar | 20 | √ | null |
|
|
Start time - Time when the service coordination session started |
|
| EndTime | varchar | 20 | √ | null |
|
|
End time - Time when the service coordination session ended |
|
| ErrorCode | varchar | 10 | √ | null |
|
|
Error code - Error code if there were issues with the scan or session |
|
| ScanStatus | int | 4 | √ | null |
|
|
Scan status - Status of the scan processing (e.g., 1=Processed, 2=Error, 3=Pending) |
|
| minutes | int | 4 | √ | null |
|
|
Session duration - Duration of the service coordination session in minutes |
|
| UpdatedBy | int | 4 | null |
|
|
Updated by user - UserID of the person who last updated the archive record |
||
| DateUpdated | datetime | 16,3 | null |
|
|
Last update date - Date when the archive record was last modified |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK__ScanArchiveSC__355F6D5C | Primary key | Asc | arcSCID |
Relationships
Close relationships within degrees of separation
