INQUIRY 14-07, Attachment 2

All EmpowHR table update requests must be submitted to the newly established e-mail address. The receipt of an EmpowHR request by a method other than the official e-mail address or from a user that has not identified as an authorized agency representative on TMGT Table 63, will be returned to the requestor. To aid in the verification of authorized users and in case we need to contact you regarding your request, please ensure that each request includes your department/agency name, your name, e-mail address and phone number.

If you have user access to update TMGT, please review the EmpowHR table guide, EmpowHR TBL to determine if any more action on your behalf is required. This guide identifies which tables are updated in the weekly Sunday night process to EmpowHR. If you have updated one of these tables, no further action is needed. If you have updated any tables that are not identified in this chart, please forward that information to the EmpowHR Help Desk at nfcempowhr@usda.gov. This is a critical process that must be completed since tables that are not automatically loaded into the EmpowHR application are processed manually by the EmpowHR Help Desk staff members.

The requests that are sent to the EmpowHR mailbox are compiled daily in the order received and the sender will be notified by e-mail from the EmpowHR Help Desk when the update has been completed within the EmpowHR application.

If the request requires more than 50 changes to Table 005, Organizational Structure Levels/Tree Manager, please submit the request on an excel spreadsheet since this information is loaded into the application via programmer intervention. The spreadsheet should be attached to the e-mail request and must contain the following information: entire organizational structure code and the effective dates. NOTE: This information must match the data that is currently displayed in TMGT 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 by e-mail.

EMPOWHR Tables Updated 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 RATES

LOCALITY TABLE

062

3 DIGIT NATURE OF ACTIONS

NOA TABLE

074

OFFICIAL POSITION TITLE

OFFICIAL POSITION TITLES

076

WORKING POSITION TITLE

ORGANIZATION POSITION TITLE USF

098

SALARY RANGES

SALARY LIMITS

106

FINANCIAL ORGANIZATION EFT ROUTING NUMBER FIELD

BANK TABLE