Red Hook WatchIndependent Community Resource

NYSLRS Enhanced Reporting File Format

↑Meetings/Document history/chain_0819
1 versions2023-01-26working document

Versions

  1. 12023-01-26
    NYSLRS Enhanced Reporting File Format
    working documentmeeting · 2023-01-26

Document

Open original on source siteView version history →Meeting on 2023-01-26 →

==> picture [145 x 52] intentionally omitted <==

----- Start of picture text -----

Thomas P. DiNapoli, State Comptroller NYSLRS New York State and Local Retirement System ----- End of picture text -----

Retirement Online

Enhanced Reporting File Format

OVERVIEW

The following specifications for the enhanced file format are for those who generate reports for local employers. These technical updates will allow employers to report new, more detailed information. The enhanced report must be generated as a pipe-delimited .txt file. Additionally, when reporting with the enhanced format, employers will provide information for a broader population of employees. This population will include all employees who are potentially eligible for NYSLRS membership, such as optional members, as well as retirees.

For more information on the benefits of enhanced reporting, see our Enhanced Reporting Fact Sheet at web.osc.state.ny.us/retire/ retirement_online/word_and_pdf_documents/enhanced-reporting-fact-sheet.pdf .

Reporting Formats and Transaction Types

The first row of the enhanced reporting file must contain your five-digit employer location code. The second row is where you will begin listing the different transactions for your employees.

The enhanced file format has four transaction types that determine what information must be provided for employees in your report. Each transaction type has its own use cases. The first five fields are repeated on each transaction type for consistency. The following tables provide details about when to use each transaction type and what information each requires. The columns found in each table detail the fields needed for each transaction:

  • Field Name: Denotes what information must be provided.

  • “Is This Field Required?”: Indicates when a field must have a valid entry in it.

    • Required: Field must contain an allowable value or else the file cannot be successfully submitted.

    • Optional: Field does not need a value to successfully submit the file.

    • Conditional: Field becomes required if another field contains a certain entry.

  • Expected Input: Describes the format of the value to be entered.

  • Max Field Length: The maximum number of characters that can be entered into a field. Note, there are some fields where you may not enter all values, and some values may require numbers with decimals.

  • Example: Provides an example of an allowable value that would be entered into the field.

  • Additional Functional Details: Provides additional information for the corresponding field.

Please note that the enhanced file format accommodates the reporting of regular and adjustment transactions in a single combined file:

  • Regular Transactions: Used to report any associated days, earnings and payroll deductions that have not previously been reported to NYSLRS. This could be money paid to/deducted from an employee in the current reporting period or an employee who has been omitted from prior reports to NYSLRS.

  • Adjustment Transaction: Used to report days or earnings that are being corrected due an incorrect entry in a previously submitted report. Due to internal processing changes, NYSLRS will no longer accept adjustments to cash amounts such as contributions, loans or service credit payments.

2

1. BIOGRAPHICAL DATA

Biographical Data (Transaction Type 1) is only required when reporting a new employee for the first time. This transaction will generate an employee’s NYSLRS ID as enhanced reporting will automatically enroll new mandatory members.

Biographical Data Transaction Requirements

Complete Example:

1|NEW|NEW|0011|Jan|012010011|Prof|Jane|Elizabeth|Smith|Esq|01/20/1950|F|USA|2424 State Street| Apartment 3||ALBANY|NY|01234-5678

==> picture [542 x 455] intentionally omitted <==

----- Start of picture text -----

