Table | cm_org_identity_source_records |
|---|---|
Description | Cached records from external org identity sources |
Column | Format | Description | Definition | Comments |
|---|---|---|---|---|
id | integer, primary key | Row identifier | autoincrement | |
org_identity_source_id | integer, foreign key | The Org Identity Source this record is from | ||
sorid | varchar(1024) | The Org Identity Source's unique key for this record | ||
source_record | text | The raw (unprocessed) record from the Org Identity Source | May be used in a diff operation to detect changes | |
last_update | timestamp | Time of last retrieval from Org Identity Source | ||
| org_identity_id | integer, foreign key | Org Identity created from and associated with this source record | cm_org_identities:id | |
| co_petition_id | integer, foreign key | CO Petition that created this Org Identity | cm_co_petitions:id | Added in Registry v3.1.0 |
| reference_identifier | varchar(40) | If this record was subject to ID Match, the Reference Identifier obtained from the Match request | TAP ID Match API | Added in Registry v3.3.0 |