December20, 2017 PeopleSoft Payroll for North America Patch 27233787 – Release 9.2

PeopleSoft Payroll for North America
Release 9.2

Peoplesoft Release Patchset27233787 Notes

PeopleSoft Payroll for North America Patchset27233787delivered a consolidation of the following patches for U.S. Year End and Quarterly reports which were late for Tax Update 17-Edelivery :

  • 27161339- TAX910LD DOESN'T CREATE WI YE RCDS IN CERTAIN SCENARIOS
  • 26395390 - WI EFW2 CHANGES REQUIRE D FOR YR 2017
  • 27138039 - TAX810FL.SQR: NEW SOFTWARE ID ISSUED FOR PEOPLESOFT
  • 27134052 - NORTH CAROLINA EFW2 CHANGES FOR 2017 REPORTING
  • 25884348 - EFW2 REPORTING REQUIRED FOR WHITEHALL OH LOCALITY 84742
  • 27170534 - TAX810KY.SQR Q3 2017 EXCESS WAGES REQUIRED S RECORD POSITIONS 78-91
  • 27099971 - MICHIGAN EFW2 CHANGES FOR 2017 REPORTING: DETROIT LWT INFO ADDED TO RS RECORD
  • 27248249 - AFTER 17E, MISSOURI LOCAL EFW2 RS RECORDS INCORRECT

Details pertaining to the above patches are provided later in this document. The same patches are also being included for delivery in Tax Update 18-A (PeopleSoft Update Image 9.2.025).

Base Bug 27161339 - TAX910LD DOESN'T CREATE WI YE RCDS IN CERTAIN SCENARIOS

9.2 Bug 27161339

TAX910LD.SQR loads data to the year-end records PS_YE_EE, PS_YE_DATA, and PS_YE_AMOUNTS.

TAX910LD.SQR is modified to correctly load year-end data for an employee who has zero-amount state withholding balance for the state of Wisconsin if:

  • The Load Year End Data processes the employee’s tax balances immediately before it processes an employee who has tax balances for U.S. territories, i.e. American Samoa, Guam, Puerto Rico or Virgin Island.
  • “All Employees” or “Selected W-2 Company” selection is made on the run control page of the Load Year End Data process.

Prior to the changes, the zero-amount Wisconsin state withholding balance was not loaded by the process in this scenario which resulted in incorrect W-2 reporting.

Base Bug 26395390 - WI EFW2 CHANGES REQUIRED FOR YR 2017

9.2 Bug 26395390

TAX960ST.SQR reports W-2 wage and tax data to state tax agencies that accept submissions in the SSA EFW2 reporting format.

PRTMMREF.SQC, in conjunction with TAX962ST.SQR, produces the audit report of the file produced by the TAX960ST.SQR program.

TAX960ST.SQR is modified to support new unique Form W-2 reporting requirements mandated by the Wisconsin Department of Revenue, described in the document “W-2 Preparation Guidance for Employers Engaged In Business In Wisconsin,” which is published on the Wisconsin Department of Revenue website.

Wisconsin now requires employers to submit a W-2 record for Wisconsin (W-2 box 15 = WI) for payments to an employee in either of the following situations, regardless of whether Wisconsin tax i s required to be withheld from the payments or whether the payments would constitute Wisconsin taxable wages subject to employer withholding under Wisconsin’s reciprocal withholding tax agreements and arrangements with other states:

  • Payments made to Wisconsin residents, regardless of where services are performed.
  • Payments made to non-residents for services performed in Wisconsin.

In some situations (such as in Example 4 in the “W-2 Preparation Guidance for Employers Engaged In Business In Wisconsin” document), compliance with this Wisconsin requirement may result in the creation of a W-2 record for Wisconsin that includes no Wisconsin taxable wage or tax amount.

For example:

An employee is a resident of Illinois and works in Wisconsin earning $50,000 for the tax year. Due to the Reciprocity arrangement (Reciprocity Rule 5A: “Do not withhold for the work state. Report work state with no wages.”), the employee has:

WI: zero taxable wages and associated tax

IL: $50,000 taxable wages and associated tax (e.g. $4,000)

The employee is reported as follows on the EFW2 file submitted to Wisconsin:

BEFORE MODIFICATIONS

No reporting to WI (only IL)

AFTER MODIFICATIONS:

RS Record #1:

  • positions 274-275: 17 (IL)
  • positions 276-286: 00005000000
  • positions 287-297: 00000400000

RS Record #2:

  • positions 274-275: 55 (WI)
  • positions 276-286 and 287-297 zero filled

