How to Complete Yearend EBPS forms
Please click the hyperlink below.
Switch vacant placements to a different school batch
Open the document link below:
Data cleansing - Overview
Please print the attached spreadsheet for instructions.
Block WE Placement Management Queries
These queries show the current status of placements and help management of projected/future activity. However, they may also be used with historical dates. See attachment:
Change of address - Health and Safety process
When a provider changes address, their H&S approval is invalidated as their new premises/location have a bearing on their H&S risk assessment. It is important that the Veryan system is updated to reflect the new address, but there is an issue regarding H&S paper files and continuity. Please fol ...
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 individuals. Also displays school's Webview status. Options at run time: Date Range, School type (P ...
Instructions for producing Employer Request Letters
Please see attachment.
Annual Analysis Charts and Tables
A set of tables and charts extracted from the Veryan database, which analyse available providers and placements by diploma sector. These are found in the Joan2000 front end. Please select Attachment hyperlink below to view full documentation.
Postcodes and LA areas - By LA
LEA Postcode Postcode Areas District Barnsley S35 7 Thurgoland, Wortley Barnsley S36 6 7 8 9 Penistone, Hoylandswaine, Millhouses, Oxspring, Thurlston Barnsley S63 8 9 0 Bolton, Goldthorpe, Thurnscoe Barnsley S70 1 2 3 4 5 6 Barnsley S71 1 2 3 4 Barnsley S72 7 8 9 0 Barnsley S73 8 ...
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 -when prompted enter the Provider name, click OK, then Print. 2. Transfer all provider staff that don't ...
Data cleansing - Opportunities
DUPLICATE OPPORTUNITIES 1.Print the 'Job Description and Placements Report' for each duplicate opp: -Main Menu> Local Queries and Reports>Reports Data Cleansing - OPPORTUNITY REPORT>Run. -when prompted enter the 1st Opp Number click OK, enter the 2nd Opp Number click OK, enter the 3rd ...
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 prompted enter the Provider name, click OK, (Partial entries are allowed, but may give more results tha ...
Merge Duplicate Providers and Opportunities
Please refer to items under the title of 'Data Cleansing...'.
Workplace Entries - Summary
Notes re Veryan database input requirements - SUMMARY ONLY
Invite businesses to an event
PURPOSE: To generate a Mail Merge data file which will be used to invite businesses to an event, and in the process: a) record an Agency Contact for each person invited b) add the business and person to the event record and c) set a status setting for all invitees. CLICK the link below to d ...
Mailmerge - troubleshooting
This article suggests steps to take if you are having trouble with the mailmerge process: Data not appearing correctly Printing in batches after a merge Turning a mailmerge document back into a normal document Display/Hide merge field codes
Provider and Job (opportunity) Classifications
For a list of Provider Classifications see one the following: A full list of all provider classifications: G:\11 - ICT (& VERYAN)\Veryan\Lookup tables\Provider classification.xls Short list of the most used types of business and the code: G:\11 - ICT (& VERYAN)\Veryan\Lookup tables\Provider cla ...
Sending single employer request letters.
Page 1 - Instructions: Browse to I:\Veryan\OtherFiles\EmpRequest\Single letters Double-click the doc called Emp Req letter (page 1). Type the required text into the 4 prompts as they appear. Check for and edit any typing errors. Do not change anything else. Print onto sheet of Letterhead. Close ...
Monthly reporting - Predicted Block Work Placements - query
To show the status of existing block placements, by LA, run the following queries as required : 1 - SCHOOLS FIX PLACEMENTS - PLEASE RUN THIS FIRST --------------------------------------------- 1 - SCHOOLS - BLOCK Projected Activity - Summary CT 1 - SCHOOLS - POST-16 Projected Activity - Summary ...
Industry Links reports - generated from Star downloads
During Health & Safety visits, a part of the process is to identify 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 provider e.g. Asda Click on tab 6: ...