Pay Period (PP) 06 Calendar Year (CY) 2018 PPS Release Notes

Pay Period (PP) 06 Calendar Year (CY) 2018 PPS Release Notes

Projects marked with an asterisk (*) are available for testing in the User Acceptance Testing (UAT) environment.

Project Number

Agency-Specific or Community-Wide

Project Title

Description of the Change

30999

Agency-Specific

Department of the Treasury (DOT)

Add Date Changed to Table Management System (TMGT), Table 5, Agency Organizational Structure, values via Table 103, TMGT Download Table

System modifications will be made to the TMGT Table 103 process to ensure that the last date updated is extracted and populated in the file sent to the Agency.

31773

Agency-Specific

Federal Deposit Insurance Corporation (FDIC)

FDIC Savings Plan Test Data Requirements

System modifications will be made to the Mainframe on the Thrift Savings 46602 file and the Roth 46606 files, to add five new fields at the end of each tax year and provide FDIC with Savings Plan Test Data.

897344

Agency-Specific

National Finance Center (NFC)

Insight Daily Time and Attendance Data (Build 3)

System modifications will be made to webTA 3.8 to create a biweekly job that will pull data from webTA 3.8 and migrate from the United States Department of Agriculture (USDA), Department of Justice (DOJ), and the Department of Homeland Security (DHS) into Insight.

1106936*

Agency-Specific

Farm Credit Administration (FCA)

Create One Way Data Feed Between Wells Fargo and NFC

System modifications will be made to the Mainframe to create a one-way data feed set up by NFC to transmit 401K payroll data files on FCA and Farm Credit System Insurance Corporation (FCSIC) employees via Secure File Transfer Protocol (SFTP) to Wells Fargo after each payroll run.

1261212*

Agency-Specific

Department of Homeland Security (DHS)

Download DHS Payroll Data

NFC will create and transmit a Mainframe file of specific payroll data biweekly to DHS. The file will be produced as a pipe delimited format and sent via File Transfer Protocol (FTP) until NFC implements SFTP in the future, at which time the method of transfer will be required to change.

1263604*

Agency-Specific

DOJ

DOJ Maximum Time-Off Award

System modifications will be made to an EmpowHR edit to accept DOJ's 120 hours for the Personnel Input and Edit System (PINE) error message, 866, Maximum Time Off Award NTE 120 Hours, for Document Type 060.

1271946

Agency-Specific

DHS/Customs and Border Protection (CBP)

Receive CBP retirement data files via CONNECT:Direct

System modifications will be made to allow CBP retirement data files to be received via CONNECT:Direct. NFC will create and transmit a file to CBP in order for data to be uploaded to their system as a retirement planning and calculator tool.

1315618

Agency-Specific

Architect of the Capitol (AOC)

Create New Grades for AOC Pay Plan UT

System modifications will be made to:

  • History Correction Update Processing System (HCUP)
  • Pay Process, Payroll/Personnel Inquiry System (PINQ)
  • webTA
  • Bi-Weekly Examination Analysis and Reporting System (BEAR)
  • TMGT 29, Pay Table Rates

To establish new grades for pay plan UT. The new grades will be 17, 18, 38, and 39. The new grades will have the same functionality and edits as the existing UT grades, 16 & 37, as well as, automate the process through NFC's Payroll/Personnel System.

1395717*

Agency-Specific

Department of the Treasury (DOT)/Office of the Comptroller of the Currency (OCC)

New Allowance Type - In Lieu of Payment

