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 |