Table Detail Report

DAILY_ACCT_BAL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Daily Account Balance
Definition: ProFit table to track the daily account balances.
Table Type: ACTIVITY





Column Detail - DAILY_ACCT_BAL


Column Name Type Null? Definition
ACCT_ID DOUBLE N Foreign key reference to the account table
ACTIVE_IND DOUBLE Y 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 Y 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_TM DATETIME Y Represents the last date and time a transactions was posted to the encounter.
ADJUSTMENT_AMOUNT DOUBLE Y The total adjustment amount for the given activity date.
ADJ_DR_CR_FLAG DOUBLE Y The total adjustment amount debit credit flag for the given activity date.
BEG_BALANCE DOUBLE Y The opening balance for the given activity date copied from the previous activities days.
BEG_DR_CR_FLAG DOUBLE Y The opening balance for the debit/credit flag for the given activity date.
BEG_EFFECTIVE_DT_TM DATETIME Y 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.
BILLING_ENTITY_ID DOUBLE N Foreign key reference to the billing_entity table
CALCULATED_END_BAL DOUBLE Y The beginning balance minus the charge, payment, and adjustments for the given activity date.
CALC_DR_CR_FLAG DOUBLE Y The calculated end balance debit/credit flag for the given activity date.
CHARGE_AMOUNT DOUBLE Y The total charge amount for the given activity date.
CHRG_DR_CR_FLAG DOUBLE Y The total charge amount debit/credit flag for the given activity date.
DAILY_ACCT_BAL_ID DOUBLE N Primary key
END_BALANCE DOUBLE Y The ending balance for the given activity date.
END_DR_CR_FLAG DOUBLE Y Ending Balance Debit/Credit Flag for the given activity date.
END_EFFECTIVE_DT_TM DATETIME Y 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.
FINCHRG_AMOUNT DOUBLE Y Finance Charge Amount - This column is no longer used.
FINCHRG_DR_CR_FLAG DOUBLE Y Finance Charge Amount Debit/Credit - This column is no longer used.
LAST_PAYMENT_DT_TM DATETIME Y The last date a payment, not equal to $0.00, was received for the associated account
PAYMENT_AMOUNT DOUBLE Y The total payment amount for the given activity date.
PAY_DR_CR_FLAG DOUBLE Y The total Payment Amount Debit/Credit Flag for the given activity date.
RESPONSIBILITY_AMT DOUBLE Y Guarantor account daily responsibility amount
TOTAL_ADJUSTMENT_AMT DOUBLE Y The last date a payment, not equal to $0.00, was received for the associated account
TOTAL_CHARGE_AMT DOUBLE Y A running total of charges for the associated account up to and including this activity_dt_tm
TOTAL_PAYMENT_AMT DOUBLE Y A running total of payments for the associated account up to and including this activity_dt_tm
TOTAL_RESPONSIBILITY_AMT DOUBLE Y Total Guarantor account responsibility amount
TRANSFER_AMOUNT DOUBLE Y Amount of a transfer that moved an amount from one account to another
TRANSFER_DR_CR_FLAG DOUBLE Y Debit/Credit flag for the transferred amount
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 - DAILY_ACCT_BAL


Child Column in DAILY_ACCT_BAL(FK) Parent Table Name Parent Column Name
Parents: ACCT_ID ACCOUNT ACCT_ID
BILLING_ENTITY_ID BILLING_ENTITY BILLING_ENTITY_ID




Parent Column in DAILY_ACCT_BAL (PK) Child Table Name Child Column Name
Children: DAILY_ACCT_BAL_ID DAILY_ACCT_BAL_RELTN DAILY_ACCT_BAL_ID


DAILY_ACCT_BAL_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: DAILY ACCOUNT BALANCE RELATION
Definition: STORE ADDITIONAL INFORAMTION RELATED TO DAILY ACCT BAL ROW
Table Type: ACTIVITY





