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 |