Querying and Viewing Lookups

To view a lookup, or reference codelist, query for it as follows. Further information is available in the online help.

See Modifiable Lookups for a list of Oracle Life Sciences Data Hub lookups you can modify.

1. Press the F11 key. The window enters Query mode and changes the background color of some of the fields.
2. In the Type field, enter the name of the lookup you want to see. You can enter part of the name and use the % wildcard. You can enter cdr% to retrieve all Oracle LSH lookups or dme% to retrieve all DMW lookups—then use the down arrow on the keyboard to view them in alphabetical order.

   Note:

   During its initial development, Oracle LSH was known as CDR. Therefore many internal names contain the string cdr. Please think of CDR as a synonym for LSH.

   Please think of DME as a synonym for DMW for the same reason.

3. Press Ctrl+F11 to enter the query. The system displays the lookup and all its current values, including predefined values and those your company has previously added (if any). If your query retrieved more than one lookup, use the Down arrow on your keyboard to view each lookup in turn.

The following information is displayed for each value:

• Code is the internal name for the value.
• Meaning is the text that appears on the user interface, exactly as it appears here.
• Description is an explanation of the value.
• Tag is an optional descriptor.
• Effective Dates. The From column contains the date the value was created in your location. The To column may contain a date; if so, this is the date on which the value became or will become unavailable for use. If there is not a date in either column, the value is in effect.