Exhibit 4 - File Format Specifications.xlsx

XLSX spreadsheet 34 KB Posted

Attached to
Compensation Consultant RFP
Solicitation number
BPM057363
Issued by
Maryland

About this file

This file contains file format specifications for the Maryland State Retirement & Pension Systems' actuarial annual valuation records. The document defines the technical record layout and data field specifications for two primary file types: the Active Actuary Annual Valuation Record and the Retired Actuary Annual Valuation Record. The Active record (Job Name: PRCJ435R, File Name: PRCP.ENRCNT.VALUDISK.DOWNLOAD) contains 500-byte records with 50,000-byte block sizes and includes 123 data fields capturing participant identification, enrollment information, compensation data, contribution and interest balances, service credit across multiple tiers, and eligibility metrics. The Retired record (Job Name: PRNJ130A, File Name: PRNP.RET.ACTFILE.PRNJ130A) contains 600-byte records with 6,000-byte block sizes and includes 143 data fields capturing retiree and beneficiary information, retirement dates, benefit allowances across multiple tiers, reserve components, accumulated contributions, and service credit details.

The file specifications document the exact starting and ending positions, field lengths, and format requirements for each data element to ensure proper data collection, validation, and actuarial analysis. Both record layouts reflect pension reform changes enacted July 1, 2011, and accommodate multiple service tiers (Regular, After/Bifurcated, Enhanced, and Reformed) to align with different member categories and system structures. Data fields include personal identifiers, demographic information, employment history, contribution and interest calculations with associated sign indicators for positive or negative values, various reserve calculations (pension reserve, annuity reserve, voluntary annuity, tax-sheltered annuity, and supplemental benefits), cost-of-living adjustments by tier, service credits in multiple categories (membership, purchased, prior, military, sick leave, incentive, and projected), and system-specific flags and indicators. The specifications note no changes from the prior fiscal year 2020 to fiscal year 2021 and include technical notes regarding eliminated and retained fields to support the ongoing valuation processes for Maryland's multiple retirement and pension systems.

View the file

Other files

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

ACTIVE

ACTUARY ANNUAL VALUATION RECORD LAYOUT (ACTIVE)

JOB NAME:PRCJ435R
FILE NAME:PRCP.ENRCNT.VALUDISK.DOWNLOAD

RECORD SIZE = 500 BLOCK SIZE = 50000 RECORD FORMAT = FIXED

STARTING POSITIONENDING POSITIONLENGTHDESCRIPTIONFIELD NAMEFORMATDETAIL DESCRIPTION
199Person IDD-PID9(9)Unique identifier of participant.
10156ENR-NUM (to be added to PRIB screen)D-ENROLL-NOX(6)Not used anymore.
163217NAMED-LNAMEX(17)Participant's last name
334412NAMED-FNAMEX(12)Participant's first name
45451NAMED-INTXParticipant's middle initial.
46538BIRTH DATED-BDTECCYYMMDDMembers Date of Birth (CCYYMMDD)
54541SEXD-SEXXM = Male

F = Female 9 = Unknown (automatic enrollment record (AA or AI status code))

55551D-SYS1XValue = 0 (zero)
56561D-SYSXSee DEFINITION OF SYSTEM/PLAN CODES (worksheet tab)
57571JOBD-JCDEXC = Identifies Correctional Officers

X = Identifies records where service credit is accrued as 10 months equal to one year in a 12 month system.

For Teachers' Systems and 10-month designated Employees' Systems members, service reported in months must be converted applying a 10-month year.

58581PLAND-PLAN-SELXSee DEFINITION OF SYSTEM/PLAN CODES (worksheet tab)
59668PL SL DTD-PLAN-SEL-DTECCYYMMDDThe date of the latest plan selection whether optional or mandatory.
67748LOCD-LOCX(8)A numerical code assigned by the State Retirement Agency that identifies an employer. There is a State valuation group and a Participating governmental unit (PGU) valuation group. The state group is comprised of employer location codes:

- < 6500

- > 6500 and 3rd and 4th position of the employer location = 07,17 & 50.

- Finance Division to provide listing of PGU's

- withdrawn employers : Included in State Pool, finance provides the list, of withdrawn prior to 6/30/97 and also by law location codes 6730 and 6627 75 77 3 PT-% D-PRT-TIME 999 Shows the budgeted percentage of time for the position being reported if worked less than full-time (100%). Full time members are reported as "100" Example: "050" represents 50% of full-time, "100" full-time.

78792STATD-STATX(2)See "Status Codes - Active" (Worksheet tab)
80812RETIREMENT OPTIOND-STAT-OPTX(2)If applicable, current fiscal year retiree's option code extracted from Retiree data

See "Option Updates" (worksheet tab)

82898SD (STATUS DATE)D-SDTECCYYMMDDDate is populated with the effective date of the most recent change in status code on the record. (CCYYMMDD)
90978ED (ENROLLMENT DATE)D-EDTECCYYMMDDDate individual was enrolled in a System (CCYYMMDD)
981058TRANS DT (TRANSFER DATE)D-TRANS-DATECCYYMMDDDate of transfer from retirement system into the pension system.

Note: Legislation prohibits transfers from Employees' and Teachers' Retirement system to the Employees' and Teachers' Pension system after 12/31/2004.

1061138LAD (LAST ACTIVE DATE)D-DTELACTCCYYMMDDEquals 405LAD except for "DR" (Deferred Vested) status accounts for which date represents earliest eligible retirement date.
1141218405-LAD (405 LAST ACTIVE DATE)D-405-LADCCYYMMDDLast pay period date of payroll information posted to an account (CCYYMMDD). The collection and updating of member's payroll data is applied to the applicable fiscal year based on the pay period end date.
12215130FILLERX(30)FILLER
1521554RT-N (EMPLOYEE CONTRIBUTION RATE)D-CONTB-RTEV9999The rate of employee contribution percentage dependent on System/Plan.

(Example 7% = 0700). See DEFINITION OF SYSTEM/PLAN CODES (worksheet tab)

1561649BAL-NC (BEGINNING BALANCE NORMAL CONT)D-PR-CONT9(7)V99Prior Regular Contribution
1651651D-PC-SXSign for prior field - (positive (spaces); negative (-) indicator)
1661749BAL-NI (BEGINNING BALANCE NORMAL INTEREST)D-PR_INT9(7)V99Interest on mandatory contributions at the beginning of the fiscal year 7/1 (less any prior year adjustments). Agency methodology for awarding interest as defined by law is to credit half the statutory rate on the beginning adjusted balance and half the statutory rate on the ending balance (beginning balance + current year).

Retirement Systems (4% a year):

- Systems 1, 2, 3, 4, 5, 8, or G (all plan codes)

- System 6 with a plan code 5, 6, J, K, R, or S

