ACCESSION_FORMAT_CD |
DOUBLE |
N |
Accession Format Cd |
ACCESSION_NBR |
VARCHAR(50) |
Y |
Accession Number of the order. |
ACTIVITY_SUBTYPE_CD |
DOUBLE |
N |
Activity Subtype cd |
ACTIVITY_TYPE_CD |
DOUBLE |
N |
Type of order activity such as 'GLB', 'BB', and 'MICROBIOLOGY'. |
ACT_DRAWN_IN_TRANSIT |
DOUBLE |
Y |
Actual Time Drawn to In Transit (In minutes) |
ACT_IN_LAB_PERF |
DOUBLE |
Y |
Actual Time In Lab to Performed |
ACT_IN_TRANSIT_IN_LAB |
DOUBLE |
Y |
Actual Time In Transit to In Lab |
ACT_ORD_REQ_COLL |
DOUBLE |
Y |
Actual Time Ordered to Requested Collection |
ACT_OVERALL_TAT |
DOUBLE |
Y |
Actual Time Ordered to Completed |
ACT_PERF_VERIF |
DOUBLE |
Y |
Actual Time Performed to Verified |
ACT_REQ_COLL_DRAWN |
DOUBLE |
Y |
Actual Time Requested Collection to Drawn |
ACT_VERIF_COMP |
DOUBLE |
Y |
Actual Time Verified to Complete |
ADJ_ACT_IN_LAB_PERF |
DOUBLE |
Y |
Adjusted Actual time in In Lab to performed |
ADJ_ACT_IN_TRANSIT_IN_LAB |
DOUBLE |
Y |
Adjusted Actual time in Transit to In Lab minus weekend minutes. |
ADJ_ACT_ORD_REQ_COLL |
DOUBLE |
Y |
Adjusted Actual time in ordered to request collection. |
ADJ_ACT_OVERALL_TAT |
DOUBLE |
Y |
Adjusted Actual Time Ordered to Complete minus weekend minutes |
ADJ_ACT_PERF_VERIF |
DOUBLE |
Y |
Adjusted Actual time Performed to Verified minus weekend minutes. |
ADJ_ACT_REQ_COLL_DRAWN |
DOUBLE |
Y |
Adjusted Actual Time Requested Collection to Drawn Minus Weekend Minutes |
ADJ_ACT_VERIF_COMP |
DOUBLE |
Y |
Adjusted Actual Time Verified to Complete minus weekend minutes. |
ANTIBIOTIC_CD |
DOUBLE |
N |
Microbiology Antibiotic Code |
BILL_ITEM_ID |
DOUBLE |
N |
Relates this UM Charge Event to a specific Bill Item |
BILL_QTY |
DOUBLE |
Y |
The billed volume for the order/event. |
BILL_REVENUE |
DOUBLE |
Y |
The revenue for the order/event. |
BODY_SITE_CD |
DOUBLE |
N |
Microbiology Body Site CD |
CANCEL_DAY |
DOUBLE |
Y |
The day of week that the order was cancelled. |
CANCEL_DT_NBR |
DOUBLE |
Y |
Cancel date as Julian Date used to join to the omf_date table. |
CANCEL_DT_TM |
DATETIME |
Y |
The date/time that the order was cancelled. |
CANCEL_HOUR |
DOUBLE |
Y |
The hour of day that the order was cancelled. |
CANCEL_MIN_NBR |
DOUBLE |
Y |
Cancel minute number used to join to the omf_time table. |
CANCEL_MONTH |
VARCHAR(10) |
Y |
The month in which the order was cancelled. |
CANCEL_QTY |
DOUBLE |
Y |
The number of orders that were cancelled. |
CANCEL_REASON_CD |
DOUBLE |
N |
The reason that the order was cancelled. |
CASE_INADEQUACY_CD |
DOUBLE |
N |
AP Case Inadequacy Cd |
CASE_RESP_PATHOLOGIST_ID |
DOUBLE |
N |
AP Case Responsible Pathologist Id |
CASE_RESP_RESIDENT_ID |
DOUBLE |
N |
AP Case Responsible Resident Id |
CASE_TYPE_CD |
DOUBLE |
N |
AP Case Type Cd |
CATALOG_CD |
DOUBLE |
N |
Order Catalog cd |
CHARGE_EVENT_ID |
DOUBLE |
N |
The unique identification number for the charge. |
CLIENT_CLASS_CD |
DOUBLE |
N |
Grouping of organizations. |
CLIENT_GRP_CD |
DOUBLE |
N |
Grouping of organizations. |
CLIENT_ID |
DOUBLE |
N |
The organization id for the order. |
COLLECTION_METHOD_CD |
DOUBLE |
N |
Collection Method |
COLL_PRIOR_CD |
DOUBLE |
N |
The collection priority assigned to the order. |
COLL_PRIOR_GRP_CD |
DOUBLE |
N |
The grouping of collection priorities to which the collectionpriority assigned to the order belongs. |
COMP_DAY |
DOUBLE |
Y |
The day of week that the order was completed. |
COMP_DT_NBR |
DOUBLE |
Y |
Complete date as Julian date, used to join to the omf_date table |
COMP_DT_TM |
DATETIME |
Y |
The date and time that the order was completed. |
COMP_HOUR |
DOUBLE |
Y |
The hour of day that the order was completed. |
COMP_MIN_NBR |
DOUBLE |
Y |
Complete minute number used to join to the omf_time table |
COMP_MONTH |
VARCHAR(10) |
Y |
The month of year that the order was completed. |
COMP_QTY |
DOUBLE |
Y |
Set to 1 when the order is completed; otherwise 0. |
COMP_SHIFT_CD |
DOUBLE |
N |
The shift grouping for the order based on completed date and time. |
CONTRIBUTOR_SYSTEM_CD |
DOUBLE |
N |
Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed. |
CREDITED_QTY |
DOUBLE |
Y |
The number of orders that were credited. |
CREDITED_REVENUE |
DOUBLE |
Y |
The amount of revenue associated with the credited qty. |
CULTURE_DT_NBR |
DOUBLE |
Y |
Microbiology Culture Start date as Julian date, used to join to the omf_date table |
CULTURE_DT_TM |
DATETIME |
Y |
Microbiology Culture Start dt/tm |
CULTURE_MIN_NBR |
DOUBLE |
Y |
Microbiology Culture Start time in minutes from start of the day used for omf_time functions. |
CULTURE_SHIFT_CD |
DOUBLE |
N |
Microbiology Culture Start Shift |
DEPARTMENT_CD |
DOUBLE |
N |
The department to which the order loaded. |
DETAIL_IND |
DOUBLE |
N |
Set to 1 if the record is at the detail level, 0 if the record is at the order level. |
DRAWN_DAY |
DOUBLE |
Y |
The day of week that the order was collected. |
DRAWN_DT_NBR |
DOUBLE |
Y |
Date Drawn as Julian Date, used to join to omf_date table. |
DRAWN_DT_TM |
DATETIME |
Y |
The date and time that the order was collected. |
DRAWN_HOUR |
DOUBLE |
Y |
The hour of day in which the order was collected. |
DRAWN_MIN_NBR |
DOUBLE |
Y |
Drawn minute number, used to join to omf_time table. |
DRAWN_MONTH |
VARCHAR(10) |
Y |
The month of year in which the order was collected. |
DRAWN_SHIFT_CD |
DOUBLE |
N |
The shift grouping for the order based on the collected date and time. |
DRAWN_TECH_ID |
DOUBLE |
N |
Drawing technician(Phlebotomist) id. |
ENCNTR_ID |
DOUBLE |
N |
This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number. |
ENCNTR_TYPE_CD |
DOUBLE |
N |
The encounter type code assigned to the patient for the order. |
ENCNTR_TYPE_GRP_CD |
DOUBLE |
N |
The encounter type grouping to which the encounter type code belongs for the order. |
EXP_DRAWN_IN_TRANSIT |
DOUBLE |
Y |
Expected time drawn to in transit |
EXP_IN_LAB_PERF |
DOUBLE |
Y |
Expected time in lab to performed |
EXP_IN_TRANSIT_IN_LAB |
DOUBLE |
Y |
Expected time in transit to in lab |
EXP_ORD_REQ_COLL |
DOUBLE |
Y |
Expected time ordered to requested collection |
EXP_OVERALL_TAT |
DOUBLE |
Y |
Expected time ordered to completed |
EXP_PERF_VERIF |
DOUBLE |
Y |
Expected time performed to verified |
EXP_REQ_COLL_DRAWN |
DOUBLE |
Y |
Expected time requested collection to drawn |
EXP_VERIF_COMP |
DOUBLE |
Y |
Expected time verified to complete |
FINANCIAL_CLASS_CD |
DOUBLE |
N |
The encounter's financial class. |
ICD9_NOMEN_ID |
DOUBLE |
N |
ICD9 primary diagnosis ** for the detail procedure **. This is gotten from the Charge_mode table. |
INSTITUTION_CD |
DOUBLE |
N |
The institution to which the order loaded. |
IN_LAB_DAY |
DOUBLE |
Y |
The day of week that the order was received in lab. |
IN_LAB_DT_NBR |
DOUBLE |
Y |
Received Date as Julian Date, used to join to omf_date table. |
IN_LAB_DT_TM |
DATETIME |
Y |
The date and time at which the order reached in lab status. |
IN_LAB_HOUR |
DOUBLE |
Y |
The hour of day in which the order reached in lab status. |
IN_LAB_MIN_NBR |
DOUBLE |
Y |
Received minute number, used to join to omf_time table. |
IN_LAB_MONTH |
VARCHAR(10) |
Y |
The month of year in which the order reached in lab status. |
IN_LAB_SHIFT_CD |
DOUBLE |
N |
The shift grouping for the order based on in lab date and time. |
IN_TRANSIT_DAY |
DOUBLE |
Y |
The day of week that the order went in transit. |
IN_TRANSIT_DT_TM |
DATETIME |
Y |
The date and time in which the order went in transit. |
IN_TRANSIT_HOUR |
DOUBLE |
Y |
The hour of day in which the order went in transit. |
IN_TRANSIT_MONTH |
VARCHAR(10) |
Y |
The month of year in which the order went in transit. |
IN_TRANSIT_SHIFT_CD |
DOUBLE |
N |
The shift grouping for the order based on in transit date and time. |
MED_SPEC_CD |
DOUBLE |
N |
The medical specialty grouping for the order based on ordering physician. |
ORDERABLE_TYPE_FLAG |
DOUBLE |
Y |
Type of order from the Orders table. This will tell us, for example, whether this order is a care set and thus should not be counted in volume views. |
ORDER_DT_TM |
DATETIME |
Y |
The date and time at which the order took place. |
ORDER_ID |
DOUBLE |
N |
The unique identification number for the order. |
ORDER_NU_CD |
DOUBLE |
N |
Nurse Unit from which the order was placed. |
ORDER_PHYS_GRP_CD |
DOUBLE |
N |
Ordering physician group (as set in the OMF Grouping Tool). |
ORDER_PHYS_ID |
DOUBLE |
N |
Ordering physicianid. |
ORDER_QTY |
DOUBLE |
Y |
Quantity of the order. |
ORDER_STATUS_CD |
DOUBLE |
N |
Order status code value such as 'CANCELED' and 'COMPLETED'. |
ORD_DAY |
DOUBLE |
Y |
The day of week that the order took place. |
ORD_DT_NBR |
DOUBLE |
Y |
Date Ordered as Julian Date, used to join to omf_date table. |
ORD_HOUR |
DOUBLE |
Y |
Hour (0 to 23) procedure was ordered. |
ORD_MIN_NBR |
DOUBLE |
Y |
Ordered time minute number used to join to omf_time table. |
ORD_MONTH |
VARCHAR(10) |
Y |
Month (1 to 12) the procedure was ordered. |
ORD_SHIFT_CD |
DOUBLE |
N |
Shift the procedure was ordered (as defined in the OMF Grouping Tool). |
ORD_YEAR |
DOUBLE |
Y |
Year the procedure was ordered. |
ORGANISM_CD |
DOUBLE |
N |
Organism |
PARENT_BILL_ITEM_ID |
DOUBLE |
N |
Parent of this bill item (e.g. for a detail procedure its the ordered procedure, for an order procedure its the order procedure again or a care set id) |
PATIENT_BUILD_CD |
DOUBLE |
N |
Building where the patient was located when the order was placed. |
PATIENT_FAC_CD |
DOUBLE |
N |
Facility where the patient was located when the order was placed. |
PATIENT_ID |
DOUBLE |
N |
Person id of patient |
PATIENT_NU_CD |
DOUBLE |
N |
Patient nurse unit (when procedure was ?ordered?). |
PATIENT_NU_GRP_CD |
DOUBLE |
N |
Patient nurse unit group (when procedure was ordered?) as defined in OMF Grouping Tool. |
PERF_DAY |
DOUBLE |
Y |
The day of week that the detail was performed. |
PERF_DT_NBR |
DOUBLE |
Y |
Date Performed as Julian Date, used to join to omf_date table. |
PERF_DT_TM |
DATETIME |
Y |
Performing date and time. |
PERF_HOUR |
DOUBLE |
Y |
Performing hour of day (0 to 23). |
PERF_MIN_NBR |
DOUBLE |
Y |
Performed time minute number used to join to omf_time table. |
PERF_MONTH |
VARCHAR(10) |
Y |
Performing month (1 to 12). |
PERF_QTY |
DOUBLE |
Y |
Set to 1 when result/task is performed |
PERF_SHIFT_CD |
DOUBLE |
N |
Performing shift (as defined in OMF Grouping Tool). |
PERF_TECH_ID |
DOUBLE |
N |
Person Id of Tech who performed the result |
REFERENCE_NBR |
VARCHAR(255) |
N |
Reference number of this row (e.g. for Gen Lab and Blood Bank this is order_id, result_id, task_assay_cd). |
REQ_COLL_DAY |
DOUBLE |
Y |
The day of week that the collection was requested. |
REQ_COLL_DT_NBR |
DOUBLE |
Y |
Requested Collection Date as Julian Date, used to join to omf_date table. |
REQ_COLL_DT_TM |
DATETIME |
Y |
Requested collection date and time. |
REQ_COLL_HOUR |
DOUBLE |
Y |
Requested collection hour of day (0 to 23). |
REQ_COLL_MIN_NBR |
DOUBLE |
Y |
Requested collection time minute number used to join to omf_time table. |
REQ_COLL_MONTH |
VARCHAR(10) |
Y |
Requested collection month (1 to 12). |
REQ_COLL_SHIFT_CD |
DOUBLE |
N |
Request collection shift (as defined in the OMF Grouping Tool). |
RESULT_ID |
DOUBLE |
N |
Id from the result table or mic_task_log table |
RESULT_STATUS_CD |
DOUBLE |
N |
Detail procedure result status such as 'verified', 'corrected', etc. |
RPT_PRIOR_CD |
DOUBLE |
N |
Report Priority Code form Order_laboratory |
RULE_ID |
DOUBLE |
N |
ID of Turnaround Time Rule that this order qualified for |
SECTION_CD |
DOUBLE |
N |
Ordering? Section. |
SERVICE_RESOURCE_CD |
DOUBLE |
N |
Service resource were action was perfomed. |
SITE_PREFIX_CD |
DOUBLE |
N |
Accession Site Prefix Cd |
SMR_FLAG |
DOUBLE |
Y |
Data level setting for Standard Mgmt when this row was populated. |
SM_FLAG |
DOUBLE |
Y |
Data level setting for Service Mgmt when this row was populated. |
SPECIMEN_CD |
DOUBLE |
N |
AP Specimen Cd |
SPECIMEN_TYPE_CD |
DOUBLE |
N |
Specimen Type |
SUBSECTION_CD |
DOUBLE |
N |
Subsection where action was performed. |
TASK_ASSAY_CD |
DOUBLE |
N |
Task or Discrete Assay |
TASK_DETAIL_CD |
DOUBLE |
N |
Microbiology Panel or Detail Biochemical |
TASK_TYPE_FLAG |
DOUBLE |
Y |
Micro Task Type |
TAT_QUAL_IND |
DOUBLE |
Y |
1 = Qualified for a turnaround time rule |
TSK_ORD_DT_NBR |
DOUBLE |
Y |
Task Order Date as Julian date used for OMF_Date functions. |
TSK_ORD_DT_TM |
DATETIME |
Y |
Task Order Dt/Tm |
TSK_ORD_MIN_NBR |
DOUBLE |
Y |
Task Order Time in minutes used for OMF_time functions. |
TSK_ORD_SHIFT_CD |
DOUBLE |
N |
Task Order Time Shift |
UM_CHARGE_EVENT_ST_ID |
DOUBLE |
N |
Unique identifier for table. Only used because true key has 3 elements (order_id, reference_nbr, contributor_system_cd) but this is not allowed for combines. |
UM_FLAG |
DOUBLE |
Y |
Data level setting for Utilization Mgmt when this row was populated. |
UPDT_APPLCTX |
DOUBLE |
N |
The application context number from the record info block. |
UPDT_CNT |
DOUBLE |
N |
Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM |
DATETIME |
N |
The date and time the row was last inserted or updated. |
UPDT_ID |
DOUBLE |
N |
The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK |
DOUBLE |
N |
The registered (assigned) task number for the process that inserted or updated the row. |
VERIF_DAY |
DOUBLE |
Y |
The day of week that the detail was verified. |
VERIF_DT_NBR |
DOUBLE |
Y |
Verified date as Julian date used to join to omf_time table. |
VERIF_DT_TM |
DATETIME |
Y |
Verfied date and time. |
VERIF_HOUR |
DOUBLE |
Y |
Verified hour of day (0 to 23). |
VERIF_MIN_NBR |
DOUBLE |
Y |
Verfied time minute number used to join to omf_time table. |
VERIF_MONTH |
VARCHAR(10) |
Y |
Verified month (1 to 12). |
VERIF_QTY |
DOUBLE |
Y |
The quantity verified. |
VERIF_SHIFT_CD |
DOUBLE |
N |
Verified shift (as defined in OMF Grouping Tool). |
VERIF_TECH_ID |
DOUBLE |
N |
Verified Technician Person ID |