PLM_TAT_PARAMETER



Column Section Top of Page


Table-level Detail

Description: Turnaround Time parameters
Definition: This table contains reference turnaround and specimen expiration minutes for orderables (for different service resources and reporting priorities)
Table Type: REFERENCE





Column Detail - PLM_TAT_PARAMETER


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
ALERT_MIN DOUBLE N Minutes, from In-lab to when the Orderable gets to an Alert time. OR Minutes from Drawn_dt_tm to when the specimen gets to an Expire Time for Specimen Expiration (for specimen expiration times)
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
CATALOG_CD DOUBLE N The catalog_cd of the orderable that is being performed at the Service_resource
DISPLAY_MIN DOUBLE N Minutes from In -lab to when the Orderable gets to a Display time.
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
REP_PRIORITY_CD DOUBLE N The Reporting Priority codes for the Turn around times from codeset 1905. This is zero for the Specimen expiration times.
SERVICE_RESOURCE_CD DOUBLE N The subsection, bench or the instrument for which the times are built.
TAT_ID DOUBLE N This is a sequential id which will be unique for each rule.
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.
WARNING_MIN DOUBLE N Minutes from In-lab to when the Orderable gets to a Warning time for Turn Around Times. Minutes from Drawn_dt_tm to when the specimen gets to a Warning Time (for Specimen Expiration)


UM_CHARGE_EVENT_ST



Column Section Relationship Section Top of Page


Table-level Detail

Description: UM CHARGE EVENT ST
Definition: Utilization Management summary table.
Table Type: ACTIVITY





Column Detail - UM_CHARGE_EVENT_ST


Column Name Type Null? Definition
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



Relationship Detail - UM_CHARGE_EVENT_ST


Child Column in UM_CHARGE_EVENT_ST(FK) Parent Table Name Parent Column Name
Parents: BILL_ITEM_ID BILL_ITEM BILL_ITEM_ID
PARENT_BILL_ITEM_ID BILL_ITEM BILL_ITEM_ID
CHARGE_EVENT_ID CHARGE_EVENT CHARGE_EVENT_ID
ENCNTR_ID ENCOUNTER ENCNTR_ID
CLIENT_ID ORGANIZATION ORGANIZATION_ID
PATIENT_ID PERSON PERSON_ID