Table Management System (TMGT)

Viewing a Record

The inquiry option is used to view active, history, or deleted records.

To View a Record:

1. Type I followed by the desired table number (i.e., I001) at the Enter Function and Table Number prompt on the Table Management System menu.
2. Press Enter. The applicable inquiry screen is displayed. For an example of a TMGT inquiry screen, see screen shown below.

   

To View the First Record of the Table:

1. Press Enter. The message Key Entered Was Not Found - Next Record Shown is displayed. The first record appears displaying the user ID and the last date the table was changed in the upper right corner. The record is identified as active, history, or deleted to the right of the screen when the applicable data is displayed.

To View a Specific Record in the Table:

1. Complete the key fields as indicated. Field instructions for key fields are located under the Updating Table section within the applicable table.
2. Press Enter. If the applicable record is found, the message Successful Inquiry is displayed. If the record is not found, the message Key Entered Was Not Found - Next Record Shown is displayed.

   Certain tables maintain a history file, which includes at least one inactive record.

To View a History Record (where available):

1. Press PF9. The history record is displayed, if available, with the message Successful Inquiry. The record is identified as history to the right of the Last-Eff-Date field information on the screen. If no history record exists, the message No History Record Available is displayed.
2. Press PF9 again to return to the active record.

   In tables with 10 or more records, you may perform an inquiry span to query a list of available records for a specific table.

To Perform an Inquiry Span (where available):

1. Press PF11. The inquiry span screen for that specific table is displayed showing a list of available records. The cursor is positioned at the Please Enter the Number of the Line for the Record Desired prompt.

   Note: Records cannot be updated (added, modified, deleted, or reactivated) in the inquiry function.

   

2. Press PF7 to scroll backward or PF8 to scroll forward through the inquiry span screens.
3. Type the line number when you locate the appropriate record.
4. Press Enter. The inquiry screen for the selected record is displayed.
5. Select one of the functions described below, after viewing a record.
   • Press PF6 to refresh the screen and modify another record.
   • Press PF2, PF3, or PF4 as applicable to perform another function.
   • Press the applicable program function key displayed at the bottom of the screen to navigate in the system.