| 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 |
| Gender, according to this SOR
|
Additional values may be defined locally
Migration Notes From OR 1
record_idrenamed toididdropped (XXX unclear what this was)ssndropped (XXX migrate to identifiers? TBD)genderreplaced withgender_t- Where is SORID (eg: emplid) stored?