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
RBMNPERA
RBMNPERA

Version management

Difference between version and

At line 1 removed 2 lines
!!!MINNESOTA PERA REPORT
At line 3 added one line
!!!MINNESOTA PERA REPORT
At line 8 changed 2 lines
!!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.\\
!!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.
At line 13 changed one line
!!2. User Defined Lexicons - IMLN
!!2. Setup new User Defined Lexicons - IMLN
At line 22 changed one line
Lexicon Name: PERA EMPLOY STATUS \\
Lexicon Name: PERA_EMPLOY_STATUS \\
At line 30 changed one line
Lexicon Name: PERA POSITION CLASS \\
Lexicon Name: PERA_POSITION_CLASS \\
At line 36 changed one line
Lexicon Name: PERA POSITION CODE \\
Lexicon Name: PERA_POSITION_CODE \\
At line 39 changed one line
!! 3. New Plan Type - IBPT
!! 3. Setup new Plan Type - IBPT
At line 43 changed one line
!! 4. New Plan - IBPN
!! 4. Setup new Plan - IBPN
At line 47 changed one line
!!5. PERA Benefit Components - IBPN
!!5. Setup PERA Benefit Components - IBPN
At line 51 changed 29 lines
|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
|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
At line 84 changed 2 lines
!!6. PERA Contribution Rates - IBPN
!!6. Setup PERA Contribution Rates - IBPN
At line 94 removed 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 110 changed one line
|Paid Date|Numeric|8|9-16|Required YYYYMMDD|Pay Issue Date
|Paid Date|Numeric|8|9-16|Required CCYYMMDD|Pay Issue Date
At line 157 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. \\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'
|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.
At line 197 changed 2 lines
|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
|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
At line 201 changed one line
|Member Employment Status Effective Date|Numeric|8|106-113|Required. YYYYMMDD|For Termination/Death, report last date worked. Otherwise effective date.
|Member Employment Status Effective Date|Numeric|8|106-113|Required. CCYYMMDD|For Termination/Death, report last date worked. Otherwise effective date.
At line 207 changed one line
|Date of Birth|Numeric|8|181-188|Required. YYYYMMDD|
|Date of Birth|Numeric|8|181-188|Required. CCYYMMDD|
At line 229 changed one line
|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.
|Pay Issue Date|Mandatory, Date, LOV available\\This field displays the pay issue date.
At line 239 removed 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 removed 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 233 added one line
This page (revision-66) was last changed on 05-Apr-2023 10:57 by Karen ParrottTop