Employee

Employee information is the lowest level of detail in Workforce Budgeting. Employees can hold one or more positions called assignments.

The table is WF_EMPLOYEE.

The Employee business object is used in these dimensions and cubes:

  • Dimensions
    • Workforce Employee (WBDEMPLOYEE)
    • Employee Dynamic Attributes (ATDATTRIBUTE_EMPLOYEE)
  • Cubes
    • Dynamic Attributes Employee (ATCDATA_EMPLOYEE)
    • WFB Calculation (WBCCALCULATION)
    • WFB Allocation Configuration (WBDCONFIG_ALLOCATION)
    • WFB Calculation Order Configuration (WBCCONFIG_ACTION_ORDER)
    • WFB Main (WBCMAIN)

Employee elements are created during the import process by the application in the Workforce Employee dimension (WBDEMPLOYEE) which is in the WBDEMPLOYEE hierarchy under TOTAL_EMPLOYEE.

The Employee business object is related to the Entity business objects.

This table describes the Employee business object:

Field Type Required Description
Title [nvarchar] (20)

NULL

 N Text string for the employee title or salutation.
Active [bit]

NULL

 N Indicates if the employee is active or inactive.

These values are valid:

  • 1 for active employee.
  • 0 for inactive employee.

The default is 1.
EmployeeID [nvarchar] (200)

NOT NULL

 Y Unique employee ID in the Employee business object.
EffectiveStart [datetime]

NOT NULL

 Y Effective start date for the employee.
EffectiveEnd [datetime]

NULL

 Y Effective end date for the employee.

Must be greater than or equal to EffectiveStart.
WorkLocation [nvarchar] (252)

NULL

 N Optional tag indicating location.
SalaryPercentage [float] (53)

NULL

 N The default salary percent expressed as a numeric without division by 100.
BenefitPercentage [float] (53)

NULL

N The default salary percent expressed as a numeric without division by 100.
ReportID [nvarchar] (200)

NULL

 N Tag for reporting.
ExcludeFromDefaults [bit]

NULL

 N Exclude the employee from any changes that are made to the default values that are specified in the position.

These values are valid:

  • 1 to not inherit changes.
  • 0 to inherit changes.

These are the properties that can be inherited per Pay Basis:

  • Annual and monthly
    • Salary
    • Maximum salary
  • Hourly rate
  • Table base annual and monthly
    • Salary table
    • Salary grade
    • Salary step
    • Progression rule
    • Maximum salary
  • Table base hourly
    • Salary table
    • Salary grade
    • Salary step
    • Progression rule

The default is 0.
ReportFTE [float] (53)

NULL

 N Full time equivalent value for reporting.
FirstName [nvarchar] (252)

NOT NULL

Y Employee first name.
MiddleName [nvarchar] (252)

NULL

 N Employee middle name.
LastName [nvarchar] (252)

NOT NULL

 Y Employee last name.
HireDate [datetime]

NULL

 N Date of hire.

There is no default.
PromotionDate [datetime]

NULL

 N Date of promotion.

There is no default.
LongevityDate [datetime]

NULL

 N Date used for longevity rules.

There is no default.
Entity [nvarchar] (200)

NOT NULL

 Y Unique entity ID in the Entity business object that is activated in the configuration set.