TX_DAY_REC

Description:

This table contains a history of all reconcilable changes made to orders in a treatment day, as well as how the user reconciled those changes. For example, if a medication order was discontinued, the discontinuation would appear in this table, as well as any actions taken on that modification (such as acknowledging it, or removing the order from future days).

Primary Key

Column Name	Ordinal Position
EVENT_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	EVENT_ID	VARCHAR	No
	The unique identifier for the event 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	TX_REC_OTP_ID	NUMERIC	No
	This item contains the ID of the order template that this action refers to.
4	TX_REC_ORD_ID	NUMERIC	No
	This item contains the ID of the order that this action refers to.
5	TX_REC_EVENT_LINE	NUMERIC	No
	This item contains the line number of the event where this action occurred. This corresponds to the LINE column in the table ED_IEV_EVENT_INFO.
6	TX_REC_CHANGE_TYP_C_NAME	VARCHAR	No
	This item contains the type of change documented on this line. May contain organization-specific values: No Category Entries: Review Propagate New Order Dose Change Discontinue Build Change
7	TX_REC_RVW_BY_LINE	NUMERIC	No
	This item contains the line number of the action that reviewed this action.
8	TX_REC_REVIEW_CMT	VARCHAR	No
	For review actions, this item contains the comment entered by the user during the review process.
9	TX_REC_OLD_ERX_ID	NUMERIC	No
	For treatment plan reconciliation events, will hold the old medication (ERX) ID if this event came from a medication replacement.
10	TX_REC_NEW_ERX_ID	NUMERIC	No
	For treatment plan reconciliation events, will hold the new medication (ERX) ID if this even came from a medication replacement
11	TX_REC_MESSAGE	VARCHAR	No
	For treatment plan reconciliation events, will hold the reconciliation message