LOADED_EXTERNAL_CVG_DATA

Description:

Clarity table for no-add single items in LCI.

Primary Key

Column Name	Ordinal Position
EXTERNAL_CVG_ID	1

Column Information

	Name	Type	Discontinued?
1	EXTERNAL_CVG_ID	NUMERIC	No
	The unique identifier for the loaded coverage information record.
2	PAT_ID	VARCHAR	No
	The unique ID of the patient record linked to the External ID bundle associated with this external coverage data.
3	EXT_DEMOG_ID	NUMERIC	No
	The unique ID of the External Demographic Set that this external coverage is loaded to.
4	EXTERNAL_CVG_PAYER_ID_PAYOR_NAME	VARCHAR	No
	The name of the payor.
5	EXTERNAL_CVG_PLAN_ID_BENEFIT_PLAN_NAME	VARCHAR	No
	The name of the benefit plan record.
6	EXTERNAL_CVG_SUB_IDENT	VARCHAR	No
	The ID of the subscriber for the associated external coverage.
7	EXT_CVG_SOURCE_SYSTEM_C_NAME	VARCHAR	No
	The external source that sent the external coverage information. 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
8	EXTERNAL_CVG_MEMBER_IDENT	VARCHAR	No
	The member's insurance ID for the associated external coverage.