GA PSERS Report

Site Profile  

To configure the details about the site. 

Setup  

To configure the pay base accumulator values. 

These accumulator values are used for calculating the retirement fields for employees and are required to generate the submission file. 

Report Instance  

To create an instance of a report, after the pre-requisite data has been configured as described in steps 1 and 2.  

You will create  

• A report instance for a month and year. 

• A submission file for each instance of the report 

Load Process  

 To load the psers information into maintenance tables. 

Maintenance  

To add/update the data that is loaded in the maintenance tables. 

Submission Process  

To generate a submission file or view report based on the information stored in the maintenance tables. 

Entity ID * 

Enter the unique ID of the entity. 

You can use alpha numeric characters, spaces & underscore only, to compose the Entity ID. 

Note: Once the site is added, the ‘Entity ID’ cannot be edited. 

Employer Name* 

 Name of the employer. 

Employer Address* 

 First line of the employer address. 

Employer Address(2) 

 Rest of the address. 

Employer City* 

 City in which the employer is located. 

Employer State* 

 State in which the employer is located.  

Select from the ‘Employer State’ drop-down list. 

Employer Zip Code* 

Numeric zip code of the employer’s location. 

This field accepts only five numeric characters and does not accept if all the five characters are zeroes.  

Example: ‘00000’ is an invalid zip code 

Employer Code* 

Code of Employer 

A unique System number identifying the employer 

Entity ID * 

Enter Entity ID as defined in ‘Site Profile’ screen. 

Retirement Pay Base* 

Enter the accumulator value for calculating the Contribution Salary. 

The default value is 6007.  

PSE Employee Contribution(s) 

TRS Employee Contribution(s) 

Name * 

Name of the report instance as defined by the user. 

Year*  

Year for which submission is required.  

Month* 

Month for which submission is required.  

Report Instance * 

Click for the list of report instances. Select the one for which you wish to perform a load. 

Notes  

Enter a note related to the action you are about to perform on the report instance.  

Entity ID* 

Click to select the specific entity whose data you wish to extract. Select ‘ALL’ to extract records of all entities.  

Check Status* 

Check Status whether an employee is “Paid”, “Unpaid” or both 

Purge Existing Data 

Select this if you wish to delete, all existing records for the report instance from the maintenance table and load currently extracted records into the table.  

This action would also remove new records added using the maintenance screen. 

 Load (Button)

Click to load employee records into the maintenance table. 

Report Instance Details 

The period (year and month) for the selected report instance. 

Last Load for the Selected Report Instance 

The date when the selected report instance was last loaded and the note that was entered. 

If the report is being loaded for the first time, this would be empty.  

Report Instance  

 Click to select a specific instance. 

Filter by Criteria 

Employee Id 

Employee last name 

Total record Count 

  Delete (Button)

To delete a record from the maintenance table.   Only one record can be deleted at any point of time. 

 Save (Button)

To save changes to  records in the maintenance table.  

 Reset (Button)

 To undo all changes made to the records. 

 Insert (Button)

To insert a new record into the maintenance table.  Add employee details in the pop-up window. 

 View All Records (Button)

To view all records 

Employee ID* 

Id of the Employee 

Entity ID* 

Entity ID 

SSN* 

SSN of the Employee 

Posting Month* 

The Month and Year of the report (YYYYMM) 

Contribution Salary* 

Represents the Members Contribution Salary 

EECOn Amount* 

Represents the Post-Tax portion of EECON if applicable.  

Prefix 

Employee's Prefix 

Employee First Name* 

First Name of the Employee 

Employee Middle Name 

Middle Name of the Employee 

Employee Last Name* 

Last Name of the Employee 

Suffix 

Employee's Suffix 

Date Of Birth 

Employee's Birth Date 

Gender* 

Employee’s Gender (M/F) 

Address Line 1* 

Employee's Primary Address Line 

Secondary Line 2 

Employee's Secondary Address Line 

City 

Employee's Residence City 

State 

Employee's Residence State 

Zip Code 

Employee's Residence Zip Code 

Local Employee Number* 

Employee ID 

Termination Date 

Represents date member terminated employment or changed pension plan. 

Termination Reason 

One of the Codes as given below: 

00 =Contribution Group/ Pension Plan Change 

 01 = Retirement 

 02 = Death 

 03 = Other 

 04 = Transfer 

Employer Code* 

Employer code 

Eligibility Date* 

YYYYMMDD - Day employee becomes eligible to be reported 

Job Classification* 

One of the Codes as given below: 

01 = Engineering / Technology Support 

02 = Facilities / Materials / Equipment 

04 = Food Services / Farm Services 

05 = General Support Services 

12 =Public Safety /Corrections /Investigation 

16 = Transportation 

