INQUIRY 20-05, Procedural Change In Requesting Table Management System (TMGT) Updates
Published: September 23, 2020
Summary
This bulletin revises and standardizes the process for requesting table updates to TMGT. These requests should now be submitted via ServiceNow. 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 TMGT updates, formerly sent to the 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.
- TMGT update requests may only be submitted to the National Finance Center (NFC) by authorized Agency representatives whose names appear on TMGT Table 063, Department/Agency/Bureau/POI, Contact Type 03. Requests submitted by individuals not identified on TMGT Table 063, Department/Agency/Bureau/POI contact will not be processed and will be placed in a canceled status with detailed notes. ServiceNow will notify the sender via an automated email of the changed status. An authorized Agency representative will need to resubmit the request.
- TMGT update requests must contain all data necessary for a successful table update. NFC requires a screen print of the relevant table with the applicable data filled in for each table entry required to ensure accuracy. Many Agencies already adhere to this process and do so by capturing the screen, saving it in a Word format, and adding the variable data to the blank screen(s) captured.
- A completed form AD-952, Organizational Structure Codes TMGT – Table Number 5, can also be submitted for Agency Organizational Structure, TMGT Table 005 Agency Organizational Structure update requests, but this form must be submitted with the pre-populated TMGT Table 005, Batch Transactions screen print.
- TMGT update requests must include the applicable Department/Agency name and Agency code along with the Personnel Office Identifier (POI) and the authorized sender's name, email address, and telephone number.
- When a ServiceNow request is received, an automatic email is sent to the sender's email address confirming receipt of the request. NFC processes valid requests within 5 business days of receipt and TMGT updates apply to the system immediately upon the successful completion of the entry process. Once the submitter’s request has been processed and marked complete, ServiceNow will generate an automated email to notify the submitter of the changed status.
Exception to Using the Payroll Processing/TMGT Path in ServiceNow when Submitting TMGT Requests
There is an exception to using the Payroll Processing/TMGT path in ServiceNow when submitting TMGT requests. When a single change request requires 50 or more changes to any one of the four tables identified in the tables below, the Agency must submit the request to . The reason for this exception is that requests of 50 or more changes are processed systemically through a system batch process in lieu of being processed manually by the Payroll Operations staff. Requests sent via must adhere to the proper file format (e.g., the required record layout).
The tables identified below are processed systematically through a system batch process when a request includes 50 or more changes to a table.
Number |
Description |
|---|---|
003 |
T&A Contact Point Name and Address |
005 |
Agency Organizational Structure |
029 |
Pay Table Rates |
087 |
Travel Per Diem Rates |
Below is the format for Batch Transactions: Table 003, T&A Contact Point Name and Address.
Position |
Length |
Description |
|---|---|---|
001-003 |
(03) REQUIRED |
TABLE-NUMBER MUST BE 003 |
004-005 |
(02) REQUIRED |
AGENCY-CODE |
006-007 |
(02) REQUIRED |
CONTACT POINT STATE CODE |
008-011 |
(04) REQUIRED |
CONTACT POINT CITY CODE |
012-013 |
(02) REQUIRED |
CONTACT POINT UNIT CODE |
014-030 |
(17) |
FILLER-MUST BE SPACES |
(2)DATA: |
N/A |
N/A |
031-031 |
(01) REQUIRED |
TABLE RECORD STATUS MUST BE ZERO |
032-036 |
(5) REQUIRED |
TABLE ENTRY EDD DATE MUST BE JULIAN YYDD |
037-041 |
(05) REQUIRED |
TABLE ENTRY LAST EFF DATE MUST BE JULIAN YYDD. IF SPACES, WILL BE FILLED WITH 49365 |
042-050 |
(09) |
FILLER- MUST BE SPACES |
051-070 |
(20) |
CITY NAME |
071-072 |
(2) REQUIRED |
STATE ABBREVIATION |
073-077 |
(05) REQUIRED |
ZIP CODE 5 (MUST BE NUMERIC) |
078-081 |
(04) |
ZIP CODE 4 |
082-082 |
(01) |
FTS INDICATOR MUST BE 8 OR SPACE- IF 8, FTS PHONE NUMBER MUST BE GREATER THAN ZERO |
083-092 |
(10) REQUIRED |
FTS PHONE NUMBER (AREA-CODE, EXCHANGE, NUMBER-NO DASHES) |
093-102 |
(10) REQUIRED |
PHONE NUMBER (AREA CODE), EXCHANGE, NUMBER-NO DASHES |
103-137 |
(35) REQUIRED |
ADDRESS LINE 1 |
138--172 |
(35) REQUIRED |
ADDRESS LINE 2 |
173-207 |
(35) |
FILLER-MUST BE SPACES |
208-242 |
(35) |
REMARKS 1 |
243-277 |
(35) |
REMARKS 2 |
278-279 |
(02) REQUIRED |
DEPARTMENT |
280-300 |
(21) |
FILLER-MUST BE SPACES |
301-301 |
(01) REQUIRED |
ACTION CODE-MUST BE A, D, |
Below is the format for Batch Transactions: Table 005, Agency Organizational Structure
Position |
Length |
Description |
|---|---|---|
001-003 |
(03) REQUIRED |
TABLE NUMBER MUST BE 005 |
004-005 |
(02) REQUIRED |
AGENCY-CODE |
006-021 |
(16) REQUIRED |
ORG-STRUCTURE CODE |
(1) TABLE-KEY-005 |
N/A |
N/A |
022-031 |
(10) |
FILLER-MUST BE SPACES |
(2) DATA |
N/A |
N/A |
032-036 |
(05) REQUIRED |
BEGINNING EFF DATE IN RECORD MUST BE JULIANN TTDDD |
037-041 |
(05) REQUIRED |
ENDING EFF DATE IN RECORD MUST BE JULIAN YYDDD. IF SPACES, WILL BE FILLED WITH 49365 |
042-050 |
(09) |
FILLER-MUST BE SPACES |
051-056 |
(06) |
AGENCY-ABBR. (UP TO SIX ALPHA CHARACTERS OR SPACES) (THIS IS FOR EACH RECORD ADDED TO THE FILE) (IF ORG-STRUCTURE-CODE-IN COLS 06-21 IS ALL ZEROS THEN ENTER AGENCY-ABBR) (UP TO SIX CHARACTERS) IF ORG-STRUCTURE-CODE IN COLS 06-21 IS GREATER THAN ZEROS THAN AGENCY-ABBR FILED MUST BE SPACES. |
057-086 |
(30) REQUIRED |
ORG-STRUCTURE-SHORT-NAME |
087-161 |
(75) REQUIRED |
ORG-STRUCTURE-NAME-1 |
162-237 |
(75) OPTIONAL |
ORG-STRUCTURE--NAME-2 |
237-238 |
(02) |
FILLER-MUST BE SPACES |
239-239 |
(01) OPTIONAL |
EMPLOYEE-EXPRESS INDICATOR |
240-240 |
(01) |
CPAS INDICATOR-DEFAULT IS "N," "Y," IF THE AGENCY HAS BEEN CERTIFIED (CERTIFIED PERFORMANCE APPRAISAL SYSTEM) |
241-300 |
(60) |
FILLER-MUST BE SPACES |
301-301 |
(01) REQUIRED |
ACTION CODE-MUST BE A, D, M OR R. A=ADD, D=DELETE, M=MODIFY, R=REACTIVATE |
Below is the format for Batch Transactions: Table 029, Pay Table Rates
Position |
Length |
Description |
|---|---|---|
001-003 |
(03) REQUIRED |
TABLE NUMBER MUST BE 029 |
004-007 |
(04) REQUIRED |
PAY-AREA |
008-009 |
(02) REQUIRED |
PAY-PLAN |
010-011 |
(02) REQUIRED |
PAY-GRADE |
012-030 |
(19) |
FILLER-MUST BE SPACES |
(2)DATA: |
N/A |
N/A |
031-031 |
(01) REQUIRED |
TABLE RECORD STATUS MUST BE ZERO |
032-036 |
(05) REQUIRED |
TABLE ENTRY EFF DATE MUST BE JULIAN YYDDD (THE BEGINNING EFFECTIVE DATE) IS USUALLY BEGINNING OF A PAY PERIOD |
037-041 |
(05) REQUIRED |
TABLE ENTRY END EFF DATE MUST BE JULIAN YYDD (THE ENDING EFFECTIVE DATE SHOULD BE 49365) |
042-050 |
(09) |
FILLER-MUST BE SPACES |
051-290 |
(240) |
PAY-AMOUNTS OCCURS 20 TIMES (EACH OCCURANCE IS A STEP) (EXAMPLE ANNUAL SALARY-NO-HOURLY-RATE=0552321000000 OR HOURLY RATE-NO ANNUAL SALARY=00000000247) THE CHARACTER "V" IN THE AMOUNT IS AN ASSUMED DECIMAL POINT ANNUAL PAY 99999V99 (RIGHT JUSTIFY ZERO FILL) FILLED IN ANNUAL SALARY WILL CALCULATE HOURLY RATE AND THE HOURLY RATE MUST BE FILLED IN WITH ZEROS |
291-300 |
(10) |
FILLER-MUST BE SPACES |
301-301 |
(01) REQUIRED |
ACTION CODE-MUST BE A, D, |
Below is the format for Batch Transactions: Table 087, Travel Per Diem Rates
Position |
Length |
Description |
|---|---|---|
001-003 |
(03) REQUIRED |
TABLE-NUMBER MUST BE 087 |
004-023 |
(20) REQUIRED |
CITY-TOWN |
024-025 |
(02) REQUIRED |
STATE |
026-027 |
(02) OPTIONAL |
AGENCY-CODE |
028-030 |
(03) |
FILLER-MUST BE SPACES |
(2) DATA: |
N/A |
N/A |
031-031 |
(01) REQUIRED |
TABLE RECORD STATUS MUST BE ZERO |
032-036 |
(05) REQUIRED |
TABLE ENTRY END EFF DATE (YYDDD) JULIAN DATE |
037-041 |
(05) REQUIRED |
TABLE ENTRY END EFF DATE (YYDDD) JULIAN DATE |
042-050 |
(09) REQUIRED |
FILLER-MUST BE SPACES |
051-057 |
(07) REQUIRED |
SEASONAL LODGING RATE 1(99999V99) |
058-064 |
(07) REQUIRED |
SEASONAL MEAL RATE (99999V99) |
065-071 |
(07) REQUIRED |
SEASONAL RATE 1 (99999V99) |
072-075 |
(04) REQUIRED |
DATE-THRU SEASONAL RATE 1 (MMDD) |
076-079 |
(04) REQUIRED |
DATE-THRU SEASONAL RATE 1 (MMDD) |
080-086 |
(07) OPTIONAL |
SEASONAL LODGING RATE 2 (99999V99) |
087-093 |
(07) OPTIONAL |
SEASONAL MEAL RATE 2 (99999V99) |
094-100 |
(07) OPTIONAL |
SEASONAL RATE 2 (99999V99) |
101-104 |
(04) OPTIONAL |
DATE-FROM SEASONAL RATE 2 (MMDD) |
105-108 |
(04) OPTIONAL |
DATE-THRU SEASONAL RATE 2 (MMDD) |
109-115 |
(07) OPTIONAL |
SEASONAL LODGING RATE 3 (99999V99) |
116-122 |
(07) OPTIONAL |
SEASONAL MEAL RATE (99999V99) |
123-129 |
(07) OPTIONAL |
SEASONAL RATE 3 (99999V99) |
130-133 |
(04) OPTIONAL |
DATE-FROM SEASONAL RATE 3 (MMDD) |
134-137 |
(04) OPTIONAL |
DATE-THRU SEASONAL RATE 3 (MMDD) |
138-144 |
(07) OPTIONAL |
SEASONAL LODGING RATE 4 (99999V99) |
145-151 |
(07) OPTIONAL |
SEASONAL MEAL RATE 4 (99999V99) |
152-158 |
(07) OPTIONAL |
SEASONAL RATE 4 (99999V99) |
159-162 |
(04) OPTIONAL |
DATE-FROM SEASONAL RATE 4 (MMDD) |
(2) DATA: |
N/A |
N/A |
163-166 |
(04) OPTIONAL |
DATE-THRU-SEASONAL RATE 4 (MMDD) |
167-173 |
(07) OPTIONAL |
SEASONAL LODGING RATE 5 (99999V99) |
174-180 |
(07) OPTIONAL |
SEASONAL MEAL RATE 5 (99999V99) |
181-187 |
(07) OPTIONAL |
SEASONAL RATE 5 (99999V99) |
188-191 |
(04) OPTIONAL |
DATE-THRU SEASONAL RATE 5 (MMDD) |
192-195 |
(04) OPTIONAL |
DATE-THRU SEASONAL RATE 5 (MMDD) |
196-202 |
(07) OPTIONAL |
SEASONAL LODGING RATE 6 (99999V99) |
203-209 |
(07) OPTIONAL |
SEASONAL MEAL RATE 6 (99999V99) |
210-216 |
(07) OPTIONAL |
SEASONAL RATE 6 (99999V99) |
217-220 |
(04) OPTIONA |
DATE-FROM SEASONAL RATE 6 (MMDD) |
221-224 |
(04) OPTIONAL |
DATE-FROM SEASONAL RATE 6 (MMDD) |
215-231 |
(04) OPTIONAL |
DATE-FROM SEASONAL RATE 6 (MMDD) |
232-238 |
(07) OPTIONAL |
SEASONAL MEAL RATE 7 (99999V99) |
239-245 |
(04) OPTIONAL |
SEASONAL RATE 7 (99999V99) |
246-249 |
(04) OPTIONAL |
DATE-FROM SEASONAL RATE 7 (MMDD) |
250-253 |
(04) OPTIONAL |
DATE-THRU SEASONAL RATE 7 (MMDD) |
254-260 |
(04) OPTIONAL |
SEASONAL LODGING RATE 8 (99999V99) |
261-267 |
(07) OPTIONAL |
SEASONAL MEAL RATE 8 (99999V99) |
268-274 |
(07) OPTIONAL |
SEASONAL RATE 8 (99999V99) |
275-278 |
(04) OPTIONAL |
DATE-FROM SEASONAL RATE 8 (MMDD) |
279-282 |
(04) OPTIONAL |
DATE-THRU SEASONAL RATE 8 (MMDD) |
283-300 |
(18) REQUIRED |
FILLER-MUST BE SPACES |
301-301 |
(01) REQUIRED |
ACTION CODE-MUST BE A, D, M, OR R. A=ADD, D=DELETE, M=MODIFY, R=REACTIVATE |
Agency Update Access to TMGT
NFC maintains and updates all tables within TMGT; however, Agencies can request and be granted access to update specific TMGT tables. TMGT tables that users may update are:
- TMGT Table 001, Personnel Office Identifier Name and Address
- TMGT Table 005, Agency Organizational Structure
- TMGT Table 022, Payroll/Personnel Document Report
- TMGT Table 063, Department/Agency/Bureau Contact
- TMGT Table 102, Pay/Pers Download Table
- TMGT Table 103, TMGT Download Table
- TMGT Table 105, Statement Messages
- TMGT Table 113, Notice of Overpayment of Salary and Demand for Payment
To obtain access to update TMGT tables, Agencies must request access to these tables through their Agency's Security Officer.
Resources
View bulletin HRPAY 20-05, Procedural Change in Requesting EmpowHR Table Updates, for information on requesting table updates in EmpowHR.
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 from the drop-down menu on the NFC Home page. At the page, select the 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.