DOCS_RCVD_MED_DISP

Description:

This table stores external medication dispense history received from outside sources.

Primary Key

Column Name	Ordinal Position
DOCUMENT_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	DOCUMENT_ID	NUMERIC	No
	This item stores the Received Document record ID.
2	LINE	INTEGER	No
	The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
3	MDH_REF_ID	VARCHAR	No
	This item stores the medication dispense reference identifier.
4	MED_DISP_MED_NAME	VARCHAR	No
	This item stores the medication dispense medication name.
5	MED_DISP_MED_ID_MEDICATION_NAME	VARCHAR	No
	The name of this medication record.
6	MED_DISP_MED_SIG	VARCHAR	No
	This item stores the medication dispense medication directions.
7	MED_DISP_MED_DOSE	VARCHAR	No
	This item stores the medication dispense medication dose.
8	MED_DISP_DIS_DOSE	NUMERIC	No
	This item stores the medication dispense medication discrete dose.
9	MED_DISP_UNIT	VARCHAR	No
	This item stores the medication dispense medication dose unit.
10	MED_DISP_UNIT_ID_C_NAME	VARCHAR	No
	This item stores the medication dispense mapped medication dose unit. May contain organization-specific values: Yes Category Entries: mL L mg g Units mmol mEq mcg % Int'l Units Million Units kcal ng mg PE milli-units pg KBq MBq GBq mcL mL/min L/min mg/min g/min Units/min mmol/min mEq/min mcg/min kJ/min Int'l Units/min Million Units/min kcal/min ng/min mg PE/min milli-units/min pg/min KBq/min MBq/min GBq/min mcL/min mL/hr L/hr mg/hr g/hr Units/hr mmol/hr mEq/hr mcg/hr kJ/hr Int'l Units/hr Million Units/hr kcal/hr ng/hr mg PE/hr milli-units/hr pg/hr KBq/hr MBq/hr GBq/hr mcL/hr mL/day L/day mg/day g/day Units/day mmol/day mEq/day mcg/day kJ/day Int'l Units/day Million Units/day kcal/day ng/day mg PE/day milli-units/day pg/day Inch/day KBq/day MBq/day GBq/day mcL/day IR/day BAU/day PFU/day Million PFU/day Million Int'l Units/day Kilo Int'l Units/day EIN/day Million EIN/day mL/kg L/kg mg/kg g/kg Units/kg mmol/kg mEq/kg mcg/kg kJ/kg Int'l Units/kg Million Units/kg kcal/kg ng/kg mg PE/kg milli-units/kg pg/kg mg/kg (Actual) Each/kg Puff/kg Package/kg Drop/kg Inch/kg KBq/kg MBq/kg GBq/kg mcL/kg IR/kg BAU/kg Million Int'l Units/kg mcmol/kg 1e12 Vector Genomes/kg Vector Genomes/kg Dose/kg mcg DFE/kg Kilo Int'l Units/kg 1e11 Vector Genomes/kg 1e13 Vector Genomes/kg 1e14 Vector Genomes/kg 1e15 Vector Genomes/kg EIN/kg IR/min BAU/min Million Int'l Units/min Kilo Int'l Units/min IR/hr BAU/hr Million Int'l Units/hr Kilo Int'l Units/hr mL/mL L/mL mg/mL g/mL Units/mL mmol/mL mEq/mL mcg/mL kJ/mL Int'l Units/mL Million Units/mL kcal/mL ng/mL mg PE/mL milli-units/mL pg/mL KBq/mL MBq/mL GBq/mL mcL/mL IR/mL BAU/mL PFU/mL Million PFU/mL Million Int'l Units/mL mcmol/mL 1e12 Vector Genomes/mL Vector Genomes/mL Kilo Int'l Units/mL 1e11 Vector Genomes/mL 1e13 Vector Genomes/mL 1e14 Vector Genomes/mL 1e15 Vector Genomes/mL millicurie/mL mL/L L/L mg/L g/L Units/L mmol/L mEq/L mcg/L kJ/L Int'l Units/L Million Units/L kcal/L ng/L mg PE/L milli-units/L pg/L KBq/L MBq/L GBq/L mcL/L IR/L BAU/L Million Int'l Units/L Kilo Int'l Units/L mL/m2 L/m2 mg/m2 g/m2 Units/m2 mmol/m2 mEq/m2 mcg/m2 kJ/m2 Int'l Units/m2 Million Units/m2 kcal/m2 ng/m2 mg PE/m2 milli-units/m2 pg/m2 mg/m2 (Actual) Each/m2 Puff/m2 Package/m2 Drop/m2 KBq/m2 MBq/m2 GBq/m2 mcL/m2 IR/m2 BAU/m2 Million Int'l Units/m2 mcmol/m2 1e12 Vector Genomes/m2 Vector Genomes/m2 Kilo Int'l Units/m2 1e11 Vector Genomes/m2 1e13 Vector Genomes/m2 1e14 Vector Genomes/m2 1e15 Vector Genomes/m2 mL/1.7m2 L/1.7m2 mg/1.7m2 g/1.7m2 Units/1.7m2 mmol/1.7m2 mEq/1.7m2 mcg/1.7m2 kJ/1.7m2 Int'l Units/1.7m2 Million Units/1.7m2 kcal/1.7m2 ng/1.7m2 mg PE/1.7m2 milli-units/1.7m2 pg/1.7m2 Each/1.7m2 KBq/1.7m2 MBq/1.7m2 GBq/1.7m2 mcL/1.7m2 IR/1.7m2 BAU/1.7m2 Million Int'l Units/1.7m2 Kilo Int'l Units/1.7m2 mL/kg (IDL) L/kg (IDL) mg/kg (IDL) g/kg (IDL) Units/kg (IDL) mmol/kg (IDL) mEq/kg (IDL) mcg/kg (IDL) Int'l Units/kg (IDL) Million Units/kg (IDL) Kcal/kg (IDL) ng/kg (IDL) mg PE/kg (IDL) milli-units/kg (IDL) pg/kg (IDL) mg/m2 (IDL) mL/kg (ADJ) L/kg (ADJ) mg/kg (ADJ) g/kg (ADJ) Units/kg (ADJ) mmol/kg (ADJ) mEq/kg (ADJ) mcg/kg (ADJ) Int'l Units/kg (ADJ) Million Units/kg (ADJ) Kcal/kg (ADJ) ng/kg (ADJ) mg PE/kg (ADJ) milli-units/kg (ADJ) pg/kg (ADJ) mg/m2 (ADJ) mL/100 mL L/100 mL mg/100 mL g/100 mL Units/100 mL mmol/100 mL mEq/100 mL mcg/100 mL kJ/100 mL Int'l Units/100 mL Million Units/100 mL kcal/100 mL ng/100 mL mg PE/100 mL milli-units/100 mL pg/100 mL KBq/100 mL MBq/100 mL GBq/100 mL mcL/100 mL IR/100 mL BAU/100 mL Million Int'l Units/100 mL Kilo Int'l Units/100 mL mL/oz L/oz mg/oz g/oz Units/oz mmol/oz mEq/oz mcg/oz kJ/oz Int'l Units/oz Million Units/oz kcal/oz ng/oz mg PE/oz milli-units/oz pg/oz KBq/oz MBq/oz GBq/oz mcL/oz IR/oz BAU/oz Million Int'l Units/oz Kilo Int'l Units/oz mL/kg/min L/kg/min mg/kg/min g/kg/min Units/kg/min mmol/kg/min mEq/kg/min mcg/kg/min kJ/kg/min Int'l Units/kg/min Million Units/kg/min kcal/kg/min ng/kg/min mg PE/kg/min milli-units/kg/min pg/kg/min KBq/kg/min MBq/kg/min GBq/kg/min mcL/kg/min mL/kg/min (IDL) L/kg/min (IDL) mg/kg/min (IDL) g/kg/min (IDL) Units/kg/min (IDL) mmol/kg/min (IDL) mEq/kg/min (IDL) mcg/kg/min (IDL) Int'l Units/kg/min (IDL) Million Units/kg/min (IDL) Kcal/kg/min (IDL) ng/kg/min (IDL) mg PE/kg/min (IDL) milli-units/kg/min (IDL) pg/kg/min (IDL) mL/kg/min (ADJ) L/kg/min (ADJ) mg/kg/min (ADJ) g/kg/min (ADJ) Units/kg/min (ADJ) mmol/kg/min (ADJ) mEq/kg/min (ADJ) mcg/kg/min (ADJ) Int'l Units/kg/min (ADJ) Million Units/kg/min (ADJ) Kcal/kg/min (ADJ) ng/kg/min (ADJ) mg PE/kg/min (ADJ) milli-units/kg/min (ADJ) pg/kg/min (ADJ) IR/kg/min BAU/kg/min Million Int'l Units/kg/min Kilo Int'l Units/kg/min mL/m2/min L/m2/min mg/m2/min g/m2/min Units/m2/min mmol/m2/min mEq/m2/min mcg/m2/min kJ/m2/min Int'l Units/m2/min Million Units/m2/min kcal/m2/min ng/m2/min mg PE/m2/min milli-units/m2/min pg/m2/min KBq/m2/min MBq/m2/min GBq/m2/min mcL/m2/min mL/1.7m2/min L/1.7m2/min mg/1.7m2/min g/1.7m2/min Units/1.7m2/min mmol/1.7m2/min mEq/1.7m2/min mcg/1.7m2/min kJ/1.7m2/min Int'l Units/1.7m2/min Million Units/1.7m2/min kcal/1.7m2/min ng/1.7m2/min mg PE/1.7m2/min milli-units/1.7m2/min pg/1.7m2/min KBq/1.7m2/min MBq/1.7m2/min GBq/1.7m2/min mSv mGy mcL/1.7m2/min mg of pseudoephedrine IR/m2/min BAU/m2/min Million Int'l Units/m2/min Kilo Int'l Units/m2/min IR/1.7m2/min BAU/1.7m2/min Million Int'l Units/1.7m2/min Kilo Int'l Units/1.7m2/min mL/kg/hr L/kg/hr mg/kg/hr g/kg/hr Units/kg/hr mmol/kg/hr mEq/kg/hr mcg/kg/hr kJ/kg/hr Int'l Units/kg/hr Million Units/kg/hr kcal/kg/hr ng/kg/hr mg PE/kg/hr milli-units/kg/hr pg/kg/hr KBq/kg/hr MBq/kg/hr GBq/kg/hr mcL/kg/hr mL/kg/hr (IDL) L/kg/hr (IDL) mg/kg/hr (IDL) g/kg/hr (IDL) Units/kg/hr (IDL) mmol/kg/hr (IDL) mEq/kg/hr (IDL) mcg/kg/hr (IDL) Int'l Units/kg/hr (IDL) Million Units/kg/hr (IDL) Kcal/kg/hr (IDL) ng/kg/hr (IDL) mg PE/kg/hr (IDL) milli-units/kg/hr (IDL) pg/kg/hr (IDL) mL/kg/hr (ADJ) L/kg/hr (ADJ) mg/kg/hr (ADJ) g/kg/hr (ADJ) Units/kg/hr (ADJ) mmol/kg/hr (ADJ) mEq/kg/hr (ADJ) mcg/kg/hr (ADJ) Int'l Units/kg/hr (ADJ) Million Units/kg/hr (ADJ) Kcal/kg/hr (ADJ) ng/kg/hr (ADJ) mg PE/kg/hr (ADJ) milli-units/kg/hr (ADJ) pg/kg/hr (ADJ) IR/kg/hr BAU/kg/hr Million Int'l Units/kg/hr Kilo Int'l Units/kg/hr mL/m2/hr L/m2/hr mg/m2/hr g/m2/hr Units/m2/hr mmol/m2/hr mEq/m2/hr mcg/m2/hr kJ/m2/hr Int'l Units/m2/hr Million Units/m2/hr kcal/m2/hr ng/m2/hr mg PE/m2/hr milli-units/m2/hr pg/m2/hr KBq/m2/hr MBq/m2/hr GBq/m2/hr mcL/m2/hr mL/1.7m2/hr L/1.7m2/hr mg/1.7m2/hr g/1.7m2/hr Units/1.7m2/hr mmol/1.7m2/hr mEq/1.7m2/hr mcg/1.7m2/hr kJ/1.7m2/hr Int'l Units/1.7m2/hr Million Units/1.7m2/hr kcal/1.7m2/hr ng/1.7m2/hr mg PE/1.7m2/hr milli-units/1.7m2/hr pg/1.7m2/hr KBq/1.7m2/hr MBq/1.7m2/hr GBq/1.7m2/hr mcL/1.7m2/hr IR/1.7m2/hr BAU/1.7m2/hr Million Int'l Units/1.7m2/hr Kilo Int'l Units/1.7m2/hr IR/m2/hr BAU/m2/hr Million Int'l Units/m2/hr Kilo Int'l Units/m2/hr mL/kg/day L/kg/day mg/kg/day g/kg/day Units/kg/day mmol/kg/day mEq/kg/day mcg/kg/day kJ/kg/day Int'l Units/kg/day Million Units/kg/day kcal/kg/day ng/kg/day mg PE/kg/day milli-units/kg/day pg/kg/day Inch/kg/day KBq/kg/day MBq/kg/day GBq/kg/day mL/kg/day (IDL) L/kg/day (IDL) mg/kg/day (IDL) g/kg/day (IDL) Units/kg/day (IDL) mmol/kg/day (IDL) mEq/kg/day (IDL) mcg/kg/day (IDL) Int'l Units/kg/day (IDL) Million Units/kg/day (IDL) Kcal/kg/day (IDL) ng/kg/day (IDL) mg PE/kg/day (IDL) milli-units/kg/day (IDL) pg/kg/day (IDL) mL/kg/day (ADJ) L/kg/day (ADJ) mg/kg/day (ADJ) g/kg/day (ADJ) Units/kg/day (ADJ) mmol/kg/day (ADJ) mEq/kg/day (ADJ) mcg/kg/day (ADJ) Int'l Units/kg/day (ADJ) Million Units/kg/day (ADJ) Kcal/kg/day (ADJ) ng/kg/day (ADJ) mg PE/kg/day (ADJ) milli-units/kg/day (ADJ) pg/kg/day (ADJ) mcL/kg/day IR/kg/day BAU/kg/day Million Int'l Units/kg/day mL/m2/day L/m2/day mg/m2/day g/m2/day Units/m2/day mmol/m2/day mEq/m2/day mcg/m2/day kJ/m2/day Int'l Units/m2/day Million Units/m2/day kcal/m2/day ng/m2/day mg PE/m2/day milli-units/m2/day pg/m2/day KBq/m2/day MBq/m2/day GBq/m2/day mcL/m2/day mL/1.7m2/day L/1.7m2/day mg/1.7m2/day g/1.7m2/day Units/1.7m2/day mmol/1.7m2/day mEq/1.7m2/day mcg/1.7m2/day kJ/1.7m2/day Int'l Units/1.7m2/day Million Units/1.7m2/day kcal/1.7m2/day ng/1.7m2/day mg PE/1.7m2/day milli-units/1.7m2/day pg/1.7m2/day KBq/1.7m2/day MBq/1.7m2/day GBq/1.7m2/day mcL/1.7m2/day mL/oz/day L/oz/day mg/oz/day g/oz/day Units/oz/day mmol/oz/day mEq/oz/day mcg/oz/day kJ/oz/day Int'l Units/oz/day Million Units/oz/day kcal/oz/day ng/oz/day mg PE/oz/day milli-units/oz/day pg/oz/day KBq/oz/day MBq/oz/day GBq/oz/day mcL/oz/day IR/m2/day BAU/m2/day Million Int'l Units/m2/day Kilo Int'l Units/m2/day IR/1.7m2/day BAU/1.7m2/day Million Int'l Units/1.7m2/day Kilo Int'l Units/1.7m2/day IR/oz/day BAU/oz/day Million Int'l Units/oz/day Kilo Int'l Units/oz/day kJ/30 mL kcal/30 mL Gy-cm2 mL/cm2 mg/cm2 mOsmol each tablet capsule drop tsp puff suppository spray Squirt inch patch Act ampule Bar Bottle Can Device enema Gallon Inhaler kit lb lozenge oz packet Stick strip Tbsp Tube vial Wafer Container Syringe Package applicator cm Applicatorful Troche millicurie Intra Uterine Device Part m Film Million Cells Dose mm IR BAU kg cm2 Imperial Gallon kJ PFU Piece Million PFU Doses/Fill Cartridge Thousand Units Lipoprotein Lipase Releasing Unit Scoop Million Int'l Units mm2 Pump fluid ounce Product Bag mcmol 1e12 Vector Genomes Vector Genomes millicurie/kg millicurie/m2 millicurie/1.7m2 microcurie microcurie/kg microcurie/m2 microcurie/1.7m2 Canister mcg DFE Billion Cells Application Box Capful Inhalation Lancet Needle Pad Pen Piece of gum Ring Swab Sachet Implant Insert Pools Kilo Int'l Units Kilo Int'l Units/kg/day 1e11 Vector Genomes 1e13 Vector Genomes 1e14 Vector Genomes 1e15 Vector Genomes Cells EIN Million EIN EIN/kg/day None / Other