Column Detail - DAILY_ACCT_BAL_RELTN


Column Name Type Null? Definition
DAILY_ACCT_BAL_ID DOUBLE N DAILY_ACCT_BAL_ID is the key to identify the parent row in the DAILY_ACCT_BAL table for this DAILY_ACCT_BAL_RELTN row
DAILY_ACCT_BAL_RELTN_ID DOUBLE N PRIMARY KEY
PARENT_ENTITY_ID DOUBLE N PARENT_ENTITY_ID is the key to identify a specific row in a table as set by the PARENT_ENTITY_NAME
PARENT_ENTITY_NAME VARCHAR(30) N PARENT_ENTITY_NAME holds the table name for the PARENT_ENTITY_ID key
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.
VALUE_AMT DOUBLE N The VALUE_AMT is a child transaction amount directly related to a specific PARENT_ENTITY_ID\PARENT_ENTITY_NAME. The VALUE_CRITERIA_CD will determine how this amount will be used.
VALUE_CRITERIA_CD DOUBLE N Specifies the VALUE_CRITERIA_CD that describes how this DAILY_ACCT_BAL_RELTN row is related back to the parent DAILY_ACCT_BAL row.
VALUE_CRITERIA_NBR DOUBLE N The VALUE_CRITERIA_NBR is defined by the VALUE_CRITERIA_CD



Relationship Detail - DAILY_ACCT_BAL_RELTN


Child Column in DAILY_ACCT_BAL_RELTN(FK) Parent Table Name Parent Column Name
Parents: DAILY_ACCT_BAL_ID DAILY_ACCT_BAL DAILY_ACCT_BAL_ID


DAILY_ENCNTR_BAL



Column Section Relationship Section Top of Page


Table-level Detail

Description: DAILY ENCNTR BAL
Definition: Profits table to track the daily financial encounter balances
Table Type: ACTIVITY





Column Detail - DAILY_ENCNTR_BAL


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y 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 Y 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_TM DATETIME Y Represents the last date and time a transactions was posted to the encounter.
ADJUSTMENT_AMOUNT DOUBLE N The total adjustment amount for the given activity date.
ADJ_DR_CR_FLAG DOUBLE Y The total adjustment amount debit credit flag for the given activity date.
BEG_BALANCE DOUBLE N The opening balance for the given activity date Copied from the previous activities days end_balance_dt_tm.
BEG_DR_CR_FLAG DOUBLE Y The opening balance for the given activity date Copied from the previous activities days end_balance_dt_tm.
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.
BILLING_ENTITY_ID DOUBLE N Foreign key reference to the billing_entity table
CALCULATED_END_BAL DOUBLE N The Beginning Balance minus the charge,payment, and adjustments for the given activity date.
CALC_DR_CR_FLAG DOUBLE Y Calculated End Balance debit/credit flag. Total calculated end balance flag.
CHARGE_AMOUNT DOUBLE N The total charge amount for the given activity date.
CHRG_DR_CR_FLAG DOUBLE Y The total charge amount debit credit flag for the given activity date.
DAILY_ENCNTR_BAL_ID DOUBLE N Unique identifier to the Daily Encounter Balance table
END_BALANCE DOUBLE N The ending balance for the given activity date.
END_DR_CR_FLAG DOUBLE Y Ending balance debit/credit flag. Total ending balance flag.
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.
LAST_PAYMENT_DT_TM DATETIME Y The last date a payment, not equal to $0.00, was received for the associated profit encounter
PAYMENT_AMOUNT DOUBLE N The total payment amount for the given activity date.
PAY_DR_CR_FLAG DOUBLE Y The total payment amount debit credit flag for the given activity date.
PFT_ENCNTR_ID DOUBLE N Unique identifier to the pft_encntr table
TOTAL_ADJUSTMENT_AMT DOUBLE Y A running total of adjustments for the associated profit encounter up to and including this activity_dt_tm
TOTAL_CHARGE_AMT DOUBLE Y A running total of charges for the associated profit encounter up to and including this activity_dt_tm
TOTAL_PAYMENT_AMT DOUBLE Y A running total of payments for the associated profit encounter up to and including this activity_dt_tm
TRANSFER_AMOUNT DOUBLE N The total transfer amount for the given activity date.
TRANSFER_DR_CR_FLAG DOUBLE Y Transfer amount debit/credit flag
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 - DAILY_ENCNTR_BAL


