APPLICANTSOURCESTAGESHISTORICALDATA

This source table stores information about historical applicant source stages.

Columns

Column	Data type	Description
ACTIVITYDATE	TIMESTAMP_NTZ	Activity date for the applicant source stage.
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.
REQID	NUMBER	The identifier for the associated requisition.
SOURCEENTITY	VARCHAR	The source entity (e.g., Nominated).
SOURCENAME	VARCHAR	The source name (e.g., Referral, Recruited, Indeed).
STAGE	VARCHAR	The stage (e.g., Submitted).