Employee

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

The process uses these tables and stored procedures:

• The staging table is DAT_ATCDATA_EMPLOYEE_STAGE.
• The stored procedure to validate staged data is depm_integration_wb_employee_prepare_staging.
• The stored procedure to process staged data is depm_integration_wb_employee.
• The data is imported to:
  • The DAT_ATCDATA_EMPLOYEE_TRANSFORMED table.
  • The ATCDATA_EMPLOYEE and WBCCONFIG_ACTION_ORDER cubes.

The output tables are:

• ATT_ATCDATA_EMPLOYEE contains dynamic attribute cube data.
• DIM_WBDEMPLOYEE_ELEMENTS contains elements for the WBDEMPLOYEE dimension.
• DIM_WBDEMPLOYEE_PARENTS contains parent/child relationships for the WBDEMPLOYEE dimension.

The entity ID must exist prior to importing data.

This table describes DAT_ATCDATA_EMPLOYEE_STAGE:

Field	Required	Description
Title	N	Employee title or salutation. For example, Mr. or Ms.
Active	N	The values are: 1 for active employees. 0 for inactive employees. The default value is 1.
Identifier	Y	Unique identifying code for the employee. Used as the element name.
EmployeeEffectiveStart	Y	Effective start date for the employee. The format is YYYY/MM/DD.
EmployeeEffectiveEnd	N	Effective end date for the employee. The format is YYYY/MM/DD.
WorkLocation	N	Optional tag indicating location.
SalaryPercentage	N	The default salary percent expressed as a number without division by 100. For example, 25 instead of 0.25.
BenefitPercentage	N	The default benefit percent expressed as a number without division by 100. For example, 25 instead of 0.25.
ReportIdentifier	N	Optional tag for reporting.
ExcludeFromDefaults	N	Exclude the employee from any changes that are made to the default values that are specified in the position. The valid values are: 1 for not inheriting changes. 0 for inheriting changes. The default is 0.
ReportFTE	N	Full time equivalent value for reporting.
FirstName	Y	Employee first name.
MiddleName	N	Employee middle name.
LastName	Y	Employee last name.
HireDate	N	Date of hire. The format is YYYY/MM/DD.
PromotionDate	N	Date of promotion. The format is YYYY/MM/DD.
LongevityDate	N	Date used for longevity. The format is YYYY/MM/DD.
BPDENTITY	Y	Set to valid entity ID of the employee's primary position. Otherwise set to valid entity ID where the employee is defined. The related field is ID in the DIM_BPDENTITY_ELEMENTS. table.