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 |