ORDER_PROC_5

Description:

The ORDER_PROC_5 table enables you to report on the procedures ordered in the clinical system. This procedure table has the same basic structure as ORDER_PROC, but was created as a fifth table to prevent ORDER_PROC_4 from getting any larger.

Primary Key

Column Name	Ordinal Position
ORDER_ID	1

Column Information

	Name	Type	Discontinued?
1	ORDER_ID	NUMERIC	No
	The unique identifier for the order record.
2	FUTURE_RELATIVE_EXPECTED_DT_C_NAME	VARCHAR	No
	Holds a category value for the expected completion date. This may be subtly different from the expected date (ORDER_PROC.FUT_EXPECT_COMP_DT) for things like "in 3 months", which could be Start Date+90 days (S+90), Start date+91 days (S+91), or Start date + 92 days (S+92) depending on the current date. May contain organization-specific values: Yes Category Entries: On Date Other (specify) Today Tomorrow 1 Week 2 Weeks 3 Weeks 4 Weeks 5 Weeks 6 Weeks 1 Month 2 Months 3 Months 4 Months 5 Months 6 Months 7 Months 8 Months 9 Months 10 Months 11 Months 12 Months 13 Months 14 Months 15 Months 16 Months 17 Months 18 Months 1 Year 2 Years 3 Years 4 Years Before Surgery Before Surgery Before Next Appt
3	FUTURE_EXPECTED_DATE_COMMENT_C_NAME	VARCHAR	No
	Holds a category value for the comment part of expected date. This will include categories based on scheduling comments like "Before Surgery", "After Consult", etc. The category values for this column were already listed for column: FUTURE_RELATIVE_EXPECTED_DT_C_NAME
4	FUTURE_EXPECTED_DATE_DETAILS	VARCHAR	No
	This item holds the free-text details entered if the future expected date comment (FUTURE_EXPECTED_DATE_COMMENT_C) is "Other (Specify)".
5	MODIFY_TRACK_C_NAME	VARCHAR	No
	Flag used to denote if the order was modified or reordered. May contain organization-specific values: No Category Entries: REORDERED MODIFIED
6	INCOMPLETE_CHILD_ORDERS	INTEGER	No
	Store the number of child orders which have not yet reached completed/canceled status. meaning they are either not yet released or are currently active.
7	ORDER_INST_UTC_DTTM	DATETIME (UTC)	No
	The instant when the order was created in UTC.
8	MINUTES_BTWN_SCHED_AND_COLL	INTEGER	No
	The number of minutes between the scheduled and collected instants for a lab. Negative values indicate early collection.
9	APPT_WINDOW_START_TIME	DATETIME (Local)	No
	This is the start of the appointment window for the preferred appointment window.
10	OVERREAD_SRC_ORD_ID	NUMERIC	No
	Stores the order record ID that is marked for imaging overread.
11	APPT_WINDOW_END_TIME	DATETIME (Local)	No
	This is the end of the appointment window for the preferred appointment window.
12	PROC_ESTIMATE_ID	NUMERIC	No
	A link to a patient estimate record that contains patient cost estimate information for procedure orders.
13	SHOULD_GENERATE_PAT_EST_YN	VARCHAR	No
	A flag used for pended orders that indicates that the order should generate a patient estimate record when it is fully signed. May contain organization-specific values: No Category Entries: No Yes
14	FINANCIAL_CLEARANCE_STATUS_C_NAME	VARCHAR	No
	Records the financial clearance status of an order May contain organization-specific values: Yes Category Entries: Cleared Pending
15	FINANCIAL_CLEARANCE_UTC_DTTM	DATETIME (UTC)	No
	Records the UTC instant an order was financially cleared
16	FNDAVTR_DOC_INFO_ID	VARCHAR	No
	Stores the Document ID of the image for the findings avatar
17	IMG_PUBLIC_RSLT_DTTM	DATETIME (Local)	No
	The instant in local time at which the imaging result was made public, as defined by the order's study status (e.g. physician finalized the exam) as configured by the imaging analyst team (I RDF 192).
