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.
Table Specific Information
Select
The Workday component requires filtering on organizations_Prompt in order to perform the query.
For example:
SELECT * FROM organizationsIManage WHERE organizations_Prompt = '1fcf0b79747a43d1a4de334e0c214b1b';
Columns
| Name | Type | References | Description |
| cf_BusinessUnitManager_id | String | Unique identifier for the business unit manager. | |
| cf_BusinessUnitManager_descriptor | String | Descriptive label for the business unit manager. | |
| cf_EmployeeTerminationsCount_IncludingSubordinateOrganizations | Int | Total number of employee terminations, including subordinate organizations. | |
| cf_CompanyCostingManager_id | String | Unique identifier for the company costing manager. | |
| cf_CompanyCostingManager_descriptor | String | Descriptive label for the company costing manager. | |
| cf_CostCenterManager_id | String | Unique identifier for the cost center manager. | |
| cf_CostCenterManager_descriptor | String | Descriptive label for the cost center manager. | |
| cf_ManagerCount_IncludingSubordinateOrganizations | Int | Total number of managers, including those in subordinate organizations. | |
| cf_BeginningEmployeeCount_IncludingSubordinateOrganizations | Int | Total number of employees at the beginning of the period, including subordinate organizations. | |
| cf_RegionCostingManager_id | String | Unique identifier for the regional costing manager. | |
| cf_RegionCostingManager_descriptor | String | Descriptive label for the regional costing manager. | |
| cf_MidYearReviewPercentCompleteRange_id | String | Unique identifier for the range of completion for mid-year reviews. | |
| cf_MidYearReviewPercentCompleteRange_descriptor | String | Descriptive label for the range of completion for mid-year reviews. | |
| cf_EmployeeVoluntaryTerminationsCount | Int | Total number of voluntary terminations by employees. | |
| cf_EndingEmployeeCount_IncludingSubordinateOrganizations | Int | Total number of employees at the end of the period, including subordinate organizations. | |
| cf_EmployeeVoluntaryTerminationsCount_IncludingSubordinateOrganizations | Int | Total number of voluntary terminations by employees, including subordinate organizations. | |
| cf_EndingContingentWorkerCount_IncludingSubordinateOrganizations | Int | Total number of contingent workers at the end of the period, including subordinate organizations. | |
| cf_AverageHeadcount_IncludingSubordinateOrganizations | Int | Average number of employees, including those in subordinate organizations. | |
| cf_SupervisoryOrganizationHierarchy_id | String | Unique identifier for the supervisory organization hierarchy. | |
| cf_SupervisoryOrganizationHierarchy_descriptor | String | Descriptive label for the supervisory organization hierarchy. | |
| cf_BeginningContingentWorkerCountInclSubOrgs | Int | Total number of contingent workers at the beginning of the period, including subordinate organizations. | |
| cf_TurnoverPercent_IncludingSubordinateOrganizations | Int | Turnover percentage of employees, including subordinate organizations. | |
| cf_OrgHierarchy_id | String | Unique identifier for the organizational hierarchy. | |
| cf_OrgHierarchy_descriptor | String | Descriptive label for the organizational hierarchy. | |
| cf_EmployeeToManagerRatio | Int | Ratio of employees to managers within the organization. | |
| cf_TopPerformerEmployeeCount | Int | Total number of employees classified as top performers. | |
| cf_BeginningEmployeeCount | Int | Total number of employees at the beginning of the period. | |
| effectiveAsOfDate | Date | A pseudo-column used to filter data based on the effective date of the organization record. | |
| effectiveAsOfMoment | Datetime | A pseudo-column used to filter data based on the exact timestamp of the organization record's effectiveness. | |
| entryDate | Date | A pseudo-column used to filter data based on the date the organization record entry was recorded. | |
| entryMoment | Datetime | A pseudo-column used to filter data based on the exact timestamp of when the organization record entry was recorded. |