Child pages
  • cm_org_identities
Skip to end of metadata
Go to start of metadata

Table

cm_org_identities

Description

Person identity, from institutional source

Column

Format

Description

Definition

Comments

id

integer, primary key

Row identifier

autoincrement


statusvarchar(2)Org Identity status
  • RM: Removed
  • SY: Synced
Added in v2.0.0. Currently intended primarily for org identities synced from an org identity source.

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

organization_id

integer, foreign key

Source organization via known organizations

cm_organizations:id

Unused column removed in v2.0.0

co_id

integer, foreign key

If pool_org_identities is false in the CMP Enrollment Configuration, the CO in which this Org Identity is available

cm_cos:id


  • No labels