FIN_ASST_TRKR_RTE_EVT_HX

Description:

This table contains a history of RTE integration for a tracker.

Primary Key

Column Name	Ordinal Position
FIN_ASST_TRACKER_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	FIN_ASST_TRACKER_ID	NUMERIC	No
	The unique identifier (.1 item) for the program tracker 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	EVT_INSTANT_UTC_DTTM	DATETIME (UTC)	No
	The instant an event was logged in UTC
4	EVT_TYP_C_NAME	VARCHAR	No
	Event type being logged May contain organization-specific values: Yes Category Entries: Program filter rules restricted all payers & plans RTE configuration or internal error Query sent Coverage linked Tracker approved via coverage link Query failed due to tracker or patient data. User note logged. Nightly processing evaluation begin Batch evaluation begin
5	EVT_PLAN_ID_BENEFIT_PLAN_NAME	VARCHAR	No
	The name of the benefit plan record.
6	EVT_PAYER_ID_PAYOR_NAME	VARCHAR	No
	The name of the payor.
7	EVT_RULE_ID	VARCHAR	No
	Program rule that matched when the tracker query was attempted
8	EVT_RULE_ID_RULE_NAME	VARCHAR	No
	The name of the rule.
9	EVT_ADDL_INFO	VARCHAR	No
	Additional info regarding RTE error codes