Table | cm_org_identities |
|---|---|
Description | Person identity, from institutional source |
Column | Format | Description | Definition | Comments |
|---|---|---|---|---|
id | integer, primary key | Row identifier | autoincrement | |
| status | varchar(2) | Org Identity status |
| Added in v2.0.0. Currently intended primarily for org identities synced from an org identity source. |
| date_of_birth | date | Person's date of birth | Added in Registry v3.3.0 | |
affiliation | varchar(8) | Broad affiliation to source organization | eduPerson person | |
title | varchar(128) | Title at source organization | X.520 via RFC 4519 person | |
o | varchar(128) | Source organization | X.520 via RFC 4519 person | |
ou | varchar(128) | Departmental affiliation at source organization | X.520 via RFC 4519 person | |
valid_from | datetime | Org Identity is considered valid from this time | If null, valid any time through valid_through | Added in v2.0.0 |
valid_through | datetime | Org Identity is considered valid through (but not past) this time | If null, valid any time from valid_from | Added in v2.0.0 |
| manager_identifier | varchar(512) | Identifier for this Org Identity's manager | cm_identifiers:identifier | Added in v4.1.0 |
| sponsor_identifier | varchar(512) | Identifier for this Org Identity's sponsor | cm_identifiers:identifier | Added in v4.1.0 |
|
|
| Unused column removed in v2.0.0 | |
co_id | integer, foreign key | If | cm_cos:id |