MAR_ADMIN_EDITD

Description:

This table contains the original data of medication administrations that have been edited. The data is no longer a current representation of the MAR, but can be used for reporting purposes.

Primary Key

Column Name	Ordinal Position
ORDER_MED_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	ORDER_MED_ID	NUMERIC	No
	The unique ID of the medication order.
2	LINE	INTEGER	No
	The line count for the item.
3	SCHEDULED_TIME	DATETIME (Local)	No
	The scheduled time on the MAR.
4	EDITED_LINE	INTEGER	No
	The line number of the previously saved data for this administration.
5	TAKEN_TIME	DATETIME (Local)	No
	The user-specified time that the action took place.
6	SAVED_TIME	DATETIME (Local)	No
	The instant the medication administration was saved.
7	EDITD_MAR_ACTION_C_NAME	VARCHAR	No
	The medication administration record (MAR) action category number for the administration. May contain organization-specific values: Yes Category Entries: Given Missed Refused Canceled Entry Held New Bag Restarted Stopped Rate Change MAR Hold MAR Unhold Bolus Push Rate Verify See Alternative Paused Prepared Pending Automatically Held Due
8	USER_ID	VARCHAR	No
	The unique ID of the user that took action on the administration.
9	USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
10	SEC_USER_ID	VARCHAR	No
	The unique ID of the secondary user associated with this administration.
11	SEC_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
12	EDIT_MAR_DOC_USR_ID	VARCHAR	No
	User ID of the user who documented the medication administration. This item is null unless the administering user (ORD 12120) is different than the documenting user.
13	EDIT_MAR_DOC_USR_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
14	SIG	VARCHAR	No
	The dose value of the administration.
15	ROUTE_C_NAME	VARCHAR	No
	The route category number for the administration. May contain organization-specific values: Yes
16	COMMENTS	VARCHAR	No
	The comment associated with the administration.
17	REASON_C_NAME	VARCHAR	No
	The reason category number for the administration. A reason is generally required for the actions of Missed and medication administration record hold (MAR Hold), but can be configured for any action. May contain organization-specific values: Yes
18	SITE_C_NAME	VARCHAR	No
	The site category number for the administration. May contain organization-specific values: Yes Category Entries: Right Arm Left Arm Right Quadriceps Left Quadriceps Right Upper Outer Quadrant Left Upper Outer Quadrant Abdominal Tissue Port
19	INFUSION_RATE	VARCHAR	No
	The rate at which the medication was infused.
20	EDIT_MAR_RATEUNIT_C_NAME	VARCHAR	No
	The infusion rate unit category number for the administration. 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 mcSv Sv mcGy cGy Gy mRAD RAD mg of pseudoephedrine mg of ephedrine 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 mcGy-cm2 mGy-cm2 cGy-cm2 dGy-cm2 mcGy-m2 mGy-m2 cGy-m2 dGy-m2 Gy-m2 mRAD-cm2 RAD-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 mGy-cm cGy-cm dGy-cm Gy-cm mGy-m cGy-m dGy-m Gy-m Hounsfield Units None / Other
21	DOSE_UNIT_C_NAME	VARCHAR	No
	The dose unit category number for the administration. The category values for this column were already listed for column: EDIT_MAR_RATEUNIT_C_NAME
22	EDITD_MAR_DURATION	VARCHAR	No
	The length of time the administration took to complete or infuse.
23	EDITD_DUR_UNIT_C_NAME	VARCHAR	No
	The duration unit category number for the administration. May contain organization-specific values: No Category Entries: Minutes Hours Days
24	EDIT_MAR_IMM_LNK_ID	NUMERIC	No
	The unique ID of the linked immunization that is associated with this administration.
25	EDITD_DUE_ACTION_C_NAME	VARCHAR	No
	The scheduled Medication administration record (MAR) action at a due time category number for the administration. This column will only be populated if Duration-Based Due Actions are configured (LSD 34640 and 34641). The category values for this column were already listed for column: EDITD_MAR_ACTION_C_NAME
26	EDITED_MAR_BILL_ID_PROV_NAME	VARCHAR	No
	The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
