Table Detail Report

OMF_OUTCOME_RATE



Column Section Top of Page


Table-level Detail

Description: OMF OUTCOME RATE
Definition: stores the rate based indicators
Table Type: ACTIVITY





Column Detail - OMF_OUTCOME_RATE


Column Name Type Null? Definition
CLIENT_NBR DOUBLE N client number
GROUP_DENOM DOUBLE Y denominator for the peer group
GROUP_DENOM_MAX DOUBLE Y maximum denominator for the peer group
GROUP_DENOM_MEAN DOUBLE Y mean denominator for the peer group
GROUP_DENOM_MEDIAN DOUBLE Y median denominator for the peer group
GROUP_DENOM_MIN DOUBLE Y minimum denominator for the peer group
GROUP_NUMBER_HCO DOUBLE Y peer group number
GROUP_NUMER DOUBLE Y peer group numerator
GROUP_NUMER_MAX DOUBLE Y maximum peer group numerator
GROUP_NUMER_MEAN DOUBLE Y mean peer group numerator
GROUP_NUMER_MEDIAN DOUBLE Y median peer group numerator
GROUP_NUMER_MIN DOUBLE Y minimum peer group numerator
GROUP_RATE DOUBLE Y peer group value
GROUP_RATE_MAX DOUBLE Y maximum peer group value
GROUP_RATE_MEAN DOUBLE Y mean peer group value
GROUP_RATE_MEDIAN DOUBLE Y median peer group value
GROUP_RATE_MIN DOUBLE Y minimum peer group value
GROUP_RATE_STD_DEV DOUBLE Y standard deviation peer group value
GROUP_TOTAL_CASES DOUBLE Y peer group total cases
GROUP_TOTAL_CASES_FOR_RATIO DOUBLE Y total cases in peer group that qualified
HCO_DENOM_VALUE DOUBLE Y denominator for healthcare organization
HCO_NUMER_VALUE DOUBLE Y numerator for healthcare organization
HCO_OBS_RATE DOUBLE Y healthcare organization's observed rate
HCO_OBS_RATIO_STD_DEV DOUBLE Y healthcare organization observed rate standard deviation
HCO_RISK_ADJ_NUMBER_OF_CASES DOUBLE Y health care organizations risk adjusted number of cases
HCO_RISK_ADJ_RATE DOUBLE Y healthcare organization's risk adjusted rate
HCO_RISK_ADJ_RATE_STD_DEV DOUBLE Y standard deviation of healthcare organization's risk adjusted rate
HCO_RISK_ADJ_RATIO_STD_DEV DOUBLE Y standard deviation of healthcare organization's risk adjusted ratio
HCO_TOTAL_CASES DOUBLE Y healthcare organization's total cases
HCO_TOTAL_CASES_FOR_RATIO DOUBLE Y healthcare organization's total cases that qualified
INDICATOR_NBR DOUBLE N This is the Cerner defined number for this indicator
JCAHO_REPORTED_MEASURE_IND DOUBLE Y send this indicator to jcaho oryx
REPORTING_PERIOD DATETIME N reporting 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_PAYOR



Column Section Relationship Section Top of Page


Table-level Detail

Description: Contains the payor reference data from the OMF Accounts Receivable interface.
Definition: omf_payor
Table Type: ACTIVITY





Column Detail - OMF_PAYOR


Column Name Type Null? Definition
OMF_PAYOR_ID DOUBLE N The unique identifier for the omf_payor table.
PAYOR_CODE VARCHAR(50) Y An abbreviation for the payor.
PAYOR_GROUP VARCHAR(100) Y A descriptive name that groups payors together for analysis.
PAYOR_GROUP_CODE VARCHAR(50) Y An abbreviation for the payor_group.
PAYOR_ID DOUBLE N The unique identifier for the payor on the organization table.
PAYOR_NAME VARCHAR(100) Y A descriptive name that identifies a party that is responsible to pay this receivable.
PAYOR_TYPE VARCHAR(100) Y A descriptive name that groups payors together for analysis.
PAYOR_TYPE_CODE VARCHAR(50) Y An abbreviation for payor_type.
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.



Relationship Detail - OMF_PAYOR




Parent Column in OMF_PAYOR (PK) Child Table Name Child Column Name
Children: OMF_PAYOR_ID OMF_ACC_FACT OMF_PAYOR_ID
OMF_ACR_FACT OMF_PAYOR_ID


OMF_POSTED_CHARGE_ST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Stores charge data that has already been posted.
Definition: Stores charge data that has already been posted either by a foreign system or by ProFit.
Table Type: ACTIVITY