Is This Max Field Name Field Expected Input Field Example Additional Functional Details Required? Length Transaction Type REQUIRED This should always be populated 1 1 Transaction type allows for the system as “1” for a Biographical Data to differentiate between the four transaction. transaction types. NYSLRS ID REQUIRED A transaction type “1” signifies this 9 NEW NYSLRS ID is the new unique identifier for employee is being newly reported to people in the NYSLRS system. It will replace NYSLRS, therefore enter a value the registration number as employers of “NEW”. transition to the enhanced format. This value is provided by NYSLRS after submitting the Biographical and Job Data transactions for a new employee and is to be stored in your system for future reports. Employment REQUIRED A transaction type “1” signifies this 3 NEW The employment instance is used to Instance employee is being newly reported determine which job is being reported to NYSLRS, therefore enter a value on in the enhanced format. While the of “NEW”. NYSLRS ID identifies the person, the employment instance identifies the job. This value is provided by NYSLRS after submitting the Biographical and Job Data transactions for a new employee and is to be stored in your system for future reports. Social Security REQUIRED The last four digits of the employee’s 4 0011 Number Social Security number (SSN). (Last Four Digits) First Three REQUIRED The first three letters of the 3 Jan Characters of employee’s first name. First Name Social Security REQUIRED The employee’s complete nine-digit 9 012010011 The full SSN is required only when Number Social Security number. Do not a new employee is initially reported (Complete) include hyphens or spaces. to NYSLRS. ----- End of picture text -----

3

==> picture [542 x 44] intentionally omitted <==

----- Start of picture text -----

Is This Max Field Name Field Expected Input Field Example Additional Functional Details Required? Length ----- End of picture text -----

|Field Name|Is This Field Required?|Expected Input|Max Field Length|Example|Additional Functional Details| |---|---|---|---|---|---| | Name Prefx | OPTIONAL | The employee’s name prefx without a | 4 | Prof | | - | - | “.” following the prefx. Allowable values: | - | - | | - | - | Ald = Alderman | - | - | | - | - | Bisp = Bishop | - | - | | - | - | Bro = Brother | - | - | | - | - | Comd = Commander | - | - | | - | - | Comr = Commissioner | - | - | | - | - | Dr = Doctor | - | - | | - | - | Fr = Father/Friar | - | - | | - | - | Gov = Governor | - | - | | - | - | Hon = Honorable | - | - | | - | - | Lt = Lieutenant | - | - | | - | - | Prof = Professor | - | - | | - | - | Rev = Reverend | - | - | | - | - | Sen = Senator | - | - | | - | - | Sr = Sister | - | - | |First Name|REQUIRED|The employee’s complete legal frst name. This feld can include any hyphens, apostrophes or other special characters the name may use.|30|Jane|| |Middle Name|OPTIONAL|The employee’s complete middle name. This feld can include any hyphens, apostrophes or other special characters the name may use.|30|Elizabeth|| |Last Name|REQUIRED|The employee’s complete legal last name. This feld can include any hyphens, apostrophes or other special characters the name may use.|30|Smith|| | Name Suffx | OPTIONAL | The employee’s name suffx without | 15 | Esq | | - | - | a “.” following the suffx. Allowable | - | - | | - | - | values: | - | - | | - | - | Exec = Executor | - | - | | - | - | I = First | - | - | | - | - | II = Second | - | - | | - | - | III = Third | - | - | | - | - | IV = Fourth | - | - | | - | - | V = Fifth | - | - | | - | - | VI = Sixth | - | - | | - | - | VII = Seventh | - | - | | - | - | VIII = Eighth | - | - | | - | - | IX = Ninth | - | - | | - | - | X = Tenth | - | - | | - | - | Eng = Engineer | - | - | | - | - | Esq = Esquire | - | - | | - | - | Jr = Junior | - | - | | - | - | LPN = Licensed Practical Nurse | - | - | | - | - | MD = Medical Doctor | - | - | | - | - | PhD = Doctor of Philosophy | - | - | | - | - | Sr = Senior | - | - | | - | - | DVM = Doctor of Veterinary Medicine | - | - | | - | - | DDS = Doctor of Dental Surgery | - | - | | - | - | RN = Registered Nurse | - | - |

4

==> picture [542 x 44] intentionally omitted <==

----- Start of picture text -----

Is This Max Field Name Field Expected Input Field Example Additional Functional Details Required? Length ----- End of picture text -----

