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.