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