|Field Name|Is This Field Required?|Expected Input|Max Field Length|Example|Additional Functional Details| |---|---|---|---|---|---| |Date of Birth|REQUIRED|The employee’s date of birth using the standard date format: MM/DD/YYYY|10|01/20/1950|| |Sex|REQUIRED|The employee’s sex. Allowable values: M = Male F = Female X = Non-binary or gender non-conforming U = Unknown|1|F|| |Country|REQUIRED|The standard three-character country abbreviation of the employee’s country of their mailing address.|3|USA|For Canadian mailing addresses, “CAN” should be used.| |Address|REQUIRED|Alphanumeric frst line of the employee’s mailing address. Spaces are allowed between each part of the address.|55|2424 State Street|| |Address 2|OPTIONAL|Alphanumeric second line of the employee’s mailing address. Spaces are allowed between each part of the address.|55|Apartment 3|| |Address 3|OPTIONAL|Alphanumeric third line of the employee’s mailing address. Spaces are allowed between each part of the address.|55||| |City|REQUIRED|The name of the city of the employee’s mailing address.|30|Albany|| |State|REQUIRED|Abbreviation of the state of the employee’s mailing address.|6|NY|Six letters are permitted to include states in other countries.| |ZIP Code|REQUIRED|The ZIP Code of the employee’s mailing address.|10|01234-5678|This feld will accept the fve-digit ZIP Code for US residences and the US ZIP Code with the additional four-digit detail. This feld can also accept the six-digit ZIP Code for Canadian residences.|

5

2. JOB DATA

Job Data (Transaction Type 2) is required for new employees or if a person has a change in their job status. Once submitted, this transaction will create a new employment instance for the employee. NYSLRS will use the information provided in this transaction to evaluate whether the employee meets NYSLRS mandatory membership criteria.

New employees and employees with changes in job status can be noted with the following HR transaction types:

  • For new employees: Hire .

  • For job status changes: Leave of Absence , Return from Leave , Military Leave , or Termination .

  • For changes in job information (e.g. promotion to a new position): Data Change .

Job Data Transaction Requirements

Complete Example:

2|NEW|NEW|0011|Jan|12/13/2016|HIR|03600E|A|120000.00|8|160000.00|R|F|12P|Y|NYSTRS

==> picture [543 x 440] intentionally omitted <==

----- Start of picture text -----

Max Is This Field Field Name Expected Input Field Example Additional Functional Details Required? Length Transaction Type REQUIRED This should always be populated as 1 2 Transaction type allows for system “2” for a Job Data transaction. to differentiate between the four transaction types. NYSLRS ID REQUIRED An alphanumeric character string that 9 NEW NYSLRS ID is the new unique identi- begins with an R and is followed by fier for people in the NYSLRS system. eight numbers (e.g. R11223344) OR if It will replace the registration number this is a new employee, enter a value when employers transition to the of “NEW”. enhanced format. This value is provided by NYSLRS after submitting the Biographical and Job Data transactions for a new employee and is to be stored in your system for future reports. Employment REQUIRED A maximum three-digit number OR if 3 NEW The employment instance is used to Instance this is a new employee, enter a value determine which job is being reported of “NEW”. on the enhanced format. While the NYSLRS ID identifies the person, the employment instance identifies the job. This value is provided by NYSLRS after submitting the Biographical and Job Data transactions for a new employee and is to be stored in your system for future reports. Social Security REQUIRED The last four digits of the employee’s 4 0011 Number Social Security number. (Last Four Digits) First Three REQUIRED The first three letters of the 3 Jan Characters of employee’s first name. First Name ----- End of picture text -----

6

==> picture [543 x 44] intentionally omitted <==

----- Start of picture text -----

Max Is This Field Field Name Expected Input Field Example Additional Functional Details Required? Length ----- End of picture text -----