- System 7 with a plan code 1, 2, 5, 6, J, K, R, or S Pension Systems (5% a year)

- System 6 with a plan code 7, 8 or L, P

- System 7 with a plan code space, 7, 8 or L, M, N, P

- System 9 (all plan codes)

- System H (all plan codes)

1751751D-PI-SXSign for prior field - (positive (spaces); negative (-) indicator)
1761849CUR-N (CURRENT FY NORMAL CONTRIBUTIONS)D-CUR-CONT9(7)V99Mandatory contributions credited during the fiscal year (7/1 - 6/30).
1851851D-CC-SXSign for prior field - (positive (spaces); negative (-) indicator)
1861949CT-NI (CURRENT FY NORMAL INTEREST)D-CUR-INT9(7)V99Interest on mandatory contributions credited during the fiscal year (7/1 - 6/30)
1951951D-CI-SXSign for prior field - (positive (spaces); negative (-) indicator)
1962049TOTAL NORMAL CONTRIBUTIONSD-TOT-CONT9(7)V99Cumulative sum of all normal contribution fields
2052051D-TC-SXSign for prior field - (positive (spaces); negative (-) indicator)
2062149TOTAL NORMAL INTERESTD-TOT-INT9(7)V99Cumulative sum of all normal interest fields
2152151D-TI-SXSign for prior field - (positive (spaces); negative (-) indicator)
2162249RF-PD (REFUND PAID)D-REFUND-AMT9(7)V99Total refund payment of employee contributions and interest paid to an individual or beneficiary. However, for a retiree this represents the mandatory contribution and interest balance transferred from the Annuity Savings Fund to the Retirement Accumulation Fund and is used to calculate the annuity reserve portion of the benefit.
2252251D-REF-DASHXSign for prior field - (positive (spaces); negative (-) indicator)
2262349DEF-C (CONTRIBUTION DEFICIENCY)D- DEF-C9(7)V99Represents a deficiency of mandatory normal contributions. Unpaid contribution deficiencies at retirement actuarially reduce the retiree's benefit allowance
2352351D-DEF-C-SXSign for prior field - (positive (spaces); negative (-) indicator)
2362449DEF-ID-DEF-I9(7)V99Represents interest accrued on a deficiency of mandatory normal contributions. Unpaid deficiencies at retirement actuarially reduce the retiree's benefit allowance
2452451D-DEF-I-SXSign for prior field - (positive (spaces); negative (-) indicator)
2462549DEATHD-DEATH9(7)V99One year actual annual salary paid to beneficiary of deceased active member
2552551D-DEATH-SXSign for prior field - (positive (spaces); negative (-) indicator)
25628530FILLERX(30)FILLER
2862927S-1 ACT-SAL (ACTUAL ANNUAL COMPENSATION @ 6/30 of CURRENT FISCAL YEAR)D-CUR-SAL9(7)Actual budgeted compensation @ 6/30 of current fiscal year. For full-time individuals the "Actual Annual Compensation" = "Annual Earnable Compensation", For example, if individual was 50% employment, Actual Annual Compensation = 20,000, Annual Earnable Compensation = 40,000.
2932997S-2 ACT-SAL (ACTUAL ANNUAL COMPENSATION @ 6/30 of PRIOR FISCAL YEAR)D-PR-SAL9(7)Actual budgeted compensation @ 6/30 of prior fiscal year. For full-time individuals the "Actual Annual Compensation" = "Annual Earnable Compensation", For example, if individual was 50% employment, Actual Annual Compensation = 20,000, Annual Earnable Compensation = 40,000.
3003067S-1 FT-EQIVSAL (ANNUAL EARNABLE COMPENSATION - FULL-TIME) @ 6/30 of CURRENT FISCAL YEAR)D-S-1 FT-EQIVSAL9(7)Members of the retirement systems earn full-time service credit and part-time salary credit, while members in the pension systems earn part-time service credit and full-time salary credit.

The agency maintains two separate annualized salaries referred to as the "Actual Annual Compensation (actual)" and the "Annual Earnable Compensation (full-time)". For full-time employees these salaries are the same. However, for part-time employees the "Actual Annual Compensation" represents their actual budgeted annual salary, while the "Annual Earnable Compensation" represents the budgeted annual salary for an equivalent full-time position.

For funding purposes the Actual Annual Compensation is applicable. For benefit calculation purposes the Annual Earnable Compensation is only applicable to Pension Systems.

3073137S-2 FT-EQIVSAL (ANNUAL EARNABLE COMPENSATION - FULL-TIME) @ 6/30 of PRIOR FISCAL YEAR)D-S-2 FT-EQIVSAL9(7)See S-1 description above.
3143229JUL – JUN (FT-EQIVSAL)D-CUR-FY-AVG-AN-SAL9(7)V99Represents the "Current Fiscal Year's Average Annual Salary" determined as the sum of the current fiscal year's monthly salaries divided by the number of months for which payroll data is reported. This data field was requested by a prior actuary.
32335230FILLERX(30)FILLER
3533553SER-MEM (MEMBERSHIP SERVICE)D-REG-MONS-SERV999Creditable membership service applied in accordance with system/plan rules. See DEFINITION OF SYSTEM/PLAN CODES (worksheet tab)
3563583SER-PUR (PURCHASED/BUYBACK SERVICE)D-BYBK-MOS999Service credit that has been purchased. See COST OF PURCHASED SERVICE (worksheet tab). See DEFINITION OF SYSTEM/PLAN CODES (worksheet tab).
3593613SER-PR (PRIOR SERVICE)D-PR-MONS-SERV999Identifies Creditable Service brought into MSRA plan when a new employer joins the systems. Service credit granted is related to a member prior to enrollment in this plan - reported as part of an enrollment of a new employer.
3623643SER-OM (OLD MILITARY SERVICE)D-OLD-MIL-MOS999Military Active Duty service which interrupts membership service credit. See DEFINITION OF SYSTEM/PLAN CODES (worksheet tab)
3653673SER-NM (NEW MILITARY SERVICE)D-NEW-MIL-MOS999Military Active Duty service prior to member’s date of enrollment.

See DEFINITION SYSTEM/PLAN CODES (worksheet tab).

