LA Optional Retirement Plan (ORP) Report

Entity*

ID of the Entity/Employer.  The Entity ID should be valid entry as defined in BusinessPLUS.  Once saved, the value cannot be changed.

Employer Name*

Name of the employer for whom the Entity ID 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 accept if all the five characters are 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 Parish Code*

Numeric parish code assigned to the site.

Field

Description

Entity*

Enter Entity ID defined in ‘Site Profile’ screen.

Retirement Pay Base *

Enter the 4-digit pay base code which stores ‘Earnings Subject to Retirement’.

Entity*

Select an Entity ID. 

Example:  ROOT

CDH Number*

The CDH number configured in BusinessPLUS for ORP. 

Example:  2420

CDH Long Description*

Description of the CDH

System Code*

6 – Optional Retirement Plan    

Field

Description

Name*

User defined name of the report instance.

Year*

Year for which submission will happen.  Once the instance is created and saved, the Year value cannot be changed.

Month*

Month for which submission will happen.  Once the instance is created and saved, the Month value cannot be changed.

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 ID

Click to select a specific Entity ID 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 data for the selected ‘Report Instance’ that is already in the maintenance table, needs to be deleted so that all new data will load, this check box should be marked. This action would also remove new maintenance records added previously using the maintenance screen.

Load Button

Click to load maintenance records into maintenance table.

Report Definition Details

Details of the selected Report Instance.

Last Load for the Selected Report Definition

The date (Last Load) and user (Created By) who performed the last load and any note entered for the selected ‘Report Instance’. If the report is loaded for the first time for the selected ‘Report Instance’, this information is blank.

Report Instance

Click the down arrow to select a specific instance.

Filter by Criteria

Filter the maintenance records based on Employee ID or Employee Last Name.  Clear fields to view all the results.

Total Record Count

Indicates the total number of maintenance records in the grid.

Employer Parish Code is not configured for the following entity - ROOT. Employees belonging to this entity will not be extracted

Enter the Employer Parish Code for the entity in the Site Profile Screen.

xxxxx has actual earnings of zero

Confirm that this employee is a member of ORP and did not have earnings subject to retirement in the report month.

xxxxx has employee contributions of zero

Confirm that this employee did not contribute to ORP during the report month.

xxxxx has employer contribution of zero

Confirm that the employer did not contribute to ORP for this employee during the report month.

xxxxx has blank carrier code

In BusinessPLUS on the ORP employee deduction, enter the carrier code in special code 1.

xxxxx has an invalid carrier code

The carrier code must be 01, 02 or 03.  In BusinessPLUS on the ORP employee deduction, enter the appropriate carrier code.

xxxxx has no active deduction assignment for code xxxx

In BusinessPLUS Review and update the status and dates on the employee’s ORP deduction assignment.  Without an active deduction assignment, the load cannot determine the carrier code.  Enter the carrier code on the ORP record within Regulatory Reporting.

xxxxx has more than 1 cdh mapping to the retire codes

An employee should not have multiple retirement deductions at the same time.  Review the deduction and contribution assignments for ORP for this employee in BusinessPLUS.  Make any appropriate changes.  Verify that the employee contribution and employer contribution amounts are correct on the ORP record.

Report Instance*

Click for the list of report instances.  Choose the report instance which is to be submitted.

Notes

Any notes applicable to the submission job.

Entity*

Click for the list of entities.  The specific entity for submission is required.  If the maintenance records for all the entities are to be submitted then ‘ALL’ should be selected.

Filename*

System generated or user defined filename for the submission file.  The filename should always end with the ‘.txt’ extension. The filename cannot contain these characters ‘\:/*?”<>|’

Note:  The path where the file is saved is already configured in the application and should not be entered here.

In some reports the report name is auto-generated and hence the text filename cannot be changes for such reports.

Example: 2009_Quarter2.txt

Report Instance Details

Details for the selected ‘Report Instance’.

Last Submission for the Selected Report Definition

The date (Last Submission) and user (Created By) who performed the last submission and the note that was entered for submitting the selected ‘Report Instance’.  The first time the Submission Process is run for the selected ‘Report Instance’, this information is blank.

Double Arrow Button

Regenerate the filename.

Generate Report Button

Create report file with data from maintenance table.

View Report Button

View the submission file report.

1

System Code*

N

1

la_retire_codes

system_code

Retirement system plan.  6 - Optional Retirement Plan

2-10

Social Security Number*

N

9

hr_empmstr

ssn

Employee’s Social Security Number

11-14

Employer ID*

N

4

rr_site_profile

emplr_county

The value is determined based on the Parish Code in the Site Profile for the entity associated with the report instance.

15-22

End-of-Month Date*

N

8

rr_run_def_mstr

month, year

The last day of the month and year for which this report applies.  Comes from the report instance.

Example:  03312011 for March of 2011

23-24

Carrier Code*

N

2

pyd_cdh_dtl

pyd_spec_cd01

Carrier employee selected for the retirement plan.  Two leftmost characters in special code 1 of the employee deduction assignment for ORP.

01-AETNA

02-TIAA-CREF

03-VALIC

25-32

Salary*

N

8

pyx_xtd_dtl

pyx_mtd01 … pyx_mtd12

Employee monthly salary amount is taken from the employee accumulator pyx_xtd_dtl.pyx_mtd## (where ## is the report month) for the Retirement Pay Base, identified on the Setup Screen.

33-40

Employer Contribution*

N

8

pyx_xtd_dtl

pyx_mtd01 … pyx_mtd12

Employer contribution is taken from the employee accumulator pyx_xtd_dtl.pyx_mtd## (where ## is the report month) for any CDH Numbers listed on the Retirement Codes screen in the range of 1000-1999.

41-48

Employee Contribution*

N

8

pyx_xtd_dtl

pyx_mtd01 … pyx_mtd12

Employee contribution is taken from the employee accumulator pyx_xtd_dtl.pyx_mtd## (where ## is the report month) for any CDH Numbers listed on the Retirement Codes screen in the range of 2000-2999.

49-74

Name

A/N

26

hr_empmstr

lname

fname

mname

Captures the first 26 characters of last name, first name and middle name.

75-80

Filler

A/N

6

Blank