K Seeded Batches

The following sections describe the seeded batches available in OFS FTP application.

• Load Instrument Summary
• <INFODOM>_PFT_MANAGEMENTLEDGER_LOAD_UNDO
• <INFODOM>_T2T_ALL_INSTRUMENT_TABLES
• <INFODOM>_T2T_ALL_TXN_SUMMARY
• <INFODOM>_T2T_MANAGEMENT_LEDGER_MULTI_SOURCE
• <INFODOM>_T2T_ALL_INS_SUMM_TABLES
• <INFODOM>_DIMENSION_ACCOUNTS
• <INFODOM>_T2T_FOR_FSI_D_CUSTOMER
• <INFODOM>_LOAD_INSTRMNT_SUMMARY
• List of Deprecated Instrument Summary T2Ts

• Load Instrument Summary
  For users who want to consolidate Profitability and Funds Transfer Pricing information from multiple Instrument tables into a single consolidated table, a new process has been created and is described below. The process includes a Data Transformation procedure that will move account level data from each Instrument table into a single table, FSI_D_INST_SUMMARY. The primary use for this new table is that it becomes a single data source for moving Profitability and Funds Transfer Pricing results to FCT tables in the reporting area and replaces the previous process that included separate T2T’s for each instrument table. Users may also want to use this table to build Profitability or Funds Transfer Pricing reports directly against process area data.
• <INFODOM>_PFT_MANAGEMENTLEDGER_LOAD_UNDO
  This Batch can be used to UNDO the data loaded into LEDGER CLASS tables.
• <INFODOM>_T2T_ALL_INSTRUMENT_TABLES
  This seeded batch contains the following Instrument Table T2Ts:
• <INFODOM>_T2T_ALL_TXN_SUMMARY
  This seeded batch contains the following Transaction Summary Table T2Ts:
• <INFODOM>_T2T_MANAGEMENT_LEDGER_MULTI_SOURCE
  This seeded batch along with the underlying DTs and T2T enables tracking of data from the Staging table to the Management ledger table using identity codes. For each distinct value of "Data Origin" in the Staging table, a new Identity code is used to populate the Management ledger and FSI_DATA_IDENTITY tables. The value of V_DATA_ORIGIN in the Staging table is mapped to the FSI_DATA_IDENTITY.description column.
• <INFODOM>_T2T_ALL_INS_SUMM_TABLES
  This seeded batch contains the following Instrument Summary Table T2Ts:
• <INFODOM>_DIMENSION_ACCOUNTS
  This seeded batch contains the following SCDs to populate the dim_accounts table:
• <INFODOM>_T2T_FOR_FSI_D_CUSTOMER
  This seeded batch contains the following T2T to load the FSI_D_CUSTOMER table:
• <INFODOM>_LOAD_INSTRMNT_SUMMARY
  This seeded batch contains the following DT to load the FSI_D_INST_SUMMARY from individual INSTRUMENT tables:
• List of Deprecated Instrument Summary T2Ts
  Starting with this Release, the following Instrument Summary T2Ts are deprecated.