HD Sports Zone Bookmark 25L-4 — Employee Access Preview Print / Manager Review Packet

Packet Summary

Selected Mapping

Published Shifts employee_id → HD Employees id

Best option if hd_employees is the active HD roster table.

High Confidence Strong Preview Candidate 100.0% Coverage

hd_published_shifts.employee_id → hd_employees.id

Selected Identity

Identity #2

Anonymized identity value only. No employee name or email is displayed.

Previewed shifts: 1

Anonymized Identity Buckets

Identity	Identity Match	Shift Count	Date Range
Identity #2 value=2	Matched	1	2026-06-14 — 2026-06-14

Previewed Published Shifts

Identity	Date / Time	Role / Area	Status	Soft Conflict	Mapping Used
Identity #2	2026-06-14 2026-06-14 2:00 PM — 2026-06-14 3:00 PM	Publish Prep Active Test Shift 26A-181 Publish Prep / Internal Test	published	None	employee_id → hd_employees.id

Mapping Options Summary

Mapping	Confidence	Status	Distinct Shift Values	Matched Values	Coverage
Published Shifts user_id → Users id Best option if published shifts store the authenticated user id directly.	High	Unavailable	0	0	0.0%
Published Shifts employee_id → Employees id Best option if employees is the active roster table.	High	Unavailable	0	0	0.0%
Published Shifts employee_id → HD Employees id Best option if hd_employees is the active HD roster table.	High	Strong Preview Candidate	1	1	100.0%
Published Shifts staff_id → Staff id Possible option if schedules are assigned to staff records.	Medium	Unavailable	0	0	0.0%
Published Shifts staff_id → HD Staff id Possible option if schedules are assigned to HD staff records.	Medium	Unavailable	0	0	0.0%
Published Shifts user_id → Employees user_id Possible bridge if employees table links to users through user_id.	Medium	Unavailable	0	0	0.0%
Published Shifts user_id → HD Employees user_id Possible bridge if hd_employees table links to users through user_id.	Medium	Unavailable	0	0	0.0%
Published Shifts employee_id → Users employee_id Possible bridge if users table stores employee_id.	Medium	Unavailable	0	0	0.0%
Published Shifts staff_id → Users staff_id Possible bridge if users table stores staff_id.	Medium	Unavailable	0	0	0.0%

Print Packet Rules

1. Browser-print only. No PDF, CSV, export, or stored file is generated.
2. Anonymized identity values only. No employee names or email addresses are displayed.
3. No permission enforcement is active from this print packet.
4. No auth config, middleware, guard, provider, policy, or role changes are made.
5. Managers can use this packet to review the selected mapping before a future enforcement-prep phase.

Preserved Boundaries

Read-only print packet Browser print only No PDF generation No CSV export No export changes No permission enforcement No auth config changes No middleware changes No database writes No migrations No employee PII output No route deletion No page deletion No schedule edits No published schedule edits No draft schedule edits No employee texts No employee emails No notifications No payroll changes No Time Clock rules changes No POS shifts changes No reservations changes No payments changes No waivers changes No customer profile changes No schedule locking No hard schedule blocking changes

Route Checks

Area	Critical	Method	Status	URI
Access Preview Print	Critical	GET	Detected	hd/employee-schedules/access-preview/print
Employee Portal Access Preview Print	Critical	GET	Detected	hd/employee-schedules/employee-portal/access-preview/print
Access Preview	Critical	GET	Detected	hd/employee-schedules/access-preview
User Mapping Audit	Optional	GET	Detected	hd/employee-schedules/user-mapping-audit
Access Prep	Optional	GET	Detected	hd/employee-schedules/access-prep
Scheduling Hub	Critical	GET	Detected	hd/employee-schedules/hub
Employee Portal	Critical	GET	Detected	hd/employee-schedules/employee-portal
My Schedule	Critical	GET	Detected	hd/employee-schedules/employee-portal/my-schedule
Weekly View	Critical	GET	Detected	hd/employee-schedules/employee-portal/weekly

Controller / View / Route File Checks

File	Status
Access Preview Print Controller /home/at4txjiyemp4/public_html/hdsportszone.com/app/Http/Controllers/Hd/EmployeeSchedules/EmployeeScheduleAccessPreviewPrintController.php	Present
Access Preview Print View /home/at4txjiyemp4/public_html/hdsportszone.com/resources/views/hd/employee_schedules/navigation/access_preview_print.blade.php	Present
Access Preview Controller /home/at4txjiyemp4/public_html/hdsportszone.com/app/Http/Controllers/Hd/EmployeeSchedules/EmployeeScheduleAccessPreviewController.php	Present
Clean Navigation Partial /home/at4txjiyemp4/public_html/hdsportszone.com/resources/views/hd/employee_schedules/_clean_nav.blade.php	Present
Navigation Route File /home/at4txjiyemp4/public_html/hdsportszone.com/routes/hd_employee_schedule_navigation.php	Present

Table Checks

Table	Status	Rows
Users users	Present	0
Employees employees	Not Detected	0
HD Employees hd_employees	Present	4
Staff staff	Not Detected	0
HD Staff hd_staff	Not Detected	0
Published Shifts hd_published_shifts	Present	1
Published Schedule Periods hd_published_schedule_periods	Present	1

Next Recommended Phase

1. Keep it read-only.
2. Confirm mapping path and anonymized preview results.
3. Do not enforce permissions yet.
4. Do not change middleware or auth config.
5. Do not show employee names or emails.
6. Do not send notifications or touch payroll, Time Clock, POS shifts, reservations, payments, waivers, customer profiles, exports, or locking.