Table Detail Report

OMF_CAP_MENU



Column Section Top of Page


Table-level Detail

Description: Stores Care Profiling audit menu items.
Definition: omf_cap_menu
Table Type: REFERENCE





Column Detail - OMF_CAP_MENU


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y 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.
MENU_NBR DOUBLE Y The menu hierarchy for the given menu item.
PREV_MENU_NBR DOUBLE Y The menu hierarchy for the previous item (to the item selected).
REPORT_DESCRIPTION VARCHAR(50) N The name of the report as it appears in the menu.
SCRIPT_NAME VARCHAR(30) Y The name of the script executed when the user selects this report.
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_CC_PPP_CHARGE_ST



Column Section Top of Page


Table-level Detail

Description: Operations Profiling -- Cost center pay period data with charge measures.
Definition: omf_cc_ppp_charge_st
Table Type: ACTIVITY





Column Detail - OMF_CC_PPP_CHARGE_ST


Column Name Type Null? Definition
AGENCY_AMT DOUBLE Y The total amount of agency compensation paid for the cost center during the pay period. Agency is considered a productive pay type.
AGENCY_HRS DOUBLE Y The total amount of agency hours worked at the cost center during the pay period. Agency is consider a productive pay type.
CALLIN_AMT DOUBLE Y The total amount of call-in compensation paid for the cost center during the pay period. Call-In is considered a productive pay type.
CALLIN_HRS DOUBLE Y The total amount of call-in hours worked at the cost center during the pay period. Call-in is considered a productive pay type.
CHARGE_CNT DOUBLE Y The total number of charges generated by the cost center during the pay period.
COMMISSION_AMT DOUBLE Y The total amount of commissions and bonuses paid for the cost center during the pay period.
COST_CENTER_CD DOUBLE N Cost center
EMP_PAID_TAX DOUBLE Y The total amount of taxes paid by the employer for the cost center during the pay period.
OTHER_NONP_AMT DOUBLE Y The total amount of other non-productive compensation paid for the cost center during the pay period.
OTHER_NONP_HRS DOUBLE Y The total amount of other non-productive hours worked at the cost center during the pay period.
OTHER_PROD_AMT DOUBLE Y The total amount of other productive compensation paid for the cost center during the pay period.
OTHER_PROD_HRS DOUBLE Y The total amount of other productive hours worked at the cost center during the pay period.
OT_AMT DOUBLE Y The total amount of overtime compensation paid for the cost center during the pay period. Overtime is considered a productive pay type.
OT_HRS DOUBLE Y The total amount of overtime hours worked at the cost center during the pay period. Overtime is considered a productive pay type.
PERIOD_NBR DOUBLE Y The client defined pay period number.
PPP_END_DT_NBR DOUBLE Y The internal Cerner date representation of the day the pay period ended.
PPP_START_DT_NBR DOUBLE N The internal Cerner date representation of the day the pay period started.
REG_AMT DOUBLE Y The total amount of regular compensation paid for the cost center during the pay period.
REG_HRS DOUBLE Y The total amount of regular hours worked at the cost center during the pay period. Regular is considered a productive pay type.
STAND_BY_AMT DOUBLE Y The total amount of stand by compensation paid for the cost center during the pay period. Stand by is NOT considered a productive pay type.
STAND_BY_HRS DOUBLE Y The total amount of stand by hours worked for the cost center during the pay period. Stand by is NOT considered a productive pay type.
STD_HRS DOUBLE Y The standard number of hours in the pay period. This is the number of hours a full time person is expected to work during the pay period.
TIME_OFF_AMT DOUBLE Y The total amount of time off compensation paid for the cost center during the pay period. Time off is NOT considered a productive pay type.
TIME_OFF_HRS DOUBLE Y The total amount of time off hours for the cost center during the pay period. Time off is NOT considered a productive pay type.
TOT_CHARGE_AMT DOUBLE Y The total amount of charges generated by the cost center during the pay period.
TOT_HRS DOUBLE Y The total amount of personnel hours worked at the cost center during the pay period.
TOT_NONP_HRS DOUBLE Y The total amount of non-productive hours worked at the cost center during the pay period.
TOT_NONP_PAY DOUBLE Y The total amount of non-productive compensation paid for the cost center during the pay period.
TOT_PAY DOUBLE Y The total amount of compensation paid for the cost center during the pay period.
TOT_PROD_HRS DOUBLE Y The total amount of productive hours worked at the cost center during the pay period.
TOT_PROD_PAY DOUBLE Y The total amount of productive compensation (without commissions and bonuses) paid for the cost center during the pay period.
TOT_PROD_PAY_WC DOUBLE Y The total amount of productive compensation (with commissions and bonuses) paid for the cost center during the pay period.
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_CC_TS_CHARGE_ST



