Documentation: trust_trace

Trust Trace - the results of data validations and checks on subjects from other tables. Populated by data processors.

To import data in this format you can use our API. -> API Documentation

You can also supply us with files in xlsx, csv or json format. -> Example CSV

	type	p14n	blurred	autogenerated	required
uid	string	⤫	⤫	✓	⤫
subject_origin + subject_uid + check
subject_origin	enum: shs, meters, grids, payments_ts	⤫	⤫	✓	⤫
The data category where we find the subject uid. Basically the table name without data_ prefix
subject_uid	string	⤫	⤫	✓	⤫
The uid of the subject. Referring to the the uid in its origin table.
check	string	⤫	⤫	✓	⤫
The name of the check performed
result	string	⤫	⤫	✓	⤫
The result of the performed check. Casted as string as it can have various forms depending on what check is performed.
id	integer	⤫	⤫	✓	⤫
Internal primary key
created_at	datetime	⤫	⤫	✓	⤫
Timestamp when row was inserted
updated_at	datetime	⤫	⤫	✓	⤫
Timestamp when row was updated
source_id	integer	⤫	⤫	✓	⤫
References Source of data
import_id	integer	⤫	⤫	✓	⤫
References Import of data
organization_id	integer	⤫	⤫	✓	⤫
References Organization of data
custom	jsonb	⤫	⤫	✓	⤫
Saves additional imported data out of standard structure
data_origin	string	⤫	⤫	✓	⤫
Origin of the data, generic or name of the api
last_import_id	integer	⤫	⤫	✓	⤫
Id of the last import which updated the record
last_source_id	integer	⤫	⤫	✓	⤫
Id of the last Source which updated the record