Special Salary Adjustments

Jira Reference: FT-818

Background

Need to import special salary adjustment (SSA) data field from Peoplesoft and present this on the Eligibility tab.  The field indicates if an SSA has been awarded. We need coordinators to indicate if an SSA was for merit (vs. equity or retention); and if so to upload the SSA documentation.  The achievements for Merit SSAs should not be considered for tenure or promotion actions, and currently there is no way for a reviewer to know this.

Requirements

Add SSA field(s) to the eligibility tab

• Need an input box to display the latest SSA, a checkbox to indicate whether the SSA was for merit or not, and an upload element to upload the SSA

• Cameron Ahana mockup what it'll look like on the eligibility tab

This only applies to promotion apps (Tenure w/ automatic promotion, Tenure and Promotion, Promotion Only)

Questions

• Where do we get the SSA data from?
  • hr_ps_report_tbl in the HR datamart

  • select *
    from hr_ps_report_tbl
    where pers_action in ('PAY', 'PYC')
    and pers_reason in ('480', '481’)

    Clinton responded: Take a look and see if this is what you’re looking for.  In theory, each employee should not have more than 1 SSA within a 12 month period.  So for example if I got an SSA effdt’d 10/16/2024, the next time I would be eligible for another SSA would be 10/17/2025.  But there is nothing in the system to stop entry of multiple SSAs within a 12 month period.  Jane folks run reports to try to clean up the data and follow up with units.  More FYI for you not sure if it will affect you for the purposes you will be using this for.
• What pers_reason do we look for?
  • Functionals said to pull in action_reason 406; they haven’t seen 480 or 481 used but Leilani is checking with OHR