JDBC Driver for Workday

Build 22.0.8462

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.

Columns

Name Type References Description
cf_BusinessUnitManager_id String Business Unit Manager id
cf_BusinessUnitManager_descriptor String Business Unit Manager descriptor
cf_EmployeeTerminationsCount_IncludingSubordinateOrganizations Int Employee Terminations Count - Including Subordinate Organizations
cf_CompanyCostingManager_id String Company Costing Manager id
cf_CompanyCostingManager_descriptor String Company Costing Manager descriptor
cf_CostCenterManager_id String Cost Center Manager id
cf_CostCenterManager_descriptor String Cost Center Manager descriptor
cf_ManagerCount_IncludingSubordinateOrganizations Int Manager Count - Including Subordinate Organizations
cf_BeginningEmployeeCount_IncludingSubordinateOrganizations Int Beginning Employee Count - Including Subordinate Organizations
cf_RegionCostingManager_id String Region Costing Manager id
cf_RegionCostingManager_descriptor String Region Costing Manager descriptor
cf_MidYearReviewPercentCompleteRange_id String Mid Year Review Percent Complete Range id
cf_MidYearReviewPercentCompleteRange_descriptor String Mid Year Review Percent Complete Range descriptor
cf_EmployeeVoluntaryTerminationsCount Int Employee Voluntary Terminations Count
cf_EndingEmployeeCount_IncludingSubordinateOrganizations Int Ending Employee Count - Including Subordinate Organizations
cf_EmployeeVoluntaryTerminationsCount_IncludingSubordinateOrganizations Int Employee Voluntary Terminations Count - including Subordinate Organizations
cf_EndingContingentWorkerCount_IncludingSubordinateOrganizations Int Ending Contingent Worker Count - Including Subordinate Organizations
cf_AverageHeadcount_IncludingSubordinateOrganizations Int Average Headcount - Including Subordinate Organizations
cf_SupervisoryOrganizationHierarchy_id String Supervisory Organization Hierarchy id
cf_SupervisoryOrganizationHierarchy_descriptor String Supervisory Organization Hierarchy descriptor
cf_BeginningContingentWorkerCountInclSubOrgs Int Beginning Contingent Worker Count (incl Sub Orgs)
cf_TurnoverPercent_IncludingSubordinateOrganizations Int Turnover Percent - Including Subordinate Organizations
cf_OrgHierarchy_id String Org Hierarchy id
cf_OrgHierarchy_descriptor String Org Hierarchy descriptor
cf_EmployeeToManagerRatio Int Employee to Manager Ratio
cf_TopPerformerEmployeeCount Int Top Performer Employee Count
cf_BeginningEmployeeCount Int Beginning Employee Count
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

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462