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_PROV_NAME VARCHAR No
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
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_PROV_NAME VARCHAR No
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.