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