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
16 | RECENT_CONTACT_DATE_REAL | NUMERIC | No |
Returns the most recent contact DTE from Contact Date [I LME 20].