Table | person_roles |
|---|---|
Description | Roles for a Person |
Column | Format | Description | Definition | Required | Comments |
|---|---|---|---|---|---|
id | integer, primary key | Row identifier | autoincrement |  | |
| person_id | integer, foreign key | Person ID | people:id | | |
| cou_id | integer, foreign key | COU ID | cous:id | ||
status | varchar(2) | Person's Role status within the CO |
| | |
| affiliation_type_id | integer, foreign key | Broad affiliation to the CO | types:id | | |
| title | varchar(128) | Title | |||
| organization | varchar(128) | Organization | Field was named | ||
| department | varchar(128) | Department | Field was named ou prior to v5.0.0 | ||
| valid_from | datetime | Person Role is valid member from this time | |||
| valid_through | datetime | Person Role is valid member of CO through this time | |||
| manager_person_id | integer, foreign key | Person ID of Manager | people:id | ||
| sponsor_person_id | integer, foreign key | Person ID of Sponsor for continued membership | people:id | ||
| ordr | integer | Order/Rank/Priority of this Person Role (for all Roles for this Person) | |||
| source_external_identity_role_id | integer, foreign key | External Identity Role that was the source for this Person Role | external_identity_roles:id | ||
| frozen | boolean | Whether or not Pipeline processing and validity date status recalculation will update this record |
|