## Maintaining Lookup Type Codes

Step | Action
1. | Begin by navigating to the Maintain Lookup Types page. Click the Links link.
2. | Click the Manage eForms link.
3. | Click the Maintain Lookup Type Codes link.
4. | Use the Maintain Lookup Types page to modify the lookup type codes made available when creating an eForm approval request.
5. | Click the Select a Lookup Type list.
6. | These are the lookup types shipped with Oracle EFM. You modify all lookup types using the same steps. In this topic, you will modify the Form Status. Click the Form Status list item.
7. | First, add a lookup type code. Click the Add button.
8. | Lookup Codes are unique keys in the data tables and built into the logic of Oracle EFM. Click in the Lookup Code field.
9. | A Lookup Code can be upper or lower case. Enter the desired information into the Lookup Code field. Enter a valid value e.g. "WORK IN PROGRESS".
10. | Next, specify a short name. The name values appear when an eForm approval request is created or reviewed. Click in the Display Value field.
11. | Enter the desired information into the Display Value field. Enter a valid value e.g. "Work in progress".
12. | Use the Description field to add an optional description. Click in the Description field.
13. | Enter the desired information into the Description field. Enter a valid value e.g. "The lookup code for entry for the Form Status".
14. | Saving the lookup type code makes it available when you create eForm approval requests. Click the Save button.
15. | The lookup type code Work in progress is now added.
16. | Next, modify the Work in progress lookup type code by editing the description. Click in the Description field.
17. | Enter the desired information into the Description field. Enter a valid value e.g. "WIP".
18. | You can reverse any modifications to a single selected row using the Undo button. To save the modification, you would click Save instead. Click the Undo button.
19. | 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 eForm approval request. First, perform a hard delete on the code Work in progress. Click an entry in the row.
20. | Click the Delete button.
21. | Confirm that you want to delete the Work in progress lookup type code. Click the Yes button.
22. | Click the Save button.
23. | The lookup type code Work in progress is now deleted.
24. | A soft delete inactivates a lookup type code already used in eForm approval requests. Inactivated codes are not displayed as options for creating or reviewing eForm approval requests. Next, perform a soft delete on the Under Review code. Click an entry in the row.
25. | Click the Active option.
26. | Click the Save button.
27. | The lookup type code Under Review is now inactive.
28. | You have completed the Maintaining Lookup Type Codes topic. End of Procedure.