How does the Reporting Tool calculate ….
… number of referrals to the service?
The referral date is defined as the date the referral was received by the employment specialist and accepted onto their caseload. The tool calculates the number of referrals in a quarter by summing together every client whose referral date (contained within the column called “Referral date”) falls within the quarter which is being submitted. If a client’s referral date is left blank they will not be counted.
… number of referrals where the client is already in employment?
IPS may work with a small number of clients who are employed upon referral but who are either on sick leave or have a job at risk. Clients who are already in employment may be supported to retain their jobs or move to a new job. It is recommended that job retention cases take up no more than 15% of the caseload.
… number of clients who have started a vocational profile?
A vocational profile is usually started at the first face to face meeting. Once work on the vocational profile has started the client is considered active/engaged. This calculation counts the number of clients that have not yet been discharged (and therefore do not have a discharge date) but whose referral date (contained within the column called “Date Vocational Profile Started”) falls within the dates submitted. If a client’s vocational profile start date is left blank they will not be counted.
… number of clients supported into work?
The number of unique service users who have been supported into employment during the reporting period in question. This metric counts first job starts only. The service user should have completed 4 hours of paid work for a job start to be counted.
… total number of job starts?
The total number of jobs started in the reporting period in question. This could include second or third jobs, or multiple part-time jobs. The metric counts the number of jobs that have been given a start date in the reporting period in question.
… 13 and 26-week sustainments?
This is the same as the number of clients still in work 13 and 26 weeks after they started a job.
If you are using the IPS Grow Standard Spreadsheet, the Reporting Tool can automatically calculate sustainments for you, using the following definition:
Sustained employment is measured regardless of whether this duration was accrued over the same job or multiple jobs. Breaks in employment for clients with multiple jobs must be less than 6 weeks between jobs. If a gap of more than 6 weeks occurs, the clock will reset and sustainments will be calculated from the start date of the subsequent job. Only one job sustainment outcome of each duration (13, 26 weeks) will be counted for each person referred into the service.
If no Job End Date has been entered for a client’s employment, the tool will assume that the employment is ongoing and will use the current date to calculate length of employment. The tool then counts the number of service users who have hit the milestone of completing 13 of 26 week sustained employment during the reporting period in question. This can be made up of multiple jobs, provided that there is no more than a 6 week gap in between any 2 jobs. If a service user has an overlap between 2 jobs (e.g. is working 2 or more jobs at once) only 1 job will be counted per day of work so that the overlap isn’t double-counted. Only one 13 week sustainment outcome is counted for each client, and only one 26 week sustainment outcome is counted for each client.
Alternatively you can manually record your 13 and 26 week sustainments.
… average number of days from starting the vocational profile to face to face contact with an employer?
The tool calculates the number of days in between a vocational profile start (the date entered under the ‘Date vocational profile started’ column) and a the first face to face with an employer (the date entered under ‘Date of first face to face contact with the employer’). This is done for each service user who has a face to face meeting with an employer within the reporting period in question.
To calculate the average number of days, the tool sums the number of days for each service user in question and divides the figure by the total number of service users being considered.
The tool does not consider any rows where the date in either of the columns is blank.
… average number of days from referral to first attempted contact by an Employment Specialist?
The tool calculates the number of days in between a referral (the date entered under the ‘referral date’ column) and first attempted contact (the date entered under the ‘Date of first attempted contact’ column). This is done for each service user who has an attempted contact date that lies within the reporting period in question.
To calculate the average number of days, the tool sums the number of days for each service user in question and divides the figure by the total number of service users being considered.
The tool does not consider any rows where the date in either of the columns is blank.
… average number of days from referral to starting the vocational profile?
The tool calculates the number of days in between a referral (the date entered under the ‘referral date’ column) and a vocational profile being started (the date entered under the ‘Date vocational profile started’ column). This is done for each service user who has an attempted contact date that lies within the reporting period in question.
To calculate the average number of days, the tool sums the number of days for each service user in question and divides the figure by the total number of service users being considered.
The tool does not consider any rows where the date in either of the columns is blank.
… average number of days from a client starting their vocational profile to their first job start?
The tool calculates the number of days in between a vocational profile start (the date entered under the ‘Date vocational profile started’ column) and a the first job start date (the date entered under ‘1st job start date’). This is done for each service user who has a face to face meeting with an employer within the reporting period in question.
To calculate the average number of days, the tool sums the number of days for each service user in question and divides the figure by the total number of service users being considered.
The tool does not consider any rows where the date in either of the columns is blank.
… number of clients discharged from the service?
The tool sums together every client who has a date entered under the column “Discharge date” that falls within the quarter which is being submitted. Service users who have been marked as discharged but do not have a discharge date in the “Discharge date” column are not counted in this figure…
