OTBI Report: Missing Seniority, Entitlement, and Vacation Balance

I’m building the Employee Vacation and Sick Leave Balance Report in OTBI with the following filters:

1. Assignment Status is in Active – No Payroll, Active – Payroll Eligible
2. Seniority Rule Name is Custom Seniority Date
3. Assignment Status Type is Active
4. Assignment Category is not Subcontractor or Union

However, I’m running into a few issues:

1. Seniority Date: The formula I used for the seniority date is coming up blank in the report.
2. Yearly Entitlement: I can’t pull this directly because it’s embedded in a plan called Vacation Leave Plan. This plan has different accrual rules depending on the employee’s service (15, 20, 22, 25, or 30 days), and I can’t figure out how to extract that information dynamically.