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