Table Detail Report

OMF_WL_PRODUCTIVITY_ST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Workload productivity stats
Definition: omf_wl_productivity_st
Table Type: ACTIVITY





Column Detail - OMF_WL_PRODUCTIVITY_ST


Column Name Type Null? Definition
CPT_NOMENCLATURE_ID DOUBLE N The unique identifier for the cpt code.
DRG_NOMENCLATURE_ID DOUBLE N The unique identifier for the DRG code.
EXTENDED_UNITS DOUBLE Y The quantity * units * multiplier.
MULTIPLIER DOUBLE Y The raw number of units that were assigned based on the standard or the number of units entered in the Pricing Tool.
NBR_CPT_PROCS DOUBLE Y The summarized number of cpt procedures.
NBR_DRGS DOUBLE Y The summarized number of DRGs
NBR_ICD_PROCS DOUBLE Y The summarized number of icd procedures.
OMF_WL_PRODUCTIVITY_ST_ID DOUBLE N The unique identifier for the omf_wl_productivity_st table.
ORD_PHYS_ID DOUBLE N The unique identifier for the ordering physician.
PROJ_WORKLOAD DOUBLE Y The projected number of workload units.
PRSNL_ID DOUBLE N The unique identifier for the performing personnel.
PRSNL_POSITION_CD DOUBLE N The position of the prsnl.
QTY DOUBLE Y The quantity for the number of units that will be multiplied to the workload multiplier in order to determine the volume of workload.
RAW_COUNT DOUBLE Y Raw procedure count.
SERVICE_CATEGORY_CD DOUBLE N Codified field which identifies the current category of service the patient is receiving for this encounter.
SERVICE_DT_NBR DOUBLE Y The Julian date number on which the service was complete for the event that resulted in this workload row.
UNITS DOUBLE Y The number of units that were calculated by the server using the multiplier and interval logic if necessary.
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.



Relationship Detail - OMF_WL_PRODUCTIVITY_ST


Child Column in OMF_WL_PRODUCTIVITY_ST(FK) Parent Table Name Parent Column Name
Parents: ORD_PHYS_ID PRSNL PERSON_ID
PRSNL_ID PRSNL PERSON_ID