3683703SER-TOT (TOTAL REGULAR TIER SERVICE)D-TOT-CRED-SER-REG999Represents the total of the SER (Regular) service fields
3713733AFT-MEM (AFTER/BIFURCATED SERVICE)D-MEM-MOS-AFT999Creditable after/bifurcated membership service applied in accordance with system/plan rules. See DEFINITION OF SYSTEM/PLAN CODES (worksheet tab)
3743763AFT-PUR (AFTER/BIFURCATED PURCHASED SERVICE)D-PUR-MOS-AFT999After/bifurcated Service credit that has been purchased. See COST OF PURCHASED SERVICE (worksheet tab). See DEFINITION OF SYSTEM/PLAN CODES (worksheet tab).
3773793AFT-OM (AFTER/BIFURCATED OLD MILITARY SERVICE)D-OLD-MIL-AFT999After/bifurcated Military Active Duty service which interrupts membership service credit. See DEFINITION OF SYSTEM/PLAN CODES (worksheet tab)
3803823AFT-NM (AFTER/BIFURCATED NEW MILITARY SERVICE)D-NEW-MIL-AFT999After/bifurcated Military Active Duty service prior to member’s date of enrollment.

See DEFINITION SYSTEM/PLAN CODES (worksheet tab).

383 385 3 AFT SER-TOT (TOTAL AFTER/BIFURCATED TIER SERVICE) D-TOT-CRED-SER-AFT 999 Represents the total of the AFT (After/Bifurcated) service fields.

Note: prior record layout included a prior service after field but there was no data ever provided. Field eliminated from current record layout.

3863883ENH-MEM (ENHANCED SERVICE)D-MEM-MO-EXT999Creditable Enhanced membership service applied in accordance with system/plan rules. See DEFINITION OF SYSTEM/PLAN CODES (worksheet tab)
3893913ENH-PUR (ENHANCED PURCHASED SERVICE)D-PUR-MO-EXT999Enhanced Service credit that has been purchased. See COST OF PURCHASED SERVICE (worksheet tab). See DEFINITION OF SYSTEM/PLAN CODES (worksheet tab).
3923943ENH-OM (ENHANCED OLD MILITARY SERVICE)D-OLD-MIL-EXT999Enhanced Military Active Duty service which interrupts membership service credit. See DEFINITION OF SYSTEM/PLAN CODES (worksheet tab)
3953973ENH-NM (ENHANCED NEW MILITARY SERVICE)D-NEW-MIL-EXT999Enhanced Military Active Duty service prior to member’s date of enrollment.

See DEFINITION SYSTEM/PLAN CODES (worksheet tab).

3984003ENH SER-TOT (TOTAL ENHANCED TIER SERVICE)D-TOT-CRED-SER-ENH999Represents the total of the ENH (Enhanced) service fields.
4014033REF-MEM (REFORMED MEMBERSHIP SERVICE)D-MEM-MOS-REF999Creditable Reformed membership service applied in accordance with system/plan rules. See DEFINITION OF SYSTEM/PLAN CODES (worksheet tab)
4044063REF-PUR (REFORMED PURCHASED/BUYBACK SERVICE)D-PUR-MOS-REF999Reformed Service credit that has been purchased. See COST OF PURCHASED SERVICE (worksheet tab). See DEFINITION OF SYSTEM/PLAN CODES (worksheet tab).
4074093REF-PR (REFORMED PRIOR SERVICE)D-PR-SER-REF999Identifies Reformed Creditable Service brought into MSRA plan when a new employer joins the systems. Service credit granted is related to a member prior to enrollment in this plan - reported as part of an enrollment of a new employer.
4104123REF-OM (REFORMED OLD MILITARY SERVICE)D-OLD-MIL-REF999Reformed Military Active Duty service which interrupts membership service credit. See DEFINITION OF SYSTEM/PLAN CODES (worksheet tab)
4134153REF-NM (REFORMED NEW MILITARY SERVICE)D-NEW-MIL-REF999Reformed Military Active Duty service prior to member’s date of enrollment.

See DEFINITION SYSTEM/PLAN CODES (worksheet tab).

