ATCDATA_EMPLOYEE_CUSTOM cube

This cube is for employee dynamic attributes records.

  • The staging table is DAT_ATCDATA_EMPLOYEE_CUSTOM_STAGE.
  • The stored procedure to create staging table is depm_integration_wp_employee_custom_create_staging.sql.
  • The stored procedure to validate staged data is depm_integration_wp_employee_custom_prepare_staging.sql.
  • The stored procedure to process staged data is depm_integration_wp_employee_custom.sql.
  • The output table is ATT_ATCDATA_EMPLOYEE_CUSTOM (employee dynamic attributes cube data table).

The table describes DAT_ATCDATA_EMPLOYEE_CUSTOM_STAGE:

Field Type Required Description
WBDEMPLOYEE nvarchar(2000) Y Must exist in DIM_WBDEMPLOYEE_ELEMENTS.
Employee dynamic attribute nvarchar(2000) Y Must exist in Designer in custom employee dynamic attributes.