17 = Unspecified 

Payroll Frequency* 

One of the Codes as given below: 

00 = Monthly  

 01 = Semi-Monthly  

 02 = Bi-Weekly 

 03 = Weekly 

Payment Reason* 

One of the Codes as given below: 

00 = Regular Pay  

01 = Leave Without Pay 

02 = Military Leave Without Pay  

03 = Pay Decrease Demotion / Position Downgrade 

04 = Pay Increase Promotion / Step Increase / Position upgrade/Interim Position/Conditional Pay 

Percent Time 

Represents the Percent Time worked 

Error Log By Last   

 Click to select a Load or Submission 

Report Instance * 

The report instance (report name as defined by the user) which is to be submitted. 

Notes  

Any notes entered by the user for submission.  

File Name* 

Auto generated File name for the submission file. The format is Year and month from report definition, employer code from site profile with extension as PRSGA. E.g. if the Year is 2010 , month is 03 and Employer code is 458945 then file name is 201003458945.PRSGA 

Entity ID* 

Specific entity for which submission should happen. If employees of all the entities are to be submitted, select ‘ALL’. 

Report Definition Details 

Displays the period (year and month) for the selected report instance. 

Last Submission for the Selected Report Definition 

Displays details of the last submission job performed on the selected report instance. If this is the first submission job, this section is blank. 

File Name 

Displays the name of the file generated on the server after the User clicks on the Generate Report button. Also it gives an option for the user to download the file from the server to the client machine by clicking on the file name.  

 Generate Report (Button)

Create report file with data from maintenance table for submission to the state. 

 View Report (Button)

View the submission file report. 

1* 

1-20 

A 

1 

Record Type 

2* 

21-32 

A 

3 

Format Version 

3* 

33-44 

A 

8 

Employer Code 

4* 

45-53 

A 

3 

Plan 

5* 

54 - 56  

A/N 

6 

Report Month 

6* 

57 

Date 

8 

File Creation Date 

7* 

58 

A 

481 

Filler 

1* 

1-1 

A 

1 

Record Type 

2* 

2-7 

A/N 

6 

Posting Month 

3* 

8-16 

A/N 

9 

SSN 

4* 

17-24 

A/N 

8 

Employer Code 

5* 

25-28 

A 

4 

Contribution Group 

6* 

29-36 

Date 

8 

Eligibility Date 

7* 

37-38 

A/N 

2 

Job Classification 

8* 

39-40 

A/N 

2 

Payroll Frequency 

9* 

41-42 

A/N 

2 

Payment Reason 

10 

43-43 

A 

1 

Filler 

11* 

44-44 

A 

1 

Percent Time Sign 

12* 

45-50 

A/N 

6 

Percent Time 

13* 

51-51 

A 

1 

Salary Sign 

14* 

52-60 

A/N 

9 

Contribution Salary 

15 

61-70 

A 

10 

filler 

16* 

71-71 

A 

1 

EECON Sign 

17* 

72-80 

A/N 

9 

EECON Amount 

18 

81-120 

A 

40 

Filler 

19 

121-128 

Date 

8 

Termination Date 

20 

129-130 

A/N 

2 

Termination Reason 

21* 

131-138 

Date 

8 

Date of Birth 

22* 

139-139 

A 

1 

Gender 

23 

140-143 

A 

4 

Prefix 

24* 

144-173 

A 

30 

First Name 

25 

174-203 

A 

30 

Middle Name 

26* 

204-233 

A 

30 

Last Name 

27 

234-243 

A 

10 

Suffix 

28* 

244-278 

A 

35 

Primary Address 

29 

279-313 

A 

35 

Secondary Address 

30 

314-343 

A 

30 

City 

31 

344-345 

A 

2 

State 

32 

346-354 

A/N 

9 

Zip Code 

33 

355-355 

A 

1 

International Address Flag 

34* 

356-405 

A 

50 

International Address 

35* 

406-420 

A/N 

15 

Local Employee Number 

36 

421-512 

A 

91 

Filler 

1* 

1-1 

A 

1 

Record Type 

2* 

2-9 

A/N 

8 

Employer Code 

3* 

10-12 

A/N 

3 

Plan 

4* 

13-18 

A/N 

6 

Report Month 

5* 

19-24 

A/N 

6 

Record Count 

6* 

25-38 

A 

13 

Filler 

7* 

39-39 

A 

1 

Total Contribution sign 

8* 

40-52 

A/N 

13 

Total contribution   

9* 

53-53 

A 

1 

EECON Sign 

10* 

54-66 

A/N 

13 

Total EECON 

11* 

67-80 

A 

13 

Filler 

12* 

81-88 

Date 

8 

File Creation Date 

13* 

89-512 

A 

Filler