/
What took the place of the TRAQS database table for SSRS use

What took the place of the TRAQS database table for SSRS use



Description of Issue

An SSRS report references the prtxtraq table which has no data after 2017.



Context

  • Payroll

  • Texas

  • TX TRS Report



Cause

  • TX TRS moved from TRAQS reporting to Teams reporting in 2017

  • The Munis TRAQS program was consequently replaced with the TX TRS Report program



Resolution

  • The SSRS view for the TX TRS Report Period Records is pr_tx_trs_detail

  • A new SSRS view was also added for TX TRS Maintenance: pr_tx_retirement



Additional Information