Winshuttle

Procedure Updated: 
Monday, May 19, 2025

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?

  1. Download the spreadsheet for the desired script.
  2. 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.

  1. Send the completed spreadsheet to HeretoHelp@ofm.wa.gov outlining in the request:
    1. The reason for the mass updates.
    2. The approximate number of records.
    3. 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
Transaction PA30 Infotype 0001 Script Name Organizational Assignment Create Use 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.  Spreadsheet PA30 IT0001 Create Save
Transaction PA30 Infotype 0001 Script Name Organizational Assignment Create Save Start Date Use 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. Spreadsheet PA30 IT0001 Create Save Start Date
Transaction PA30 Infotype 0001 Script Name Organizational Assignment Org Key Update Use Use this script to update the Org. Key field on the Organizational Assignment Infotype 0001. Spreadsheet PA30 IT0001 Org Key 1
Transaction PA30 Infotype 0001 Script Name Organizational Assignment Personnel Subarea Update Use Use this script to update the Personnel Subarea for an employee. Spreadsheet PA30 IT0001 Personnel Subarea Update 1
Transaction PA30 Infotype 0001 Script Name Organizational Assignment Time Admin Code Update Use 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. Spreadsheet PA30 IT0001 Time Admin Code Update 1
Transaction PA30 Infotype 0006 Script Name Address – Create Out of State Work Location Subtype 9 Use 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. Spreadsheet PA30 IT0006 Create Out of State Work Location Address
Transaction PA30 Infotype 0007 Script Name Planned Working Time Update Use Use this script to change the Work Schedule Rule in Planned Working Time  IT0007. Spreadsheet PA30 IT0007 Copy Update
Transaction PA30 Infotype 0007 Script Name Planned Working Time-  ACA Status Code Update Use

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.

Spreadsheet PA30 IT0007 Copy ACA Status Code 1
Transaction PA30 Infotype 0007 Script Name Planned Working Time-EEPercentage Update Use Use this script to update Employee Percentage in Planned Working Time IT0007. Spreadsheet PA30 IT0007 EE Percentage Copy Update
Transaction PA30 Infotype 0008 Script Name Basic Pay - Next Increase Date Update Use Use this script to copy the existing Basic Pay Infotype 0008 record and enter the next increase date. Spreadsheet PA30 IT0008 Next Increase 1
Transaction PA30 Infotype 0008 Script Name Basic Pay - Additional Wage Types Delete Use 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. Spreadsheet PA30 IT0008 Delete Additional Wage Types Reason Code
Transaction PA30 Infotype 0008 Script Name Basic Pay Create Use

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).

Spreadsheet PA30 IT0008 Create 1
Transaction PA30 Infotype 0008 Script Name Basic Pay Update - Pay Scale Use

Use this script to update an existing basic pay record for employees that are on a pay scale. This script is hard coded for the end-date to be 12/31/9999. It will override any future dated basic pay records. The Next Increase Date is needed for employees that are not at the top PS Level (Step) for them to receive their PID/Longevity step on time.  This script will copy additional wage types that are on the previous record.

Spreadsheet PA30 IT0008 Copy Update PS Group PS Level
Transaction PA30 Infotype 0008 Script Name Basic Pay - Add Additional Wage Types Update Use 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. Spreadsheet PA30 IT0008 Assn Pay Flex Reason Code
Transaction PA30 Infotype 0008 Script Name Basic Pay - Directly Valued Employees Update Use

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.

Spreadsheet PA30 IT008 Dir Val WT Update
Transaction PA30 Infotype 0008 Script Name Basis Pay - Capacity Utilization Level and Working Hours per Payroll Period Update Use

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.

Spreadsheet PA30 IT0008 Capacity Utility Level and Work Hours Period Copy Update
Transaction PA30 Infotype 0014 Script Name Recurring Payments/Deductions Change End Date Use 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. Spreadsheet PA30 IT0014 Change 1
Transaction PA30 Infotype 0014 Script Name Recurring Payments/Deductions Create Use

Use this script to create Recurring Payments/Deductions records for employees.

The Assignment number field is not required. 

Spreadsheet PA30 IT0014 Create 1
Transaction PA30 Infotype 0014 Script Name Recurring Payments/Deductions with Cost Assignment Use

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.

Spreadsheet PA30 IT0014 with Cost Assignment
Transaction PA30 Infotype 0015 Script Name Additional Payments Create Use 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. Spreadsheet PA30 IT0015 Create 1
Transaction PA30 Infotype 0015 Script Name Additional Payments Create with Assignment Use

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.

Spreadsheet PA30 IT0015 Create With Assignment 1
Transaction PA30 Infotype 0015 Script Name Additional Payments with Cost Assignment Use

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.

Spreadsheet PA30 IT0015 with Cost Assignment
Transaction PA30 Infotype 0015 Script Name Additional Payments Delete Use Use this script to delete wage types in IT15 within date range. Spreadsheet PA30 IT15 Delete 1
Transaction PA30 Infotype 0019 Script Name Monitoring of Task Update Use 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. Spreadsheet PA30 IT0019 Update
Transaction PA30 Infotype 0019 Script Name Monitoring of Task Update the Processing Indicator Status Use Use this script to update the Processing Indicator Status on the Monitoring of Task Infotype 0019. Spreadsheet PA30 IT0019 Change Processing Indicator Status 1
Transaction PA30 Infotype 0027 Script Name Employee Cost Distribution Create Use Use this script to create IT0027 records for employees. The end-date defaults to 12/31/9999. Spreadsheet PA30 IT0027 Update 1
Transaction PA30 Infotype 0027 Script Name Employee Cost Distribution Create with End Dates Use Use this script to create IT0027 with end date records for employees. Spreadsheet PA30 IT0027 Update End Date 1
Transaction PA30 Infotype 0040 Script Name Objects on Loan Create Use Use this script to create the Object on Loans (IT0040). Spreadsheet PA30 IT0040 Create 1
Transaction PA30 Infotype 0041 Script Name Date Specifications Update Use

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.” 

Spreadsheet PA30 IT0041 Update 1
Transaction PA30 Infotype 0077 Script Name Additional Personal Data – Public Service Loan Forgiveness Status Update Use Use this script to update the PSLF Status and PSLF Date on the Additional Personal Data infotype 0077. Spreadsheet PA30 IT0077 PSLF Status Update
Transaction PA30 Infotype 0081 Script Name Military Service Create Use

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 

Spreadsheet PA30 IT0081 Create
Transaction PA30 Infotype 0094 Script Name Residence Status Commercial Driver's License (CDL) Create Use 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. Spreadsheet PA30 IT0094 Create Drivers License
Transaction PA30 Infotype 0105 Script Name Email Address Update Use Use this script to update employee email addresses on the Communications Infotype 0105, Subtype 0010. Spreadsheet PA30 IT0105 SType 0010 Update 1
Transaction PA30 Infotype 0105 Script Name Email Address - End Date Use Use this script to end date employee email addresses. Spreadsheet PA30 IT0105 SType 0010 End Date
Transaction PA30 Infotype 0105 Script Name WD1A Update Use

Use this script to add Communication Subtype WD1A to the Communications Infotype 0105. 

Enter the personnel number in the Communication Identification/Number column.

Spreadsheet PA30 IT0105 SType WD1A Update
Transaction PA30 Infotype 0234 Script Name Add. Withh. Info. US Update Use 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. Spreadsheet PA30 IT0234 Copy Update 1
Transaction PA30 Infotype 0235 Script Name LTSS WA Cares Fund EE Exemption tax type 113 Use

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.

