Winshuttle
Winshuttle is a data movement tool that enables OFM to upload data from Excel to HRMS through a pre-built Excel file. We call these Excel files Winshuttle scripts.
Who can use Winshuttle?
HRMS users assigned the Personnel Administration Processor role, Payroll Processor role, or Organizational Management Processor role can contact OFM to request a Winshuttle upload to HRMS.
What is the Process for me to Request a Winshuttle Script Upload?
- Download the spreadsheet for the desired script.
- Save the spreadsheet with the following naming convention for the spreadsheet is required: agency code followed by the original Winshuttle spreadsheet name. File names should not contain spaces, rather an underscore to separate the title name. It is okay to put dates or unique identifier after the original spreadsheet name. Example: OFM_PA30_IT0001_Personnel_Subarea_Update-1_01152024.xlsx
Note: OFM does not validate your data before or after running the updates. Prior to sending in your request, verify the personnel numbers, position numbers, and organizational unit numbers belong to your agency on the effective date for the update.
- Send the completed spreadsheet to HeretoHelp@ofm.wa.gov outlining in the request:
- The reason for the mass updates.
- The approximate number of records.
- Your preferred upload goal date. OFM cannot guarantee same day processing.
After OFM completes the upload, they will send you the completed spreadsheet to validate. If there are errors, manual updates may be necessary.
If you do not see the Winshuttle Script you need, please follow the HRMS Standard Change Request process to request a new Winshuttle script creation.
Which Winshuttle Scripts are Available?
If your agency has 30 or more data updates to process, one of the following scripts may be used.
| Transaction | Infotype | Script Name | Use | Spreadsheet |
|---|---|---|---|---|
| PA30 | 0001 | Organizational Assignment Create | Use this script when you need to update the employee Organizational Assignment Infotype 0001 to display the correct Position, Job, Organizational Unit data when updates the Position, Job, Organizational Unit Titles and relationships have been created on the Org Management Side. | PA30 IT0001 Create Save |
| PA30 | 0001 | Organizational Assignment Create Save Start Date | Use this script when you need to create a new Organizational Assignment infotype 0001 with the start date to display the correct data that has been updated on the Org Management side like the Position UFI code. | PA30 IT0001 Create Save Start Date |
| PA30 | 0001 | Organizational Assignment Org Key Update | Use this script to update the Org. Key field on the Organizational Assignment Infotype 0001. | PA30 IT0001 Org Key 1 |
| PA30 | 0001 | Organizational Assignment Personnel Subarea Update | Use this script to update the Personnel Subarea for an employee. | PA30 IT0001 Personnel Subarea Update 1 |
| PA30 | 0001 | Organizational Assignment Time Admin Code Update | Use this script to update the Time Administrator field on the Organizational Assignment Infotype. If the Administrator for Time Recording field is left blank the script will delete existing codes. | PA30 IT0001 Time Admin Code Update 1 |
| PA30 | 0006 | Address – Create Out of State Work Location Subtype 9 | Use this script to create Address Subtype 9 - Out of State Work Location for addresses within the United States or Territories. This script will not work for foreign addresses. The script will override any existing Address Subtype 9-Out of State Work Location. | PA30 IT0006 Create Out of State Work Location Address |
| PA30 | 0007 | Planned Working Time Update | Use this script to change the Work Schedule Rule in Planned Working Time IT0007. | PA30 IT0007 Copy Update |
| PA30 | 0007 | Planned Working Time- ACA Status Code Update |
Use this script to copy a new Planned Working Time IT0007 record with ACA Status Code for several employees. NOTE: You will need to also include the employees current work schedule rule. When copying a planned working time record, the new record defaults to FULL. |
PA30 IT0007 Copy ACA Status Code 1 |
| PA30 | 0007 | Planned Working Time-EEPercentage Update | Use this script to update Employee Percentage in Planned Working Time IT0007. | PA30 IT0007 EE Percentage Copy Update |
| PA30 | 0008 | Basic Pay - Next Increase Date Update | Use this script to copy the existing Basic Pay Infotype 0008 record and enter the next increase date. | PA30 IT0008 Next Increase 1 |
| PA30 | 0008 | Basic Pay - Additional Wage Types Delete | Please contact the OFM - Helpdesk if you want to use this script. Use this script to delete additional Wage Types from the Basic Pay Infotype 0008. This script will delete up to 4 additional Wage Types on Basic Pay. | PA30 IT0008 Delete Additional Wage Types Reason Code |
| PA30 | 0008 | Basic Pay Create |
Use this script to create a new basic pay record for an employee. All fields are required except the Next Increase Date. This script will will not work for Basic Pay records that are set up as pay grades (example: WMS). |
PA30 IT0008 Create 1 |
| PA30 | 0008 | Basic Pay Update |
Use this script to update an existing basic pay record for employees that are on a payscale. This script will update the reason for changing master data, Pay Scale Type, Pay Scale Area, Pay Scale Group, Pay Scale Level. This script does not include the next increase date and will not work for Basic Pay records that are set up as pay grades (example: WMS). |
PA30 IT0008 Copy Update PS Group PS Level 1 |
| PA30 | 0008 | Basic Pay - Add Additional Wage Types Update | Use this script to add additional wage types to a basic pay record. This script copies the existing record inserts the new date, reason code, wage type and data saves the record. | PA30 IT0008 Assn Pay Flex Reason Code |
| PA30 | 0008 | Basic Pay - Directly Valued Employees Update |
Use this script to update Wage type 1003 (semi-monthly), 1001 (hourly) and 1006 (Daily) for Directly Valued employees ONLY. If an indirectly employee is run with this script it will change their basic pay from Indirect to Direct. |
PA30 IT008 Dir Val WT Update |
| PA30 | 0008 | Basis Pay - Capacity Utilization Level and Working Hours per Payroll Period Update |
Use this script to update the Capacity Utilization Level and Working Hours per Payroll Period on IT0008. The Working Hours per Payroll Period will need to be manually calculated. To calculate, Multiply 87 by the Capacity Utilization Level percentage. Example: 87.00 x 80% = 69.60. NOTE: Setting the Capacity Utilization Level below 100% may erroneously reduce the employee’s additional pay wage types. |
PA30 IT0008 Capacity Utility Level and Work Hours Period Copy Update |
| PA30 | 0014 | Recurring Payments/Deductions Change End Date | Please contact the OFM Helpdesk if you want to use this script. Use this script to change the end date of a record. If there are multiple wage types, this script will select the most recent record and update the end date. | PA30 IT0014 Change 1 |
| PA30 | 0014 | Recurring Payments/Deductions Create |
Use this script to create Recurring Payments/Deductions records for employees. The Assignment number field is not required. |
PA30 IT0014 Create 1 |
| PA30 | 0014 | Recurring Payments/Deductions with Cost Assignment |
Use this script to create Recurring Payments/Deductions infotype 0014 with cost assignment. Note: The fields are not in the same order as the Cost Distribution infotype. |
PA30 IT0014 with Cost Assignment |
| PA30 | 0015 | Additional Payments Create | Use this script to Create an Additional Payments Infotype record. This script will only work for Wage Types that you have to enter an amount. It will not work for scripts that you enter hours. | PA30 IT0015 Create 1 |
| PA30 | 0015 | Additional Payments Create with Assignment |
Use this script to Create an Additional Payments Infotype record to include an assignment number. This script will only work for Wage Types that you have to enter an amount. It will not work for scripts that you enter hours. NOTE: The Assignment Number field (Column E) is limited to 20 characters including spaces. |
PA30 IT0015 Create With Assignment 1 |
| PA30 | 0015 | Additional Payments with Cost Assignment |
Use this script to create Additional Payments infotype 0015 with cost assignment. Note: The fields are not in the same order as the Cost Distribution infotype. |
PA30 IT0015 with Cost Assignment |
| PA30 | 0015 | Additional Payments Delete | Use this script to delete wage types in IT15 within date range. | PA30 IT15 Delete 1 |
| PA30 | 0019 | Monitoring of Task Update | Use this script to update the Monitoring of Task infotype 0019. This script uses the change functionality and will override existing data. Make sure the spreadsheet is correct prior to submitting. | PA30 IT0019 Update |
| PA30 | 0019 | Monitoring of Task Update the Processing Indicator Status | Use this script to update the Processing Indicator Status on the Monitoring of Task Infotype 0019. | PA30 IT0019 Change Processing Indicator Status 1 |
| PA30 | 0027 | Employee Cost Distribution Create | Use this script to create IT0027 records for employees. The end-date defaults to 12/31/9999. | PA30 IT0027 Update 1 |
| PA30 | 0027 | Employee Cost Distribution Create with End Dates | Use this script to create IT0027 with end date records for employees. | PA30 IT0027 Update End Date 1 |
| PA30 | 0040 | Objects on Loan Create | Use this script to create the Object on Loans (IT0040). | PA30 IT0040 Create 1 |
| PA30 | 0041 | Date Specifications Update |
Use this script to update the Date Specifications infotype. The start date on the spreadsheet needs to be the same for every record. Use a date in the current pay period. If you have need to use a different start date, ask in your ticket.” |
PA30 IT0041 Update 1 |
| PA30 | 0077 | Additional Personal Data – Public Service Loan Forgiveness Status Update | Use this script to update the PSLF Status and PSLF Date on the Additional Personal Data infotype 0077. | PA30 IT0077 PSLF Status Update |
| PA30 | 0081 | Military Service Create |
Use this script to create a Military Status Infotype IT0081 Record. After this record is saved, there is a dynamic action to create a Time Specification/Employ. Period Infotype IT0552 record. If you have the Start Date of IT0552 and End Date of IT0552 but no Duration of imputation in years, months and Days, enter the start and end dates and leave the Duration of imputation in years, months and Days columns blank. You will need to manually complete the Time Specification/Employ. Period Infotype IT0552 record at another time. If there are no Start Date of IT0552, End Date of IT0552, Duration of imputation in years, months and Days, leave the coulmn blank. You will get a error message to "Fill out all required entry fields" but the IT0081 record will be created. You will need to manually complete the Time Specification/Employ. Period Infotype IT0552 record at another time |
PA30 IT0081 Create |
| PA30 | 0094 | Residence Status Commercial Driver's License (CDL) Create | Use this script to create Resident Status Records IT0094 for agencies that have employees who have a Commercial Driver's License (CDL). The use of the ID type BA - U.S. Drivers License w/photo has been approved to store this data in HRMS to be compliance with U.S. Department of Transportation, Federal Motor Carrier Safety Administration regulations effective January 6, 2020. | PA30 IT0094 Create Drivers License |
| PA30 | 0105 | Email Address Update | Use this script to update employee email addresses on the Communications Infotype 0105, Subtype 0010. | PA30 IT0105 SType 0010 Update 1 |
| PA30 | 0105 | Email Address - End Date | Use this script to end date employee email addresses. | PA30 IT0105 SType 0010 End Date |
| PA30 | 0105 | WD1A Update |
Use this script to add Communication Subtype WD1A to the Communications Infotype 0105. Enter the personnel number in the Communication Identification/Number column. |
PA30 IT0105 SType WD1A Update |
| PA30 | 0234 | Add. Withh. Info. US Update | Use this script to update Add. Withh. Info. US Infotype 0234 records with L&I Code for employees that already have a valid IT0234 record. The script defaults the end date to 12/31/9999. | PA30 IT0234 Copy Update 1 |
| PA30 | 0235 | LTSS WA Cares Fund EE Exemption tax type 113 |
Use this script to exempt an employee from the LTSS/Washington Care Fund Tax Type 113. NOTE: If there is a current IT0235 exempting the employee for any other tax types (i.e. LNI Medical Aid Rates),this WinShuttle script should not be used. The current IT0235 record will need to be copied and updated manually to include the LTSS exemption. Other Taxes US Infotype 0235 reads what is active on the pay date. |
PA30 IT0235 LTSS WA Cares Fund EE Exemption Tax Type 113 |
| PA30 | 0416 | Time Quota Compensation Create | Use this script to create a Time Quota Compensation record for an employee. | PA30 IT0416 Create Quota Compensation 1 |
| PA30 | 2006 | Absence Quotas Change | Use this script to change the Quota Deduction Date for mass updates when adding a specific quota type. It should not be used to update multiple quota types. | PA2006 Change |
| PA30 | 2010 | Employee Remuneration Info Create | Use this script to create Employee Remuneration Info IT 2010. | PA30 Create Employee Remuneration 1 |
| PA30 | 2010 | Employee Remuneration Info Create Wage Type Amounts with Cost Coding | Use this script to create Employee Remuneration Infotype for wage types that you enter payment amounts and cost coding. | PA30 IT2010 WT Amount Cost Coding |
| PA30 | 2013 | Quota Corrections Create | Use This Script to create Quota Corrections. Default options are to Increase generated entitlement and Transfer collected entitlement immediately. | PA2013 Create |
| PA30 | 9105 | Employee Duty Station Create |
Use this script to create the employee Duty Station Infotype with the UFI code. This only needs to be created if there is a need to override the employee's position UFI code. |
PA30 IT9105 CREATE 1 |
| PA30 | 9105 | Employee Duty Station - End Date | Use this script to end date the Employee Duty Station Address (IT9105) override. | PA30 9105 End Date |
| PA30 | 9106 | Employee Telework/Flexible Work Create |
Use this script to create an employee Telework/Flexible work status infotype 9106 record. NOTE: Do not leave the Flex work hours Start Time P9106-START_TIME and Flex work hours End Time P9106-END_TIME columns blank. If they are blank, it will cause issues in MyPortal. If Flex Hours are not needed for the employee enter 00:00:00 in the columns or use the script: Employee Telework/Flexible Work without Flex Hours. |
PA30 IT9106 Create 1 |
| PA30 | 9106 | Employee Telework/Flexible Work - End Date |
Use this script to end date the Telework/Flex Work (Employee) IT9106 Infotype. You will not be able to end date the employee's record until the employee is separated. |
PA30 IT9106 End Date |
| PA30 | 9106 | Employee Telework/Flexible Work without Flex Hours |
Use this script to update an employee Telework/Flexible work status. This script does not include the Flex work hours fields. If Flex Hours are needed for the employee, use the script: Employee Telework/Flexible Work Create. |
PA30 IT9106 Create No Flex Hours 1 |
|
PA40 |
Appointment Change Action Update Employee Subgroup |
Use this script to update the Employee Subgroup for an employee. Note: This script should only be used for employees that their current Employee Subgroup is remaining hourly or monthly. If the employee is currently monthly and the Employee Subgroup is changing to hourly or currently hourly and the Employee Subgroup is changing to monthly, the Planned Working Time (IT0007) and the Basic Pay (IT0008) will need to be manually updated. |
PA40 Appointment Change Change EE Subgroup 1 | |
| PA40 | Separation Action Create (PA) | Use this script to perform part of the personnel administration processor portion of a PA40 separation action. This script will update the following infotypes:
This script will not update the following Employee Master Data infotypes:
There are separate Winshuttle scripts that will update these infotypes. (OFM IT will run these scripts for agencies that submit the Separation_Action_Create Winshuttle Spreadsheet). |
Separation Action Create (PA) | |
| PO11 | 1001 | Org Unit to Cost Center Relationships Create | Use this script to create org unit to cost center relationships. | PP01 Org to Cost Center Rel 1 |
| PO13 | 1001 | Position to Org Unit Relationship Update | Use this script to update Position to Org Unit Relationships. | PP01 IT1001 Position To ORG REL 1 |
| PO13 | 1001 | Position to Position Relationship Update | Use this script to update Position to Position relationships. | PP01 IT1001 Position To Position REL 1 |
| PO13 | 1002 | Position Description Create | Use this Script to create Org Unit or Position Description Infotype IT0002. | PP02 IT1002 Create Description 1 |
| PO13 | 1005 | Position Planned Compensation - Pay Grade Create | Use this script to create a Position Planned Compensation Infotype 1005 for positions that are related to job classes that are set up with a pay grade. | PP02 IT1005 Create Position Pay Grade 1 |
| PO13 | 1005 | Position Planned Compensation - Pay Scale Create | Use this script to create a Position Planned Compensation Infotype 1005 for positions that are related to job classes that are set up with a pay scale. | PP02 IT005 Create Position Pay Scale 1 |
| PO13 | 1007 | Position Vacancy - Create | Use this script to create position vacancy infotype records. | PP02 IT1007 Create |
| PO13 | 1008 | Position Account Assignment Features Update | Use this script to update the position Account Assignment Features. | PO13 IT1008 Copy 1 |
| PO13 | 1011 | Position Work Schedule - Percentage Update | Use this script to copy a position's current Work Schedule record and update the percentage on IT1011. | PP02 IT1011 Work Schedule Copy Update Position Percentage |
| PO13 | 1013 | Position Employee Group/Subgroup Update | Use this script to update position Employee Group and Employee Subgroup. | PP02 IT1013 Update 1 |
| PO13 | 1018 | Position Cost Distribution Create | Use this script to create cost distribution for positions. The end date defaults to 12/31/9999. | PP02 1018 Update 1 |
| PO13 | 1028 | Position Address UFI and Optional Fields Update | Use this script to update the position address Infotype with UFI code and other optional fields. | PP02 IT1028 Copy Address All Fields 1 |
| PO13 | 1028 | Position Address UFI Create | Use this script to update the position address Infotype with UFI code. | PP02 IT1028 Create UFI 1 |
| PO13 | 1028 | Position Address UFI Update | Use this script to update the position address Infotype with UFI code. | PP02 IT1028 COPY UFI 1 |
| PO13 | 1660 | Position Job Attributes - Duty Station County Code Create | Use this script to create the position Duty Station County Code on the Position Job Attributes Infotype IT1660. | PP02 IT1660 Create Duty Station County Code |
| PO13 | 1660 | Position Job Attributes - Duty Station County Code Update | Use this script to update the position Duty Station County Code on the Position Job Attributes Infotype IT1660. | PP02 IT1660 Update Duty Station County Code |
| PO13 | 1660 | Position Job Attributes – Position Sensitivity Update | Use this script to update the position sensitivity field on the position Job Attributes infotype 1660. | PP02 1660 Position Sensitivity Update |
| PO13 | 1660 | Position Job Attributes – Security Clearance Update | Use this script to update the position Job Attributes infotype, Security Clearance Field. This will not delete existing data that is in the field. | PP02 IT1660 Security Clearance Update |
| PO13 | 9901 | Position Telework/Flexible Work Status Create | Use this script to create the Telework/Flexible Work status for a position. | PP02 IT9901 Create 1 |
| PP02 | 1000 | Organizational Management Object Name Only Update |
Use this script to copy an Org Management Object and update the title. This script will not update the abbreviation. |
PP02 IT1000 Copy 1 |
| PP02 | 1000 | Organizational Management Object Update | Use this script to update the Object abbreviation and Object name for Organizational Management Object 1000 Infotype records. | PP02 1000 Create Object |
| PP02 | 1001 | Organizational Management Relationships Create | Use this script to create Org Management Relationships. | PP02 IT1001 Copy ORG Management Relationships 1 |
| PP03 | Position Create Pay Grade |
Use this script to create new positions that have the planned compensation set up as Pay Grade (WMS, EMS). This script will not update the Position to Position relationship or the Description Infotype. These update will need to be made after the position is created. This script will only update one line of cost coding on the Cost Distribution Infotype. If there are multiple lines needed. Only enter the agency default coding and use the script Position Cost Distribution Create to update the multiple lines of cost coding after the position is created. After the position is created, the new Position object ID will display in the New Position Object ID PM0D1-SEARK column. |
PP03 Create Position Pay Grade 1 | |
| PP03 | Position Create Pay Scale |
Use this script to create new positions that have the planned compensation set up as Pay Scale. This script will not update the Position to Position relationship or the Description Infotypes. These update will need to be made after the position is created. This script will only update one line of cost coding on the Cost Distribution Infotype. If there are multiple lines needed. Only enter the agency default coding and use the script Position Cost Distribution Create to update the multiple lines of cost coding after the position is created. After the position is created, the new Position object ID will display in the New Position Object ID PM0D1-SEARK column. |
PP03 Create Position Pay Scale 1 |