Employee

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

The staging table is WF_EMPLOYEE.

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

  • Dimensions
    • WBDEMPLOYEE
    • ATDATTRIBUTE_EMPLOYEE
  • Cubes
    • ATCDATA_EMPLOYEE
    • WBCCALCULATION
    • WBDCONFIG_ALLOCATION
    • WBCCONFIG_ACTION_ORDER
    • WBCMAIN

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

The Employee business object is related to these business objects:

  • Entity

This table describes the Employee business object:

Field Type Mandatory 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 0.
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.

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.