PRTMMREF.SQC is redelivered with modifications related to compliance with the new Wisconsin W-2 reporting requirement.

Base Bug 27138039 - TAX810FL.SQR: NEW SOFTWARE ID ISSUED FOR PEOPLESOFT

9.2 Bug 27138039

Patch 27139513 modifies TAX810FL.SQR to include the new Software ID provided by Florida for PeopleSoft submissions.

Prior to the modifications, the Florida quarterly wage file contained an old Software ID that is no longer valid.

Base Bug 27134052 - NORTH CAROLINA EFW2 CHANGES FOR 2017 REPORTING

9.2 Bug 27134052

TAX960ST.SQR reports W-2 wage and tax data to state tax agencies that accept submissions in the SSA EFW2 reporting format.The program is modified to comply with tax year 2017 reporting requirements for North Carolina by adding the standard EFW2 RA, RT, and RF Records to the file (in addition to the existing RE, RW and RS Records).

Prior to the modifications, only the RE, RW and RS records were required for North Carolina.

Base Bug 25884348 - EFW2 REPORTING REQUIRED FOR WHITEHALL OH LOCALITY 84742

9.2 Bug 25884348

TAX960LC.SQR, in conjunction with TAXMMREF.SQC, reports W-2 wage and tax data to local tax agencies that accept submissions in the SSA EFW2 reporting format.

The programs are modified to support the electronic reporting of W-2 data in the SSA EFW2 format to Whitehall, Ohio beginning with data for tax year 2017. The City of Whitehall Income Tax Division requires all of the standard EFW2 records (RA, RE, RW, RS, RT, RF) in addition to the RS Record. A script is included in the patch that updates the Taxing Entity Code and W2 Reporting Agency fields to “WHT” for both fields in the Local Tax Table. The Local Tax Table for locality 84742 must be updated before running TAX960LC.SQR to create the file.

Base Bug 27170534 - TAX810KY.SQR Q3 2017 EXCESS WAGES REQUIRED S RECORD POSITIONS 78-91

9.2 Bug 27170534

TAX810KY.SQR reports employee quarterly wage and tax data to Kentucky in the ICESA format. The program is modified to comply with new quarterly wage and tax reporting requirements implemented by the Kentucky Division of Unemployment Insurance which are effective beginning with data reported for the quarter ending December 31, 2017 (report due January 31, 2018).The excess wages are reported on the RS Record in positions 78-91.

Prior to the modifications, the excess wages were not reported on the S record.

Base Bug 27099971 - MICHIGAN EFW2 CHANGES FOR 2017 REPORTING: DETROIT LWT INFO ADDED TO RS RECORD

9.2 Bug 27099971

TAX960ST.SQR, in conjunction with TAXMMREF.SQC, reports W-2 wage and tax data to state tax agencies that accept submissions in the SSA EFW2 reporting format. Patch 27166232 modifies both programs to comply with tax year 2017 reporting requirements for Michigan. For tax year 2017, Michigan now requires that Detroit local taxable wages and the associated tax withheld must be reported in addition to the Michigan state taxable wages and the associated tax withheld on the RS Record.

RS Record for Detroit wages and taxes:

305/307 City of Detroit code '170'

308 Tax Type Code 'C'

309-319 City Taxable Wages

320-330 City Tax Withheld

331-512 Blank

Positions 305-512 are blank-filled if an employee does not have any Detroit withholding information to report.

TAX962ST.SQR and PRTMMREF.SQC are also redelivered with modifications to comply with the Michigan reporting requirements for tax year 2017.

Base Bug 27248249- AFTER 17E, MISSOURI LOCAL EFW2 RS RECORDS INCORRECT

9.2 Bug 27248249

TAX960LC.SQR in conjunction with TAXMMREF.SQC reports W-2 wage and tax data to local tax agencies that accept submissions in the SSA EFW2 reporting format. The TAXMMREF program is redelivered to write the accurate structure of RS record according to Missouri Agencies requirements, which were incorrectly modified after Tax Update 17E.

Before Modifications

Agency: KCFD

Record S.

Position 203 - 234 reported blanks.

Position 248 - 267 reported blanks.

Position 308 - 327 reported blanks.

After Modifications

Agency: KCFD

Record S.

Position 203 - 234 reports zeroes.

Position 248 - 267 reports the EIN.

Position 308 reports the Tax Type Code

Position 309 - 319 reports the Local Wages.

Position 320 - 330 reports the Local Taxes.

PeopleSoft Proprietary and ConfidentialPeopleSoft Release Patchset 27233787-notes.doc - 1