Table Detail Report

OMF_PRSNL_TIMEHOUR_ST



Column Section Top of Page


Table-level Detail

Description: Operations Profiling - Hour level timesheet data
Definition: omf_prsnl_timehour_st
Table Type: ACTIVITY





Column Detail - OMF_PRSNL_TIMEHOUR_ST


Column Name Type Null? Definition
ACTIVITY_DT_NBR DOUBLE Y The internal Cerner date representation of the day on which the individual worked.
ACTIVITY_MIN_NBR DOUBLE Y The minute of day, that represents the hour in which the individual performed work. This also corresponds to the first minute of each hour (1, 61, 121, 181, 241 ... 1381 ).
ACTIVITY_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
NUM_MIN DOUBLE Y The number of minutes work was performed during the hour.
OT_NUM_MIN DOUBLE Y The number of overtime minutes that work was performed during the hour.
PRSNL_PAYPERIOD_ID DOUBLE N Not used
PRSNL_TIMEDATE_ID DOUBLE N The identifier for the person's work period that the hour corresponds to.
PRSNL_TIMEHOUR_ID DOUBLE N The unique row identifier for the table.
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.


OMF_PV_IDENTIFIER



Column Section Top of Page


Table-level Detail

Description: OMF PV IDENTIFIER
Definition: Table to store identifiers as defined within the PowerVisionDemoBuilder
Table Type: ACTIVITY





Column Detail - OMF_PV_IDENTIFIER


Column Name Type Null? Definition
DISPLAY VARCHAR(80) Y Display value as entered via the PowerVisionDemoBuilder (free text)
OMF_ID DOUBLE N Unique identifier
PD_GRID_CD DOUBLE N Grid_cd
SG_TYPE VARCHAR(50) Y Study group type
ST_COLUMN_NAME VARCHAR(40) N Summary table column name


OMF_REVENUE_ST



Column Section Relationship Section Top of Page


Table-level Detail

Description: OMF REVENUE ST
Definition: Stores billed charge data (from UB92)
Table Type: ACTIVITY





Column Detail - OMF_REVENUE_ST


Column Name Type Null? Definition
CHARGE DOUBLE Y The billed charge amount
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
OMF_REVENUE_ST_ID DOUBLE N The unique identifier for a row on omf_revenue_st.
REVENUE_CATEGORY_CD DOUBLE N The revenue category
REVENUE_CD DOUBLE N The revenue code
SERVICE_DT_TM DATETIME Y The date/time on which the service for the charge was performed.
SERVICE_UNITS DOUBLE Y The service amount
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_REVENUE_ST


