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.