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. |