Workday Connector Objects (wql Schema)
| Name | Description |
|---|---|
| allAllowancePlans | Accesses the Allowance Plan as the primary object and returns one row per plan. Includes all allowance plans. Does not contain built-in prompts. This data source delivers the additions and removals for plans over time. |
| allBonusPlans | Accesses the Bonus Plan as the primary object and returns one row per bonus plan. Includes all active bonus plans. Does not contain built-in prompts. The data source delivers the additions and removals for bonus plans over time. |
| allCompensationPlans | Accesses the Compensation Plan as the primary object and returns one row per plan. Includes all active plans. Does not contain built-in prompts. This data source delivers the additions and removals for plans over time. |
| allCompensationRuleAssignments | Accesses the Compensation Rule as its primary object. The Compensation Rule object returns one row per Compensation Rule. Includes all Compensation Rules. Does not contain any built-in prompts. |
| 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. |
| allMeritPlans | Accesses the Merit Plan as the primary object and returns one row per plan. Includes all active and inactive plans. Does not contain any built-in prompts. The data source delivers the additions and removals for plans over time. |
| allOpenPositions | Accesses the Position as its primary object. The Position object returns one row per position. Includes only open positions that are in supervisory organizations that the user has access. Does not contain any built-in prompts. |
| allPreHires | Accesses Pre-Hire as the primary object and returns one row per pre-hire. Includes all pre-hires as well as pre-hires converted to hires. Does not contain built-in prompts. |
| allWorkdayAccounts | Accesses the Workday Account object and returns one row per Workday account. Includes all Workday accounts ever created, either currently enabled or not. Does not contain built-in prompts. This data source will show settings of the user login information and preferences in Workday. |
| allWorkers | Accesses the Worker as its primary object and returns one row per worker. Includes all workers even workers to be hired in the future. Does not contain any built-in prompts. This data source can be used to build reports on all workers. Helpful Tips - 1) If the worker is hired in the future, all fields will be returned based on the effective date. 2) If no effective date is specified, the system will use the current date as the effective date. 3) If the effective date is less than the worker's hire date, no effective dated information (such as position information, compensation information and so on) will be returned. 4) If effective dated behavior is desired, use the "All Active and Terminated workers" data source instead. |
| classes | Returns all classes accessible by the current user |
| organizationsIManage | Accesses the Organization as its primary object. The Organization object returns one row per organization. Only includes supervisory organizations that the user manages. Prompts the user at run-time for Supervisory Organization to automatically filter the report results. |
| positionsValidForCompensationSelectionRule | Accesses the Position Group as its primary object. The Position Group object returns one row per Position Group. Includes all unfilled and filled Positions. Prompts the user at run-time for a Compensation Rule to automatically filter the report results. |
| topLevelOrganizations | Accesses the Organization object and returns one row per organization. Includes all active and inactive organizations with no superior. Does not contain built-in prompts. |
| topLevelOrganizationsAndSubordinates | Accesses the Organization as its primary object. The Organization object returns one row per organization. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| classOfInstance1_id | String | False | No | Unique identifier for the class of the compensation plan instance. | |
| classOfInstance1_descriptor | String | False | No | Human-readable label for the class of the compensation plan instance. | |
| cf_CompensationPlanEqualToHourly | Bool | False | No | Indicates whether the compensation plan is categorized as an hourly wage plan (True/False). | |
| cf_FrequencyForCompensationPlan_id | String | False | No | Unique identifier for the frequency of the compensation plan (e.g., weekly, bi-weekly, monthly). | |
| cf_FrequencyForCompensationPlan_descriptor | String | False | No | Descriptive name for the frequency of the compensation plan. | |
| cf_CompensationPlanEqualToAllowance | Bool | False | No | Indicates whether the compensation plan includes allowances (True/False). | |
| cf_CompensationPlanEqualToBonus | Bool | False | No | Indicates whether the compensation plan includes bonuses (True/False). | |
| cf_CompensationPlanTypeEqualToMerit | Bool | False | No | Indicates whether the compensation plan is classified as a merit-based plan (True/False). | |
| cf_CompensationPlanEqualToCommission | Bool | False | No | Indicates whether the compensation plan includes commission-based payments (True/False). | |
| cf_CompensationPlanEqualToStock | Bool | False | No | Indicates whether the compensation plan includes stock-based compensation (True/False). | |
| cf_CompensationPlanEqualToSalaryPlanUnitPeriodOrSalary | Bool | False | No | Indicates whether the compensation plan is structured as a salary plan, defined by unit, period, or a fixed salary (True/False). | |
| compensationPlanName | String | False | No | The official name assigned to the compensation plan. | |
| description | String | False | No | A general description of the compensation plan. | |
| compensationPlanDefaults_id | String | False | No | Unique identifier for the default settings associated with the compensation plan. | |
| compensationPlanDefaults_descriptor | String | False | No | Human-readable description of the default settings for the compensation plan. | |
| compensationPlanProcessHistory | String | False | No | Records and tracks historical changes made to the compensation plan. | |
| compensationPackages | String | False | No | Lists the different compensation packages associated with the plan. | |
| eligibilityRules | String | False | No | Defines the rules that determine employee eligibility for the compensation plan. | |
| compensationPlan_id | String | False | No | Unique identifier for the specific compensation plan. | |
| compensationPlan_descriptor | String | False | No | Descriptive label for the compensation plan. | |
| positionsInCompensationPlan | String | False | No | Lists the job positions that fall under this compensation plan. | |
| employeesInCompensationPlan | String | False | No | Lists employees enrolled in this compensation plan. | |
| calculationType_id | String | False | No | Unique identifier for the calculation method used in the compensation plan. | |
| calculationType_descriptor | String | False | No | Descriptive label for the calculation method applied to the compensation plan. | |
| calculation_id | String | False | No | Unique identifier for the specific calculation associated with the compensation plan. | |
| calculation_descriptor | String | False | No | Descriptive label for the specific calculation applied within the compensation plan. | |
| effectiveAsOfDate | Date | False | No | A pseudo-column used to filter data based on the effective date of the compensation plan. | |
| effectiveAsOfMoment | Datetime | False | No | A pseudo-column used to filter data based on the exact timestamp of the compensation plan's effectiveness. | |
| entryDate | Date | False | No | A pseudo-column used to filter data based on the date the compensation plan entry was recorded. | |
| entryMoment | Datetime | False | No | A pseudo-column used to filter data based on the exact timestamp of when the compensation plan entry was recorded. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| classOfInstance1_id | String | False | No | Unique identifier for the class of the compensation plan instance. | |
| classOfInstance1_descriptor | String | False | No | Human-readable label for the class of the compensation plan instance. | |
| cf_CompensationPlanEqualToHourly | Bool | False | No | Indicates whether the compensation plan is categorized as an hourly wage plan (True/False). | |
| cf_FrequencyForCompensationPlan_id | String | False | No | Unique identifier for the frequency of the compensation plan (e.g., weekly, bi-weekly, monthly). | |
| cf_FrequencyForCompensationPlan_descriptor | String | False | No | Descriptive name for the frequency of the compensation plan. | |
| cf_CompensationPlanEqualToAllowance | Bool | False | No | Indicates whether the compensation plan includes allowances (True/False). | |
| cf_CompensationPlanEqualToBonus | Bool | False | No | Indicates whether the compensation plan includes bonuses (True/False). | |
| cf_CompensationPlanTypeEqualToMerit | Bool | False | No | Indicates whether the compensation plan is classified as a merit-based plan (True/False). | |
| cf_CompensationPlanEqualToCommission | Bool | False | No | Indicates whether the compensation plan includes commission-based payments (True/False). | |
| cf_CompensationPlanEqualToStock | Bool | False | No | Indicates whether the compensation plan includes stock-based compensation (True/False). | |
| cf_CompensationPlanEqualToSalaryPlanUnitPeriodOrSalary | Bool | False | No | Indicates whether the compensation plan is structured as a salary plan, defined by unit, period, or a fixed salary (True/False). | |
| compensationPlanName | String | False | No | The official name assigned to the compensation plan. | |
| description | String | False | No | A general description of the compensation plan. | |
| compensationPlanDefaults_id | String | False | No | Unique identifier for the default settings associated with the compensation plan. | |
| compensationPlanDefaults_descriptor | String | False | No | Human-readable description of the default settings for the compensation plan. | |
| compensationPlanProcessHistory | String | False | No | Records and tracks historical changes made to the compensation plan. | |
| compensationPackages | String | False | No | Lists the different compensation packages associated with the plan. | |
| eligibilityRules | String | False | No | Defines the rules that determine employee eligibility for the compensation plan. | |
| compensationPlan_id | String | False | No | Unique identifier for the specific compensation plan. | |
| compensationPlan_descriptor | String | False | No | Descriptive label for the compensation plan. | |
| positionsInCompensationPlan | String | False | No | Lists the job positions that fall under this compensation plan. | |
| employeesInCompensationPlan | String | False | No | Lists employees enrolled in this compensation plan. | |
| calculationType_id | String | False | No | Unique identifier for the calculation method used in the compensation plan. | |
| calculationType_descriptor | String | False | No | Descriptive label for the calculation method applied to the compensation plan. | |
| calculation_id | String | False | No | Unique identifier for the specific calculation associated with the compensation plan. | |
| calculation_descriptor | String | False | No | Descriptive label for the specific calculation applied within the compensation plan. | |
| effectiveAsOfDate | Date | False | No | A pseudo-column used to filter data based on the effective date of the compensation plan. | |
| effectiveAsOfMoment | Datetime | False | No | A pseudo-column used to filter data based on the exact timestamp of the compensation plan's effectiveness. | |
| entryDate | Date | False | No | A pseudo-column used to filter data based on the date the compensation plan entry was recorded. | |
| entryMoment | Datetime | False | No | A pseudo-column used to filter data based on the exact timestamp of when the compensation plan entry was recorded. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| classOfInstance1_id | String | False | No | Unique identifier for the class of the compensation plan instance. | |
| classOfInstance1_descriptor | String | False | No | Human-readable label for the class of the compensation plan instance. | |
| cf_CompensationPlanEqualToHourly | Bool | False | No | Indicates whether the compensation plan is categorized as an hourly wage plan (True/False). | |
| cf_FrequencyForCompensationPlan_id | String | False | No | Unique identifier for the frequency of the compensation plan (e.g., weekly, bi-weekly, monthly). | |
| cf_FrequencyForCompensationPlan_descriptor | String | False | No | Descriptive name for the frequency of the compensation plan. | |
| cf_CompensationPlanEqualToAllowance | Bool | False | No | Indicates whether the compensation plan includes allowances (True/False). | |
| cf_CompensationPlanEqualToBonus | Bool | False | No | Indicates whether the compensation plan includes bonuses (True/False). | |
| cf_CompensationPlanTypeEqualToMerit | Bool | False | No | Indicates whether the compensation plan is classified as a merit-based plan (True/False). | |
| cf_CompensationPlanEqualToCommission | Bool | False | No | Indicates whether the compensation plan includes commission-based payments (True/False). | |
| cf_CompensationPlanEqualToStock | Bool | False | No | Indicates whether the compensation plan includes stock-based compensation (True/False). | |
| cf_CompensationPlanEqualToSalaryPlanUnitPeriodOrSalary | Bool | False | No | Indicates whether the compensation plan is structured as a salary plan, defined by unit, period, or a fixed salary (True/False). | |
| compensationPlanName | String | False | No | The official name assigned to the compensation plan. | |
| description | String | False | No | A general description of the compensation plan. | |
| compensationPlanDefaults_id | String | False | No | Unique identifier for the default settings associated with the compensation plan. | |
| compensationPlanDefaults_descriptor | String | False | No | Human-readable description of the default settings for the compensation plan. | |
| compensationPlanProcessHistory | String | False | No | Records and tracks historical changes made to the compensation plan. | |
| compensationPackages | String | False | No | Lists the different compensation packages associated with the plan. | |
| eligibilityRules | String | False | No | Defines the rules that determine employee eligibility for the compensation plan. | |
| compensationPlan_id | String | False | No | Unique identifier for the specific compensation plan. | |
| compensationPlan_descriptor | String | False | No | Descriptive label for the compensation plan. | |
| positionsInCompensationPlan | String | False | No | Lists the job positions that fall under this compensation plan. | |
| employeesInCompensationPlan | String | False | No | Lists employees enrolled in this compensation plan. | |
| workdayID | String | False | No | Unique identifier assigned to the compensation plan within the Workday system. | |
| referenceID1 | String | False | No | Reference identifier used to track the compensation plan in external systems. | |
| effectiveAsOfDate | Date | False | No | A pseudo-column used to filter data based on the effective date of the compensation plan. | |
| effectiveAsOfMoment | Datetime | False | No | A pseudo-column used to filter data based on the exact timestamp of the compensation plan's effectiveness. | |
| entryDate | Date | False | No | A pseudo-column used to filter data based on the date the compensation plan entry was recorded. | |
| entryMoment | Datetime | False | No | A pseudo-column used to filter data based on the exact timestamp of when the compensation plan entry was recorded. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| classOfInstance1_id | String | False | No | Unique identifier for the class of the compensation rule assignment instance. | |
| classOfInstance1_descriptor | String | False | No | Human-readable label for the class of the compensation rule assignment instance. | |
| positionsAndPositionGroupsSelectedByCompensationRule | String | False | No | Lists the positions and position groups that are selected by the compensation rule. | |
| compensationRuleName | String | False | No | The official name assigned to the compensation rule. | |
| compensationRuleAssignment_id | String | False | No | Unique identifier for the compensation rule assignment. | |
| compensationRuleAssignment_descriptor | String | False | No | Descriptive label for the compensation rule assignment. | |
| compensationComponents | String | False | No | Lists the compensation components associated with this rule assignment. | |
| employeesSelectedByCompensationRule | String | False | No | Lists employees selected by the compensation rule. | |
| compensationGradeProfiles | String | False | No | Lists the compensation grade profiles associated with this rule assignment. | |
| compensationGrades | String | False | No | Lists the compensation grades applicable to this rule assignment. | |
| compensationPlans | String | False | No | Lists the compensation plans covered by this rule assignment. | |
| compensationPackages | String | False | No | Lists the compensation packages included in this rule assignment. | |
| workdayID | String | False | No | Unique identifier assigned to the compensation rule assignment within the Workday system. | |
| compensationEligibilityRule_id | String | False | No | Unique identifier for the compensation eligibility rule. | |
| compensationEligibilityRule_descriptor | String | False | No | Descriptive label for the compensation eligibility rule. | |
| referenceID | String | False | No | Reference identifier used to track the compensation rule assignment in external systems. | |
| createdMoment | Date | False | No | Timestamp indicating when the compensation rule assignment was created. | |
| lastFunctionallyUpdated | Date | False | No | Date when the compensation rule assignment was last functionally updated. | |
| currentOMSVersion_id | String | False | No | Unique identifier for the current version of the OMS (Order Management System) linked to this compensation rule assignment. | |
| currentOMSVersion_descriptor | String | False | No | Descriptive label for the current version of the OMS associated with this compensation rule assignment. | |
| effectiveAsOfDate | Date | False | No | A pseudo-column used to filter data based on the effective date of the compensation rule assignment. | |
| effectiveAsOfMoment | Datetime | False | No | A pseudo-column used to filter data based on the exact timestamp of the compensation rule assignment's effectiveness. | |
| entryDate | Date | False | No | A pseudo-column used to filter data based on the date the compensation rule assignment entry was recorded. | |
| entryMoment | Datetime | False | No | A pseudo-column used to filter data based on the exact timestamp of when the compensation rule assignment entry was recorded. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| cf_JobProfileDegrees | String | False | No | Lists the educational degrees typically associated with this job profile. | |
| cf_CompensationSurvey | String | False | No | Indicates whether this job profile is included in a compensation survey. | |
| cf_JobEvaluationScore | String | False | No | Score assigned to the job profile based on evaluation metrics. | |
| classOfInstance1_id | String | False | No | Unique identifier for the class of the job profile instance. | |
| classOfInstance1_descriptor | String | False | No | Human-readable label for the class of the job profile instance. | |
| cf_countriesWherePayRateTypeEqualToSalaried | String | False | No | Lists the countries where the job profile follows a salaried pay rate type. | |
| cf_countriesWherePayRateTypeEqualToHourly | String | False | No | Lists the countries where the job profile follows an hourly pay rate type. | |
| cf_CompensationGroup_id | String | False | No | Unique identifier for the compensation group associated with the job profile. | |
| cf_CompensationGroup_descriptor | String | False | No | Descriptive label for the compensation group linked to this job profile. | |
| jobProfileName | String | False | No | The official name assigned to the job profile. | |
| jobFamilyGroupAndFamily | String | False | No | Lists all job families and groups associated with this job profile. | |
| jobProfileSummary | String | False | No | A brief summary describing the job profile. | |
| jobProfile_id | String | False | No | Unique identifier for the job profile. | |
| jobProfile_descriptor | String | False | No | Descriptive label for the job profile. | |
| jobClassifications | String | False | No | Lists the job classifications applicable to this job profile. | |
| managementLevel_id | String | False | No | Unique identifier for the management level associated with this job profile. | |
| managementLevel_descriptor | String | False | No | Descriptive label for the management level. | |
| ID | String | False | No | General identifier used for tracking the job profile. | |
| compensationGradesImpactedByRules | String | False | No | Lists the compensation grades affected by rules for this job profile. | |
| jobExempt | Bool | False | No | Indicates whether this job profile is exempt from overtime regulations (True/False). | |
| averagePay_Amount_value | Decimal | False | No | The average pay amount associated with this job profile. | |
| averagePay_Amount_currency | String | False | No | The currency in which the average pay amount is measured. | |
| employeeCount | Int | False | No | The total number of employees assigned to this job profile. | |
| highestPay_Amount_value | Decimal | False | No | The highest pay amount recorded for this job profile. | |
| highestPay_Amount_currency | String | False | No | The currency in which the highest pay amount is measured. | |
| lowestPay_Amount_value | Decimal | False | No | The lowest pay amount recorded for this job profile. | |
| lowestPay_Amount_currency | String | False | No | The currency in which the lowest pay amount is measured. | |
| effectiveAsOfDate | Date | False | No | A pseudo-column used to filter data based on the effective date of the job profile. | |
| effectiveAsOfMoment | Datetime | False | No | A pseudo-column used to filter data based on the exact timestamp of the job profile's effectiveness. | |
| entryDate | Date | False | No | A pseudo-column used to filter data based on the date the job profile entry was recorded. | |
| entryMoment | Datetime | False | No | A pseudo-column used to filter data based on the exact timestamp of when the job profile entry was recorded. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| classOfInstance1_id | String | False | No | Unique identifier for the class of the compensation plan instance. | |
| classOfInstance1_descriptor | String | False | No | Human-readable label for the class of the compensation plan instance. | |
| cf_CompensationPlanEqualToHourly | Bool | False | No | Indicates whether the compensation plan is categorized as an hourly wage plan (True/False). | |
| cf_FrequencyForCompensationPlan_id | String | False | No | Unique identifier for the frequency of the compensation plan (e.g., weekly, bi-weekly, monthly). | |
| cf_FrequencyForCompensationPlan_descriptor | String | False | No | Descriptive name for the frequency of the compensation plan. | |
| cf_CompensationPlanEqualToAllowance | Bool | False | No | Indicates whether the compensation plan includes allowances (True/False). | |
| cf_CompensationPlanEqualToBonus | Bool | False | No | Indicates whether the compensation plan includes bonuses (True/False). | |
| cf_CompensationPlanTypeEqualToMerit | Bool | False | No | Indicates whether the compensation plan is classified as a merit-based plan (True/False). | |
| cf_CompensationPlanEqualToCommission | Bool | False | No | Indicates whether the compensation plan includes commission-based payments (True/False). | |
| cf_CompensationPlanEqualToStock | Bool | False | No | Indicates whether the compensation plan includes stock-based compensation (True/False). | |
| cf_CompensationPlanEqualToSalaryPlanUnitPeriodOrSalary | Bool | False | No | Indicates whether the compensation plan is structured as a salary plan, defined by unit, period, or a fixed salary (True/False). | |
| compensationPlanName | String | False | No | The official name assigned to the compensation plan. | |
| description | String | False | No | A general description of the compensation plan. | |
| compensationPlanDefaults_id | String | False | No | Unique identifier for the default settings associated with the compensation plan. | |
| compensationPlanDefaults_descriptor | String | False | No | Human-readable description of the default settings for the compensation plan. | |
| compensationPlanProcessHistory | String | False | No | Records and tracks historical changes made to the compensation plan. | |
| compensationPackages | String | False | No | Lists the different compensation packages associated with the plan. | |
| eligibilityRules | String | False | No | Defines the rules that determine employee eligibility for the compensation plan. | |
| compensationPlan_id | String | False | No | Unique identifier for the specific compensation plan. | |
| compensationPlan_descriptor | String | False | No | Descriptive label for the compensation plan. | |
| positionsInCompensationPlan | String | False | No | Lists the job positions that fall under this compensation plan. | |
| employeesInCompensationPlan | String | False | No | Lists employees enrolled in this compensation plan. | |
| workdayID | String | False | No | Unique identifier assigned to the compensation plan within the Workday system. | |
| referenceID1 | String | False | No | Reference identifier used to track the compensation plan in external systems. | |
| effectiveAsOfDate | Date | False | No | A pseudo-column used to filter data based on the effective date of the compensation plan. | |
| effectiveAsOfMoment | Datetime | False | No | A pseudo-column used to filter data based on the exact timestamp of the compensation plan's effectiveness. | |
| entryDate | Date | False | No | A pseudo-column used to filter data based on the date the compensation plan entry was recorded. | |
| entryMoment | Datetime | False | No | A pseudo-column used to filter data based on the exact timestamp of when the compensation plan entry was recorded. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| cf_SupervisoryOrganizationHierarchy_id | String | False | No | Unique identifier for the supervisory organization hierarchy. | |
| cf_SupervisoryOrganizationHierarchy_descriptor | String | False | No | Descriptive label for the supervisory organization hierarchy. | |
| cf_EarliestHireDate_Quarter | String | False | No | The earliest hire date categorized by quarter. | |
| cf_MonthsFromEarliestHireDate | Int | False | No | Number of months that have passed since the earliest hire date. | |
| cf_TimeToFill1 | Int | False | No | Number of days required to fill an open position. | |
| cf_OpenPositionCountAtEndOfLastQuarter | Int | False | No | Total number of open positions at the end of the last quarter. | |
| cf_ExecutiveGroup1_id | String | False | No | Unique identifier for the executive group. | |
| cf_ExecutiveGroup1_descriptor | String | False | No | Descriptive label for the executive group. | |
| cf_AnnualPositionBurdenInUSD1_value | Decimal | False | No | Annual cost associated with a position, expressed in USD. | |
| cf_AnnualPositionBurdenInUSD1_currency | String | False | No | Currency used for the annual position burden amount. | |
| cf_DaysFromEarliestHireDate | Int | False | No | Number of days that have passed since the earliest hire date. | |
| cf_NumberOfMonthsPositionUnfilled | Int | False | No | Number of months a position has remained unfilled. | |
| cf_PositionCount_Frozen | Int | False | No | Number of positions that are currently frozen. | |
| cf_AnnualPositionBurdenInUSDOpenPositionsOnly_value | Decimal | False | No | Annual position burden in USD for open positions only. | |
| cf_AnnualPositionBurdenInUSDOpenPositionsOnly_currency | String | False | No | Currency used for the annual position burden of open positions. | |
| cf_IsPositionOpenAndEarliestHireDateCurrent | Bool | False | No | Indicates whether the position is open and the earliest hire date is current (True/False). | |
| cf_EarliestHireDate9Months1 | Date | False | No | Earliest hire date plus nine months. | |
| cf_CompensationRangeMidpointInUSD_value | Decimal | False | No | Midpoint value of the compensation range, expressed in USD. | |
| cf_CompensationRangeMidpointInUSD_currency | String | False | No | Currency used for the compensation range midpoint. | |
| cf_EarliestHireDate6Months1 | Date | False | No | Earliest hire date plus six months. | |
| cf_OpenPositionCount_GAndA | Int | False | No | Total number of open positions in General and Administrative (G and A) departments. | |
| cf_TimeInPositionRange_id | String | False | No | Unique identifier for the time in position range. | |
| cf_TimeInPositionRange_descriptor | String | False | No | Descriptive label for the time in position range. | |
| cf_IsInGAndA | Bool | False | No | Indicates whether the position falls under General and Administrative (G and A) (True/False). | |
| cf_AvailableYearQuarter | String | False | No | The year and quarter when the position became available. | |
| cf_EarliestHireDate3Months1 | Date | False | No | Earliest hire date plus three months. | |
| effectiveAsOfDate | Date | False | No | A pseudo-column used to filter data based on the effective date of the open position. | |
| effectiveAsOfMoment | Datetime | False | No | A pseudo-column used to filter data based on the exact timestamp of the open position's effectiveness. | |
| entryDate | Date | False | No | A pseudo-column used to filter data based on the date the open position entry was recorded. | |
| entryMoment | Datetime | False | No | A pseudo-column used to filter data based on the exact timestamp of when the open position entry was recorded. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| classOfInstance1_id | String | False | No | Unique identifier for the class of the pre-hire instance. | |
| classOfInstance1_descriptor | String | False | No | Human-readable label for the class of the pre-hire instance. | |
| cf_WorkerCountryISOCodeOnExpensePayee | String | False | No | ISO country code associated with the pre-hire's expense payee information. | |
| pre_Hire_id | String | False | No | Unique identifier for the pre-hire record. | |
| pre_Hire_descriptor | String | False | No | Descriptive label for the pre-hire record. | |
| source_id | String | False | No | Unique identifier for the source from which the pre-hire originated. | |
| source_descriptor | String | False | No | Descriptive label for the source of the pre-hire. | |
| referredBy | String | False | No | The individual or entity that referred the pre-hire. | |
| pre_HirePools | String | False | No | Lists the pools or groups that the pre-hire is associated with. | |
| datePre_HireAddedToSystem | Date | False | No | The date when the pre-hire record was added to the system. | |
| notEligibleForHireComment | String | False | No | Comment explaining why the pre-hire is not eligible for hire. | |
| comment | String | False | No | General comments related to the pre-hire. | |
| resume | String | False | No | Stores the resume or CV associated with the pre-hire. | |
| pre_HireConsideration | String | False | No | Additional considerations relevant to the pre-hire process. | |
| availableForHire | Bool | False | No | Indicates whether the pre-hire is currently available for hire (True/False). | |
| roleName | String | False | No | The role assigned to the pre-hire within the organization. | |
| email_Primary | String | False | No | Primary email address of the pre-hire. | |
| phone_Primary | String | False | No | Primary phone number of the pre-hire. | |
| organizationRoleAssignments | String | False | No | Lists the organization roles assigned to the pre-hire. | |
| integrationIdentifier | String | False | No | Unique identifier used for integration purposes. | |
| organizationRoles | String | False | No | Roles assigned to the pre-hire within the organization. | |
| externalIDForSystemID | String | False | No | External system ID associated with the pre-hire record. | |
| raceEthnicity_id | String | False | No | Unique identifier for the race/ethnicity classification of the pre-hire. | |
| raceEthnicity_descriptor | String | False | No | Descriptive label for the race/ethnicity classification. | |
| effectiveAsOfDate | Date | False | No | A pseudo-column used to filter data based on the effective date of the pre-hire. | |
| effectiveAsOfMoment | Datetime | False | No | A pseudo-column used to filter data based on the exact timestamp of the pre-hire's effectiveness. | |
| entryDate | Date | False | No | A pseudo-column used to filter data based on the date the pre-hire entry was recorded. | |
| entryMoment | Datetime | False | No | A pseudo-column used to filter data based on the exact timestamp of when the pre-hire entry was recorded. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| forUnitTestingMulti | String | False | No | Used for multi-instance unit testing purposes. | |
| cf_ClickableAddedRoleAssignments | String | False | No | Lists role assignments that have been added and can be clicked for more details. | |
| cf_ClickableRemovedRoleAssignments | String | False | No | Lists role assignments that have been removed and can be clicked for more details. | |
| cf_SecurityGroupsWithAccessToSettlePayments_Payroll | String | False | No | Security groups that have access to settle payroll payments. | |
| cf_SecurityGroupsWithAccessToInputEditOrProcessPayroll | String | False | No | Security groups with access to input, edit, or process payroll data. | |
| cf_SecurityGroupsWithAccessToRefundCustomers | String | False | No | Security groups that have access to issue refunds to customers. | |
| cf_SecurityGroupsWithAccessToCreateModifyCustomers | String | False | No | Security groups that can create or modify customer records. | |
| cf_ReportsAndTasks_View | String | False | No | Lists reports and tasks that users have permission to view. | |
| cf_SecurityGroupsWithAccessToCreateModifySuppliers | String | False | No | Security groups that can create or modify supplier records. | |
| cf_ReportsAndTasks_Modify | String | False | No | Lists reports and tasks that users have permission to modify. | |
| cf_SecurityGroupsWithAccessToCreateEditSupplierInvoices | String | False | No | Security groups that have access to create or edit supplier invoices. | |
| cf_BusinessProcessPolicy_Approve | String | False | No | Indicates whether the business process policy includes approval permissions. | |
| cf_BusinessProcessPolicy_Cancel | String | False | No | Indicates whether the business process policy includes cancellation permissions. | |
| cf_SecurityGroupsWithAccessToSettlePayments_Suppliers | String | False | No | Security groups that have access to settle supplier payments. | |
| cf_BusinessProcessPolicy_Rescind | String | False | No | Indicates whether the business process policy includes rescind permissions. | |
| cf_SecurityGroupsWithAccessToCreateModifyExpenseReports | String | False | No | Security groups that have access to create or modify expense reports. | |
| cf_BusinessProcessPolicy_Initiate | String | False | No | Indicates whether the business process policy includes initiation permissions. | |
| cf_SecurityGroupsWithAccessToSettlePayments_Expenses | String | False | No | Security groups that have access to settle expense payments. | |
| cf_BusinessProcessPolicy_View | String | False | No | Indicates whether the business process policy includes viewing permissions. | |
| cf_BusinessProcessPolicy_ViewCompleted | String | False | No | Indicates whether the business process policy includes permissions to view completed processes. | |
| effectiveAsOfDate | Date | False | No | A pseudo-column used to filter data based on the effective date of the Workday account. | |
| effectiveAsOfMoment | Datetime | False | No | A pseudo-column used to filter data based on the exact timestamp of the Workday account's effectiveness. | |
| entryDate | Date | False | No | A pseudo-column used to filter data based on the date the Workday account entry was recorded. | |
| entryMoment | Datetime | False | No | A pseudo-column used to filter data based on the exact timestamp of when the Workday account entry was recorded. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| cf_ContractPayRateAnnualized_value | Decimal | False | No | Annualized pay rate for contract workers, expressed as a numerical value. | |
| cf_ContractPayRateAnnualized_currency | String | False | No | Currency in which the contract pay rate annualized value is measured. | |
| cf_NumberOfTerminations | Int | False | No | Total number of terminations recorded for the worker. | |
| cf_DisciplinaryActions_Completed | String | False | No | List of completed disciplinary actions for the worker. | |
| cf_RetirementEligibility_id | String | False | No | Unique identifier for the worker's retirement eligibility classification. | |
| cf_RetirementEligibility_descriptor | String | False | No | Descriptive label for the worker's retirement eligibility classification. | |
| cf_LocationSiteHierarchyLevel2_id | String | False | No | Unique identifier for the Level 2 location site hierarchy. | |
| cf_LocationSiteHierarchyLevel2_descriptor | String | False | No | Descriptive label for the Level 2 location site hierarchy. | |
| cf_TotalBasePayAnnualizedInCAD_Amount_value | Decimal | False | No | Total base pay annualized in CAD, expressed as a numerical value. | |
| cf_TotalBasePayAnnualizedInCAD_Amount_currency | String | False | No | Currency in which the total base pay annualized in CAD is measured. | |
| cf_TotalBasePayHourly_Amount_value | Decimal | False | No | Total base pay on an hourly basis, expressed as a numerical value. | |
| cf_TotalBasePayHourly_Amount_currency | String | False | No | Currency in which the total base pay hourly amount is measured. | |
| cf_PrimaryAddressHomeStateText | String | False | No | Text representation of the worker's primary home state address. | |
| cf_NumberOfHires | Int | False | No | Total number of hires associated with this worker record. | |
| cf_SpendAuthorizationsNotInUseByActiveExpenseReports | String | False | No | List of spend authorizations that are not in use by active expense reports. | |
| cf_FormatPercentOfExpenseReportsWithWarningValidations | String | False | No | Formatted percentage of expense reports that include warning validations. | |
| cf_LegalName_LastNameUppercase | String | False | No | Worker's legal last name formatted in uppercase. | |
| cf_Apparel | String | False | No | Apparel-related details associated with the worker. | |
| cf_TopLevelSupervisoryOrganizationGMS_id | String | False | No | Unique identifier for the worker's top-level supervisory organization in the GMS. | |
| cf_TopLevelSupervisoryOrganizationGMS_descriptor | String | False | No | Descriptive label for the worker's top-level supervisory organization in the GMS. | |
| cf_HireDate90Days | Date | False | No | Hire date plus 90 days. | |
| cf_TotalBasePayAnnualizedInEUR_Amount_value | Decimal | False | No | Total base pay annualized in EUR, expressed as a numerical value. | |
| cf_TotalBasePayAnnualizedInEUR_Amount_currency | String | False | No | Currency in which the total base pay annualized in EUR is measured. | |
| cf_TotalBasePayMonthly_Amount_value | Decimal | False | No | Total base pay on a monthly basis, expressed as a numerical value. | |
| cf_TotalBasePayMonthly_Amount_currency | String | False | No | Currency in which the total base pay monthly amount is measured. | |
| cf_PerformanceImprovementPlans_InProgressOrCompleted | String | False | No | List of performance improvement plans that are either in progress or completed. | |
| cf_ExternalPayrollActualHoursWorkedInLast12Months | Int | False | No | Total actual hours worked in external payroll during the last 12 months. | |
| cf_PreferredName_LastNameUppercase | String | False | No | Worker's preferred last name formatted in uppercase. | |
| effectiveAsOfDate | Date | False | No | A pseudo-column used to filter data based on the effective date of the worker record. | |
| effectiveAsOfMoment | Datetime | False | No | A pseudo-column used to filter data based on the exact timestamp of the worker record's effectiveness. | |
| entryDate | Date | False | No | A pseudo-column used to filter data based on the date the worker record entry was recorded. | |
| entryMoment | Datetime | False | No | A pseudo-column used to filter data based on the exact timestamp of when the worker record entry was recorded. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| class1_id | String | False | No | Unique identifier for the class. | |
| class1_descriptor | String | False | No | Descriptive label for the class. | |
| classOfInstance1_id | String | False | No | Unique identifier for the instance's associated class. | |
| classOfInstance1_descriptor | String | False | No | Descriptive label for the instance's associated class. | |
| superclasses | String | False | No | List of superclasses to which this class belongs. | |
| instanceSet1_id | String | False | No | Unique identifier for the set of instances within this class. | |
| instanceSet1_descriptor | String | False | No | Descriptive label for the set of instances within this class. | |
| name1 | String | False | No | Name assigned to the class. | |
| metadata | Bool | False | No | Indicates whether the class contains metadata (True/False). | |
| countClassReportFieldForClass | Int | False | No | Total number of report fields associated with this class. | |
| totalInstancesOfClassIncludingSubclasses | Int | False | No | Total number of instances of this class, including those in subclasses. | |
| comment | String | False | No | General comment or additional information about the class. | |
| classReportFieldsForClassAndSuperClasses | String | False | No | List of report fields available for this class and its superclasses. | |
| DEPRECATED | Bool | False | No | Indicates whether this class has been deprecated (True/False). | |
| translatableDataForClassOrSupersOrSubs | String | False | No | List of translatable data associated with this class, its superclasses, or its subclasses. | |
| securityGroups1 | String | False | No | Security groups associated with this class. | |
| iManSetupDataClass_id | String | False | No | Unique identifier for the iMan setup data class. | |
| iManSetupDataClass_descriptor | String | False | No | Descriptive label for the iMan setup data class. | |
| setupDataClass_id | String | False | No | Unique identifier for the setup data class. | |
| setupDataClass_descriptor | String | False | No | Descriptive label for the setup data class. | |
| workdayID | String | False | No | Unique identifier assigned to the class within Workday. | |
| businessObjectName | String | False | No | Name of the business object associated with this class. | |
| customerAccessibleReportFields | String | False | No | List of report fields accessible to customers for this class. | |
| customerAccessibleDataSources | String | False | No | List of data sources accessible to customers for this class. | |
| secured_id | String | False | No | Unique identifier for the security classification of the class. | |
| secured_descriptor | String | False | No | Descriptive label for the security classification of the class. | |
| effectiveAsOfDate | Date | False | No | A pseudo-column used to filter data based on the effective date of the class. | |
| effectiveAsOfMoment | Datetime | False | No | A pseudo-column used to filter data based on the exact timestamp of the class's effectiveness. | |
| entryDate | Date | False | No | A pseudo-column used to filter data based on the date the class entry was recorded. | |
| entryMoment | Datetime | False | No | A pseudo-column used to filter data based on the exact timestamp of when the class entry was recorded. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| cf_BusinessUnitManager_id | String | False | No | Unique identifier for the business unit manager. | |
| cf_BusinessUnitManager_descriptor | String | False | No | Descriptive label for the business unit manager. | |
| cf_EmployeeTerminationsCount_IncludingSubordinateOrganizations | Int | False | No | Total number of employee terminations, including subordinate organizations. | |
| cf_CompanyCostingManager_id | String | False | No | Unique identifier for the company costing manager. | |
| cf_CompanyCostingManager_descriptor | String | False | No | Descriptive label for the company costing manager. | |
| cf_CostCenterManager_id | String | False | No | Unique identifier for the cost center manager. | |
| cf_CostCenterManager_descriptor | String | False | No | Descriptive label for the cost center manager. | |
| cf_ManagerCount_IncludingSubordinateOrganizations | Int | False | No | Total number of managers, including those in subordinate organizations. | |
| cf_BeginningEmployeeCount_IncludingSubordinateOrganizations | Int | False | No | Total number of employees at the beginning of the period, including subordinate organizations. | |
| cf_RegionCostingManager_id | String | False | No | Unique identifier for the regional costing manager. | |
| cf_RegionCostingManager_descriptor | String | False | No | Descriptive label for the regional costing manager. | |
| cf_MidYearReviewPercentCompleteRange_id | String | False | No | Unique identifier for the range of completion for mid-year reviews. | |
| cf_MidYearReviewPercentCompleteRange_descriptor | String | False | No | Descriptive label for the range of completion for mid-year reviews. | |
| cf_EmployeeVoluntaryTerminationsCount | Int | False | No | Total number of voluntary terminations by employees. | |
| cf_EndingEmployeeCount_IncludingSubordinateOrganizations | Int | False | No | Total number of employees at the end of the period, including subordinate organizations. | |
| cf_EmployeeVoluntaryTerminationsCount_IncludingSubordinateOrganizations | Int | False | No | Total number of voluntary terminations by employees, including subordinate organizations. | |
| cf_EndingContingentWorkerCount_IncludingSubordinateOrganizations | Int | False | No | Total number of contingent workers at the end of the period, including subordinate organizations. | |
| cf_AverageHeadcount_IncludingSubordinateOrganizations | Int | False | No | Average number of employees, including those in subordinate organizations. | |
| cf_SupervisoryOrganizationHierarchy_id | String | False | No | Unique identifier for the supervisory organization hierarchy. | |
| cf_SupervisoryOrganizationHierarchy_descriptor | String | False | No | Descriptive label for the supervisory organization hierarchy. | |
| cf_BeginningContingentWorkerCountInclSubOrgs | Int | False | No | Total number of contingent workers at the beginning of the period, including subordinate organizations. | |
| cf_TurnoverPercent_IncludingSubordinateOrganizations | Int | False | No | Turnover percentage of employees, including subordinate organizations. | |
| cf_OrgHierarchy_id | String | False | No | Unique identifier for the organizational hierarchy. | |
| cf_OrgHierarchy_descriptor | String | False | No | Descriptive label for the organizational hierarchy. | |
| cf_EmployeeToManagerRatio | Int | False | No | Ratio of employees to managers within the organization. | |
| cf_TopPerformerEmployeeCount | Int | False | No | Total number of employees classified as top performers. | |
| cf_BeginningEmployeeCount | Int | False | No | Total number of employees at the beginning of the period. | |
| effectiveAsOfDate | Date | False | No | A pseudo-column used to filter data based on the effective date of the organization record. | |
| effectiveAsOfMoment | Datetime | False | No | A pseudo-column used to filter data based on the exact timestamp of the organization record's effectiveness. | |
| entryDate | Date | False | No | A pseudo-column used to filter data based on the date the organization record entry was recorded. | |
| entryMoment | Datetime | False | No | A pseudo-column used to filter data based on the exact timestamp of when the organization record entry was recorded. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| cf_SupervisoryOrganizationHierarchy_id | String | False | No | Unique identifier for the supervisory organization hierarchy. | |
| cf_SupervisoryOrganizationHierarchy_descriptor | String | False | No | Descriptive label for the supervisory organization hierarchy. | |
| cf_TimeInPositionRange_id | String | False | No | Unique identifier for the time in position range. | |
| cf_TimeInPositionRange_descriptor | String | False | No | Descriptive label for the time in position range. | |
| cf_PositionsFrozen | Int | False | No | Total number of frozen positions. | |
| cf_QuarterAvailable | String | False | No | Quarter in which the position is available. | |
| cf_PositionText | String | False | No | Descriptive text associated with the position. | |
| cf_AnnualPositionBurdenInUSD_value | Decimal | False | No | Total annual burden cost of the position, expressed in USD. | |
| cf_AnnualPositionBurdenInUSD_currency | String | False | No | Currency in which the annual position burden is measured. | |
| cf_NumberOfMonthsUnfilledRange_id | String | False | No | Unique identifier for the range of months a position has been unfilled. | |
| cf_NumberOfMonthsUnfilledRange_descriptor | String | False | No | Descriptive label for the range of months a position has been unfilled. | |
| cf_EarliestHireDate9Months | Date | False | No | Earliest hire date plus nine months. | |
| cf_TimeInPosition_Days | Int | False | No | Number of days the position has been occupied. | |
| cf_AnnualEmployeeBurdenInUSD_value | Decimal | False | No | Total annual burden cost of an employee in this position, expressed in USD. | |
| cf_AnnualEmployeeBurdenInUSD_currency | String | False | No | Currency in which the annual employee burden is measured. | |
| cf_DefaultCompensationRangeMidpointInUSD_value | Decimal | False | No | Midpoint of the default compensation range, expressed in USD. | |
| cf_DefaultCompensationRangeMidpointInUSD_currency | String | False | No | Currency in which the default compensation range midpoint is measured. | |
| cf_EarliestHireDate6Months | Date | False | No | Earliest hire date plus six months. | |
| cf_AnnualContingentWorkerBurdenInUSD_value | Decimal | False | No | Total annual burden cost of a contingent worker, expressed in USD. | |
| cf_AnnualContingentWorkerBurdenInUSD_currency | String | False | No | Currency in which the annual contingent worker burden is measured. | |
| cf_EarliestHireDate3Months | Date | False | No | Earliest hire date plus three months. | |
| cf_MyOrganizations_id | String | False | No | Unique identifier for the associated organization. | |
| cf_MyOrganizations_descriptor | String | False | No | Descriptive label for the associated organization. | |
| cf_PositionCount_AllStatuses | Int | False | No | Total number of positions across all statuses. | |
| cf_AnnualCompensationPayWithBurdenInUSD_value | Decimal | False | No | Annual compensation or pay including burden costs, expressed in USD. | |
| cf_AnnualCompensationPayWithBurdenInUSD_currency | String | False | No | Currency in which the annual compensation with burden is measured. | |
| cf_Worker_id | String | False | No | Unique identifier for the worker assigned to the position. | |
| cf_Worker_descriptor | String | False | No | Descriptive label for the worker assigned to the position. | |
| cf_AnnualCompensationPayInUSD_value | Decimal | False | No | Total annual compensation or pay, expressed in USD. | |
| cf_AnnualCompensationPayInUSD_currency | String | False | No | Currency in which the annual compensation or pay is measured. | |
| cf_WorkerType_id | String | False | No | Unique identifier for the worker type classification. | |
| cf_WorkerType_descriptor | String | False | No | Descriptive label for the worker type classification. | |
| effectiveAsOfDate | Date | False | No | A pseudo-column used to filter data based on the effective date of the position. | |
| effectiveAsOfMoment | Datetime | False | No | A pseudo-column used to filter data based on the exact timestamp of the position's effectiveness. | |
| entryDate | Date | False | No | A pseudo-column used to filter data based on the date the position entry was recorded. | |
| entryMoment | Datetime | False | No | A pseudo-column used to filter data based on the exact timestamp of when the position entry was recorded. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| cf_BusinessUnitManager_id | String | False | No | Unique identifier for the business unit manager. | |
| cf_BusinessUnitManager_descriptor | String | False | No | Descriptive label for the business unit manager. | |
| cf_EmployeeTerminationsCount_IncludingSubordinateOrganizations | Int | False | No | Total number of employee terminations, including subordinate organizations. | |
| cf_CompanyCostingManager_id | String | False | No | Unique identifier for the company costing manager. | |
| cf_CompanyCostingManager_descriptor | String | False | No | Descriptive label for the company costing manager. | |
| cf_CostCenterManager_id | String | False | No | Unique identifier for the cost center manager. | |
| cf_CostCenterManager_descriptor | String | False | No | Descriptive label for the cost center manager. | |
| cf_ManagerCount_IncludingSubordinateOrganizations | Int | False | No | Total number of managers, including those in subordinate organizations. | |
| cf_BeginningEmployeeCount_IncludingSubordinateOrganizations | Int | False | No | Total number of employees at the beginning of the period, including subordinate organizations. | |
| cf_RegionCostingManager_id | String | False | No | Unique identifier for the regional costing manager. | |
| cf_RegionCostingManager_descriptor | String | False | No | Descriptive label for the regional costing manager. | |
| cf_MidYearReviewPercentCompleteRange_id | String | False | No | Unique identifier for the range of completion for mid-year reviews. | |
| cf_MidYearReviewPercentCompleteRange_descriptor | String | False | No | Descriptive label for the range of completion for mid-year reviews. | |
| cf_EmployeeVoluntaryTerminationsCount | Int | False | No | Total number of voluntary terminations by employees. | |
| cf_EndingEmployeeCount_IncludingSubordinateOrganizations | Int | False | No | Total number of employees at the end of the period, including subordinate organizations. | |
| cf_EmployeeVoluntaryTerminationsCount_IncludingSubordinateOrganizations | Int | False | No | Total number of voluntary terminations by employees, including subordinate organizations. | |
| cf_EndingContingentWorkerCount_IncludingSubordinateOrganizations | Int | False | No | Total number of contingent workers at the end of the period, including subordinate organizations. | |
| cf_AverageHeadcount_IncludingSubordinateOrganizations | Int | False | No | Average number of employees, including those in subordinate organizations. | |
| cf_SupervisoryOrganizationHierarchy_id | String | False | No | Unique identifier for the supervisory organization hierarchy. | |
| cf_SupervisoryOrganizationHierarchy_descriptor | String | False | No | Descriptive label for the supervisory organization hierarchy. | |
| cf_BeginningContingentWorkerCountInclSubOrgs | Int | False | No | Total number of contingent workers at the beginning of the period, including subordinate organizations. | |
| cf_TurnoverPercent_IncludingSubordinateOrganizations | Int | False | No | Turnover percentage of employees, including subordinate organizations. | |
| cf_OrgHierarchy_id | String | False | No | Unique identifier for the organizational hierarchy. | |
| cf_OrgHierarchy_descriptor | String | False | No | Descriptive label for the organizational hierarchy. | |
| cf_EmployeeToManagerRatio | Int | False | No | Ratio of employees to managers within the organization. | |
| cf_TopPerformerEmployeeCount | Int | False | No | Total number of employees classified as top performers. | |
| cf_BeginningEmployeeCount | Int | False | No | Total number of employees at the beginning of the period. | |
| effectiveAsOfDate | Date | False | No | A pseudo-column used to filter data based on the effective date of the organization record. | |
| effectiveAsOfMoment | Datetime | False | No | A pseudo-column used to filter data based on the exact timestamp of the organization record's effectiveness. | |
| entryDate | Date | False | No | A pseudo-column used to filter data based on the date the organization record entry was recorded. | |
| entryMoment | Datetime | False | No | A pseudo-column used to filter data based on the exact timestamp of when the organization record entry was recorded. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| cf_BusinessUnitManager_id | String | False | No | Unique identifier for the business unit manager. | |
| cf_BusinessUnitManager_descriptor | String | False | No | Descriptive label for the business unit manager. | |
| cf_EmployeeTerminationsCount_IncludingSubordinateOrganizations | Int | False | No | Total number of employee terminations, including subordinate organizations. | |
| cf_CompanyCostingManager_id | String | False | No | Unique identifier for the company costing manager. | |
| cf_CompanyCostingManager_descriptor | String | False | No | Descriptive label for the company costing manager. | |
| cf_CostCenterManager_id | String | False | No | Unique identifier for the cost center manager. | |
| cf_CostCenterManager_descriptor | String | False | No | Descriptive label for the cost center manager. | |
| cf_ManagerCount_IncludingSubordinateOrganizations | Int | False | No | Total number of managers, including those in subordinate organizations. | |
| cf_BeginningEmployeeCount_IncludingSubordinateOrganizations | Int | False | No | Total number of employees at the beginning of the period, including subordinate organizations. | |
| cf_RegionCostingManager_id | String | False | No | Unique identifier for the regional costing manager. | |
| cf_RegionCostingManager_descriptor | String | False | No | Descriptive label for the regional costing manager. | |
| cf_MidYearReviewPercentCompleteRange_id | String | False | No | Unique identifier for the range of completion for mid-year reviews. | |
| cf_MidYearReviewPercentCompleteRange_descriptor | String | False | No | Descriptive label for the range of completion for mid-year reviews. | |
| cf_EmployeeVoluntaryTerminationsCount | Int | False | No | Total number of voluntary terminations by employees. | |
| cf_EndingEmployeeCount_IncludingSubordinateOrganizations | Int | False | No | Total number of employees at the end of the period, including subordinate organizations. | |
| cf_EmployeeVoluntaryTerminationsCount_IncludingSubordinateOrganizations | Int | False | No | Total number of voluntary terminations by employees, including subordinate organizations. | |
| cf_EndingContingentWorkerCount_IncludingSubordinateOrganizations | Int | False | No | Total number of contingent workers at the end of the period, including subordinate organizations. | |
| cf_AverageHeadcount_IncludingSubordinateOrganizations | Int | False | No | Average number of employees, including those in subordinate organizations. | |
| cf_SupervisoryOrganizationHierarchy_id | String | False | No | Unique identifier for the supervisory organization hierarchy. | |
| cf_SupervisoryOrganizationHierarchy_descriptor | String | False | No | Descriptive label for the supervisory organization hierarchy. | |
| cf_BeginningContingentWorkerCountInclSubOrgs | Int | False | No | Total number of contingent workers at the beginning of the period, including subordinate organizations. | |
| cf_TurnoverPercent_IncludingSubordinateOrganizations | Int | False | No | Turnover percentage of employees, including subordinate organizations. | |
| cf_OrgHierarchy_id | String | False | No | Unique identifier for the organizational hierarchy. | |
| cf_OrgHierarchy_descriptor | String | False | No | Descriptive label for the organizational hierarchy. | |
| cf_EmployeeToManagerRatio | Int | False | No | Ratio of employees to managers within the organization. | |
| cf_TopPerformerEmployeeCount | Int | False | No | Total number of employees classified as top performers. | |
| cf_BeginningEmployeeCount | Int | False | No | Total number of employees at the beginning of the period. | |
| effectiveAsOfDate | Date | False | No | A pseudo-column used to filter data based on the effective date of the organization record. | |
| effectiveAsOfMoment | Datetime | False | No | A pseudo-column used to filter data based on the exact timestamp of the organization record's effectiveness. | |
| entryDate | Date | False | No | A pseudo-column used to filter data based on the date the organization record entry was recorded. | |
| entryMoment | Datetime | False | No | A pseudo-column used to filter data based on the exact timestamp of when the organization record entry was recorded. |