Column Detail - OMF_POSTED_CHARGE_ST


Column Name Type Null? Definition
ACCESSION VARCHAR(20) Y An accession uniquely identifies a specimen.
ACTIVITY_TYPE_CD DOUBLE N Department to which the activity belongs
ACT_DIRECT_FIX_COST DOUBLE Y The actual direct fixed cost.
ACT_DIRECT_VAR_COST DOUBLE Y The actual direct variable cost.
ACT_INDIRECT_FIX_COST DOUBLE Y The actual indirect fixed cost
ACT_INDIRECT_VAR_COST DOUBLE Y The actual indirect variable cost.
ACT_SERVICE_TO_CHARGE DOUBLE Y The actual turnaround time from the service date/time to the charge date/time (in minutes).
ADMIT_TYPE_CD DOUBLE N Stores the unique admission type for each patient
BILL_CODE_ID DOUBLE N Depending on the value in charge_mod_type_cd, this is either the value from 13030 that represents the suspense reason, or it is the value from 14002 that represents the bill code schedule.
BILL_ITEM_ID DOUBLE N The unique identifier for a bill item.
CATALOG_CD DOUBLE N The coded value for the order catalog for this order.
CDM_DESC VARCHAR(200) Y The charge description master description.
CDM_NBR VARCHAR(200) Y The charge description master number.
CHARGE_DESCRIPTION VARCHAR(200) Y The free text description for the charge.
CHARGE_DT_NBR DOUBLE Y The Julian date on which the charge occurred.
CHARGE_DT_TM DATETIME Y The date/time on which the charge occurred.
CHARGE_ITEM_ID DOUBLE N Charge Item ID uniquely identifies the charge. It is a foreign key to the Charge Table
CHARGE_MIN_NBR DOUBLE Y The minute of the day on which the charge occurred.
CHARGE_TYPE_CD DOUBLE N Represents the charge event: debit, credit, collection, no charge, etc.
CHARGE_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
COST_CENTER_CD DOUBLE N The cost center within which the charge occurred.
COST_CENTER_GRP_CD DOUBLE N Grouping of cost centers (14058)
CPT4_DESC VARCHAR(200) Y The CPT4 description as it applies to the charge.
CPT4_ID DOUBLE N The nomenclature id for the CPT4 code
CPT4_NBR VARCHAR(200) Y The CPT4 number as it applies to the charge
DEPARTMENT_CD DOUBLE N The code value for the performing department.
DISCOUNT_AMOUNT DOUBLE Y The discount amount applied to the charge.
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
ICD9_DESC VARCHAR(200) Y The ICD9 description as it applies to the charge.
ICD9_ID DOUBLE N The nomenclature id for the icd9 code.
ICD9_NBR VARCHAR(200) Y The ICD9 number as it applies to the charge.
INSTITUTION_CD DOUBLE N The code value for the performing institution.
INTERFACED_DT_NBR DOUBLE Y The Julian date for the interfaced date/time.
INTERFACED_DT_TM DATETIME Y The interfaced date/time.
INTERFACED_MIN_NBR DOUBLE Y The minute of day at which the charge was interfaced.
INTERFACE_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
ITEM_EXTENDED_PRICE DOUBLE Y The extended price for the charge item.
ITEM_PRICE DOUBLE Y The price for the charge item.
ITEM_QUANTITY DOUBLE Y The charge quantity.
LOC_FACILITY_CD DOUBLE N The code value for the patient facility.
LOC_NURSE_UNIT_CD DOUBLE N The code value for the patient nurse unit.
MANUAL_IND DOUBLE Y Indicates if this charge is currently on hold as a manual charge or if it has ever been on hold as a manual charge.
NOMENCLATURE_ID DOUBLE N The unique identifier for the charge nomenclature.
ORDER_DT_NBR DOUBLE Y The Julian date number for the date on which the order occurred.
ORDER_DT_TM DATETIME Y The date/time on which the order occurred.
ORDER_ID DOUBLE N The unique identifier for the order.
ORDER_MIN_NBR DOUBLE Y The minute of day on which the order occurred.
ORDER_PHYS_GRP_CD DOUBLE N The code value representing the order physician group.
ORDER_PHYS_ID DOUBLE N The unique identifier for the ordering physician.
ORDER_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
PAYOR_ID DOUBLE N The unique identifier for the organization that is the payor.
PERF_PHYS_GRP_CD DOUBLE N The code value representing the performing physician group.
PERF_PHYS_ID DOUBLE N The unique identifier for the performing physician
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
PROCESS_FLAG DOUBLE Y Indicates how to process data in batch mode.
PROCESS_FLG DOUBLE Y Indicates if the charge is pending, suspended/held, skipped, interfaced, combined or bundled.
REV_CAT_CD DOUBLE N The grouping of revenue codes (20769)
REV_CAT_GRP_CD DOUBLE N Grouping of revenue categories (25993)
REV_CODE_CD DOUBLE N Revenue code assigned to the CDM
SECTION_CD DOUBLE N The code value representing the performing section.
SERVICE_DT_NBR DOUBLE Y The Julian date on which the service for the charge was performed.
SERVICE_DT_TM DATETIME Y The date/time on which the service for the charge was performed.
SERVICE_MIN_NBR DOUBLE Y The minute of day on which the service for the charge was performed.
SERVICE_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
STD_DIRECT_FIX_COST DOUBLE Y The standard direct fixed cost.
STD_DIRECT_VAR_COST DOUBLE Y The standard direct variable cost.
STD_INDIRECT_FIX_COST DOUBLE Y The standard indirect fixed cost.
STD_INDIRECT_VAR_COST DOUBLE Y The standard indirect variable cost.
SUBSECTION_CD DOUBLE N The code value representing the subsection at which the service was performed.
TASK_ASSAY_CD DOUBLE N The code value representing the task assay that was performed.
TIER_GROUP_CD DOUBLE N The charge tier group code used to identity charges
TOTAL_ACT_COST DOUBLE Y The total actual cost.
TOTAL_STD_COST DOUBLE Y The total standard cost
TRANSACTION_IND DOUBLE Y The number of transactions.
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_POSTED_CHARGE_ST


