|
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 |
|
|
| 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 |
| 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 fatty |
| 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 |
|
|
