PAT_EXTERNAL_CVGS

Description: |
The PAT_EXTERNAL_CVGS table contains insurance information imported into Epic from an external system. Each row in the table corresponds to a coverage a patient had in the external system.

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 | EXT_CVGS_SRC_SYS_C_NAME | VARCHAR | No |
The external system that the insurance information was loaded from.
May contain organization-specific values: Yes
Category Entries:
MyChart
EpicCare Link
Welcome
RTE Response
Roster Management Engine
MyChart Guest
Interconnect Network
Yaqeen Register
Standalone Webservice
Payer Platform
Incoming External Pre-Adjudicated Claims (X12 837) Interface
PB Exchange
Roster Assignment and Attribution
Electronic Authorization Request Autotrigger
Incoming Bulk Flat File
4 | EXT_CVGS_PAYOR_ID_PAYOR_NAME | VARCHAR | No |
The name of the payor.
5 | EXT_CVGS_PLAN_ID_BENEFIT_PLAN_NAME | VARCHAR | No |
The name of the benefit plan record.
6 | EXT_CVGS_INS_NAME | VARCHAR | No |
The search string a registrar would enter in the search box when attempting to create a new coverage record. This string typically includes the payor name, plan name, or synonym used to refer to the payor or plan.
7 | EXT_CVGS_SUBSCR_NUM | VARCHAR | No |
The subscriber ID associated with the external insurance information.
8 | EXT_CVGS_SUBSCR_NAM | VARCHAR | No |
The name of the subscriber associated with the external insurance information.
9 | EXT_CVGS_SUBSCR_BIRTH_DATE | DATETIME | No |
The birth date of the subscriber associated with the external insurance information.
10 | EXT_CVGS_SUBS_SEX_C_NAME | VARCHAR | No |
The sex of the subscriber associated with the external insurance information.
May contain organization-specific values: Yes
Category Entries:
Female
Male
Unknown
Nonbinary
X
Other
11 | EXT_CVGS_MEM_REL_C_NAME | VARCHAR | No |
The relationship between the member and the subscriber associated with the external insurance information.
May contain organization-specific values: Yes
Category Entries:
Self
Spouse
Child
Employee
Unknown
12 | EXT_CVGS_MEM_NUM | VARCHAR | No |
The member ID associated with the external insurance information.
13 | EXT_CVGS_MEM_NAME | VARCHAR | No |
The member name override for the patient associated with the external insurance information. This is an override for the patient name when the payor is expecting a different name.
14 | EXT_CVGS_GROUP_NUM | VARCHAR | No |
The group number associated with the external insurance information.
15 | EXT_CVGS_RESP_ID | VARCHAR | No |
The General Use Notes (HNO) ID or response text received from an eligibility query sent to verify the external coverage.
16 | EXT_CVGS_CVG_ID | NUMERIC | No |
The ID of the coverage created from the external insurance information.
17 | EXT_CVGS_ACTION_C_NAME | VARCHAR | No |
The action taken on the external insurance information.
May contain organization-specific values: No
Category Entries:
No Action Taken
Manually Flagged as Done
Eligibility Coverage Created
Eligibility Response Updated Existing Coverage
Eligibility Response Ignored
Non-Eligibility Coverage Created
Matched Existing Coverage
Eligibility Coverage with Mismatch Dismissed
18 | EXT_CVGS_CREAT_UTC_DTTM | DATETIME (UTC) | No |
The UTC instant when this external coverage was stored in Epic.
19 | EXT_CVGS_EFF_FRM_DATE | DATETIME | No |
The date from which the external coverage is effective. This is meant to map to what we store in Effective Date From (I CVG 400).
20 | EXT_CVGS_EFF_TO_DATE | DATETIME | No |
The date to which the external coverage is effective. This is meant to map to what we store in Effective Date To (I CVG 410)
21 | EXT_CVGS_BIN | VARCHAR | No |
The Beneficiary Identification Number (BIN) of the external coverage.
22 | EXT_CVGS_PCN | VARCHAR | No |
The processor control number (PCN) of the external coverage.
23 | EXT_CVGS_PERS_CODE | VARCHAR | No |
The person code of the external coverage. This is meant to map to what we store in Member Person Code (I CVG 316).
24 | EXT_CVGS_CSN | NUMERIC | No |
Stores the contact serial number (CSN) of the encounter that created the coverage, if it was created in an encounter.
25 | EXT_CVG_SRC_ORGANIZATION_ID | NUMERIC | No |
The Organization (DXO) that provided the information for this coverage.
26 | EXT_CVG_SRC_ORGANIZATION_ID_EXTERNAL_NAME | VARCHAR | No |
Organization's external name used as the display name on forms and user interfaces.
27 | EXT_CVGS_FHIR_IDENT | VARCHAR | No |
The FHIR Id of a coverage record on an external system that was used to create this coverage.
28 | EXT_CVGS_CVG_OID | VARCHAR | No |
The OID of a coverage record on an external system that was used to create this coverage.