Organization Design Data Requirements

Table of objects required to populate Organization Design with data.

Overview

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 strongly recommended for meaningful analysis.
  • Optional: Additional data that provides extra context but does not affect the core functionality.

Data customizations

The default objects below drive the core functionality of Organization Design. If your organization requires customizations, contact Visier Technical Support.

Customizing this list expands how you interact with Organization Design. For example, adding custom dimensions such as Career Level allows you to view and edit those fields in the employee side panel, track modifications in the Changes view, group your metric breakdowns by those attributes, and display them directly as a node in your org structure.

Data requirements

Note: Some data requirements listed below are marked as Future Enhancement in the Status column. While providing this data does not currently affect the behavior of Organization Design, loading this data ensures the application is seamlessly prepared for future enhancements.

Display Name

Object Name

Parent Object

Object Type

Requirement Category

Status

Employee ID

EmployeeID

Employee

Property

Required

Available

First Name

Employee.First_Name

Employee

Property

Required

Available

Last Name

Employee.Last_Name

Employee

Property

Required

Available

Job Name

Job_Name

Shared dimension between Employee and Managed Position

Dimension

Required

Available

Headcount

employeeCount

Employee

Metric

Required

Available

Current Employee

isActiveEmployee

Employee

Selection Concept

Required

Available

Direct Manager

Employee.Direct_Manager

Employee

Reference

Required

Available

Position ID

Managed_PositionID

Managed Position

Property

Recommended

Without this, you will not see vacant positions in the org structure.

Available

Parent Position

Managed_Position.Parent_Position

Managed Position

Reference

Recommended

Without this, you will not see vacant positions in the org structure.

Available

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.

Available

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.

Available

Manager Status

isManager

Shared concept between Employee and Managed Position

Selection Concept

Recommended

Without this, you cannot perform a custom check that looks for manager positions with no direct reports and you cannot edit manager status in the Show details panel.

Available

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.

Available

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.

Available

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.

Available

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.

Available

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.

Available

Contract Type

Employee.Contract_Type

Employee

Property

Recommended

Without this, you cannot see contract type in employee details.

Available

Future Employee Starts

N/A

Employee

Record

Recommended

Without this, you cannot see future employee starts.

Future Enhancement

Employee ID

EmployeeID

Future Employee Exit

Property

Recommended

Without this, you cannot see known employee exits.

Future Enhancement

Future Employee Exit Reason

Future_Employee_Exit_Reason

Future Employee Exit

Dimension

Recommended

Without this, you cannot see known employee exits.

Future Enhancement

Expected Exit Date

Future_Employee_Exit.Expected_Termination_Date

Future Employee Exit

Property

Recommended

Without this, you cannot see known employee exits.

Future Enhancement

Contingent Employee

isContingentEmployee

Shared concept between Employee and Managed Position

Selection Concept

Recommended

Without this, you cannot see the contractor ratio design principle.

Available

Executive-level

isExecutiveLevelPosition

Shared concept between Employee and Managed Position

Selection Concept

Optional

Without this, you cannot see the executive level ratio design principle.

Available

Middle-level

isMiddleLevelPosition

Shared concept between Employee and Managed Position

Selection Concept

Optional

Without this, you cannot see the mid level ratio design principle.

Available

Entry-level

isEntryLevelPosition

Shared concept between Employee and Managed Position

Selection Concept

Optional

Without this, you cannot see the entry level ratio design principle.

Available

Standard Occupational Hierarchy

Standard_Occupational_Hierarchy

Employee

Dimension

Optional

Future Enhancement

EEOC Function

EEOC_Function

Shared dimension between Employee and Managed Position

Dimension

Optional

Future Enhancement

Performance Rating

Employee.Performance_Rating

Employee

Property

Optional

Available

Employment Status

Employee.Employment_Status

Employee

Property

Optional

Available

Tenure

Employee.Tenure

Employee

Property

Optional

Available

Time in Role

Employee.Time_in_Role

Employee

Property

Optional

Available

Potential

Employee.Potential

Employee

Property

Optional

Available

Critical Employee Status

Employee.Critical_Employee_Status

Employee

Property

Optional

Available

Top Talent Status

Employee.Top_Talent_Status

Employee

Property

Optional

Available