4 Data Management Tools

This chapter covers the following topics:

  • Data Model Extension: The PBSM Cloud Service provides OOTB placeholder Columns and Tables that can be configured to use as custom Columns, Custom Dimensions, and Custom Management Ledger Tables as suitable to the business requirements. However, these Columns and Table are placeholder items and must be registered before use. The Data Model Extension module enables you to register these Columns and Tables.
  • unresolvable-reference.html#GUID-0A0C8A04-C2F2-48D4-8EBE-725DF346F415: The Data File Specification module helps you to load the data from your systems to the PBSM Cloud Services.
  • File Upload and Download Utility: The File Upload and Download Utility enables you to upload or download files to the Object Store.
  • Data Quality Framework: Data Quality Framework Data Quality Framework consists of a scalable rule-based engine which uses a single-pass integration process to standardize, match, and duplicate information across global data.
  • Data Verification: Data Verification UI allows you to carry out small edits on the imported data. You can also add few entries manually using this UI.
  • Data Housekeeping: The Data Housekeeping UI helps you to Delete data from selected tables, Drop partitions and truncate subpartitions from selected tables, and Archive the data from selected tables.
  • Data Redaction: Oracle Data Redaction provides selective, on-the-fly redaction of sensitive data in database query results prior to display by applications so that unauthorized users cannot view the sensitive data.
  • Balance Reconciliation: Balance Reconciliation module helps you to Reconcile the selected processing/instrument/account balances against the Management Ledger. If any differences are found, you will have the flexibility to choose significant differences and create plug entries for those in the Ledger_Instruments table.
  • Data Stratification: Data Aggregation and Stratification enables you to summarize large volumes of financial instruments to a manageable scale for processing and reporting purposes. The stratification engine is used to intelligently group financial instrument records for processing.
  • Extract Data: The Data Extraction feature allows you to extract the data which can used as input for another downstream service for processing.
  • Configure Cash Flow Edits Rule: The Cash Flow Edits Configuration Window allows you to configure a new Cash Flow Edits Rule.
  • Cash Flow Edits Process: The Cash Flow Edits Process allows you to verify the accuracy and check the completeness of your Instrument Table Data.
  • ALM Output Export: This module discusses the procedure to download the ALM Output details. When you download the data, it moves to Object Store.
  • ALM Table Cleanup: This module discusses the procedure to delete data from ALM Output Tables.