TRS Team Report
TRS Teams Report Overview
The data provided in this report is used to replace the old TRS report. Every paid employee is reported with Demographic, Position, and Payroll information. To avoid submitting the same employee multiple times, after records are verified and the submission file created, the user must go back to the submission menu option and enter the date the file was submitted.
Report Frequency
Every month.
Selection Criteria
Employees are selected based upon their Pay Assignments and Pay History.
BusinessPlus Setup
The Statutory Minimum report must be run prior to the TEAM report every month.
Setup
Before a report can be generated, the reporting interface must be accessed, and necessary data setup completed. This configuration information is used by the Load and Submission processes.
Click Site Profile to define the entities and their details. This information is used by the Load and Submission processes for the defined entities. At least one Site Profile record is required. Site-sensitive information has been cleared.
To add details about a site, enter data in the fields as described below.
Field | Description |
|---|---|
Entity | ID of the entity/employer. The entity should be a valid entry as defined in BusinessPlus. Once saved, the value cannot be changed. |
Employer Name* | Name of the employer for whom the entity is defined. |
Employer Address* | First line of the employer’s address. |
Employer Address (2) | Second line of the employer’s address. |
Employer City* | City in which the employer is located. |
Employer State* | State in which the employer is located. Click for the list of states. |
Employer Zip Code* | Numeric zip code of the employer’s location. This field accepts only five numeric characters and does not allow all five characters to be zeroes. |
Employer Zip Code Extension | Numeric zip code extension of the employer’s location. This field accepts only numeric characters of 4 digits or less |
District ID* | Employer’s District Identification number. |
Crosswalk Mapping:
Click Crosswalk to map Employee data to Reporting data. This data is used during the Load process to convert Employee data to the Report’s codes.
Code Item Drop-Down Menu
Code Item | Description |
|---|---|
TXTRSPOSCODE | TRS Position Code Mapping |
TXTRSEMPLTYPE | Employee Type Mapping to Reporting Code |
TXTRSTERMCODE | Termination Reason Code Mapping to Reporting Code |
Code Item Fields
Fields | Description |
|---|---|
Source Value* | The Data used in your database |
Source Description | A short description of the Source Value |
Reporting Value* | The coded value to report |
Reporting Description | A short description of the Reporting Value |
Additional Set Up
Additional Setup contains miscellaneous fields to customize where the Load gathers data.
Entity* | Entity associated with the Site Profile. |
Setup Description* | The field that requires setup. |
Setup Value* | The actual value corresponding to the setup. |
Comments | Additional notes. |
Setup Values
Fields | Description |
CATEGORY - EXCLUSIONS | The following fields are EXCLUSIONS: |
Excluded Employee Last Names | Comma-separated list of last names |
Excluded Employee IDs | Comma-separated list of IDs |
Excluded Pay_classes from hours worked | Comma-separated list of Pay Classes |
Excluded Pay_classes from days worked | Comma-separated list of Pay Classes |
Excluded codes from Federal Comp CDH List | Comma-separated list of CDH codes |
Excluded ED40 Positions List | Comma-separated list of Positions |
Excluded RP20 Positions List | Comma-separated list of Positions |
Excluded RP20 CDHs List | Comma-separated list of CDH Codes |
Excluded Pay_classes from (only) ED40 | Comma-separated list of Pay Classes |
CATEGORY - INCLUSIONS | The following fields are INCLUSIONS: |
Included Rec_types from hours worked | Comma-separated list of Record Types |
Included Rec_types from days worked | Comma-separated list of Record Types |
Included Assignment_status for hours worked | Comma-separated list of Assignment Status |
Included Assignment_status for days worked | Comma-separated list of Assignment Status |
Included PayClass for Timecard Days | Comma-separated list of Pay Classes |
CATEGORY - PAY BASES | The following fields are PAY BASES: |
Eligible TRS Gross Pay Base | Single-digit Pay Base associated with Eligible TRS Gross Pay |
Total Gross Pay Base | Single-digit Pay Base associated with Gross Pay |
CATEGORY - HOUR BASES | The following fields are HOURS BASES: |
Valid Hours Hours-Base | Single-digit Pay Base associated with valid hours |
Full Time minimum hours requirement | Double-digit number of hours to denote Full Time employment |
Pay/Hour Base Vector? | Option to select Pay Base vector to use: PAY_VECT, HRS_VECT, or BOTH |
Overtime Hours Base Flag | Single-digit Pay Base associated with valid overtime hours |
CATEGORY - CDH LISTS | The following fields are CDH LISTS: |
Performance Pay CDH List | Comma-separated list of CDHs involving Performance Pay |
Member Contribution CDH List | Comma-separated list of CDHs involving Member Contributions |
Member TRS-Care Contribution CDH List | Comma-separated list of CDHs involving Member TRS-Care Contributions |
RE TRS-Care Contribution CDH List | Comma-separated list of CDHs involving RE TRS-Care Contributions |
Eligible Comp. from Fed Funds/Prvt Grants | Comma-separated list of CDHs involving Federal Funds/Prvt Grants Compensation |
Fed Funds/Prvt Grants Contribution | Comma-separated list of CDHs involving Federal Funds/Prvt Grants Contribution |
Federal TRS Contribution CDH List | Comma-separated list of CDHs involving Federal TRS Contribution |
RE Payment for New Member Contribution | Comma-separated list of CDHs involving RE Payment for New Members |
RE Payment for Non-OASDI Member Contribution | Comma-separated list of CDHs involving RE Payment for Non-OASDI Members |
Adjusted State Minimum Comp CDH List | Comma-separated list of CDHs involving Adjusted State Minimum Compensation |
Statutory Minimum Contribution CDH Lists | Comma-separated list of CDHs involving Statutory Minimum Contributions |
Service Credit Purchase CDH List | Comma-separated list of CDHs involving Service Credit |
Pension Surcharge Cont CDH list | Comma-separated list of CDHs involving Pensions |
TRS Care Surcharge Contribution CDH List | Comma-separated list of CDHs involving TRS Care Surcharges |
TRS Group Benefit Coverage CDH List | Comma-separated list of CDHs involving TRS Group Benefit Coverage |
TRS Social Security CDH List | Comma-separated list of CDHs involving TRS Social Security |
TRS Medicare CDH List | Comma-separated list of CDHs involving TRS Medicare |
CATEGORY - POSITION | The following fields are Position Info: |
TRS Position Field Location | Where the TRS Position is stored. |
TRS Position Field Start Position | If the TRS Position is a SUBSTRING of another field, the starting position. LEAVE BLANK otherwise. |
TRS Position Field Length | If the TRS Position is a SUBSTRING of another field the length. LEAVE BLANK otherwise. |
Use TRS Position Crosswalk (Y/N) | Indicates whether the TRS Position needs mapped via the Crosswalk Setup or not. |
CATEGORY - EMPLOYEE TYPE | The following fields are Type Info: |
TRS Employee Type Field Location | Where the Employee type is stored |
TRS Employee Type Field Start Position | If the Employee type is a SUBSTRING of another field, the starting position. LEAVE BLANK otherwise. |
TRS Employee Type Field Length | If the Employee type is a SUBSTRING of another field, the length. LEAVE BLANK otherwise. |
Use Employee Type Crosswalk (Y/N) | Indicates whether the Employee type needs mapped via the Crosswalk Setup or not |
CATEGORY - RETIREMENT | The following fields are Retirement Setup (CHOOSE ONLY ONE OF THE FOLLOWING!): |
TRS Retirement Date Field | Where the Retired Date Field is located |
TRS Retiree Assoc. Code Setup (Code,Prefix) | Where the Retired Code is in Association Codes |
CATEGORY - TERMINATION | The following fields are Termination Setup: |
List of Valid Termination Date Fields | Where the Term Date is located. Also accepts comma-separated lists in order of precedence. |
Termination Code Location | Where the Term Code is located |
Use Termination Code Crosswalk (Y/N) | Indicates whether the Term Code needs mapped via the Crosswalk Setup or not |
CATEGORY - CHILD NUTRITION | The following fields are Child Nutrition Setup: |
Labor Cost Percent | Labor Cost Percent. NO % sign. |
Federal Fund/Private Grant Contribution Percent | Federal Fund/Prvt Grant Percent. NO % sign. |
Federal Grant TRS-Care Contribution Percent | Federal Grant TRS-Care Percent. NO % sign. |
Child Nutrition Fund Code | Fund code used to pay Child Nutrition |
CATEGORY – SUMMER | The following fields are SUMMER Setup: |
Split RP20 on Summer CDH codes? Y/N | Indicates where to split out a Summer Record |
Summer codes CDH List | Comma-separated list of CDH Codes |
Summer 09 Start Date | Date used as the Summer Record start date |
Summer 09 End Date | Date used as the Summer Record end date |
Summer Default Days | Number of days to default the Summer Record to |
Summer Default Hours Worked | Number of hours per month to default the Summer Record to |
Summer Default Hours Scheduled | Number of hours per week to default the Summer Record to |
CATEGORY - MISC | The following fields are MISC Setup: |
Fund Codes for Federal Compensation | Comma-separated list of all FUND codes associated with Federal Compensation. Ranges allowed. |
Employee IDs for TRS Tests | Comma-separated list of IDs to Load. Only affects INSTANCES flagged with “TRS Test Instance?” |
TRS Pay Unit Misc Field Number | Where the Pay Unit is stored (e.g., 5 would be misc5) |
TRS Group Benefit Coverage Field | Where the Group Benefit Coverage is stored |
Instance
Select Instance to configure the report instances for each report to be created. Report instances need to be configured for the extract process.
Use the Navigation Bar to:
Cycle Instances
Edit Instance
Add/Delete Instance
Enter data in the fields as described below.
Field | Description |
|---|---|
Name* | The user-created name for the instance |
Start Date* | The beginning of the month to be reported |
End Date* | The end of the month to be reported |
TRS Test Instance? | Do not use Check Box to flag the instance as TEST |
Allowable Federal Fund Base | Total funds associated with Child Nutrition |
Columns marked with * are required fields.
Instances are sorted alphabetically.
Submission Details
At the bottom of the instance screen, the Submission Details adjusts the status of the Instance.
Fields | Description |
|---|---|
Status | ACTIVE – Can [view], [edit], [delete], [load], [submit] LOCKED – Can only [view]. Temporary. (Do not use.) SUBMITTED – Can only [view]. Finalized and submitted to the state. |
Date Submitted | Date Submitted Date that the Instance’s report was accepted by the state. |
Load:
Select Load to select the Report Instance for which to extract and load the eligible records into the maintenance table.
For TRS TEAM, the process is split into two sections. Upload File and Load Criteria.
Upload File
Upload File is a tool to import records that successfully posted to TRS.
Upload Files before using Load Criteria.
Only import each file once per report month.
After files have been uploaded, you can skip the upload step when using the Load tab until next month.
Field/ Button | Description |
|---|---|
Import Report Date* | Insert a date that the file represents. For example: Last month’s file would need any date in last month. |
Import File Name* | Select “…” to browse the local computer for the file to upload. Multiple files allowed. |
Import Retiree Correction File? | Check this box to import a Retiree Correction File. This is a separate process and file to apply fixes to the ER20s if necessary. Leave blank unless needed. |
Delete old files? | Check this box to delete old files associated with the selected Import Report Date. Only use this option if unsure which files were previously uploaded. |
Upload | Select to upload the selected files for processing during the Load Criteria |
Load Data
To load data for an instance of a report, enter data in the fields as described below.
Field / Button | Description |
|---|---|
Report Instance* | Click for the list of report instances. Select the desired report instance. |
Status | Displays the current status as assigned in the Report Instance screen. This is a display only field. |
Notes | Enter a note related to the report instance or load that is to be performed. |
Entity* | Click to select a specific entity for which the load will be performed. Select ‘ALL’ to extract records of all entities. |
Employee ID(s) | If specific IDs are to be refreshed or reported on, enter on this line, separated by commas. |
Purge Existing Data | If all the existing maintenance table data, for the selected ‘Report Instance’, needs to be deleted this checkbox should be checked. This action would also remove new maintenance records added previously using the maintenance screen. |
Load | Click to load maintenance records into the maintenance table. |
Import Retiree Correction | Check this box to process the last uploaded Retiree Correction File. Leave blank unless needed. |
Import Previous Month | Check this box to process all files uploaded with the previous month report date . Creates a “Previous Month” instance of all records Posted to TRS. |
Columns marked with * are required fields.
After clicking Load the following window appears, to indicate that the Load Process has begun. Click on the OK button to proceed further.
The selected report instance details appear as described below.
Field | Description |
|---|---|
Report Instance Details | Details of the selected Report Instance. |
Last Load for the Selected Report Instance | The date (Last Load) and user (Created By) who performed the last load and any note entered for the selected Report Instance. If the report is loaded for the first time for the selected Report Instance, this information is blank. |
Maintenance
Click the Maintenance tab to view Load Process results. The load will include any generated errors and will display those in the bottom half of the screen. Data manipulation is allowed.
Maintenance Table
The Maintenance table allows you to [view], [edit], [sort], and [export] the data from the load.
Changelog
The Changelog will show changes found between months.
Error Log
The Error Log contains information from the Load process. If there are any errors, warnings, or package notifications, they will show up here.
Demographic
Contains all Demographic Information generated from the Load process.
Record Type | Description |
ED20* | Demographic Record |
ED25* | Adjustment to prior Demographic Record |
ED90* | Termination of prior Demographic Record |
RE20 – Not included in report | Retiree Demographic Record |
RE25 – Not included in report | Adjustment to prior Retiree Demographic Record |
NONE – Not included in report | Demographic Placeholder from last month |
TERM – Not included in report | Terminated Demographic Placeholder |
ADDR – Not included in report | Redundant ED25 that only changes address |
Position
Contains all Position Information generated from the Load process.
Record Type | Description |
ED40* | Position Record |
ED45* | Adjustment or Closure of prior Position Record |
NONE – Not included in report | Position Placeholder from last month |
FY40 – Not included in report | Position Placeholder from last fiscal year |
HOLD – Not included in report | Manual change to exclude from submission |
RE40 – Not included in report | Position Placeholder for ER (Retire) records |
Payroll
Contains all Payroll Information generated from the Load process.
Record Type | Description |
RP20* | Payroll Record |
RP25* | Adjustment to prior Payroll Record |
Retire
Contains all Retiree Information generated from the Load process.
Record Type | Description |
ER20* | Retiree Record |
ER25* | Manually created adjustment to prior submission |
ER27* | Manually created adjustment to prior submission |
Columns marked with * will be reported.
Submission
The Submission screen will generate the file. The file name is auto-generated and will create a separate file for report.
Note:
Each checkbox shows which report will be generated. An empty check box means that file will not be processed, and the corresponding file will be empty.
To create a report file for submission, data is entered into the fields as described below.
Field / Button | Description |
Report Instance* | Click for the list of report instances. Choose the report instance which is to be submitted. |
Notes | Any notes applicable to the submission job. |
ED File Name* RP File Name* ER File Name* | System generated or user defined filename for the submission file. The filename should always end with the ‘.txt’ extension. The filename cannot contain these characters ‘\:/*?”<>|’ Note: The path where the file is saved is already configured in the application and should not be entered here. In some reports the report name is auto-generated and hence the text filename cannot be changed for such reports. Example: ED0316201510.txt |
Entity* | Click for the list of entities. The specific entity for submission is required. If the maintenance records for all the entities are to be submitted, then ‘ALL’ should be selected. |
Report Instance Details | Details for the selected ‘Report Instance’. |
Last Submission for the Selected Report Instance | The date (Last Submission) and user (Created By) who performed the last submission and the note that was entered for submitting the selected ‘Report Instance’. The first time the Submission Process is run for the selected ‘Report Instance’, this information is blank. |
Regenerate | Regenerate the filename. |
Generate Report | Create report file with data from maintenance table. |
View Report | View the submission file report. |
Download the file from the blue hyperlinks under the Last Submission for the Selected Report Instance section.
The Last Submission for the Selected Report Instance section displays the Created By (user ID), Last Submission (date and time stamp), Notes (if any were added in the Load Process screen), Filename (link to the physical location of the submission file), and View Report (which will run an SSRS version of the submission file).
The Submission Details section provides the Status and Date Submitted information. It may be updated using the Update button.
ED File Name
Record Type | Description |
ED25 | Adjustment Demographic record |
ED90 | Termination record |
ED20 | Demographic record |
ED45 | Adjustment Position record |
ED40 | Position record |
SUMR | Additional Summer ED40s generated |
RP File Name
Record Type | Description |
RP__ (RP20 & RP25) | Payroll file |
ER File Name
Record Type | Description |
ER__ (ER20, ER25, & ER27) | Retiree file |
About
The About screen has generic package information.
Field | Description |
Version | Regulatory Reporting Module version |
Current Report Name | Report Name |
Source Server Name | The server we retrieve data from |
Source Database Name | The database we retrieve data from |
Target Server Name | The server we save data to |
Target Database Name | The database we save data to |
Report Server URL | The URL for the Report Services used in Submission |
Package Path | The file system path where we store files |
Submission File Path | The file system path where we store submission files |
Report Root Path | The file system path for the Report Services |