Ask BESY!

If you spot anything incorrect or believe that a report could be improved, please respond by posting a comment (scroll down to the bottom).

To run a report follow the steps below:
1) From the Veryan SQL main menu click the Local Queries and reports link
2) Select the Reports tab
3) Select the desired report from the list
4) Click the Run button

This will display all pages of the report in a Print Preview window. Use the navigation buttons at the bottom of the window to move between pages.

 - To print all pages, click the Print button (displaying the printer icon).
 - To print selected pages only, click File > Print... and enter the first and last page numbers of the required page range in the relevant boxes.

Click the  Close button when done.

BESY:AvailableJobsInBatch
Lists available placements for a specific school batch. Ordered by Opp classification. Prompts for school batch.

BESY:AvailableJobsInPerion
Lists any available placements between 2 dates. Option to print for a single area [BDRS] or all. Ordered by Opp classification. Prompts for Placement date from, date to, then area.

BESY:Duplicate Providers + Opps grouped
Originally used after the 4 area databases were merged, to identify duplicated providers and opps; these were then merged and removed. The report lists companies with the same NAME and POSTCODE; also lists all the jobs for each.

BESY:WPl Placements only
Lists Placement info for a specific school batch, sorted in client name order. Prompts for school batch and batch start date.

BESY:WPl Placements only - Grouped
ement info for a specific school batch, grouped by Tutor Group and sorted in client name order. Prompts for school batch and batch start date.

BESY:WPl School Placements
Lists Placement and Placement History info for a specific school batch, sorted in client name order. Prompts for school batch and batch start date.

BESY:WPl School Placements - Grouped
Lists Placement and Placement History info for a specific school batch, grouped by Tutor Group and sorted in client name order. Prompts for school batch and batch start date.