ORDER_PROC_3

Description:

The ORDER_PROC_3 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 third table to prevent ORDER_PROC_2 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	MAMMO_OUTCOME_C_NAME	VARCHAR	No
	This column stores the outcome (e.g. FP/FN/TP/FN/etc) for a mammography study. This column is used to link to the ZC_MAMMO_OUTCOME table. 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
3	OLD_RAD_STAT_C_NAME	VARCHAR	No
	This stores the category ID for the imaging study status (e.g. technician ended the exam, reading physician finalized the exam) before the order was canceled. This will only be populated for canceled imaging orders. This column is used to link to the ZC_RADIOLOGY_STS table. May contain organization-specific values: No Category Entries: Ordered No Show Scheduled Arrived Exam Begun Procedure Started Discontinued Procedure Finished Exam Ended ----- BEGIN READING PALETTE STATUSES ----- Tech Complete Tech Revise Resident Revise Saved Queued In Trans In Transcription Incomplete Transcription Transcribed Wet Read Queued Prelim Preliminary Queued Needs Review Needs Review Revised Queued Final Final Cadence Non-Imaging Order
4	TRANSCRIPTIONIST	VARCHAR	No
	The transcriptionist of an external order result coming through the transcription interface.
5	ORDERING_MODE_C_NAME	VARCHAR	No
	This indicates whether an order is an inpatient or outpatient order. Note that Outpatient orders can be placed from an Inpatient encounter as discharge orders. This column might be blank for Outpatient orders placed prior to the creation of the IP module. This column is used to link to the ZC_ORDERING_MODE table. May contain organization-specific values: No Category Entries: Outpatient Inpatient
6	PROV_STATUS_C_NAME	VARCHAR	No
	The provider status category number for the order at the time of the extract. This item reflects the providers' viewed status of the order result message. The amount, frequency and type of data stored in this item depends on the programming point records entered into the results message type definition in use at each facility. This column is used to link to the ZC_PROV_STATUS table. May contain organization-specific values: No Category Entries: Ordered Open Reviewed Accepted w/o review
7	RESULT_TYPE_C_NAME	VARCHAR	No
	The result type category number for the order, if noted. A null value indicates that it is normal order results. This column is used to link to the ZC_ORD_RESULT_TYPE table. May contain organization-specific values: No Category Entries: Table Text Scan Voice
8	RFL_PRIORITY_C_NAME	VARCHAR	No
	The priority level category number of a referral order, which is used to specify whether a referral order is routine, urgent, emergency or elective. This column is used to link to the ZC_RFL_PRIORITY table. May contain organization-specific values: Yes Category Entries: Routine Urgent Emergency Elective Two Week Wait See Details
9	REFLEX_ORDER_ID	NUMERIC	No
	The order ID from which this reflex order was created.
10	ORD_TRANS_METHOD_C_NAME	VARCHAR	No
	This item holds the method of transmission for a given order. It should only be set from a property within an order transmittal rule. May contain organization-specific values: Yes Category Entries: Printed Faxed E-Prescribed Mail Ordered Phoned In OTC Vended Internal Pharmacy
11	NUM_SIG_REQ	INTEGER	No
	The number of physician signatures required to move the study status to final within the procedural applications.
12	DURATION	INTEGER	No
	Duration for this procedure.
13	INTERVENTION	VARCHAR	No
	Intervention for this procedure.
14	SIGN_ACTION_PEND_C_NAME	VARCHAR	No
	Sign action for pended order. May contain organization-specific values: No Category Entries: Sign Sign & Hold
15	STAT_COMP_USER_ID	VARCHAR	No
	The ID of the user who marked an inpatient procedure as 'Complete'
16	STAT_COMP_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
17	STAT_COMP_DTTM	DATETIME (Local)	No
	The time and date that an inpatient procedure was marked as 'Complete'
18	IS_EXT_READ_YN	VARCHAR	No
	This item indicates whether this order is for an external read of an imaging study. A null value should be assumed to be No. May contain organization-specific values: No Category Entries: No Yes
19	PENDDC_STATUS_C_NAME	VARCHAR	No
	Status of an order if the order is pending discontinue. May contain organization-specific values: No Category Entries: D/C Accepted Pending D/C D/C Rejected
20	AUTOINTK_COMPL_YN	VARCHAR	No
	This item contains whether an auto-intake has been completed for the order. The category values for this column were already listed for column: IS_EXT_READ_YN
21	RESULT_LOCATION_C_NAME	VARCHAR	No
	This item indicates which order item the result is stored. May contain organization-specific values: No Category Entries: Normal result entry Entered in narrative
22	STAND_EOW_ID	VARCHAR	No
	Holds the ID number of the Standing Status In Basket message associated with this Order. The In Basket message informs the user that a standing order exists.
23	INPAT_DISC_INTER_ID	VARCHAR	No
	This item stores the interval at which a standing order should be released for inpatient orders.
24	INPAT_DISC_INTER_ID_FREQ_NAME	VARCHAR	No
	The name of the frequency record.
25	INPAT_AUTO_RLSE_YN	VARCHAR	No
	This item indicates whether child instances of a standing order should be automatically released for inpatient orders. May contain organization-specific values: No Category Entries: Yes No
