Data Model
- Benn Oshrin
Raw (R) Tables
Raw Tables reflect the data as provided by the SOR, unmodified.
| Table | Description | Status |
|---|---|---|
| prr_src_SORKEY | Source table (or view) per system of record. This table will generally be maintained by OR via the OR Loader. | Provisional |
| prr_work_SORKEY | Work table, corresponding one-to-one with prr_src_SORKEY. When a row is processed from prr_src_SORKEY, the corresponding row will be inserted into or updated in prr_work_SORKEY. | Provisional |
SORKEY corresponds to prx_systems_of_record:sor_key
Standardized (S) Tables
Standardized Tables (__s prefixed) are loaded from System Of Record data, cleaned up so all records look the same regardless of SOR formatting quirks. They are for internal (to OpenRegistry) use only. Standardized data is removed if the corresponding raw SOR record is removed.
| Table | Description | Status |
|---|---|---|
| prs_addresses | Standardized physical addresses | Provisional |
| prs_email_addresses | Standardized email addresses | Provisional |
| prs_identifiers | SOR-level identifiers | Provisional |
| prs_names | Standardized names | Provisional |
| prs_phones | Standardized telephone numbers | Provisional |
| prs_role_records | SOR Role Records (1 per person per role per SOR) | Provisional |
| prs_sor_persons | Standardized Person, the master record of an individual within a system of record (1 per person per SOR) | Provisional |
Calculated (C) Tables
Calculated Tables (__c prefixed) are created by OpenRegistry from standardized tables based on configured rules, and are considered "exportable". They reflect a consolidated view of a Person, across all SORs. Calculated data remains even after the corresponding SOR data is removed.
| Table | Description | Status |
|---|---|---|
| prc_addresses | Calculated physical addresses | Provisional |
| prc_email_addresses | Calculated email addresses | Provisional |
| prc_identifiers | Person-level identifiers | Provisional |
| prc_names | Calculated names | Provisional |
| prc_persons | Calculated Person, the master record of an individual (1 per person) | Provisional |
| prc_phones | Calculated telephone numbers | Provisional |
| prc_role_records | Calculated Role Records | Provisional |
Dictionary (D) Tables
Dictionary Tables (__d prefixed) are support tables that hold (pre)defined definitions external to the Registry. They may be loaded from specialized feeds or manually set up.
| Table | Description | Status |
|---|---|---|
| ctd_countries | Countries | Provisional |
| ctd_regions | States / Regions | Provisional |
| drd_buildings | Buildings | Provisional |
| drd_campuses | Campuses | Provisional |
| drd_organizational_units | Organizational Unit/Departmental hierarchy | Provisional |
Supporting (X) Tables
Supporting Tables (__x prefixed) are support tables that relate to the management of the system, and that are generally only instantiated or modified by the system or an administrator.
| Table | Description | Status |
|---|---|---|
| ctx_data_types | Data type definitions (for _t columns) | Provisional |
| ctx_history_records | Need to discuss, vs aud_ tables | |
| prx_systems_of_record | List of Systems of Records (SORs) known to the Registry | Provisional |