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 | prd_system_of_record:id rename table | ||
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
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?