## Maintaining Airport Code

Step | Action
1. | Begin by navigating to the Maintain Airport Code page. Click the Links link.
2. | Click the Manage Travel Requests link.
3. | Click the Administration link.
4. | Click the Airport Code link.
5. | Use the Maintain Airport Code page to modify the airport options made available when creating a travel request.
6. | First, add a new airport. Click the New button.
7. | Airport Codes are used as unique keys in the TR_AIRPORT_CODE_Master table and built into the logic of Oracle TRM. Click in the Airport Code field.
8. | Airport Codes can be upper or lower case and up to 8 characters. Enter the desired information into the Airport Code field. Enter a valid value e.g. "OAK".
9. | Next, specify the full name of the airport. Airport codes appear on the Travel Request for Username (Request ID) page. Click in the Airport Name field.
10. | Enter the desired information into the Airport Name field. Enter a valid value e.g. "Oakland International Airport".
11. | Click in the City field.
12. | Enter the desired information into the City field. Enter a valid value e.g. "Oakland, California".
13. | Click in the Country Name field.
14. | Enter the desired information into the Country Name field. Enter a valid value e.g. "United States".
15. | Click in the Country Code field.
16. | Enter the desired information into the Country Code field. Enter a valid value e.g. "US".
17. | Use the Revert button to cancel adding a new airport code. This only works if the airport code has not been saved.
18. | Saving the airport code makes it available on the Travel Request for Username (Request ID) page. Click the Save button.
19. | The airport code OAK is now added.
20. | 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. Click in the City field.
21. | Enter the desired information into the City field. Enter a valid value e.g. "Oakland, CA".
22. | Click the Save button.
23. | 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. Click the row header.
24. | Click the Delete button.
25. | Click the Save button.
26. | The OAK airport code is now deleted.
27. | 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. Click the row header.
28. | Click the Active option.
29. | Check the Do not show this dialog again option if you do not want to see this message in the future.
30. | Confirm that you want to make the LHR airport code inactive. Click the Yes button.
31. | Click the Save button.
32. | The LHR airport code is now inactive.
33. | Next, query for all airports in India. Click the Query By Example button.
34. | You can query on any field by clicking into that field. Click in the Country Code field.
35. | You can query using whole or partial words. Enter the desired information into the Country Code field. Enter a valid value e.g. "India".
36. | Press the Enter key to initiate the query. Press [Enter].
37. | Only the airports in India appear.
38. | Clear the query field to display the full list of airport codes. In this example, the field has been cleared for you.
39. | The full list of airport code options is viewable again. The Query By Example button can be toggled on or off.
40. | You have completed the Maintaining Airport Code topic. End of Procedure.