Open $vms_url and go to timesheets for the week ending $week_ending.

Instructions

Open $vms_url and go to timesheets for the week ending $week_ending.
For each contractor, read: contractor_name, req_id, hours, status, approver.
Return every timesheet whose status is not Approved, grouped by approver, with a count per approver.
Save each timesheet keyed by contractor_name and week_ending.

You provide “vms_url”, “week_ending” each time you run it.