Retrieves the languages of a single prospect instance.

Table Specific Information

Select

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

For example:

SELECT * FROM ProspectsLanguages WHERE Prospects_Id = 'c1d030d96f4c900144b4d0bd8d470000';

Workday Resource Information

Retrieves the languages of the prospect with the specified ID.

Secured by: Prospects

Scope: Recruiting, Talent Pipeline

Aggregate Fields

The connector represents the following fields as aggregates containing JSON text. Each of them conforms to their respective schema. Fields marked with an asterisk are required and must be included if their parent object is. Fields marked with a hyphen are read-only and must not be included when calling stored procedures or when performing an INSERT or UPDATE.

This information is derived from the Workday REST API specification which does not explicitly list all business rules and validations that apply to each object. More fields may be required than what is listed here.

Abilities_Aggregate

[{
  abilityType: { /* The type of language ability. See the configured types in the Maintain Language Ability Types. */
     -descriptor: Text /* The display name of the instance */
     -href: Text /* A link to the instance */
     *id: Text /* wid / id / reference id */
  }
  id: Text /* Id of the instance */
  proficiency: { /* The proficiency for a specific language ability. */
     -descriptor: Text /* The display name of the instance */
     -href: Text /* A link to the instance */
     *id: Text /* wid / id / reference id */
  }
}]

Columns

Name	Type	ReadOnly	Description
Id [KEY]	String	False	The unique identifier for this specific language entry, which distinguishes it from other entries in the table.
Prospects_Id [KEY]	String	False	The system-generated Workday ID (WID) that links this language skill record to a specific prospect.
Abilities_Aggregate	String	False	A collection of skills and proficiencies demonstrated by the prospect in the specified language, including speaking, writing, reading, and comprehension.
Language_Descriptor	String	False	The display name of the instance
Language_Href	String	False	A direct URL or reference link to the Workday instance of this language record, allowing quick access within the system.
Language_Id	String	False	A unique identifier for the language within Workday, which can be a WID, reference ID, or another system-generated ID.
Native	Bool	False	Indicates whether this language is the prospect’s native language. If the value is 'true,' the individual considers this their primary language.