Child Column in OMF_REVENUE_ST(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID


OMF_SVC_CAT_HIST_ST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Stores service category history for each encounter.
Definition: omf_svc_cat_hist_st
Table Type: ACTIVITY





Column Detail - OMF_SVC_CAT_HIST_ST


Column Name Type Null? Definition
ANESTHESIOLOGIST_ID DOUBLE N The unique identifier of the anesthesiologist for the principal procedure.
ANESTH_POSITION_CD DOUBLE N The Cerner-defined position for the anesthesiologist.
ATTEND_PHYS_POSITION_CD DOUBLE N The Cerner-defined position for the attending physician.
ATT_PRSNL_GRP_CD DOUBLE N Grouping of attending physicians as defined within the OMFGroupingTool.exe.
ATT_PRSNL_ID DOUBLE N The unique identifier for the attending physician.
ATT_PRSNL_MED_SPEC_CD DOUBLE N Grouping of attending physicians as defined within the OMFGroupingTool.exe.
BEG_TRANSACTION_DT_NBR DOUBLE Y The Julian date for the beginning date of the service category.
BEG_TRANSACTION_DT_TM DATETIME Y The date/time for the beginning date of the service category.
BEG_TRANSACTION_MIN_NBR DOUBLE Y The minute for the beginning date/time of the service category.
BEG_TRANSACTION_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
CPT_P_STR VARCHAR(255) Y Free text string of cpt procedure codes.
DEATH_24H_PRIN_PROC_IND DOUBLE Y Indicates whether or not the patient expired within 24 hours of the principal procedure.
DRG_AMLOS DOUBLE Y The arithmetic mean length of stay based on the DRG.
DRG_GMLOS DOUBLE Y The geometric mean length of stay based on the DRG.
DRG_GRP2_CD DOUBLE N Grouping of DRG codes as defined within the OMFGroupingTool.exe.
DRG_GRP_CD DOUBLE N Grouping of DRG codes as defined within the OMFGroupingTool.exe.
DRG_NOMENCLATURE_ID DOUBLE N The unique identifier for the DRG code.
DRG_WEIGHT DOUBLE Y The relative weight of the DRG.
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
END_TRANSACTION_DT_NBR DOUBLE Y The Julian date for the end of the service category.
END_TRANSACTION_DT_TM DATETIME Y The date/time for the end of the service category.
END_TRANSACTION_MIN_NBR DOUBLE Y The minute for the end of the service category.
END_TRANSACTION_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
ICD9_SECONDARY1_DIAG_NOMEN_ID DOUBLE N The unique identifier for the secondary diagnosis code.
ICD_PD_GRP_CD DOUBLE N Grouping of diagnosis codes as defined within the OMFGroupingTool.exe
ICD_PD_NOMENCLATURE_ID DOUBLE N The unique identifier for the primary diagnosis code.
ICD_PP_DT_NBR DOUBLE Y The Julian date for the principal procedure.
ICD_PP_DT_TM DATETIME Y The date/time of the principal procedure.
ICD_PP_DT_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
ICD_PP_GRP_CD DOUBLE N Grouping of procedures as defined within the OMFGroupingTool.exe
ICD_PP_MINUTES DOUBLE Y The number of procedure minutes.
ICD_PP_MIN_NBR DOUBLE Y The minute of the principal procedure.
ICD_PP_NOMENCLATURE_ID DOUBLE N The unique identifier for the principal procedure.
ICD_SD_STR VARCHAR(255) Y Free text string of secondary diagnosis codes.
ICD_SP_STR VARCHAR(255) Y Free text string of secondary procedures.
MDC_CD DOUBLE N The major diagnostic category associated with the DRG.
MED_SERVICE_CD DOUBLE N The type or category of medical service that the patient is receiving in relation to their encounter. The category may be of treatment type, surgery, general resources, or others.
PREV_SERVICE_CATEGORY_CD DOUBLE N The previous service category.
SERVICE_CATEGORY_CD DOUBLE N Codified field which identifies the current category of service the patient is receiving for this encounter.
SURGEON_GRP_CD DOUBLE N Grouping of surgeons as defined within the OMFGroupingTool.exe
SURGEON_ID DOUBLE N The unique identifier for the surgeon.
SURGEON_MED_SPEC_CD DOUBLE N Grouping of physicians as defined within the OMFGroupingTool.exe.
SURGEON_POSITION_CD DOUBLE N The Cerner-defined position for the surgeon.
SVC_CAT_HIST_ID DOUBLE N Unique identifier for the service_category_hist table.
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_SVC_CAT_HIST_ST


Child Column in OMF_SVC_CAT_HIST_ST(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
ANESTHESIOLOGIST_ID PRSNL PERSON_ID
ATT_PRSNL_ID PRSNL PERSON_ID
SURGEON_ID PRSNL PERSON_ID


OMF_TIME



Column Section Relationship Section Top of Page


Table-level Detail

Description: OMF_TIME
Definition: Denormalized table holding various temporal groupings of minutes. This reference table holds a record for each minute of the day.
Table Type: REFERENCE





Column Detail - OMF_TIME


Column Name Type Null? Definition
AM_IND DOUBLE Y Indicates if the minute occurred in the morning, before 12:00 pm.
HALF_HOUR_IND DOUBLE Y Indicates the minute is part of the second half of the hour.
HOUR DOUBLE Y Holds the numeric hour of day the minute falls in.
HOUR_STR VARCHAR(13) Y String representation of the hour the minute falls in.
MIN_NBR DOUBLE N Minute number of day, 1..1440.
TIME_STR VARCHAR(5) Y String representation of the time the min_nbr represents.
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_TIME




Parent Column in OMF_TIME (PK) Child Table Name Child Column Name
Children: MIN_NBR WHC_F_CHILD CHILD_BIRTH_TIME_NBR
WHC_F_CHILD NEONATE_ADMISSION_TIME_NBR
WHC_F_CHILD NEONATE_DISCHARGE_TIME_NBR
WHC_F_CHILD SKIN_SKIN_CONTCT_INT_TIME_NBR
WHC_F_DELIVERY CMPLT_CERV_DIALTN_TIME_NBR
WHC_F_DELIVERY EPIDURAL_BOLUS_ANES_TIME_NBR
WHC_F_DELIVERY EPIDURAL_BOLUS_PATNT_TIME_NBR
WHC_F_DELIVERY EPIDURAL_DISCONTINUED_TIME_NBR
WHC_F_DELIVERY EPIDURAL_START_TIME_NBR
WHC_F_DELIVERY EPIDURAL_TEST_DOSE_TIME_NBR
WHC_F_DELIVERY LABOR_ONSET_TIME_NBR
WHC_F_DELIVERY_CHILD DELIVERY_TIME_NBR
WHC_F_DELIVERY_CHILD PLACENTA_DELIVERY_TIME_NBR
WHC_F_DELIVERY_CHILD ROM_TIME_NBR
WHC_F_MOTHER_PREGNANCY ADMIT_TIME_NBR
WHC_F_MOTHER_PREGNANCY DISCHARGE_TIME_NBR
WHC_F_MOTHER_PREGNANCY PREGNANCY_CLOSE_TIME_NBR
WHC_F_MOTHER_PREGNANCY PREGNANCY_ONSET_TIME_NBR