MED_CVG_INFO

Description:

This table holds information about medication coverage records.

Primary Key

Column Name	Ordinal Position
MED_ESTIMATE_ID	1

Column Information

	Name	Type	Discontinued?
1	MED_ESTIMATE_ID	NUMERIC	No
	The unique identifier (.1 item) for the medication estimate record.
2	CM_PHY_OWNER_ID	VARCHAR	No
	The Community ID (CID) of the instance that owns this record or line. This is only populated if you use IntraConnect.
3	CM_LOG_OWNER_ID	VARCHAR	No
	The Community ID (CID) of the instance from which this record or line was extracted. This is only populated if you use IntraConnect.
4	RECORD_CREATION_DATE	DATETIME	No
	Stores the date the record was created.
5	CNCT_TYPE_C_NAME	VARCHAR	No
	Stores the record type for this medication estimate. May contain organization-specific values: No Category Entries: Medication Estimate Alternatives for Medication Estimate Best Care Choices Medication Estimate
6	CVG_MEMBER_ID	VARCHAR	No
	This holds the member ID associated with this medication estimate.
7	PAT_ID	VARCHAR	No
	The unique ID of the patient record for this row (EPT ID). This column is frequently used to link to the PATIENT table.
8	ENC_CSN	NUMERIC	No
	Encounter contact serial number of the patient encounter record for this row (EPT CSN). A unique contact serial number in decimal format.
9	EPRESCRIBING_NET_ID	NUMERIC	No
	The identifier of the e-prescribing network (DXO) record used for real-time prescription benefits (RTPB) for this estimate.
10	EPRESCRIBING_NET_ID_EXTERNAL_NAME	VARCHAR	No
	Organization's external name used as the display name on forms and user interfaces.
11	CVG_PAYER_IDNT	VARCHAR	No
	This holds the external ID of the payer associated with this estimate.
12	ORDER_ID	NUMERIC	No
	This item holds the record ID of the order (ORD) this medication estimate is linked to. It may be null if an order has not been linked yet.
13	REPORTING_VERSION	INTEGER	No
	This item is used for reporting purposes. It holds a number that is used to determine which items were available when this record was created.
14	VIEWED_BEFORE_SIGN_YN	VARCHAR	No
	This item records if a user viewed estimate data in the RTPB window prior to the order being signed. It will only be set to Yes if the the query results were actually displayed prior to signing. This item is only populated on records of type 1-Medication Estimate. May contain organization-specific values: No Category Entries: No Yes
15	ALT_VIEWED_BEFORE_SIGN_YN	VARCHAR	No
	This item records if a user ever viewed an alternative in the RTPB window prior to the order being signed. To determine which specific alternatives were viewed, see LME 320-Displayed to User Before Signing. This item is only populated on records of type 1-Medication Estimate. The category values for this column were already listed for column: VIEWED_BEFORE_SIGN_YN