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
Roster Assignment and Attribution
4 EXT_CVGS_PAYOR_ID NUMERIC No
The payor ID associated with the external insurance information.
5 EXT_CVGS_PLAN_ID NUMERIC No
The benefit plan ID associated with the external insurance information.
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 Existing Coverage Used
Eligibility Response Ignored
Non-Eligibility Coverage Created
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.