Business

User Tools

Site Tools

Trace: • rp20extract_child_nutrition

Sidebar

Table of Contents

general:rp20extract_child_nutrition
Book Creator
 Add this page to your book
Book Creator
 Remove this page from your book  

 Manage book(0 page(s))
 Help

❏ Select Regular Payroll (RP20) Extract to extract regular payroll data.

Maximum Days WorkedType the actual number of days worked in the reporting period month.
Maximum Hours Worked

Type the actual number of hours worked in the reporting period month.

The below approach allows each work day to be assigned independently of the pay dates that may contain the work day. Also, it manages the days worked if an employee has multiple jobs with different calendar codes but the same TRS position. And, the TRS adjustment days for leave docks (each TRS position code will have an entry for every dock day in the TRS adjustment days table) can easily be applied per TRS position.

Notes:

Maximum hours worked and maximum days worked should be entered allowing a warning message to be issued to identify employees with totals for the respective amounts (totals of all TRS positions codes) that may exceed the entered threshold values.

Actual days worked are accumulated from the calendar codes in the job history records for each pay date. A list of work dates is created for each TRS position code for every employee. A work date is included if the employee was paid during a pay date that is considered for the extract. Included dates are based on the following:

The employee’s job history contract begin/end dates (if either is within the current reporting month/year.)

The date is marked as a work day in the calendar code. The calendar code to be used is determined as follows: If the job still exists in the employee’s job master then the job master calendar code is used, if the job does not exist in the employee’s job master, then the job history calendar code is used. If the calendar code is blank, then the TR calendar code is used.

The dates to be considered from each calendar are based on the selected reporting period.

Default Zero Days ReasonClick 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


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 Personnel > Tables > Salaries > 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 and Previous or Current Month Salary amount should be entered on 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 field.

❏ If applicable to your LEA, under Child Nutrition, click + Add to add a row and enter data in the following fields:

Grant CodeType the designated TRS grant code.
Account CodeType the designated child nutrition expenditure account code. All expense account codes must have the same fund/fiscal year.
DescriptionType a description for the entry.
Current Month SalaryType 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 SalaryType 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 April, the current reporting month is April and the adjusting reporting month is March.) 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.
general/rp20extract_child_nutrition.txt · Last modified: 2024/06/07 14:12 by emoreno

Page Tools

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International

Americans with Disabilities Act (ADA) and Web Accessibility

The Texas Computer Cooperative (TCC) is committed to making its websites accessible to all users. It is TCC policy to ensure that new and updated content complies with Web Content Accessibility Guidelines (WCAG) 2.0 Level AA. We welcome comments and suggestions to improve the accessibility of our websites. If the format of any material on our website interferes with your ability to access the information, use this form to leave a comment about the accessibility of our website.