System modifications will be made to:

  • Payroll Computation System (PAYE) to include the new In Lieu of Stipend - Taxable Allowance Code 539 in Gross Pay. Add Transaction Code (TC) 53 with the Suffix of 9, to process taxable payment amount and apply to the Budget Object Class (BOC) of 1266 for processing and reporting a payment as a valid transaction, with the Allowance-Code 3 in gross pay.
  • Adjustment Processing System (ADJP) to ensure ADJP is modified to support corrected and revalidated T&As with this allowance.
  • Payroll Accounting System (PACS) Reconciliation report to include the In Lieu of Stipend - Taxable Allowance as a separate line item with the other allowances in the Paid Totals column of the PACS report and in the Allowances column of the Pay Transaction Amounts section in the PACS Reconciliation report.
  • TMGT Tables for the new allowance. The following tables will be updated:
    • Table 32 - Transaction Codes
    • Table 56 - Manual Transaction Codes
    • Table 64 - Sub-object Class Conversion
  • Statement of Earnings and Leave (EARN) to move 09 to the suffix, with TC 53 to call TMGT Table 32, Transaction Codes, to display the allowance as In Lieu of Stipend - Taxable, on the Earnings and Leave Statement (E&L).
  • W-2 Online Processing System (WTWO), to report this allowance as taxable income on the Internal Revenue Service (IRS) Form W-2, Wage and Tax Statement.

Note: In Lieu of Stipend - Taxable only applies to Agency AJ (OCC).

Note: Personnel Applications Systems Branch (PESB) will accept the new allowance type for processing and reporting an In Lieu of Stipend - Taxable payment as a valid transaction to be recorded each pay period.

1435169*

Agency-Specific

DOT / Office of Financial Research (OFR)

Ensure Correct 401(k) Contribution Rates for OFR Employees Enrolled in T5 Plan

System modifications will be made to the Payroll Applications Systems Branch (PASB) programs to change the Agency contribution rate from 7 percent to 4 percent per pay period, for OFR employees that are participating in non-Federal Thrift Savings Plan (TSP), Code T5.

1493361

Agency-Specific

Government Accounting Office (GAO)

Change Existing Validation Routine on Management Accounting Structure Codes System (MASC) for Congressional Executive Committee on the People’ s Republic of China, Agency CH (1339), and Commission on Security and Cooperation in Europe, Agency 85 (1339)

System modifications will be made to MASC for Agencies Commission on Security and Cooperation in Europe (CH) and Congressional Executive Committee on the People's Republic of China (85), allowing positions 1-3 to be alphanumeric; therefore, the code must be either 11 or 19 alphanumeric characters. This new validation routine should allow for the correct processing of the T&A.

1516070*

Agency-Specific

Consumer Finance Protection Bureau (CFPB)

CFPB Federal Reserve System (FRS) Thrift Plan Modify Option for Fixed Dollar Amounts

System modifications will be made to the non-Federal Thrift Plan for employees of the FRS Thrift Plan for CFPB. Employees may elect a fixed dollar amount deduction or variable percentage deduction for the following plans:

  • Pre-tax contribution (Plan Code 94)
  • Roth 401(k) contribution (Plan Code 95)
  • Other after-tax savings contribution (Plan Code 96)

1516596*

Agency-Specific

DOJ/Bureau of Prisons (BOP)

Change in Position Management System Online (PMSO) Edit for BOP

System modifications will be made to PMSO to allow system edits for employees who meet the criteria of Pay Plan GS-7, 9, or 11 with OCC, series 0603 or 0610 with duty station 29-740-077, to be paid from Special Salary Rate Table 0621 via Table 052, Remarks Code and Description, for DOJ/BOP. Additionally, replace special pay area 0582 with 0621 with an effective date of January 1, 2017.

1540959*

Agency-Specific

Department of Commerce (DOC)

Expand Record Layout and Increase the Amount field for DOC Agencies

System modifications will be made to the NFCPAII05 file to break payments into multiple records for amounts over $99,999.99 for PACS record 1 for the following Agencies:

  • 51, Office of the Secretary
  • 53, Bureau of Economic Analysis
  • 55, International Trade Administration
  • 57, National Institute of Standards and Technology
  • 59, Minority Business Development Agency
  • 61, National Telecommunications and Information Administration
  • 64, Office of the Inspector General
  • 65, Economics and Statistics Administration