Table Detail Report

RC_F_CLAIM_EVENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Fact Claim Event
Definition: This table contains data related to claims.
Table Type: ACTIVITY





Column Detail - RC_F_CLAIM_EVENT


Column Name Type Null? Definition
BILL_NUMBER_IDENT VARCHAR(40) N Contains the display value associated to a bill number.
BILL_VRSN_NBR DOUBLE N The version of the bill that has been generated.
CLAIM_BILLED_AMT DOUBLE N Contains the dollar amount billed on the claim.
CLAIM_EVENT_DT_NBR DOUBLE N A number representing the date of the claim event. References the key in the OMF_DATE table.
DAYS_SINCE_DISCHARGE_CNT DOUBLE N Contains the number of days since the encounter's discharge.
DAYS_SINCE_GENERATION_CNT DOUBLE N Contains the number of days since the generation of the claim.
DAYS_SINCE_SUBMISSION_CNT DOUBLE N Contains the number of days since the submission of the claim.
FIRST_PROCESS_DT_TM DATETIME N The date/time that the first ETL process started that created this record.
LAST_PROCESS_DT_TM DATETIME N The date/time that the last ETL process started that updated this record.
MILL_CORSP_ID DOUBLE N Identifies the row in the Bill_Rec table in the Millennium database from which the data for this table was derived.
MILL_LOGICAL_DOMAIN_ID DOUBLE N Uniquely identifies the logical domain to which the row data belongs.
PRIORITY_SEQ_NBR DOUBLE N Sequence that defines the hierarchy for insurance responsibility.
RC_AF_PATIENT_AR_BALANCE_ID DOUBLE N Uniquely identifies data related to the RC_F_Claim_Event table.
RC_D_BILLING_ENTITY_ID DOUBLE N Uniquely identifies the billing entity dimension row related to this fact row.
RC_D_BILL_TYPE_ID DOUBLE N Uniquely identifies the bill type related to this fact row.
RC_D_CLAIM_EVENT_TYPE_ID DOUBLE N Uniquely identifies a claim event type dimension row related to this fact row.
RC_D_FINANCIAL_CLASS_ID DOUBLE N Uniquely identifies the financial class related to this fact row.
RC_D_HEALTH_PLAN_ID DOUBLE N Uniquely identifies the health plan related to this fact row.
RC_F_CLAIM_EVENT_ID DOUBLE N Uniquely identifies data related to claims.
SHR_D_ADMIT_PRSNL_ID DOUBLE N Uniquely identifies the admit person for this claim event.
SHR_D_LOCATION_ID DOUBLE N Uniquely identifies the patient encounter location at the time the claim event.
SHR_D_PERSON_ID DOUBLE N Uniquely identifies the person related to this claim event.
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 - RC_F_CLAIM_EVENT


Child Column in RC_F_CLAIM_EVENT(FK) Parent Table Name Parent Column Name
Parents: CLAIM_EVENT_DT_NBR OMF_DATE DT_NBR
RC_AF_PATIENT_AR_BALANCE_ID RC_AF_PATIENT_AR_BALANCE RC_AF_PATIENT_AR_BALANCE_ID
RC_D_BILLING_ENTITY_ID RC_D_BILLING_ENTITY RC_D_BILLING_ENTITY_ID
RC_D_BILL_TYPE_ID RC_D_BILL_TYPE RC_D_BILL_TYPE_ID
RC_D_CLAIM_EVENT_TYPE_ID RC_D_CLAIM_EVENT_TYPE RC_D_CLAIM_EVENT_TYPE_ID
RC_D_FINANCIAL_CLASS_ID RC_D_FINANCIAL_CLASS RC_D_FINANCIAL_CLASS_ID
RC_D_HEALTH_PLAN_ID RC_D_HEALTH_PLAN RC_D_HEALTH_PLAN_ID
SHR_D_LOCATION_ID SHR_D_LOCATION SHR_D_LOCATION_ID
SHR_D_ADMIT_PRSNL_ID SHR_D_PERSON SHR_D_PERSON_ID
SHR_D_PERSON_ID SHR_D_PERSON SHR_D_PERSON_ID


RC_F_CODING_ACTIVITY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Fact Coding Activity
Definition: This table is used to store activity related to the coding of clinical encounters.
Table Type: ACTIVITY





Column Detail - RC_F_CODING_ACTIVITY


Column Name Type Null? Definition
ACTIVITY_DT_NBR DOUBLE N The Cerner Julian number representing the date.
ADMIT_DT_NBR DOUBLE N A number representing the admit date. References the key in the OMF_DATE table.
CODING_DT_NBR DOUBLE N The Cerner Julian number representing the date the coding episode took place.
CODING_DT_TM DATETIME Y The date and time the coding of episode took place.
COMPLETED_DT_NBR DOUBLE N The Cerner Julian number representing the date for which the coding activity was completed.
COMPLETED_DT_TM DATETIME Y The date and time for which the coding activity was completed.
DISCHARGE_DT_NBR DOUBLE N A number representing the discharge date. References the key in the OMF_DATE table.
FE_BALANCE_AMT DOUBLE N The financial encounter balance amount for the patient who had the coding activity.
FIN_NBR_IDENT VARCHAR(50) Y The financial number alias related to the patient encounter.
FIRST_PROCESS_DT_TM DATETIME N The date/time that the first ETL process started that created this record.
LAST_PROCESS_DT_TM DATETIME N The date/time that the last ETL process started that updated this record.
LENGTH_OF_STAY DOUBLE N The number of midnights the patient stays in the hospital, from admission to either discharge or coding activity date, which ever occurs first.
MILL_ENCOUNTER_ID DOUBLE N The ENCOUNTER.ENCNTR_ID associated to the patient in Millennium.
MILL_LOGICAL_DOMAIN_ID DOUBLE N Uniquely identifies the related logical domain record.
MRN_NBR_IDENT VARCHAR(50) Y Identifier of a medical record number.
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_CODING_ACTION_ID DOUBLE N Uniquely identifies the coding activity related to this fact row.
RC_D_DRG_ID DOUBLE N Uniquely identifies the DRG associated tot the encounter related to this coding activity.
RC_D_ENCNTR_TYPE_CLASS_ID DOUBLE N Uniquely identifies the encounter type class of the encounter associated to this coding activity.
RC_D_MEDICAL_SERVICE_ID DOUBLE N Uniquely identifies the medical service of the encounter associated to this coding activity.
RC_D_PRI_FIN_CLASS_ID DOUBLE N Uniquely identifies the primary financial class related to this coding activity.
RC_D_PRI_HEALTH_PLAN_ID DOUBLE N Uniquely identifies the primary health plan of the financial encounter.
RC_F_CODING_ACTIVITY_ID DOUBLE N Uniquely identifies activity related to the coding of clinical encounters.
SHR_D_ADMITTING_PRSNL_ID DOUBLE N Uniquely identifies the admitting personnel related to this coding activity.
SHR_D_ATTENDING_PRSNL_ID DOUBLE N Uniquely identifies the attending personnel related to this coding activity.
SHR_D_CODING_PRSNL_ID DOUBLE N Uniquely identifies the coding personnel related to this coding activity.
SHR_D_LOCATION_ID DOUBLE N Uniquely identifies the location related to this coding activity.
SHR_D_PERSON_ID DOUBLE N Uniquely identifies the person related to this coding activity.
TIME_ZONE_INDEX DOUBLE N Stores the time zone from which the data was extracted.
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_CODING_ACTIVITY


Child Column in RC_F_CODING_ACTIVITY(FK) Parent Table Name Parent Column Name
Parents: RC_D_CODING_ACTION_ID RC_D_CODING_ACTION RC_D_CODING_ACTION_ID
RC_D_DRG_ID RC_D_DRG RC_D_DRG_ID
RC_D_ENCNTR_TYPE_CLASS_ID RC_D_ENCNTR_TYPE_CLASS RC_D_ENCNTR_TYPE_CLASS_ID
RC_D_PRI_FIN_CLASS_ID RC_D_FINANCIAL_CLASS RC_D_FINANCIAL_CLASS_ID
RC_D_PRI_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
SHR_D_LOCATION_ID SHR_D_LOCATION SHR_D_LOCATION_ID
SHR_D_ADMITTING_PRSNL_ID SHR_D_PERSON SHR_D_PERSON_ID
SHR_D_ATTENDING_PRSNL_ID SHR_D_PERSON SHR_D_PERSON_ID
SHR_D_CODING_PRSNL_ID SHR_D_PERSON SHR_D_PERSON_ID
SHR_D_PERSON_ID SHR_D_PERSON SHR_D_PERSON_ID


RC_F_DAILY_BAL_AR_SMRY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Fact Daily Balance AR Summary
Definition: Summarization of RC_F_Balance_AR table.
Table Type: ACTIVITY





Column Detail - RC_F_DAILY_BAL_AR_SMRY


Column Name Type Null? Definition
ACTIVITY_DT_NBR DOUBLE N A number representing the activity date. References the key in the OMF_DATE table.
FIRST_PROCESS_DT_TM DATETIME N The date/time that the first ETL process started that created this record.
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_ACCOMMODATION_ID DOUBLE N Uniquely identifies the accommodation related to this fact row.
RC_D_AGE_BY_DISCHARGE_ID DOUBLE N Relates this fact row to a specific age category based on the discharge age.
RC_D_AGE_BY_FIRST_SERVICE_ID DOUBLE N Uniquely identifies an age category that represents the difference between the activity date and the date the first charge was posted to the balance.
RC_D_AGE_BY_ORIG_BILL_ID DOUBLE N Uniquely identifies an age category that represents the difference between the activity date and the first transmitted claim or submitted statement on a balance, regardless of whether or not the bill was cancelled.
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_BALANCE_GROUP_ID DOUBLE N Uniquely identifies the balance group related to this fact row.
RC_D_BALANCE_TYPE_ID DOUBLE N Uniquely identifies the balance type related to this fact row
RC_D_BAL_HOLD_ID DOUBLE N Uniquely identifies the balance hold related to this fact row
RC_D_BILLING_ENTITY_ID DOUBLE N Uniquely identifies the billing entity related to this fact row.
RC_D_ENCNTR_HOLD_ID DOUBLE N Uniquely identifies the encounter hold related to this fact row
RC_D_ENCNTR_TYPE_CLASS_ID DOUBLE N Uniquely identifies the encounter class and encounter type related to this fact row.
RC_D_FIN_CLASS_ID DOUBLE N Uniquely identifies the financial class related to this fact row.
RC_D_HEALTH_PLAN_ID DOUBLE N Uniquely identifies the health plan related to this fact row
RC_D_MEDICAL_SERVICE_ID DOUBLE N Uniquely identifies the medical service related to this fact row.
RC_D_PRI_FIN_CLASS_ID DOUBLE N Uniquely identifies the primary financial class related to this fact row
RC_D_PRI_HEALTH_PLAN_ID DOUBLE N Uniquely identifies the primary health plan related to this fact row
RC_D_RESP_FIN_CLASS_ID DOUBLE N Uniquely identifies the responsible financial class related to this fact row
RC_D_RESP_HEALTH_PLAN_ID DOUBLE N Uniquely identifies the responsible health plan related to this fact row
RC_F_DAILY_BAL_AR_SMRY_ID DOUBLE N Unique generated number that identifies a single row on the RC_F_DAILY_BALANCE_AR_SMRY table.
SHR_D_ATTENDING_PHYSICIAN_ID DOUBLE N Uniquely identifies the attending physician related to this fact row
SHR_D_LOCATION_ID DOUBLE N Uniquely identifies the location related to this fact row
TOTAL_ADJUSTMENT_AMT DOUBLE N The total adjustment amounts for the balances that make up the fact row.
TOTAL_BALANCE_AMT DOUBLE N The total outstanding balance amount for the payer.
TOTAL_BALANCE_COUNT DOUBLE N The number of balances rolled up into this fact row.
TOTAL_CHARGE_AMT DOUBLE N The total charge amounts for the balances that make up the fact row.
TOTAL_PAYMENT_AMT DOUBLE N The total payment amounts for the balances that make up the fact row.
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_DAILY_BAL_AR_SMRY


Child Column in RC_F_DAILY_BAL_AR_SMRY(FK) Parent Table Name Parent Column Name
Parents: RC_D_ACCOMMODATION_ID RC_D_ACCOMMODATION RC_D_ACCOMMODATION_ID
RC_D_AGE_BY_DISCHARGE_ID RC_D_AGE_CATEGORY RC_D_AGE_CATEGORY_ID
RC_D_AGE_BY_FIRST_SERVICE_ID RC_D_AGE_CATEGORY RC_D_AGE_CATEGORY_ID
RC_D_AGE_BY_ORIG_BILL_ID RC_D_AGE_CATEGORY RC_D_AGE_CATEGORY_ID
RC_D_BALANCE_GROUP_ID RC_D_BALANCE_GROUP RC_D_BALANCE_GROUP_ID
RC_D_BALANCE_TYPE_ID RC_D_BALANCE_TYPE RC_D_BALANCE_TYPE_ID
RC_D_BILLING_ENTITY_ID RC_D_BILLING_ENTITY RC_D_BILLING_ENTITY_ID
RC_D_ENCNTR_TYPE_CLASS_ID RC_D_ENCNTR_TYPE_CLASS RC_D_ENCNTR_TYPE_CLASS_ID
RC_D_FIN_CLASS_ID RC_D_FINANCIAL_CLASS RC_D_FINANCIAL_CLASS_ID
RC_D_PRI_FIN_CLASS_ID RC_D_FINANCIAL_CLASS RC_D_FINANCIAL_CLASS_ID
RC_D_RESP_FIN_CLASS_ID RC_D_FINANCIAL_CLASS RC_D_FINANCIAL_CLASS_ID
RC_D_HEALTH_PLAN_ID RC_D_HEALTH_PLAN RC_D_HEALTH_PLAN_ID
RC_D_PRI_HEALTH_PLAN_ID RC_D_HEALTH_PLAN RC_D_HEALTH_PLAN_ID
RC_D_RESP_HEALTH_PLAN_ID RC_D_HEALTH_PLAN RC_D_HEALTH_PLAN_ID
RC_D_BAL_HOLD_ID RC_D_HOLD RC_D_HOLD_ID
RC_D_ENCNTR_HOLD_ID RC_D_HOLD RC_D_HOLD_ID
RC_D_MEDICAL_SERVICE_ID RC_D_MEDICAL_SERVICE RC_D_MEDICAL_SERVICE_ID
RC_D_ATTEND_PHYS_SPECIALTY_ID RC_D_PHYSICIAN_SPECIALTY RC_D_PHYSICIAN_SPECIALTY_ID
SHR_D_LOCATION_ID SHR_D_LOCATION SHR_D_LOCATION_ID
SHR_D_ATTENDING_PHYSICIAN_ID SHR_D_PERSON SHR_D_PERSON_ID


RC_F_DAILY_CDM_SMRY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Fact Daily CDM Summary
Definition: Contains charges aggregated by CDM at a daily level.
Table Type: ACTIVITY





Column Detail - RC_F_DAILY_CDM_SMRY


Column Name Type Null? Definition
ACTIVITY_DT_NBR DOUBLE N Represents the date for which the CDM charges are aggregated.
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.
DISCHARGE_MONTH_ID DOUBLE N The month the patient who made the transaction was discharged.
DISCHARGE_YEAR DOUBLE N The year the patient who made the transaction was discharged.
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 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 related 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_DAILY_CDM_SMRY_ID DOUBLE N Uniquely identifies aggregated charges by CDM at a daily 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_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_DAILY_CDM_SMRY


Child Column in RC_F_DAILY_CDM_SMRY(FK) Parent Table Name Parent Column Name
Parents: ACTIVITY_DT_NBR OMF_DATE DT_NBR
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_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


RC_F_DAILY_CENSUS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Fact Daily Census
Definition: This table contains information "Admission", "Transfer In", "Transfer Out", "Discharge", "Held Over" census events for encounters that are an encounter type class of "Inpatient", "Skilled Nursing", or "Observation" for a given activity date.
Table Type: ACTIVITY





Column Detail - RC_F_DAILY_CENSUS


Column Name Type Null? Definition
ACTIVITY_DT_NBR DOUBLE N The Cerner Julian number representing the date for which the census data applies.
ADMISSION_DT_NBR DOUBLE N The Cerner Julian number representing the date the patient was admitted to the hospital. In the case of Observation patients, this is the date the patient was registered to the hospital.
DISCHARGE_DT_NBR DOUBLE N The Cerner Julian number representing the date the patient was discharged from the hospital.
FIN_NBR_IDENT VARCHAR(50) N The financial number alias related to the patient encounter.
FIRST_PROCESS_DT_TM DATETIME N The date/time that the first ETL process started that created this record.
LAST_PROCESS_DT_TM DATETIME N The date/time that the last ETL process started that updated this record.
LENGTH_OF_STAY DOUBLE N The cumulative number of days an encounter has been in a bed at midnight since admission. Additionally, if the patient is admitted and discharged on the same day, the Length of Stay is 1 day.
MILL_ENCOUNTER_ID DOUBLE N The ENCOUNTER.ENCNTR_ID associated to the patient in Millennium.
MILL_LOGICAL_DOMAIN_ID DOUBLE N Uniquely identifies the logical domain to which the row data belongs.
MILL_ORGANIZATION_ID DOUBLE N Uniquely identifies a related Millennium organization at which this census event occurred.
PATIENT_DAY_IND DOUBLE N A value of 1 indicates lodging was provided and services were rendered to one inpatient between the midnight on two successive days. This is only evaluated for DISCHARGE and HELD_OVER census events. Additionally, if the patient is admitted and discharged on the same day, the patient_day_ind is 1.
RC_D_ACCOMMODATION_ID DOUBLE N Uniquely identifies the accommodation related to this fact row.
RC_D_ADMIT_SOURCE_ID DOUBLE N Uniquely identifies related admit source information
RC_D_ADMIT_TYPE_ID DOUBLE N Uniquely identifies admit type information related to this fact row.
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_CENSUS_EVENT_ID DOUBLE N Uniquely identifies the census event related to this fact row.
RC_D_DISCHARGE_DISPOSITION_ID DOUBLE N Uniquely identifies discharge disposition information related to this fact row.
RC_D_DRG_ID DOUBLE N Uniquely identifies the diagnostic related group related to this fact row.
RC_D_ENCNTR_TYPE_CLASS_ID DOUBLE N Uniquely identifies the encounter type class related to this fact row.
RC_D_ETHNICITY_COMPOSITE_ID DOUBLE N Unique generated number that identifies a single row on the RC_D_ETHNICITY_COMPOSITE table.
RC_D_MEDICAL_SERVICE_ID DOUBLE N Uniquely identifies medical service information related to this fact row.
RC_D_NEWBORN_STATUS_ID DOUBLE N Uniquely identifies information about the status of a newborn.
RC_D_PATIENT_AGE_ID DOUBLE N Uniquely identifies the patient age related to this fact row.
RC_D_PRI_FIN_CLASS_ID DOUBLE N Uniquely identifies the primary financial class related to this fact row.
RC_D_RACE_COMPOSITE_ID DOUBLE N Unique generated number that identifies a single row on the RC_D_RACE_COMPOSITE table.
RC_D_RACE_COMPOSITE_VALUE DOUBLE N ** Obsolete ** This column i s no longer being used. Contains a value that will identify a single or combination of race values.
RC_D_SEX_ID DOUBLE N Uniquely identifies the gender related to this fact row.
RC_F_DAILY_CENSUS_ID DOUBLE N Uniquely identifies information about census events for encounters that are a specific encounter type class for a given activity date.
SHR_D_ATTENDING_PHYSICIAN_ID DOUBLE N Uniquely identifies the attending physician related to this fact row
SHR_D_LOCATION_ID DOUBLE N Uniquely identifies the hospital location related to this fact row.
SHR_D_PERSON_ID DOUBLE N Uniquely identifies the patient related to this fact row.
TIME_ZONE_INDEX DOUBLE N Stores the time zone from which the data was extracted.
TOTAL_CHARGE_AMT DOUBLE N The total charges accumulated on the patient encounter up to the activity date. This is only evaluated on the DISCHARGE and HELD_OVER census events.
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_DAILY_CENSUS


