EmpowHR Setup Tables (HD)

EmpowHR is a relational database. A relational database is a series of tables linked by key fields. The advantage of a relational database is that data is entered into a table once, and can be accessed and reassembled many different ways without having to reenter or reorganize tables. This saves time and decreases the potential for errors made during data entry.

Tables are the foundation of the database. Each table is composed of columns and rows like a spreadsheet. The columns in each table are the records and contain the entries that make up each field.

Each table has a unique name and is linked by key fields to create the relational database. Foundation tables are updated by the system administrator whenever actions are processed or records are changed/created in the database.

Updates to EmpowHR Tables

All EmpowHR table update requests must be submitted via email to NFC.TMGT@nfc.usda.gov. The receipt of an EmpowHR request by a method other than the official email address or from a user that has not been identified as an authorized Agency representative on Table Management System (TMGT) Table 63, Department/Agency/Bureau Contact, Contact Type 03, will be returned to the requester. To aid in the verification of authorized users and if we need to contact you regarding your request, please ensure that each request includes:

• Department
• Agency
• Personnel Office Identifier (POI)
• Authorized sender's name, email address, and telephone 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. The table below also lists these tables. If you have updated one of these tables, no further action is needed. If you have updated any table that is not identified on this table, please forward that information to nfc.tmgt@nfc.usda.gov. This is a critical process that must be completed since tables that are not automatically loaded into EmpowHR are processed manually by the National Finance Center (NFC) Contact Center staff members.

The requests that are sent to the NFC.TMGT@nfc.usda.gov email address are compiled daily in the order received, and the sender will be notified by email when the update is completed.

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 NFC.TMGT@nfc.usda.gov email request and must contain the following information:

• Entire organizational structure code
• Effective dates

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