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