This page (revision-66) was last changed on 05-Apr-2023 10:57 by Karen Parrott

This page was created on 26-Nov-2021 10:22 by UnknownAuthor

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
66 05-Apr-2023 10:57 21 KB Karen Parrott to previous
65 26-Nov-2021 10:22 19 KB Meg McFarland to previous | to last
64 26-Nov-2021 10:22 19 KB ihowie to previous | to last
63 26-Nov-2021 10:22 19 KB khiggs to previous | to last
62 26-Nov-2021 10:22 18 KB mmcfarland to previous | to last
61 26-Nov-2021 10:22 18 KB mmcfarland to previous | to last

Page References

Incoming links Outgoing links

Version management

Difference between version and

At line 1 added 2 lines
!!!MINNESOTA PERA REPORT
At line 3 removed one line
!!!MINNESOTA PERA REPORT
At line 7 changed 2 lines
!!1. Setup new User Fields - IMUF
One new user field is needed to set up in the BEND table(P2K_ENROLLMENT_DETAILS) to translate and populate the PERA demographic record type (Type 42) for new employees where applicable.
!!1. User Fields - IMUF
One new user field is needed to set up in the BEND table (P2K_ENROLLMENT_DETAILS) to translate and populate the PERA demographic record type (Type 42) for new employees where applicable.\\
At line 10 changed one line
The PERA_EXLCUDE_CODE user field should be set up to populate the exclusion code field (Positions 101-103)
The PERA_EXCLUDE_CODE user field should be set up to populate the exclusion code field (Positions 101-103)
At line 12 changed one line
!!2. Setup new User Defined Lexicons - IMLN
!!2. User Defined Lexicons - IMLN
At line 20 changed 2 lines
__PERA Employment Status__
Lexicon Name: PERA_EMPLOY_STATUS \\
\\__PERA Employment Status__\\
Lexicon Name: PERA EMPLOY STATUS \\
At line 24 changed one line
Any Change Codes that are not entered in this table are assumed to be not reportable to PERA. \\
Any Change Codes that are not entered in this table are assumed to be not reportable to PERA.
\\
At line 26 changed 2 lines
__PERA Position Class__
Lexicon Name: PERA_POSITION_CLASS \\
\\__PERA Position Class__\\
Lexicon Name: PERA POSITION CLASS \\
At line 32 changed 2 lines
__PERA Position Code__
Lexicon Name: PERA_POSITION_CODE \\
\\__PERA Position Code__\\
Lexicon Name: PERA POSITION CODE \\
At line 36 changed one line
!! 3. Setup new Plan Type - IBPT
!! 3. New Plan Type - IBPT
At line 40 changed one line
!! 4. Setup new Plan - IBPN
!! 4. New Plan - IBPN
At line 44 changed one line
!!5. Setup PERA Benefit Components - IBPN
!!5. PERA Benefit Components - IBPN
At line 48 changed 23 lines
|B2010|Regular Pensionable Earnings (Pay Type 01)|Pay Element/Pay PC|Total employee earnings for the reporting period that are deemed pensionable. It must be stored in a Pay PC that the report program can access.
|B2012|Regular Employer Contribution Amount|Pay Element or system calculated|Regular ER Contribution. The system will calculate this amount using the ER rate.
|B2014|Regular Employee Deduction Amount|Pay Element or system calculated| Regular Deduction Amount for the Pay Period based on the regular pay period salary. The system will calculate this amount using the EE rate.
|B2016|Additional ER Contribution on Regular Earnings|Pay Element|Additional ER Contribution Amount
|B2020|Earning Adjustment (Pay Type 02, A)|Pay Element|Pensionable Salary Adjustment
|B2022|ER Deduction Adjustment|Pay Element or system generated|ER Contribution Amount that is based on the Salary Adjustment
|B2024|EE Contribution Adjustment|Pay Element or system generated|Deduction Amount based on the Earning Adjustment
|B2026|Additional ER Contribution on Adjustment Pays|Pay Element|Additional ER Contribution Amount
|B2040|Grievance Earning (Pay Type 04)|Pay Element/Pay PC|Total grievance earnings for the reporting period that are deemed reportable
|B2042| Grievance Employer Contribution Amount|Pay Element or system calculated|Grievance ER contribution amount. The system will calculate this amount using the ER rate.
|B2044|Greivance Employee Deduction|Pay Element or system calculated|EE Deduction Amount for the Pay Period based on the Grievance Pay. The system will calculate this amount using the EE rate.
|B2046|Additional ER amount on grievance pays|Pay Element or system generated|Additional ER amount on Grievance Pay
|B2050|Retroactive Earning (Pay Type 05)|Pay Element|Pensionable Retroactive Salary
|B2052|Retroactive ER Contribution|Pay Element or system generated|ER Contribution amount that is based on the Retroactive Salary
|B2054| Retroactive EE Deduction|Pay Element or system generated|EE Deduction amount based on the Retroactive Earning
|B2060|Omitted Earnings (Pay Type 06)|Pay Element|Omitted Pays
|B2062|Omitted ER Contribution|Pay Element or system generated|ER Contribution Amount that is based on the Omitted pays
|B2064|Omitted EE Deduction (Pay TYpe 06)|Pay Element|Omitted EE Deduction Amount
|B2066|Additional ER Amount on Omitted Pay|Pay Element or system generated|Additional ER amount on Omitted pay
|B2070|Lump Sum Comp Pay Out|Pay Element|Total Lump Sum Payout
|B2072|ER Contribution on Lump Sum Payout|Pay Element or system generated|ER Contribution on Lump Sum Payout
|B2074| EE Deduction on Lump Sum Payout|Pay Element or system generated|EE Deduction on Lump Sum Payout
|B2076|Additional ER Amount on Lump Sum Payout|Pay Element or system generated|Additional ER amount on Lump Sum Payout
|B2010|Regular Pensionable Earnings (Pay Type 01)|Pay Element/Pay Component|Total employee earnings for the reporting period that are deemed pensionable. It must be stored in a Pay PC that the report program can access.
|B2011|Regular OT Earning|Pay Element/Pay Component|Total employee Overtime earnings for the reporting period that are deemed pensionable
|B2012|Regular Employer Contribution Amount|Pay Component|Regular ER Contribution. The system will calculate this amount using the ER rate.
|B2014|Regular Employee Deduction Amount|Pay Component| Regular Deduction Amount for the Pay Period based on the regular pay period salary. The system will calculate this amount using the EE rate.
|B2016|Additional ER Contribution on Regular Earnings|Pay Component|Additional ER Contribution Amount
|B2020|Earning Adjustment (Pay Type 02, A)|Pay Component|Pensionable Salary Adjustment
|B2021|OT Earning Adjustment|Pay Element/Pay Component
|B2022|ER Deduction Adjustment|Pay Component|ER Contribution Amount that is based on the Salary Adjustment
|B2024|EE Contribution Adjustment|Pay Component|Deduction Amount based on the Earning Adjustment
|B2026|Additional ER Contribution on Adjustment Pays|Pay Component|Additional ER Contribution Amount
|B2040|Grievance Earning (Pay Type 04)|Pay Component|Total grievance earnings for the reporting period that are deemed reportable
|B2041|Grievance OT Earning|Pay Element/Pay Component|Total grievance Overtime earnings for the reporting period that are deemed reportable
|B2042| Grievance Employer Contribution Amount|Pay Component|Grievance ER contribution amount. The system will calculate this amount using the ER rate.
|B2044|Greivance Employee Deduction|Pay Component|EE Deduction Amount for the Pay Period based on the Grievance Pay. The system will calculate this amount using the EE rate.
|B2046|Additional ER amount on grievance pays|PPay Component|Additional ER amount on Grievance Pay
|B2050|Retroactive Earning (Pay Type 05)|Pay Component|Pensionable Retroactive Salary
|B2051|Retroactive OT Earning|Pay Element/Pay Component|Pensionable Retroactive Overtime
|B2052|Retroactive ER Contribution|PPay Component|ER Contribution amount that is based on the Retroactive Salary
|B2054| Retroactive EE Deduction|Pay Component|EE Deduction amount based on the Retroactive Earning
|B2060|Omitted Earnings (Pay Type 06)|Pay Component|Omitted Pays
|B2061|Omitted Earnings (Pay Type 06)|Pay Component|Omitted Pays
|B2062|Omitted ER Contribution|Pay Component|ER Contribution Amount that is based on the Omitted pays
|B2064|Omitted EE Deduction (Pay TYpe 06)|Pay Component|Omitted EE Deduction Amount
|B2066|Additional ER Amount on Omitted Pay|Pay Component|Additional ER amount on Omitted pay
|B2070|Lump Sum Comp Pay Out|Pay Component|Total Lump Sum Payout
|B2071|Lump Sum OT Earning|Pay Element/Pay Component|Total Lump Sum Overtime Payout
|B2072|ER Contribution on Lump Sum Payout|Pay Component|ER Contribution on Lump Sum Payout
|B2074| EE Deduction on Lump Sum Payout|Pay Component|EE Deduction on Lump Sum Payout
|B2076|Additional ER Amount on Lump Sum Payout|Pay Component|Additional ER amount on Lump Sum Payout
At line 75 changed one line
!!6. Setup PERA Contribution Rates - IBPN
!!6. PERA Contribution Rates - IBPN
At line 94 added one line
* Changes have been made to report terminated employees, 'T' status on 'Record Type 42' tab in the report. Code change for Pera status for Terminated and New EE, and changes for effective and expiry Dates
At line 104 added one line
\\
At line 98 changed one line
|Paid Date|Numeric|8|9-16|Required CCYYMMDD|Pay Issue Date
|Paid Date|Numeric|8|9-16|Required YYYYMMDD|Pay Issue Date
At line 145 changed 2 lines
|Increase/Decrease Compensated Hours|Alpha Numeric|1|161-161| |Indicates whether the Compensated hours reported in positions 162-167 is a positive or a negative. + = Increase/Positive, - = Decrease/Negative
|Compensated Hours|Numeric|6|162-167|Optional|For non-DCP members, the number of hours an employee received compensation during the period being reported.
|Increase/Decrease Compensated Hours|Alpha Numeric|1|161-161| |Indicates whether the Compensated hours reported in positions 162-167 is a positive or a negative. + = Increase/Positive, - = Decrease/Negative. \\If the Pay Type is defined as 05 (Retro), the Compensated Hours - positions 161 - 167 is set to '+000000'
|Compensated Hours|Numeric|6|162-167|Optional|For non-DCP members, the number of hours an employee received compensation during the period being reported. \\If the Pay Type is defined as 05 (Retro), the Compensated Hours - positions 161 - 167 is set to '+000000'
At line 179 changed one line
|Plan ID|Numeric|2|9-10|Required|PERA Plan Code|01-Basic, 02-Coordinated, 03-Police and Fire, 11-Correctional, 14-DCP Ambulance, 15-DCP Physician, 16-DCP Elected Official, 17-DCP City Manager, 99-Exempt
|Plan ID|Numeric|2|9-10|Required|PERA Plan Code. 01-Basic, 02-Coordinated, 03-Police and Fire, 11-Correctional, 14-DCP Ambulance, 15-DCP Physician, 16-DCP Elected Official, 17-DCP City Manager, 99-Exempt
At line 185 changed 2 lines
|Most Recent Hire Date|Numeric|8|85-92|Required. CCYYMMDD |For new employees, the original hire date. For existing employees, must be the most recent hire date.
|Eligibility Date|Numeric|8|93-100|Required. CCYYMMDD|The date an employee becomes eligible for PERA coverage
|Most Recent Hire Date|Numeric|8|85-92|Required. YYYYMMDD |For new employees, the original hire date. For existing employees, must be the most recent hire date.
|Eligibility Date|Numeric|8|93-100|Required. YYYYMMDD|The date an employee becomes eligible for PERA coverage
At line 189 changed one line
|Member Employment Status Effective Date|Numeric|8|106-113|Required. CCYYMMDD|For Termination/Death, report last date worked. Otherwise effective date.
|Member Employment Status Effective Date|Numeric|8|106-113|Required. YYYYMMDD|For Termination/Death, report last date worked. Otherwise effective date.
At line 195 changed one line
|Date of Birth|Numeric|8|181-188|Required. CCYYMMDD|
|Date of Birth|Numeric|8|181-188|Required. YYYYMMDD|
At line 217 changed one line
|Pay Issue Date|Mandatory, Date, LOV available\\This field displays the pay issue date.
|Pay Issue Date|Mandatory, Date, LOV available\\This field displays the pay issue date. If the Pay Issue Date is overridden, then we get the Pay Period where the given Pay Issue Date is between start date and end date.
At line 239 added 7 lines
!!!MINNESOTA PERA REPORT - EXCLUSION REPORT
!!SET UP REQUIREMENTS
!1. User Fields - IMUF
1) ‘PERA_EXCL_REQ’ UDF has to be set to ‘YES’ in IEEI screen if the employee is to be included in the annual exclusion report.\\2) 'PERA_EXCL_CODE' UDF is used to input the employee Exclusion Code, populates data from LOV ‘X_PERA_EX_CODES’.
One new user field is needed to be set up in the BEND table (P2K_ENROLLMENT_DETAILS) to translate and populate the PERA demographic record type (Type 42) for new employees where applicable.\\
\\
Screen Capture - IMUF:
At line 247 added 26 lines
[{Image src='RBMNPERA-EXCLUS-IMUF.png' width='700'}]
\\
*The UDF’s has to be mapped to their specific lexicon
*'PERA_EXCL_CODE' to lexicon X_PERA_EX_CODES
*‘PERA_EXCL_REQ’ to lexicon X_YES_NO
\\
!2. User Fields - IEEI
Input the values on IEEI in the UDF fields
[{Image src='RBMNPERA-EXCLUS-IEEI.png' width='700'}]
!3. Lexicon - IMLN
Added PERA exclusion code values to ‘X_PERA_EX_CODES’ \\
[{Image src='RBMNPERA-EXCLUS-IMLN.jpg' width='500'}]
!4. Processing - Exclusion Report
*Exclusion Report Param should be set to 'YES' to report exclusion data
*Depending on the pay start, end, and issue date the details will be pulled
*Pay Category, Pay Calendar and Calculate Last Pay for parameter should be selected to report employee's last pay and pay cycle
\\
Exclusion File Name parameter has to be entered to generate the .txt file\\e.g. SK_PERA_mex.txt, the file will be generated with the execution id as SK_PERA_512085.txt
\\
----
At line 230 removed one line