ODBC Driver for Workday

Build 25.0.9434

Scorecards

Manages compensation scorecard data for performance-based evaluations.

Workday Resource Information

Retrieves Compensation Scorecard information including the scorecardName, scorecardDescription, inactive status, defaultScorecardGoals, scorecardProfiles containing profileScorecardGoals as of the effective date. The default effective date is the request date.

Secured by: Set Up: Merit and Bonus

Scope: Advanced Compensation

Aggregate Fields

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

DefaultScorecardGoals_Aggregate


[{
  goalDescription: Text /* The description of the Compensation Scorecard Goal */
 *goalName: Text /* The name of the Compensation Scorecard Goal. */
 *goalWeight: Numeric /* The weight given to the Compensation Scorecard Goal. [90% will be displayed as 0.9] */
  id: Text /* Id of the instance */
}]

ScorecardProfiles_Aggregate


[{
 *eligibilityRule: { /* The name of the Compensation Eligibility Rule assigned to the Compensation Scorecard Profile. */
     -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 */
 *profileScorecardGoals: [{
      goalDescription: Text /* The description of the Compensation Scorecard Goal */
     *goalName: Text /* The name of the Compensation Scorecard Goal. */
     *goalWeight: Numeric /* The weight given to the Compensation Scorecard Goal. [90% will be displayed as 0.9] */
      id: Text /* Id of the instance */
  }]
}]

Columns

Name Type ReadOnly Description
Id [KEY] String False

Unique identifier for this instance.

DefaultScorecardGoals_Aggregate String False

A collection of goals associated with the Compensation Scorecard.

EffectiveDate Datetime False

The date the Compensation Scorecard becomes effective, formatted as YYYY-MM-DD.

Inactive Bool False

Indicates whether the scorecard is inactive (true) or active (false).

ScorecardDescription String False

A detailed description of the Compensation Scorecard.

ScorecardName String False

The name assigned to the Compensation Scorecard.

ScorecardProfiles_Aggregate String False

A collection of profiles associated with the Compensation Scorecard.

EffectiveDate_Prompt Date False

Reference prompt indicating the effective date of the scorecard task.

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