ODBC Driver for Workday

Build 24.0.9060

Scorecards

Retrieves Compensation Scorecard information.

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.

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

Id of the instance

DefaultScorecardGoals_Aggregate String False

Supported for: INSERT. A JSON aggregate. The goals for the Compensation Scorecard.

EffectiveDate Datetime False

Supported for: SELECT, INSERT, UPDATE. The Effective Date of the Compensation Scorecard in format YYYY-MM-DD.

Inactive Bool False

Supported for: SELECT, INSERT, UPDATE. Indicates whether the Scorecard is inactive using a value of true/false.

ScorecardDescription String False

Supported for: SELECT, INSERT, UPDATE. The description of the Compensation Scorecard.

ScorecardName String False

Supported for: SELECT, INSERT, UPDATE. The name of the Compensation Scorecard.

ScorecardProfiles_Aggregate String False

Supported for: INSERT. A JSON aggregate. The profiles for the Compensation Scorecard.

EffectiveDate_Prompt Date False

Effective date the scorecard task takes effect.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060