Maintaining Lookup Type Codes
Maintaining Lookup Type Codes
_NR_Est Tim:
_NR_Test Set:
Maintaining Lookup Type Codes
Test Results
Maintaining Lookup Type Codes

Begin by navigating to the Maintain Lookup Type Codes page.

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.

First, add a lookup code.

Lookup Codes are unique keys in the data tables and built into the logic of Oracle MDO.

A Lookup Code can be upper or lower case.

Use the Description field to add an optional description.

Saving the lookup type code makes it available when you create areas of interest.

Next, modify the Mall lookup type code by editing the description.

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.

Confirm that you want to delete the Mall lookup code.

Next, perform a soft delete on the STRT code.

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.

Use the Maintain Lookup Type Codes page to modify the lookup type codes made available while creating areas of interest.

Next, specify a short meaning value. Meaning values appear when an area of interest is created.

The lookup type code MALL is now added.

The Mall lookup type code is now modified.

The lookup type code Mall is now deleted.

The lookup type code STRT is now inactive.

Maintaining Lookup Type Codes

You have completed the Maintaining Lookup Type Codes topic.

Click the Maintain Lookup Type Codes link.
Click the Select a Lookup Type list.
Click the Area Type list item.
Click the Add button.
Click in the LookupCode field.
Enter the desired information into the LookupCode field. Enter
a valid value
e.g.
"MALL"
.
Enter the desired information into the Meaning field. Enter
a valid value
e.g.
"Mall"
.
Click in the Description field.
Enter the desired information into the Description field. Enter
a valid value
e.g.
"Mall Area"
.
Click the Save button.
Click in the Description field.
Enter the desired information into the Description field. Enter
a valid value
e.g.
"The lookup code entry for area type Mall."
.
Click the Save button.
Click an entry in the row.
Click the Delete button.
Click the Yes button.
Click the Save button.
Click an entry in the row.
Click the ActiveFlag option.
Click the Save button.
Click in the Meaning field.
Frame ID:

| ; |  |

Frame ID: