topLevelOrganizationsAndSubordinates
Accesses the Organization as its primary object. The Organization object returns one row per organization.
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 |