Data Model

Raw (R) Tables

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

Table	Description	Status

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

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

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

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

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