Child Column in RC_F_DAILY_CENSUS(FK) Parent Table Name Parent Column Name
Parents: ACTIVITY_DT_NBR OMF_DATE DT_NBR
ADMISSION_DT_NBR OMF_DATE DT_NBR
DISCHARGE_DT_NBR OMF_DATE DT_NBR
RC_D_ACCOMMODATION_ID RC_D_ACCOMMODATION RC_D_ACCOMMODATION_ID
RC_D_ADMIT_SOURCE_ID RC_D_ADMIT_SOURCE RC_D_ADMIT_SOURCE_ID
RC_D_ADMIT_TYPE_ID RC_D_ADMIT_TYPE RC_D_ADMIT_TYPE_ID
RC_D_CENSUS_EVENT_ID RC_D_CENSUS_EVENT RC_D_CENSUS_EVENT_ID
RC_D_DISCHARGE_DISPOSITION_ID RC_D_DISCHARGE_DISPOSITION RC_D_DISCHARGE_DISPOSITION_ID
RC_D_DRG_ID RC_D_DRG RC_D_DRG_ID
RC_D_ENCNTR_TYPE_CLASS_ID RC_D_ENCNTR_TYPE_CLASS RC_D_ENCNTR_TYPE_CLASS_ID
RC_D_ETHNICITY_COMPOSITE_ID RC_D_ETHNICITY_COMPOSITE RC_D_ETHNICITY_COMPOSITE_ID
RC_D_PRI_FIN_CLASS_ID RC_D_FINANCIAL_CLASS RC_D_FINANCIAL_CLASS_ID
RC_D_MEDICAL_SERVICE_ID RC_D_MEDICAL_SERVICE RC_D_MEDICAL_SERVICE_ID
RC_D_NEWBORN_STATUS_ID RC_D_NEWBORN_STATUS RC_D_NEWBORN_STATUS_ID
RC_D_PATIENT_AGE_ID RC_D_PATIENT_AGE RC_D_PATIENT_AGE_ID
RC_D_ATTEND_PHYS_SPECIALTY_ID RC_D_PHYSICIAN_SPECIALTY RC_D_PHYSICIAN_SPECIALTY_ID
RC_D_RACE_COMPOSITE_ID RC_D_RACE_COMPOSITE RC_D_RACE_COMPOSITE_ID
RC_D_SEX_ID RC_D_SEX RC_D_SEX_ID
SHR_D_LOCATION_ID SHR_D_LOCATION SHR_D_LOCATION_ID
SHR_D_ATTENDING_PHYSICIAN_ID SHR_D_PERSON SHR_D_PERSON_ID
SHR_D_PERSON_ID SHR_D_PERSON SHR_D_PERSON_ID