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

Owned by Knowledge Assistant
Apr 04, 2022
1 min read



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