RXA_CVG_TABLE

Description: |
Table that holds coverage information for an adjudication. Adjudication records are used by Ambulatory Pharmacy during prescription copay adjudication.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
RECORD_ID | 1 |
CONTACT_DATE_REAL | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | RECORD_ID | NUMERIC | No |
The unique identifier for the adjudication record.
2 | CONTACT_DATE_REAL | FLOAT | No |
A unique, internal contact date in decimal format. The integer portion of the number indicates the date of the contact. The digits after the decimal distinguish different contacts on the same date and are unique for each contact on that date. For example, .00 is the first/only contact, .01 is the second contact, etc.
3 | CONTACT_DATE | DATETIME | No |
The date of this contact in calendar format.
4 | CM_CT_OWNER_ID | VARCHAR | No |
The Community ID (CID) of the instance that owns this contact. This is only populated if you use IntraConnect.
5 | CVG_ID | NUMERIC | No |
The unique ID of the coverage for which the adjudication record was created.
6 | TX_TYPE_C_NAME | VARCHAR | No |
Transaction Type category ID of the adjudication message
May contain organization-specific values: No
Category Entries:
Bill (B1)
Reversal (B2)
Rebill (B3)
Eligibility (E1)
Authorization
Cancellation
Claim
Information Reporting (N1)
7 | PAYOR_SHEET_ID | NUMERIC | No |
The payor sheet that is used during adjudication. Each time an adjudication occurs on a prescription the payor sheet to use is determined based on setup in the payor and plan records.
8 | PAYOR_SHEET_ID_RECORD_NAME | VARCHAR | No |
The name of this payor sheet
9 | ACTION_INSTANT_DTTM | DATETIME (UTC) | No |
Date and time when the adjudication action was performed on the prescription fill.