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