11	MED_DISP_ROUTE	VARCHAR	No
	This item stores the medication dispense medication dose route.
12	MED_DISP_ROUTE_ID_C_NAME	VARCHAR	No
	This item stores the medication dispense mapped medication dose route. May contain organization-specific values: Yes
13	MED_DISP_FREQ	VARCHAR	No
	This item stores the medication dispense medication dose frequency.
14	MED_DISP_FREQ_ID	VARCHAR	No
	This item stores the medication dispense mapped medication dose frequency.
15	MED_DISP_FREQ_ID_FREQ_NAME	VARCHAR	No
	The name of the frequency record.
16	MED_DISP_FORM	VARCHAR	No
	This item stores the medication dispense medication form.
17	MED_DISP_FORM_ID_C_NAME	VARCHAR	No
	This item stores the medication dispense mapped medication form. May contain organization-specific values: Yes Category Entries: Non-Scheduled Medication C-I No Accepted Medical Use C-II High Abuse Potential C-III Moderate Dependence C-IV Limited Dependence C-V Limited Abuse Potential Undeterminable C-VI State Scheduled C-VII State Scheduled C-VIII State Scheduled C-IX State Scheduled C-X State Scheduled
18	MED_DISP_STRN	NUMERIC	No
	This item stores the medication dispense medication strength.
19	MED_DISP_STRN_UNT_C_NAME	VARCHAR	No
	This item stores the medication dispense mapped medication strength units. The category values for this column were already listed for column: MED_DISP_UNIT_ID_C_NAME
20	MED_DISP_REFILLS	NUMERIC	No
	This item stores number of refills allowed for this medication.
21	MED_DISP_AS_WRIT_YN	VARCHAR	No
	This item stores whether the medication was dispensed as written. May contain organization-specific values: No Category Entries: No Yes
22	MED_DISP_DATE	DATETIME	No
	This item stores the medication dispense date.
23	MED_DISP_QTY_DISP	NUMERIC	No
	This item stores the medication quantity dispensed.
24	MED_DISP_UNIT_C_NAME	VARCHAR	No
	This item stores the mapped medication dispense units. The category values for this column were already listed for column: MED_DISP_UNIT_ID_C_NAME
25	MED_DISP_DAYS_SUPL	NUMERIC	No
	This item stores the day supply for this medication.
26	MED_DISP_WRTN_DATE	DATETIME	No
	This item stores the medication written date.
27	MED_DISP_AUTH_QUA_C_NAME	VARCHAR	No
	This item stores the medication prior authorization qualifier. May contain organization-specific values: No Category Entries: Prior Authorization Promotion Number
