Maintaining Airport Code
Maintaining Airport Code
_NR_Est Tim:
_NR_Test Set:
Maintaining Airport Code
Test Results
Maintaining Airport Code

Begin by navigating to the Maintain Airport Code page.

First, add a new airport.

Airport Codes are used as unique keys in the TR_AIRPORT_CODE_Master table and built into the logic of Oracle TRM.

Airport Codes can be upper or lower case and up to 8 characters.

Next, specify the full name of the airport. Airport codes appear on the Travel Request for Username (Request ID) page.

Saving the airport code makes it available on the Travel Request for Username (Request ID) page.

Next, modify the description for the OAK airport code.

By default, the first row is automatically selected. When modifying or deleting an airport code, ensure the row you want to take action on is selected. You can click anywhere in the row to select it.

There are two types of delete, a hard delete and soft delete.

A hard delete removes the airport code from the database table, provided it is not used in a travel request.

First, perform a hard delete on the airport code OAK.

Confirm that you want to make the LHR airport code inactive.

Next, query for all airports in India.

You can query on any field by clicking into that field.

You can query using whole or partial words.

Press the Enter key to initiate the query.

Use the Maintain Airport Code page to modify the airport options made available when creating a travel request.

Use the Revert button to cancel adding a new airport code. This only works if the airport code has not been saved.

The airport code OAK is now added.

The OAK airport code is now deleted.

A soft delete is used for inactivating an airport code already used in travel requests. Inactivated airport codes are not displayed as options on the Travel Request for Username (Request ID) page.

Next, perform a soft delete on the LHR airport code.

Check the Do not show this dialog again option if you do not want to see this message in the future.

The LHR airport code is now inactive.

Only the airports in India appear.

The full list of airport code options is viewable again.

The Query By Example button can be toggled on or off.

Clear the query field to display the full list of airport codes. In this example, the field has been cleared for you.

Maintaining Airport Code

You have completed the Maintaining Airport Code topic.

Click the Links link.
Click the New button.
Click in the Airport Code field.
Enter the desired information into the Airport Code field. Enter
a valid value
e.g.
"OAK"
.
Click in the Airport Name field.
Enter the desired information into the Airport Name field. Enter
a valid value
e.g.
"Oakland International Airport"
.
Click in the City field.
Enter the desired information into the City field. Enter
a valid value
e.g.
"Oakland, California"
.
Click in the Country Name field.
Enter the desired information into the Country Name field. Enter
a valid value
e.g.
"United States"
.
Click in the Country Code field.
Enter the desired information into the Country Code field. Enter
a valid value
e.g.
"US"
.
Click the Save button.
Click in the City field.
Enter the desired information into the City field. Enter
a valid value
e.g.
"Oakland, CA"
.
Click the Save button.
Click the row header.
Click the Delete button.
Click the Save button.
Click the Active option.
Click the Yes button.
Click the Save button.
Click the Query By Example button.
Click in the Country Code field.
Enter the desired information into the Country Code field. Enter
a valid value
e.g.
"India"
.
Press [Enter].
Click the Airport Code link.
Click the Administration link.
Click the row header.
Click the Manage Travel Requests link.
Frame ID:

| ; |  |

Frame ID: