ETO Report Enhancements
There is an upgrade effective 4/17/2023, which affects ETO reports. Please see the summary of changes in this PowerPoint that was reviewed at the 4/5 T12 meeting.
Below are the various categories of ETO reports. Click on the + to expand a category for a list of reports we've already completed work on, including what category the report used to be and where it moved to. If you have questions, please email the WorkSource System Support Team esdgpwssteam@esd.wa.gov
Administrative
| Report | Date | Change(s) |
| Missing Demographics Report - WIT Interface | 6/27/2023 | NEW report to assist in identifying missing data on 4 required TPs |
| Missing Demographics Report - UI Interface | 6/27/2023 | NEW report to assist in identifying missing data on 4 required TPs |
| Non Disclosure Update | 11/3/2021 | Report started to timeout; modified lookback date to 1/1/2020 instead of 7/2016 |
| Staff Created Participants | 8/10/20211 | Had to combine 'Complete' and 'Incomplete' on one tab in order to correct bad opt-out logic |
| Staff Created Participants | 7/20/2021 | Corrected logic to display 'service date' and 'service recorded' data |
| Staff Account Details | 7/9/2021 | Moved here from the 'Operational Reports' category |
| UniqueProgramEnrollmentNames | 7/9/2021 | Moved here from the 'Operational Reports' category |
| Staff Created Participants | 6/23/2021 | NEW--created to monitor staff created participants |
| Enabled User Greater Than 90 Days and Less than 90 Days Since Login | 3/10/2021 | Added new report logic on new tab to include users logged in between 89-60 days; modified initial prompt by WDA instead of Office; modified report name and description |
| Login Report | 3/9/2021 | Moved to 'Uncategorized' category; report only available to Enterprise and Site Managers |
Employer & Job Posting Reports
| Report | Date | Change(s) |
| Staff Provided Business Services | 5/1/2023 | Added 'Contact Method' column |
| Job Postings Report | 11/4/2021 | Modified so all roles can see report |
| Job Postings Report | 10/6/2021 | NEW report to combine 3 separate job postings reports |
| New to WorksourceWA-Employers | 9/14/2021 | Change report name so will be next to recruiter report on list |
|
New to WorksourceWA-Recruiters |
9/14/2021 | Change report name so will be next to employer report on list |
|
Job Match Activity |
6/8/2021 | Added initial date range prompt so report wouldn't pull 2016 data; relocated to Employer & Job Posting Reports category |
|
Business Services |
1/11/2021 | Removed report |
|
Business Services |
12/8/2020 | Added initial prompts for WDA, Office, start/end date range; Office is an optional field |
|
Business Services |
11/9/2020 | Moved here from the ‘My Reports’ category |
|
Staff Provided Business Services |
11/5/2020 |
Added new columns -- Identifier field |
Employer Events & Rapid Response
| Report | Date | Change(s) |
| Employer Events | 11/5/2020 | NEW—created new report for the ‘Employer Events’ TouchPoint |
Job Seekers
| Report | Date | Change(s) |
| Seekers Served--Basic Services | 12/1/2021 | Added 3 new columns - Method of Contact, Other Program and Daily New Hire |
| All Seeker Services History | 7/9/2021 | Updated description; added 'History' to report name; and made report available to all staff |
| Services Planned End Date | 3/9/2021 | Deleted report; reported out at 2/24 T12 meeting this is no longer used |
| Participants New to ETO | 2/23/2021 | Updated report logic to pull based on date demographic details TP created; report identifies how profile created by either staff, WSWA (WIT Integration) or UTAB (UI Interface) |
| Seekers Served--Basic Services | 12/14/2020 | NEW--created new report to list seekers receiving only basic services listed in the service catalog |
Local Reporter Data
| Report | Date | Change(s) |
| Program Enrollment Report – With Demographic Details ORIGINAL report | 10/18/2023 | Unique Enrollment ID was not populating – Now fixed |
| Local Reporter Services Report | 7/26/2023 | Removed Federal EcSA 200% FPL household income column |
| Local Reporter Services Report | 6/26/2023 | Added Federal EcSA 200% FPL household income column |
| Program Enrollment Outcomes | 6/26/2023 | Added Federal EcSA 200% FPL household income column |
| Services Report - Demographics | 10/21/2022 | Updated to add WDC prompt, and two new columns - Office and Veteran |
| Individualized Training and Support Services TPs | 6/28/2022 | Deleted 'Daily New Hire' column |
| Individualized Training and Support Services TPs | 12/22/2021 | Added 'Daily New Hire' and 'Method of Contact' columns |
| Common Measures Exits | 11/10/2021 | NEW--created new report for program enrollments with system exit date on or after specified date |
| Individualized Training and Support Services TPs | 10/6/2021 | Added 'Date Last Updated' column |
| Outcomes TPs based on Completion Date Value | 9/14/2021 | Removed In Youth Program and Program Category columns; moved Opted-Out column after Case Number column |
| Individualized Training and Support Services TPs | 8/23/2021 | Added 'Office' as optional prompt |
| Program Enrollment Outcomes | 8/23/2021 | Added 'Office' as optional prompt |
| Program Enrollment Outcomes | 8/12/2021 | Added email, phone & preferred contact method; deleted 3 unused columns |
| Chronological Seeker Services | 7/9/2021 | Deleted report; duplicate of All Seeker Services History report under 'Job Seekers' category |
| Follow Up TouchPoints | 5/25/2021 | Deleted columns = SSN, Link to Seeker Dashboard, SKIES Seeker ID; also made available to PM role. |
| Individualized Training and Support Services TPs | 5/25/2021 | Deleted column = SKIES ID; also made available to PM role. |
| Local Reporter Services Report | 5/25/2021 | Deleted columns = SSN, SKIES Seeker ID; also made available to PM role. |
| Outcomes TPs based on Completion Date Value | 5/25/2021 | Made available to PM role. |
| Program Enrollment Outcomes | 5/25/2021 | Made available to PM role. |
| Program Enrollment TPs and Attached Services | 5/25/2021 | Added 'Is opted-out' column to both tabs; also made available to PM role. |
| Program Enrollments - Enrollment End Date, Exit Date, Completion Date | 5/25/2021 | Added columns = Seeker Name and Is opted-out; deleted column = Link to Seeker Dashboard; also made available to PM role. |
| Services Report - Demographics | 5/25/2021 | Deleted column = SKIES ID; also made available to PM role. |
| Outcomes TPs based on Completion Date Value | 5/5/2021 | Corrected 'Opted-Out' logic; deleted SKIES Seeker ID, Link to Seeker Dashboard and SSN columns |
| Program Enrollment Outcomes | 4/27/2021 | Added 'Is Opted-Out' column and removed 'SKIES Seeker ID' column; deleted SSN column |
| Program Enrollment Outcomes | 10/28/2020 | Added new column--Annualized Wage; removed Link to Seeker Dashboard; and updated report description |
|
Local Reporter Services Report |
9/23/2020 |
Added new columns--TP Created By and TP Last Updated By |
| Case Management Report – test 3-17-2017 |
9/22/2020 |
Deleted report |
MSFW
| Report | Date | Change(s) |
| Active MSFWs |
11/17/2020 |
Updated to reorder columns & updated business rules to only display participants with questions answered on NEW tab of MSFW Details TP; also added 'Office' to the initial prompt |
| Active MSFWs | 9/29/2020 | Added new columns--Phone Number, Email Address, Preferred Contact Method, Is Opted-Out |
| MSFW Job Referrals on H2A and H2B Jobs | 9/16/2020 | Added initial prompt for start/end date range; added report description; also included headers on 'raw data' tab to indicate where data is pulled from |
Operational Reports
| Report | Date | Change(s) |
| State Funded Services Report | 10/18/2023 | Add field to report: “Did the participant successfully pass an exam that is required for a particular occupation, or progress in attaining technical or occupational skills as evidenced by trade-related benchmarks such as knowledge-based exams” (Yes/No question) |
| Measurable skill gains | 10/18/2023 | Add field to report: Last Updated By |
| Demographic and Veteran Details ORIGINAL report | 10/18/2023 | Add field to report: Household Income greater than 200% FPL |
| Program Enrollment with Limited Demographic Details report | 10/18/2023 | Household Income Greater than 200% of Federal Poverty Level is displaying Yes on reports when the response in ETO is No or blank. – Now fixed |
| State Funded Services | 7/26/2023 | Added 'Type of Resource' and 'Other Resource' columns |
| State Funded Services - Participant Level | 7/26/2023 | Added 'Participant Name' and 'Opted-out' columns |
| Program Enrollment Report With Demographic Details-ORIGINAL | 7/26/2023 | Added Federal EcSA 200% FPL household income column |
| Program Enrollment Report With Limited Demographic Details | 7/26/2023 | Added Federal EcSA 200% FPL household income column |
| Outcomes TouchPoints with Employment Start Date Information | 7/26/2023 | Removed Federal EcSA 200% FPL household income column |
| State Funded Services | 7/3/2023 | Added 'Date TP Entered' column |
| Outcomes TouchPoints with Employment Start Date Information | 6/26/2023 | Added Federal EcSA 200% FPL household income column |
| Program Enrollment Report Without Demographic Details | 6/26/2023 | Added Federal EcSA 200% FPL household income column |
| Activity Log - WSWA Report | 6/26/2023 | Added new 'date submitted' column and updated report logic |
| Case Notes -(no WIT Integration) | 6/15/2023 | Added case notes recorded on the State Funded Services TP |
| Seekers Served by Office | 5/1/2023 | Corrected filter with offices displaying under WDA |
| Seekers Served by Office-ORIGINAL | 5/1/2023 | Corrected filter with offices displaying under WDA |
| Activity Log - Participant Counts | 5/1/2023 | NEW--created for WorkFirst program operator and specialists |
| Activity Log - WSWA Report | 5/1/2023 | NEW--created for WorkFirst program staff to manage workload |
| My Caseload | 3/20/2023 | NEW--created to manage and track staff caseload |
| My Current Caseload User Filter | 3/20/2023 | NEW--created for staff to view their individual caseload |
| State Funded Services - Participant Level | 2/7/2023 | NEW--created new report for days since last state-funded service for clients with active enrollment in program selected |
| State Funded Services | 1/26/2023 | NEW--created new report for State-Funded Services linked with the selected program of enrollment and area |
| Case Notes 4.0-Only Basic Services | 3/7/2022 | Added 'Identifier' and 'Service Provided' columns |
| Case Notes 4.0 (No WIT Integration) | 3/7/2022 | Added 'Identifier' and 'Service Provided' columns; removed OPTIMIZED from report name |
| Case Notes 4.0-No Basic Services Included | 3/7/2022 | Added 'Identifier' and 'Service Provided' columns |
| Case Notes 4.0 (No WIT Integration) OPTIMIZED | 3/1/2022 | Added ‘Identifier’ column |
| Case Notes 4.0-No Basic Services Included | 3/1/2022 | Added ‘Identifier’ column |
| Case Management 'Staff Work' Report | 1/11/2022 | NEW--created new report for services linked to Program Enrollment, including a column of the most recent durational service Last Updated Date. |
| Program Enrollment Report with Demographic and Veteran Details-Limited | 10/21/2021 | Updated report logic so report won't timeout |
| Program Enrollment Report - Demographic and Veteran Details-ORIGINAL | 10/21/2021 | Updated report logic so report won't timeout |
| Program Enrollment Report with Limited Demographic and Veteran Details | 9/27/2021 | NEW--created new report with limited demographic & veteran details |
| Program Enrollment Report - Demographic and Veteran Details-ORIGINAL | 9/27/2021 | Added ORIGINAL to report name since new report created |
| Seekers Served by Office | 9/14/2021 | Removed 8/27/2021 from report name |
| Seekers Served by Office - ORIGINAL | 9/14/2021 | Added ORIGINAL to report name since new report created |
| Seekers Served by Office 8/27/2021 | 8/30/2021 | Added WDA filter; built new version since old version kept timing out |
| Program Enrollment Report - With Demographic and Veteran Details | 8/23/2021 | Added 'Office' as optional prompt |
| Measurable Skills Gains | 8/23/2021 | Added 'Office' as optional prompt |
| Staff Account Details | 7/9/2021 | Moved to the 'Administrative' category |
| UniqueProgramEnrollmentNames | 7/9/2021 | Moved to the 'Administrative' category |
| Case Management "Other Program" Report | 6/8/2021 | Added 'Is opted-out' column |
| Data Entry Issue - Basic Services Late Entry | 6/8/2021 | Added 'Is opted-out' column |
| Data Entry Issue - Individualized/Training Services Late Entry | 6/8/2021 | Added 'Is opted-out' column |
| Program Enrollment Exists Outcomes Wages | 6/8/2021 | Added 'Is opted-out' column |
| Outcomes Touchpoints With Employment Start Date Information | 6/8/2021 | Added 'Is opted-out' column and deleted SSN column |
| Open Durational Services | 6/8/2021 | Corrected 'opt-out' logic |
| Job Match Activity | 6/8/2021 | Added initial date range prompt so report wouldn't pull 2016 data; relocated to Employer & Job Posting Reports category |
| Seekers Served by State/Area | 6/8/2021 | Removed 2016-2017 default date logic |
| Case Managment Report | 5/13/2021 | Added 'Is Opted-Out' and 'Date Most Recent Duration Service Last Updated' columns; deleted 'Participant Site Identifier' column |
| Measurable Skills Gains-NEW | 5/5/2021 | Combined 3 Program Enrollment columns all into one column |
| Measurable Skills Gains-NEW | 5/3/2021 | Copy/paste of existing MSG report; changed date logic to an OR format to include not only 'date touchpoint taken', but also any of the following dates within the specified date range: *Test date *Date of report card or transcript *Date of progress report *Date TP taken |
| Program Enrollment Report - With Demographic Details ORIGINAL | 3/1/2021 | Removed unused columns from report |
| Program Enrollment Report Without Demographic Details | 3/1/2021 | NEW; super-slimmed down version without demographic details |
| Program Enrollment Report With Limited Demographic Details | 3/1/2021 | NEW; slimmed-down version with limited demographic details |
| Open Durational Services | 2/18/2021 | Added new column for most recent date TP updated |
| Case Management Report | 2/9/2021 | Moved 'Days' columns for Last Completed Services columns and added 'Days' columns for Most Recent Duration Service' columns |
| Program Enrollment report - With Demographic Details | 2/3/2021 | Corrected report logic to fix time out issues |
| Open Durational Services | 1/28/2021 | NEW--Created new report for the open durational services |
| Non-Federal Activity - Participant Contact | 11/19/2020 |
NEW--Created new report for the 'Non-Federal Activity' TouchPoint |
| Program Enrollment Report - Demographic and Veteran Details |
10/26/2020 |
Added new columns--Eligibility Veteran Status and Veteran Verification |
| Data Entry Issue - Basic Services Late Entry | 9/29/2020 |
*Moved here from the ‘Temporary Reports’ category *Added initial prompt to run by WDC and start/end date range; added new columns--Service Recorded By, Service Last Updated By, and Service Recorded on Behalf Of; moved reports from 'Temporary' category to 'Operational' category; opened Basic Service version up to all WDAs and not just Columbia Basin |
| Data Entry Issue - Individualized/Training Services Late Entry | 9/29/2020 |
*Moved here from the ‘Temporary Reports’ category *Added initial prompt to run by WDC and start/end date range; added new columns--Service Recorded By, Service Last Updated By, and Service Recorded on Behalf Of; moved reports from 'Temporary' category to 'Operational' category |
Outreach Reports
| Report | Date | Change(s) |
| Ex-Offender With or Without A Basic Service or ITSS Optimized | 12/16/2020 | Deleted report |
| Outreach Offenders By County | 12/16/2020 | Deleted report |
| Outreach Reentry Program - Ex-Offender PESvcTP | 12/16/2020 | Deleted Report |
| Outreach Reentry Program - Ex-Offender X | 12/16/2020 | Deleted Report |
| Outreach Reentry Program - Ex-Offender | 12/16/2020 | Moved to NEW Re-Entry Reports category; removed Ex-Offender from report name |
| Outreach Reentry Program - Ex-Offender | 9/23/2020 | Added new columns--Most recent service date, Most recent service provided, Program enrollment of service, Recorded by, Recorded on behalf of |
Re-Entry Reports
| Report | Date | Change(s) |
| Outreach Re-Entry Program Based on Audit Date | 4/6/2021 | Updated to add phone number |
| Outreach Re-Entry Program Based on Service Date | 4/6/2021 | Updated to add phone number |
| Outreach Re-Entry Program Based on Audit Date | 2/24/2021 | NEW--corrected report logic; displays data based on most recent 'audit' date |
| Outreach Re-Entry Program Based on Service Date | 2/24/2021 | NEW--corrected report logic; displays data based on most recent 'service' date |
| Outreach Reentry Program | 2/24/2021 | Deleted report; split into two separate versions |
| Re-Entry with Basic Services | 2/24/2021 | Corrected report logic for identifying offenders |
| Re-Entry with ITSS Services | 2/24/2021 | Corrected report logic for identifying offenders |
| Re-entry Program - Outcomes and Program Completion | 1/11/2021 | Deleted report (replaced with new version) |
| Outcomes and Program Completion for ReEntry | 1/6/2021 | Updated report logic, renamed and added desciption |
| Reentry Program - Ex-Offender | 12/28/2020 | Deleted report |
| Re-Entry with Basic Services | 12/17/2020 | NEW--Split out old report to display only Basic Services |
| Re-Entry with ITSS Services | 12/17/2020 | NEW--Split out old report to display only Basic Services |
| Outreach Offenders by County | 12/16/2020 | Deleted report |
| Outreach Reentry Program - Ex-Offender PESvcTP | 12/16/2020 | Deleted report |
| Outreach Reentry Program - Ex-Offender X | 12/16/2020 | Deleted report |
| Outreach Reentry Program | 12/16/2020 | Moved from Outreach Reports category to this NEW Re-Entry category |
| Reentry Program - Ex-Offender | 12/16/2020 | Moved from Outreach Reports category to this NEW Re-Entry category |
| Re-entry Program - Outcomes and Program Completion | 12/16/2020 | Moved from Outreach Reports category to this NEW Re-Entry category |
Temporary Reports
| Report | Date | Change(s) |
| Data Entry Issue - Program Enrollments With No Attached Services | 2/4/2021 | Deleted report as no longer used; per 1/20 T12 meeting, staff use Case Management Report |
| WA-3332 Data Entry Issue - Program Enrollments With No Attached Services | 2/4/2021 | Deleted report as no longer used; per 1/20 T12 meeting, staff use Case Management Report |
| QA Report: TAA Waiver responses missing Associated Determinations | 1/26/2021 | Deleted report; made Associated Determination field on TAA Waiver TP a required field |
| Data Entry Issue - Basic Services Late Entry | 9/29/2020 | Moved to the ‘Operational Reports’ category |
| Data Entry Issue - Individualized/Training Services Late Entry | 9/29/2020 | Moved to the ‘Operational Reports’ category |
TouchPoint Reports
| Report | Date | Change(s) |
| n/a |
Trade Assistance Act
| Report | Date | Change(s) |
| Batch Payment Review | 4/27/2022 | Added start/end date initial prompts; added participant name and opt-out columns to report. |
| TAA Determination Letter | 12/30/2021 | Deleted: duplicate of dashboard version |
| TAA Entitlement Letter | 12/30/2021 | Deleted: duplicate of dashboard version |
| Training Waivers | 3/23/2021 | Corrected bad report logic for various date columns |
| Petition Activity | 3/23/2021 | Corrected bad report logic; removed all WorkSource Offices since all data reported under Administrative |
| Training Waivers | 2/9/2021 | NEW--reworked old version of report and added/changed/removed columns |
| Waiver Report | 2/9/2021 | Deleted report; replaced w/new version |
| Obligations and Acitivites Report | 1/28/2021 | Added report description |
| Determination without Services | 1/21/2021 | Corrected bad report logic for TAA and TRA columns |
| Obligation/DeObligation Report | 1/20/2021 | NEW obligation/deobligation report |
| Obligations Audit | 1/7/2021 | Deleted report |
| Obligations and De-obligations | 1/4/2021 | Deleted report |
| Employer Petition List | 12/16/2020 | Added an initial prompt for Start Date, which is based on when the TAA Petition Tracking Employer TP was taken; removed a couple of columns |
| Petition Activity | 12/10/2020 | Relabeled column headings; rebuilt to fix the logic on how the report populates |
| Determination without Services | 11/23/2020 | Added Entitlement Type column |
| Obligations and Activities Report | 11/9/2020 | Moved here from the ‘Finance and Obligations’ category |
| Obligations with Section Balances | 11/9/2020 | Moved here from the ‘Finance and Obligations’ category |
| Payment Batch Cover Page Full Version WA-3671 | 11/9/2020 | Moved here from the ‘Finance and Obligations’ category |
UI Claimant/RESEA
| Report | Date | Change(s) |
| RESEA Action Plan Follow-up – Printable | 3/7/2022 | NEW-printable copy of RESEA action plan follow-up TP |
| RESEA Action Plan Initial – Printable | 3/7/2022 | NEW-printable copy of RESEA action plan initial TP |
| RESEA Draft TouchPoints | 1/20/2022 | NEW; report to display when either the RESEA Required Elements Initial or RESEA Action Plan Initial TouchPoints are in still in 'Draft' status |
| RESEA Seekers Served Counts NEW | 2/4/2021 | Corrected report logic to remove #MULTI-VALUE issue |
| RESEA Seekers Served Counts ONLY | 2/4/2021 | Corrected report logic to remove #MULTI-VALUE issue |
| RESEA Seekers Served | 2/4/2021 | Corrected report logic to remove #MULTI-VALUE issue |
| RESEA Seekers Served Counts NEW | 11/9/2020 | Moved here from the ‘Uncategorized’ category |
| RESEA Seekers Served NEW | 11/9/2020 | Moved here from the ‘Uncategorized’ category; deleted report as duplicate of another report |
| Generate Letter Batches - Admin - Auto Filled Events | 9/23/2020 |
Moved here from the ‘Mass Scheduling’ category |
| Generate Letter Batches - Local Office - Auto Filled Events | 9/23/2020 |
Moved here from the ‘Mass Scheduling’ category |
| Generate Letter Batches - Local Office - Auto Filled Events March 2018 | 9/23/2020 | Moved here from the ‘Mass Scheduling’ category |
| Generate Letter Batches (Auburn-North Seattle-Rainier-Redmond-Renton) | 9/23/2020 | Moved here from the ‘Mass Scheduling’ category |
| RESEACallINS | 7/15/2020 |
Deleted report |
| RESEACallINSREschedules | 7/15/2020 |
Deleted report |
Veterans
| Report | Date | Change(s) |
| Outreach through UI | 9/27/2021 | Modified report logic to only pull those with UI claim |
| DVOP Services | 5/3/2021 | Found setting that wasn't correct for displaying 'Is Veteran per profile' data correctly when Staff role runs report; also fixed irregularity for accurately reporting individualized career services. |
| Spouse Program Eligibility Screening Questions | 2/23/2021 | NEW--split spouse questions into separate report |
| Veteran Program Eligibility Screening Questions | 2/23/2021 | Updated to remove spouse questions and added them to new report |
|
DVOP Services |
1/12/2021 | Fixed inconsistent report logic |
|
Veteran Program Eligibility Screening Questions |
7/22/2020 | Added several new columns; moved columns; deleted columns; relabeled column headers |
|
OFCCP Audit |
6/23/2020 |
Fixed formatting issues |
| Outreach through UI | 6/21/2020 | Changed initial WDA and start date prompts; added new columns; relabeled column headers; changed report name |
| HVRP Job Seekers | 6/20/2020 |
Changed initial prompts and filters; added several new columns; changed report name |
| DVOP Services | 6/16/2020 | Added new columns—Staff and Program; relabeled a few column headers and labels |
|
Veteran Case Management |
6/10/2020 | Removed ‘Link to Seeker Dashboard’ column; changed report name |
Other
| Report | Date | Change(s) |
|
MSFW Outreach List widget (on staff dashboard) |
11/24/2020 | Updated to reorder questions; added new columns; and renamed |
| Uncategorized |
*Moved 2 RESEA reports (RESEA Seekers Served Counts NEW and RESEA Seekers Served NEW) to the ‘UI Claimant/RESEA’ category *Eventually will delete ‘Uncategorized’ category |
|
| My Reports category | 11/9/2020 |
*Moved ‘Business Services’ to Employer & Job Postings Report category *Deleted category from menu |
| Finance and Obligations category | 11/9/2020 |
*Moved 3 TAA reports (Obligations and Activities Report, Obligations with Section Balances, and Payment Batch Cover Page Full Version WA-3671) to the ‘Trade Assistance Act’ category *Deleted category from menu |
| Mass Scheduling | 9/23/2020 |
*Moved 4 ‘Generate Letter Batches’ reports to the ‘UI Claimant/RESEA’ category *Deleted several old test reports *Deleted category from menu |