Table | external_identity_roles |
|---|---|
Description | Roles for an External Identity |
Column | Format | Description | Definition | Required | Comments |
|---|---|---|---|---|---|
id | integer, primary key | Row identifier | autoincrement |  | |
| external_identity_id | integer, foreign key | External Identity ID | external_identities:id | | |
| role_key | varchar(512) | External Identity Source's unique key this role maps to | | Role Keys need only be unique within a given Source Key | |
status | varchar(2) | External Identity's status |
| | |
| affiliation_type_id | integer, foreign key | Broad affiliation to the external entity | 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 | External Identity is valid from this time | |||
| valid_through | datetime | External Identity is valid through this time | |||
| manager_identifier | varchar(512) | Identifier associated with Person record describing this Role's Manager | identifiers:identifier | ||
| sponsor_identifier | varchar(512) | Identifier associated with Person record describing this Role's Sponsor | identifiers:identifier | ||
| ordr | integer | Order/Rank/Priority of this External Identity Role (for all Roles for this External Identity) |