NE NSSRS Report - Data Load Process

The NE NSSRS report’s data load process consists of the following steps:

• Employee Selection

• Load Staff Demographics Records

• Load Position Assignment Records

• Rebuild Position/Assignment History

• Salary Benefits Calculation

Employee Selection

The employee selection functionality depends on whether:

• Position Control is enabled

• Position Control is off

Position Control enabled

The load process selects all employees from the Position History page where:

• The End Date field is blank, or the date is on or after the Termination Cut-off Date specified on the NE NSSRS Report - Load page.

• The position code exists on the NE NSSRS Report - Positions page.

• The employee has at least one pay rate record with a pay code configured as type 'P' (Pay Code) on the NE NSSRS Report - Setup page.

• The Employee Type and Status on the Employee Information page are specified on the NE NSSRS Report - Setup page.

For more information about Position Control, refer to Position Control.

Position Control off

The load process selects all employees from the Assignments page where:

• The Completion Date field is blank, or the date is on or after the Termination Cut-off Date specified on the NE NSSRS Report - Load page.

• The assignment code exists on the NE NSSRS Report - Positions page.

• The employee has at least one assignment record with a non-null assignment code.

• The Employee Type and Status on the Employee Information page are specified on the NE NSSRS Report - Setup page.

Load Staff Demographics Records

The employees are loaded into the NSSRS maintenance table using the Base Location on the Employment tab of the Employee Information page. Only one record per employee per report date will be loaded into the NSSRS maintenance table, regardless of the number of locations the employee works at.

Load Position Assignment Records

Multiple records are allowed in the NSSRS assignment file. Since each location can have multiple positions, one assignment record will be loaded for each position within a unique location. The location loaded into the NSSRS assignment file is retrieved from the neprs_loc table.

The position assignment record load functionality depends on whether:

• Position Control is enabled

• Position Control is off

Position Control enabled

• Assignment records are retrieved from the Position History page.

• The FTE value is retrieved from the FTE field on the Position History page.

• The Assignment Date is derived from the Start Date field on the Position History page or the Start Date field on the Pay Rate Information page.

• The Completion Date is derived from the End Date field on the Position History page, the Last Day Worked field on the Employee Information page, or defaults to June 30th of the fiscal year.

• Locked assignment records from the previous report within the same school year are preserved and carried forward, preventing them from being overwritten during the load process.

For more information about Position Control, refer to Position Control.

Position Control off

• Assignment records are retrieved from the Assignments page.

• The FTE value is retrieved from the Percent field on the Assignments page.

• The Assignment Date is derived from the Start Date field on the Assignments page or the Start Date field on the Pay Rate Information page.

• The Completion Date is derived from the Completion Date field on the Assignments page, the Last Day Worked field on the Employee Information page, or defaults to June 30th of the fiscal year.

• The Lock functionality is not available.

Rebuild Position/Assignment History

Each time the Load process runs, it rebuilds the history of positions or assignments that fall between the specified report start date and the current date. When Position Control is enabled, locked assignment records are preserved and not rebuilt.

Salary Benefits Calculation

The Load process calculates the amount in the Salary Benefits field on the Employment tab of the NE NSSRS Report page as follows:

1. NSSRS Annual Salary: Total the annual salary of all pay rates (active or terminated, but the contract end date is greater than or equal to the report start date), and the paycode is configured on the NE NSSRS Report - Setup page with a Pay Type of P – Pay Codes.

2. NSSRS Additional Compensation: Total the annual salary of all pay rates (active or terminated, but the contract end date is greater than or equal to the report start date), and the paycode is configured on the NE NSSRS Report - Setup page with a Pay Type of A - Additional Compensation.

3. Benefits Salary: Total the annual salary of all pay rates (active or terminated, but the contract end date is greater than or equal to the report start date), and the paycode is configured on the NE NSSRS Report - Setup page with a Pay Type of B – Benefit Codes.

4. Fringe Benefits: Get the employee's total fringe benefits for the year. Check all the active deductions that have a deduction code on the NE NSSRS Report - Setup page:

   • If a deduction has an employer contribution amount, multiply it by 12 and add it.

   • If it is a (P)ercent method or (M) method (percent plus additional amount), then get the salary plus any additional retirement money (depending on the deduction code) and multiply it by the fringe percent to get the annual contribution amount. Add this amount directly (do not multiply by 12 since the salary is already an annual amount).

   • For other fringe methods, multiply the fringe rate by 12 and add it.

5. FICA/Medicare Benefits: Get any FICA or Medicare fringe benefit. If the NSSRS Annual Salary exceeds the FICA or Medicare employer maximum, use the employer maximum times the employer percent. If not, use the NSSRS Annual Salary plus NSSRS Additional Compensation, times the employer percent, to get the FICA and Medicare amounts. Add these amounts directly (do not multiply by 12 since the salary amounts are already annual).

The sum of items 3, 4, and 5 is the Salary Benefits, representing the annualized benefit amount.