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 | Job Profile Degrees | |
cf_CompensationSurvey | String | Compensation Survey | |
cf_JobEvaluationScore | String | Job Evaluation Score | |
classOfInstance1_id | String | Class of Instance id | |
classOfInstance1_descriptor | String | Class of Instance descriptor | |
cf_countriesWherePayRateTypeEqualToSalaried | String | Countries where Pay Rate Type = Salaried | |
cf_countriesWherePayRateTypeEqualToHourly | String | Countries where Pay Rate Type = Hourly | |
cf_CompensationGroup_id | String | Compensation Group id | |
cf_CompensationGroup_descriptor | String | Compensation Group descriptor | |
jobProfileName | String | Job Profile Name | |
jobFamilyGroupAndFamily | String | All Job Families and Groups for Job Profile | |
jobProfileSummary | String | Job Profile Summary | |
jobProfile_id | String | Job Profile id | |
jobProfile_descriptor | String | Job Profile descriptor | |
jobClassifications | String | Job Classifications | |
managementLevel_id | String | Management Level id | |
managementLevel_descriptor | String | Management Level descriptor | |
ID | String | ID | |
compensationGradesImpactedByRules | String | Compensation Grades impacted by rules | |
jobExempt | Bool | Job Exempt | |
averagePay_Amount_value | Decimal | Average Pay - Amount value | |
averagePay_Amount_currency | String | Average Pay - Amount currency | |
employeeCount | Int | Employee Count | |
highestPay_Amount_value | Decimal | Highest Pay - Amount value | |
highestPay_Amount_currency | String | Highest Pay - Amount currency | |
lowestPay_Amount_value | Decimal | Lowest Pay - Amount value | |
lowestPay_Amount_currency | String | Lowest Pay - Amount currency | |
effectiveAsOfDate | Date | Pseudo-column used to filter the data source | |
effectiveAsOfMoment | Datetime | Pseudo-column used to filter the data source | |
entryDate | Date | Pseudo-column used to filter the data source | |
entryMoment | Datetime | Pseudo-column used to filter the data source |