Description:
Manages verification records for users, typically used for identity, document, or background checks. It tracks the type of verification, document information, status, and decision times, along with metadata for audit and compliance.
🔑 Primary Key
id
| Field Name | Data Type | Description |
|---|---|---|
id |
NUMBER | Unique identifier for the verification. |
code |
NUMBER | Verification code generated for the verification process. |
created_at |
TIMESTAMP_TZ | Timestamp when the verification was created. |
host |
TEXT | Host system or domain associated with the verification request. |
reason |
TEXT | Reason for the verification. |
status |
NUMBER | Status of the verification. (0 => created, 1 => approved, 2 => resubmission_requested, 3 => declined, 4 => expired, 5 => abandoned, 6 => started, 7 => review, 8 => submitted, 9 => inflow_completed.) |
status_name |
TEXT | String label for status. |
token |
TEXT | Unique token associated with the verification. |
updated_at |
TIMESTAMP_TZ | Timestamp when the verification was last updated. |
uuid |
TEXT | Universally unique identifier for the verification request. |
valid_until |
TIMESTAMP_TZ | Expiration timestamp for the verification validity. |
guser_id |
NUMBER | The global user ID associated with the verification. |
acceptance_time |
TIMESTAMP_TZ | Timestamp when the verification was accepted. |
decision_time |
TIMESTAMP_TZ | Timestamp when a decision was made regarding the verification. |
document_country |
TEXT | Country of the document being verified. |
document_number |
TEXT | Document number for verification. |
document_type |
NUMBER | Type of document being verified. (0 => PASSPORT, 1 => ID_CARD, 2 => DRIVERS_LICENSE, 3 => RESIDENCE_PERMIT, 4 => OTHER.) |
document_type_name |
TEXT | String label for document_type. |
document_valid_from |
DATE | Date when the document becomes valid. |
document_valid_until |
DATE | Date when the document expires. |
first_name |
TEXT | First name of the individual being verified. |
id_number |
TEXT | Identification number. |
last_name |
TEXT | Last name of the individual being verified. |
driving_license_categories |
ARRAY | Array of driving license categories associated with the individual. |
risk_labels |
ARRAY | Array of risk labels associated with the verification. |
verification_type |
NUMBER | Type of verification. (0 => VERIFF_SDK, 1 => ONFIDO_SDK, 2 => ONFIDO_WEB, 3 => MANUAL.) |
verification_type_name |
TEXT | String label for verification_type. |
driving_license_category_objects |
VARIANT | JSON object representing driving license category details. Sample value: [{ "category": "B", "codes": null, "expiryDate": null, "obtainmentDate": [ 2023, 7, 11 ] }]. |
birthdate |
DATE | Birthdate of the individual being verified. |
document_verification_type |
TEXT | Type of document verification (e.g. DRIVING_LICENSE, ANY). |
_snowflake_inserted_at |
TIMESTAMP_NTZ | System timestamp when the record was inserted into Snowflake. |
_snowflake_updated_at |
TIMESTAMP_NTZ | System timestamp when the record was last updated in Snowflake. |
_snowflake_deleted |
BOOLEAN | True if the record was deleted in the source. |