APPLICANT_CONTRACTS

This source table stores information about applicant contracts.

Columns

Column	Data type	Description
APPID	NUMBER	The identifier for the talent/applicant.
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.
CANCELDATE	TIMESTAMP_NTZ	The date the contract was cancelled.
CDCSTATUS	VARCHAR	For Avionté internal use only.
CONTRACTID	NUMBER	The identifier for the contract.
CONTRACTTYPEID	NUMBER	The identifier for the contract type.
DOCID	NUMBER	The identifier for the document.
DOCKEY	VARCHAR	The Document Key (deprecated – use DOCID instead).
DOCNAME	VARCHAR	The name of the document.
EXTERNALDB	VARCHAR	For Avionté internal use only. Non-null values typically mean the row was imported from another data source.
LASTUPDATEDDATE	TIMESTAMP_NTZ	The timestamp when the row was last updated.
OLDID	NUMBER	For Avionté internal use only.
OPENDATE	TIMESTAMP_NTZ	The date the contract was opened.
PARTIALSIGNDATE	TIMESTAMP_NTZ	The date the contract was partially signed.
SENDDATE	TIMESTAMP_NTZ	The date the contract was sent.
SIGNDATE	TIMESTAMP_NTZ	The date the contract was signed.
TEMPBUILDID	NUMBER	For Avionté internal use only.
USERID	NUMBER	The identifier of the user that created the contract record.