Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| HeaderID | int | 4 | null |
|
|
Header identifier - Unique identifier for the scan header record |
||
| MilliSecs | nvarchar | 40 | null |
|
|
Milliseconds timestamp - Precise timestamp in milliseconds for scan processing |
||
| UserID | varchar | 30 | √ | null |
|
|
User identifier - ID of the user who processed or scanned the document |
|
| Agencypatientid | varchar | 10 | √ | null |
|
|
Agency patient ID - Patient identifier used by the agency |
|
| DocName | varchar | 255 | √ | null |
|
|
Document name - Name or type of the scanned document |
|
| Signature | varchar | 30 | √ | null |
|
|
Signature information - Digital signature or signature verification data |
|
| DateSigned | varchar | 30 | √ | null |
|
|
Signature date - Date when the document was signed |
|
| FormID | varchar | 30 | √ | null |
|
|
Form identifier - ID of the form or document template |
|
| cpid | varchar | 50 | √ | null |
|
|
Claim procedure ID - Identifier for the claim procedure record |
|
| Dateservice | varchar | 30 | √ | null |
|
|
Service date - Date when the service was provided |
|
| StartTime | varchar | 20 | √ | null |
|
|
Service start time - Time when the service session started |
|
| EndTime | varchar | 20 | √ | null |
|
|
Service end time - Time when the service session ended |
|
| Minutes | int | 4 | √ | null |
|
|
Service duration - Duration of the service in minutes |
|
| ClaimID | int | 4 | √ | null |
|
|
Claim identifier - Unique identifier for the service claim |
|
| SubClaimID | int | 4 | √ | null |
|
|
Sub-claim identifier - Identifier for sub-claims or claim components |
|
| RuleDescription | varchar | 100 | √ | null |
|
|
Rule description - Description of validation rule or business rule applied |
|
| EID | int | 4 | √ | null |
|
|
Error identifier - Identifier for validation errors or rule violations |
|
| ErrorCode | varchar | 10 | √ | null |
|
|
Error code - Code indicating type of error or validation issue |
|
| DateScan | varchar | 30 | √ | null |
|
|
Scan date - Date when the document was scanned into the system |
|
| ScanID | int | 4 | null |
|
|
Scan identifier - Unique identifier for the scan record |
||
| ScanStatus | int | 4 | √ | null |
|
|
Scan status - Current processing status of the scanned document |
|
| ScanStatusDesc | varchar | 30 | √ | null |
|
|
Scan status description - Description of the scan processing status |
|
| pagerecord | int | 4 | √ | null |
|
|
Page record - Page number or record number within the scanned document |
|
| Attcode | int | 4 | √ | null |
|
|
Attendance code - Code indicating attendance or participation status |
Relationships
Close relationships within degrees of separation