18	ORDER_RECEIVED_DTTM	DATETIME (Local)	No
	The date and time the order was received.
19	ACTV_EXCLUDE_FROM_CDS_REASON_C_NAME	VARCHAR	No
	The Exclude From Decision Support reason for the order. It will be either 1 - Unsuccessful Attempt represents an order that was not successfully completed. or 2 - Documented on Wrong Patient represents the order's result information was documented on the incorrect patient. May contain organization-specific values: No Category Entries: Unsuccessful Attempt Documented on Wrong Patient
20	ACTV_EXCLUDE_FROM_CDS_UTC_DTTM	DATETIME (UTC)	No
	The instance in UTC when the "Exclude From Decision Support" was updated on the order record.
21	ACTV_EXCLUDE_FROM_CDS_DTTM	DATETIME (Local)	No
	The instance when the "Exclude From Decision Support" was updated on the order record.
22	LEAVE_TYPE_C_NAME	VARCHAR	No
	The type of medical leave being ordered. May contain organization-specific values: Yes Category Entries: Outpatient Sick Leave Hospitalization Leave Maternity Leave Light Duty Only Excuses Only
23	LEAVE_START_DATE	DATETIME	No
	Start date of the medical leave.
24	LEAVE_END_DATE	DATETIME	No
	End date of the medical leave.
25	LEAVE_DURATION	INTEGER	No
	Duration of the medical leave in days.
26	LEAVE_LIGHTDUTY_YN	VARCHAR	No
	Whether the medical leave also has a light duty period. The category values for this column were already listed for column: SHOULD_GENERATE_PAT_EST_YN
27	LEAVE_LIGHTDUTY_START_DATE	DATETIME	No
	Start date of the light duty period.
28	LEAVE_LIGHTDUTY_END_DATE	DATETIME	No
	End date of the light duty period.
29	LEAVE_LIGHTDUTY_DURATION	INTEGER	No
	Duration of the light duty period in days.
30	LEAVE_EXCUSED_ACTIVITIES_YN	VARCHAR	No
	Whether the patient should be excused from doing specific activities during the leave. The category values for this column were already listed for column: SHOULD_GENERATE_PAT_EST_YN
31	LEAVE_EXCUSED_START_DATE	DATETIME	No
	Start date of the excused activities period.
32	LEAVE_EXCUSED_END_DATE	DATETIME	No
	End date of the excuse period.
33	LEAVE_EXCUSED_DURATION	INTEGER	No
	Duration of the excuse period in days.
34	LEAVE_EXCUSED_COMMENTS	VARCHAR	No
	Comments about the excused activities for the excuse period.
35	DELIVERY_REQUEST_ORDER_ID	NUMERIC	No
	The order ID of the blood component order this order record is requesting a delivery from.
36	DELIVERY_REQUEST_AMOUNT	INTEGER	No
	The number of units being requested from the blood component order record.
37	ORIGINATING_ORD_ID	NUMERIC	No
	This column contains the originating order ID. It is related conceptually to ORDER_PROC_2.ORIGINAL_ORDER_ID, but rather than pointing back to the previous order ID at the same level in the order tree hierarchy, this column will point back to the initial order created by the ordering end user. Use this column to find out information about the initial order, or to determine if an order went through a change procedure workflow which generated new order records.
38	PROC_CHANGED_YN	VARCHAR	No
	This column determines whether the orderable procedure was changed as part of a change procedure workflow that generated new order records. The column will be set to 1 - Yes if a new procedure was selected during the change procedure workflow step. If the procedure was kept and other details were changed, this column will be populated with 0 - No. If the order did not go through a change procedure workflow which generated new order records, this column will be null. The category values for this column were already listed for column: SHOULD_GENERATE_PAT_EST_YN
