Montata TRS Monthly Report & File

SunGard Bi-Tech Notes

TRS Report/File for the State of Montana

August 28, 2000     Version 1.1

The process for producing the TRS report and file for the state of Montana is available via mask PYRERRMTTR. 

Before running the process, the common code PYFG/PY780C must be set up.  Following is a sample screen shot of this common code:

 Q''2BI-TECH                  Vanilla Organization                Copyright1''W

 1((2Software       C O M M O N    C O D E S    M A S T E R       (C)  20001((2

 )                                                                            )

 )      Code Category:  PYFG   Code Value:  PY780MT    Ledger: @@             )

 )                                                                            )

 )  Short Description:   EBUG                                                 )

 ) Medium Description:                                                        )

 )   Long Description:                                                        )

 )                                                                            )

 )                                                                            )

 )  Q;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;W  )

 )  :               ASSOCIATED VALUES, CODES & DESCRIPTIONS                :  )

 )  199999999999999999939999999999999999399999999999999999999999999999999992  )

 )  :  Numeric Values  )      Codes     )   Descriptions                   :  )

 )  199999999999999999909999999999999999099999999999999999999999999999999992  )

 )  :                  )  ABCDEF        )  <Agency Number                  :  )

 )  :         1.00000  )                )  <TRS Paybase                    :  )

 )  :         2.00000  )                )  <TRS Hourbase                   :  )

 )  :                  )                )                                  :  )

 )  :                  )                )                                  :  )

 )  A;;;;;;;;;;;;;;;;;;4;;;;;;;;;;;;;;;;4;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;S  )

 )                                                                            )

 A92 f4 for HELP  E    Find Category:     , Value:         , Ledger:        19S

The following table describes the required values:

Before running the process, a number of deductions and contributions must be set up.  Miscellaneous Code (1) of these CDH definitions determine the type of TRS processing performed by the process.  Following are the possible values of Miscellaneous Code (1) for TRS CDHs:

·       TRS            Regular deduction and contribution.

·       TRSH         Hourly employee deduction

·       TRSP          Part-time employee deduction

·       TRSW         Working retiree deduction

·       TIAA          TIAA/CREF plan deduction and contribution

·       TRSB          Buyback deduction and contribution

·       TRS1          Term Pay deduction and contribution, option 1        

·       TRS2          Term Pay deduction, option 2

For sake of discussion, TRS CDHs will be referred to by their Miscellaneous Code (1) value.  For example, a TRSB contribution is a CDH with TRSB in Miscellaneous Code (1).

Note that all TRS related CDHs need start and stop dates so the process can determine the start/stop dates for TRS participation which is reported in the resultant file.

When the process runs, the user will input the month/year to be reported.  The process will include all periods with a check date within this month for the report.

The resultant file is named TRSyymm where yymm if the year/month being reported.

The employee type is determined by the type of TRS deduction for the employee.  The following table demonstrates this:

Note that if an employee has more than one of the above deductions active in a particular reporting month, results will be unpredictable.

The following table includes all file and report fields developed from the data and indicates which data is included in each field: