Table Detail Report
RC_F_DAYS_IN_AR_SMRY
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Revenue Cycle Fact Days in AR Summary |
Definition: | This table contains summarized days in AR data. |
Table Type: | ACTIVITY |
Column Detail - RC_F_DAYS_IN_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 logical domain to which the row data belongs. |
RC_D_BILLING_ENTITY_ID | DOUBLE | N | Uniquely identifies the billing entity related to this fact row. |
RC_D_DISCHARGE_AGE_ID | DOUBLE | N | Uniquely identifies the age category to which this fact row is related based on the discharge age. |
RC_D_HOLD_ID | DOUBLE | N | Uniquely identifies the hold related to this fact row. |
RC_F_DAYS_IN_AR_SMRY_ID | DOUBLE | N | Uniquely identifies summarized days in AR data. |
TOTAL_DAYS_IN_AR | DOUBLE | N | Represents the average number of days spent recovering AR. |
TOT_CREDIT_BALANCE_DAYS_IN_AR | DOUBLE | N | Represents the average number of days spent recovering credit AR. |
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_DAYS_IN_AR_SMRY
Child Column in RC_F_DAYS_IN_AR_SMRY(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ACTIVITY_DT_NBR | OMF_DATE | DT_NBR |
RC_D_DISCHARGE_AGE_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_HOLD_ID | RC_D_HOLD | RC_D_HOLD_ID |
RC_F_DENIAL
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Revenue Cycle Fact Denial |
Definition: | This table contains data related to denials (remark codes) applied to transactions. |
Table Type: | ACTIVITY |
Column Detail - RC_F_DENIAL
Column Name | Type | Null? | Definition |
---|---|---|---|
ADJUSTMENT_AMT | DOUBLE | N | Contains the total adjustment amount made to claim associated to the denial. |
ADMIT_DT_NBR | DOUBLE | N | A number representing the admit date. References the key in the OMF_DATE table. |
BILL_NUMBER_IDENT | VARCHAR(40) | N | Contains the display value associated to a bill number. |
CLAIM_BILLED_AMT | DOUBLE | N | Contains the total amount of the claim billed to payor for the claim associated to the denial. |
DENIAL_BILLED_AMT | DOUBLE | N | Contains the dollar amount denied. |
DENIAL_DT_NBR | DOUBLE | N | A number representing the denial date. References the key in the OMF_DATE table. |
DISCHARGE_DT_NBR | DOUBLE | N | A number representing the discharge 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_CORSP_ID | DOUBLE | N | Uniquely identifies the millennium database claim to which the denial fact information is related. |
MILL_DENIAL_ID | DOUBLE | N | Uniquely identifies a row on the Denial table in the Millennium from which this data is derived. |
MILL_LOGICAL_DOMAIN_ID | DOUBLE | N | Uniquely identifies the logical domain to which the row data belongs. |
PATIENT_LIABILITY_AMT | DOUBLE | N | Contains the dollar amount tied to a patient liability remark. |
PAYMENT_AMT | DOUBLE | N | Contains the total payment amount made to the claim associated to the denial. |
RC_AF_PATIENT_AR_BALANCE_ID | DOUBLE | N | Uniquely identifies data related to the RC_F_Denial table. |
RC_D_BILLING_ENTITY_ID | DOUBLE | N | Uniquely identifies the billing entity associated to the encounter associated to this denial. |
RC_D_BILL_TYPE_ID | DOUBLE | N | Uniquely identifies the bill type related to this fact row. |
RC_D_DENIAL_ALIAS_ID | DOUBLE | N | Uniquely identifies the denial alias dimension row that is related to this fact row. |
RC_D_DRG_ID | DOUBLE | N | Uniquely identifies the DRG associated tot the encounter for which the denial is posted. |
RC_D_ENCNTR_TYPE_CLASS_ID | DOUBLE | N | Uniquely identifies the encounter type class of the encounter associated to this denial. |
RC_D_FINANCIAL_CLASS_ID | DOUBLE | N | Uniquely identifies the financial class of the health plan associated to the claim for which this denial was posted. |
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 of the encounter associated to this denial. |
RC_D_TRANSACTION_BATCH_ID | DOUBLE | N | Uniquely identifies the remittance batch from which this denial was posted. |
RC_F_DENIAL_ID | DOUBLE | N | Uniquely identifies data related to denials applied to transactions. |
SHR_D_ATTENDING_PHYSICIAN_ID | DOUBLE | N | Uniquely identifies the attending physician associated with this denial. |
SHR_D_LOCATION_ID | DOUBLE | N | Uniquely identifies the patient encounter location at the time the denial was posted. |
SHR_D_PERSON_ID | DOUBLE | N | Uniquely identifies the patient associated with this denial. |
SHR_D_POSTED_PERSON_ID | DOUBLE | N | Uniquely identifies the person who posted this denial. |
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_DENIAL
Child Column in RC_F_DENIAL(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ADMIT_DT_NBR | OMF_DATE | DT_NBR |
DENIAL_DT_NBR | OMF_DATE | DT_NBR | |
DISCHARGE_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_DENIAL_ALIAS_ID | RC_D_DENIAL_ALIAS | RC_D_DENIAL_ALIAS_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_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 | |
RC_D_MEDICAL_SERVICE_ID | RC_D_MEDICAL_SERVICE | RC_D_MEDICAL_SERVICE_ID | |
RC_D_TRANSACTION_BATCH_ID | RC_D_TRANSACTION_BATCH | RC_D_TRANSACTION_BATCH_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 | |
SHR_D_POSTED_PERSON_ID | SHR_D_PERSON | SHR_D_PERSON_ID |
RC_F_DLY_CHRG_ASSOC_SMRY
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Revenue Cycle Daily Charge Association Summary |
Definition: | This table contains summarized payment and adjustment amounts related to a charge for each physician. |
Table Type: | ACTIVITY |
Column Detail - RC_F_DLY_CHRG_ASSOC_SMRY
Column Name | Type | Null? | Definition |
---|---|---|---|
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 | Represents the transaction's logical domain. |
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 related to this fact row. |
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_ENCNTR_TYPE_CLASS_ID | DOUBLE | N | Uniquely identifies encounter type class information 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_D_MEDICAL_SERVICE_ID | DOUBLE | N | Uniquely identifies medical service information 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_DLY_CHRG_ASSOC_SMRY_ID | DOUBLE | N | Uniquely identifies summarized payment and adjustment amounts related to a charge for each physician. |
SERVICE_DT_NBR | DOUBLE | N | A number representing the service date. References the key in the OMF_DATE table. |
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_ORDER_PHYSICIAN_ID | DOUBLE | N | Represents the person who was the ordering physician for the related fact rows. |
SHR_D_PATIENT_LOCATION_ID | DOUBLE | N | Uniquely identifies the location of the patient. |
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_ADJUSTMENT_AMT | DOUBLE | N | Sum of all adjustments from the ADJUSTMENT fact table that are related to charges for the physician for the same date. |
TOTAL_ADJUSTMENT_COUNT | DOUBLE | N | TOTAL_ADJUSTMENT_COUNT is the sum of all adjustments from the RC_F_ADJUSTMENT table that are related to charges for the physician for the same date. |
TOTAL_CHARGE_AMT | DOUBLE | N | Total amount for charges for each physician. |
TOTAL_CHARGE_COUNT | DOUBLE | N | Total number of charges per physician on a service date. |
TOTAL_PAYMENT_AMT | DOUBLE | N | Sum of all payments from the CASH fact table that are related to charges for the physician for the same date |
TOTAL_PAYMENT_COUNT | DOUBLE | N | Total count of all payments from the CASH fact table that are related to charges for the physician for the same date |
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_DLY_CHRG_ASSOC_SMRY
Child Column in RC_F_DLY_CHRG_ASSOC_SMRY(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | SERVICE_DT_NBR | OMF_DATE | DT_NBR |
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_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_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_PATIENT_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_DLY_CODING_ACT_SMRY
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Revenue Cycle Fact Daily Coding Action Summary |
Definition: | This table will store monthly summarization of coding activity by coding personnel. |
Table Type: | ACTIVITY |
Column Detail - RC_F_DLY_CODING_ACT_SMRY
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVITY_DT_NBR | DOUBLE | N | The Cerner Julian number representing the date. |
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 | Represents the transaction's logical domain. |
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 medical service information such as type or category, that the patient is receiving in relation to this coding activity |
RC_D_PRI_FIN_CLASS_ID | DOUBLE | N | Number that 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_F_DLY_CODING_ACT_SMRY_ID | DOUBLE | N | unique generated number that identifies a row on the RC_F_MTH_CODING_ACT_SMRY table. |
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 location information such as facility and building name. |
TOTAL_ACTIONS_COUNT | DOUBLE | N | The total actions count per coding personnel. |
TOTAL_ENCOUNTER_COUNT | DOUBLE | N | The total number of encounters associated to this coding activity. |
TOTAL_FE_BALANCE_AMT | DOUBLE | N | The total of the financial encounter balance amount for the patient who had the coding activity. |
TOTAL_LENGTH_OF_STAY | DOUBLE | N | The total number of midnights the patient stays in the hospital, from admission to either discharge or coding activity date, which ever occurs first. |
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_DLY_CODING_ACT_SMRY
Child Column in RC_F_DLY_CODING_ACT_SMRY(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ACTIVITY_DT_NBR | OMF_DATE | DT_NBR |
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 | |
SHR_D_LOCATION_ID | SHR_D_LOCATION | SHR_D_LOCATION_ID | |
SHR_D_CODING_PRSNL_ID | SHR_D_PERSON | SHR_D_PERSON_ID |
RC_F_GENERAL_AR_BALANCE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Revenue Cycle Fact General AR Balance |
Definition: | This table contains data related to General AR account balances. |
Table Type: | ACTIVITY |
Column Detail - RC_F_GENERAL_AR_BALANCE
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVITY_DT_NBR | DOUBLE | N | **obsolete** This column is no longer being used. It has been replaced by the begin_dt_nbr and end_dt_nbr. A number representing the activity date. References the key in the OMF_DATE table. ** obsolete** |
BALANCE_AMT | DOUBLE | N | ** Obsolete ** No longer used. Contains the Balance of the General AR account. *** Obsolete *** |
BEGIN_BALANCE_AMT | DOUBLE | Y | The opening balance for the given activity date. |
BEGIN_DT_NBR | DOUBLE | N | A number representing the begin date of this balance fact row. References the related row in the OMF_DATE table. |
DAILY_ADJUSTMENT_AMT | DOUBLE | N | Contains the adjustment amount per day. |
DAILY_PAYMENT_AMT | DOUBLE | N | Contains the payment amount per day. |
END_BALANCE_AMT | DOUBLE | Y | The ending balance for the given activity date. |
END_DT_NBR | DOUBLE | N | A number representing the end date of this balance fact row. References the related row 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_ADJUSTMENT_DT_NBR | DOUBLE | N | A number representing the most recent adjustment date of this fact row. References the related row on the OMF_DATE table. |
LAST_PAYMENT_DT_NBR | DOUBLE | N | A number representing the most recent adjustment date of this fact row. References the related row on the OMF_Date table. |
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 logical domain to which the row data belongs. |
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 billing entity information related to this fact row. |
RC_F_GENERAL_AR_BALANCE_ID | DOUBLE | N | Uniquely identifies General AR Balance information. |
TIME_ZONE_INDEX | DOUBLE | N | Stores the time zone from which the data was extracted. |
TOTAL_ADJUSTMENT_AMT | DOUBLE | N | ** obsolete ** this column is no longer being used. Contains the total of the adjustments. ** obsolete ** |
TOTAL_PAYMENT_AMT | DOUBLE | N | ** obsolete ** This column is no longer being used. Contains 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_GENERAL_AR_BALANCE
Child Column in RC_F_GENERAL_AR_BALANCE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ACTIVITY_DT_NBR | OMF_DATE | DT_NBR |
BEGIN_DT_NBR | OMF_DATE | DT_NBR | |
END_DT_NBR | OMF_DATE | DT_NBR | |
LAST_ADJUSTMENT_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_BILLING_ENTITY_ID | RC_D_BILLING_ENTITY | RC_D_BILLING_ENTITY_ID |