26	LAB_CRT_CNCT_CSN_ID	NUMERIC	No
	The unique contact serial number for the contact that was created from this order. This number is unique across all patient encounters in your system. If you use IntraConnect, this is the Unique Contact Identifier (UCI).
27	LAST_OVERALL_ASMT_C_NAME	VARCHAR	No
	The most recent overall mammography assessment for the order. This should be the same as the most recent value for ORDER_RAD_ASMT.ASSESSMENT_C. This column is used to link to the ZC_ASSESSMENT table. May contain organization-specific values: Yes Category Entries: Need Additional Imaging Evaluation Negative Benign Probably Benign Suspicious Highly Suggestive of Malignancy Known Biopsy-Proven Malignancy Post-Procedure Mammogram for Marker Placement Need Prior Mammograms for Comparison Low Suspicion for Malignancy Moderate Suspicion for Malignancy High Suspicion for Malignancy
28	REVENUE_CODE_ID	NUMERIC	No
	The revenue code associated with the service.
29	REVENUE_CODE_ID_REVENUE_CODE_NAME	VARCHAR	No
	The name of the revenue code.
30	UNITS_REQUESTED	INTEGER	No
	The number of units requested for the service.
31	UNITS_APPROVED	INTEGER	No
	The number of units approved for the service.
32	TOTAL_PRICE	NUMERIC	No
	The total price of the service.
33	PATIENT_PORTION	NUMERIC	No
	The amount or portion the patient will have to pay for the service they are being referred for.
34	AUTH_REQUIRED	VARCHAR	No
	This column stores whether or not authorization is required for the service.
35	NET_PAYABLE	NUMERIC	No
	The net payable of the service.
36	NOT_COVERED	VARCHAR	No
	This item indicates whether or not the service is covered.
37	PROVIDING_PROV_ID	VARCHAR	No
	The provider on the service.
38	COMMENT_WITH_CANCEL	VARCHAR	No
	Comment entered while cancelling an order.
39	SOFT_DEL_FLAG	VARCHAR	No
	Soft deletion flag for order records associated with order-based transcriptions, which were deleted by the transcription soft-deletion utility.
40	RESULT_TRACK_STS_C_NAME	VARCHAR	No
	This stores whether follow-up with recipients is required, in progress, or completed. This status is the per-order, see RESULT_TRACK_RECIP for individual recipient result tracking statuses. May contain organization-specific values: No Category Entries: Required In Progress Completed
41	ORD_PHASE_OF_CARE_C_NAME	VARCHAR	No
	This item will store the phase of care for which this order was created. Example: Pre-Op, Intra-Op, PACU. May contain organization-specific values: Yes
42	REQUESTED_DATETIME	DATETIME	No
	The requested date and time. The items extracted to this column are populated by the Cadence Orders Interface.
43	ORX_ID	NUMERIC	No
	Contains an ID from Order Lookup Index. This may be populated if an order originates from an Order Panel.
44	ORX_ID_ORDER_LOOKUP_NAME	VARCHAR	No
	The name (.2 item) for the order panel record.
45	RELEASED_INSTA_DTTM	DATETIME (Local)	No
	Stores the scheduled instant of the child order.
46	LAST_SCHE_INST_DTTM	DATETIME (UTC)	No
	This item stores the inpatient order's last scheduled instant.
47	INTERACT_COMMENT	VARCHAR	No
	Interaction override comment.
48	COPY_POINTER_ID	NUMERIC	No
	This object tracks order record links created when using the inpatient or ambulatory order mover utilities to move an order record. This item is populated on the source order record and points to the target order record(s) created.
49	AFTER_ORDER_ID	VARCHAR	No
	This column contains the After Order ID for an order after Order Transmittal.
50	BEFORE_ORDER_ID	VARCHAR	No
	This column contains the Before Order ID for an order before Order Transmittal.
51	DIET_COMMENTS	VARCHAR	No
	This column contains the Diet Comments entered for an order.
52	ORD_CONDITION_FLAG	INTEGER	No
	This column contains the a Condition Flag if this is an order created from certain condition.
53	COR_AFTR_FINAL_DTTM	DATETIME (Local)	No
	The date and time when the study was corrected and finalized.
54	IS_HELD_ORDER_C_NAME	VARCHAR	No
	This item stores 1 if the order is signed and held and active May contain organization-specific values: No Category Entries: Yes
55	NOCHRG_EXT_RSLT_YN	VARCHAR	No
	This column returns whether the order is an external result that should not drop charges. A value of 1 returns Y. A value of 0 returns N. A null value will return null but is treated the same as 0 when dropping charges. The category values for this column were already listed for column: IS_EXT_READ_YN
56	PROTOCOL_STATUS_C_NAME	VARCHAR	No
	Contains the current status of the order's protocols. Will be used to determine how to populate the protocol work list. May contain organization-specific values: No Category Entries: Protocol Needed Protocol Routed Protocol Completed Automatically Routed Automatically Completed
57	PROTCL_ASGN_POOL_ID	VARCHAR	No
	If an order's protocol has been assigned to a pool, this item contains the pool ID of the assigned pool.
58	PROTCL_ASGN_POOL_ID_POOL_NAME	VARCHAR	No
	The name of the scheduling pool used when searching for available providers for an appointment.
59	PROTCL_ASGN_PROV_ID	VARCHAR	No
	If an order's protocol has been assigned to a provider, this item contains the provider ID of the assigned provider.