3 Data Administration

This chapter introduces the following Data Administration tools:

  • 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.
  • Data File Administration: This topic covers the Data File Specification, Data File History, and File Upload and Download functionalities.
  • Data Maintenance Interface: Data Maintenance Interface (DMI) helps to design a Data Form in a user-specified format. Further, it allows to perform maintenance activities using the Designed Form.
  • 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, drop partitions and truncate sub-partitions, and archive the data from selected tables.
  • 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.
  • Redaction Framework: Oracle Data Redaction provides selective, on-the-fly redaction of sensitive data in database query results prior to display by applications.
  • Data Retention: Data Retention enables you to view policies that manage data lifecycle by archiving or deleting data based on retention criteria, and to monitor execution history.
  • Data Stratification: Data Aggregation and Stratification enables you to summarize large volumes of financial instruments to a manageable scale for processing and reporting purposes.
  • Data Model Extension
  • Data File Administration
    This topic covers the following sub-topics:
  • Data Maintenance Interface
  • 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
    The Data Verification UI helps you to verify the data that is loaded from the source systems to the Cloud Service’s stage and processing tables, make minor corrections/adjustment to the data, and add new data directly into the tables. This UI allows you to add one record at a time and is not recommended for high volume additions as entering data is a lengthy process.
  • Lookup Tables
    Lookup Tables are user-defined database tables created to hold user data for matching instrument-level measures or attributes and returning a corresponding value. The user data is matched conditionally with columns from a Profitability Management Cloud Service instrument table, and a user-specified return value is stored in the return columns of the Lookup table.
  • Data Housekeeping
  • Balance Reconciliation
    The Profitability and Balance Sheet Management Cloud Service's 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.
  • Rules Framework
    The Rules Framework provides a user-friendly interface for creating, managing, and executing business rules without requiring direct SQL knowledge. It enables you to define rule logic using datasets, conditions, hierarchies, and expressions, and preview the impact before execution.
  • Datasets
    The Dataset UI enables an Admin to specify the selection of tables and columns.
  • Data Extraction
  • Data Redaction
    PBSMCS is enhanced to enable masking of sensitive data and Personal Identification Information (PII) to adhere to Regulations and Privacy Policies.
  • Data Stratification
  • Cash Flow Edits
    In this section, you can find the details about all Cash Flow Edits.
  • Cash Flow Edits Process
  • Account Summary
  • Cash Flow Table Cleanup
  • Cash Flow Output Export
    This module discusses the procedure to download the Cash Flow Output details. When you download the data, it moves to Object Store. To export the Cash Flow Output, follow these steps: