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


manager_co_person_idinteger, foreign keyCO Person ID of Managercm_co_people:idAdded in Registry v4.1.0

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

title

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


ordrintegerOrder/Rank/Priority of this Person Role
Added in Registry v3.2.0

status

varchar(2)

Person's Role status within CO

  • A: Active
  • C: Confirmed
  • D: Deleted
  • D2: Duplicate
  • GP: Grace Period
  • I: Invited
  • N: Denied
  • P: Pending
  • PA: Pending Approval
  • PC: Pending Confirmation
  • PV: Pending Vetting
  • S: Suspended
  • X: Declined
  • XP: Expired
  • Y: Approved


source_org_identity_idinteger, foreign keyIf Pipelines are in use, the Org Identity ID of record that created this Person Rolecm_org_identities:id