Excel Add-In for Workday

Build 25.0.9434

ProspectsLanguages

Captures language proficiency information for prospects, supporting multilingual hiring and candidate assessment.

Table Specific Information

Select

The Workday add-in 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 language with the specified ID for the specified prospect.

Secured by: Prospects

Scope: Recruiting, Talent Pipeline

Aggregate Fields

The add-in 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 /* A description 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 /* A description 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

A textual representation of the language, such as its name, classification, or additional metadata that helps describe the entry.

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.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434