Generic Job Descriptions
... Veryan database, how do I do it? 1) From the Veryan SQL main menu click the Local Queries and reports link 2) Select the Reports tab 3) Select the BESY Generic Job Descriptions report from the l...
- Veryan Reports for Work Placement
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 ...
- Event summary report - by date
To run an event summary report by date:
Local Queries and Reports
Reports
Event current status report - date range
enter start date e.g. 01/06/08
enter end date e.g. 01/08/08
re...
- Importing Reports
This article is useful if you need to import one or more reports from a personalised version of the database into the main database.
Make a note of the names of all the reports you wish to impor...
- Data cleansing - Providers
DUPLICATE PROVIDERS
1. Before starting, print the Provider Report for the one you will be deleting:
-Main Menu> Local Queries and Reports>Reports Data Cleansing - PROVIDER REPORT>Run
...
- Data cleansing - Opportunities
...K, then Print.
2.Identify which Opportunity is to be the Live one:
-Compare Job details on each report. You may need to consult with a member of the Work Experience or Health & Safety teams.
3.T...
- Data cleansing - Provider Staff
DUPLICATE PROVIDER STAFF
1. Print Provider Staff reports for the records to be deleted:
-Main Menu> Local Queries and Reports>Reports Data Cleansing - PROVIDER STAFF REPORT>Run
- when ...
- Printing Annual Analysis of WE activity by sector
...inting Annual Analysis of WE activity by sector (diploma).
Explanation
This set of queries and reports were inspired by similar ones in a report by Redbridge BEP (ReBEP). B&E's versions can be ru...
- Schools Activity report
The Schools - Activity - SUMMARY CT report can be found in the STATS2000 front-end. Shows all WEX and GEBLA activity per school, analysed by type of intervention. Figures relate to placements, not ind...
- Switch vacant placements to a different school batch - Part 2
When part 1 of this process has been completed please run the following report (from main Veryan screen): BESY:AvailableJobsInBatch Enter details of batch to view and amend details accordingly.
- School dates query
To report on dates for Work Experience, qurey can be found in: Peters DB - Schools - activity - batches
- Industry Links reports - generated from Star downloads
...fy which businesses would like to be involved in additional activity. To generate a Industry links report, showing a business' requested involvement, please follow the procedure below: Choose any pr...
- Amend student details in webview
...bottom of the page. Part 2. Sheffield schools - follow the process to download and create variance report. Then follow the process to upload clients, except, when importing into Webview, use Import s...
- Complaints process
...plaint should be presented to the SMT as soon as possible for review
All complaints should be reported to Peter
Davies for inclusion in the monthly complaints report
The customer who...
- Local Authority - Monthly report
To create an LA monthly report, the following queries should be run: Q - 4 - Schools Activity - Summary CTQ - 4 - Schools Activity - Summary CT Q - 1 - Schools - block projected activity - summary C...
- Block activity projected - Batches
To be able to run a report identifying the status of placements/students in a batch, run the following query: Local queries and reports Select 1A_SCHOOLS - BLOCK PROJECTED ACTIVITY - SUMMARY CT Run:...
- Employer / Provider report
To create an Employer / Provider report run the report: The report is situated in STATS DB: DATA CLEANSING - PROVIDER REPORT