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 |