Scheduled and worked shifts by unit and role. Under review: employee identifiers must be tokenized before gold promotion.
2 upstream · 0 downstream · Show in the estate graph
Source · Systems of record, untouched
Bronze · Raw landing, append-only
Silver · Cleaned and conformed
SG-OPS-WORKFORCE-READAdded to SG-OPS-WORKFORCE-READ, recertified every 90 days.
Refreshed within SLA
Timeliness
Unit in org hierarchy
Conformance
Worked hours not negative
Validity
Pass at 98% or better, warn from 90%. A failing check blocks certification.
| Column | Type | Description | Class |
|---|---|---|---|
| shift_id | varchar(20) | Shift key | None |
| employee_id | varchar(10) | Employee number (to be tokenized) | None |
| unit | varchar(30) | Nursing or clinic unit | None |
| scheduled_hours | decimal(4,2) | Scheduled hours | None |