28	MED_DISP_AUTH_DATA	VARCHAR	No
	This item stores the prior authorization data.
29	MED_DISP_PHARM_ID	VARCHAR	No
	This item stores the pharmacy Identifier.
30	MED_DISP_PROV_ID	VARCHAR	No
	This item stores the provider identifier.
31	MED_DISP_ORD_ID	NUMERIC	No
	This item stores the Epic Order identifier associated with this prescription.
32	MED_DISP_PRESC_NUM	VARCHAR	No
	This item stores the medication prescription number.
33	MED_DISP_PRIM_DX	VARCHAR	No
	The primary diagnosis code for the medication in the medication dispensed segment of the external e-prescription, received through the incoming e-prescribing interface. This column is being replaced by table MED_DISP_ALL_DX_CODES.
34	MED_DIS_PRIM_DX_SYS	VARCHAR	No
	The coding system used for the primary diagnosis code for the medication in the medication dispensed segment of the external e-prescription, received through the incoming e-prescribing interface. This column is being replaced by table MED_DISP_ALL_DX_CODE_SYS.
35	MED_DISP_PRIM_DX_ID_DX_NAME	VARCHAR	No
	The name of the diagnosis.
36	MED_DISP_SEC_DX	VARCHAR	No
	The secondary diagnosis code for the medication in the medication dispensed segment of the external e-prescription, received through the incoming e-prescribing interface. This column is being replaced by table MED_DISP_ALL_DX_CODES.
