Print-friendly review of the future draft-save dry-run payload. This packet does not save, publish, insert, update, delete, text, email, lock, or hard-block anything.
Generated: Jun 5, 2026 12:18 AM
Likely draft source: hd_draft_shifts — Best detected draft-save review target. This print packet does not write to it.
| Field | Status | Detected Column | Example | Note |
|---|---|---|---|---|
| Employee employee_id |
Mapped | employee_id | selected_employee_id | Mapped for future review only. No data is written. |
| Shift Date shift_date |
Mapped | work_date | YYYY-MM-DD | Mapped for future review only. No data is written. |
| Start Time start_time |
Mapped | starts_at | 09:00 | Mapped for future review only. No data is written. |
| End Time end_time |
Mapped | ends_at | 17:00 | Mapped for future review only. No data is written. |
| Field | Required | Status | Column | Example Value | Would Write? |
|---|---|---|---|---|---|
| Employee employee_id |
Yes | Mapped | employee_id | selected_employee_id | No |
| Shift Date shift_date |
Yes | Mapped | work_date | YYYY-MM-DD | No |
| Start Time start_time |
Yes | Mapped | starts_at | 09:00 | No |
| End Time end_time |
Yes | Mapped | ends_at | 17:00 | No |
| Schedule Period period_id |
No | Mapped | schedule_period_id | selected_period_id | No |
| Draft Status status |
No | Mapped | status | draft | No |
| Role / Position role_position |
No | Mapped | role | lane_attendant | No |
| Notes notes |
No | Missing | Not detected | optional manager note | No |
| Created By created_by |
No | Mapped | created_by | current_manager_id | No |
| Updated By updated_by |
No | Mapped | updated_by | current_manager_id | No |
| Check | Status | Note |
|---|---|---|
| No POST request made | Passed | Print packet is GET-only. |
| No form submitted | Passed | This packet reviews fields only. |
| No draft row inserted | Passed | No insert/update/delete statements are performed. |
| No publish action called | Passed | Employee-facing published schedules are not changed. |
| No employee notification sent | Passed | No text/email behavior is introduced. |
| No hard conflict blocking added | Passed | Soft conflicts remain review-only. |
| No production controller override | Passed | This is a separate support/print route. |
| URI | Status | Action |
|---|---|---|
| hd/employee-schedules/production | Found | App\Http\Controllers\Hd\EmployeeSchedules\EmployeeScheduleProductionRouteRescueController@index |
| hd/employee-schedules/builder/draft-save-dry-run-preview | Found | App\Http\Controllers\Hd\EmployeeSchedules\EmployeeScheduleBuilderDraftSaveDryRunPreviewController@index |
| hd/employee-schedules/builder/draft-save-dry-run-preview/print | Found | App\Http\Controllers\Hd\EmployeeSchedules\EmployeeScheduleBuilderDraftSaveDryRunPrintController@index |
| hd/employee-schedules/employee-portal | Found | App\Http\Controllers\Hd\EmployeeSchedules\EmployeeScheduleSimplifiedPortalController@index |
| Table | Status | Rows | Score | Purpose |
|---|---|---|---|---|
| hd_draft_shifts | Present | 5 | 115 | Preferred draft shift table candidate. |
| hd_employee_schedule_shifts | Present | 2 | 75 | Possible employee schedule shift table. |
| hd_schedule_periods | Present | 2 | 45 | Possible schedule period/week table. |
| hd_schedule_shifts | Missing | 0 | 0 | Possible generic schedule shift table. |
| hd_employee_schedules | Missing | 0 | 0 | Possible schedule header/shift hybrid table. |
| hd_employee_schedule_periods | Missing | 0 | 0 | Possible employee schedule period table. |
| hd_published_shifts | Present | 1 | 0 | Published shift table; should not be a draft-save target. |