import pandas as pd
from datetime import datetime
def check_onboarding_step(emp_id, step):
# Check if onboarding step is complete
status = pd.read_sql("SELECT status FROM onboarding WHERE emp_id = ? AND step = ?", (emp_id, step))
return status[0] if status else 'pending'
def generate_onboarding_plan(emp_id):
# Create onboarding workflow
steps = ['docs', 'it', 'training', 'access', 'mentor', 'review']
return {step: check_onboarding_step(emp_id, step) for step in steps}