New for FY21 is the ability to upload Merit, Promotion, and Additional rate changes.
For users with Central Administrator role, a new feature allows them to upload/import rate adjustments into the application. Regardless of whether the System Member wishes to use Option 1 or Option 2 in regards to the Workday Merit Process, they can use the Upload / Import feature to add rate adjustments to the Position Budget Application.
The File to Upload
The file to upload must be of file type comma separated values (CSV) and contain the following columns as the first 5 columns:
- PositionID
- UIN
- Merit
- Additional
- Promotion
If the user wishes to add more columns, they may do so at their own discretion, but must be added after the first 5 required columns. The System Budget Office has a template that members can get. The first row of the file must be a header row. The values must be in the format of 0.000000. example: for 3.2579% the value in the file should be 0.032579.
The Upload Process
When the user presses the Upload button, they will be allowed to select only .csv files. When they select a file and click Ok, the file will automatically begin to upload. The process will skip the first row (the header row) and begin validating at the second row. The following validations are performed during the upload process:
- Rounding of the values to 6 decimal places
- Checks the values uploaded for errors
- Greater than 99% is a critical error (cannot be committed)
- Less than 0% is a critical error (cannot be committed)
- Greater than 10% is a warning (can be committed)
- UIN is currently in the Position
- User is authorized for the Position
After the validation process has occurred, the positions are sent back to the user’s screen so they can see if there were any problems with the validation process. If there were problems, the user can edit the CSV file and go through the upload process again which will overwrite what is on the user’s screen after the modified file is validated.
The Commit Process
When the user is satisfied with the adjustments, they can click the “Commit” button. This will send the adjustments that are listed on their screen to the server to be saved and recalculated. NOTE: adjustments with Critical Errors (highlighted in red) WILL NOT be committed. This process can take a while. There are a lot of data-related things happening. There is a Status area at the top of the screen that will let the user know what is happening during the process. If the user leaves the screen, the process will continue, you just won’t know when the process is completed.