ProspectsExperiences

Stores and retrieves work experience details of prospects, allowing recruiters to assess career history and job suitability.

Table Specific Information

The Workday driver requires filtering on Prospects_Id in order to perform the query.

For example:

SELECT * FROM ProspectsExperiences WHERE Prospects_Id = 'c1d030d96f4c900144b4d0bd8d470000';

Retrieves the work experience with the specified ID for the specified prospect.

Secured by: Prospects

Scope: Recruiting, Talent Pipeline


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier for this specific work experience entry, assigned automatically.
Prospects_Id [KEY]	String	False	The unique Workday ID (WID) associated with the prospect to whom this work experience belongs.
CompanyName	String	False	The full name of the company where the candidate was employed, as entered in their job history.
CurrentlyWorkHere	Bool	False	Indicates whether the candidate is still employed at this company. If the value is 'true,' the employment is ongoing.
Description	String	False	A detailed summary of the candidate's responsibilities, achievements, and contributions during their tenure at this company.
EndMonth	Decimal	False	Represents the numerical month (1-12) when the candidate's employment at this company ended.
EndYear	Datetime	False	The four-digit year in which the candidate's employment at this company concluded.
Location	String	False	The geographic location of the company where the candidate was employed, which can include city and state.
StartMonth	Decimal	False	Represents the numerical month (1-12) when the candidate began working at this company.
StartYear	Datetime	False	The four-digit year in which the candidate's employment at this company commenced.
Title	String	False	The job title or position held by the candidate at this company, reflecting their role and responsibilities.