1. Once a course has passed it's end date the course will be moved to this page for users to complete any administrative work.
  2. The Course roster will pull courses with active status first. Once a class past the two year mark it's status will automatically be changed to inactive, if staff has not already done so.
  3. On the the completed course detail page will have the status drop down for staff to change status.
Local Union Kingston (1) Pasco (3) Utah (4) Spokane (5) Satsop (6) DesMoines (8)
121-Eugene/Springfield, OR 96 144 101 72 241
121-Hermiston,OR 101 56 30 92 180
121-Bend,OR 111 122 79 84 205
238-Spokane, WA 114 30 43 107 221
ID MIN HOURS MAX Hours INS Amount
1 0 23 5.60
2 24 40 7.00
3 41 80 14.00

Below are the tables that exist now in the database. I built the UX based on them.


tblLocalUnionTravelPay


tblInsuranceAmounts.jpg