Guideline 17. Developing a master data model and system

Submitted by Anonymous (not verified) on

The institution develops a unique master data model, which standardizes the definition of the core objects and relationships (e.g. persons, employers, enrolment periods, benefits). A corresponding ICT-based master data system fosters the consistency of such information.

The master data model should be of a highly stable specification covering information items used in most of the social programmes. The model can be viewed as the intersection of the sets of information items used in the social programmes. On the other hand, objects associated with specific programmes and their operations should not be included in the model (e.g. benefit payment information, variants on benefits).

Guideline code
ICT_02300
Mechanism
Mechanism
  • The ICT unit should define and implement a master data model and implement a corresponding information system. The project should involve business experts in addition to ICT staff.
  • The project should identify the core information items (for social security operations) in the institution and metadata should be developed.
  • To ensure the accuracy of the specification, the master data model should be represented through a formal or semi-formal language (e.g. OWL, UML, Entity–Relationship Model).
  • The implementation of a database including the referred information should be based on relational database management systems (RDBMS), ideally using the master data model as metadata. Given the importance of master databases, specialized technologies have been developed for them.
  • ICT staff (in the main) should administer the master data system, and business staff should carry out data stewardship and data specification tasks.
Structure
Structure
  • The management should commission the ICT unit to implement a master data model and information system covering the core objects for social security operations. Although it varies depending on the scope and characteristics of the social security system, this usually includes:
    • Persons’ data, including family ties, role (e.g. employee, retired person, relative of worker);
    • Employers’ data;
    • Social programmes;
    • Relationships between persons and employers, working periods, etc.;
    • Relationships between persons and social programmes (affiliation relationship), registration periods, characteristics of the affiliation, etc.
  • A specialized organizational structure should be established to administer the master data model and information system. To establish accountability, the roles and responsibilities of the units within that structure have to be well defined and documented.
  • The master data model and information system should be based on institutional models and standards: the institutional data governance framework; the service-oriented architecture (SOA)-based interoperability application model, interoperable shared data services (basic registries), and data security and privacy; and the institutional technical standards.
Title HTML
Guideline 17. Developing a master data model and system
Type
Guideline_1
Weight
26