Table Detail Report
RC_F_GENERAL_AR_BAL_TRANS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | RC_F_GENERAL_AR_BAL_TRANS |
Definition: | Revenue Cycle Fact General Accounts Receivable Balance Transaction |
Table Type: | ACTIVITY |
Column Detail - RC_F_GENERAL_AR_BAL_TRANS
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVITY_DT_NBR | DOUBLE | N | A number representing the activity date. References the key in the OMF_DATE table. |
MILL_ACTIVITY_ID | DOUBLE | N | Number that identifies the row in the pft_trans_reltn millennium database table from which this row was derived. |
MILL_LOGICAL_DOMAIN_ID | DOUBLE | N | Uniquely identifies the logical domain to which the row data belongs. |
POST_DT_NBR | DOUBLE | N | A number representing the post date. References the key in the OMF_DATE table. |
RC_D_ACCOUNT_ID | DOUBLE | N | Uniquely identifies a row on the Account Dimension row related to this fact row |
RC_D_ACCOUNT_TYPE_ID | DOUBLE | N | Unique genereated number that identifies the row on the rc_d_account_type table related to this fact. |
RC_D_BILLING_ENTITY_ID | DOUBLE | N | Uniquely identifies the Billing Entity Dimension row related to this fact row. |
RC_D_TRANSACTION_ALIAS_ID | DOUBLE | N | Uniquely identifies a Transaction Alias Dimension row related to this fact row |
RC_D_TRANSACTION_BATCH_ID | DOUBLE | N | Uniquely identifies a Transaction Batch Dimension row related to this fact row |
RC_D_TRANSACTION_TYPE_ID | DOUBLE | N | Uniquely identifies a Transaction Type Dimension row realted to this fact row |
RC_F_GENERAL_AR_BAL_TRANS_ID | DOUBLE | N | PRIMARY KEY |
SHR_D_POSTING_PRSNL_ID | DOUBLE | N | Uniquely identifies a row on the Shared Person Dimension table that represents the person who posted the information about the related fact row |
TIME_ZONE_INDEX | DOUBLE | N | Stores the time zone from which the data was extracted |
TRANSACTION_AMT | DOUBLE | N | Contains the dollar amount associated to the given transaction |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
Relationship Detail - RC_F_GENERAL_AR_BAL_TRANS
Child Column in RC_F_GENERAL_AR_BAL_TRANS(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ACTIVITY_DT_NBR | OMF_DATE | DT_NBR |
POST_DT_NBR | OMF_DATE | DT_NBR | |
RC_D_ACCOUNT_ID | RC_D_ACCOUNT | RC_D_ACCOUNT_ID | |
RC_D_ACCOUNT_TYPE_ID | RC_D_ACCOUNT_TYPE | RC_D_ACCOUNT_TYPE_ID | |
RC_D_BILLING_ENTITY_ID | RC_D_BILLING_ENTITY | RC_D_BILLING_ENTITY_ID | |
RC_D_TRANSACTION_ALIAS_ID | RC_D_TRANSACTION_ALIAS | RC_D_TRANSACTION_ALIAS_ID | |
RC_D_TRANSACTION_BATCH_ID | RC_D_TRANSACTION_BATCH | RC_D_TRANSACTION_BATCH_ID | |
RC_D_TRANSACTION_TYPE_ID | RC_D_TRANSACTION_TYPE | RC_D_TRANSACTION_TYPE_ID | |
SHR_D_POSTING_PRSNL_ID | SHR_D_PERSON | SHR_D_PERSON_ID |
RC_F_INVOICE_AR_BALANCE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Revenue Cycle Fact Invoice AR Balance |
Definition: | This table contains data related to client invoices. |
Table Type: | ACTIVITY |
Column Detail - RC_F_INVOICE_AR_BALANCE
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVITY_DT_NBR | DOUBLE | N | A number representing the activity date. References the key in the OMF_DATE table. |
ADMIT_DT_NBR | DOUBLE | N | A number representing the admit date. |
BALANCE_AMT | DOUBLE | N | ** Obsolete ** This column is no longer being used. Contains the invoice balance. ** Obsolete ** |
BILL_AGE | DOUBLE | N | ** Obsolete ** This column is no longer being used. Contains the number of days that result from the difference between the current activity data and the transmission date of the bill. ** Obsolete ** |
BILL_NUMBER_IDENT | VARCHAR(40) | N | Contains the display value associated to a bill number. |
DAILY_ADJUSTMENT_AMT | DOUBLE | N | ** Obsolete ** - No longer used. Contains the adjustment amount per day. ** Obsolete ** |
DAILY_CHARGE_AMT | DOUBLE | N | ** Obsolete ** - No longer used. Contains the daily charge amount per day. ** Obsolete **. |
DAILY_PAYMENT_AMT | DOUBLE | N | ** Obsolete ** - No longer used. Contains the payment amount per day. ** Obsolete ** |
DISCHARGE_DT_NBR | DOUBLE | Y | The Discharge Date of the Patient |
FIN_NBR_IDENT | VARCHAR(50) | N | Financial Number of the patient |
FIRST_PROCESS_DT_TM | DATETIME | N | The date/time that the first ETL process started that created this record. |
INVOICE_AGE | DOUBLE | N | Contains the number of days that result from the difference between the current activity date and the submission date of the bill. |
INVOICE_BALANCE_AMT | DOUBLE | Y | Contains the invoice balance due. |
INVOICE_GENERATION_DT_NBR | DOUBLE | N | Date the invoice was generated. |
INVOICE_LAST_ADJUSTMENT_DT_NBR | DOUBLE | N | Date of the last time a adjusment was made to the financial encounter. |
INVOICE_LAST_PAYMENT_DT_NBR | DOUBLE | N | Date of the last time a payment was made against the invoice. |
INVOICE_ORIG_BALANCE_AMT | DOUBLE | N | Contains the original invoice balance. |
INVOICE_SUBMISSION_DT_NBR | DOUBLE | Y | The date the invoice was submited |
INVOICE_TOTAL_ADJUSTMENT_AMT | DOUBLE | N | Contains the total of the adjustments at invoice level |
INVOICE_TOTAL_CHARGE_AMT | DOUBLE | N | Contains the total of the charges at invoice level |
INVOICE_TOTAL_PAYMENT_AMT | DOUBLE | N | Contains the total of the payments at invoice level |
INVOICE_TRANSMISSION_DT_NBR | DOUBLE | N | The date the invoice was transmitted |
LAST_ADJUSTMENT_DT_NBR | DOUBLE | N | ** Obsolete ** - No longer used. Date of the last time a adjusment was made to the financial encounter. ** Obsolete ** |
LAST_CHARGE_DT_NBR | DOUBLE | N | ** Obsolete ** No longer being used. Date of the last time a charge was posted to the financial encounter. ** Obsolete ** |
LAST_PAYMENT_DT_NBR | DOUBLE | N | ** Obsolete ** - No longer being used. Date of the last time a payment was made to the financial encounter. ** Obsolete ** |
LAST_PROCESS_DT_TM | DATETIME | N | The date/time that the last ETL process started that updated this record. |
MILL_CORSP_ID | DOUBLE | N | Uniquely identifies the related BILL_REC row on Millennium. |
MILL_LOGICAL_DOMAIN_ID | DOUBLE | N | Uniquely identifies the logical domain to which the row data belongs. |
MILL_PFT_ENCNTR_ID | DOUBLE | N | Uniquely identifies the Millennium Profit Encounter record that relates to this fact row. |
MRN_NBR_IDENT | VARCHAR(50) | N | Identifier of a medical record number. |
ORIGINAL_BILL_DT_NBR | DOUBLE | N | ** Obsolete ** This column is no longer being used. A number representing the original bill date. References the key in the OMF_DATE table. ** Obsolete ** |
RC_D_ACCOUNT_ID | DOUBLE | N | Uniquely identifies account information related to this fact. |
RC_D_ACCOUNT_TYPE_ID | DOUBLE | N | Unique genereated number that identifies the row on the rc_d_account_type table related to this fact. |
RC_D_AGE_BY_BILL_ID | DOUBLE | N | ** Obsolete ** This column is no longer being used. Relates this fact row to a specific age category. ** Obsolete ** |
RC_D_AGE_BY_INVOICE_ID | DOUBLE | N | Relates this fact row to a specific age category. |
RC_D_BILLING_ENTITY_ID | DOUBLE | N | Uniquely identifies the billing entity related to this fact row. |
RC_D_BILL_PROPERTY_ID | DOUBLE | N | Uniquely identifies bill property information related to this fact row |
RC_D_ENCNTR_TYPE_CLASS_ID | DOUBLE | N | Uniquely identifies encounter type class information related to this fact row |
RC_F_INVOICE_AR_BALANCE_ID | DOUBLE | N | Uniquely identifies data related to client invoices. |
SHR_D_LOCATION_ID | DOUBLE | N | Uniquely identifies location information related to this fact row. |
SHR_D_PERSON_ID | DOUBLE | N | Uniquely identifies person information related to this fact row. |
TIME_ZONE_INDEX | DOUBLE | N | Stores the time zone from which the data was extracted |
TOTAL_ADJUSTMENT_AMT | DOUBLE | N | ** Obsolete ** No longer being used. The total of the adjustments. ** Obsolete ** |
TOTAL_CHARGE_AMT | DOUBLE | N | ** Obsolete ** - No longer used. The total of the charges. ** Obsolete ** |
TOTAL_PAYMENT_AMT | DOUBLE | N | ** Obsolete ** No longer used. The total of the payments. ** Obsolete ** |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
Relationship Detail - RC_F_INVOICE_AR_BALANCE
Child Column in RC_F_INVOICE_AR_BALANCE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ACTIVITY_DT_NBR | OMF_DATE | DT_NBR |
DISCHARGE_DT_NBR | OMF_DATE | DT_NBR | |
INVOICE_GENERATION_DT_NBR | OMF_DATE | DT_NBR | |
INVOICE_LAST_ADJUSTMENT_DT_NBR | OMF_DATE | DT_NBR | |
INVOICE_LAST_PAYMENT_DT_NBR | OMF_DATE | DT_NBR | |
INVOICE_SUBMISSION_DT_NBR | OMF_DATE | DT_NBR | |
INVOICE_TRANSMISSION_DT_NBR | OMF_DATE | DT_NBR | |
LAST_ADJUSTMENT_DT_NBR | OMF_DATE | DT_NBR | |
LAST_CHARGE_DT_NBR | OMF_DATE | DT_NBR | |
LAST_PAYMENT_DT_NBR | OMF_DATE | DT_NBR | |
RC_D_ACCOUNT_ID | RC_D_ACCOUNT | RC_D_ACCOUNT_ID | |
RC_D_ACCOUNT_TYPE_ID | RC_D_ACCOUNT_TYPE | RC_D_ACCOUNT_TYPE_ID | |
RC_D_AGE_BY_BILL_ID | RC_D_AGE_CATEGORY | RC_D_AGE_CATEGORY_ID | |
RC_D_AGE_BY_INVOICE_ID | RC_D_AGE_CATEGORY | RC_D_AGE_CATEGORY_ID | |
RC_D_BILLING_ENTITY_ID | RC_D_BILLING_ENTITY | RC_D_BILLING_ENTITY_ID | |
RC_D_BILL_PROPERTY_ID | RC_D_BILL_PROPERTY | RC_D_BILL_PROPERTY_ID | |
RC_D_ENCNTR_TYPE_CLASS_ID | RC_D_ENCNTR_TYPE_CLASS | RC_D_ENCNTR_TYPE_CLASS_ID | |
SHR_D_LOCATION_ID | SHR_D_LOCATION | SHR_D_LOCATION_ID | |
SHR_D_PERSON_ID | SHR_D_PERSON | SHR_D_PERSON_ID |
RC_F_INVOICE_AR_BAL_INV
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Revenue Cycle Fact Invoice AR Balance |
Definition: | This table contains summarized client AR balance data at the account level. |
Table Type: | ACTIVITY |
Column Detail - RC_F_INVOICE_AR_BAL_INV
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | N | 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. |
ACTIVE_STATUS_CD | DOUBLE | N | Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc. |
ACTIVE_STATUS_DT_TM | DATETIME | N | The date and time that the active_status_cd was set. |
ACTIVE_STATUS_PRSNL_ID | DOUBLE | N | The person who caused the active_status_cd to be set or change. |
ACTIVITY_DT_NBR | DOUBLE | N | A number representing the activity date. References the key in the OMF_DATE table. |
BALANCE_AMT | DOUBLE | N | The invoice balance amount that is due. |
BEG_EFFECTIVE_DT_TM | DATETIME | N | 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 | N | 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. |
FIRST_PROCESS_DT_TM | DATETIME | N | The date/time that the first ETL process started that created this record. |
GENERATION_DT_NBR | DOUBLE | N | The date the invoice was generated. |
INVOICE_AGE | DOUBLE | N | Contains the number of days that result from the difference between the current activity date and the submission date of the bill. |
INVOICE_IDENT | VARCHAR(40) | N | Contains the display value assoicated to an invoice. |
LAST_ADJUSTMENT_DT_NBR | DOUBLE | N | A number representing the most recent adjustment date of this balance fact row. References the key in the OMF_DATE table. |
LAST_PAYMENT_DT_NBR | DOUBLE | N | Date of the last time a payment was made against the invoice. Related to the OMF_DATE table. |
LAST_PROCESS_DT_TM | DATETIME | N | The date/time that the last ETL process started that updated this record. |
MILL_CORSP_ID | DOUBLE | N | Uniquely identifies the related row on the Millennium BILL_REC table |
MILL_LOGICAL_DOMAIN_ID | DOUBLE | N | Uniquely identifies the related logical domain record. |
ORIG_BALANCE_AMT | DOUBLE | Y | Contains the original invoice balance. |
RC_D_ACCOUNT_ID | DOUBLE | N | Uniquely identifies account information related to this fact row. |
RC_D_ACCOUNT_TYPE_ID | DOUBLE | N | Uniquely identifies account type information related to this fact row. |
RC_D_AGE_BY_INVOICE_ID | DOUBLE | N | Relates this fact row to a specific age category. |
RC_D_BILLING_ENTITY_ID | DOUBLE | N | Uniquely identifiies the billing entity related to this fact row. |
RC_F_INVOICE_AR_BAL_INV_ID | DOUBLE | N | Contains accounts receivable balance invoice summary information. |
SUBMISSION_DT_NBR | DOUBLE | N | The date the invoice was submitted. Relates to the OMF Date table. |
TIME_ZONE_INDEX | DOUBLE | N | Stores the time zone from which the data was extracted. |
TOTAL_ADJUSTMENT_AMT | DOUBLE | Y | The total adjustment made against the invoice. |
TOTAL_CHARGE_AMT | DOUBLE | Y | The total charge made against the invoice. |
TOTAL_PAYMENT_AMT | DOUBLE | Y | The total payment made against the invoice. |
TRANSMISSION_DT_NBR | DOUBLE | N | The date the invoice was transmitted. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
Relationship Detail - RC_F_INVOICE_AR_BAL_INV
Child Column in RC_F_INVOICE_AR_BAL_INV(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ACTIVITY_DT_NBR | OMF_DATE | DT_NBR |
GENERATION_DT_NBR | OMF_DATE | DT_NBR | |
LAST_ADJUSTMENT_DT_NBR | OMF_DATE | DT_NBR | |
LAST_PAYMENT_DT_NBR | OMF_DATE | DT_NBR | |
SUBMISSION_DT_NBR | OMF_DATE | DT_NBR | |
TRANSMISSION_DT_NBR | OMF_DATE | DT_NBR | |
RC_D_ACCOUNT_ID | RC_D_ACCOUNT | RC_D_ACCOUNT_ID | |
RC_D_ACCOUNT_TYPE_ID | RC_D_ACCOUNT_TYPE | RC_D_ACCOUNT_TYPE_ID | |
RC_D_AGE_BY_INVOICE_ID | RC_D_AGE_CATEGORY | RC_D_AGE_CATEGORY_ID | |
RC_D_BILLING_ENTITY_ID | RC_D_BILLING_ENTITY | RC_D_BILLING_ENTITY_ID |
RC_F_INVOICE_AR_BAL_SMRY
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Revenue Cycle Fact Invoice Accounts Receivable Balance |
Definition: | This table contains summarized client AR balance data at the account level. |
Table Type: | ACTIVITY |
Column Detail - RC_F_INVOICE_AR_BAL_SMRY
Column Name | Type | Null? | Definition |
---|---|---|---|
BEGIN_BALANCE_AMT | DOUBLE | Y | The beginning balance amount. |
BEGIN_DT_NBR | DOUBLE | N | The beginning date. References the OMF_DATE table. |
DAILY_ADJUSTMENT_AMT | DOUBLE | Y | The Daily Adjustment amount associated to the encounter. |
DAILY_CHARGE_AMT | DOUBLE | Y | The Daily Charge amount associated to the encounter. |
DAILY_PAYMENT_AMT | DOUBLE | Y | The daily payment amount associate to the encounter. |
END_BALANCE_AMT | DOUBLE | Y | The ending balance amount |
END_DT_NBR | DOUBLE | N | The ending date number. References the OMF_DATE table. |
FIRST_PROCESS_DT_TM | DATETIME | N | The date/time that the first ETL process started that created this record. |
LAST_INVOICE_ADJUSTMENT_DT_NBR | DOUBLE | N | The date of the last time an adjustment was made against the invoice. |
LAST_INVOICE_AMT | DOUBLE | N | The total charge amount against the invoice. |
LAST_INVOICE_DT_NBR | DOUBLE | N | The date the last invoice was generated. References the OMF Date table. |
LAST_INVOICE_PAYMENT_DT_NBR | DOUBLE | N | Date of the last time a payment was made against the invoice. |
LAST_PROCESS_DT_TM | DATETIME | N | The date/time that the last ETL process started that updated this record. |
MILL_LOGICAL_DOMAIN_ID | DOUBLE | N | Uniquely identifies the related logical domain record. |
RC_D_ACCOUNT_ID | DOUBLE | N | Uniquely identifies account information related to this fact. |
RC_D_ACCOUNT_TYPE_ID | DOUBLE | N | Unique genereated number that identifies the row on the rc_d_account_type table related to this fact. |
RC_D_BILLING_ENTITY_ID | DOUBLE | N | Uniquely identifies the billing entity related to this fact row. |
RC_F_INVOICE_AR_BAL_SMRY_ID | DOUBLE | N | Unique generated number that identifies a single row on the RC_F_INVOICE_AR_BAL_SMRY table. |
TIME_ZONE_INDEX | DOUBLE | N | Stores the time zone from which the data was extracted. |
UNBILLED_CHARGE_AMT | DOUBLE | Y | The total charges that have not been billed yet. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
Relationship Detail - RC_F_INVOICE_AR_BAL_SMRY
Child Column in RC_F_INVOICE_AR_BAL_SMRY(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | BEGIN_DT_NBR | OMF_DATE | DT_NBR |
END_DT_NBR | OMF_DATE | DT_NBR | |
LAST_INVOICE_ADJUSTMENT_DT_NBR | OMF_DATE | DT_NBR | |
LAST_INVOICE_DT_NBR | OMF_DATE | DT_NBR | |
LAST_INVOICE_PAYMENT_DT_NBR | OMF_DATE | DT_NBR | |
RC_D_ACCOUNT_ID | RC_D_ACCOUNT | RC_D_ACCOUNT_ID | |
RC_D_ACCOUNT_TYPE_ID | RC_D_ACCOUNT_TYPE | RC_D_ACCOUNT_TYPE_ID | |
RC_D_BILLING_ENTITY_ID | RC_D_BILLING_ENTITY | RC_D_BILLING_ENTITY_ID |
RC_F_MONTHLY_CDM_SMRY
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Revenue Cycle Fact Monthly CDM Summary |
Definition: | Contains charges aggregated by CDM at a Monthly level. |
Table Type: | ACTIVITY |
Column Detail - RC_F_MONTHLY_CDM_SMRY
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVITY_YEAR | DOUBLE | N | Contains the year in which the activity took place. |
CDM_FULL_IMPL_FAC_RVU_NBR | DOUBLE | Y | This field contains the CDM fully implemented facility relative value units associated to a charge. |
CDM_FULL_IMPL_NON_FAC_RVU_NBR | DOUBLE | Y | This field contains the CDM fully implemented non-facility relative value units associated to a charge. |
CDM_MALPRACTICE_RVU_NBR | DOUBLE | Y | This field contains the CDM malpractice relative value units associated to a charge. |
CDM_RVU_NBR | DOUBLE | Y | This field contains the cdm relative value units associated to a charge. |
FIRST_PROCESS_DT_TM | DATETIME | N | The date/time that the first ETL process started that created this record. |
FULL_IMPL_FAC_RVU_NBR | DOUBLE | Y | This field contains the fully implemented facility relative value units associated to a charge. |
FULL_IMPL_NONFAC_RVU_NBR | DOUBLE | Y | This field contains the fully implemented non-facility relative value unites associated to a charge. |
HCPCS_FULL_IMPL_FAC_RVU_NBR | DOUBLE | Y | This field containes the HCPCS fully implemented facility relative value units associated to a charge. |
HCPCS_FULL_IMPL_NONFAC_RVU_NBR | DOUBLE | Y | This field contains the HCPCS fully implemented non-facility relative value units associated to a charge. |
HCPCS_MALPRACTICE_RVU_NBR | DOUBLE | Y | This field contains the HCPCS malpractice relative value units associated to a charge. |
HCPCS_RVU_NBR | DOUBLE | Y | This field contains the HCPCS work relative value units associated to a charge. |
LAST_PROCESS_DT_TM | DATETIME | N | The date/time that the last ETL process started that updated this record. |
MALPRACTICE_RVU_NBR | DOUBLE | Y | This field contains the malpractice relative value units associated to a charge. |
MILL_LOGICAL_DOMAIN_ID | DOUBLE | N | Uniquely identifies the logical domain to which the row data belongs. |
RC_D_ACCOUNT_TYPE_ID | DOUBLE | N | Uniquely identifies the related account type. |
RC_D_ADMIT_PHYS_SPECIALTY_ID | DOUBLE | N | This is a foreign key that identifies the specialty assigned to the admitting physician in a given location in the fact table. |
RC_D_ATTEND_PHYS_SPECIALTY_ID | DOUBLE | N | This is a foreign key that identifies the specialty assigned to the attending physician in a given location in the fact table. |
RC_D_BILLING_ENTITY_ID | DOUBLE | N | Uniquely identifies the billing entity associated to the encounter associated to this CDM summary record. |
RC_D_BILL_ITEM_ID | DOUBLE | N | Uniquely identifies the bill item related to this fact row. |
RC_D_CONSULT_PHYS_SPECIALTY_ID | DOUBLE | N | This is a foreign key that identifies the specialty assigned to the consulting physician in a given location in the fact table. |
RC_D_CPT_MODIFIER_ID | DOUBLE | N | Uniquely identifies the related CPT Modifier |
RC_D_ENCNTR_TYPE_CLASS_ID | DOUBLE | N | Uniquely identifies the encounter type class of the encounter associated to this fact row. |
RC_D_FINANCIAL_CLASS_ID | DOUBLE | N | Uniquely identifies the financial class of the health plan associated to this fact row. |
RC_D_GL_ALIAS_ID | DOUBLE | N | Uniquely identifies the GL Alias information associated to this fact row. |
RC_D_HCPCS_MODIFIER_ID | DOUBLE | N | Uniquely identifies the related HCPCS Modifier. |
RC_D_HEALTH_PLAN_ID | DOUBLE | N | Uniquely identifies the health plan associated to this fact row. |
RC_D_MEDICAL_SERVICE_ID | DOUBLE | N | Uniquely identifies the medical service of the encounter associated to this fact row. |
RC_D_ORDER_PHYS_SPECIALTY_ID | DOUBLE | N | This is a foreign key that identifies the specialty assigned to the ordering physician in a given location in the fact table. |
RC_D_PERFORM_PHYS_SPECIALTY_ID | DOUBLE | N | This is a foreign key that identifies the specialty assigned to the performing physician in a given location in the fact table. |
RC_D_REFER_PHYS_SPECIALTY_ID | DOUBLE | N | This is a foreign key that identifies the specialty assigned to the refering physician in a given location in the fact table. |
RC_D_REND_PHYS_SPECIALTY_ID | DOUBLE | N | This is a foreign key that identifies the specialty assigned to the rendering physician in a given location in the fact table. |
RC_D_SUPERV_PHYS_SPECIALTY_ID | DOUBLE | N | This is a foreign key that identifies the specialty assigned to the supervising physician in a given location in the fact table. |
RC_D_TIER_GROUP_ID | DOUBLE | N | Uniquely identifies the tier group related to this fact row. |
RC_F_MONTHLY_CDM_SMRY_ID | DOUBLE | N | Uniquely identifies charges by CDM aggregated at a Monthly level. |
RELATIVE_VALUE_UNITS_QTY | DOUBLE | N | Workload units associated to a charge. |
SHR_D_ADMIT_PHYSICIAN_ID | DOUBLE | N | Represents the person who was the admitting physician for the related fact row. |
SHR_D_ATTEND_PHYSICIAN_ID | DOUBLE | N | Represents the person who was the attending physician for the related fact row. |
SHR_D_CONSULT_PHYSICIAN_ID | DOUBLE | N | Represents the person who was the consulting physician for the related fact row. |
SHR_D_LOCATION_ID | DOUBLE | N | Uniquely identifies the patient encounter location related to this fact row. |
SHR_D_MONTH_ID | DOUBLE | N | Uniquely identifies the month related to this fact row. |
SHR_D_ORDER_PHYSICIAN_ID | DOUBLE | N | Represents the person who was the ordering physician for the related fact rows. |
SHR_D_PERFORM_PHYSICIAN_ID | DOUBLE | N | Represents the person who was the performing physician for the related fact row. |
SHR_D_REFER_PHYSICIAN_ID | DOUBLE | N | Represents the person who was the referring physician for the related fact row. |
SHR_D_REND_PHYSICIAN_ID | DOUBLE | N | Uniquely identifies a row on the shared person dimension table that represents the person who was the rendering/primary physician about the related fact row. |
SHR_D_SUPERV_PHYSICIAN_ID | DOUBLE | N | Uniquely identifies supervising physician information related to this fact row. |
TOTAL_CHARGE_AMT | DOUBLE | N | Represents the total transaction amount of all the transactions aggregated into the summary row. |
TOTAL_SERVICE_UNITS | DOUBLE | N | The total amount of units associated to an individual charge. |
TOTAL_TRANSACTIONS | DOUBLE | N | The total number of transactions represented in this summary row. |
UNIT_PRICE_AMT | DOUBLE | N | The price per unit for the charge. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
Relationship Detail - RC_F_MONTHLY_CDM_SMRY
Child Column in RC_F_MONTHLY_CDM_SMRY(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | RC_D_ACCOUNT_TYPE_ID | RC_D_ACCOUNT_TYPE | RC_D_ACCOUNT_TYPE_ID |
RC_D_BILLING_ENTITY_ID | RC_D_BILLING_ENTITY | RC_D_BILLING_ENTITY_ID | |
RC_D_BILL_ITEM_ID | RC_D_BILL_ITEM | RC_D_BILL_ITEM_ID | |
RC_D_CPT_MODIFIER_ID | RC_D_BILL_ITEM_MODIFIER | RC_D_BILL_ITEM_MODIFIER_ID | |
RC_D_HCPCS_MODIFIER_ID | RC_D_BILL_ITEM_MODIFIER | RC_D_BILL_ITEM_MODIFIER_ID | |
RC_D_ENCNTR_TYPE_CLASS_ID | RC_D_ENCNTR_TYPE_CLASS | RC_D_ENCNTR_TYPE_CLASS_ID | |
RC_D_FINANCIAL_CLASS_ID | RC_D_FINANCIAL_CLASS | RC_D_FINANCIAL_CLASS_ID | |
RC_D_GL_ALIAS_ID | RC_D_GL_ALIAS | RC_D_GL_ALIAS_ID | |
RC_D_HEALTH_PLAN_ID | RC_D_HEALTH_PLAN | RC_D_HEALTH_PLAN_ID | |
RC_D_MEDICAL_SERVICE_ID | RC_D_MEDICAL_SERVICE | RC_D_MEDICAL_SERVICE_ID | |
RC_D_ADMIT_PHYS_SPECIALTY_ID | RC_D_PHYSICIAN_SPECIALTY | RC_D_PHYSICIAN_SPECIALTY_ID | |
RC_D_ATTEND_PHYS_SPECIALTY_ID | RC_D_PHYSICIAN_SPECIALTY | RC_D_PHYSICIAN_SPECIALTY_ID | |
RC_D_CONSULT_PHYS_SPECIALTY_ID | RC_D_PHYSICIAN_SPECIALTY | RC_D_PHYSICIAN_SPECIALTY_ID | |
RC_D_ORDER_PHYS_SPECIALTY_ID | RC_D_PHYSICIAN_SPECIALTY | RC_D_PHYSICIAN_SPECIALTY_ID | |
RC_D_PERFORM_PHYS_SPECIALTY_ID | RC_D_PHYSICIAN_SPECIALTY | RC_D_PHYSICIAN_SPECIALTY_ID | |
RC_D_REFER_PHYS_SPECIALTY_ID | RC_D_PHYSICIAN_SPECIALTY | RC_D_PHYSICIAN_SPECIALTY_ID | |
RC_D_REND_PHYS_SPECIALTY_ID | RC_D_PHYSICIAN_SPECIALTY | RC_D_PHYSICIAN_SPECIALTY_ID | |
RC_D_SUPERV_PHYS_SPECIALTY_ID | RC_D_PHYSICIAN_SPECIALTY | RC_D_PHYSICIAN_SPECIALTY_ID | |
RC_D_TIER_GROUP_ID | RC_D_TIER_GROUP | RC_D_TIER_GROUP_ID | |
SHR_D_LOCATION_ID | SHR_D_LOCATION | SHR_D_LOCATION_ID | |
SHR_D_MONTH_ID | SHR_D_MONTH | SHR_D_MONTH_ID | |
SHR_D_ADMIT_PHYSICIAN_ID | SHR_D_PERSON | SHR_D_PERSON_ID | |
SHR_D_ATTEND_PHYSICIAN_ID | SHR_D_PERSON | SHR_D_PERSON_ID | |
SHR_D_CONSULT_PHYSICIAN_ID | SHR_D_PERSON | SHR_D_PERSON_ID | |
SHR_D_ORDER_PHYSICIAN_ID | SHR_D_PERSON | SHR_D_PERSON_ID | |
SHR_D_PERFORM_PHYSICIAN_ID | SHR_D_PERSON | SHR_D_PERSON_ID | |
SHR_D_REFER_PHYSICIAN_ID | SHR_D_PERSON | SHR_D_PERSON_ID | |
SHR_D_REND_PHYSICIAN_ID | SHR_D_PERSON | SHR_D_PERSON_ID | |
SHR_D_SUPERV_PHYSICIAN_ID | SHR_D_PERSON | SHR_D_PERSON_ID |