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/Recurring 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.