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. |