RTE_PATIENT_QUERY

Description:

This table will contain information about Patient Level Coverage Eligibility Queries. Included in the data is the date and time the query was sent, along with the date and time the response was received. Also included is the Note Record (HNO), the Payor the query was sent to, whether the response was eligible or not, and the action taken upon the response.

Primary Key

Column Name	Ordinal Position
PAT_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	PAT_ID	VARCHAR	No
	The unique ID of the patient record for this row. This column is frequently used to link to the PATIENT table.
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	RTE_SENT_INST	VARCHAR	No
	The instant the patient-level eligibility query was sent.
4	RTE_RCVD_INST	VARCHAR	No
	The instant the patient-level eligibility query's response was received.
5	RTE_HNO_ID	VARCHAR	No
	The unique ID of the note (HNO) record for this patient-level eligibility query.
6	RTE_PAYOR_ID_PAYOR_NAME	VARCHAR	No
	The name of the payor.
7	RTE_HGEN_NUM	NUMERIC	No
	The hSeq index number for this patient-level eligibility query, corresponding to the global ^HGEN("CVG",hSeq) where query information is stored.
8	RTE_RESP_STATUS_C_NAME	VARCHAR	No
	The response status category ID for this patient-level eligibility query. May contain organization-specific values: No Category Entries: ELIGIBLE PENDING ERROR NOT ELIGIBLE
9	RTE_ACTION_C_NAME	VARCHAR	No
	The action taken category ID for this patient-level eligibility query. May contain organization-specific values: No Category Entries: Coverage Created Coverage Updated Response Ignored Auto-Created Auto-Updated Response Resolved Coverage Matched Member Line Added Auto-Ignored