The Additional Adjustments tab can be loaded to the AAP after all mass changes have been made in the IPS.
Save the "IPS → AAP" tab of the IPS as a .CSV file.
Open the "IPS → CAT" tab
Scroll to the bottom of this tab and delete any rows that appear as so:
Press the "Click Here to Export File for AAP Upload" button
See the output file "Name.CSV" under the file menu.
The following box will appear in Excel. Select Okay.
The "Name.CSV" file will appear on your screen. You may close it out.
Navigate to the CAT
Workforce Administration > UW External HR Systems > Compensation Admin Tool > Upload to CAT and AAP Process (shown in images below).
Create a new Run Control ID or use an existing saved Run Control.
The Run Control ID is a unique identifier that saves the criteria for running a process or report.
While there is no set format for naming a Run Control ID, a potential suggested format is initials_next available number (eg "ABC01")
The following screen will appear:
Under "Process Options," choose between "Report" and "Process and Report."
The report mode should be run first.
The process mode should be run second.
The Fiscal Year should be automatically populated.
Select the appropriate "Inbound File Upload Criteria"
For File Type, select "Additional Adjustment"
For Business Unit, click the magnifying glass to search for the appropriate Business Unit. Click the green link for the Business Unit to select it.
For file description, there is no set format. A potential suggested format is "AAPCAT_IPS_YYYYMMDD" (e.g. "CAT_IPS_20160101")
Click the "Upload File" link next to the Attached File to browse for, select and upload the CSV file from Step 1.
Once the CSV file has uploaded, press the "Save" button at the bottom of the window.
Upload the AAP to the CAT.
Press "Run" at the top right of the window.
Press "OK" at the bottom of the new window.
You will have returned to your previous window. Note your Process Instance number. Press "Process Monitor" at the top right of the window.
The new window will indicate the status of your file upload. When the file is finished uploading, Run Status will be "Success" and Distribution Status will be "Posted."
Once the Run Status is "Success," and Distribution Status is "Posted," download the output.
Click "Details"
Click the "View Log/Trace" hyperlink at the bottom right of the window.
Under the File List, click the file with the .xls extension to download the output.
When opening the file, if an error message appears indicating that "the file you are trying to open.....is in a different format than specified by the file extension," click Yes.
Review the output file.
Open the downloaded Excel file.
The file will contain Error, Warning, and Successful sections.
Correct the AAP based on the errors in the output. Once all errors have been corrected, the upload can be run in Process mode.
OUTPUT HEADER FIELDS
REPORT PARAMETERS
FIELD NAME
DESCRIPTION
Run Control ID
The Run Control ID used to run the report or process
Run Date
The date the report was created or process run
Mode
The mode (report or process) used for the upload.
Process Instance
The unique number assigned by PeopleSoft for each report or process
Ran By
The unique user ID for the person who ran the report or process
REPORT STATISTICS
FIELD NAME
DESCRIPTION
Total AAP Records
The total number of AAP records evaluated
Processed
The total number of AAP records processed successfully
Processed with Warnings
The total number of AAP records processed but have warnings.
Rejected
The Total number of AAP records rejected because of errors.
Number (#)
Row Type
Description
Comments
Message
1
Error
Funding Department
not active in HRS Entire row errors out
Invalid Funding
Department
2
Error
Funding Department
does not match
Business Unit
Invalid Funding Department
3
Error
Fiscal Year not Active
in CAT
Fiscal Year not Active
in CAT
3.1
Error
Fiscal Year did not
match Run Control
Fiscal Year did not
match Run Control
4
Error
Invalid Fiscal Year, Funding
Department, Job Code, Pay
Basis, Position Number,
Business Unit, FTE, Adj Type,
Fund, DeptID, Program,
Budgeted Amount. Field Errors
Did not load
4.1
Error
Invalid Jobcode
Invalid Jobcode
4.2
Error
Invalid Pay Basis
Pay Basis not 'H,' 'A,' or 'C'
Invalid Pay Basis
4.3
Error
Invalid Position Type
Position Type not 'Vacant' or
'Bud. Adj.' Invalid Position Type,
needs to be either
Vacant or Bud. Adj.
4.4
Error
Invalid Position Number
Invalid Position
Number
4.5
Error
Invalid Adjustment Type
Adjustment Type not 'SH'
'Grad," "LTE," "Univ Staff,'
or 'LI/AS/FA' Invalid Adjustment
Type
4.6
Error
Invalid Business Unit GL
in Account Code
Invalid Business Unit
GL
4.7
Error
Invalid Fund Code in
Account Code
Invalid Fund Code
4.8
Error
Invalid Dept ID in
Account Code
Invalid Department
ID
4.9
Error
Invalid Program Code
in Account Code
Invalid Program Code
4.10
Error
Invalid Project ID in
Account Code
Invalid Project ID
5
Error
Identical AAP Row Exists
(entire row is key) AAP Row Exists entire row is
key not 'H' 'A' or 'C' Identical AAP Row
Exists in File/Table
6
Error
Incomplete funding string
(missing fund, DeptID, or
program) Funding string missing fund
DeptID or Program not 'H' 'A'
or 'C' Account Code is
invalid
7
Error
Row Errors out, no
budgeted amount entered
for positive FTE or no FTE Errors out no budgeted amount
entered for positive FTE or no
FTE not 'Vacant' or 'Bud. Err.'
7.1
Error
No FTE entered
No FTE for Empl Type 'LTE'
or 'SH' No FTE entered
7.2
Error
No budget amount for
position FTE
No budget amount
entered for position FTE
8
Error
Does not pass budget edits
Not pass budget edits error
'Vacant' or 'Bud. not.' No special messages.
The error messages
from Section 4 is used
for Budget Error Edits
9
Warning
Adj Type SH, FTE Entered
Everything will load except
the FTE, SH cannot have FTE
entered Adjustment Type SH,
FTE Entered
10
Warning
Adj Type LTE, FTE Entered
Everything will load except
the FTE, LTE cannot have FTE
entered Adjustment Type LTE,
FTE Entered
11
Successful
New Funding Department
Record Create New AAP record
Loaded Successfully
12 Successful Existing record, but unique
row (entire row is Key) Add to existing AAP record Loaded Successfully 13 Successful Row loads, Negative FTE,
$0 budgeted amount Loads Negative FTE budgeted
amount Loaded 'Vacant'
successful 'Bud. loa.' Loaded Successfully
Related KBs: