ODBC Driver for Workday

Build 25.0.9434

allJobProfiles

Accesses Job Profile as the primary object and returns one row per job profile. Includes all active and inactive job profiles. Does not contain built-in prompts.

Columns

Name Type References Description
cf_JobProfileDegrees String Lists the educational degrees typically associated with this job profile.
cf_CompensationSurvey String Indicates whether this job profile is included in a compensation survey.
cf_JobEvaluationScore String Score assigned to the job profile based on evaluation metrics.
classOfInstance1_id String Unique identifier for the class of the job profile instance.
classOfInstance1_descriptor String Human-readable label for the class of the job profile instance.
cf_countriesWherePayRateTypeEqualToSalaried String Lists the countries where the job profile follows a salaried pay rate type.
cf_countriesWherePayRateTypeEqualToHourly String Lists the countries where the job profile follows an hourly pay rate type.
cf_CompensationGroup_id String Unique identifier for the compensation group associated with the job profile.
cf_CompensationGroup_descriptor String Descriptive label for the compensation group linked to this job profile.
jobProfileName String The official name assigned to the job profile.
jobFamilyGroupAndFamily String Lists all job families and groups associated with this job profile.
jobProfileSummary String A brief summary describing the job profile.
jobProfile_id String Unique identifier for the job profile.
jobProfile_descriptor String Descriptive label for the job profile.
jobClassifications String Lists the job classifications applicable to this job profile.
managementLevel_id String Unique identifier for the management level associated with this job profile.
managementLevel_descriptor String Descriptive label for the management level.
ID String General identifier used for tracking the job profile.
compensationGradesImpactedByRules String Lists the compensation grades affected by rules for this job profile.
jobExempt Bool Indicates whether this job profile is exempt from overtime regulations (True/False).
averagePay_Amount_value Decimal The average pay amount associated with this job profile.
averagePay_Amount_currency String The currency in which the average pay amount is measured.
employeeCount Int The total number of employees assigned to this job profile.
highestPay_Amount_value Decimal The highest pay amount recorded for this job profile.
highestPay_Amount_currency String The currency in which the highest pay amount is measured.
lowestPay_Amount_value Decimal The lowest pay amount recorded for this job profile.
lowestPay_Amount_currency String The currency in which the lowest pay amount is measured.
effectiveAsOfDate Date A pseudo-column used to filter data based on the effective date of the job profile.
effectiveAsOfMoment Datetime A pseudo-column used to filter data based on the exact timestamp of the job profile's effectiveness.
entryDate Date A pseudo-column used to filter data based on the date the job profile entry was recorded.
entryMoment Datetime A pseudo-column used to filter data based on the exact timestamp of when the job profile entry was recorded.

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