Eligible employees {EMPLOYEE.EMP_STATUS}in["A","L"]AND {EMPLOYEE.FTE_TOTAL}>=.40 OR
Employees who have lost eligibility in the past 7 days due to status change {PAEMPPOS.DATE_STAMP}IN {?Date_Report}TO {?Date_Report}-6 AND {PAEMPPOS.FTE} >= 0.4 and {EMPLOYEE.FTE_TOTAL}< 0.4 and {EMPLOYEE.FTE_TOTAL}<>{PAEMPPOS.FTE} OR
Employees who have termed in the last 7 days {EMPLOYEE.EMP_STATUS} IN ["U","TP"] and {EMPLOYEE.NBR_FTE} >=.40 and {PAEMPPOS.DATE_STAMP} IN {?Date_Report}TO {?Date_Report}-6 Can anyone give me some good reasons why we wouldn't want to evaluate off of FTE in the PAEMPPOS table? Thank you, Sarah