Table | cm_co_person_roles |
---|---|
Description | Per-CO person roles |
Column | Format | Description | Definition | Comments |
---|---|---|---|---|
id | integer, primary key | Row identifier | autoincrement |
|
co_person_id | integer, foreign key | CO Person ID | cm_co_people:id |
|
sponsor_co_person_id | integer, foreign key | CO Person ID of Sponsor for continued membership | cm_co_people:id | not necessarily the same as the enrollment sponsor in cm_co_petitions |
cou_id | integer, foreign key | COU ID | cm_cous:id |
|
affiliation | varchar(8) | Broad affiliation to CO | eduPerson person | Extended Type |
varchar(128) | Title at CO | X.520 via RFC 4519 person |
| |
o | varchar(128) | CO | X.520 via RFC 4519 person |
|
ou | varchar(128) | Departmental affiliation at CO | X.520 via RFC 4519 person |
|
valid_from | datetime | Person Role is valid member of CO from this time | If null, valid any time through valid_through |
|
valid_through | datetime | Person Role is valid member of CO through (but not past) this time | If null, valid any time from valid_from |
|
status | varchar(2) | Person's Role status within CO |
|
|
source_org_identity_id | integer, foreign key | If Pipelines are in use, the Org Identity ID of record that created this Person Role | cm_org_identities:id |