Table | pipelines |
|---|---|
Description | Pipelines |
Column | Format | Description | Definition | Required | Comments |
|---|---|---|---|---|---|
id | integer, primary key | Row identifier | autoincrement |  | |
| co_id | integer, foreign key | CO Record ID | cos:id | | |
description | varchar(128) | Description | |||
| status | varchar(2) | Status |
| | |
| match_strategy | varchar(2) | Match strategy on add of new record |
| | |
| match_email_address_type_id | integer, foreign key | For match strategy of Email Address, the type of the email address to use for matching | types:id | ||
| match_identifier_type_id | integer, foreign key | For match strategy of Identifier, the type of the identifier to use for matching | types:id | ||
| match_server_id | integer, foreign key | For match strategy of External, the Match Server ID | match_servers:id | ||
| sync_status_on_delete | varchar(2) | When an External Identity Role record is deleted, the status to set the corresponding Person Role to |
| ||
| sync_affiliation_type_id | integer, foreign key | When adding or updating a Person Role, the affiliation given to the Role (overriding any value provided by the source) | types:id | ||
| sync_cou_id | integer, foreign key | When adding or updating a Person Role, the COU the resulting Role should be attached to | cous:id | ||
| sync_replace_cou_id | integer, foreign key | When adding a Person Role, if a corresponding Person Role is found in the specified COU delete/expire it | cous:id | ||
| sync_identifier_type_id | integer, foreign key | When syncing relationships, the identifier type to use for mapping | types:id |