Child Column in DAILY_ENCNTR_BAL(FK) Parent Table Name Parent Column Name
Parents: PFT_ENCNTR_ID PFT_ENCNTR PFT_ENCNTR_ID


DELIVERY_SYSTEM



Column Section Relationship Section Top of Page


Table-level Detail

Description: Delivery System
Definition: Delivery System
Table Type: REFERENCE





Column Detail - DELIVERY_SYSTEM


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y 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 Y 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.
BEG_EFFECTIVE_DT_TM DATETIME Y 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.
BILLING_ENTITY_ID DOUBLE N Billing Entity ID
DELIVERY_SYSTEM_ID DOUBLE N Delivery System ID
END_EFFECTIVE_DT_TM DATETIME Y 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.
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 - DELIVERY_SYSTEM


Child Column in DELIVERY_SYSTEM(FK) Parent Table Name Parent Column Name
Parents: BILLING_ENTITY_ID BILLING_ENTITY BILLING_ENTITY_ID


DENIAL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Denial
Definition: This table tracks denial information on the claims.
Table Type: ACTIVITY





Column Detail - DENIAL


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y 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 Y 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.
BATCH_TRANS_FILE_ID DOUBLE N Identifies the batch transaction associated with a denial.
BEG_EFFECTIVE_DT_TM DATETIME Y 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.
BILL_VRSN_NBR DOUBLE Y The version number identifying which bill
CORSP_ACTIVITY_ID DOUBLE N Correspondence Activity ID value related to this denial.
DENIAL_AMT DOUBLE N Contains the amount of the denial.
DENIAL_CODE_TXT VARCHAR(255) Y The actual denial code sent on an ERA
DENIAL_GROUP_CD DOUBLE N Grouping mechanism for the Denial codes.
DENIAL_ID DOUBLE N Uniquely identifies denial information.
DENIAL_REASON_CD DOUBLE N Represents the denial reason on an era, if it is available.
DENIAL_TXT VARCHAR(255) Y Contains a textual description of the denial.
DENIAL_TYPE_CD DOUBLE N This defines the base type of the denial code i.e. provider, patient, technical, information only.
END_EFFECTIVE_DT_TM DATETIME Y 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.
FIN_TRANS_GROUP_ID DOUBLE N Uniquely identifies the related row on the FIN_TRANS_GROUP table.
JOURNAL_BO_RELTN_ID DOUBLE N Journal Benefit Order Relation ID related to this denial. The parent table JOURNAL_BO_RELATION is obsolete.
PFT_LINE_ITEM_ID DOUBLE N Identifies the Claim line item related to the denial.
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 - DENIAL


Child Column in DENIAL(FK) Parent Table Name Parent Column Name
Parents: BATCH_TRANS_FILE_ID BATCH_TRANS_FILE BATCH_TRANS_FILE_ID
BILL_VRSN_NBR BILL_REC BILL_VRSN_NBR
CORSP_ACTIVITY_ID BILL_REC CORSP_ACTIVITY_ID
FIN_TRANS_GROUP_ID FIN_TRANS_GROUP FIN_TRANS_GROUP_ID
PFT_LINE_ITEM_ID PFT_LINE_ITEM PFT_LINE_ITEM_ID




Parent Column in DENIAL (PK) Child Table Name Child Column Name
Children: DENIAL_ID DENIAL_DETAIL DENIAL_ID