Differences

This shows you the differences between two versions of the page.

--- humanresources:payrollprocessing:trsprocessing:extract [2019/04/25 19:10] – emoreno
+++ humanresources:payrollprocessing:trsprocessing:extract [2020/09/28 16:34] (current) – removed emoreno
@@ Line 1: / Line 1: @@
-======Extract======
-<div #message></div>
-//**Human Resources > Payroll Processing > TRS Processing > Extract**//
-<WRAP round intro>This tab is used to extract the following TRS reporting data. All six extracts (ED20, ED40, ER20, RP20, Adjustment Days to RP25, and Adjustment Days to ER27) can be run simultaneously while you perform other system tasks. You can extract per frequency or for all frequencies.
-  - ++Employee Demographic (ED20)|{{page>general:ed20info&inline}}++
-  - ++Contract and Position (ED40)|{{page>general:ed40info&inline}}++
-  - ++Regular Payroll (RP20)|{{page>general:rp20info&inline}}++
-  - ++Employment after Retirement (ER20)|{{page>general:er20info&inline}}++
-  - ++Adjustment Days|{{page>general:adjdaysinfo&inline}}++
-Access the [[https://www.trs.texas.gov/Pages/re_team_about.aspx|RE Portal Resources]] page for additional reporting information and complete file record layouts.
-</WRAP>
-====Extract data:====
-^ Field                                        ^ Description   ^  /*Table with two rows*/
-^TRS Month|This field defaults to the current TRS reporting month.\\ \\  Click {{:images:acct_period_image.png|Account Period Selection Scroll Arrows}} to select the TRS reporting month. This is a required field.|
-^TRS Year|This field defaults to the current reporting TRS year.\\  \\  Click {{:images:acct_period_image.png|Account Period Selection Scroll Arrows}} to select the TRS reporting year. This is a required field.|
-{{:humanresources:payrollprocessing:trsprocessing:trs_processing_extract_1.jpg|TRS Processsing Extract Page}}
-Select one of the following extract options:
-  * **Delete All and Insert New Records** - Select to delete existing data and insert new records.
-  * **Insert New Records** - Select to only insert new records.
-^First Time Reporting|{{page>general:firsttimereporting}}|
-^Frequency|Select the payroll frequencies (e.g., 4 (biweekly), 5 (semimonthly), 6 (monthly)) to be extracted for the report. Multiple frequencies can be selected.\\  \\  By default, only the pay frequencies that are selected on the District Administration > Tables > District Information > Payroll Frequencies tab are enabled and selected.|
-Select the extracts to be processed. You can run multiple extracts simultaneously while you perform other system tasks.
-{{:humanresources:payrollprocessing:trsprocessing:trs_processing_extract_2.jpg|TRS Processing Extract Page With All Extracts Selected}}
-Select **Employee Demographic (ED20) Extract** to extract employee demographic data.
-Select **Contract and Position (ED40) Extract** to extract contract and position data.
-^From Contract Begin Date|Type the from contract begin date in the MM-DD-YYYY format to specify a beginning date range to be used to determine which records should be included in the extract. If this field is populated, the **To Contract Begin Date** must be populated and vice versa.|
-^To Contract Begin Date|{{page>general:tocontractbegindate_notes}}|
-Select **Regular Payroll (RP20) Extract** to extract regular payroll data.
-^Maximum Days Worked|Type the actual number of days worked in the reporting period month.|
-^Maximum Hours Worked|{{page>general:max_hours_worked}}|
-^Default Zero Days Reason|Click {{:images:dropdown.gif|Drop-down Arrow}} to select one of the following reasons:\\  \\  //A -  Accrued Pay/Not Terminated//\\  //C - Employee on less than 12 month pay schedule/Not Terminated//\\  //F - Final Pay/Terminated//\\  //L - Leave Without Pay//|
-\\
-<WRAP Box>**Child Nutrition Information**
-Child Nutrition (i.e. school breakfast and lunch) is a Special Revenue fund as LEAs are reimbursed based on the number of qualifying meals. Each LEA has the option to decide how the monthly child nutrition contributions submitted under the TRS Grant Deposit and TRS Grant Care are determined, either by actual salaries or on the TRS Child Nutrition Calculation Worksheet (two options).
-If the LEA bases the amounts on actual salaries, a **TRS Grant Code** should be entered for that fund (usually 240) on the Fund to Grant table. However, if the LEA uses one of the two methods on the TRS Child Nutrition Calculation Worksheet, then an **Expenditure Account Code** and **Salary** amount should be entered below for the RP extract. The system will proportionately distribute the entered salary amount for the employees paid out of the same fund as entered in the **Expenditure Account Code** field.
-</WRAP>
-Under **Child Nutrition**, click **+ Add** to add a row and enter data in the following fields:
-^Grant Code|Type the designated TRS grant code.|
-^Account Code|Type the designated child nutrition expenditure account code. All expense account codes must have the same fund/fiscal year.|
-^Description|Type a description for the entry.|
-^Current Month Salary|Type the current month gross salary amount. The entered salary amount is proportionately distributed for the employees paid out of the same fund as entered as the expenditure account.|
-^Previous Month Salary|Type the prior month gross salary amount. If an amount is entered, the child nutrition salary is calculated based on the specified fund and all employees who were paid in the prior TRS reporting month and year using the child nutrition fund(s) (e.g., 240). If the current TRS reporting month is 09, the prior year TRS Rates table is used.\\  \\  If an amount is not entered, no processing is completed for the prior month pay dates.\\  \\  RP25 records are automatically updated/inserted for the current reporting month but adjusting the previous reporting month for child nutrition amounts. (e.g., If you are extracting data for 04-2018, the current reporting month is 04-2018 and the adjusting reporting month is 03-2018.) If an RP25 record already exists, the TRS grant gross, grant deposit, and grant care amounts are updated.\\  \\  Journal entries are created in Finance for the prior month child nutrition TRS grant deposit and care amounts.|
-Select **Employment after Retirement (ER20) Extract** to extract employment after retirement data.
-^Maximum Days Worked|Type the actual number of days worked in the reporting period month.|
-^Maximum Hours Worked|{{page>general:max_hours_worked}}|
-^Default Zero Days Reason|Click {{:images:dropdown.gif|Drop-down Arrow}} to select the reason for reporting zero days worked.\\  \\  //A - Accrued Pay/Not Terminated//\\  //C - Employee on less than 12 month pay schedule/Not Terminated//\\  //F - Final Pay/Terminated//\\  //L - Leave Without Pay//|
-Select **Adjustment Days ** to extract adjustment days data.
-^Adjustment Days to RP25|Select to extract all adjustments from the Maintenance tab page that do not have an amount in the **TRS Posted MO/YR** field, and the TRS reporting month and year does not match the **Begin Adj Date** field. Only records with the **TRS Retiree** field set to //N// are extracted. If the adjustment days are a result of a leave dock, and the employee has multiple jobs with multiple position codes, then the adjustment days are recorded for each of the TRS position codes. Only the net difference days worked are extracted to the RP25 record.|
-^Adjustment Days to ER27|Select to extract adjustments from the Maintenance tab. Only records that have the **TRS Retiree** field set to //Y// are extracted. If the adjustment days are a result of a leave dock, and the employee has multiple jobs with multiple position codes, then the adjustment days are recorded for each TRS position code. No amounts are extracted to the ER27 record. Only net difference days worked, the contract begin and end dates, and records with the default reason code set to //E// are extracted.|
-Click **Execute** to process the selected extracts.
-{{:humanresources:payrollprocessing:trsprocessing:trs_processing_extract_execute.jpg|TRS Processing Extract Execute Button}}
-Click **Extract Status** to view the details (extract and error reports, status, user details, etc.) for each processed extract.
-{{:humanresources:payrollprocessing:trsprocessing:trs_processing_extract_status.jpg|TRS Processing Extract Status Button}}
-The TRS Extract Processing pop-up window is displayed with the extract **Status**, **Extract Type**, **Start** date and time, **End** date and time, **User ID**, and user **Email** address. The email address is retrieved from the logged-on user's staff demographic record.
-{{:humanresources:payrollprocessing:trsprocessing:trs_extract_processing_window.jpg|TRS Extract Processing Pop-Up Window}}
-Under **Error Report**, click **Print Report** to display the selected error report. [[general:printreport| Review the report.]]
-\\
-{{:humanresources:payrollprocessing:trsprocessing:trs_processsing_rp20_extract_error_report.jpg|Sample TRS Processing RP20 Extract Error Report}}
-Under **Print Report**, click **Print Report** to display the selected extract reports. [[general:printreport|Review the report.]]\\
-{{:humanresources:payrollprocessing:trsprocessing:trs_processsing_rp20_extract_report.jpg|Sample TRS Processing RP20 Extract Report}}
-Click **Continue** to continue through the list of reports for the selected extract.
-Click **Return** to return to the Extract tab.
-<WRAP Box>**Extract Error Report Notes**:
-  * If a **Warning** message is displayed, the data is extracted and you can address the issue(s) on the Maintenance tab.
-  * If a **Failure** message is displayed, the data is not extracted and you must resolve the issue(s) and extract the data again.
-</WRAP>
-Click **Close** to close the TRS Extract Processing pop-up window and return to the Extract tab.
-<WRAP #no-print>
-====Other functions and features:====
-^Errors|{{page>general:extract_errors}}|
-</WRAP>
-{{indexmenu_n>15}}

Business

Differences

Americans with Disabilities Act (ADA) and Web Accessibility

Business

User Tools

Site Tools

Differences

Page Tools

Americans with Disabilities Act (ADA) and Web Accessibility