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