Table 103, TMGT Download Table

TMGT Download Table is Table 103 on the Table Management System (TMGT) menu. Agencies that use the alternative Front-End System Interface (FESI) can select from Table 103 which TMGT tables they want to download to their FESI. The TMGT table data downloaded to the Agency’s FESI system is used to validate or edit data on their front-end system.

TMGT Download Table (1), includes record specifications such as the frequency of the download, destination, routing information, and the expiration date. Additionally, TMGT Download Table (1) is used to add and/or modify the requests for downloading data files. TMGT Download Table (2) Table Elements, includes those TMGT tables that are available for downloading table data to the FESI.

Note: Agencies can query and update Table 103 data, view documentation data, and generate reports. The data maintained in Table 103 is contained on two screens. Press PF10, on the TMGT Download Table (1) inquiry screen to view TMGT data that can be downloaded using TMGT Download Table (1) Table Elements inquiry screen. To return to the TMGT Download Table (1) inquiry screen, press PF7. To view the next record, press PF8.

Updating Table 103

Table 103, TMGT Download Table, update screen shown below allows authorized users to add, modify, delete, or reactivate a record.

Table 103, TMGT Download Table (1) Update Screen

For update authority to FESI, contact your Agency Security Officer (ASO).

Note: To receive transmitted TMGT data using Table 103, you must provide the National Finance Center (NFC) with a job control language (JCL). A JCL is a group of specialized computer language statements designed to give instructions to a computer, so the computer will perform a desired action. In this case, the desired action would be the successful transmission of user data from the NFC Mainframe computer to a predetermined location at the user’s site.

At the TMGT Download Table (1) update screen, complete the fields as follows:

Note: You must complete and process Download Table (1) before you can access Download Table (2).

History Last-Eff-Date Range

Expiration-Date

Adding Table Elements Data to Table 103

The TMGT Download Table (1) screen must be completed and processed, before the TMGT Download Table (2) Table Elements screen can be accessed. Press PF8 on the TMGT Download Table (1) screen to access the TMGT Download Table (2) Table Elements screen shown below to include data elements from this screen. The key fields are system generated from Download Table (1).

Note: Both the Table Number and Scope fields must be completed to obtain data from the following tables:
Table 001, Personnel Office Identifier Name and Address
Table 002, Accounting Station Name and Address
Table 005, Agency Organizational Structure
Table 010, Union and Association Code Address
Table 016, Geographical Location Codes With Names
Table 029, Pay Table Rates

Table 103, TMGT Download Table (2) Table Elements Update Screen