- Maintaining Lookup Type Codes
- Maintaining Lookup Type Codes
- Begin by navigating to the
- Maintain Lookup Types
- page.
- You have completed the
- Maintaining Lookup Type Codes
- topic.
- 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
- .
- First, add a lookup type code.
- Lookup Codes
- are unique keys in the data tables and built into the logic of Oracle EFM.
- A
- Lookup Code
- can be upper or lower case.
- Next, specify a short name. The name values appear when an eForm approval request is created or reviewed.
- Use the
- Description
- field to add an optional description.
- Saving the lookup type code makes it available when you create eForm approval requests.
- Next, modify the
- Work in progress
- lookup type code by editing the description.
- You can reverse any modifications to a single selected row using the
- Undo
- button. To save the modification, you would click
- Save
- instead.
- Confirm that you want to delete the
- Work in progress
- lookup type code.
- 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.
- Use the
- Maintain Lookup Types
- page to modify the lookup type codes made available when creating an eForm approval request.
- The lookup type code
- Work in progress
- is now added.
- 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
- .
- The lookup type code
- Work in progress
- is now deleted.
- The lookup type code
- Under Review
- is now inactive.
- Original Path
- Adding a lookup type code
- Modifying a lookup type code
- Deleting a lookup type code
- Links
- Manage eForms
- Maintain Lookup Type Codes
- Select a Lookup Type
- Form Status
- Add
- Lookup Code
- Lookup Code
- Display Value
- Display Value
- Description
- Description
- Save
- Description
- Description
- Undo
- Delete
- Yes
- Save
- Active
- Save
- Lookup type codes specify values used in eForm approval requests. Oracle eForms Management ships with seeded values for lookup type codes.
- The seeded values are:
- Reviewer Routing Pattern
- Serial
- Parallel
- Process Role
- Approver
- Reviewer
- Document Class
- Main
- Supporting
- User Type
- User
- Role
- Group
- Completion Status
- Approved
- Rejected
- Form Status
- Submitted
- Re-submitted
- Closed
- Withdrawn
- Under Review
- Approved
- Rejected
- Form Tag
- Citizen
- Patient
- Staff
- Business
- Contractor
- Veteran
- Active
- Resubmission
- Preferred
- Single
- Joint
- Public
- Private
- Level 1
- Level 2
- Level 3
- Reject Reason
- Funding Expired
- Inaccurate
- Incomplete
- Late
- No Supporting Documents
- Resource Unavailable
- Others
- You can add additional lookup type codes to meet your organization's needs.
- In this topic, you will modify lookup type code options.