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