EVERIFY

This source table stores information about the E-Verify cases.

Columns

Column	Data type	Description
APPLICANTID	NUMBER	The identifier for the talent/applicant.
APPLICANTTASKID	NUMBER	The identifier for the applicant task.
BUILDID	NUMBER	Avionté’s unique identifier for each of its customers’ instances or builds. The value in this field is the same for all rows.
CASENUMBER	VARCHAR	The E-Verify Case Number.
CDCSTATUS	VARCHAR	For Avionté internal use only.
EVERIFYCASEURL	VARCHAR	The E-Verify Case URL.
ID	NUMBER	The identifier for the record.
ISAUTHORIZED	NUMBER	An Authorized Indicator.
ISCLOSED	NUMBER	An indication of whether the E-Verify Case is closed or not.
LASTEVENTDATETIMEUTC	TIMESTAMP_NTZ	The timestamp for the last event.
LASTUPDATEDDATE	TIMESTAMP_NTZ	The timestamp when the row was last updated.
SOURCE	VARCHAR	The source for the record.
STATUSID	NUMBER	The Status identifier of the Record.
SUBMITDATE	TIMESTAMP_NTZ	The submission date for the E-Verify Case.
SUBMITUSERID	NUMBER	The user identifier for the person that submitted the E-Verify Case.