prs_sor_persons
- Benn Oshrin
Owned by Benn Oshrin
Mar 13, 2013
1 min read
Loading data...
| Title | prs_sor_persons |
|---|---|
| Type | Standardized |
| Description | SOR Person (1 per person per SOR) |
| Column | Format | Nullable? | Description | Definition | Comments |
|---|---|---|---|---|---|
| record_id | integer, primary key | No | Â | Â |  This should really be id |
| date_of_birth | date | Â | Date of birth for this person according to SOR | Â | Need not be same as validity but validity is not implemented |
| gender | integer | Â | Gender of this person according to SOR |
| Â |
| person_id | integer, foreign key | Â | Calculated Person this SOR Person has been reconciled to | prc_persons:id | This column is basically a "reverse key" that is populated after the corresponding prc_person record is created/determined |
| id | varchar(255) | Â | Â | Â | Â |
| source_sor_id | varchar(255), should be integer, foreign key | No | Source SOR for this SOR Person | prd_system_of_record:id  | Â |
| ssn | varchar(9) | Â | US Social Security Number | Â | This column needs to be refactored for better international support |