5.2.4 Create and Execute Batch

To create and execute the batch:

  1. From the LHS menu, navigate to Operations and Processes, select Scheduler, and then select Define Batch. For more details, see Define Batch.
  2. From the LHS menu, navigate to Operations and Processes, select Scheduler, and then select Define Task. For more details, see Adding a Task.

    Refer to the following table for Component and Parameters to be defined for different tasks.

    Table 5-10 Components and Parameters

    Component Parameters Target Tables
    PBSM_DFCS_Data_Transfer_instruments

    ADS Id: This displays list of data connectors available. Select one value from LOV.

    Data File Specification Id: This displays list of seeded and user defined DFS definitions. Select one relevant value for the selected ADS.

    Data Source Id: This displays members of ‘Instrument Data Source’ dimension. Select one value from LOV. Instrument data belonging to this source only will be moved from DFCS to PBSM.

    Optional Input: This can be used to specify any other input parameter in JSON Object/String.

    Stage Assets

    Stage Liabilities

    Stage Derivatives

    Stage Fee Based Services

    Stage Loan Commitments

    Stage Off Balance Sheet
    PBSM_DFCS_Data_Transfer_Dimensions

    ADS Id: This displays list of data connectors available. Select one value from LOV.

    Optional Input: This can be used to specify any other input parameter in JSON Object/String.

    		Stage Dimensions Interface
    PBSM_DFCS_Data_Transfer_ExchangeRates

    ADS Id: This displays list of data connectors available. Select one value from LOV.

    Rate Data Source Id: This displays members of ‘Rate Data Source’ dimension. Select one value from LOV. Data belonging to this source only will be moved from DFCS to PBSM.

    Optional Input: This can be used to specify any other input parameter in JSON Object/String.

    		Stage Exchange Rates
    PBSM_DFCS_Data_Transfer_InterestRates

    ADS Id: This displays list of data connectors available. Select one value from LOV.

    Rate Data Source Id: This displays members of ‘Rate Data Source’ dimension. Select one value from LOV. Data belonging to this source only will be moved from DFCS to PBSM.

    Optional Input: This can be used to specify any other input parameter in JSON Object/String.

    		Stage IRC Rate History
    PBSM_DFCS_Data_Transfer_InstrumentSupplementary

    ADS Id: This displays list of data connectors available. Select one value from LOV.

    Data File Specification Id: This displays list of seeded and user defined DFS definitions. Select one relevant value for the selected ADS.

    Data Source Id: This displays members of ‘Instrument Data Source’ dimension. Select one value from LOV. Instrument data belonging to this source only will be moved from DFCS to PBSM.

    Optional Input: This can be used to specify any other input parameter in JSON Object/String.

    Stage Account Index History

    Stage Account Rate Tiers

    Stage Embedded Options Schedule

    Stage Payment Schedule
  3. Select the seeded batch and click Edit Parameters. In the Dynamic Parameters pop-up window, change the date to the relevant As-of-Date, and then save the batch.
  4. From the LHS menu, navigate to Operations and Processes, select Scheduler, and then select Execute Batch. For more information, see Schedule Batch.
  5. From the LHS menu, navigate to Operations and Processes, select Scheduler, and then select Monitor Batch. For more information, see Monitor Batch.
  6. Select the Batch, MISDATE and the Batch name. Select the latest execution and click Start Monitor.