39	ACTIVE_PROC_TYPE_C_NAME	VARCHAR	No
	This item holds the category type of the active procedure order. Only active procedure type orders will be contained in this item. Medications are excluded. The categories separate order type in parent/child/normal and IP/OP order type. May contain organization-specific values: No Category Entries: Active OP Parent Order Active OP Child Order Active OP Normal Order Active IP Parent Order Active IP Child Order
40	DELIVERY_REQUEST_UNIT_C_NAME	VARCHAR	No
	The unit category of the blood component order record being requested. 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
41	BILL_AREA_ID	NUMERIC	No
	The bill area this order is associated with.
42	BILL_AREA_ID_BILL_AREA_NAME	VARCHAR	No
	The record name of this bill area, financial subdivision, or financial division.
43	ADT_ORDER_TYPE_C_NAME	VARCHAR	No
	The ADT (admission, discharge, transfer) order type category ID for the order, indicating what type of patient movement this order is intended for. May contain organization-specific values: No Category Entries: Admission, Transfer, Update Leave of Absence Discharge Telemetry
44	BI_PRELIM_OUTCOME_C_NAME	VARCHAR	No
	Stores preliminary FP/FN/TP/FN/etc info for a breast imaging study. May not contain the most current data until the MQSA report has been run. May contain organization-specific values: No Category Entries: True Negative False Negative True Positive False Positive 1 False Positive 2 False Positive 1 & 2 False Positive 2 & 3 False Positive 1 & 2 & 3 N/A
45	RAD_EXAM_END_UTC_DTTM	DATETIME (UTC)	No
	The date and time an order's exam is ended in the Universal Time Coordinated (UTC) format.
46	PAT_AGE_AT_EXAM	INTEGER	No
	The age of the patient (in years) as of the date of the exam. If the exam has ended, this will be the age as of end exam. If not, this will be the age as of the scheduled appointment date. If an appointment has not been scheduled for this exam, this value will be null.
47	PRIORITIZED_UTC_DTTM	DATETIME (UTC)	No
	Stores the prioritized instant for the result in UTC
48	RESULT_UPDATE_UTC_DTTM	DATETIME (UTC)	No
	Stores the last update instant for a result in UTC
