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