...

The program has the ability to optionally create spreadsheets. These spreadsheets can be used by any district, but may be particularly helpful to those districts on GAAP.

Wage Obligation By Employee calculation explanation

Accrued Wages

Accrued wages on the wage obligation reports is calculated as follows:

If the compensation contract days worked is >= the compensation contract work days OR if the work days remaining for the compensation plus contract days worked is equal to the contract work days, then accrued wages is compensation contract obligation - amount paid - amount docked

If neither of the above are true, then we determine the daily rate from the compensation and accrued wages is calculated as (days remaining in contract * compensation daily rate) + (compensation amount earned - amount paid - amount docked)

Accrued wages that is shown on the compensation detail is just earnings - amount paid - amount docked.  

This report was written based upon the classic USPS report calculations.

Contract Remaining

The Contract Remaining = Contract Obligation - Amount Paid.

Criteria to be included

1. Wage Obligation initial query includes a compensation based on the following
   1. Legacy or Contract
      
   2. Position Job Status Active
   3. Contract Amount greater than 0
   4. Date Range start date before report as of date OR null
      
   5. Date Range stop date after report as of date OR null
   6. If include Position of Archived Employees = false
      1. Position → Employee archived must be false
      2. Position archived must be false
   7. If filtering by Employee, then search for only compensations that match the employee(s)
   8. If filtering by Pay Group, then search for only position that match the pay group(s)
   9. Appointment Type Options filter checks Appointment Type on position matches
2. Wage Obligation Filtering
   1. if  (Compensation → Compensation Amounts → Pays Paid >= Compensation→ Pays In Contract)
      1. return false and filter
      2. else return true and include
   2. if (Compensation → Contract Work Days = 0 OR Compensation → Contract Work Days IS NULL)
      1. return false and filter
      2. else return true and include

...