CVG_RTE_QUERY

Description:

Table for Eligibility coverage queries.

Primary Key

Column Name	Ordinal Position
CVG_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	CVG_ID	NUMERIC	No
	The unique identifier of the coverage (CVG) 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	SENT_INST	VARCHAR	No
	The time an eligibility response was sent.
4	RCVD_INST	VARCHAR	No
	The time an eligibility response was received.
5	RESP_ID	VARCHAR	No
	The ID of the linked note (HNO) record for the response text.
6	RESP_FILED_YN	VARCHAR	No
	This item flags if the response data was filed. May contain organization-specific values: No Category Entries: Yes No
7	HGEN_INX	NUMERIC	No
	Index to HGEN global for message info. Packed version of CVG 8550 HGEN INDEX
8	PAT_ID	VARCHAR	No
	Record the patient ID of the member for the particular response message.
9	QUERY_DATE	DATETIME	No
	A record of the service date queried.
10	SENT_TRUE_INST_DTTM	DATETIME (UTC)	No
	The time an eligibility response was sent, in instance format.
11	RESPONSE_REG_STATUS_C_NAME	VARCHAR	No
	This contains the verification status associated with a specific RTE (real-time eligibility) Response. May contain organization-specific values: Yes
12	REALTIME_TX_ID	NUMERIC	No
	Transaction record that stores the coverage level query request and response.