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 toÂid
(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 withÂgender_t
 ( )source_sor_id
 is now a foreign key ( )-  Where is SORID (eg: emplid) stored? ( )