Tell me about your experience with Workday integrations, including EIB, custom integrations, data transformation, security protocols, and troubleshooting.
For a hands-on SQL exercise, use the supplied Workday integration tables to identify issues across the latest EIB and custom integration record for each worker.
worker_id, worker_name, both run IDs and statuses, security protocols, issue_count, and semicolon-separated issue_types.issue_count descending, then worker_id ascending.| Column | Type | Description |
|---|---|---|
| worker_idPK | VARCHAR(10) | Workday worker identifier |
| worker_name | VARCHAR(100) | Worker display name |
| worker_status | VARCHAR(20) | Current worker status |
| Column | Type | Description |
|---|---|---|
| run_idPK | INT | Integration run identifier |
| integration_name | VARCHAR(100) | Workday integration name |
| integration_type | VARCHAR(20) | EIB or custom integration type |
| started_at | TIMESTAMP | Run start timestamp |
| status | VARCHAR(20) | Overall run status |
| Column | Type | Description |
|---|---|---|
| record_idPK | INT | Processed worker record identifier |
| run_id | INT | Related integration run |
| worker_id | VARCHAR(10) | Related Workday worker |
| source_status | VARCHAR(20) | Status received from the source |
| transformed_status | VARCHAR(20) | Status after transformation |
| security_check_id | INT | Related security validation |
| processed_at | TIMESTAMP | Record processing timestamp |
| error_code | VARCHAR(30) | Integration error code, if present |
| Column | Type | Description |
|---|---|---|
| security_check_idPK | INT | Security validation identifier |
| protocol | VARCHAR(30) | Security protocol used |
| verification_status | VARCHAR(20) | Security verification result |