ORDER_STATUS

Description: |
The ORDER_STATUS table contains overtime single response orders information.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
ORDER_ID | 1 |
ORD_DATE_REAL | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | ORDER_ID | NUMERIC | No |
Unique ID for this order record
2 | ORD_DATE_REAL | FLOAT | No |
This is a numeric representation of the date of this encounter in your system. The integer portion of the number specifies the date of the encounter. The digits after the decimal point indicate multiple visits on one day.
3 | CONTACT_DATE | DATETIME | No |
The date of this contact in calendar format.
4 | CONTACT_NUMBER | INTEGER | No |
The contact number of the orders record.
5 | CONTACT_TYPE_C_NAME | VARCHAR | No |
The category value for the contact type, such as "1" for "Ordered" or "2" for "Resulted"
May contain organization-specific values: No
Category Entries:
Ordered
Resulted
Canceled
Verify
Dispense
Return
Administration
Edited History
Credit
Add Refill
Fill Request
Prescription Transfer
Pend Verify
Waste
Waste Credit
Canceled Verify
Canceled Pend Verify
Canceled Dispense
Adjudication
Hospice Refill
Charge
Pend Autoverify Review
Canceled Return
Canceled Waste
Edit Infusion Rate
Pharmacy Sale
Dispensing Verify
Provisional Verify
6 | ABNORMAL_YN | VARCHAR | No |
This Y/N flag reports Y if a result component in the order is reported as abnormal or N if the order is normal.
May contain organization-specific values: No
Category Entries:
Abnormal
Normal
7 | ORDER_CREATOR_ID | VARCHAR | No |
The unique ID of the person creating the order.
8 | ORDER_CREATOR_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
9 | RESULTING_PROV | VARCHAR | No |
The name of the provider signing off on the results.
10 | LAB_TECHNICIAN | VARCHAR | No |
The technician responsible for the order tests.
11 | RESULTING_LAB_ID | NUMERIC | No |
The unique ID of the lab running the test.
12 | RESULTING_LAB_ID_LLB_NAME | VARCHAR | No |
Interface laboratory name.
13 | INSTANT_OF_ENTRY | DATETIME (Local) | No |
The instant the record was last entered.
14 | INSTANT_OF_EDIT | DATETIME | No |
The instant the record was last edited.
15 | RX_DISPENSE_CODE_C_NAME | VARCHAR | No |
The pharmacy dispense code used for this order.
May contain organization-specific values: Yes
16 | RX_PAR_DOSES | INTEGER | No |
PRN par level number of doses
17 | CSN_FOR_ADD_REFILL | NUMERIC | No |
This item only applies to refill orders. It stores the contact serial numbers of the patient visits where the refill order was modified.
18 | SCHEDULED_DATE | DATETIME | No |
The date a standard ambulatory order is scheduled for.
19 | SCHEDULED_TIME | DATETIME (Local) | No |
The time a standard ambulatory order is scheduled for.
20 | PROCEDURE_NOTE_ID | VARCHAR | No |
This column contains the unique notes record identifier of the note that resulted the narrative for the order.
21 | PROCEDURE_NOTE_DT | DATETIME | No |
This is the date for the procedure note that resulted the order.
22 | ERFLL_REQ_RFL_PRN_C_NAME | VARCHAR | No |
This item stores the time period for refills requested in the erefill.
May contain organization-specific values: No
Category Entries:
PRN-2Yr
PRN-1Yr
PRN-Other
23 | ERFLL_APP_RFL_PRN_C_NAME | VARCHAR | No |
This item stores the time period for refills approved in the erefill.
The category values for this column were already listed for column: ERFLL_REQ_RFL_PRN_C_NAME
24 | EREFILL_TO_PHM_ID | VARCHAR | No |
Stores the link to the general use notes record containing the action message to the pharmacy.
25 | WET_READS_C_NAME | VARCHAR | No |
Indicates whether this contact is created by Wet Reads. Used in ED Wet Reads pop-up form.
May contain organization-specific values: No
Category Entries:
Wet Reads
26 | ROUTING_OUTCOME_C_NAME | VARCHAR | No |
The category value of the outcome of results routing for each resulting contact of order associated with this row.
May contain organization-specific values: Yes
Category Entries:
Result not sent
Primary notification suppressed, CC list and Care Team evaluated
Routed using only CC list and additional recipients
Routed using routing scheme
Routed using routing scheme and additional recipients
Routed using results routing rule
Routed using results routing rule and additional recipients
Routed using an override provider
Routed using the authorizing provider
Routed using the authorizing provider and additional recipients
Routed using the encounter provider
Routed using the encounter provider and additional recipients
Routing failure - routed via batch
Sent with a different order as part of a grouped result
Routed as a group with other orders
Primary notification suppressed, CC list evaluated except Care Team
27 | ROUTING_RULE_LEVEL | VARCHAR | No |
The level at which the results routing rule used to determine recipients was specified. The possible levels are: Auth Prov, Auth Prov Primary Dept, Enc Dept, or System
28 | ROUTING_SCHEME_LINE | VARCHAR | No |
The line of the results routing scheme that was executed to determine recipients for this result. If no line was executed, the value of the column will be the string "DEFAULT".
29 | ROUTING_INST_TM | DATETIME (Local) | No |
The date and time the order was resulted and routed.
30 | ROUTING_USER_ID | VARCHAR | No |
The unique ID of the user the result was routed to for this row.
31 | ROUTING_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
32 | RIS_LET_TEMPLT_ID | VARCHAR | No |
The unique ID of the SmartText record for a mammography result letter associated with this order.
33 | RIS_LET_TEMPLT_ID_SMARTTEXT_NAME | VARCHAR | No |
The name of the SmartText record.
34 | ROUTING_CURSTATUS_C_NAME | VARCHAR | No |
This item stores the current routing status for a resulting contact.
May contain organization-specific values: Yes
Category Entries:
Result contact created
Routing started
Needs Chart Sync
Synced - Needs routing
Re-Routing attempted
Re-routing attempt failed
Routing Complete
35 | MAM_LIFETIME_RISK | NUMERIC | No |
Patient's probability of getting breast cancer in a lifetime. Calculated using external formula.
36 | LAB_STATUS_C_NAME | VARCHAR | No |
Indicates the lab status value associated with each order contact.
May contain organization-specific values: No
Category Entries:
In process
Preliminary result
Final result
Edited
Edited Result - FINAL
37 | OVRL_BREAST_DENS_C_NAME | VARCHAR | No |
Overall breast density. Entered when reading a mammography study.
May contain organization-specific values: Yes
Category Entries:
Almost entirely fatty
Scattered fibroglandular density
Heterogeneously dense
Extremely dense
Unknown
38 | RIGHT_BREAST_DENS_C_NAME | VARCHAR | No |
Right breast density. Entered when reading a mammography study.
The category values for this column were already listed for column: OVRL_BREAST_DENS_C_NAME
39 | LEFT_BREAST_DENS_C_NAME | VARCHAR | No |
Left breast density. Entered when reading a mammography study.
The category values for this column were already listed for column: OVRL_BREAST_DENS_C_NAME
40 | MOST_SIG_MAM_FIND_C_NAME | VARCHAR | No |
This stores the most significant mammography finding as documented by a radiologist.
May contain organization-specific values: Yes
Category Entries:
None
Mass
Calcification
Architectural distortion
Asymmetries
Other
41 | IMG_DOUBLE_READ_C_NAME | VARCHAR | No |
This tracks if a double read was performed while resulting an imaging study, and if so, what type of double read was it.
May contain organization-specific values: Yes
Category Entries:
No
Yes - standard views
Yes - additional views
Yes - both standard and additional views
Yes - NOS
Unknown
42 | CAD_USAGE_C_NAME | VARCHAR | No |
This stores whether CAD (Computer Aided Detection) was used while interpreting an imaging study.
May contain organization-specific values: Yes
Category Entries:
No
Yes - standard views
Yes - additional views
Yes - both standard and additional views
Yes - NOS
Unknown
43 | LAB_PATHOLOGIST_ID | VARCHAR | No |
The unique user ID of the pathologist that has responsibility for the current Anatomic Pathology order.
44 | LAB_PATHOLOGIST_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
45 | RSLT_CNCT_INSTANT_DTTM | DATETIME (UTC) | No |
The instant in which a result contact is modified/filed to the system. Not to be confused with Result Date/Time, which is when the result was actually generated.
46 | RSLT_CNCT_USER_ID | VARCHAR | No |
The user filing the result contact. For interfaces or Beaker Result Filing background job, this might be a generic user.
47 | RSLT_CNCT_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
48 | RSLT_CNCT_SOURCE_C_NAME | VARCHAR | No |
Stores which entry point modified the result contact.
May contain organization-specific values: No
Category Entries:
Unknown
Enter/Edit Results
Result Orders Visit Navigator
Results Console Visit Navigator
Anticoag Tracker Visit Navigator
Lab Auto Verification
Lab Manual Verification
Study Review
Procedure Notes
Begin/End Exam
Media Manager
Prior Status
Update Assessment and Recommendation
Validation Queue
Change Procedure
Change Imaging Study Status
Track Result
In Basket
ED Narrator
Wet Read
External Results Entry
HH Remote Client Lab Result
Donor Organ Editor
UNOS Import
Historical Cervical Cytology
Automatically Reconciled Lab Result
Link Health Maintenance
Dermatology Exam
Automatically Reconciled Image Result
Mobile POCT Results Entry
Document Batch Editor
Imaging and Procedures
Imaging and Procedures Mobile
Stability
Interfaces
Transcription Utility
3rd Party Result Entry
Bulk Ordering Utility
Utilities
49 | IPROC_NOTE_ID | VARCHAR | No |
Stores the ID to the general use notes record of the Imaging and Procedures Resulting Note.
50 | IPROC_NOTE_CSN | NUMERIC | No |
Stores the contact serial number to the general use notes record of the Imaging and Procedures Resulting Note.
51 | RES_INTERPRETER_ID | VARCHAR | No |
The unique ID of the user who is the interpreter of the results for this order.
52 | RES_INTERPRETER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
53 | RESPONS_AP_USER_ID | VARCHAR | No |
The unique ID of the lab user that has responsibility for the current anatomic pathology order.
54 | RESPONS_AP_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
55 | OVRL_TISSUE_COMP_C_NAME | VARCHAR | No |
Patient level tissue composition. Entered when reading a breast US.
May contain organization-specific values: No
Category Entries:
Homogeneous background echotexture - fat
Homogeneous background echotexture - fibroglandular
Heterogeneous background echotexture
56 | RIGHT_TISSUE_COMP_C_NAME | VARCHAR | No |
Right breast tissue composition. Entered when reading a breast US.
The category values for this column were already listed for column: OVRL_TISSUE_COMP_C_NAME
57 | LEFT_TISSUE_COMP_C_NAME | VARCHAR | No |
Left breast tissue composition. Entered when reading a breast US.
The category values for this column were already listed for column: OVRL_TISSUE_COMP_C_NAME
58 | OVRL_FGT_C_NAME | VARCHAR | No |
Patient level amount of fibroglandular tissue. Entered when reading a breast MR.
May contain organization-specific values: No
Category Entries:
Almost entirely fat
Scattered fibroglandular tissue
Heterogeneous fibroglandular tissue
Extreme fibroglandular tissue
59 | RIGHT_FGT_C_NAME | VARCHAR | No |
Right breast amount of fibroglandular tissue. Entered when reading a breast MR.
The category values for this column were already listed for column: OVRL_FGT_C_NAME
60 | LEFT_FGT_C_NAME | VARCHAR | No |
Left breast amount of fibroglandular tissue. Entered when reading a breast MR.
The category values for this column were already listed for column: OVRL_FGT_C_NAME
61 | OVRL_BPE_C_NAME | VARCHAR | No |
Patient level background parenchymal enhancement. Entered when reading a breast MR.
May contain organization-specific values: No
Category Entries:
Minimal
Mild
Moderate
Marked
62 | RIGHT_BPE_C_NAME | VARCHAR | No |
Right breast background parenchymal enhancement. Entered when reading a breast MR.
The category values for this column were already listed for column: OVRL_BPE_C_NAME
63 | LEFT_BPE_C_NAME | VARCHAR | No |
Left breast background parenchymal enhancement. Entered when reading a breast MR.
The category values for this column were already listed for column: OVRL_BPE_C_NAME
64 | SYMMETRIC_BPE_C_NAME | VARCHAR | No |
Symmetric flag for background parenchymal enhancement. Entered when reading a bilateral breast magnetic resonance (MR).
May contain organization-specific values: No
Category Entries:
Symmetric
Asymmetric
65 | LAB_CORR_TYPE_C_NAME | VARCHAR | No |
Stores the type of correction that was made to an anatomic pathology report.
May contain organization-specific values: No
Category Entries:
Addendum
Correction
66 | RESULT_DTTM | DATETIME (Local) | No |
The date and time the technician ran the tests for each order in calendar format. NOTE: Concatenates the result date (ORD 26) and result time (ORD 28) into a datetime format. If the time value is null, the query will return 12:00 AM for a time.
67 | LEFT_OVARY_SMALL_FOLLICLE_CNT | INTEGER | No |
The number of follicles in the left ovary at or below the minimum threshold as defined in system definitions (I LSD 53002).
68 | RIGHT_OVARY_SMALL_FOLLICLE_CNT | INTEGER | No |
The number of follicles in the right ovary at or below the minimum threshold as defined in system definitions (I LSD 53002).
69 | ENDOMETRIAL_STRIPE | NUMERIC | No |
The measurement of the endometrial stripe.
70 | OV_CYST_PRESENCE_C_NAME | VARCHAR | No |
Whether ovarian cysts are present in this ultrasound study.
May contain organization-specific values: No
Category Entries:
Not Present
Present
Not Evaluated
71 | UTERINE_FIBROID_PRESENCE_C_NAME | VARCHAR | No |
Whether uterine fibroids are present in this ultrasound study.
The category values for this column were already listed for column: OV_CYST_PRESENCE_C_NAME
72 | UTERINE_POLYP_PRESENCE_C_NAME | VARCHAR | No |
Whether uterine polyps are present in this ultrasound study.
The category values for this column were already listed for column: OV_CYST_PRESENCE_C_NAME
73 | NARRATIVE_PERF_ORG_INFO | INTEGER | No |
This item stores the line number of the performing organization related group (ORD 1220) and acts as a pointer to the performing organization information of narrative of the result.
74 | IMPRESSION_PERF_ORG_INFO | INTEGER | No |
This item stores the line number of the preforming organization related group (ORD 1220) and acts as a pointer to the performing organization information of impression of the result.
75 | EXT_DISP_FILL_IDENT | VARCHAR | No |
Holds the unique identifier for a given fill used to identify the external dispense
76 | SR_VALID_STATUS_C_NAME | VARCHAR | No |
Indicates whether the study has been properly updated and validated for a particular order, and is ready for enhanced validation from outside of Study Review. Validated [1] means that the study is ready for enhanced validation. Not Validated [0] or blank means that it is not ready, usually because the study was modified from outside of Study Review, or has never been opened in Study Review.
May contain organization-specific values: No
Category Entries:
Not Validated
Validated
77 | RESULT_PERF_ORG | INTEGER | No |
This item stores the line number of related group 1220 and acts as a pointer to the performing organization information of the result.
78 | LAB_RESULTING_METHOD | VARCHAR | No |
The main resulting method (either manual or a specific interface) that was used to result the order
79 | NLP_RESULT_ACTION_C_NAME | VARCHAR | No |
Flags which result contact was used to send the impression to Nebula for natural language processing. Used to determine if the impression changed since natural language processing ran.
May contain organization-specific values: No
Category Entries:
No Result Text
Result Text Sent
Result Text Changed
Result Text Verified
80 | ROUTING_MOPS_ORDER_ID | NUMERIC | No |
The ID of the MOPS grouper order this order was routed with.
81 | ROUTING_MOPS_ORDER_DAT | INTEGER | No |
The DAT of the MOPS grouper order this order was routed with.
82 | NLP_UNVERIFIED_IB_ONLY_YN | VARCHAR | No |
Flag to restrict sending unverified NLP data to only In Basket.
May contain organization-specific values: No
Category Entries:
Yes
No
83 | OVRL_AVG_VOL_BREAST_DENS | NUMERIC | No |
Overall average volumetric breast density. Stored as a percentage.
84 | RIGHT_VOL_BREAST_DENS | NUMERIC | No |
Right volumetric breast density. Stored as a percentage.
85 | LEFT_VOL_BREAST_DENS | NUMERIC | No |
Left Volumetric Breast Density. Stored as a percentage.
86 | BREAST_DENS_ALG | VARCHAR | No |
The algorithm used to determine breast composition and volumetric breast density
87 | BREAST_DENS_ALG_VER | VARCHAR | No |
The algorithm version used to determine breast composition and volumetric breast density
88 | OVRL_VOL_ASSOC_BREAST_DENS_C_NAME | VARCHAR | No |
Overall volumetric breast density's associated category.
The category values for this column were already listed for column: OVRL_BREAST_DENS_C_NAME