Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| BusinessRuleViolations | Unknown | 0 | null |
|
|
Business rule violations - List of business rule violations |
||
| ErrorCode | Unknown | 0 | null |
|
|
Error code - Specific error code if processing failed |
||
| ErrorMessage | Unknown | 0 | null |
|
|
Error message - Detailed error message for failed processing |
||
| pk_ID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each import status detail |
|
| fkImportedId | int | 4 | √ | null |
|
|
Import reference - Links to EIHUB_ImportHistory for the import operation |
|
| fkImportRowId | int | 4 | √ | null |
|
|
Import row reference - Links to specific row in the import file |
|
| ImportCaseStatus | varchar | 20 | √ | null |
|
|
Case import status - Status of case import for this record |
|
| ImportCase_Message | varchar | 2147483647 | √ | null |
|
|
Case import message - Detailed message about case import |
|
| ImportedAdmitId | int | 4 | √ | null |
|
|
Imported admission ID - ID of the admission created during import |
|
| ImportAuthStatus | varchar | 20 | √ | null |
|
|
Authorization import status - Status of authorization import for this record |
|
| ImportAuth_Message | varchar | 2147483647 | √ | null |
|
|
Authorization import message - Detailed message about authorization import |
|
| ImportedAuthId | int | 4 | √ | null |
|
|
Imported authorization ID - ID of the authorization created during import |
|
| ImportPlanStatus | varchar | 20 | √ | null |
|
|
Plan import status - Status of plan import for this record |
|
| ImportPlan_Message | varchar | 2147483647 | √ | null |
|
|
Plan import message - Detailed message about plan import |
|
| ImportedPlanId | int | 4 | √ | null |
|
|
Imported plan ID - ID of the plan created during import |
|
| CatchErrorMessage | varchar | 2147483647 | √ | null |
|
|
Error message - General error message for any import failures |
|
| ProcessedDate | Unknown | 0 | null |
|
|
Processing date - Date when this record was processed |
||
| ProcessingStatus | Unknown | 0 | null |
|
|
Processing status - Status of processing for this specific record |
||
| RecordID | Unknown | 0 | null |
|
|
Record identifier - Identifier of the specific record being processed |
||
| RecordType | Unknown | 0 | null |
|
|
Record type - Type of record being imported (Patient, Service, etc.) |
||
| ResolutionNotes | Unknown | 0 | null |
|
|
Resolution notes - Notes about resolving import issues |
||
| RetryCount | Unknown | 0 | null |
|
|
Retry count - Number of times processing was retried for this record |
||
| SourceData | Unknown | 0 | null |
|
|
Source data - Original data from EIHUB for this record |
||
| TransformedData | Unknown | 0 | null |
|
|
Transformed data - Data after transformation for local system |
||
| ValidationErrors | Unknown | 0 | null |
|
|
Validation errors - List of validation errors encountered |
Relationships
Close relationships within degrees of separation
