Table Detail Report

DENIAL_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Denial Details
Definition: Contains detail information about the denial.
Table Type: ACTIVITY





Column Detail - DENIAL_DETAIL


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.
DENIAL_DETAIL_ID DOUBLE N Primary Key
DENIAL_ID DOUBLE N Foreign Key to Denial table
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.
REMARK_CODE_ATTRIB_CD DOUBLE N Remark Code Attribute
REMARK_CODE_ATTRIB_VALUE VARCHAR(255) Y value of the attribute identified by the remark_code_attrib_cd
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 - DENIAL_DETAIL


Child Column in DENIAL_DETAIL(FK) Parent Table Name Parent Column Name
Parents: DENIAL_ID DENIAL DENIAL_ID


DEPOSIT_ACCT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Deposit Account
Definition: A deposit account is owned by a financial institution and will not be stored on the account table.
Table Type: REFERENCE





Column Detail - DEPOSIT_ACCT


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.
DEPOSIT_ACCT_CUR_CD DOUBLE N Holds the Currency type of the Deposit Account
DEPOSIT_ACCT_DESC VARCHAR(200) Y A description of the deposit account.
DEPOSIT_ACCT_ID DOUBLE N Unique Identifier for the Deposit_Acct_ID table.
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.
EXT_ACCT_ID_TXT VARCHAR(50) Y The Account ID as identified by the financial institution.
EXT_ACCT_ID_TXT_KEY VARCHAR(250) Y Key Field for Ext_Acct_ID_Txt. This field can be indexed.
GLOBAL_IND DOUBLE Y Indicates whether the account is used by all billing entities.
ORGANIZATION_ID DOUBLE N The financial institution off the Organization table.
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 - DEPOSIT_ACCT


Child Column in DEPOSIT_ACCT(FK) Parent Table Name Parent Column Name
Parents: ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID




Parent Column in DEPOSIT_ACCT (PK) Child Table Name Child Column Name
Children: DEPOSIT_ACCT_ID DEPOSIT_RECORD DEPOSIT_ACCT_ID


DEPOSIT_RECORD



Column Section Relationship Section Top of Page


Table-level Detail

Description: Deposit Record
Definition: Stores information about the deposit itself
Table Type: ACTIVITY





Column Detail - DEPOSIT_RECORD


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_ID DOUBLE N Unique Identifier and Foreign Key to the Corsp_Log Table.
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.
DEPOSIT_ACCT_ID DOUBLE N The account that the deposit was made.
DEPOSIT_AMOUNT DOUBLE Y The amount of the deposit.
DEPOSIT_DT_TM DATETIME Y The Date and Time of the deposit
DEPOSIT_RECORD_ID DOUBLE N Unique Identifier
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.
EXT_DEPOSIT_NBR_TXT VARCHAR(40) Y Textual identifier of the deposit number given by an outside source.
ITEM_CNT DOUBLE Y The total number of checks in the deposit.
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 - DEPOSIT_RECORD


Child Column in DEPOSIT_RECORD(FK) Parent Table Name Parent Column Name
Parents: ACTIVITY_ID CORSP_LOG ACTIVITY_ID
DEPOSIT_ACCT_ID DEPOSIT_ACCT DEPOSIT_ACCT_ID




Parent Column in DEPOSIT_RECORD (PK) Child Table Name Child Column Name
Children: DEPOSIT_RECORD_ID DEP_REC_BATCH_TRANS_RELTN DEPOSIT_RECORD_ID


DEP_REC_BATCH_TRANS_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: DEP REC BATCH TRANS RELTN
Definition: Deposit Record Batch Transaction Relation
Table Type: ACTIVITY





Column Detail - DEP_REC_BATCH_TRANS_RELTN


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_ID DOUBLE N Foreign key to the batch_trans table
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.
DEPOSIT_RECORD_ID DOUBLE N Foreign key to the deposit_record table.
DEP_REC_BATCH_TRANS_RELTN_ID DOUBLE N Primary key
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 - DEP_REC_BATCH_TRANS_RELTN


Child Column in DEP_REC_BATCH_TRANS_RELTN(FK) Parent Table Name Parent Column Name
Parents: BATCH_TRANS_ID BATCH_TRANS BATCH_TRANS_ID
DEPOSIT_RECORD_ID DEPOSIT_RECORD DEPOSIT_RECORD_ID


EXT_PAY_PLAN_PE_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: External Payment Plan to ProFit Encounter Relationship
Definition: This table stores Payment Plan to Pft_Encntr reltn information for payment plans managed by third party.
Table Type: ACTIVITY





Column Detail - EXT_PAY_PLAN_PE_RELTN


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
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.
CBOS_PE_RELTN_ID DOUBLE N Contributor System identifies the source feed of data from which a row was populated. this is mainly used to determine how to update a set of data that may have originated from more than one source feed.
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.
EXT_PAY_PLAN_PE_RELTN_ID DOUBLE N System generated number that uniquely identifies a row on the EXT_PAY_PLAN_PE_RELTN table.
PFT_ENCNTR_ID DOUBLE N Uniquely identifies the related row on the pft_encntr table.
PFT_PAYMENT_PLAN_ID DOUBLE N Contributor System identifies the source feed of data from which a row was populated. this is mainly used to determine how to update a set of data that may have originated from more than one source feed.
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 - EXT_PAY_PLAN_PE_RELTN


Child Column in EXT_PAY_PLAN_PE_RELTN(FK) Parent Table Name Parent Column Name
Parents: CBOS_PE_RELTN_ID CBOS_PE_RELTN CBOS_PE_RELTN_ID
PFT_ENCNTR_ID PFT_ENCNTR PFT_ENCNTR_ID
PFT_PAYMENT_PLAN_ID PFT_PAYMENT_PLAN PFT_PAYMENT_PLAN_ID