4164183REF-TOT (TOTAL REFORMED TIER SERVICE)D-TOT-CRED-SER-REF999Represents the total of the REF (Reformed) service fields
4194213GRAND-TOT (TOTAL CREDITABLE SERVICE)D-GRAND-TOT-CRED-SER999Grand total of all creditable service tier fields (SER + AFT + ENH + REF_
4224243SER-ELIGIBIL (ELIGIBILITY SERVICE)D-ELIG-SVC999The Agency maintains separate "Eligibility" and "Creditable" service fields. Eligibility service credit is used to qualify a member for a benefit. Creditable service is used to calculate the benefit.

Eligibility service credit is only separately reported for Pension System accounts. For the Pension Systems eligibility service is measured in years and months. A member that works at least 500 hours (eligibility service prior to 7/01/1998 is based on at least 700 hours) in any fiscal year (July 1 to June 30) will be credited with one year of eligibility service. If a member completes less than 500 hours of employment, in the first and last fiscal year of employment, eligibility service is prorated based on the number of hours worked as compared to the 500 hours standard times the applicable work year (10/12 months).

For pension system member's subject to the contributory, or alternate contributory, or reformed contributory pension benefit who complete less than 500 hours of employment in any fiscal year (other than the first and last FY), eligibility service is prorated based on the number of hours worked as compared to the 500 hours standard times the applicable work year (10/12 months). (Pension Systems include Teachers’/Employees’ Pension Systems, Law Enforcement Officers Pension System, and Local Fire and Police System).

For non-contributory pension system ((system 7, plan code "space" and "N") and system "H" (all plan codes)) member's subject to the non-contributory benefit , if the member works less than 351 hours, then they earn no service credit (creditable & eligiblity) in that fiscal year. If the member works 351 hours through 499 hours, although they do not receive creditable or eligibility service, they do not accrue a break in service months. When the member's break in service months equal their previously accrued service that is moved to the "Lost" service fields during the fiscal year a break occurs (< 351 hours), membership ends, and all service is lost..

For Retirement Systems eligibility service credit equals the sum of all service fields. Retirement System records do not reflect eligibility service credit.

425 427 3 SERV-TRANS (TRANSFERRED SERVICE) D-TRANS-SVC 999 Memorandum only and represents the total service credit posted to the account as of the date of transfer into the pension system which is already reflected in the membership service months totals for certain members enrolled prior to 1980.

Note: Legislation prohibits transfers from Employees' and Teachers' Retirement system to the Employees' and Teachers' Pension system after 12/31/2004.

4284303SER-L ELIGIB (LOST ELIGIBILITY SERVICE)D-LOST-ELIG-SVC999Refer to SER-ELIGIBIL (ELIGIBILITY SERVICE) description for details.
4314333SERV-RSTRD (RESTORED SERVICE)D-RESTORED-SVC999Memorandum only. Any prior service credit restored is reflected in the membership service months field after working 500 hours.
43446330FILLERX(30)FILLER
4644652VEST-YR (VESTING YEARS)D-VEST-YR99Identifies the number of years needed to vest for that system/plan. As a result of the pension reform changes enacted 7/1/2011 this field was added. See DEFINITION OF SYSTEM/PLAN CODES (worksheet tab)
4664661AFC-YR-FG (AVERAGE FINAL COMPENSATION YEAR FLAG)D-AFC-YR-FG9Identifies the number of years used to calculate the Average Final Compensation for calculating the retirement allowance. As a result of the pension reform changes enacted 7/1/2011 this field was added. See DEFINITION OF SYSTEM/PLAN CODES (worksheet tab)
4674715HOS-VEST (HOSPITALIZATION FLAG)D-HOS-VEST99/99Memorandum only. Applicable to State heath benefit program valuation.
4724721Dual Employment IndicatorD-DUAL-EMPLOYX"D" identifies multiple same system/plan active status ("A") records that are dual employed
47350028FILLERX(28)FILLER
Other Notes:
General notes: No changes from prior year's valuation FY 2020 to the current FY 2021.
- Due to the need to make significant modifications to the record layout as a result of the pension reform changes enacted 7/1/2011, the SRA reorganized the record layout.
- Previously, the SRA record layout included a unused sick leave field extracted from our membership database. This field has been eliminated from this active valuation data. Sick leave is only applicable to retirees' and should only be referenced from the Retiree valuation data.
- Individuals' may have multiple records differentiated by the combination of the System and Plan Code for which separate valuation is required.

RETIRED

ACTUARY ANNUAL VALUATION RECORD LAYOUT (RETIRED)

JOB NAME:PRNJ130A
FILE NAME:PRNP.RET.ACTFILE.PRNJ130A

RECORD SIZE = 600 BLOCK SIZE = 6000 RECORD FORMAT = FIXED

STARTING POSITIONENDING POSITIONLENGTHDESCRIPTIONFIELD NAMEFORMATDETAIL DESCRIPTION
199Person IDUP-PID9(9)Unique identifier of payee.
10101MULTIPLE.RECORD INDICATORUP-REC-CODE9Indicator that counts the number of records with the same social security number.(e.g.1, 2, etc.)
11188BIRTH DATEUP-DOBCCYYMMDDRetiree's Date of Birth (CCYYMMDD)
19268RD (RETIREMENT DATE)UP-RETIRE-DATECCYYMMDDRetiree's Date of Retirement (CCYYMMDD)
27348DD (RETIREE'S DATE OF DEATH)UP-RETIRE-DODCCYYMMDDRetiree's Date of Death (CCYYMMDD)
35351SEXUP-SEXXM = Male

F = Female

36361SYSTEMUP-SYSTEMXSee DEFINITION OF SYSTEM/PLAN CODES (worksheet tab)
37371JOB CODEUP-JOBXC = Identifies Correctional Officers

X = Identifies records where service credit is accrued as 10 months equal to one year in a 12 month system.

For Teachers' Systems and 10-month designated Employees' Systems members, service reported in months must be converted applying a 10-month year.

3838110 MONTH FLAGUP-10-MO-EMPL-FLAGXA '1' in the 10 month employee flag indicates a retiree that was a 10 month employee in a 12 month system. For Teachers' systems and 10-month employees' systems retiree's service reported in months must be converted applying a 10 month year. Duplication of Job Code = X.
39391PLAN CODEUP-PLAN-SELECTIONXSee DEFINITION OF SYSTEM/PLAN CODES (worksheet tab)
40478LOCATION CODEUP-LOCATION9(8)A numerical code assigned by the State Retirement Agency that identifies an employer. There is a State valuation group and a Participating governmental unit (PGU) valuation group. The state group is comprised of employer location codes:

- < 6500

- > 6500 and 3rd and 4th position of the employer location = 07,17 & 50.

- Finance Division to provide listing of PGU's

- withdrawn employers that are included in State pool, and by statute location codes 6627 and 6730 belong in State pool

48481LEGISLATIVE PLANUP-LEGIS- PLANXSee DEFINITION OF SYSTEM/PLAN CODES (worksheet tab)
49502STATUS CODEUP-STATUS-CODEX(2)Defines the status of an account.

R - Retired - Retired member includes DRO’s for which the retirement benefit allowance is allocated between the retiree and alternate payee (DRO) records. (DRO accounts identified by an "R" status with the original retiree social security number reflected in positions 70 - 78). At death of the retiree, the DRO payments cease without any beneficiary protection.

RB - Retired Beneficiary – Beneficiary of a dual-life annuity; For the State Police, Judges, Legislators and Law Enforcement Officer's Pension Systems the law mandates that if their is a surviving spouse or minor children that the basic allowance (Option 00) provides for continuation of dual life payments. For other systems refer to the "Option Codes - retiree's" worksheet tab.

RI - Retired Suspended - Identifies DROP participants in systems 3, 8 and 9. (SRA identifies as an RI status with a "Z" or "S" in the FLAG field). "RI" status code also represents other records in a suspended state for various reasons.

51588STATUS DATEUP-STATUS-DATECCYYMMDDStatus Date = Date of the most recent status code change (CCYYMMDD).
59668405-LAD (405 LAST ACTIVE DATE)UP-405LADCCYYMMDDLast pay period date of payroll information posted to an account (CCYYMMDD). The collection and updating of member's payroll data is applied to the applicable fiscal year based on the pay period end date.

67 67 1 RETIREMENT TYPE UP-TYPE-RETIRE X Defines the retirement type for an account:

S = Service – Includes normal service, early service and vested.

U = Unclassified and certain elected/appointed officials - Special early (16 year rule) (§22-404;§23-404) W = Widow – Spouse Law Death benefit annuity, member dies while in active service, spouse named as sole beneficiary and meets spouse law eligibility requirements for plan.

D = Ordinary Disability A = Accidental or Special Disability (State Police)

68692RETIREMENT OPTIONUP-OPTION-CODE99See OPTION CODES - retirees (worksheet)
70789Person ID-R (ORIGINAL RETIREE'S Unique Identifier)UP-PID-R9(9)For beneficiary payment records, the PID-R identifies the original retiree's record which is the basis for the beneficiary record.
79879BEN-Person ID (BENEFICIARY'S Unique Identifier)UP-BEN-PID9(9)Identifies the beneficiary's unique identifier, when applicable.
88958BEN-BD (BENEFICIARY BIRTH DATEUP-BENF-DOBCCYYMMDD(CCYYMMDD)
96961BEN-SEX (BENEFICIARY SEX)UP-BENF-SEXXM = Male

F = Female

97982BEN-CD (BENEFICIARY RELATIONSHIP CODE)UP-BENF-REL-CODE99See BENEFICIARY RELATION CODES - retiree (worksheet)
991068BEN-DD (BENEFICIARY DATE OF DEATH)UP-BENEF-DODCCYYMMDD(CCYYMMDD)
1071368FILLERFILLERX(30)FILLER
1371459AFC (AVERAGE FINAL COMPENSATION)UP-FIN-SAL9(7)V99Average annual earnable final compensation of a member determined in accordance with plan rules.
1461461NEG-UP-FIN-SALXSign for prior field - (positive (spaces); negative (-) indicator)
1471537PR - REGULAR (PENSION RESERVE - REGULAR TIER)UP-PENS-RES-PMO9(5)V99Portion of monthly benefit funded by employer contributions. See DEFINITION OF SYSTEM/PLAN CODES (worksheet tab)
1541541NEG-UP-PENS-RES-PMOXSign for prior field - (positive (spaces); negative (-) indicator)
1551617PR - BIFURCATED (PENSION RESERVE - BIFURCATED TIER)UP-BIF-PEN-RESV9(5)V99Portion of monthly benefit funded by employer contributions. See DEFINITION OF SYSTEM/PLAN CODES (worksheet tab)
1621621NEG-UP-BIF-PEN-RESVXSign for prior field - (positive (spaces); negative (-) indicator)
1631697PR - ENHANCED (PENSION RESERVE - ENHANCED TIER)UP-ENH-PEN-RESV9(5)V99Portion of monthly benefit funded by employer contributions. See DEFINITION OF SYSTEM/PLAN CODES (worksheet tab)
1701701NEG-UP-ENH-PEN-RESVXSign for prior field - (positive (spaces); negative (-) indicator)
1711777PR - REFORMED (PENSION RESERVE - REFORMED TIER)UP-REF-PEN-RESV9(5)V99Portion of monthly benefit funded by employer contributions. See DEFINITION OF SYSTEM/PLAN CODES (worksheet tab)
1781781NEG-UP-REF-PEN-RESVXSign for prior field - (positive (spaces); negative (-) indicator)
1791868PR - TOTAL (PENSION RESERVE - ALL TIERS)UP-TTL-PEN-RESV9(6)V99Sum of the Pension Reserve monthly benefit tiers
1871871NEG-UP-TTL-PEN-RESVXSign for prior field - (positive (spaces); negative (-) indicator)
1881947AP - REGULAR (ADDITIONAL PENSION RESERVE - REGULAR TIER ONLY)UP-ADD-PENS-RES-PMO9(5)V99Represents the additional portion of the employer funding.
1951951NEG-UP-ADD-PENS-RES-PMOXSign for prior field - (positive (spaces); negative (-) indicator)
1962027AR - REGULAR (ANNUITY RESERVE - REGULAR TIER)UP-ANN-RES-PMO9(5)V99Portion of a benefit funded by mandatory member contributions and interest.
2032031NEG-UP-ANN-RES-PMOXSign for prior field - (positive (spaces); negative (-) indicator)
2042107AR - BIFURCATED (ANNUITY RESERVE - BIFURCATED TIER)UP-BIF-ANN-RESV9(5)V99Portion of a monthly benefit funded by mandatory member contributions and interest. See DEFINITION OF SYSTEM/PLAN CODES attachment.
2112111NEG-UP-BIF-ANN-RESVXSign for prior field - (positive (spaces); negative (-) indicator)
2122187AR - ENHANCED (ANNUITY RESERVE - ENHANCED TIER)UP-ENH-ANN-RESV9(5)V99Portion of a benefit funded by mandatory member contributions and interest.
2192191NEG-UP-ENH-ANN-RESVXSign for prior field - (positive (spaces); negative (-) indicator)
2202267AR - REFORMED (ANNUITY RESERVE - REFORMED TIER)UP-REF-ANN-RESV9(5)V99Portion of a benefit funded by mandatory member contributions and interest.
2272271NEG-UP-REF-ANN-RESVXSign for prior field - (positive (spaces); negative (-) indicator)
2282358AR - TOTAL (ANNUITY RESERVE - ALL TIERS)UP-TTL-ANN-RESV9(6)V99Sum of the Annuity Reserve monthly benefit tiers
2362361NEG-UP-TTL-ANN-RESVXSign for prior field - (positive (spaces); negative (-) indicator)
2372437VA-REGULAR (VOLUNTARY ANNUITY - REGULAR TIER)UP-REG-VOL-ANN-PMO9(5)V99Portion of a benefit that is derived from voluntary member contributions and interest as described in §20-101(c). This money does not receive a Cost of Living Adjustment (COLA).

Exception - For system 3 (State Police) the voluntary annuity field is used to report the benefit adjustment amount applicable to individuals with a retirement date prior to 7/1/99 (see §24-401(e)). At death, the surviving spouse continues to receive the special benefit adjustment without reduction. See DEFINITION OF SYSTEM/PLAN CODES (worksheet tab).

2442441NEG-UP-VOL-ANN-PMOXSign for prior field - (positive (spaces); negative (-) indicator)
2452517TA - Regular (TAX SHELTERED ANNUITY - REGULAR TIER ONLY)UP-TSA-ANN-PMO9(5)V99TSA = Tax Sheltered Annuity

Additional annuity funded by voluntary contributions under the tax-sheltered plan in the 1970’s and 80’s.

2522521NEG-UP-TSA-ANN-PMOXSign for prior field - (positive (spaces); negative (-) indicator)
2532597SL - REGULAR (SUPPLEMENTAL BENEFIT - REGULAR TIER ONLY)UP-SUPPL-PMO9(5)V99Generally, System 9 Plan 7, Non-contributory benefit described in §29-303(g)(3). Also includes amounts for System 1 & 2 accounts retired in the 1950’s and 60’s as calculated by the actuary. See DEFINITION OF SYSTEM/PLAN CODES (worksheet tab)
2602601NEG-UP-SUPPL-PMOXSign for prior field - (positive (spaces); negative (-) indicator)
2612677CL - REGULAR (COST OF LIVING ADJUSTMENT - REGULAR TIER)UP-CPI-AMT-PMO9(5)V99Cost of living adjustment amount applied to an individual's account as defined by the System/Plan. See DEFINITION OF SYSTEM/PLAN CODES (worksheet). Starting in FY2012 the cost of living adjustments are allocated to the associated fund allowance by tier.
2682681NEG-UP-CPI-AMT-PMOXSign for prior field - (positive (spaces); negative (-) indicator)
2692757CL - BIFURCATED (COST OF LIVING ADJUSTMENT - BIFURCATED TIER)UP-BIF-COST-LIVING9(5)V99Cost of living adjustment amount applied to an individual's account as defined by the System/Plan. See DEFINITION OF SYSTEM/PLAN CODES (worksheet). Starting in FY2012 the cost of living adjustments are allocated to the associated fund allowance by tier.
2762761NEG-UP-BIF-COST-LIVINGXSign for prior field - (positive (spaces); negative (-) indicator)
2772837CL -ENHANCED (COST OF LIVING ADJUSTMENT - ENHANCED TIER)UP-ENH-COST-LIVING9(5)V99Cost of living adjustment amount applied to an individual's account as defined by the System/Plan. See DEFINITION OF SYSTEM/PLAN CODES (worksheet). Starting in FY2012 the cost of living adjustments are allocated to the associated fund allowance by tier.
2842841NEG-UP-ENH-COST-LIVINGXSign for prior field - (positive (spaces); negative (-) indicator)
2852917CL-REFORMED (COST OF LIVING ADJUSTMENT - REFORMED TIER)UP-REF-COST-LIVING9(5)V99Cost of living adjustment amount applied to an individual's account as defined by the System/Plan. See DEFINITION OF SYSTEM/PLAN CODES (worksheet). Starting in FY2012 the cost of living adjustments are allocated to the associated fund allowance by tier.
2922921NEG-UP-REF-COST-LIVINGXSign for prior field - (positive (spaces); negative (-) indicator)
2933008CL-TOTAL (COST OF LIVING ADJUSTMENT - ALL TIERS)UP-TTL-COST-LIVING9(6)V99Sum of the Cost of Living Adjustment monthly benefit tiers
3013011NEG-UP-TTL-COST-LIVINGXSign for prior field - (positive (spaces); negative (-) indicator)
3023087MAX-REGULAR (BASIC ALLOWANCE - REGULAR TIER)UP-REG-MAX-MNTHLY9(5)V99The calculation of the Basic Allowance without optional allowance modification.

See DEFINITION OF SYSTEM/PLAN CODES (worksheet tab)

3093091NEG-UP-REG-MAX-MNTHLYXSign for prior field - (positive (spaces); negative (-) indicator)
3103167MAX-BIFURCATED (BASIC ALLOWANCE - BIFURCATED TIER)UP-BIF-MAX-MNTHLY9(5)V99The calculation of the Basic Allowance without optional allowance modification.

See DEFINITION OF SYSTEM/PLAN CODES (worksheet tab)

3173171NEG-UP-BIF-MAX-MNTHLYXSign for prior field - (positive (spaces); negative (-) indicator)
3183247MAX-ENHANCED (BASIC ALLOWANCE - ENHANCED TIER)UP-ENH-MAX-MNTHLY9(5)V99The calculation of the Basic Allowance without optional allowance modification.

See DEFINITION OF SYSTEM/PLAN CODES (worksheet tab)

3253251NEG-UP-ENH-MAX-MNTHLYXSign for prior field - (positive (spaces); negative (-) indicator)
3263327MAX-REFORMED (BASIC ALLOWANCE - REFORMED TIER)UP-REF-MAX-MNTHLY9(5)V99The calculation of the Basic Allowance without optional allowance modification.

See DEFINITION OF SYSTEM/PLAN CODES (worksheet tab)

3333331NEG-UP-REF-MAX-MNTHLYXSign for prior field - (positive (spaces); negative (-) indicator)
3343418MAX-TOTAL (BASIC ALLOWANCE - ALL TIERS)UP-TTL-MAX-MNTHLY9(6)V99Sum of the Basic Allowance from all tiers
3423421NEG-UP-TTL-MAX-MNTHLYSign for prior field - (positive (spaces); negative (-) indicator)
3433497GROSS ALLOWANCEUP-RETIRE-ALLOW-PMO9(5)V99Gross monthly benefit allowance for all tiers
3503501NEG-UP-RETIRE-ALLOW-PMOXSign for prior field - (positive (spaces); negative (-) indicator)
3513599TAC (TOTAL ACCUMULATED CONTRIBUTIONS)UP-TOT-ACC-CONT9(7)V99§20-101(b)(1)(2) – the amounts credited to a retiree's individual account in the Annuity Savings Fund of the appropriate State system. At retirement contribution and interest amounts are transferred from the Annuity Savings Fund to the Retirement Accumulation Fund. Accumulated contributions include member contributions, purchases of service, voluntary contributions and regular interest. "Regular Interest" means interest at the rate payable on accumulated contributions as provided under this Division II for each State system.
3603601NEG-UP-TOT-ACC-CONTXSign for prior field - (positive (spaces); negative (-) indicator)
3613688DEF (CONTRIBUTIONS AND INTEREST DEFICIENCY)UP-Deficiency9(6)V99Accumulated deficiency (contributions and interest) that actuarially reduces the monthly benefit allowance.
3693691NEG-UP-DEFICIENCYXSign for prior field - (positive (spaces); negative (-) indicator)
37038011PV (PRESENT VALUE)UP-PRES-VAL-OPT9(9)V99The remaining balance of the guaranteed amount payable as defined by the provisions for Options 01 & 04.
3813811NEG-UP-PRES-Val-OPTXSign for prior field - (positive (spaces); negative (-) indicator)
3823887SPCL (STATE POLICE SPECIAL COST OF LIVING ADJUSTMENT - REGULAR TIER ONLY)UP-SPCL-AMT-PMO9(5)V99State Police accounts retired prior to 7/1/99 received a special retirement allowance adjustment (§ 24-401(e)) that receives an annual cola adjustment. Cola on the special retirement allowance is calculated as follows:

As its numerator, the Consumer Price Index for the calendar year ending December 31 of the preceding fiscal year; and as its denominator, the Consumer Price Index for the calendar year ending December 31, 1998 (488.3).

Effective FY 2013, the SRA moved the Monthly Tier 2 CPI Amount from Bifurcated Cost of Living Adjustment (BIF-CL) field to its own field - State Police Cost of Living Adjustment (SP-CL) to support year end tax reporting purposes for Accidental Disability Retirees.

3893891NEG-UP-SPCL-AMT-PMOXSign for prior field - (positive (spaces); negative (-) indicator)
3903967VA-REFORMED (VOLUNTARY ANNUITY - REFORMED TIER)UP-REF-VOL-ANN-PMO9(5)V99Portion of a benefit that is derived from voluntary member contributions and interest as described in §20-101(c). This money does not receive a Cost of Living Adjustment (COLA).
3973971NEG-UP-REF-VOL-ANN-PMOXSign for prior field - (positive (spaces); negative (-) indicator)
3984058VA-TOTAL (VOLUNTARY ANNUITY - ALL TIERS)UP-TTL-VOL-ANN9(6)V99Sum of the Cost of Living Adjustment monthly benefit tiers
4064061NEG-UP-TTL-VOL-ANNXSign for prior field - (positive (spaces); negative (-) indicator)
4074104FILLERX(4)FILLER
4114133MEM-REG (MEMBERSHIP SERVICE - REGULAR TIER)UP-MEM-REG9(3)Creditable membership service applied in accordance with system/plan rules. See DEFINITION OF SYSTEM/PLAN CODES (worksheet tab)
4144163PR-REG (PRIOR SERVICE - REGULAR TIER)UP-PR-REG9(3)Creditable prior service applied in accordance with system/plan rules. See DEFINITION OF SYSTEM/PLAN CODES (worksheet tab)
4174193NM-REG (NEW MILITARY SERVICE - REGULAR TIER)UP-NM-REG9(3)Creditable new military service applied in accordance with system/plan rules. See DEFINITION OF SYSTEM/PLAN CODES (worksheet tab)
4204223OM-REG (OLD MILITARY SERVICE - REGULAR TIER)UP-OM-REG9(3)Creditable old military service applied in accordance with system/plan rules. See DEFINITION OF SYSTEM/PLAN CODES (worksheet tab)
4234253SL-REG (SICK LEAVE SERVICE - REGULAR TIER)UP-SL-REG9(3)Creditable sick leave service applied in accordance with system/plan rules. See DEFINITION OF SYSTEM/PLAN CODES (worksheet tab)
4264283I/PROJ-REG (INCENTIVE SERVICE OR PROJECTED DISABILITY SERVICE - REGULAR TIER)UP-INCN-PROJ-REG9(3)Creditable Incentive service (applicable to 1996 early retirement program) or Projected Pension System or CORS ordinary disabililty service to normal retirement age.
4294313TOTALS-REG (TOTAL REGULAR SERVICE - ALL TYPES)UP-TOT-CRED-SER-REG9(3)Sum of the Regular service types
4324343MEM-AFT (MEMBERSHIP SERVICE - AFTER TIER)UP-MEM-REG9(3)Creditable membership service applied in accordance with system/plan rules. See DEFINITION OF SYSTEM/PLAN CODES (worksheet tab)
4354373PR-AFT (PRIOR SERVICE - AFTER TIER)UP-PR-REG9(3)Creditable prior service applied in accordance with system/plan rules. See DEFINITION OF SYSTEM/PLAN CODES (worksheet tab)
4384403NM-AFT (NEW MILITARY SERVICE - AFTER TIER)UP-NM-REG9(3)Creditable new military service applied in accordance with system/plan rules. See DEFINITION OF SYSTEM/PLAN CODES (worksheet tab)
4414433OM-AFT (OLD MILITARY SERVICE - AFTER TIER)UP-OM-REG9(3)Creditable old military service applied in accordance with system/plan rules. See DEFINITION OF SYSTEM/PLAN CODES (worksheet tab)
4444463SL-AFT (SICK LEAVE SERVICE - AFTER TIER)UP-SL-REG9(3)Creditable sick leave service applied in accordance with system/plan rules. See DEFINITION OF SYSTEM/PLAN CODES (worksheet tab)
4474493I/PROJ-AFT (INCENTIVE SERVICE OR PROJECTED DISABILITY SERVICE - AFTER TIER)UP-INCN-PROJ- AFT9(3)Creditable Incentive service (applicable to 1996 early retirement program) or Projected Pension System or CORS ordinary disabililty service to normal retirement age.
4504523TOTALS-AFT (TOTAL AFTER SERVICE - ALL TYPES)UP-TOT-CRED-SER-AFT9(3)Sum of the After service types
4534553MEM-ENH (MEMBERSHIP SERVICE - ENHANCED TIER)UP-MEM-ENH9(3)Creditable membership service applied in accordance with system/plan rules. See DEFINITION OF SYSTEM/PLAN CODES (worksheet tab)
4564583PR-ENH (PRIOR SERVICE - ENHANCED TIER)UP-PR-ENH9(3)Creditable prior service applied in accordance with system/plan rules. See DEFINITION OF SYSTEM/PLAN CODES (worksheet tab)
4594613NM-ENH (NEW MILITARY SERVICE - ENHANCED TIER)UP-NM-ENH9(3)Creditable new military service applied in accordance with system/plan rules. See DEFINITION OF SYSTEM/PLAN CODES (worksheet tab)
4624643OM-ENH (OLD MILITARY SERVICE - ENHANCED TIER)UP-OM-ENH9(3)Creditable old military service applied in accordance with system/plan rules. See DEFINITION OF SYSTEM/PLAN CODES (worksheet tab)
4654673SL-ENH (SICK LEAVE SERVICE - ENHANCED TIER)UP-SL-ENH9(3)Creditable sick leave service applied in accordance with system/plan rules. See DEFINITION OF SYSTEM/PLAN CODES (worksheet tab)
4684703I/PROJ-ENH (INCENTIVE SERVICE OR PROJECTED DISABILITY SERVICE - ENHANCED TIER)UP-INCN-PROJ-ENH9(3)Creditable Incentive service (applicable to 1996 early retirement program) or Projected Pension System or CORS ordinary disabililty service to normal retirement age.
4714733TOTALS-ENH (TOTAL ENHANCED SERVICE - ALL TYPES)UP-TOT-CRED-SER-ENH9(3)Sum of the Enhanced service types
4744763MEM-REF (MEMBERSHIP SERVICE - REFORMED TIER)UP-MEM-REF9(3)Creditable membership service applied in accordance with system/plan rules. See DEFINITION OF SYSTEM/PLAN CODES (worksheet tab)
4774793PR-REF (PRIOR SERVICE - REFORMED TIER)UP-PR-REF9(3)Creditable prior service applied in accordance with system/plan rules. See DEFINITION OF SYSTEM/PLAN CODES (worksheet tab)
4804823NM-REF (NEW MILITARY SERVICE - REFORMED TIER)UP-NM-REF9(3)Creditable new military service applied in accordance with system/plan rules. See DEFINITION OF SYSTEM/PLAN CODES (worksheet tab)
4834853OM-REF (OLD MILITARY SERVICE - REFORMED TIER)UP-OM-REF9(3)Creditable old military service applied in accordance with system/plan rules. See DEFINITION OF SYSTEM/PLAN CODES (worksheet tab)
4864883SL-REF (SICK LEAVE SERVICE - REFORMED TIER)UP-SL-REF9(3)Creditable sick leave service applied in accordance with system/plan rules. See DEFINITION OF SYSTEM/PLAN CODES (worksheet tab)
4894913I/PROJ-REF (INCENTIVE SERVICE OR PROJECTED DISABILITY SERVICE - REFORMED TIER)UP-INCN-PROJ-REF9(3)Creditable Incentive service (applicable to 1996 early retirement program) or Projected Pension System or CORS ordinary disabililty service to normal retirement age.
4924943TOTALS-REF (TOTAL REFORMED SERVICE - ALL TYPES)UP-TOT-CRED-SER-REF9(3)Sum of the Reformed service types
4954973GRAND TOTAL CREDITABLE SERVICEUP-TOT-CR-SERV-MO9(3)Sum of the total creditable service for all tiers
4985003ELG-MO (ELIGIBILITY SERVICE MONTHS)UP-ELIG-MNTHS9(3)Eligibility service credit used to qualify a member for retirement.

For Retirement Systems eligibility service credit equals the sum of all service fields.

Effective with the FY2012 valuation file, SRA combines the eligibility credit of all system 1,2,6 or 7 records excluding CORS updating the combined total to the retirement record..

50153030FILLERX(30)FILLER
5315377CPI-A REGULAR (CPI ADJUSTMENT FACTOR - REGULAR TIER)UP-CPI-ADJUST-FACTOR9(2)V9(5)The CPI adjustment factor is used to calculate the annual COLA. Each tier's COLA is determined by multiplying the factor times that applicable portion of that tier's allowance. See DEFINITION OF SYSTEM/PLAN CODES (worksheet tab)
5385447CPI-A BIFURCATED (CPI ADJUSTMENT FACTOR - BIFURCATED TIER)UP-BIF-CPI-ADJ9(2)V9(5)The CPI adjustment factor is used to calculate the annual COLA. Each tier's COLA is determined by multiplying the factor times that applicable portion of that tier's allowance. See DEFINITION OF SYSTEM/PLAN CODES (worksheet tab)
5455517CPI-A ENHANCED (CPI ADJUSTMENT FACTOR - ENHANCED TIER)UP-ENH-CPI-ADJ9(2)V9(5)The CPI adjustment factor is used to calculate the annual COLA. Each tier's COLA is determined by multiplying the factor times that applicable portion of that tier's allowance. See DEFINITION OF SYSTEM/PLAN CODES (worksheet tab)
5525587CPI-A REFORMED (CPI ADJUSTMENT FACTOR - REFORMED TIER)UP-REF-CPI-ADJ9(2)V9(5)The CPI adjustment factor is used to calculate the annual COLA. Each tier's COLA is determined by multiplying the factor times that applicable portion of that tier's allowance. See DEFINITION OF SYSTEM/PLAN CODES (worksheet tab)
5595646CPI-B (CPI BASE FACTOR)UP-CPI-FACTOR-RETIRE9(3)V(3)CPI = Consumer Price Index - the State Retirement Agency uses the Consumer Price Index for all urban consumers, U.S. city average from the U.S. Department Of Labor, Bureau Of Statistics. CPI FACTOR = The average Consumer Price Index for the Calendar Year of retirement.

See CPI FACTOR (worksheet tab) 565 565 1 CPI-C (CPI FLAG) UP-CPI-CODE X If a ' 1' is present in the CPI Flag field then COLA is not calculated by the system.

Typical accounts with a ' 1 ' in the COLA flag are:

- Systems 4 and Systems 5 have a '1' in the CPI flag because their increases are based on salary increases of current Judges or Legislators.

- MD School for Deaf accounts have a "1" in the CPI Flag field due to a reporting issue

- Accounts established DRO's have a '1' since it is dependent on the court order if COLA applies. If COLA applies both the retiree account and the ex-spouse account have a '1' because the COLA must be calculated manually.

- Accounts that exceed the IRC 415 limit will have a '1' placed in the CPI CODE to prevent the calculation of COLA. These accounts must be review individually each year.

5665661DIS-FLG (DISABILITY FLAG)UP-Disability FlagXA disability flag = "1" identifies those retiree's who transferred from the retirement to the pension system within two years of the ordinary disability date of retirement.
5675671ABOL-FL (ABOLISHED FLAG)UP-ABOL-FLAGXAn 'A' in this field denotes an individual who met requirements to retire based on special legislation (Early Retirement Incentive Program (ERIP)) due to their position being abolished between January 1, 1996 and June 30, 1997. Individuals received extra months of service and a reduced reduction (up to 18% forgiveness). (See Incentive Fag, Incentive Months Prior and Incentive Months After below)

Individuals' with an Abolished Flag = A will have incentive credit. See I/PROJ description above.

5685681I-FLAG (INCENTIVE FLAG)UP-INCN-FLAGXAn 'I' in this field denotes an individual who retired under the State Early Retirement Incentive Program (ERIP). Individuals' with an Incentive Flag = I will have incentive credit. See I/PROJ description above.
5695691AFC-YR-FG (AVERAGE FINAL COMPENSATION YEAR FLAG)UP-AFC-YR-FLAGXIdentifies the number of years used to calculate the Average Final Compensation for calculating the retirement allowance. As a result of the pension reform changes enacted 7/1/2011 this field was added. See DEFINITION OF SYSTEM/PLAN CODES (worksheet tab)
5705745HOS-VEST (HOSPITALIZATION FLAG)UP-HOSP-VESTX(5)Memorandum only. Applicable to State heath benefit program valuation.
5755751FLAGUP-FLAGXA flag field used to identify special situations as follows:

'E' - Identifies a beneficiary receiving a benefit resulting from the loss of a public safety officer’s life in the line of duty, a value of ‘E’ in the FLAG field will signal the tax programs to report the annual annuity benefit as tax-free.

'J' - § 25-401.1 Establishes an early service retirement benefit for Baltimore City jail employees.

'L' - Identifies the account has a lien.

'S' - Identifies individual with multiple flags. Requires manual research although generally a DROP participant who also has a lien on their account.

'T' - This code was used on the active file to identify individuals in the retirement system that were no longer eligible to receive a special transfer rate under a statutory terminated program, met termination rules so only eligible to receive the straight 4% if transferring. Carry over from the active file, no impact on the retired file. Note: Legislation prohibits transfers from Employees' and Teachers' Retirement system to the Employees' and Teachers' Pension system after 12/31/2004.

'Z' - Identifies a DROP participant.

576 600 25 Filler Filler X(25)

General Notes:
General notes: No changes from prior year's valuation FY 2020 to the current FY 2021.
(a) Field UP-ANNUAL-MIN-PMO is deleted as field no longer exists on PRNA along with text negative indicator
(b) Field UP BIF-ADD-PEN-RESV is deleted as field no longer exists on PRNA along with text negative indicator
(c) Field UP-BIF-VOL-ANN is deleted as field no longer exists on PRNA along with text negative indicator
(d) Field UP-BIF-TSA-ANN is deleted as field no longer exists on PRNA along with text negative indicator
(e) Field UP-BIF-SUPPL is deleted as field no longer exists on PRNA along with text negative indicator
(f) Field UP-BIF-ANN-MIN is deleted as field no longer exists on PRNA along with text negative indicator
(g) Field UP-TOT-CR-SERV-MO is derived by summing all creditable service fields. Logic revision needed to include all- new fields. Will show each separate field component as well as this summary field.
(h) Field UP-TSA-ANN-FLAG is deleted as field no longer exists on PRNA
(i) Field UP-FLAG was inadvertently deleted during initial testing, but identified by Actuary as missing and added 6/28/2012 prior to production execution for FY2012 valuation data.

File details come from the government source that posted it. Updated .