## Maintaining Lookup Type Codes

Step | Action
1. | Begin by navigating to the Maintain Lookup Type Codes page. Click the Maintain Lookup Type Codes link.
2. | Use the Maintain Lookup Type Codes page to modify the lookup type codes made available while creating areas of interest.
3. | Click the Select a Lookup Type list.
4. | These are the lookup types shipped with Oracle MDO. You modify all lookup types using the same steps. In this topic, you will modify the Area Type. Click the Area Type list item.
5. | First, add a lookup code. Click the Add button.
6. | Lookup Codes are unique keys in the data tables and built into the logic of Oracle MDO. Click in the LookupCode field.
7. | A Lookup Code can be upper or lower case. Enter the desired information into the LookupCode field. Enter a valid value e.g. "MALL".
8. | Next, specify a short meaning value. Meaning values appear when an area of interest is created. Click in the Meaning field.
9. | Enter the desired information into the Meaning field. Enter a valid value e.g. "Mall".
10. | Use the Description field to add an optional description. Click in the Description field.
11. | Enter the desired information into the Description field. Enter a valid value e.g. "Mall Area".
12. | Saving the lookup type code makes it available when you create areas of interest. Click the Save button.
13. | The lookup type code MALL is now added.
14. | Next, modify the Mall lookup type code by editing the description. Click in the Description field.
15. | Enter the desired information into the Description field. Enter a valid value e.g. "The lookup code entry for area type Mall.".
16. | Click the Save button.
17. | The Mall lookup type code is now modified.
18. | There are two types of delete, a hard delete and soft delete. A hard delete removes the lookup type code from the database table, provided it is not used in an area of interest. First, perform a hard delete on the code Mall. Click an entry in the row.
19. | Click the Delete button.
20. | Confirm that you want to delete the Mall lookup code. Click the Yes button.
21. | Click the Save button.
22. | The lookup type code Mall is now deleted.
23. | Next, perform a soft delete on the STRT code. Click an entry in the row.
24. | A soft delete inactivates a lookup type code already used in an area of interest. Inactivated codes are not displayed as options when creating areas of interest. Click the ActiveFlag option.
25. | Click the Save button.
26. | The lookup type code STRT is now inactive.
27. | You have completed the Maintaining Lookup Type Codes topic. End of Procedure.