|Field Name|Is This Field Required?|Expected Input|Max Field Length|Example|Additional Functional Details| |---|---|---|---|---|---| |Transaction Date|REQUIRED|The transaction date is entered using the standard date format: MM/DD/ YYYY|10|12/13/2016|This is the date the HR transaction (defned in the HR Transaction Type feld) becomes effective.| | HR Transaction | REQUIRED | Enter the HR transaction type. | 3 | HIR | Changes to an employee’s job status | | Type | - | Allowable values: | - | - | can impact service crediting and | | - | - | HIR = Hire | - | - | beneft calculations for employees | | - | - | REH = Rehire | - | - | as well as required loan payment | | - | - | DTA = Data Change | - | - | deductions. When an employee | | - | - | LOA = Leave of Absence | - | - | has a job status change, employers | | - | - | MED = Leave of Absence (Medical) | - | - | can include this information on the | | - | - | MIL = Military Leave | - | - | enhanced report and it can be stored | | - | - | RFL = Return from Leave (Any) | - | - | for the employee. | | - | - | TER = Termination | - | - | - | | Job Code | REQUIRED | An alphanumeric string of six | 6 | 03600E | Job codes determine what beneft plan | | - | - | characters; valid values defned by | - | - | an employee qualifes for. NYSLRS will | | - | - | NYSLRS. | - | - | post the list of acceptable job codes to | | - | - | - | - | - | the Retirement Online for Employers | | - | - | - | - | - | home page. Employers must map their | | - | - | - | - | - | job codes to one of the valid codes as | | - | - | - | - | - | provided by NYSLRS. | | Pay Frequency | REQUIRED | Allowable values: | 5 | A | Indicates how often the employee | | - | - | A = Annual | - | - | is paid. | | - | - | B = Biweekly | - | - | - | | - | - | M = Monthly | - | - | - | | - | - | Q = Quarterly | - | - | - | | - | - | S = Semimonthly | - | - | - | | - | - | T = Semi-Annual | - | - | - | | - | - | W = Weekly | - | - | - | | Annual | REQUIRED | The actual compensation rate the | 12.2 | 120000.00 | For a full-time employee, this value | | Compensation | - | employee is expected to make | - | - | would be equal to the Annualized Rate | | Rate | - | annually, using two decimal places. | - | - | of Pay. For a part-time employee, this | | - | - | This feld will be used to determine | - | - | feld is calculated based on the number | | - | - | overtime limitations. | - | - | of hours the employee is expected to | | - | - | - | - | - | work in a calendar year multiplied by | | - | - | - | - | - | the employee’s hourly rate. | |Standard Work Day|REQUIRED|The hours per day a full-time employee in the position would be expected to work, followed by a decimal (if needed) and a maximum of two decimal places.|4.2|7.5|Must be between six-to-eight hours for all jobs.| | Annualized Rate | REQUIRED | The compensation rate the employee | 15.2 | 120000.00 | Previous NYSLRS references have | | of Pay | - | would be expected to make if the | - | - | called this feld “Annualized Wage.” | | - | - | employee were full-time, using two | - | - | For details regarding calculation of | | - | - | decimal places. | - | - | the Annualized Rate of Pay, please | | - | - | - | - | - | determine the appropriate system of | | - | - | - | - | - | membership and see the corresponding | | - | - | - | - | - | “Annual Wage” calculation section in | | - | - | - | - | - | the Employees’ Retirement System | | - | - | - | - | - | Membership Application or the Police | | - | - | - | - | - | and Fire Membership Application. |

7

==> picture [543 x 44] intentionally omitted <==

----- Start of picture text -----

Max Is This Field Field Name Expected Input Field Example Additional Functional Details Required? Length ----- End of picture text -----

