Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| arcHeaderID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each archived document header |
|
| headerID | int | 4 | null |
|
|
Header reference - Links to the original document header being archived |
||
| MilliSecs | nvarchar | 40 | null |
|
|
Timestamp milliseconds - Precise timestamp in milliseconds for archive creation |
||
| UserID | varchar | 20 | null |
|
|
User identifier - ID of the user who created or processed the archived document |
||
| AgencyPatientID | varchar | 30 | null |
|
|
Agency patient ID - Agency-specific patient identifier associated with the archived document |
||
| 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__ScanArchiveHeade__3747B5CE | Primary key | Asc | arcHeaderID |
Relationships
Close relationships within degrees of separation
