Organization Design Data Requirements
Table of objects required to populate Organization Design with data.
The following table outlines the metrics, concepts, dimensions, properties, and references required to populate Organization Design with data. The requirement categories are defined as follows:
- Required: These are mandatory to populate the org structure.
- Recommended: Not mandatory, but essential for meaningful analysis.
- Optional: Additional data that provides extra context but does not affect the core functionality.
|
Display Name |
Object Name |
Parent Object |
Object Type |
Requirement Category |
|---|---|---|---|---|
|
Employee ID |
Employee.EmployeeID |
Employee |
Property |
Required |
|
First Name |
Employee.First_Name |
Employee |
Property |
Required |
|
Last Name |
Employee.Last_Name |
Employee |
Property |
Required |
|
Job Name |
Job_Name |
Shared dimension between Employee and Managed Position |
Dimension |
Required |
|
Headcount |
employeeCount |
Employee |
Metric |
Required |
|
Current Employee |
isActiveEmployee |
Employee |
Selection Concept |
Required |
|
Direct Manager |
Employee.Direct_Manager |
Employee |
Reference |
Required |
|
Parent Position |
Managed_Position.Parent_Position |
Managed Position |
Reference |
Recommended Without this, you will not see vacant positions in the org structure. |
|
Organization |
Organization_Hierarchy |
Shared dimension between Employee and Managed Position |
Dimension |
Recommended Without this, you cannot use organizations view or edit organization values in the Show details panel. |
|
Organization Head |
Organization_Hierarchy.Org_Head |
Organization Hierarchy |
Property |
Recommended Without this, all organizations will initially appear with an unassigned organization head in the organizations view. |
|
Manager Status |
Manager_Status |
Shared dimension between Employee and Managed Position |
Dimension |
Recommended Without this, you cannot edit manager status in the Show details panel, and the health check will be unable to identify managers who currently have no direct reports. |
|
Pay Level |
Pay_Level |
Shared dimension between Employee and Managed Position |
Dimension |
Recommended Without this, you cannot edit pay level in the Show details panel. |
|
Location |
Location |
Shared dimension between Employee and Managed Position |
Dimension |
Recommended Without this, you cannot edit location in the Show details panel and it will not show on nodes. |
|
Cost Center Hierarchy |
Cost_Center_Hierarchy |
Shared dimension between Employee and Managed Position |
Dimension |
Recommended Without this, you cannot edit cost center in the Show details panel. |
|
Total Cost of Workforce |
Total_Cost_of_Workforce |
Employee |
Calculation Concept |
Recommended Without this, you cannot see cost metrics, and you will be unable to edit compensation values in the Show details panel. |
|
Budgeted Total Cost of Position |
Managed_Position.Budgeted_Total_Cost_Of_Position |
Managed Position |
Property |
Recommended Without this, the cost of vacant positions will not be included in cost metric calculations. |
|
Contract Type |
Employee.Contract_Type |
Employee |
Property |
Recommended Without this, you cannot see contract type in employee details. |
|
Performance Rating |
Employee.Performance_Rating |
Employee |
Property |
Optional |
|
Employment Status |
Employee.Employment_Status |
Employee |
Property |
Optional |
|
Tenure |
Employee.Tenure |
Employee |
Property |
Optional |
|
Time in Role |
Employee.Time_in_Role |
Employee |
Property |
Optional |
|
Potential |
Employee.Potential |
Employee |
Property |
Optional |
|
Critical Employee Status |
Employee.Critical_Employee_Status |
Employee |
Property |
Optional |
|
Top Talent Status |
Employee.Top_Talent_Status |
Employee |
Property |
Optional |
