Table Detail Report

OMF_ACC_FACT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Stores the transaction level data for the OMF A/R cash collections interface.
Definition: omf_acc_fact
Table Type: ACTIVITY





Column Detail - OMF_ACC_FACT


Column Name Type Null? Definition
CASH_COLLECTED DOUBLE Y The amount of cash collected during the period.
INTERFACE_DT_TM DATETIME Y The date/time the transaction was sent through the interface.
INTERFACE_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
NBR_PAYORS DOUBLE Y The number of payors (will always be 1 at the detail level).
OMF_ACC_FACT_ID DOUBLE N Unique identifier for the omf_acc_fact table.
OMF_FISCAL_DATE_ID DOUBLE N The unique identifier from the omf_fiscal_date table.
OMF_PAYOR_ID DOUBLE N The unique identifier from the omf_payor table.
REVENUE DOUBLE Y The amount of revenue billed during the period.
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_ACC_FACT


Child Column in OMF_ACC_FACT(FK) Parent Table Name Parent Column Name
Parents: OMF_FISCAL_DATE_ID OMF_FISCAL_CALENDAR OMF_FISCAL_CALENDAR_ID
OMF_PAYOR_ID OMF_PAYOR OMF_PAYOR_ID


OMF_ACR_FACT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Stores the transaction level data for the OMF accounts receivable interface.
Definition: omf_acr_fact
Table Type: ACTIVITY





Column Detail - OMF_ACR_FACT


Column Name Type Null? Definition
ACR_DT_NBR DOUBLE Y The date on which the account balance was copied.
ACR_END_OF_PERIOD_IND DOUBLE Y A Yes/No flag indicating that this is the last snapshot posted during the period.
ACR_MIN_NBR DOUBLE Y The minute on which the snapshot was taken.
ACR_MOST_RECENT_IND DOUBLE Y A Yes/No flag indicating that this is the most recent balance for the account or it is a historical balance.
BALANCE DOUBLE Y The dollar balance in the account.
BALANCE_AGE_CAT1 DOUBLE Y Payor balance aging category (i.e. 30, 60, 90, >90 days).
BALANCE_AGE_CAT2 DOUBLE Y Payor balance aging category (i.e. 30, 60, 90, >90 days).
BALANCE_AGE_CAT3 DOUBLE Y Payor balance aging category (i.e. 30, 60, 90, >90 days).
BALANCE_AGE_CAT4 DOUBLE Y Payor balance aging category (i.e. 30, 60, 90, >90 days).
BALANCE_AGE_CAT5 DOUBLE Y Payor balance aging category (i.e. 30, 60, 90, >90 days).
BALANCE_DIFF_PP DOUBLE Y The amount by which the account balance has changed since the end of the previous period.
INTERFACE_DT_TM DATETIME Y The date/time on which the transaction was interfaced.
INTERFACE_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
NBR_PAYORS DOUBLE Y The number of payors (always 1 at the lowest level).
NET_REV_PER_DAY DOUBLE Y Avg net revenue for the payor during recent months.
OMF_ACR_FACT_ID DOUBLE N The unique identifier for the omf_acr_fact table.
OMF_FISCAL_DATE_ID DOUBLE N The unique identifier for the omf_fiscal_date table
OMF_GL_ACCT_ID DOUBLE N The unique identifier for the omf_gl_acct table.
OMF_PAYOR_ID DOUBLE N The unique identifier for the omf_payor table.
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_ACR_FACT


Child Column in OMF_ACR_FACT(FK) Parent Table Name Parent Column Name
Parents: OMF_FISCAL_DATE_ID OMF_FISCAL_CALENDAR OMF_FISCAL_CALENDAR_ID
OMF_GL_ACCT_ID OMF_GL_ACCT OMF_GL_ACCT_ID
OMF_PAYOR_ID OMF_PAYOR OMF_PAYOR_ID


OMF_APC_CODING_ST



