Person records within a given system can be found in <platform>_<bot_id>_person
.
The person table holds one record per person in the source system. Data is mapped into a common schema, with the remote_person_id as the primary key.
The standard person fields pulled into the Frakture warehouse are below. These are the core Frakture standard, but some bots might be able to obtain additional fields for their respective systems. If present, such fields are supplemental for your benefit; they will not be standard across other people streams nor will they be utilized for any automated Frakture analysis or in stock Frakture reports.
** Note that Frakture does not auto-generate complete addresses based on partial information (e.g., we do not infer postal code from a street address, nor city/state from postal code). We capture street, city, region, postal code, and country information only as explicitly provided by the source system.