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