1. User Guide
  2. Data Loaders
  3. Transaction Summary Table Loader
  4. Stage Tables

5.10.1 Stage Tables

Following are examples of various application staging transaction summary tables:

  • STG_LOAN_CONTRACT_TXNS_SUMMARY: holds transaction summary information related to the loan contracts that are present in staging instrument table for loan contracts, that is STG_LOAN_CONTRACTS.
  • STG_CARDS_TXNS_SUMMARY: holds transaction summary information related to the credit cards present that are present in staging instrument table for credit cards, that is STG_CARDS.
  • STG_CASA_TXNS_SUMMARY: holds transaction summary information related to the checking and saving accounts that are present in staging instrument table for CASA, that is STG_CASA.
  • STG_MERCHANT_CARD_TXNS_SUMMARY: holds transaction summary information related to the merchant cards that are present in staging instrument table for merchant cards, that is STG_MERCHANT_CARDS.
  • STG_OTHER_SERVICE_TXNS_SUMMARY: holds transaction summary information related to other services that are present in staging instrument table for other services, that is STG_OTHER_SERVICES.
  • STG_TERMDEPOSITS_TXNS_SUMMARY: holds transaction summary information related to the term deposits that are present in staging instrument table for term deposits, that is STG_TD_CONTRACTS.
  • STG_TRUSTS_TXNS_SUMMARY: holds transaction summary information related to the trust accounts that are present in staging instrument table for trusts, that is STG_TRUSTS.

Note:

These tables are required for PFT application and used in the Allocation definitions.