Employee custom dynamic attributes

This topic describes the information required to load data to Employee custom dynamic attributes.

There are two data load types:

  • Employee level. The configuration is done by specifying the EmployeeID field.
  • Position assignment level. The configuration is done by specifying the PositionID and EmployeeID fields.

The table is WFB_EmployeeCustomDynamicAttributes.

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

  • Dimensions
    • WBDEMPLOYEE
    • ATDATTRIBUTE_EMPLOYEE
  • Cube
    • ATCDATA_EMPLOYEE

The Job custom dynamic attribute is related to these business objects:

  • Entity
  • Position
  • Employee

This table describes the Employee custom dynamic attribute business object:

Field Type Required Description
EmployeeID [nvarchar] (200) Y EmployeeID that exists in the particular configuration set. The EmployeeID must be unique per configuration set, version, and entity.
PositionID [nvarchar] (200) Y/N PositionID that exists in the particular configuration set. The PositionID must be unique per configuration set and version.
AttributeName [nvarchar] (252) Y Custom attribute name that exists in the system.
Value [nvarchar] (252) YES Custom dynamic attribute value.

These values are valid:

  • Free text. The format type must be String or Text Area.
  • F, False, or 0 for inactive value. Anything other than F, False, or 0 for active value. The format type must be Boolean.
  • Valid element name in the hierarchy. The format type must be List.

Valid element name in the selected hierarchy of the selected cube and dimension. The format type must be Dimension List.