Smart investigate for payments data tables and views
The following table lists the Smart Investigate for Payments data tables and views. Tables identified as PegaRESEARCH Manager tables are created and loaded during the Smart Investigate for Payments installation process, but also must be loaded into PegaRESEARCH Manager. When you load these tables into PegaRESEARCH Manager they are identical except that they are placed in a separate database.
Using the interface activities described in this chapter, map your data to these tables.
TableName | Description |
PA_Product | This table is required by the PegApp layer but is not used by Smart Investigate for Payments. |
PA_Product_Type | This table is required by the PegApp layer but is not used by Smart Investigate for Payments. |
PAF_Entry | This table prepares the Smart Investigate for Payments accounting entries for posting to an external system. |
PAF_Index_Original | This table indexes the original data from Smart Investigate for Payments for reporting and cannot be modified. |
PAF_Index_Txn | This table indexes the Smart Investigate for Payments accounting data for reporting and cannot be modified. |
PAF_Index_Workparty | This table indexes the Smart Investigate for Payments work items for reporting and cannot be modified. |
PAF_Party | This table holds the Smart Investigate for Payments internal account records. |
PAF_Work | This is the Smart Investigate for Payments work object table and holds case data. When first installed it contains sample data. |
PAF_Rule | This is the Smart Investigate for Payments financial rules table. |
PCB_Accounts | This is the Smart Investigate for Payments party table. |
SI_Index_AdjustmentDetails | This table is used for financial / accounting reports. |
SI_Work | This is the default table for Smart Investigate for Payments work objects. |
SI_Index_Workparty | This table is an index listing of each party associated with a work object. |
SI_SecurityLevel SI_OperatorSecurity | These tables contain Smart Investigate for Payments security configuration records. These tables augment the Smart Investigate for Payments security and are in addition to standard Process Commander security. |
SIV_AdjusmentDetails | 30. This table is used for Financial / Accounting reports. |
SIV_CaseFind | This database view joins SI-Work and SI_Index_WorkParty to allow comprehensive case find capabilities within Smart Investigate for Payments. |
SIV_Workbasket | This database view facilitates reports based on workbaskets. |
SIV_Worklist | This database view facilitates reports based on worklists. |
Research_Links | This table stores transaction data and is a PegaRESEARCH Manager table. |
AdditionalPymtInfo | This table stores transaction data and is a PegaRESEARCH Manager table. |
History | This table stores transaction data and is a PegaRESEARCH Manager table. |
InterestRates | This table stores the interest rates for interest rate table maintenance. |
LoadStat | This table stores transaction data and is a PegaRESEARCH Manager table. |
Message | This table stores transaction data and is a PegaRESEARCH Manager table. |
PaymentCharges | Thistable stores transaction data and is a PegaRESEARCH Manager table. |
PaymentTxn | This table stores transaction data and is a PegaRESEARCH Manager table. |
Security | This table stores transaction data and is a PegaRESEARCH Manager table. |
Settlement | Thistable stores transaction data and is a PegaRESEARCH Manager table. |
WorkActions | This table is used for MIS reports. |
Previous topic Customer information file interface Next topic Pega 8 integration layer