|Field Name|Is This Field Required?|Expected Input|Max Field Length|Example|Additional Functional Details| |---|---|---|---|---|---| | Regular/ | REQUIRED | Allowable values: | 1 | R | Regular employees have no end date | | Temporary | - | R = Regular | - | - | regardless of their probationary status. | | Employee | - | T = Temporary | - | - | Temporary employees are any other | | - | - | - | - | - | type of employees including seasonal, | | - | - | - | - | - | provisional, substitute, on call or | | - | - | - | - | - | per diem. | | - | - | - | - | - | Used along with the Job Code | | - | - | - | - | - | feld to determine if a person is a | | - | - | - | - | - | mandatory member of NYSLRS. | | - | - | - | - | - | If they are mandatory, that employee | | - | - | - | - | - | is automatically enrolled using the | | - | - | - | - | - | reported data. | |Full-Time/ Part-Time Employee|REQUIRED|Allowable values: F = Full-Time P = Part-Time|1|F|Used, along with job code, to determine if a person is a mandatory member of NYSLRS. If they are mandatory, that employee is automatically enrolled using reported data.| | Employee Class | REQUIRED | Allowable values: | 3 | 12P | | - | - | 12 = 12 Month | - | - | | - | - | 12P = 12 Month Provisional | - | - | | - | - | 10 = 10 Month | - | - | | - | - | S = Seasonal | - | - | | - | - | OC = On Call | - | - | | - | - | SB = Substitute | - | - | | - | - | PD = Per Diem | - | - | |Retirement Indicator|REQUIRED|Indicates whether the employee is retired from any of the public retire- ment systems in New York State or New York City. Allowable values: Y = Yes N = No|1|Y|NYSLRS is obligated to monitor post-retirement earnings.| | Retired in | CONDITIONAL: | The public retirement system from | 7 | NYSTRS | If the employee is retired from a | | Retirement | Required | which the employee is retired. | - | - | reciprocal system, enter the retirement | | System | if the | Allowable values: | - | - | system from which they retired. | | - | Retirement | NYSTRS | - | - | - | | - | Indicator is | NYSERS | - | - | - | | - | marked “Y” | NYSPFRS | - | - | - | | - | - | NYCPPF | - | - | - | | - | - | NYCFPF | - | - | - | | - | - | NYCBDED | - | - | - | | - | - | NYCTRS | - | - | - | | - | - | NYCERS | - | - | - |

8

3. DAYS AND CONTRIBUTIONS

Days and Contributions (Transaction Type 3) is required for all employees where:

  • Days were worked for the payroll period being reported, or

  • Contributions were deducted for the payroll period being reported, or

  • A loan payment was deducted for the payroll period being reported, or

  • Service credit purchase payments were deducted for the payroll period being reported.

Days and Contributions Transaction Requirements

Complete Example:

3|NEW|NEW|0011|Jan|R|12/31/2016|2|15|500.00|450.00|0.00|200.20|150.50

==> picture [542 x 481] intentionally omitted <==

----- Start of picture text -----

Is This Max Field Name Field Expected Input Field Example Additional Functional Details Required? Length Transaction Type REQUIRED This should always be populated 1 3 Transaction type allows for system as “3” for a Days and Contributions to differentiate between the four transaction. transaction types. NYSLRS ID REQUIRED An alphanumeric character string 9 NEW NYSLRS ID is the new unique identifier for that begins with an R and is followed people in the NYSLRS system. It will replace by eight numbers (e.g. R11223344) the registration number as employers OR if this is a new employee, enter transition to the enhanced format. a value of “NEW”. This value is provided by NYSLRS after submitting the Biographical and Job Data transactions for a new employee and is to be stored in your system for future reports. Employment REQUIRED A maximum three-digit number OR if 3 NEW The employment instance is used to Instance this is a new employee, enter a value determine which job is being reported of “NEW”. on the enhanced format. While the NYSLRS ID identifies the person, the employment instance identifies the job. This value is provided by NYSLRS after submitting the Biographical and Job Data transactions for a new employee and is to be stored in your system for future reports. Social Security REQUIRED The last four digits of the employee’s 4 0011 Number (Last Social Security number. Four Digits) First Three REQUIRED The first three letters of the 3 Jan Characters of First employee’s first name. Name Regular/ REQUIRED Indicate if this transaction is a regular 1 R Adjustment report or an adjustment report for Indicator system processing. Allowable values: R = Regular A = Adjustment ----- End of picture text -----

9

==> picture [542 x 44] intentionally omitted <==

----- Start of picture text -----

Is This Max Field Name Field Expected Input Field Example Additional Functional Details Required? Length ----- End of picture text -----

