Table | sp_co_person_roles |
|---|---|
Description | Per-CO person roles |
| Plugin | SQL Provisioning Plugin |
For column definitions, see cm_co_person_roles.
Column | Format | Comments |
|---|---|---|
id | integer, primary key | |
co_person_id | integer, foreign key | |
| manager_co_person_id | integer, foreign key | Added in Registry v4.1.0 |
sponsor_co_person_id | integer, foreign key | |
cou_id | integer, foreign key | |
affiliation | varchar(8) | |
| eduperson_affiliation | varchar(32) | As mapped via Extended Types. Added in Registry v4.2.0 |
| title | varchar(128) | |
o | varchar(128) | |
ou | varchar(128) | |
valid_from | datetime | |
valid_through | datetime | |
| ordr | integer | |
status | varchar(2) |