Column Section Relationship Section Top of Page


Table-level Detail

Description: The activity summary table storing the ambulatory payment classification data.
Definition: omf_apc_coding_st
Table Type: ACTIVITY





Column Detail - OMF_APC_CODING_ST


Column Name Type Null? Definition
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
NOMENCLATURE_ID DOUBLE N The unique identifier for the APC code
OMF_APC_CODING_ST_ID DOUBLE N The unique identifier for a row on the omf_apc_coding_st
RELATED_IDENTIFIER_STR VARCHAR(255) Y The concatenation of the CPT codes that make up the APC code.
RELATIVE_WEIGHT DOUBLE Y The weight assigned to an APC code.
STATUS_INDICATOR CHAR(1) Y The status indicator for the APC code.
TOTAL_EST_REIMB_VALUE DOUBLE Y The total estimated reimbursement for the APC code.
UPDT_APPLCTX DOUBLE N The update application
UPDT_CNT DOUBLE N The update count
UPDT_DT_TM DATETIME N The update date/time.
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 update task.



Relationship Detail - OMF_APC_CODING_ST


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


OMF_BLS_FACT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Stores the transaction level data for the OMF balance sheet interface.
Definition: omf_bls_fact
Table Type: ACTIVITY





Column Detail - OMF_BLS_FACT


Column Name Type Null? Definition
BALANCE DOUBLE Y The dollar balance in the account
BALANCE_DIFF_PP DOUBLE Y The amount the account balance has changed since the end of the previous period.
BLS_DT_NBR DOUBLE Y The date on which the snapshot of the balance sheet was taken.
BLS_END_OF_PERIOD_IND DOUBLE Y A yes/no flag indicating that this snapshot is the last one posted during the period.
BLS_MIN_NBR DOUBLE Y The minute on which the snapshot of the balance sheet was taken.
BLS_MOST_RECENT_IND DOUBLE Y A yes/no flag indicating this this snapshot is the most recent for the account of a historical balance.
INTERFACE_DT_TM DATETIME Y The date/time on which the transaction was sent through the interface.
INTERFACE_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
OMF_BLS_FACT_ID DOUBLE N The unique identifier for the omf_bls_fact table.
OMF_FISCAL_DATE_ID DOUBLE N The unique identifier for the omf_fiscal_date table.
OMF_GL_ACCT_ID DOUBLE N The unique identifier for the omf_gl_acct table.
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_BLS_FACT


Child Column in OMF_BLS_FACT(FK) Parent Table Name Parent Column Name
Parents: OMF_FISCAL_DATE_ID OMF_FISCAL_CALENDAR OMF_FISCAL_CALENDAR_ID
OMF_GL_ACCT_ID OMF_GL_ACCT OMF_GL_ACCT_ID


OMF_BM_CHA



Column Section Top of Page


Table-level Detail

Description: Stores Connecticut Health Association benchmark data.
Definition: omf_bm_cha
Table Type: ACTIVITY





