Person Form
Field reference for core person records. All other roles (Student, Teacher, Advisor) reference a Person record.
Fields
Backed by core.people.
| Field | Column | Type | Required | Notes |
|---|---|---|---|---|
| Person ID | person_id | UUID | Auto | System-generated unique identifier |
| Date of Birth | date_of_birth | Date | No | Birth date |
| Gender | gender_id | Select (Lookup) | No | GENDER |
| Marital Status | marital_status_id | Select (Lookup) | No | MARITAL_STATUS |
| Religion | religion_id | Select (Lookup) | No | |
| Ethnicity | ethnicity_id | Select (Lookup) | No | IPEDS ethnicity category |
| Veteran Status | veteran_status_id | Select (Lookup) | No | |
| Primary Language | primary_language_id | Select (Lookup) | No | |
| Country of Birth | country_of_birth_id | Select (FK) | No | |
| Citizenship | citizenship_country_id | Select (FK) | No | The primary citizenship. Also stored as citizenship_country_code (3 chars). Further citizenships are in core.person_citizenships |
| Nationality | nationality_country_code | Text(3) | No | Code only; no FK column |
| Primary Email | primary_email | No | Denormalised convenience copy — the authoritative list is Emails | |
| Person ID Number | person_id_number | Text(50) | No | Institutional ID number |
| Deceased Date | deceased_date | Date | No | Deceased is this being non-null; there is no boolean |
| FERPA Opt-Out | ferpa_opt_out | Boolean | Yes | Suppresses directory disclosure |
| Is Active | is_active | Boolean | Yes | |
| Merged Into | merged_into_person_id | UUID (FK) | No | Set when this record was merged into another person |
| Legacy Person ID | legacy_person_id | Text(32) | No | Colleague/ODS source ID; unique where present |
Audit columns created_at, created_by, updated_at, updated_by are present and maintained by the application.
Fields that are not on this record
| Looks like a person field | Where it actually lives |
|---|---|
| SSN / SSN last four | person_identifiers, encrypted at rest with click-to-reveal and an access log — never a plain column on people |
| Race | person_races — a person may hold several, so it cannot be one column |
| Is Hispanic/Latino | Derived from ethnicity and race, not stored separately |
| Is Deceased | Not stored; a person is deceased when deceased_date is not null |
| Notes | No notes column exists on core.people |
| Additional citizenships | core.person_citizenships (migration 281), one row per country, unique per person and country; edited on the International tab |
| Visa / immigration status | core.person_visa_status; passport, I-94, EAD and I-20 / DS-2019 numbers are person_identifiers |
Computed Fields (Read-Only)
| Field | Description |
|---|---|
| Display Name | core.person_display_name: current Preferred Name, else the legal name (migration 298). See Names |
| Full Name | Complete legal name |
| Is International | Detail responses only (is_international, with home_country_code). True when a citizenship is on file and none of the person's citizenships -- primary or additional -- is the HOME_COUNTRY setting. Decided by the server; a person with no citizenship on file is not international |
| Age | Calculated from date of birth |
| Is Student | Has student record |
| Is Teacher | Has teacher record |
| Is Advisor | Has advisor record |
Validation Rules
- Person ID is automatically generated as UUID
- Date of Birth cannot be in the future
- Deceased Date cannot be before Date of Birth
- FERPA Opt-Out must be honoured by every directory and disclosure path
Related Sub-Records
A person has multiple related records:
- Names - Legal, preferred, maiden names
- Addresses - Home, mailing, campus addresses
- Phones - Mobile, home, work numbers
- Emails - Personal, institutional emails
Role Records
- Student - Created when person registers for classes
- Teacher - Created when assigned to teach
- Advisor - Created when assigned as advisor
Important Notes
- A person can have multiple roles simultaneously
- Roles are created through business processes, not directly
- Demographic changes update the Person record regardless of role