27	EDIT_BLOOD_INFO_LN	INTEGER	No
	This item stores the line pointer to the blood information, for this edit (ORD 13000).
28	EDITED_CYCLIC_RATE_PARENT_LINE	INTEGER	No
	The line number of the parent administration of this cyclic rate change due time.
29	EDITED_ORIGINAL_AMOUNT	VARCHAR	No
	Edit history of the original amount if weight-based dose conversion or other unit conversion took place.
30	EDITED_ORIGINAL_UNIT_C_NAME	VARCHAR	No
	Edited value of the original unit The category values for this column were already listed for column: EDIT_MAR_RATEUNIT_C_NAME
31	EDIT_CUP_IDENT	VARCHAR	No
	This is the ID that dictates which cup an administration belongs to.
32	EDITED_SCHEDULED_DOSE	VARCHAR	No
	The dose that was scheduled to be due for the administration of an order with multiple possible doses.
33	EDITED_SCHEDULED_DOSE_UNIT_C_NAME	VARCHAR	No
	The scheduled dose unit category ID for the administration. The category values for this column were already listed for column: EDIT_MAR_RATEUNIT_C_NAME
34	EDITED_CONCENTRATION	VARCHAR	No
	The concentration for the administration.
35	EDITED_DUR_BASED_PARENT_LINE	INTEGER	No
	The line number of the administration that created this duration-based due time.
36	EDITED_DUR_BASED_CHILD_LINE	INTEGER	No
	The line number of the duration-based due time administration that was created by this administration.
37	EDITED_CYCLIC_RATE_CHILD_LINE	INTEGER	No
	The line number of the following child administration of this cyclic rate change due time.
38	EDITED_SCHEDULED_AMOUNT	VARCHAR	No
	Scheduled administration amount when the order has multiple doses.
39	EDITED_SCHEDULED_AMOUNT_UNIT_C_NAME	VARCHAR	No
	Scheduled administration amount unit when the order has multiple doses. The category values for this column were already listed for column: EDIT_MAR_RATEUNIT_C_NAME
40	EDITED_MAR_PEND_USER_ID	VARCHAR	No
	The unique ID of the user with deferred signoff for the administration.
41	EDITED_MAR_PEND_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
42	EDITED_MAR_PEND_SECOND_USER_ID	VARCHAR	No
	The unique ID of the verifying user with deferred signoff for the administration.
43	EDITED_MAR_PEND_SECOND_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
44	EDIT_TCI_CONCENTRATION	VARCHAR	No
	Edited target concentration of the TCI pump
45	EDIT_TCI_CONCENTRATION_UNIT_C_NAME	VARCHAR	No
	Edited target concentration unit of the TCI pump The category values for this column were already listed for column: EDIT_MAR_RATEUNIT_C_NAME
46	EDIT_TCI_MODEL_C_NAME	VARCHAR	No
	Edited model used for the TCI pump May contain organization-specific values: Yes Category Entries: Marsh Schnider Kataria Paedfusor Minto Kim Eleveld
47	EDIT_TCI_TARGET_C_NAME	VARCHAR	No
	Edited TCI Target for a TCI Target May contain organization-specific values: Yes Category Entries: Effect-Site Plasma
48	EDIT_MAR_PSP_IDENT	VARCHAR	No
	This is the identifier that dictates which Patient-Specific Package belongs to an administration. This can also be a comma delimited list of identifiers if multiple patient-specific packages are scanned for a single administration.
49	EDIT_MAR_DUAL_SIGN_SOURCE_C_NAME	VARCHAR	No
	The source of the device the second signer used when approving the administration. For example, whether their signoff took place from a remote location May contain organization-specific values: No Category Entries: signed remotely
50	EDIT_PEND_DUE_ACTION_C_NAME	VARCHAR	No
	Audit trail - the MAR action that was being documented when the administration pended. The category values for this column were already listed for column: EDITD_MAR_ACTION_C_NAME
51	EDIT_DUR_BASED_PARENT_ORDER_ID	NUMERIC	No
	For a duration-based child administration, this item stores the order ID of its parent. When the duration-based parent and child administrations are on the same order, this item is null.