Child Column in OMF_POSTED_CHARGE_ST(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
PERSON_ID PERSON PERSON_ID


OMF_PRSNL_PAYPERIOD_ST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Operations Profiling -- Personnel pay period data
Definition: omf_prsnl_payperiod_st
Table Type: ACTIVITY





Column Detail - OMF_PRSNL_PAYPERIOD_ST


Column Name Type Null? Definition
AGENCY_AMT DOUBLE Y The amount of agency pay earned during the pay period. The agency pay type is considered productive.
AGENCY_HRS DOUBLE Y The amount of agency hours worked during the pay period. The agency pay type is considered productive.
CALLIN_AMT DOUBLE Y The amount of call-in pay earned during the pay period. The call-in pay type is considered productive.
CALLIN_HRS DOUBLE Y The amount of call-in hours worked during the pay period. The call-in pay type is considered productive.
COMMISSION_AMT DOUBLE Y The amount of commission/bonus pay earned.
COST_CENTER_CD DOUBLE N The cost center to which the person is assigned to.
DEPARTMENT_CD DOUBLE N The department to which the person is assigned.
EMP_PAID_TAX DOUBLE Y The amount of taxes paid by the employer during the pay period.
EXP_HRS DOUBLE Y The number of hours the person is expected to have worked during the pay period.
EXTRACT_DT_TM DATETIME Y The date/time the data were extracted.
EXTRACT_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
FACILITY_CD DOUBLE N The facility were the person worked.
HIRE_DT_NBR DOUBLE Y The Cerner internal date representation of the day the person was hired.
OTHER_NONP_AMT DOUBLE Y The amount of other non-productive pay earned during the pay period.
OTHER_NONP_HRS DOUBLE Y The amount of other non-productive hours worked during the pay period.
OTHER_PROD_AMT DOUBLE Y The amount of other productive pay earned during the pay period.
OTHER_PROD_HRS DOUBLE Y The amount of other productive hours worked during the pay period.
OT_AMT DOUBLE Y The amount of overtime pay earned during the pay period. Overtime is considered a productive pay type.
OT_HRS DOUBLE Y The amount of overtime hours worked during the pay period. Overtime is considered a productive pay type.
PERIOD_END_DT_NBR DOUBLE Y The internal Cerner date representation of the day the pay period ended.
PERIOD_NBR DOUBLE Y The client defined pay period number.
PERIOD_START_DT_NBR DOUBLE Y The internal Cerner date representation of the day the pay period started.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
PERSON_POSITION_CD DOUBLE N The Cerner-defined position for the person.
PRSNL_ALIAS VARCHAR(200) Y The external personnel identifier used to import the pay period data.
PRSNL_ALIAS_POOL_CD DOUBLE N The set of identifiers the prsnl_alias belongs to.
PRSNL_PAYPERIOD_ID DOUBLE N The unique identifier for a row on the table.
REG_AMT DOUBLE Y The amount of regular pay earned during the pay period. Regular is considered a productive pay type.
REG_HRS DOUBLE Y The amount of regular hours worked during the pay period. Regular is considered a productive pay type.
ROLE_CD DOUBLE N The role of the person at the time of the pay period.
ROLE_GRP_CD DOUBLE N Role grouping
ROLE_START_DT_NBR DOUBLE Y The internal Cerner date representation of the day the person started working under the role.
STAND_BY_AMT DOUBLE Y The amount of stand by pay earned during the pay period. Stand by is NOT considered a productive pay type.
STAND_BY_HRS DOUBLE Y The amount of stand by hours worked 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 amount of time off pay earned during the pay period. Time off is NOT considered a productive pay type.
TIME_OFF_HRS DOUBLE Y The amount of time off hours the person used during the pay period. Time off is NOT considered a productive pay type.
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_PRSNL_PAYPERIOD_ST


Child Column in OMF_PRSNL_PAYPERIOD_ST(FK) Parent Table Name Parent Column Name
Parents: PERSON_ID PERSON PERSON_ID


OMF_PRSNL_TIMEDATE_ST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Operations Profiling - Personnel timesheet data
Definition: omf_prsnl_timedate_st
Table Type: ACTIVITY





Column Detail - OMF_PRSNL_TIMEDATE_ST


Column Name Type Null? Definition
COST_CENTER_CD DOUBLE N The cost center at which the person clocked in.
DEPARTMENT_CD DOUBLE N The department at which the person clocked in.
EXTRACT_DT_TM DATETIME Y The date/time when the data were extracted.
EXTRACT_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
FACILITY_CD DOUBLE N The facility at which the person clocked in.
HIRE_DT_NBR DOUBLE Y The internal Cerner date representation of the day the person was hired.
MISC_NUM_HRS DOUBLE Y The number of productive hours (excluding regular an overtime) worked during the work period.
MISC_NUM_MIN DOUBLE Y The number of productive minutes (excluding regular an overtime) worked during the work period.
NUM_HRS DOUBLE Y The number of hours worked from clock in to clock out.
NUM_MIN DOUBLE Y The number of minutes worked from clock in to clock out.
OT_NUM_HRS DOUBLE Y The number of overtime hours worked during the work period.
OT_NUM_MIN DOUBLE Y The number of overtime minutes worked during the work period.
OT_START_DT_NBR DOUBLE Y The internal Cerner date representation of the day which overtime started to accrue during the work period.
OT_START_DT_TM DATETIME Y The date/time at which overtime started to accrue during the work period.
OT_START_MIN_NBR DOUBLE Y The minute of the day which overtime started to accrue (1..1440).
OT_START_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
PERSON_POSITION_CD DOUBLE N The Cerner-defined position for the person.
PROCESS_FLAG DOUBLE Y Flag to determine those rows that need omf_prsnl_timehour_st rows built/updated.
PRSNL_ALIAS VARCHAR(200) Y The external personnel identifier used to import data.
PRSNL_ALIAS_POOL_CD DOUBLE N The set of identifiers from which the prsnl_alias originated from.
PRSNL_PAYPERIOD_ID DOUBLE N Not used.
PRSNL_TIMEDATE_ID DOUBLE N The unique row identifier for the table.
REG_NUM_HRS DOUBLE Y The number of regular hours worked during the work period.
REG_NUM_MIN DOUBLE Y The number of regular minutes worked during the work period.
ROLE_CD DOUBLE N The role of the person at the time of the clock in.
ROLE_GRP_CD DOUBLE N Role grouping
ROLE_START_DT_NBR DOUBLE Y The internal Cerner date representation of the day on which the person started the role.
SHIFT_GRP_CD DOUBLE N Not used
TIME_IN_DT_NBR DOUBLE Y The internal Cerner date representation of the day when the person clocked in.
TIME_IN_DT_TM DATETIME Y The date/time at which the person clocked in.
TIME_IN_MIN_NBR DOUBLE Y The minute of the day when the person clocked in (1..1440).
TIME_IN_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
TIME_OUT_DT_NBR DOUBLE Y The internal Cerner date representation of the day the person clocked out.
TIME_OUT_DT_TM DATETIME Y The date/time at which the person clocked out.
TIME_OUT_MIN_NBR DOUBLE Y The minute of the day when the person clocked out (1..1440).
TIME_OUT_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
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_PRSNL_TIMEDATE_ST


Child Column in OMF_PRSNL_TIMEDATE_ST(FK) Parent Table Name Parent Column Name
Parents: PERSON_ID PERSON PERSON_ID