Spreadsheet PA30 IT0235 LTSS WA Cares Fund EE Exemption Tax Type 113
Transaction PA30 Infotype 0416 Script Name Time Quota Compensation Create Use Use this script to create a Time Quota Compensation record for an employee. Spreadsheet PA30 IT0416 Create Quota Compensation 1
Transaction PA30 Infotype 2006 Script Name Absence Quotas Change Use 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. Spreadsheet PA2006 Change
Transaction PA30 Infotype 2010 Script Name Employee Remuneration Info Create Use Use this script to create Employee Remuneration Info IT 2010. Spreadsheet PA30 Create Employee Remuneration 1
Transaction PA30 Infotype 2010 Script Name Employee Remuneration Info Create Wage Type Amounts with Cost Coding Use Use this script to create Employee Remuneration Infotype for wage types that you enter payment amounts and cost coding. Spreadsheet PA30 IT2010 WT Amount Cost Coding
Transaction PA30 Infotype 2013 Script Name Quota Corrections Create Use Use This Script to create Quota Corrections. Default options are to Increase generated entitlement and Transfer collected entitlement immediately. Spreadsheet PA2013 Create
Transaction PA30 Infotype 9105 Script Name Employee Duty Station Create Use

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.

Spreadsheet PA30 IT9105 CREATE 1
Transaction PA30 Infotype 9105 Script Name Employee Duty Station - End Date Use Use this script to end date the Employee Duty Station Address (IT9105) override. Spreadsheet PA30 9105 End Date
Transaction PA30 Infotype 9106 Script Name Employee Telework/Flexible Work Create Use

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.

Spreadsheet PA30 IT9106 Create 1
Transaction PA30 Infotype 9106 Script Name Employee Telework/Flexible Work  - End Date Use

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.

Spreadsheet PA30 IT9106 End Date
Transaction PA30 Infotype 9106 Script Name Employee Telework/Flexible Work without Flex Hours Use

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.

Spreadsheet PA30 IT9106 Create No Flex Hours 1
Transaction

PA40

Infotype   Script Name Appointment Change Action Update Employee Subgroup Use

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.

Spreadsheet PA40 Appointment Change Change EE Subgroup 1
Transaction PA40 Infotype   Script Name Separation Action Create (PA) Use Use this script to perform part of the personnel administration processor portion of a PA40 separation action.

This script will update the following infotypes: 
  • Action (0000)
  • Organizational Assignment (0001)
  • Employee Cost Distribution (0027)
  • Date Specifications (0041) 
  • Position Relationship (1001)

This script will not update the following Employee Master Data infotypes:

  • Duty Station Address (9105)
  • Telework/Flex Work (Employee) (9106)
  • Communication - E-mail (0105 - subtype 0010) 

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).

This script will not update the Position Vacancy infotype (1007), see Position Vacancy script, if desired, for position vacancy clean-up.

Spreadsheet Separation Action Create (PA)
Transaction  PO11 Infotype 1001 Script Name Org Unit to Cost Center Relationships Create Use Use this script to create org unit to cost center relationships. Spreadsheet PP01 Org to Cost Center Rel 1
Transaction PO13 Infotype 1001 Script Name Position to Org Unit Relationship Update Use Use this script to update Position to Org Unit Relationships. Spreadsheet PP01 IT1001 Position To ORG REL 1
Transaction PO13 Infotype 1001 Script Name Position to Position Relationship Update Use Use this script to update Position to Position relationships. Spreadsheet PP01 IT1001 Position To Position REL 1
Transaction PO13 Infotype 1002 Script Name Position Description Create Use Use this Script to create Org Unit or Position Description Infotype IT0002. Spreadsheet PP02 IT1002 Create Description 1
Transaction PO13 Infotype 1005 Script Name Position Planned Compensation - Pay Grade Create Use 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.  Spreadsheet PP02 IT1005 Create Position Pay Grade 1
Transaction PO13 Infotype 1005 Script Name Position Planned Compensation - Pay Scale Create Use 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. Spreadsheet PP02 IT005 Create Position Pay Scale 1
Transaction PO13 Infotype 1007 Script Name Position Vacancy - Create Use Use this script to create position vacancy infotype records. Spreadsheet PP02 IT1007 Create
Transaction PO13 Infotype 1008 Script Name Position Account Assignment Features Update Use Use this script to update the position Account Assignment Features. Spreadsheet PO13 IT1008 Copy 1
Transaction PO13 Infotype 1011 Script Name Position Work Schedule - Percentage Update Use Use this script to copy a position's current Work Schedule record and update the percentage on IT1011. Spreadsheet PP02 IT1011 Work Schedule Copy Update Position Percentage
Transaction PO13 Infotype 1013 Script Name Position Employee Group/Subgroup Update Use Use this script to update position Employee Group and Employee Subgroup. Spreadsheet PP02 IT1013 Update 1
Transaction PO13 Infotype 1018 Script Name Position Cost Distribution Create Use Use this script to create cost distribution for positions. The end date defaults to 12/31/9999. Spreadsheet PP02 1018 Update 1
Transaction PO13 Infotype 1028 Script Name Position Address UFI and Optional Fields Update Use Use this script to update the position address Infotype with UFI code and other optional fields. Spreadsheet PP02 IT1028 Copy Address All Fields 1
Transaction PO13 Infotype 1028 Script Name Position Address UFI Create Use Use this script to update the position address Infotype with UFI code. Spreadsheet PP02 IT1028 Create UFI 1
Transaction PO13 Infotype 1028 Script Name Position Address UFI Update Use Use this script to update the position address Infotype with UFI code. Spreadsheet PP02 IT1028 COPY UFI 1
Transaction PO13 Infotype 1660 Script Name Position Job Attributes - Duty Station County Code Create Use Use this script to create the position Duty Station County Code on the Position Job Attributes Infotype IT1660. Spreadsheet PP02 IT1660 Create Duty Station County Code
Transaction PO13 Infotype 1660 Script Name Position Job Attributes - Duty Station County Code Update Use Use this script to update the position Duty Station County Code on the Position Job Attributes Infotype IT1660. Spreadsheet PP02 IT1660 Update Duty Station County Code
Transaction PO13 Infotype 1660 Script Name Position Job Attributes – Position Sensitivity Update Use Use this script to update the position sensitivity field on the position Job Attributes infotype 1660. Spreadsheet PP02 1660 Position Sensitivity Update
Transaction PO13 Infotype 1660 Script Name Position Job Attributes – Security Clearance Update Use Use this script to update the position Job Attributes infotype, Security Clearance Field. This will not delete existing data that is in the field. Spreadsheet PP02 IT1660 Security Clearance Update
Transaction PO13 Infotype 9901 Script Name Position Telework/Flexible Work Status Create Use Use this script to create the Telework/Flexible Work status for a position. Spreadsheet PP02 IT9901 Create 1
Transaction PP02 Infotype 1000 Script Name Organizational Management Object Name Only Update Use

Use this script to copy an Org Management Object and update the title.

This script will not update the abbreviation.

Spreadsheet PP02 IT1000 Copy 1
Transaction PP02 Infotype 1000 Script Name Organizational Management Object Update Use Use this script to update the Object abbreviation and Object name for Organizational Management Object 1000 Infotype records. Spreadsheet PP02 1000 Create Object
Transaction PP02 Infotype 1001 Script Name Organizational Management Relationships Create Use Use this script to create Org Management Relationships. Spreadsheet PP02 IT1001 Copy ORG Management Relationships 1
Transaction PP03 Infotype   Script Name Position Create Pay Grade Use

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.

Spreadsheet PP03 Create Position Pay Grade 1
Transaction PP03 Infotype   Script Name Position Create Pay Scale Use

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.

Spreadsheet PP03 Create Position Pay Scale 1