HRPAY 20-05, Procedural Change in Requesting EmpowHR Table Updates

Published: September 23, 2020

Summary

This bulletin revises and standardizes the process for requesting table updates for EmpowHR. To accomplish more precise recordkeeping and help eliminate delays in the processing of your change requests, Agencies should follow the procedures described below.

Implementation

All EmpowhHR table updates, formerly sent to the Table Management System (TMGT) mailbox, should now be submitted via the ServiceNow self-service portal at ServiceNow portal for federated users for federated users and ServiceNow portal for nonfederated users  for non-federated users.

Exception to Using the Payroll Processing/TMGT Path in ServiceNow when Submitting EmpowHR Requests

If the EmpowHR table request requires more than 50 changes to TMGT Table 005, Agency Organizational Structure, please submit the request on an Excel spreadsheet and submit the request via email to NFC.GESDRequest@usda.gov. This information is loaded into the application via programmer intervention, because requests of 50 or more changes are processed systematically through a system batch process instead of manually by the Payroll Operations staff. Requests sent to NFC.GESDRequest@usda.gov must adhere to the proper file format (e.g., the required record layout).

Below is a list of EmpowHR tables uploaded in the weekly Sunday night process.

TMGT Table Number

TMGT Table Name

EmpowHR Related Table

001

PERSONNEL OFFICE ID

PERSONNEL OFFICE ID

002

ACCOUNTING STATION CODES

ACCOUNTING STATION CODES

010

UNION AND ASSOCIATION CODE ADDRESS

UNION TABLE

029

PAY TABLE RATE

LOCALITY TABLE

062

3 DIGIT NATURE OF ACTIONS

NOA TABLE

074

OFFICIAL POSITION TITLE

OFFICIAL POSITION TITLES

098

SALARY RANGES

SALARY LIMITS

106

FINANCIAL ORGANIZATION EFT ROUTING NUMBER FIELD

BANK TABLE

Note: This information must match the data currently displayed in TMGT Table 005 in order to be successfully updated in the EmpowHR application. Once the spreadsheet information has been loaded into the EmpowHR application, the Agency representative will be notified via email.

Note: If Agencies are submitting requests for changes to the Payroll/Personnel System (PPS) that also require updates to TMGT tables, these requests (e.g., requests that combine system change needsith TMGT table updates) must continue to be submitted via ServiceNow.

EmpowHR Table Updates

TMGT changes do not update immediately to EmpowHR related tables. Some tables are updated in the EmpowHR application with a system batch load that is completed on a weekly basis. All other tables are manually updated. Refer to the table above, which identifies the EmpowHR tables that are updated via a system batch load.

Note: The TMGT mailbox is no longer in use. TMGT requests should be submitted via the ServiceNow self-service portal.

Resources

View bulletin INQUIRY 20-05, Procedural Change in Requesting Table Management System (TMGT) Updates, for additional TMGT information.

The procedure manual for this application, which is available online at the NFC Web site, is being updated to include the information in this bulletin. To view this procedure, select HR and Payroll Clients from the MyNFC drop-down menu on the NFC Home page. At the HR and Payroll Clients page, select the Publications tab and select the applicable category to access the procedure manual within the category.

Inquiries

For questions about NFC processing, authorized Servicing Personnel Office representatives should contact the NFC Contact Center at 1-855-NFC-4GOV (1-855-632-4468) or via the customer service portal.