Table Detail Report
PFT_PAYMENT_LOCATION_DEF
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Payment Location Definition |
Definition: | Stores the definition of a payment location. |
Table Type: | REFERENCE |
Column Detail - PFT_PAYMENT_LOCATION_DEF
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. |
DEFAULT_PAYMENT_LOC_IND | DOUBLE | N | This option will allow the user to keep the previous payment location as default payment location in upcoming payments |
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. |
LOGICAL_DOMAIN_ID | DOUBLE | N | The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table. |
ORIG_PAYMENT_LOCATION_DEF_ID | DOUBLE | N | Used to track versions of the payment location definition information. This field will always point back to the initial value created. This may be used to find the correct version when combined with begin and end effective dates and times. |
PAYMENT_LOCATION_DESC | VARCHAR(255) | N | The textual description of the Payment Location |
PAYMENT_LOCATION_NAME | VARCHAR(255) | N | The name of the payment location |
PAYMENT_LOCATION_NAME_KEY | VARCHAR(255) | N | The name of the Payment Location in uppercases with all spaces and special characters removed. |
PFT_PAYMENT_LOCATION_DEF_ID | DOUBLE | N | Unique generated number that identifies a single row on the PFT_PAYMENT_LOCATION_DEF table. |
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 - PFT_PAYMENT_LOCATION_DEF
Child Column in PFT_PAYMENT_LOCATION_DEF(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | LOGICAL_DOMAIN_ID | LOGICAL_DOMAIN | LOGICAL_DOMAIN_ID |
ORIG_PAYMENT_LOCATION_DEF_ID | PFT_PAYMENT_LOCATION_DEF | PFT_PAYMENT_LOCATION_DEF_ID |
Parent Column in PFT_PAYMENT_LOCATION_DEF (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | PFT_PAYMENT_LOCATION_DEF_ID | PFT_PAYMENT_LOCATION | PFT_PAYMENT_LOCATION_DEF_ID |
PFT_PAYMENT_LOCATION_DEF | ORIG_PAYMENT_LOCATION_DEF_ID |
PFT_PAYMENT_PLAN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Profit payment plan |
Definition: | Contains information about the payment plan |
Table Type: | ACTIVITY |
Column Detail - PFT_PAYMENT_PLAN
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. |
AGENCY_NAME | VARCHAR(200) | Y | Stores the name of the agency. |
BEGIN_PLAN_DT_TM | DATETIME | Y | The date/time that the first payment is due |
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_GROUP_ID | DOUBLE | N | Uniquely identifies the related billing entity group. |
BILLING_ENTITY_ID | DOUBLE | N | Foreign key to the Billing Entity for this payment plan. |
CONTRIBUTOR_SYSTEM_CD | 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. |
CURRENT_PERIOD_START_DT_TM | DATETIME | Y | The start date/time of the current period for this plan. |
CURRENT_PLAN_STATUS_CD | DOUBLE | N | The current status of the payment plan |
CYCLE_LENGTH | DOUBLE | N | The length of the cycle between statements |
DUE_DAY | DOUBLE | Y | The day of the month that the payment is due by such as the 15th of the month. |
DURATION_PLAN_DT_TM | DATETIME | Y | The date that the plan should be paid off. This will be calculated based on the payment amount and number of payments. |
ENDING_PLAN_DT_TM | DATETIME | Y | The date/time that the pft_encntr was removed from a formal plan either by being paid or sent back to collection. |
ENDING_PLAN_STATUS_CD | DOUBLE | N | The status when the plan ended. Currently either FORMALNOPAY or PAIDIN FULL. |
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. |
INSTALLMENT_AMOUNT | DOUBLE | N | Total dollar amount that is due each period |
MINIMUM_INSTALLMENT_AMT | DOUBLE | Y | This table stores the minimum instalment amount. |
NUMBER_OF_PAYMENTS | DOUBLE | Y | The number of payments that will be made under the current plan. |
OVERRIDE_PRSNL_ID | DOUBLE | N | This stores the overridding fpp installment amount person identifier. |
PARENT_ENTITY_ID | DOUBLE | N | Foreign key to the person_id for the guarantor |
PARENT_ENTITY_NAME | VARCHAR(32) | Y | Name of the parent entity |
PFT_PAYMENT_PLAN_ID | DOUBLE | N | The unique identifier to the table |
TOTAL_AMOUNT_DUE | DOUBLE | N | The total amount due when the formal payment plan originated |
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 - PFT_PAYMENT_PLAN
Child Column in PFT_PAYMENT_PLAN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | BILLING_ENTITY_ID | BILLING_ENTITY | BILLING_ENTITY_ID |
BILLING_ENTITY_GROUP_ID | BILLING_ENTITY_GROUP | BILLING_ENTITY_GROUP_ID | |
OVERRIDE_PRSNL_ID | PRSNL | PERSON_ID |
Parent Column in PFT_PAYMENT_PLAN (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | PFT_PAYMENT_PLAN_ID | BATCH_TRANS_FILE | PFT_PAYMENT_PLAN_ID |
CREDIT_CARD_RELTN | PFT_PAYMENT_PLAN_ID | ||
EXT_PAY_PLAN_PE_RELTN | PFT_PAYMENT_PLAN_ID | ||
PFT_PAY_PLAN_HIST | PFT_PAYMENT_PLAN_ID | ||
PFT_PAY_PLAN_PE_RELTN | PFT_PAYMENT_PLAN_ID |
PFT_PAY_PLAN_HIST
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | PFT PAY PLAN HIST |
Definition: | Profit payment plan history |
Table Type: | ACTIVITY |
Column Detail - PFT_PAY_PLAN_HIST
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. |
AGENCY_NAME | VARCHAR(200) | Y | Stores the name of the agency. |
BEGIN_PLAN_DT_TM | DATETIME | Y | The date/time that the first payment is due |
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_GROUP_ID | DOUBLE | N | Uniquely identifies the related billing entity group. |
BILLING_ENTITY_ID | DOUBLE | N | Foreign key to the Billing Entity for this payment plan. |
CONTRIBUTOR_SYSTEM_CD | 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. |
CURRENT_PERIOD_START_DT_TM | DATETIME | Y | The start date/time of the current period for this plan. |
CURRENT_PLAN_STATUS_CD | DOUBLE | N | The current status of the payment plan |
CYCLE_LENGTH | DOUBLE | N | The length of the cycle between statements |
DUE_DAY | DOUBLE | Y | The day of the month that the payment is due by such as the 15th of the month. |
DURATION_PLAN_DT_TM | DATETIME | Y | The date that the plan should be paid off. This will be calculated based on the payment amount and number of payments. |
ENDING_PLAN_DT_TM | DATETIME | Y | The date/time that the pft_encntr was removed from a formal plan either by being paid or sent back to collection. |
ENDING_PLAN_STATUS_CD | DOUBLE | N | The status when the plan ended. Currently either FORMALNOPAY or PAIDIN FULL. |
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. |
INSTALLMENT_AMOUNT | DOUBLE | N | Total dollar amount that is due each period |
MINIMUM_INSTALLMENT_AMT | DOUBLE | Y | Stores the minimum installment amount. |
NUMBER_OF_PAYMENTS | DOUBLE | Y | The number of payments that will be made under the current plan. |
OVERRIDE_PRSNL_ID | DOUBLE | N | Stores the overriding FPP installment amount person ID. |
PARENT_ENTITY_ID | DOUBLE | N | Foreign key to the person_id for the guarantor |
PARENT_ENTITY_NAME | VARCHAR(32) | Y | Name of the parent entity |
PFT_PAYMENT_PLAN_ID | DOUBLE | N | Foreign key to the pft_payment_plan table |
PFT_PAY_PLAN_HIST_ID | DOUBLE | N | The unique identifier to the table |
TOTAL_AMOUNT_DUE | DOUBLE | N | The total amount due when the formal payment plan originated |
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 - PFT_PAY_PLAN_HIST
Child Column in PFT_PAY_PLAN_HIST(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | BILLING_ENTITY_ID | BILLING_ENTITY | BILLING_ENTITY_ID |
PFT_PAYMENT_PLAN_ID | PFT_PAYMENT_PLAN | PFT_PAYMENT_PLAN_ID |
PFT_PAY_PLAN_PE_RELTN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | PFT PAY PLAN PE RELTN |
Definition: | Profit payent plan profit encounter relation |
Table Type: | ACTIVITY |
Column Detail - PFT_PAY_PLAN_PE_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. |
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 | Foreign key to the cbos_pe_reltn for this pft_encntr. |
ENDING_ENCNTR_DT_TM | DATETIME | Y | The date/time that this encounter was removed from this payment plan |
ENDING_ENCNTR_STATUS_CD | DOUBLE | N | The status when the encounter was removed from this payment plan. Currently either FORMALNOPAY, PAIDINFULL, or MANUAL REMOV. |
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. |
ORIG_ENCOUNTER_BAL | DOUBLE | Y | The balance of the pft_encntr when it was placed in this playment plan. |
ORIG_ENCOUNTER_DT_TM | DATETIME | Y | The date/time that this encounter was placed in this payment plan. |
PFT_ENCNTR_ID | DOUBLE | N | The corresponding pft_encntr_id for the Profit Encounter in this payment plan. |
PFT_PAYMENT_PLAN_ID | DOUBLE | N | Foreign key to the pft_payment_plan for this pft_encntr |
PFT_PAY_PLAN_PE_RELTN_ID | DOUBLE | N | Unique key to this table |
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 - PFT_PAY_PLAN_PE_RELTN
Child Column in PFT_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 |
PFT_PROCESS_QUEUE
Column Section | Top of Page |
Table-level Detail
Description: | PFT PROCESS QUEUE |
Definition: | Push queue for ProFit tasks |
Table Type: | ACTIVITY |
Column Detail - PFT_PROCESS_QUEUE
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 | 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. |
CHILD_ENTITY_ID | DOUBLE | N | FK to tables using composite keys |
CHILD_ENTITY_NAME | VARCHAR(32) | Y | Name of the child entity |
CURRENT_USER_ID | DOUBLE | N | Contains the person_id of the user currently assigned the item |
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. |
PARENT_ENTITY_ID | DOUBLE | N | FK to the table for which this queue entry points (acount, pft_encntr, bill_rec, etc.) |
PARENT_ENTITY_NAME | VARCHAR(32) | Y | name of the parent entity (ACCOUNT, PFT_ENCNTR, BILL_REC, etc.) |
PFT_PROCESS_QUEUE_ID | DOUBLE | N | Primary Key |
PREVIOUS_USER_ID | DOUBLE | N | FK to the prsnl table. This field is used when a queue entry is transferred to another user. |
PROCESS_MSG_TXT | VARCHAR(100) | Y | Text describing why this entry is in the queue |
PROCESS_SEQ | DOUBLE | Y | Sequence in which to process items in the queue |
PROCESS_STATUS_CD | DOUBLE | N | Status of the queue entry |
PROCESS_STATUS_REASON_CD | DOUBLE | N | Hold location for if we need a status reason codeset |
PROCESS_TYPE_CD | DOUBLE | N | Defines the type process for the queue entry |
SELECTED_TASK_ID | DOUBLE | N | FK to the Selected Task table. Defines what task to which this queue entry belongs |
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. |