Spreadsheet: 683070d1592474146-conditional-formatting-based-on-dates-in-cells-query-job-sheet-sample
Sheet: IPS DataSheet

ID No | Consent | Name                   NOT SHARED WITH GENIO | Status | ACTIVE/ INACTIVE | CURRENT EMPLOYMENT STATUS | Gender | Birth Year | Referral Pathway | Referral            Date | RE-Referral (Only complete with YES if person is re-referred to the programme.  Please enter date of re-referral in the column beside it. There are space for 3 re-referals at present. More can be added if necessary) | DATE OF RE-REFERRAL 1 | DAT E OF REFERRAL 2 | Date of                                                      Initial  Employment Assessment | Length of time unemployed | Is the person in receipt of a payment from the Dept. of Employment Affairs and Social Protection? (DEASP) | Current education level | Date of first face to face contact with employer | Days between employment assessment and employer contact | Jobs applied for to date | Interviews to date | Jobs Secured to date | Date first job application | Date of first job | Employed/Self Employed (E1) | Job Title (E1) | Employer Type (E1)               Please enter the type of business of employer here (Retail, Childcare, Restaurant, Car repairs etc. | Employer   (E1)                                     This is a requirement for Fidelity Reviews. A list of all employers is created in the Employers List below for you. THIS IS NOT SHARED WITH GENIO | Job Type    (E1)        Part time is defined as under 19 hours per week | Job                Perm/Temp               (E1) | Wage Earned (E1) approx. Please select the band below. | Impact on DEASP Payments    (E1) | If yes,                   please indicate  change                     (E1) | Disclosure to Employer          (E1) | Employer Supports                    (E1) | If yes,                               please                         indicate                               the types                                of support               provided.                            (E1) Dropdown provided | Date of Leaving (E1) | Duration of Job 1 (E1) (Calculates to today if job is ongoing) | Reason              (E1) | Date of exit from IPS programme | Reason for exiting IPS programme | IF THE PERSON WAS RE-REFERRED TO THE PROGRAMME, PLEASE ENTER NEW DATE OF EXIT FROM PROGRAMME HERE | DATE OF RE-REFERRAL EXIT 2 | JOB 2 | Date of 2nd job application | Date of 2nd job interview | Date of 2nd                            job secured | What type of job did the person secure? (2nd Job) | Is the 2nd job full time or part-time? | What is the weekly wage being earned? (2nd job) | Has securing this job had an effect on their state benefits? (2nd job) | If yes, please indicate the change in benefits being claimed. (2nd job) | Difference in benefits claimed in euro (2nd Job) | Has the person disclosed their Mental health conditon to their employer? (2nd Job) | Has the employment specialist been supporting the employer in this case? (2nd Job) | If yes, please indicate the types of support that have been given to the employer (2nd Job) | Date of end of employment 2 | Duration of Job 2 (E2) | Reason for end of employment 2 | JOB 3 | Date of 3RD job application | Date of 3RD job interview | Date of 3RD                           job secured | What type of job did the person secure? 3RD job | Is the job full time or part-time? 3RD | What is the weekly wage being earned? | Has securing this job had an effect on their state benefits? | If yes, please indicate the change in benefits being claimed | Difference in benefits claimed (euro) | Has the person disclosed their Mental health conditon to their employer? | Has the employment specialist been supporting the employer in this case? | If yes, please indicate the types of support that have been given to the employer | Date of end of employment 3 | Reason for end of employment 3 | JOB 4 | To enter details of employment 5                              SELECT UNHIDE | To enter details of employment 6                               SELECT UNHIDE | Date of 4nd job application | Date of 4nd job interview | Date of 4nd                            job secured | What type of job did the person secure? (4th Job) | Is the 4th job full time or part-time? | What is the weekly wage being earned? (4th job) | Has securing this job had an effect on their state benefits? (4th job) | If yes, please indicate the change in benefits being claimed. (4th job) | Difference in benefits claimed in euro (4th Job) | Has the person disclosed their Mental health conditon to their employer? (4thJob) | Has the employment specialist been supporting the employer in this case? (4th Job) | If yes, please indicate the types of support that have been given to the employer (4th Job) | Date of end of employment 4 | Reason for end of employment 4 | JOB 5 | Date 5th job application | Date of 5th job | Employed/Self Employed (E5) | Job Title (E5) | Employer Type (E5)               Please enter the type of business of employer here (Retail, Childcare, Restaurant, Car repairs etc. | Job Type    (E5)        Part time is defined as under 19 hours per week | Job                Perm/Temp               (E5) | Wage Earned (E5) approx. Please select the band below. | Impact on DEASP Payments    (E5) | If yes,                   please indicate  change                     (E5) | Disclosure to Employer          (E5) | Employer Supports                    (E5) | If yes,                               please                         indicate                               the types                                of support               provided.                            (E5) Dropdown provided | Date of Leaving (E5) | Reason              (E5) | JOB 6 | Date 6th job application | Date of 6th job | Employed/Self Employed (E6) | Job Title (E6) | Employer Type (E6)               Please enter the type of business of employer here (Retail, Childcare, Restaurant, Car repairs etc. | Job Type    (E6)        Part time is defined as under 19 hours per week | Job                Perm/Temp               (E6) | Wage Earned (E6) approx. Please select the band below. | Impact on DEASP Payments    (E6) | If yes,                   please indicate  change                     (E6) | Disclosure to Employer          (E6) | Employer Supports                    (E6) | If yes,                               please                         indicate                               the types                                of support               provided.                            (E6) Dropdown provided | Date of Leaving (E6) | Reason              (E6) | JOB 7 | Date 7th job application | Date of 7th job | Employed/Self Employed (E7) | Job Title (E7) | Employer Type (E7)               Please enter the type of business of employer here (Retail, Childcare, Restaurant, Car repairs etc. | Job Type    (E7)        Part time is defined as under 19 hours per week | Job                Perm/Temp               (E7) | Wage Earned (E7) approx. Please select the band below. | Impact on DEASP Payments    (E7) | If yes,                   please indicate  change                     (E7) | Disclosure to Employer          (E7) | Employer Supports                    (E7) | If yes,                               please                         indicate                               the types                                of support               provided.                            (E7) Dropdown provided | Date of Leaving (E7) | Reason              (E7) | JOB 8 | Date 8th job application | Date of 8th job | Employed/Self Employed (E8) | Job Title (E8) | Employer Type (E8)               Please enter the type of business of employer here (Retail, Childcare, Restaurant, Car repairs etc. | Job Type    (E8)        Part time is defined as under 19 hours per week | Job                Perm/Temp               (E8) | Wage Earned (E8) approx. Please select the band below. | Impact on DEASP Payments    (E8) | If yes,                   please indicate  change                     (E8) | Disclosure to Employer          (E8) | Employer Supports                    (E8) | If yes,                               please                         indicate                               the types                                of support               provided.                            (E8) Dropdown provided | Date of Leaving (E8) | Reason              (E8) | JOB 9 | Date 9th job application | Date of 9th job | Employed/Self Employed (E9) | Job Title (E9) | Employer Type (E9)               Please enter the type of business of employer here (Retail, Childcare, Restaurant, Car repairs etc. | Job Type    (E9)        Part time is defined as under 19 hours per week | Job                Perm/Temp               (E9) | Wage Earned (E9) approx. Please select the band below. | Impact on DEASP Payments    (E9) | If yes,                   please indicate  change                     (E9) | Disclosure to Employer          (E9) | Employer Supports                    (E9) | If yes,                               please                         indicate                               the types                                of support               provided.                            (E9) Dropdown provided | Date of Leaving (E9) | Reason              (E9) | JOB 10 |  |  |  |  | JOB TIME CALCULATOR
10001 | Yes | [NAME] | Job Search |  |  | Male | 18-24 years old | Primary | 2018-08-09 00:00:00 |  |  |  | 2018-03-01 00:00:00 | 12 | Yes | Primary Level | 2018-06-01 00:00:00 |  | 3 | 3 | 2 | 2018-08-01 00:00:00 | 2018-09-02 00:00:00 | Employed | Kitchen Assistant | Restaurant | Galleon Restaurant | Full-Time | Permanent | €51 to €100 per week |  | No longer receiving Job seekers benefit | Yes |  | Provide Information (booklets etc.) | 2019-11-01 00:00:00 |  | new job |  |  |  |  |  | 2019-07-08 00:00:00 | 2019-07-29 00:00:00 | 2019-07-30 00:00:00 | Manufacturing | Full time | 400 | Yes | Total loss of DA | 200 | No | No |  | 2019-11-30 00:00:00
10002 | Yes | [NAME] | Paused |  |  | Female | 35-44 years old | Primary | 2018-08-09 00:00:00 |  |  |  | 2018-03-02 00:00:00 | 35 | Yes | Secondary Level | 2018-05-01 00:00:00 |  | 3 | 2 |  | 2018-09-01 00:00:00 |  | Employed | Childcare Assistant | Childcare | Star Creche | Part-Time | Permanent | €151 to €200 per week |  |  | No |  | Face to face meetings |  |  |  |  |  |  |  |  | 2019-03-29 00:00:00 | 2019-04-02 00:00:00 | 2019-04-05 00:00:00 | Retail | Full time | 400 | No |  |  | Yes | No |  | 2019-05-16 00:00:00
10003 | Yes | [NAME] | In work Support |  |  | Male | 55-64 years old | Primary | 2017-08-01 00:00:00 |  |  |  | 2018-03-10 00:00:00 | 3 | Yes | Third Level | 2018-04-04 00:00:00 |  | 3 | 2 | 2 | 2018-09-02 00:00:00 | 2020-01-01 00:00:00 | Employed | Sales Assistant | Retail | Penneys | Full-Time | Temporary/Time-limited | €51 to €100 per week |  |  | Yes |  |  | 2020-05-03 00:00:00 |  | better pay |  |  |  |  |  | 2019-08-01 00:00:00 | 2019-08-07 00:00:00 | 2019-08-29 00:00:00 | School | part time | 200 | No |  |  | Yes | No |  |  |  |  |  |  | 2019-08-27 00:00:00 | 2019-10-16 00:00:00 | [NAME] | Part time | 0-50 | No |  |  | Yes | Yes | Phone Support during recruitment |  | [NAME] |  |  |  | 2019-11-29 00:00:00 | 2019-12-06 00:00:00 | 2019-12-06 00:00:00 | Industrial Cleaning | Part time | €101-150 | Yes | reduction in weekly Disability allowance plus, any days worked with other part time role, means a significant reduction of DA. | €15 every week, plus reductions relating to event based [NAME] rugby game dates) | Yes | No |  | [NAME]
10004 | Yes | June Smith | Employment Start |  |  | Female | 65-74 years old | Primary | 2018-09-09 00:00:00 |  |  |  | 2018-03-19 00:00:00 | 24 | No | None | 2018-05-01 00:00:00 |  | 3 | 2 | 1 | 2018-09-03 00:00:00 | 2019-03-01 00:00:00 | Employed | Factory Operative | Manufacturing | Fish Factory | Unsure | Temporary/Time-limited | €10 to €50 per week |  |  | No |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2019-05-15 00:00:00 | 2019-05-17 00:00:00 | 2019-05-20 00:00:00 | Hotel | Full time | 365 | no |  |  | Yes | Yes | Phone support | 2020-02-14 00:00:00 | New job offer with more pay/better working conditions |  |  |  | 2020-01-10 00:00:00 | 2020-01-21 00:00:00 | 2020-01-27 00:00:00 | Domestic Attendant | Full time | 550 | No |  |  | Yes | Yes | Onboarding process and check [NAME] actively refers client back to ES for support | [NAME]
10005 | Yes | [NAME] | Exited |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 2 | 1 | 2018-09-04 00:00:00 | 2019-03-01 00:00:00 | Employed | Factory Operative | Manufacturing | Fish Factory | Unsure | Temporary/Time-limited | €10 to €50 per week |  |  | No |  |  | 2019-10-04 00:00:00 |  | Unwell