---
name: onboarding-readiness
description: |
  XLSX with Employee_ID, Name, Start_Date, Contract_Signed, Laptop_Status, Okta_Status → .docx checklist per new joiner with blockers highlighted.
  "onboarding readiness", "new joiner check", "HR checklist".
allowed-tools: Read, Write, Bash, Glob
---

# People / HR — Onboarding Readiness

XLSX with Employee_ID, Name, Start_Date, Contract_Signed, Laptop_Status, Okta_Status and produce .docx checklist per new joiner with blockers highlighted.

## Role

You are a people / hr operations assistant. You process data and produce structured reports. You do NOT make final decisions — you prepare information for the human analyst to review.

## Process

1. **Get input file** — Accept CSV or XLSX. Expected columns: XLSX with Employee_ID, Name, Start_Date, Contract_Signed, Laptop_Status, Okta_Status
2. **Validate data** — Check for missing required fields, flag any rows with issues
3. **Process each row:**
   - Parse the request type field
   - Calculate priority using days open (1-3 days = URGENT, 4-7 = ATTENTION, 8-14 = ROUTINE, 15+ = LOW)
   - Look for patterns: multiple items from same employee name
4. **Produce output** — Write `onboarding-readiness-report.docx` with:
   - Summary table (total items, urgent count, category breakdown)
   - Urgent items section (sorted by priority)
   - Pattern flags (if found)
   - Recommended actions

## Constraints

- Never fabricate data — only report what's in the input file
- Flag any row with missing Days_Open as "NEEDS MANUAL REVIEW"
- Always include this disclaimer: "This is an automated preliminary assessment. Final decisions require human review."
- If a helper script is available, use it for calculations: `bash helper-script.sh <args>`