|Field Name|Is This Field Required?|Expected Input|Max Field Length|Example|Additional Functional Details| |---|---|---|---|---|---| |Payroll End Date|REQUIRED|Date of the last day of the period being reported (the last day of the month). The payroll end date is entered using the standard date format: MM/DD/YYYY|10|12/31/2016|This specifes the month for which the days and/or contributions reported in this transaction are applicable. Note: A reporting fle can contain transactions with more than one payroll end date.| |Number of Pay Cycles in Period|REQUIRED|Number between one and fve based on the Pay Frequency.|1|2|Number of pay cycles included in this reported transaction (e.g. an employee paid weekly might have been paid up to four or fve times in a reported month).| | Reported Days | OPTIONAL | The number of days worked in the | 3.2 | 15 | The number of days worked to be | | - | - | period of time covered by the report. | - | - | reported should be calculated as the | | - | - | A maximum of three numbers followed | - | - | number of hours worked during the | | - | - | by a decimal (if needed) and rounded | - | - | reporting period divided by the number | | - | - | to two decimal places. | - | - | of hours in the standard work day, | | - | - | - | - | - | rounded to two decimal places. | | - | - | - | - | - | If this is an Adjustment transaction, days | | - | - | - | - | - | can be adjusted positively or negatively. | | - | - | - | - | - | This feld value may be 0 or null if there | | - | - | - | - | - | are no days associated with the corre- | | - | - | - | - | - | sponding earnings (e.g. for a lump sum | | - | - | - | - | - | payment or a grievance/arbitration award). | |Reported Pre-Tax Contributions|OPTIONAL|The pre-tax contributions that were deducted for the employee. A maximum of sixteen numbers followed by a decimal (if needed) and two decimal places.|16.2|500.00|Note: Contributions cannot be adjusted once reported. This feld value may be 0 or null if there are no contributions associated with the corresponding earnings.| |Reported Post-Tax Contributions|OPTIONAL|The post-tax contributions that were deducted for the employee. A maximum of sixteen numbers followed by a decimal (if needed) and two decimal places.|16.2|450.00|Note: Contributions cannot be adjusted once reported. This feld value may be 0 or null if there are no contributions associated with the corresponding earnings.| |Reported Loan Payments|OPTIONAL|The employee’s reported loan payment amount. A maximum of sixteen numbers followed by a decimal (if needed) and two decimal places.|16.2|0.00|Note: Loan payments cannot be adjusted once reported. This feld value may be 0 or null if there are no loan payments associated with the report.| |Pre-Tax Service Credit Payments|OPTIONAL|The employee’s pre-tax service credit purchase deduction for the purpose of completing a service credit purchase. A maximum of sixteen numbers followed by a decimal (if needed) and a maximum of two decimal places.|16.2|200.20|Note: Service credit payments cannot be adjusted once reported. This feld value may be 0 or null if there are no pre-tax service credit payments associated with the report.| |Post-Tax Service Credit Payments|OPTIONAL|The employee’s post-tax service credit purchase deduction for the purpose of completing a service credit purchase. A maximum of sixteen numbers followed by a decimal (if needed) and a maximum of two decimal places.|16.2|150.50|Note: Service credit payments cannot be adjusted once reported. This feld value may be 0 or null if there are no post-tax service credit payments associated with the report.|

10

4. EARNINGS

Earnings (Transaction Type 4) is required for all employees who had earnings for the payroll period. All earnings (pensionable and non-pensionable) should be mapped to a corresponding earnings code and reported to NYSLRS. NYSLRS will provide the list of valid earnings codes.

Earnings Transaction Requirements

Complete Example:

4|NEW|NEW|0011|Jan|R|12/31/2016|DEF|2433.75|80.00

