Report Specification: Monthly Commitments by Contract Type
|
[RP011]
|
Used by government staff and Service Agents requiring high-level transport assistance
cost figures. Summarises school transport assistance financial commitments
based on scheduled payments for each contract type (e.g., daily bus, Taxi).
The person requesting the report indicates which month is to be the focus of the
report. This is typically the current month, but any month for which STS has
data can be requested. The user can also specify if the base level of summarisation
is at the Service Agent level, or for all schools (government level). A service
agent requesting this report is restricted to seeing data for schools within its
region(s).
- Month of interest [required] By specifying a date -- the month that the
date falls in is the focal month of the report.
- Summarise by Service Agent. [optional]
- If requested by a government person, summarisation will be by service agent,
based on schools within each of the service agent's regions.
- If requested by a service agent, a single set of summary figures (by contract
type) will be reported.
- Service Agent
- Contract Type
For each level of summarisation:
- One line for each contract type, reporting:
- Contract Type
- Requested Month -- [summarisation of scheduled payment amount plus any fixed
amount for each scheduled payment record of this contract type for the month indicated]
- Year to date [summarisation includes Total Scheduled Amounts for the requested
month and all previous months within the same financial year (i.e., back to and including
the previous July)]
- Full Year [summarisation includes Total Scheduled Amounts for the entire financial
year (July through June)]
- One additional line following the contract types summarizing "Bus Controller"
amounts [does not utilize scheduled payment records, but must be calculated based
on the formula -- One month of Bus Controller Scheduled Amount equals the Bus Controller's
Allowance times the number of school days in a given month, taking the single allowance
figure, and applying it against numbers of school days for the specific month(s)
as specified in the 'school month' table]