Data Model

Raw (R) Tables

Raw Tables reflect the data as provided by the SOR, unmodified.

TableDescriptionStatus
prr_src_SORKEYSource table (or view) per system of record. This table will generally be maintained by OR via the OR Loader.Provisional
prr_work_SORKEYWork 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

(warning) 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.

TableDescriptionStatus
prs_addressesStandardized physical addressesProvisional
prs_email_addressesStandardized email addressesProvisional
prs_identifiersSOR-level identifiersProvisional
prs_namesStandardized namesProvisional
prs_phonesStandardized telephone numbersProvisional
prs_role_recordsSOR Role Records (1 per person per role per SOR)Provisional
prs_sor_personsStandardized 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.

TableDescriptionStatus
prc_addressesCalculated physical addressesProvisional
prc_email_addressesCalculated email addressesProvisional
prc_identifiersPerson-level identifiersProvisional
prc_namesCalculated namesProvisional
prc_personsCalculated Person, the master record of an individual (1 per person)Provisional
prc_phones Calculated telephone numbersProvisional
prc_role_recordsCalculated Role RecordsProvisional

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.

TableDescriptionStatus
ctd_countriesCountriesProvisional
ctd_regionsStates / RegionsProvisional
drd_buildingsBuildingsProvisional
drd_campusesCampusesProvisional
drd_organizational_unitsOrganizational Unit/Departmental hierarchyProvisional

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.

TableDescriptionStatus
ctx_data_typesData type definitions (for _t columns)Provisional
ctx_history_records (warning) Need to discuss, vs aud_ tables
prx_systems_of_recordList of Systems of Records (SORs) known to the RegistryProvisional