Column Section Top of Page


Table-level Detail

Description: Operations Profiling - Cost center timesheet data with charge measures
Definition: omf_cc_ts_charge_st
Table Type: ACTIVITY





Column Detail - OMF_CC_TS_CHARGE_ST


Column Name Type Null? Definition
ACTIVITY_DT_NBR DOUBLE N The internal Cerner date representation of the day on which personnel worked.
ACTIVITY_MIN_NBR DOUBLE N The minute of day, that represents the hour in which personnel worked. This also corresponds to the first minute of the hour (1, 61, 121, 181, 241 ... 1381).
ACTIVITY_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
CHARGE_CNT DOUBLE Y The total number of charges generated at the cost center during the hour.
COST_CENTER_CD DOUBLE N Cost center
PRSNL_CNT DOUBLE Y The number of personnel that worked at the cost center during some part of the hour.
TOT_CHARGE_AMT DOUBLE Y The total amount of charges generated by the cost center during the hour.
TOT_OT_PRSNL_HRS DOUBLE Y The total number of personnel overtime hours worked at the cost center during the hour.
TOT_OT_PRSNL_MIN DOUBLE Y The total number or personnel overtime minutes worked at the cost center during the hour.
TOT_PRSNL_HRS DOUBLE Y The total number of personnel hours worked at the cost center during the hour
TOT_PRSNL_MIN DOUBLE Y The total number of personnel minutes worked at the cost center during the hour.
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_CENSUS_SMRY_ST



Column Section Top of Page


Table-level Detail

Description: Daily census extract.
Definition: Summary table comprised of records extracted from omf_encntr_st to provide the daily census analysis data through PowerVision.
Table Type: ACTIVITY





Column Detail - OMF_CENSUS_SMRY_ST


