Table

cm_co_pipelines

Description

Per-CO pipelines

Column

Format

Description

Definition

Comments

id

integer, primary key

Row identifier

autoincrement


co_id

integer, foreign key

CO ID

cm_cos:id


namevarchar(128)Name

status

varchar(128)

Status of Org Identity Source Plugin

  • A: Active 
  • S: Suspended


match_strategyvarchar(2)Match strategy on add of new record
  • EA: Email Address
  • EX: External
  • ID: Identifier
  • NO: No Matching

match_typevarchar(32)For match strategy of Email Address or Identifier, the type of the email address or identifier to use for matchingcm_co_extended_types:name
match_server_idinteger, foreign keyMatch Server IDcm_match_servers:idAdded in Registry v3.3.0
sync_on_addbooleanSync record on add

sync_on_updatebooleanSync record on update

sync_on_deletebooleanSync record on delete

sync_coperson_statusvarchar(2)If set new CoPerson record will be created with this status
  • A: Active
  • C: Confirmed
  • D: Deleted
  • D2: Duplicate
  • GP: Grace Period
  • I: Invited
  • N: Denied
  • P: Pending
  • PA: Pending Approval
  • PC: Pending Confirmation
  • S: Suspended
  • X: Declined
  • XP: Expired
  • Y: Approved
Added in Registry v3.3.1
create_rolebooleanCreate a corresponding CO Person Role on sync

sync_cou_idinteger, foreign keyWhen adding or updating a record, the COU the resulting Person Role should be attached tocm_cous:id
sync_affiliationvarchar(32)When adding or updating a CO Person Role, the affiliation given to the Role (regardless of Org Identity affiliation)

sync_replace_cou_idinteger, foreign keyWhen adding a record, if a corresponding role is found in the specified COU delete/expire itcm_cous:id
sync_status_on_deletevarchar(2)When syncing a record on delete, set the corresponding Person Role to the specified status
  • D: Deleted
  • GP: Grace Period
  • S: Suspended
  • XP: Expired

sync_identifier_typevarchar(32)When syncing relationships, the identifier type to use for mappingcm_co_extended_types:nameAdded in Registry v4.1.0
co_enrollment_flow_idinteger, foreign keyCO Enrollment Flow ID to trigger during synccm_co_enrollment_flows:idAdded in Registry v3.3.0
  • No labels