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 45 changed 24 lines
|__Pay Component__|__ Name__|__Source__|__Description__|
|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|Pensionalble 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 Earnings|
|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|
|__Pay Component__|__ Name__|__Source__|__Description__
|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|Pensionalble 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 Earnings
|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 92 changed one line
|__Data Element__|__Data Type__|__Length__|__Position__|__Validation__|__Description__|
|__Data Element__|__Data Type__|__Length__|__Position__|__Validation__|__Description__
At line 94 changed 5 lines
|Employer ID for the PERA system|Number|6|3-8| |ID of organization providing the data, assigned by PERA|
|Paid Date|CCMMYYDD|8|9-16|Required|Pay Issue Date CCYYMMDD|
|Increase/Decrease|Character|1|17-17|Required|Use either an __+__ to indicate an increase or an __-__ to indicate a decrease|
|Contribution Total|Number|14|18-31| |Two decimal position. Net total of all Employer and Member amounts reported|
|Number of Plan Summary|Number|6|32-27| |Computed|
|Employer ID for the PERA system|Number|6|3-8| |ID of organization providing the data, assigned by PERA
|Paid Date|CCMMYYDD|8|9-16|Required|Pay Issue Date CCYYMMDD
|Increase/Decrease|Character|1|17-17|Required|Use either an __+__ to indicate an increase or an __-__ to indicate a decrease
|Contribution Total|Number|14|18-31| |Two decimal position. Net total of all Employer and Member amounts reported
|Number of Plan Summary|Number|6|32-27| |Computed
At line 103 changed one line
|__Data Element__|__Data Type__|__Length__|__Position__|__Validation__|__Description__|
|__Data Element__|__Data Type__|__Length__|__Position__|__Validation__|__Description__
At line 105 changed 11 lines
|Employer ID for the PERA system|Number|6|3-8|Required|Employer Identification Number, assigned by PERA|
|PERA Plan ID|Number|2|9-10| |01-Basic 02-Coordinated 03-Police and Fire 11-Correctional 12-Police Consolidated 13-Fire Consolidated 14-DCP Ambulance 15-DCP Physician 16-DCP Elected Official 99-Exempt|
|Increase/Decrease|Character|1|11-11| |Use either an __+__ to indicate an increase or an __-__ to indicate a decrease|
|Plan Total|Number|12|12-23| |Two decimal places. Net total of employee and employer contributions for the plan|
|Increase/Decrease|Character|1|24-24| |Use either an __+__ to indicate an increase or an __-__ to indicate a decrease|
|Member Total|Number|12|25-36| |Two decimal places. Net total member contribution amount|
|Increase/Decrease|Character|1|37-37| |Use either an __+__ to indicate an increase or an __-__ to indicate a decrease|
|Employer Total|Number|12|38-49| |Two decimal places. Net total employer contribution amount|
|Increase/Decrease|Character|1|50-50| |Use either an __+__ to indicate an increase or an __-__ to indicate a decrease|
|Additional Total| Number|12|51-62| |Two decimal places. Net total employer additional contribution amount|
|Number of Detail Records|Number|6|63-68| |Number of detail records associated with the Summary record|
|Employer ID for the PERA system|Number|6|3-8|Required|Employer Identification Number, assigned by PERA
|PERA Plan ID|Number|2|9-10| |01-Basic 02-Coordinated 03-Police and Fire 11-Correctional 12-Police Consolidated 13-Fire Consolidated 14-DCP Ambulance 15-DCP Physician 16-DCP Elected Official 99-Exempt
|Increase/Decrease|Character|1|11-11| |Use either an __+__ to indicate an increase or an __-__ to indicate a decrease
|Plan Total|Number|12|12-23| |Two decimal places. Net total of employee and employer contributions for the plan
|Increase/Decrease|Character|1|24-24| |Use either an __+__ to indicate an increase or an __-__ to indicate a decrease
|Member Total|Number|12|25-36| |Two decimal places. Net total member contribution amount
|Increase/Decrease|Character|1|37-37| |Use either an __+__ to indicate an increase or an __-__ to indicate a decrease
|Employer Total|Number|12|38-49| |Two decimal places. Net total employer contribution amount
|Increase/Decrease|Character|1|50-50| |Use either an __+__ to indicate an increase or an __-__ to indicate a decrease
|Additional Total| Number|12|51-62| |Two decimal places. Net total employer additional contribution amount
|Number of Detail Records|Number|6|63-68| |Number of detail records associated with the Summary record
At line 119 changed 22 lines
|__Data Element__|__Data Type__|__Length__|__Position__|__Validation__|__Description__|
|Record Type|Charcter|2|1-2|38|Record Type|
|Employer Number|Number|6|3-8|Required|PERA assigned|
|Plan ID|Character|2|9-10|Required|PERA assigned|
|Employee SSN|Character|9|11-19|Required| |
|Last Name|Character|30|20-49| | |
|First NameCharacter|30|50-79| | |
|Middle Initial|Character|1|80-80| | |
|Title|Character|4|81-84| | |
|Coverage Start Date|CCYYMMDD|8|85-92| |Must not be greater than the Coverage End Date|
|Coverage End Date|CCYYMMDD|8|93-100| | |
|Pay Type|Character|2|101-102| |01-Regular Pay 02-Adjustment or Lump Sum 04-Grievance Pay 05-Retroactive 06-Omitted Deduction|
|Adjustment|Character|1|103-103| |A for Adjustment O for all other, not adjustment|
|Increase/Decrease|Character|1|104-104| |Use __-__ if Member amount is negative|
|Member Amount|Number|9(8)V99|105-114| | |
|Increase/Decrease|Character|1|104-104| |Use __-__ if Eligible earning is negative|
|PERA Eligible Earning|Number|9(8)V99|116-125| | |
|Increase/Decrease|Character|1|104-104| |Use __-__ if amount is negative|
|Employer Amount|Number|9(8)V99|127-136| |DCP Only|
|Fiscal Year|CCYY|4|137-140| | |
|Reference|Character|20|141-160|Optional| |
|Hours Worked|Number|4|161-164|Optional| |
|__Data Element__|__Data Type__|__Length__|__Position__|__Validation__|__Description__
|Record Type|Charcter|2|1-2|38|Record Type
|Employer Number|Number|6|3-8|Required|PERA assigned
|Plan ID|Character|2|9-10|Required|PERA assigned
|Employee SSN|Character|9|11-19|Required|
|Last Name|Character|30|20-49| |
|First NameCharacter|30|50-79| |
|Middle Initial|Character|1|80-80| |
|Title|Character|4|81-84| |
|Coverage Start Date|CCYYMMDD|8|85-92| |Must not be greater than the Coverage End Date
|Coverage End Date|CCYYMMDD|8|93-100| |
|Pay Type|Character|2|101-102| |01-Regular Pay 02-Adjustment or Lump Sum 04-Grievance Pay 05-Retroactive 06-Omitted Deduction
|Adjustment|Character|1|103-103| |A for Adjustment O for all other, not adjustment
|Increase/Decrease|Character|1|104-104| |Use __-__ if Member amount is negative
|Member Amount|Number|9(8)V99|105-114| |
|Increase/Decrease|Character|1|104-104| |Use __-__ if Eligible earning is negative
|PERA Eligible Earning|Number|9(8)V99|116-125| |
|Increase/Decrease|Character|1|104-104| |Use __-__ if amount is negative
|Employer Amount|Number|9(8)V99|127-136| |DCP Only
|Fiscal Year|CCYY|4|137-140| |
|Reference|Character|20|141-160|Optional|
|Hours Worked|Number|4|161-164|Optional|
At line 144 changed 27 lines
|__Data Element__|__Data Type__|__Length__|__Position__|__Validation__|__Description__|
|Record Type|Character|2|1-2|42|Record Type|
|Employer Number|Number|6|3-8|Required|Assigned by PERA|
|Plan ID|Number|2|9-10| |PERA Plan Code|
|Employee SSN|Number|9|11-19| | |
|Employee Last Name|Character|30|20-49|Required|Used to identify member|
|Employee First Name|Character|30|50-79| | |
|Employee Middle Initial|Character|1|80-80| | |
|Title|Character|4|81-84| | |
|Hire Date|CCYYMMDD|8|85-92| |Date when employee was first hired. Must be on or before the Eligibility Date.|
|Eligibility Date|CCYYMMDD|8|93-100| | |
|Exclusion Code|Character|3|101-103| |UDF|
|Employment Status|Character|2|104-105| |User Defined Lexicon|
|Employment Status Effective Date|CCYYMMDD|8|106-113| |Termination/Death reports last date worked, otherwise effective date.|
|Position Code|Character|4|114-117| |Job Code User Lexicon|
|Position Class|Character|2|118-119| |Group Code User Lexicon|
|Job Title|Character|20|120-149|Optional| |
|Birth Last Name|Character|30|150-179|Optional| |
|Gender|Character|1|180-180| | |
|Birth Date|CCYYMMDD|8|181-188| | |
|Address Attention|Character|30|189-218| | |
|Address Line 1|Character|40|219-258| | |
|Address Line 2|Character|40|259-298| | |
|City|Character|20|299-318| | |
|State|Character|2|319-320| | |
|Zip Code|Number|5|320-325| | |
|Zip + four|Character|4|325-329| | |
|__Data Element__|__Data Type__|__Length__|__Position__|__Validation__|__Description__
|Record Type|Character|2|1-2|42|Record Type
|Employer Number|Number|6|3-8|Required|Assigned by PERA
|Plan ID|Number|2|9-10| |PERA Plan Code
|Employee SSN|Number|9|11-19| |
|Employee Last Name|Character|30|20-49|Required|Used to identify member
|Employee First Name|Character|30|50-79| |
|Employee Middle Initial|Character|1|80-80| |
|Title|Character|4|81-84| |
|Hire Date|CCYYMMDD|8|85-92| |Date when employee was first hired. Must be on or before the Eligibility Date.
|Eligibility Date|CCYYMMDD|8|93-100| |
|Exclusion Code|Character|3|101-103| |UDF
|Employment Status|Character|2|104-105| |User Defined Lexicon
|Employment Status Effective Date|CCYYMMDD|8|106-113| |Termination/Death reports last date worked, otherwise effective date.
|Position Code|Character|4|114-117| |Job Code User Lexicon
|Position Class|Character|2|118-119| |Group Code User Lexicon
|Job Title|Character|20|120-149|Optional|
|Birth Last Name|Character|30|150-179|Optional|
|Gender|Character|1|180-180| |
|Birth Date|CCYYMMDD|8|181-188| |
|Address Attention|Character|30|189-218| |
|Address Line 1|Character|40|219-258| |
|Address Line 2|Character|40|259-298| |
|City|Character|20|299-318| |
|State|Character|2|319-320| |
|Zip Code|Number|5|320-325| |
|Zip + four|Character|4|325-329| |
At line 173 removed 6 lines
This page (revision-66) was last changed on 05-Apr-2023 10:57 by Karen ParrottTop