|Field Name|Is This Field Required?|Expected Input|Max Field Length|Example|Additional Functional Details| |---|---|---|---|---|---| |Transaction Type|REQUIRED|This should always be populated as “4” for an Earnings transaction.|1|4|Transaction type allows for system to differentiate between the four transaction types.| | NYSLRS ID | REQUIRED | An alphanumeric character string that | 9 | NEW | NYSLRS ID is the new unique identifer for | | - | - | begins with an R and is followed by | - | - | people in the NYSLRS system. It will replace | | - | - | eight numbers (e.g. R11223344) OR if | - | - | the registration number as employers | | - | - | this is a new employee, enter a value | - | - | transition to the enhanced format. | | - | - | of “NEW”. | - | - | This value is provided by NYSLRS after | | - | - | - | - | - | submitting the Biographical and Job Data | | - | - | - | - | - | transactions for a new employee and is to | | - | - | - | - | - | be stored in your system for future reports. | | Employment | REQUIRED | A maximum three-digit number OR if | 3 | NEW | The employment instance is used to | | Instance | - | this is a new employee, enter a value | - | - | determine which job is being reported on | | - | - | of “NEW”. | - | - | the enhanced format. While the NYSLRS | | - | - | - | - | - | ID identifes the person, the employment | | - | - | - | - | - | instance identifes the job. | | - | - | - | - | - | This value is provided by NYSLRS after | | - | - | - | - | - | submitting the Biographical and Job Data | | - | - | - | - | - | transactions for a new employee and is to | | - | - | - | - | - | be stored in your system for future reports. | |Social Security Number (Last Four Digits)|REQUIRED|The last four digits of the employee’s Social Security number.|4|0011|| |First Three Characters of First Name|REQUIRED|The frst three letters of the employee’s frst name.|3|Jan|| |Regular/ Adjustment Indicator|REQUIRED|Indicate if this transaction is a regular report or an adjustment report for system processing. Allowable values: R = Regular A = Adjustment|1|R|The initial report of earnings would be regular. Any positive or negative changes to earnings previously reported to NYSLRS would be an adjustment.| |Payroll End Date|REQUIRED|Date of the last day of earnings of the period being reported. The payroll end date is entered in the format of MM/DD/YYYY.|10|12/31/2016|This specifes the end date of the month in which the earnings were accrued.|

11

==> picture [543 x 44] intentionally omitted <==

----- Start of picture text -----

Is This Max Field Name Field Expected Input Field Example Additional Functional Details Required? Length ----- End of picture text -----

|Field Name|Is This Field Required?|Expected Input|Max Field Length|Example|Additional Functional Details| |---|---|---|---|---|---| | Reported Earnings | REQUIRED | The earnings type for the reported | 3 | DEF | NYSLRS will provide a more detailed | | Code | - | earnings amount and reported earnings | - | - | breakdown of what should be reported | | - | - | hours. The allowable earnings codes are: | - | - | for each earnings code. | | - | - | DEF = Deferred Payment | - | - | - | | - | - | EAR = Elected and Appointed Reporting | - | - | - | | - | - | GRA = Grievance/Arbitration Award | - | - | - | | - | - | HOL = Holiday Payment | - | - | - | | - | - | LON = Longevity | - | - | - | | - | - | LSV = Lump Sum Vacation | - | - | - | | - | - | MNP = Miscellaneous Non-Pensionable | - | - | - | | - | - | MPE = Miscellaneous Pensionable | - | - | - | | - | - | NOT = Non-Pensionable Overtime | - | - | - | | - | - | OVT = Regular Overtime | - | - | - | | - | - | PEO = Private Entity Overtime | - | - | - | | - | - | RBC = Retroactive Pay/Balance | - | - | - | | - | - | of Contract | - | - | - | | - | - | RBS = Recurring Bonus Payments | - | - | - | | - | - | REG = Regular Earnings | - | - | - | | - | - | ROT = Retroactive Overtime Pay | - | - | - | | - | - | SLV = Unpaid Sick Leave | - | - | - | | - | - | WCS= Workers Comp. – State | - | - | - | |Reported Earnings Amount|OPTIONAL|The amount that was earned for the reported earnings code. A numeric string with a maximum of 16 numbers followed by a decimal and a maximum of two decimal places.|16.2|2433.75|This feld value may be 0 or null if there are no earnings associated with the transaction, such as if reporting unpaid sick leave.| |Reported Earnings Hours|OPTIONAL|The hours that are associated to the reported earnings amount and reported earnings code. A numeric string with a maximum of four numbers followed by a decimal and a maximum of two decimal places.|4.2|80.00|This feld value may be 0 or null if there are no hours associated with the earnings, such as if reporting a lump sum or grievance/ arbitration award.|

If you have questions about Retirement Online or the enhanced reporting format, please call the Retirement Online Help Desk at 844-619-9614 during normal business hours, or send an inquiry using the Help Desk form at www.osc.state.ny.us/retirement/ employers/help-desk-form .

12

Rev. 1/23