prs_sor_persons
Title | prs_sor_persons |
---|---|
Type | Standardized |
Description | Standardized Person, the master record of an individual within a system of record |
Column | Format | Nullable | Description | Definition | Comments |
---|---|---|---|---|---|
id | integer, primary key | Row identifier | autoincrement | ||
source_sor_id | integer, foreign key | Source SOR for this SOR Person | prx_systems_of_record:id | ||
person_id | integer, foreign key | Calculated Person this SOR Person has been reconciled to | prc_persons:id | ||
date_of_birth | date | Date of birth | Date of birth, according to this SOR | ||
gender_t | varchar(2) | Gender | Additional values may be defined locally | Gender, according to this SOR
|
Migration Notes From OR 1
record_id
renamed toid
(Error rendering macro 'jira' : Unable to locate Jira server for this macro. It may be due to Application Link configuration.)id
dropped (XXX unclear what this was) ( )ssn
dropped (XXX migrate to identifiers? TBD) ( )gender
replaced withgender_t
( )source_sor_id
is now a foreign key ( )- Where is SORID (eg: emplid) stored? ( )