37	MED_DIS_SEC_DX_SYS	VARCHAR	No
	The coding system used for the secondary diagnosis code for the medication in the medication dispensed segment of the external e-prescription, received through the incoming e-prescribing interface. This column is being replaced by table MED_DISP_ALL_DX_CODE_SYS.
38	MED_DISP_SEC_DX_ID_DX_NAME	VARCHAR	No
	The name of the diagnosis.
39	MED_DISP_LASTFIL_DT	DATETIME	No
	The date on which the medication in the medication dispensed segment of the external e-prescription, received through the incoming e-prescribing interface, was last filled.
40	MED_DISP_DEA_CODE_C_NAME	VARCHAR	No
	The DEA schedule for the medication in the medication dispensed segment of the external e-prescription received through the incoming e-prescribing interface. The category values for this column were already listed for column: MED_DISP_FORM_ID_C_NAME
41	MED_DISP_EAR_FIL_DT	DATETIME	No
	The first or earliest date on which the medication in the medication dispensed segment of the external e-prescription can be filled.
42	MED_DISP_IS_MIX_YN	VARCHAR	No
	This column indicates whether the medication in the medication dispensed segment of the external e-prescription, received through the incoming e-prescribing interface, is a mixture. The category values for this column were already listed for column: MED_DISP_AS_WRIT_YN
