3 Data Administration

This chapter covers the Data Model Extension, Data File Specification, File Upload and Download, Data Maintenance Interface, and Data Quality Framework topics.

Data Administration 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.
• Data File Specification: 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 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: 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.
• 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.