49	PROC_SVC_TYPE_CODE_C_NAME	VARCHAR	No
	This item contains a procedure service type (surgery, imaging, dental, etc.) that overrides the service type from a referral or coverage source. May contain organization-specific values: No Category Entries: Medical Care Surgical Consultation Diagnostic X-Ray Diagnostic Lab Radiation Therapy Anesthesia Surgical Assistance Other Medical Blood Charges Used Durable Medical Equipment Durable Medical Equipment Purchase Ambulatory Service Center Facility Renal Supplies in the Home Alternate Method Dialysis Chronic Renal Disease (CRD) Equipment Pre-Admission Testing Durable Medical Equipment Rental Pneumonia Vaccine Second Surgical Opinion Third Surgical Opinion Social Work Diagnostic Dental Periodontics Restorative Endodontics Maxillofacial Prosthetics Adjunctive Dental Services Health Benefit Plan Coverage Plan Waiting Period Chiropractic Chiropractic Office Visits Dental Care Dental Crowns Dental Accident Orthodontics Prosthodontics Oral Surgery Routine (Preventive) Dental Home Health Care Home Health Prescriptions Home Health Visits Hospice Respite Care Hospital Hospital - Inpatient Hospital - Room and Board Hospital - Outpatient Hospital - Emergency Accident Hospital - Emergency Medical Hospital - Ambulatory Surgical Long Term Care Major Medical Medically Related Transportation Air Transportation Cabulance Licensed Ambulance General Benefits In-vitro Fertilization MRI/CAT Scan Donor Procedures Acupuncture Newborn Care Pathology Smoking Cessation Well Baby Care Maternity Transplants Audiology Exam Inhalation Therapy Diagnostic Medical Private Duty Nursing Prosthetic Device Dialysis Otological Exam Chemotherapy Allergy Testing Immunizations Routine Physical Family Planning Infertility Abortion AIDS Emergency Services Cancer Pharmacy Free Standing Prescription Drug Mail Order Prescription Drug Brand Name Prescription Drug Generic Prescription Drug Podiatry Podiatry - Office Visits Podiatry - Nursing Home Visits Professional (Physician) Anesthesiologist Professional (Physician) Visit - Office Professional (Physician) Visit - Inpatient Professional (Physician) Visit - Outpatient Professional (Physician) Visit - Nursing Home Professional (Physician) Visit - Skilled Nursing Facility Professional (Physician) Visit - Home Psychiatric Psychiatric - Room and Board Psychotherapy Psychiatric - Inpatient Psychiatric - Outpatient Rehabilitation Rehabilitation - Room and Board Rehabilitation - Inpatient Rehabilitation - Outpatient Occupational Therapy Physical Medicine Speech Therapy Skilled Nursing Care Skilled Nursing Care - Room and Board Substance Abuse Alcoholism Drug Addiction Vision (Optometry) Frames Routine Exam Lenses Nonmedically Necessary Physical Experimental Drug Therapy Burn Care Brand Name Prescription Drug - Formulary Brand Name Prescription Drug - Non-Formulary Independent Medical Evaluation Partial Hospitalization (Psychiatric) Day Care (Psychiatric) Cognitive Therapy Massage Therapy Pulmonary Rehabilitation Cardiac Rehabilitation Pediatric Nursery Skin Orthopedic Cardiac Lymphatic Gastrointestinal Endocrine Neurology Eye Invasive Procedures Gynecological Obstetrical Obstetrical/Gynecological Mail Order Prescription Drug: Brand Name Mail Order Prescription Drug: Generic Physician Visit - Office: Sick Physician Visit - Office: Well Coronary Care Private Duty Nursing - Inpatient Private Duty Nursing - Home Surgical Benefits - Professional (Physician) Surgical Benefits - Facility Mental Health Provider - Inpatient Mental Health Provider - Outpatient Mental Health Facility - Inpatient Mental Health Facility - Outpatient Substance Abuse Facility - Inpatient Substance Abuse Facility - Outpatient Screening X-ray Screening laboratory Mammogram, High Risk Patient Mammogram, Low Risk Patient Flu Vaccination Eyewear and Eyewear Accessories Case Management Dermatology Durable Medical Equipment Diabetic Supplies Generic Prescription Drug - Formulary Generic Prescription Drug - Non-Formulary Allergy Intensive Care Mental Health Neonatal Intensive Care Oncology Physical Therapy Pulmonary Renal Residential Psychiatric Treatment Transitional Care Transitional Nursery Care Urgent Care
50	PERFORMED_IN_ISO_YN	VARCHAR	No
	Stores whether the imaging exam was performed in isolation. The category values for this column were already listed for column: SHOULD_GENERATE_PAT_EST_YN
51	RFL_FIRST_APPOINTMENT_BY_DATE	DATETIME	No
	The date that the first appointment for the referral should occur by.
52	RFL_LIVING_SITUATION_C_NAME	VARCHAR	No
	Describes who the patient or child lives with for this psychology referral order. May contain organization-specific values: Yes No Entries Defined
53	RFL_CHILD_SERVICE_C_NAME	VARCHAR	No
	Indicates the child welfare service role in connection with child psychology services for the psychology referral order. May contain organization-specific values: Yes No Entries Defined
54	RFL_PARENTAL_RESP_C_NAME	VARCHAR	No
	Indicates which entity has parental responsibility for the patient for the psychology referral order. May contain organization-specific values: Yes No Entries Defined
55	RFL_CONSENT_TO_TREAT_STAT_C_NAME	VARCHAR	No
	Indicates the status of obtaining the patient's consent in connection with the referral's transfer of medical record information for the psychology referral order. May contain organization-specific values: Yes No Entries Defined
56	RFL_CASE_WORKER_NAME	VARCHAR	No
	The case manager of the child psychology case for this psychology referral order.
57	LUNG_OUTCOME_C_NAME	VARCHAR	No
	The positive/negative outcome for a lung imaging study. May contain organization-specific values: No Category Entries: True Negative False Negative True Positive False Positive 1 False Positive 2 False Positive 3 False Positive 4 False Positive 1 & 2 & 4 False Positive 1 & 3 & 4 False Positive 1 & 2 & 3 & 4 False Positive 1 & 2a False Positive 1 & 2b False Positive 1 & 2b & 3 Not Applicable
58	MAM_INDICATION_C_NAME	VARCHAR	No
	Indication for mammography exam specific to NMD version 2. Category values that can be mapped to BI-RADS indication for exam. May contain organization-specific values: No Category Entries: Routine Screening Additional evaluation of recent screening mammogram Diagnostic: Short interval followup Diagnostic: Evaluation of breast problem Diagnostic: Previous history of breast cancer Unknown Unknown - Deprecated
59	HAS_LAB_SPEC_YN	VARCHAR	No
	Indicates whether the order or any of the linked performable orders have a lab specimen. 'Y' indicates that the order or one of the linked performable orders has a lab specimen. 'N' indicates that the order does not have a linked lab specimen and no linked performable order has a lab specimen. The category values for this column were already listed for column: SHOULD_GENERATE_PAT_EST_YN
60	HAS_RSLT_CNCT_YN	VARCHAR	No
	Indicates whether the order has a resulted contact. 'Y' indicates that the order has at least one contact of type 2-Resulted. 'N' indicates that the order does not have any contacts of type 2-Resulted. The category values for this column were already listed for column: SHOULD_GENERATE_PAT_EST_YN
61	HAS_CORR_YN	VARCHAR	No
	Indicates whether the order has a correction. 'Y' indicates that the order has at least one contact with procedure result status equal to 4-Edited or 5-Edited Result - FINAL. 'N' indicates that the order does not have any contacts with procedure result status equal to 4-Edited or 5-Edited Result - FINAL. The category values for this column were already listed for column: SHOULD_GENERATE_PAT_EST_YN
62	LAB_REDRAW_REASON_C_NAME	VARCHAR	No
	The last redraw reason category ID for the order. May contain organization-specific values: Yes
63	PANEL_RELEASE_DTTM	DATETIME (Local)	No
	If this order is a performable order on a test panel, this item stores the local date and time when the associated orderable was released. This column will only be populated for performable orders on test panels. It will not be populated for the orderable order on test panels.
64	PANEL_RELEASE_UTC_DTTM	DATETIME (UTC)	No
	If this order is a performable order on a test panel, this item contains the UTC date and time when the associated orderable was released. This column will only be populated for performable orders on test panels. It will not be populated for the orderable order on test panels.
65	LAST_RSLT_LAB_ID	NUMERIC	No
	The unique ID of the resulting lab from the last contact where the procedure result status is not null.
66	LAST_RSLT_LAB_ID_LLB_NAME	VARCHAR	No
	Interface laboratory name.
67	MAM_TECH_IMG_DOC_REV_DTTM	DATETIME (UTC)	No
	Stores the instant when the last technologist image documentation was reviewed.
68	MAM_TECH_IMG_DOC_REV_USER_ID	VARCHAR	No
	Stores the user ID of the last person to review the technologist imaging documentation.
69	MAM_TECH_IMG_DOC_REV_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
70	NMD_3_MAM_INDICATION_C_NAME	VARCHAR	No
	Indication for mammography exam specific to NMD version 3. Category values that can be mapped to BI-RADS indication for exam. . May contain organization-specific values: No Category Entries: Screening Diagnostic: Evaluation of an abnormal finding at screening Diagnostic: Surveillance imaging for a probably benign finding or following breast conservation treatment Diagnostic: Evaluation of breast problem-palpable abnormality Diagnostic: Evaluation of breast problem-other Unknown