Front-End System Interface (FESI)

TMGT Download Tables

TMGT Tables 100 through 103 were created specifically to accommodate Agencies using front-end systems. A brief description of each table is provided below. A detailed description can be found in the TMGT procedure.

TMGT Table 103, TMGT Download Table

Table 103, TMGT Download Table, allows Agencies to select a variety of TMGT tables to download into the front-end systems to edit and validate transactions. The following tables are available for downloading through Table 103 instead of downloading each table individually through FOCUS.

• 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 018, Occupational Series Alpha Description
• Table 019, Functional Classification Description
• Table 025, AD-350 (Personnel Block and Description)
• Table 029, Pay Table Rates
• Table 036, School Identification
• Table 052, Remarks Code and Descriptions
• Table 055, Minimum and Maximum Salaries
• Table 061, Nature of Action Conversion
• Table 062, 3 Digit Nature of Action
• Table 074, Official Position Title
• Table 076, Working Position Title
• Table 087, Travel Per Diem Rates
• Table 091, OPM NOA Legal Authorities
• Table 100, PACT Data Element Description
• Table 101, PACT Screen Elements
• Table 102, Payroll/Personnel Download Profile Screen
• Table 103, TMGT Download Table (1)

To download a table from TMGT Table 103, request update authority through your Agency security officer. After a table is downloaded, it can be modified based on the Agency’s processing needs. See Title I, Chapter 2, Table Management System, for more information about TMGT.

TMGT Table 100, PACT Data Element Description

Table 100 can be used as a guide when designing a front-end system. Table 100 includes the CPDF and non-CPDF data elements and specifications. Front-end systems should include all personnel data elements that are included in Personnel Action Processing System (PACT) or ( EPIC) and must include all CPDF data elements. Agency front-end systems must be in conformance with the specifications outlined in Table 100 for successful interface and successful processing.

TMGT Table 101, PACT Screen Elements

Table 101, PACT Screen Elements, includes the required, system-generated, and optional fields and associated remarks codes for each NOAC. This table includes OPM's remarks codes only; it does not include Agency-specific remarks codes.

TMGT Table 102, PAY/PERS Download Table Profile Screen

Periodically, Agencies can request a profile of the database to compare the front-end system database to the PPS database to ensure the two are synchronized. Table 102 download contains selected payroll and personnel data elements from the PPS database. Agencies may initiate a download file that contains all of the selected database elements or only those that have changed since the last download. Changed records are identified by updates to specific elements in the PPS database.

Note: If more than one personnel action is transmitted for an employee, only the last one processed appears on the download file. If the last action is a payroll document or a cash award, the data is shown in the Last Action field.

Security Access

To receive transmitted personnel data using TMGT Table 102, you must obtain security access to the table. When requesting access, ask for the FESI Table 102 security profile. Be sure to include update access.

You must also have access to PMSO and payroll/personnel data that will be transmitted to you. Request read and update access to the PMSO data. You must request read-only access to PMSO even if you currently have update access.