MO Annual Base Salary

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.

Employer Zip Code Extension

Numeric zip code extension of the employer’s location.  This field accepts only numeric characters of 4 digits or less.

Employer Federal Identification Number*

Employer’s Federal Identification Number.  This field can have only numeric characters of length 9 and does not allow all 9 characters to be zeroes.

Example: “000000000” is an invalid number.

Employer State Identification Number*

District Number*

EMERS District No for the entity.  This field accepts up to three numeric characters.

Fiscal Start Month*

Calendar month that represents the start of the fiscal year.

Fiscal Year Is End

Check this flag if the fiscal year is the year when the fiscal year ends.

Default value is true.  For example, if the fiscal year that goes from 07/01/2010 to 06/30/2011 is referred to as 2011 in BusinessPLUS, this flag should be checked. If this fiscal year is referred to as 2010 in BusinessPLUS then the flag should not be checked.

This field is used during the load to determine the fiscal year for pay assignments to include in the salary calculation.

Name *

User-defined name of the report instance

Fiscal Year*

Fiscal Year for which submission will happen

Start Date*

Start date of the school year

End Date*

End date of the school year.

Updates Only

Report Instance*

Click  for the list of report instances.  Select the desired report instance. 

Notes

Enter a note related to 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 (Button)

Click to load Maintenance records into the Maintenance table.

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 notes entered for the selected Report Instance.  If the report is loaded for the first time for the selected Report Instance, this information is blank.

Employee Id*

ID of the employee

Entity*

Entity ID

Employee SSN

SSN of the Employee

Employee First Name*

First Name of the Employee

Employee Middle Name

Middle Name of the Employee

Employee Last Name*

Last Name of the Employee

Annual Salary*

Annual Salary for the Employee’s Position

Retirement Type*

Retirement Plan Code (P,C,S,N, or W)

P - PSRS

C - PSRS Critical Shortage

S - PSRS Social Security Required

N - PEERS (Formally NTRS)

W - PEERS Critical Shortage

District Number*

PSRS/PEERS District number

Each Employer has a unique 3-digit number

Fiscal Year

Earnings reported for fiscal year YYYY

Example: use 2011 for FY10/11

Parttime Flag*

Enter Y if employee works part time, or N if employee works full time.  Entry required for PSRS members only.

Record Type

A for Annual Base

Termination Date

Employee's final date of employment

Position Code

Position code of the Employees

Position Term

Annual Term of Position

Number of months the employee is hired to serve, not the number of monthly salary payments he/she will receive.

Employer Memo

Employer Memo Field

Annual Salary Without X Duty

Warning 99999: Defaulting Position Code to 090 as cbeds value is empty

Go to the PCN/Position Code Definition Screen and select the position associated with the employee’s primary pay assignment.  Enter the EMERS position code in the CBEDS/Misc field on the PCN Position Supplemental tab.

Warning 99999: Defaulting Position Term to 12 as current Position Term --0.00000 is invalid            

Go to the PCN/Position Code Definition Screen and select the position associated with the employee’s primary pay assignment.  Enter the position term in the Misc Value 4 field on the PCN Position Supplemental tab.  Valid values are 09, 10, 11, or 12.

1*

1-20

A/N

20

Last Name

hr_pe_mstr

py_emp_l_name

Employee Last Name

2*

21-32

A/N

12

First Name

hr_pe_mstr

py_emp_f_name

Employee First Name

3

33-44

A/N

12

Middle Name

hr_pe_mstr

py_emp_m_name

Employee Middle Initial

4*

45-53

N

9

Social Security Number

hr_pe_mstr

hr_pe_ssn

Employee SSN

5*

54 - 56

N

3

District Number

rr_site_profile

district_no

District Number

It is configured in Site Profile screen and it is defined for each Entity

6*

57

A

1

Retirement System

Calculated

Retirement System:

P- PSRS

C – PSRS Critical Shortage

S – PSRS Social Security

N – PEERS (Formerly NTRS)

W – PEERS Critical Shortage

‘P’ if employee has both an employer contribution and employee deduction for PSRS and the SS/FICA flag on the mandatory assignments for the employee is not “Y”.

 ‘C’ if employee has an employer contribution and does not have an employee deduction for PSRS.

 ‘S’ if employee has both an employer contribution and employee deduction for PSRS and the SS/FICA flag on the mandatory assignments for the employee is “Y”

‘N’ if employee has both an employer contribution and employee deduction for PEERS.

 ‘W’ if employee has an employer contribution and does not have an employee deduction for PEERS.

7*

58

A

1

Part-Time Indicator

Calculated

Valid only if Retirement System is P or S

For PSRS members, if the FTE on the employee master record is less than 1then the flag is set to Y otherwise it is set to N

8*

59-69

N

11

Annual Salary

Calculated

Annual Salary

See the notes below.

9*

70-80

N

11

Retirement Salary

Blank

Retirement Salary

Blank for the Annual Base Salary Report

10*

81-91

N

11

Retirement contributions withheld

Blank

Retirement contributions withheld

Blank for the Annual Base Salary Report

11*

92-102

N

11

Board Paid Health Insurance

Blank

Board Paid Health Insurance

Blank for the Annual Base Salary Report

12

103-104

A/N

2

Annual Term of Position

hr_pcntble

miscval4

Annual Term of Position

Position Term related to current active primary pay assignments

Valid values are 09,10,11,12. Defaults to 12 if miscellaneous value 4 does not contain a valid value.

13

105-107

A/N

3

Position Code

hr_pcntble

cbeds

Position Code

Position Code related to current active primary pay assignments

Defaults to 090 if the position record does not exist or the value in the CBED/Misc field is not a valid EMERS position code.

14

108-115

N

8

Termination date

hr_empmstr

lastdaywrk

Termination date

15

116-123

N

8

Payroll Check Number

Blank

Payroll Check Number

Blank for the Annual Base Salary report

16*

124-131

N

8

Starting Date

Blank

Starting Date

Blank for the Annual Base Salary report

17*

132-139

N

8

Ending Date

Blank

Ending Date

Blank for the Annual Base Salary report

18*

140-143

N

4

Earnings Year

Earnings Year

Fiscal Year in the form of YYYY. Input during Extract

19*

144

A

1

Career Ladder

Blank

Blank for the Annual Base Salary report

20

145

A

1

Final Payroll Indicator for District

Blank

Final Payroll Indicator for District

Blank for the Annual Base Salary report

21

146

A

1

Final Payroll Indicator for Member

Blank

Final Payroll Indicator for Member

Blank for the Annual Base Salary report

22

147

A/N

1

Sick Pay Indicator

Blank

Sick Pay Indicator

Blank for the Annual Base Salary report

23

148

A/N

1

Correction, Normal or Annual Base

Correction, Normal or Annual Base

A for Annual Base Salary Report

24

149-398

A/N

250

Memo Field

hr_pe_mstr

hr_pe_id

Employee ID