Paysheet Holding Load (PSHUP_TXN)
Purpose: Use this document as a reference for how to load the PSHUP File Template .CSV file to the Paysheet Holding Update (PSHUP_TXN) staging table.
Audience: Payroll Administrators, Benefits Administrators, Faculty Workload Administrators
You must have at least one of these local college managed security roles:
- ZD FWL HCM View Pay
- ZZ FWL HCM Pay Process
- ZZ Payroll Processing
- ZZ SS Payroll
If you need assistance with the above security roles, please contact your local college supervisor or IT Admin to request role access.
This procedure expects only CSV formatted files for the PSHUP load process. Any other file type will generate an error during the load process. This assumes you have already received the proper formatted file or the file was created following the procedure for Utilizing the PSHUP File Template QRG.
Paysheet Holding Load (PSHUP_TXN)
Navigation: Payroll for North America > CTC Custom > CTC Processes > Paysheet Holding Load
- The Paysheet Holding Load run control Find an Existing Value search page displays.
- If you have run this process or report in the past, select the Find an Existing Value tab to enter an existing Run Control ID and click the Search button. If this is the first time running this process or report, select the Add a New Value tab to create a new Run Control ID and click the Add button.
- NOTE: It is important to note that Run Control IDs cannot be deleted. Do not include spaces in your Run Control. We encourage the Run Control ID to have the same process naming convention but unique to the step; because of this, including your institution code and a short process description in the Run Control ID is recommended--e.g., WA220_ADM_FYR_5 (Institution, Process).
- The Paysheet Holding Load (PSHUP_TXN) page displays.
- In the Paysheet Holding Load File section, select the Attach File icon to select the CSV formatted file to be loaded.
- The File Attachment pagelet displays.
- Select the Choose File button to open your computer's File Explorer.
- Locate and select the file.
- Select the Open button in the file explorer window.
- Select the Upload button on the File Attachment pagelet.
- Back on the Paysheet Holding Load (PSHUP_TXN) page, select the Run button.
- The Process Scheduler Request page displays.
- Select the OK button to initiate the PSHUP Holding Load process.
- When the process has completed, select the Details or Actions link.
- Select the Review Log/Trace link to confirm process success or to identify issues.
- There are two logs provided in the File List section of the View Log/Trace page:
- The main log file (Naming convention = AE_CTC_PSHUP_AE_process instance number.log).
- The InvalidValues.log showing lines that did not load (aka issues) If this log file size = 0, then there are no errors.
- Select the log file link to open and view the information.
- If the InvalidValues.log file showed a file size greater than 0, select that log file link to open and review message(s).

- If there are issues encountered during the process to load files to the Paysheet Holding Update (PSHUP_TXN) staging table:
- Identify the issue creating the error.
- Determine where and how in HCM to fix the error.
- If the error count is few, consider entering the corrected line(s) in the staging table directly. Follow instruction in the Paysheet Holding Update (PSHUP_TXN) QRG.
- If the error count is high, consider putting the corrected error lines on an appropriate PSHUP File Template.
- Run this load process again for those lines that did not originally load.
Video Tutorial
The video below demonstrates the process actions described in the steps listed above. There is no audio included with this video. Select the play button to start the video.
Video Tutorial via Panopto
View the external link to Paysheet Holding Load (PSHUP_TXN). This link will open in a new tab/window.
0 Comments
Add your comment