43	MED_DISP_IS_SUPP_YN	VARCHAR	No
	This column indicates whether the medication in the medication dispensed segment of the external e-prescription, received through the incoming e-prescribing interface, is a medication supply (for example, a test strip). The category values for this column were already listed for column: MED_DISP_AS_WRIT_YN
44	MED_DISP_DUR_UNIT_C_NAME	VARCHAR	No
	The unit for the duration of therapy for the medication associated with the medication dispensed segment of the external e-prescription. May contain organization-specific values: No Category Entries: Days Weeks Hours Occurrences Months Years
45	MED_DSP_ADM_UNIT_C_NAME	VARCHAR	No
	The unit of measurement for the admin amount of the medication dose in the medication dispensed segment of the external e-prescription. The category values for this column were already listed for column: MED_DISP_UNIT_ID_C_NAME
46	MED_DIS_TTLDOSUNT_C_NAME	VARCHAR	No
	The unit for the total amount for a unit dose of a medication that uses a patient's clinical measurement (for example, weight or BSA) for dosing in the medication dispensed segment of the external e-prescription. The category values for this column were already listed for column: MED_DISP_UNIT_ID_C_NAME
47	MED_DISP_DOSE_TYP_C_NAME	VARCHAR	No
	The dosing type, based on the patient's clinical measurement, used for determining the unit dose amount of the medication in the medication dispensed segment of the external e-prescription. May contain organization-specific values: Yes Category Entries: Weight-based BSA-based
48	MED_DISP_DURATION	VARCHAR	No
	The duration of therapy for the medication associated with the medication dispensed segment of the external e-prescription.
49	MED_DISP_ADMIN_AMT	VARCHAR	No
	The admin amount for a unit dose of the medication associated with the medication dispensed segment of the external e-prescription.
50	MED_DISP_TTL_DOSE	VARCHAR	No
	The total amount for a unit dose of a medication that uses a patient's clinical measurement (for example, weight or BSA) for dosing in the medication dispensed segment of the external e-prescription.
51	MED_DISP_DOSE_VALUE	VARCHAR	No
	The value of the patient's clinical measurement used for dosing a unit dose of the medication in the medication dispensed segment of the external e-prescription. For weight-based dosing, the value is stored in kilograms and for BSA-based dosing, the value is stored in square meters (m2).