Column Detail - OMF_BM_CHA


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.
BEG_EFFECTIVE_DT_TM DATETIME Y The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
END_EFFECTIVE_DT_TM DATETIME Y The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
HI_OUT_CNT DOUBLE Y HI LOS outlier count
HI_OUT_LOS DOUBLE Y Average LOS for high LOS outliers
HI_OUT_TOT_CHG DOUBLE Y Average total charges for high LOS outliers
IN_ANES_CHG DOUBLE Y Inlier average anesthesia charges.
IN_BED_CHG DOUBLE Y Inlier average room charges
IN_CHG1 DOUBLE Y Inlier average user defined charges1
IN_CHG10 DOUBLE Y Inlier average user defined charges10
IN_CHG2 DOUBLE Y Inlier average user defined charges2
IN_CHG3 DOUBLE Y Inlier average user defined charges3
IN_CHG4 DOUBLE Y Inlier average user defined charges4
IN_CHG5 DOUBLE Y Inlier average user defined charges5
IN_CHG6 DOUBLE Y Inlier average user defined charges6
IN_CHG7 DOUBLE Y Inlier average user defined charges7
IN_CHG8 DOUBLE Y Inlier average user defined charges8
IN_CHG9 DOUBLE Y Inlier average user defined charges9
IN_CHG_NBR_PATIENTS DOUBLE Y Total inlier patients with charges.
IN_CNT DOUBLE Y Inlier count
IN_ER_CHG DOUBLE Y Inlier average emergency room charges
IN_ICU_CCU_CHG DOUBLE Y Inlier average ICU/CCU charges
IN_ICU_LOS DOUBLE Y Inlier ICU average length of stay.
IN_LABOR_DELIV_CHG DOUBLE Y Inlier average labor/delivery room charges
IN_LAB_CHG DOUBLE Y Inlier average laboratory charges
IN_LAB_CHG_STDDEV DOUBLE Y Inlier laboratory charges standard deviation
IN_LOS DOUBLE Y Inlier average LOS
IN_LOS1 DOUBLE Y Inlier average user defined LOS1
IN_LOS2 DOUBLE Y Inlier average user defined LOS2
IN_LOS3 DOUBLE Y Inlier average user defined LOS3
IN_LOS4 DOUBLE Y Inlier average user defined LOS4
IN_LOS5 DOUBLE Y Inlier average user defined LOS5
IN_LOS_STDDEV DOUBLE Y Inlier LOS standard deviation
IN_MED_SURG_SUPP_CHG DOUBLE Y Inlier average medical/surgical supply charges
IN_MED_SURG_SUPP_CHG_STDDEV DOUBLE Y Inlier medical/surgical supply charges standard deviation.
IN_NBR_DEATHS DOUBLE Y Total deaths for hospitals in the norms
IN_NUCL_MED_CHG DOUBLE Y Inlier average nuclear medicine charges.
IN_NURSERY_CHG DOUBLE Y Inlier average nursery charges
IN_OR_CHG DOUBLE Y Inlier average operating room charges.
IN_OTHER_CHG DOUBLE Y Inlier average all other charges
IN_PHARM_CHG DOUBLE Y Inlier average pharmacy charges
IN_PHARM_CHG_STDDEV DOUBLE Y Inlier pharmacy charges standard deviation.
IN_PT_CHG DOUBLE Y Inlier average physical therapy charges
IN_RAD_CHG DOUBLE Y Inlier average radiology charges.
IN_RAD_CHG_STDDEV DOUBLE Y Inlier radiology charges standard deviation
IN_RECOV_CHG DOUBLE Y Inlier average recovery room charges
IN_RELATIVE_WEIGHT DOUBLE Y Inlier relative weight
IN_RESP_CHG DOUBLE Y Inlier average respiratory services charges
IN_ROM_NBR_PATIENTS DOUBLE Y Total patients for hospitals in norms for risk of mortality subclass.
IN_SOI_NBR_PATIENTS DOUBLE Y Total patients for hospitals in norms for severity of illness subclass
IN_TOT_CHG DOUBLE Y Inlier average total charges
IN_TOT_CHG_STDDEV DOUBLE Y Inlier total charges standard deviation
LOW_OUT_CNT DOUBLE Y Los LOS outlier count
LOW_OUT_LOS DOUBLE Y Average LOS for low LOS outliers
LOW_OUT_TOT_CHG DOUBLE Y Average total charges for low LOS outliers
NOMENCLATURE_ID DOUBLE N The nomenclature ID for the APRDRG code.
OMF_BM_CHA_ID DOUBLE N The unique identifier for the benchmark row.
SUBCLASS_NBR DOUBLE Y Subclass value (1 - Minor, 2 - Moderate, 3- Major, 4- Extreme) for Severity of Illness or Risk of Mortality.
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.