Table | ext_identity_source_records |
|---|---|
Description | External Identity Source Records |
This table should be called external_identity_source_records, but that name is too long for certain contexts.
Column | Format | Description | Definition | Required | Comments |
|---|---|---|---|---|---|
id | integer, primary key | Row identifier | autoincrement |  | |
| external_identity_source_id | integer, foreign key | External Identity Source ID | external_identity_sources:id | | |
source_key | varchar(1024) | External Identity Source's unique key this record maps to | | ||
source_record | text | The raw (unprocessed) record from the External Identity Source backend | May be used in a diff operation to detect changes | ||
| last_update | timestamp | Time of last retrieval from External Identity Source backend | |||
| external_identity_id | integer, foreign key | External Identity created from and associated with this source record | external_identities:id | ||
| reference_identifier | varchar(40) | If this record was subject to ID Match, the Reference Identifier obtained from the Match request | TAP ID Match API |