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
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.