Spreadsheet: 691347d1597658171-pivot-table-picking-up-two-of-the-same-category-sample-jobs-data-with-pivot-table
Sheet: IPS DataSheet

ID No | Consent | Name                   NOT SHARED WITH GENIO | Status | ACTIVE STATUS | [NAME] | Date of exit from IPS programme | Reason for exiting IPS programme | Gender | Birth Year | Referral Pathway | Referral            Date | 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 | JOB 1 | 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) | 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 | Reason              (E1) | Notes | JOB 2 | Date of 2ND job | Employed/Self Employed (E2) | Job Title (E2) | Employer Type (E2)               Please enter the type of business of employer here (Retail, Childcare, Restaurant, Car repairs etc. | Employer   (E2)                                     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    (E2)        Part time is defined as under 29 hours per week | Job                Perm/Temp               (E2) | Wage Earned (E2) approx. Please select the band below. | Impact on DEASP Payments    (E2) | Disclosure to Employer          (E2) | Employer Supports                    (E2) | If yes,                               please                         indicate                               the types                                of support               provided.                            (E2) Dropdown provided | Date of Leaving (E2) | DURATION OF JOB 2 | Reason              (E2) | Job 3 | Date of 3ND  job | Employed/Self Employed (E3) | Job Title (E3) | Employer Type (E3)                                            Please enter the type of business of employer here (Retail, Childcare, Restaurant, Car repairs etc. | Employer   (E3) | Job Type    (E3)        Part time is defined as under 19 hours per week | Job                Perm/Temp               (E3) | Wage Earned (E3) approx. Please select the band below. | Impact on DEASP Payments    (E3) | Disclosure to Employer          (E3) | Employer Supports                    (E3) | If yes,                               please                         indicate                               the types                                of support               provided.                            (E3) Dropdown provided | Date of Leaving (E3) | DURATION OF JOB 3 | Reason              (E3) | Job 4 | Date of 4TH  job | Employed/Self Employed (E4) | [NAME] (E4) | Employer Type (E4)                                            Please enter the type of business of employer here (Retail, Childcare, Restaurant, Car repairs etc. | Employer   (E4) | Job Type    (E4)        Part time is defined as under 19 hours per week | Job                Perm/Temp               (E4) | Wage Earned (E4) approx. Please select the band below. | Impact on DEASP Payments    (E4) | Disclosure to Employer          (E4) | Employer Supports                    (E4) | If yes,                               please                         indicate                               the types                                of support               provided.                            (E4) Dropdown provided | Date of Leaving (E4) | DURATION OF JOB 4 | Reason              (E4) | Job 5 | 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. | Employer   (E5) | 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) | Disclosure to Employer          (E5) | Employer Supports                    (E5) | If yes,                               please                         indicate                               the types                                of support               provided.                            (E5) Dropdown provided | Date of Leaving (E5) | DURATION OF JOB 5 | Reason              (E5) | SHOULD YOU REQUIRE ANY MORE JOB COLUMNS PLEASE CONTACT GENIO
1 | yes | Conor Goulding | Job Search |  |  |  |  | Male | 25-31 years old | primary | 2020-05-26 00:00:00 | 2020-06-02 00:00:00 | 18 | Yes | Third Level |  |  | 15 | 0 | 0 | 2020-07-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1st face to face meeting with Conor on Monday. Did a review of career profile. Mentioned publishing/proof reading as another area of interest. Has applied for 4 jobs this week. Very negative. ES has referred for CBT
 | yes | [NAME] | Job Search |  |  |  |  | Male | 45-54 years old | primary | 2020-05-25 00:00:00 | 2020-05-28 00:00:00 | 36 | Yes | Third Level | 2020-06-15 00:00:00 |  | 16 | 1 | 0 | 2020-06-19 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Meeting today for 1st face to face. ES has forwarded his [NAME] on to Spirasi and spoken to Director who has said will give ML an interview at the beginning of Sept
3 | yes | [NAME] | Job Search |  |  |  |  | Male | 35-44 years old | primary | 2020-05-18 00:00:00 | 2020-05-19 00:00:00 | 36 | No | Third Level | 2020-07-10 00:00:00 |  | 12 | 1 | 0 | 2020-06-25 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ES has been speaking to TTM Healthcare and CPL about lab aide roles and has forwarded his [NAME] on. He is now in their database but not many of these jobs at the moment
 | yes | Noreen Monahan | Paused |  |  |  |  | Female | 45-54 years old | primary | 2020-05-15 00:00:00 | 2020-06-11 00:00:00 | 120 | Yes | Secondary Level | 2020-07-23 00:00:00 |  | 3 | 0 | 0 | 2020-06-27 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ES has phoned and emailed Noreen this week and last week but she hasn’t got back in touch. Told by the OT that’s she is having financial and domestic issues and isnt able to deal with IPS at the moment
5 | Yes | [NAME] | Vocational Profiling |  |  |  |  | Male | 18-24 years old | Primary | 2020-07-10 00:00:00 | 2020-07-21 00:00:00 | 7 | No | Secondary Level | 2020-07-28 00:00:00 |  | 4 |  |  | 2020-07-28 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1st face to face meeting with [NAME] on Wednesday. Has provided a soft copy of 1st draft of CV. ES has suggested some changes
6 | Yes | [NAME] | Vocational Profiling |  | UNEMPLOYED |  |  | Male | 35-44 years old | Primary | 2020-07-21 00:00:00 | 2020-07-29 00:00:00 | 72 | Yes | Third Level |  |  | 1 |  |  | 2020-08-14 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1st face to face meeting with [NAME] on Wednesday. Worked on his CV. Produced an incomplete CV and ES suggested changes
 | No | [NAME] | Referral |  |  |  |  | Male |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Called [NAME] times last week and twice this week but no answer and cant leave a message. Sent a letter following advice from OT that if havent heard from him by 19th Aug will assume he doesn’t wish to avail of IPS
 | Yes | [NAME] | Vocational Profiling |  |  |  |  | Female | 55-64 years old | Primary | 2020-08-06 00:00:00 | 2020-08-14 00:00:00 |  | Yes | Third Level |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1st face to face meeting with [NAME] on Thursday. Spent most of the session working on her CV, at her request. Has given consent for data collection and sharing.