Versions Compared

Old Version 24

changes.mady.by.user Benn Oshrin

Saved on

compared with

New Version 25

changes.mady.by.user Benn Oshrin

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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 v1.1.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 v1.1.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 v1.1.0

organization_id

integer, foreign key

Source organization via known organizations

cm_organizations:id

Unused column removed in v1.1.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