PR_EST_EVENT_HX

Description: |
Price Estimate event history information.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
ESTIMATE_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | ESTIMATE_ID | NUMERIC | No |
The unique identifier for the estimate record.
2 | LINE | INTEGER | No |
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 | HX_EVENT_TYPE_C_NAME | VARCHAR | No |
The event type category ID for the patient estimate.
May contain organization-specific values: No
Category Entries:
Created
Edited
Finalized
Letter Generated
Replaced
Voided
Amounts Updated
Linked To Encounter
Detached
Linked To Encounter (Prospective Patient)
Refreshed By System
Finalized By System
Expired
Visit List Updated By System
Voided By System
Adjudicated by Payer
Amounts Calculated by Resolute
Signed
Replaced by System
Web Service Sent
Web Service Failed
Amounts Copied from Treatment Estimate
Replaced for Account Split/Combine
Updated via Wisdom Builder
Letter Printing Queued
Letter Printed
Letter Removed From Print Queue
Patient Link Request Sent
Patient Link Response Received
Adjudication Request Sent
Adjudication Response Received
Adjudication Request Canceled
Adjudicated by Payer With Errors
Recalculated by System
4 | HX_USER_ID | VARCHAR | No |
The user associated with the event for this line in the event history table.
5 | HX_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
6 | HX_INSTANT_DTTM | DATETIME (UTC) | No |
The instant of the event for this line in the event history table.
7 | HX_MYPT_ID | VARCHAR | No |
Stores the MyChart user for this line in the event history table.
8 | HX_INSTANT_LOC_DTTM | DATETIME (Local) | No |
The local instant of the event for this line in the event history table.