Column Name Type Null? Definition
ALT_LEVEL_OF_CARE_DISCH_CNT DOUBLE Y The total number of encounters that were discharged from an Alternate Level of Care status between 00:00 and 23:59 on the census date.
ALT_LEVEL_OF_CARE_WAIT_DAYS DOUBLE Y For encounters that were discharged during the day from an Alternate Level of Care status on the census date: the total number of days that patients were in and Alternate Level of Care Status. This is the difference between the Alternate Level of Care Date/Time and the Discharge Date/Time.
CENSUS_DT_NBR DOUBLE Y The Julian date on which the census was taken.
CENSUS_DT_TM DATETIME Y The date/time on which the census was taken.
CENSUS_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
CURR_MTH_DISCH_PD DOUBLE Y The number of person days for patients discharged on the given date.
DISCH_CNT DOUBLE Y The total number of encounters that were discharged during the census date. If a patient expired during their encounter they will not be counted as a discharge.
ENCNTR_TYPE_CD DOUBLE N The code value for the encounter type.
EXPIRED_CNT DOUBLE Y The total number of persons that expired during the census date.
EXTENDED_LOA_RETURN_CNT DOUBLE Y The total number of patients that returned from an extended leave of absence during the census date.
FIN_CLASS_CD DOUBLE N Financial class code value.
INPATIENT_CNT DOUBLE Y The number of inpatients that have not been discharged as of 11:59pm on the census date.
INPATIENT_PD DOUBLE Y The total number of patient days for patients that had not been discharged as of 11:59pm on the census date.
ISOLATION_CD DOUBLE N The isolation code indicates that some level of isolation or restricted access is required or in place for this patient indicating special procedure or consideration to be used when dealing with the patient.
LOA_CNT DOUBLE Y The total number of encounters that are on leave of absence on the census date at 23:59.
LOC_BUILDING_CD DOUBLE N The code value for the building.
LOC_FACILITY_CD DOUBLE N The code value for the facility.
LOC_NURSE_UNIT_CD DOUBLE N The code value for the nurse unit.
MED_SERVICE_CD DOUBLE N The code value for the medical service.
NEW_EXTENDED_LOA_CNT DOUBLE Y The total number of encounters that were placed on extended leave of absence during the census date.
NEW_PEND_ARRIVAL_CNT DOUBLE Y The total number of encounters that were placed on pending arrival during the census date.
NEW_PEND_DISCH_CNT DOUBLE Y The total number of encounters that were placed on pending discharge during the census date.
OCCUPIED_BED_CNT DOUBLE Y The total number of beds occupied by patients that had not been discharged as of 11:59pm on the census date.
OCCUPIED_BED_PD DOUBLE Y The total number of patient days for patients that had not been discharged as of 11:59pm on the census date.
OMF_CENSUS_SMRY_ST_ID DOUBLE N The unique identifier for the omf_census_smry_st summary table.
ONE_DAY_STAY_CNT DOUBLE Y The total number of encounters that were both admitted and discharged on the census date.
PEND_ARRIVAL_ADMIT_CNT DOUBLE Y The total number of encounters that were admitted from a Pending Arrival status during the census date.
PEND_ARRIVAL_ADMIT_WAIT_DAYS DOUBLE Y For encounters that were admitted during the census date from a pending arrival status: the total number of days they waited. This is the difference between the encounter's Pending Date/Time and the Registration Date/Time.
PEND_DISCH_DISCH_CNT DOUBLE Y The total number of encounters that were discharged during the day from a pending discharge status.
PEND_DISCH_DISCH_WAIT_DAYS DOUBLE Y For encounters that were discharged from a pending discharge status on the census date: the total number of days they waited. This is the difference between the encounters Pending Date/Time (Discharge) and the Discharge Date/Time.
TOT_ADMIT_CNT DOUBLE Y The total number of encounters that were admitted on the census date.
TOT_ALT_LEVEL_OF_CARE_CNT DOUBLE Y The total number of encounters that are in an Alternate Level of Care and are occupying beds at 23:59 of the census date.
TOT_EXTENDED_LOA_CNT DOUBLE Y The total number of encounters that are on extended leave of absence at 23:59 of the census date.
TOT_PEND_ARRIVAL_CNT DOUBLE Y The total number of encounters that are in a pending arrival status at 23:59 of the census date.
TOT_PEND_DISCH_CNT DOUBLE Y The total number of encounters that are in a pending discharge status at 23:59 of the census date.
TRANSFER_IN_CNT DOUBLE Y The total number of encounters that were transferred into the nurse unit on the census date.
TRANSFER_OUT_CNT DOUBLE Y The total number of encounters that were transferred out of the nurse unit on the census date.
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_CE_MICROBIOLOGY_ST



Column Section Top of Page


Table-level Detail

Description: Stores microbiology data used by the Prologue team for their Care Prof views
Definition: omf_ce_mcirobiology_st
Table Type: ACTIVITY





Column Detail - OMF_CE_MICROBIOLOGY_ST


Column Name Type Null? Definition
EVENT_ID DOUBLE N Unique identifier to the event stored on the omf_clinical_event_st table.
MICRO_SEQ_NBR DOUBLE N Used to differentiate between microbiology events if more than one was done on the same event
ORGANISM_CD DOUBLE N Unique identifier for organism
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.