HomeUser SupportData Fixes

Data Fixes

The INACTIVATION DATE of employers created by the WS interface with the history date that the status was originally updated to INACTIVE
-EMPLOYER data records that were created by WS interface and the employer status is INACTIVE will have their INACTIVATION PERSON populated with agent ID 2023
(Moved into Production 11/25/03)

The WS Employer IN process was not populating the inactivation date nor inactivation person in EMPLOYER_DATA when the employer status was updated to INACTIVE through the WS interface. The employer_in process has been changed to update the INACTIVATION DATE with SYSDATE of when the interface updates the EMPLOYER status to INACTIVE and the INACTIVATION PERSON with agent ID 2023 which means Worksource Interface at the same time.
(SKIES Track Record Incident # 962 Moved into Production 11/25/03)

UI Update, UI CLAIMANT IN and Worker Profiling
(SKIES Track Record Incident #734 Moved into Production 06/08/03)

Issue: ACES Interfaces are writing extra records to seeker_data_hist table

Fix: The above interfaces include coding to update a Job Seeker/Job Match status. Currently, if that status is “active” already and one of these interfaces contains an “active” status, the record will be “updated”. This creates unnecessary history records. These interfaces will no longer update if the current Job Match status is the same as the interface Job Match status. Also, the coding has been updated such that when a status is updated, the seeker_status_date will be updated to reflect the date of the change. The data fix for this incident will delete the duplicate seeker history records created by the unnecessary “updates” of the same status stated above.

Data fix for duplicate employment histories
(SKIES Track Record Incident #760 Moved into Production 06/08/03)

Issue: Currently, the coding does not create a second employment history when there is a duplicate that matches on ONET code, the employment start date, and the employment end date.

Fix: To have less duplication, the coding has been updated to include “null” fields for the employment start date and the employment end date as a match. For example, an ONET code is created in SKIES from the interface with Guide but no start or end date is available. SKIES would create the employment history record without the start and end dates for employment (these would be blank or null). If a second interface with Guide brings in the same ONET code for the same record and null dates, SKIES will now recognize that this is a duplicate and not create the same record. If there are the same ONET codes but different dates, this will be created as two employment history records. The data fix will delete these duplicate employment history records if the created by field is “Interface UI”, the ONET code is the same, the employment start date is the same, and the employment end date is the same.

JOB MATCHING Results
(SKIES Track Record Incident #773 Moved into Production 06/08/03)

Issue: election of "Display Detail" creates an employer service of Applicant Referral/Applicant referral in error

Fix: Through the Employer/Job Placement form, the “display seeker” button when activated was generating an employer service for “Applicant Referral”. This form has been updated to no longer create this error. The data fix will delete employer services created by the above error. There are a total of 18 employer services deleted that are errors or duplicates.  If you have any questions contact the SKIES Help Desk at 360.438.4674

Job Seeker records as created by the Go2WorkSource.com interface, the Aces interface, and the Unemployment Insurance (Guide system) interface
(Track Record Incident #496 and #625 Moved into production 05/29/03)

Issue: At the end of March, a portion of incidents #496 and #625 were moved into Production. These pertained to Employer records and Job Order records that are created by the Go2WorkSource.com or the interface with the Taxis system and assigned to the Central Office WDA or Telecenter WDA. May 29, 2003 the remainder of the processes for incidents #496 and #625 will be moved into Production. These will address Job Seeker records as created by the Go2WorkSource.com interface, the Aces interface, and the Unemployment Insurance (Guide system) interface. These interfaces will no longer assign a record to Central Office WDA or Telecenter WDA.

Data Fix:  Job Orders that were assigned to Central Office WDA or Telecenter WDA will be reassigned using the work site zip code and the first office extracted that is not Central Office WDA or Telecenter WDA. Seeker records that were created by the WS Interface, ACES interface, or UI Claimant interface will have the office reassigned if that office is either Central Office WDA or Telecenter WDA. Most offices are rationally assigned with the exceptions described below. The data fix will reassign as described below. For the WS Interface, that will be a matching office zip code to the Seeker address zip code. On records that do not match, GO2WS INTERFACE will be assigned office. For the Aces Interface, records have a corresponding Community Service Office that they are assigned to with one exception going to SKIES Management. That assignment will now go to Aces Interface instead of SKIES Management.  For the UI Claimant In interface, there are corresponding offices from the UI system to SKIES with the exception of one office assigned to the SKIES Management office. This assignment will now be to the UI Claimant Interface “office” instead of SKIES Management.

Prevent the same JAS/ACES file from processing twice in SKIES and SKIES Track Record#477 - WorkFirst JAS/ACES Interface Not Running/Populating SKIES Public_Assistance Table
(SKIES Track Record #60)

Issue: The interface from JAS/ACES to SKIES is creating the same record more than once if the data is matched to an existing record under some circumstances. Due to the incorrect creation of this data, the interface was discontinued until the programming could be updated that would stop the JAS/ACES interface from this duplication. The data from this interface has been stored until the interface coding has completed re-programming.

Data Fix: Programming on the JAS/ACES interface has now been updated so that re-occurring records from the interface will not routinely duplicate records that already exist in SKIES. Data from the interface that has been stored from previous dates will be updated to SKIES. This interface will now run on a daily schedule between Monday and Saturday early mornings. This data fix has been completed and the interface began running over this last weekend 2/9/03. NOTE: Due to storage space availability, data from the JAS/ACES interface will span back to 9/9/02.  02/10/03

Changing the Literal on Employer/Job Order/Description Tab “Commission or Piece Rate”.
(Track Record #716 (Also Change Order #6) Moved to Production 03/28/03)

On the Employer/Job Order/Description tab, there is a check box that currently reads “Commission or Piece Rate”. This box will be updated to read “Non WA State Min Wage, Commission, or Piece Rate”. Job orders posted that have this box or the “Unpaid” box checked will now allow a Minimum Salary and Maximum Salary denomination of less than Washington minimum wage standards to be entered into the Min Salary and Max Salary fields. A portion of Track Record #690, #625, and #496 will be implemented now as described below. However, the Track Records #690, #625, and #496 will not be closed until the entire track record has been implemented.

Before: If SKIES receives an update from the Go2WorkSource interface to an employer record that SKIES does not have in the database, the update is rejected. The result is that the employer record database in SKIES does not contain the same employer records as Go2WorkSource.

After: If SKIES receives an update from the Go2WorkSource interface for an employer record that SKIES does not have in the database, SKIES will add the information as an employer record. The result will be that SKIES and Go2WorkSource will have employer records synchronized.

Employer records will no longer be assigned to Telecenter WDA through the above interface. This rule applies to both record creation and record updates. Employer records will no longer be assigned to Central Office WDA through the above interface. This rule applies to both record creation and record updates.

Data Fix: Employers that were created by the above interface and assigned to Telecenter WDA or Central Office WDA will be reassigned to an appropriate office using the records City, State, Zip combination. If no office can be identified with the available City, State, Zip combination on the employer record then the assignment will go to the default office of GO2WS Interface.

Data Fix: Some employer records created through the above interface contained phone numbers and fax numbers that had errant symbols instead of the numeric digits.

Previous System Updates

January 31, 2002 - In order to ready the servers for the pilots and implementation, the SKIES training environment is being moved from the production server to a smaller server on the evening of 2/6/02. This means that there are constraints to the amount of concurrent users on this server. There can only be 100 users on this server at one time so the amount of student logons is shrinking. We need your opinions on how to deal with this. Would each area like 8 assigned logons or would you prefer that they be centrally managed by the help desk? Please let me know by e-mail. Also, the new J-initiator will be installed this weekend so you all need to make sure that the new version is loaded in your offices and training facilities. SKIES will not work on Monday if the installation has not been done.

January 28, 2001 - For future SKIES bi-weekly teleconferences the number has been changed to 360.357.2961

January 23, 2002 - Trainers - This is a heads up that we need your assistance again. A statewide stress test will be executed next week on January 29th. We want as many trained people as possible to logon the system that day so that statewide system performance can be measured. The test will be from 7AM to noon on that day. The hope is that we will have about 800 people logon to SKIES between 7AM and 8:30 AM and complete three exercises. This test WILL NOT occur in the training environment. There will a test environment with separate logons and a password which will be outline in a communication coming out later this afternoon. Stand by for further details! - Jan Oswold

January 18, 2002 - The server reboot that occurred yesterday noon appears to have fixed the clocking out problem.

January 17, 2001 - Please exit the SKIES training site from noon to 1:00 pm today. The server will be rebooted during that time, which should correct the system delays. If you have any questions, please contact the SKIES HELP Desk at (360)438-4690. 

Recent Update - All SKIES training has been delayed until 1/7/2002 to facilitate data conversion and stress testing. 

December 14, 2001 - 5:30 pm
All SKIES training has been delayed until 1/2/2002 to facilitate data conversion and stress testing. The Demo site is available at https://wws2.wa.gov:875/esd/skies (for outside firewall) or http://skies (for inside firewall) starting Monday morning, December 17th. If you have any questions, please contact the SKIES HELP Desk at (360)438-4690.

Thursday, December 13, 2001 - noon
The SKIES Project will hold its next bi-weekly teleconference on SKIES implementation on Friday, December 14, from 9 to 10 a.m. The number to call is 360-357-2911. Due to the limited number of ports, WDC areas are encouraged to select representatives to participate in a group setting rather than having individuals call in. Central Office and Lacey Building staff for ESD must participate via a group call from the First Floor Conference Room in Lacey. For more information, contact Jeanette Nelson at (360) 438-3284.

Recent Updates
Check for the latest news. The SKIES system is working well. If you are experiencing difficulties, please call the Help Desk at 360-438-4690. After receiving requests from both trainers and trainees, management decided to transfer the delete capability from the supervisor role (remember this a role in SKIES and not a position in the office) to the staff role, and the supervisor role was removed from the system. The change was applied to every database. This means that trainees should be able to delete the data they were not able to with the previous "staff role". The programmers have removed the 60-minute timeout feature from the Training Database. The change is effective as soon as a student logs off and then logs in again. 

December 11, 2001 - 1:50pm
The system has been clocking, the problem is resolved, just log out and log back into the system, everything should be fine.  If not, please call the Help Desk at 360-438-4690. In order to assist the programmers and network admin staff with diagnosing the clocking problem it will be very helpful for them to know exactly when and where training is occurring. Starting Wednesday, December 12th, you will see the following message in a text box above the TRAINING button on the first SKIES screen:

Please call the HELP DESK (360) 438-4690 when you start a new SKIES training class. People at the help desk will ask the following questions:

• The physical location of the training

• How many people are in the class

• When (date and time) will the class begin and end

• Is the facility connection to SKIES inside or outside of the firewall

December 5, 2001
First of all the project team would like to thank you for your cooperation this week with the scheduled logoffs during the training days. This week we were able to solve the server problem which caused students and trainers to be "kicked off" the system. The opportunity to possibly tune the server during the day was a sacrifice for you but it provided a window of time for technical staff to work if fixes needed to be made. As of 12/3/01 it has been determined that there is no need to logoff the system during the day except from noon to 1PM. Please continue your training and call the HELP DESK when you have problems and/or questions.
My sincere thanks,
Jan Oswold
SKIES Training

November 27, 2001
Note from Peggy Zimmerman - As you all know, we have been having performance problems. We now believe the problems are related to software compatibility. We have an Oracle expert on site to change settings and work with our servers. Testing of these changes will be done for the week of Nov 26th until we find a solution. We will also have experts from IBM here this week to complete the problem assessment and recommended solutions.

We will not go to pilot on December 3rd. We will not have anyone serving customers with SKIES until we can ensure system performance. We have not set new dates and we will not set new dates until we diagnose the problem and identify the solutions. We will have a plan in place by the end of next week. Thank you for your patience, your forbearance, and your tolerance. 

Monday, November 26, 2001 - 11:30am
Note from Peggy Zimmerman - We understand that there are continued problems with SKIES in the training environment. Both Oracle and IBM have been contacted and are sending specialists to assist us in resolving the performance issues we are facing. You may certainly continue to attempt training while we work on the issues, but the system may not work as well as you or we would like. It is understandable if you decide to postpone or delay your training schedule due to these issues. We do understand the frustration you are experiencing and with the help of the specialists will hopefully resolve these concerns soon. 

Wednesday, November 21, 2001 - 11:00am
The SKIES system appears to be stable. Please continue to call the SKIES HELP DESK at 360-438-4690 and report your experiences. The details you provide help isolate the problems.

Tuesday, November 20, 2001
Efforts to balance connectivity continue. The servers should be running by 11:15 today. If not, please log off and wait until 1:30 to re-establish contact.

Monday, November 19, 2001 11:45 am
There is a web application server problem. Please log out shortly before noon. You can log back in at 1:15 PM. Remember, your help is essential in resolving SKIES issues. Please continue to call the SKIES HELP DESK at 360-438-4690 and report your experiences. The details you provide help isolate the problems.

Friday, November 16, 2001 
10:00 am The SKIES system appears to be operating. 10:30 am Some locking up is occurring in some locations. 

Thursday, November 15, 2001 4:30 pm The local training sessions attendees have identified an issue on the Provider forms that adversely effects response time. Thanks to the local training effort, a resource intensive query has been identified. The development team is conducting research with a resolution possible within the next 2 or 3 days. 2:30 pm The system appears to be functioning much better this afternoon. 11:30 am Please log off the system during the lunch hour for system repairs. The system should be back up by 1:15. 10:00 am The SKIES system has been locking up. Oracle was contacted for technical assistance yesterday. It appears that the system is not logging out users as it should, thus, when the user returns to the system and tries to open a record they were using, the record is not available because the system believes that another user is updating the record.  Work continues to resolve the problem. Check back for updates. 

Friday, November 9, 2001 - 1:00 PM System Update - The SKIES system is operating effectively. Please continue to call the SKIES HELP DESK at 360-438-4690 and report your experiences. The details you provide help isolate the problems.

Thursday, November 8, 2001 - 3:30PM Trainers and SKIES Users Teleconference Announcement - A teleconference for SKIES trainers and users is scheduled for 11:00 AM in the first floor large conference room, Lacey.  The number is 360-357-2937. SKIES IT Infrastructure Update (Technical Notes)  - The SKIES technical team identified possible problems that effected performance during training yesterday. Testing concluded a marked improvement in response times. 

Thursday, November 8, 2001 - 12:45 PM The system problems from yesterday are generally resolved, although slow-downs appear to be occurring in some areas. Another update will be published as soon as more information is available. Please continue to call the SKIES HELP DESK at 360-438-4690 and report your experiences. The details you provide help isolate the problems.

Wednesday November 7, 2001 - 3:45 PM Recent fixes to the SKIES Application and Data Base have somewhat improved  performance. We are still experiencing slow response times, (clocking for a long time). Programmers are continuing to work through the evening to diagnose and repair problems. You should see improvements as the week progresses. Thank you for your patience. Your participation is paramount. Please continue to call the SKIES HELP DESK at 360-438-4690 and report your experiences. The details you provide help isolate the problems.