NAPIS® Utilities: Lookup Tables

From the NAPIS main menu select Utilities | Lookup Tables to open the Lookup Table Maintenance dialog.

Extensive use of Lookup Tables are made throughout NAPIS to support standardized data-entry. On the various NAPIS forms, data value choices are presented to the user via pull-down lists and list-boxes.

To customize data choices, select the Table Name from the pull-down list to open a table and display its values. Use the '+' and '-' buttons to insert or delete records, respectively. A code may be required to store the data value properly in the database table; in the example below, primary and secondary color names are stored with color codes used by the U.S. National Cancer Institute. NAPIS can export an NCI-compliant database file using techniques like this. Click here for information on Record Type Usage.

Lookup Table Maintenance To the top

Lookup Table Description
AB_LOOK Lookup table for ANALYTICAL_BACKUP table.
AC_LOOK Lookup table for ANALYTICAL and PLATE_DETAIL tables.
AM_LOOK Lookup table for ANALYTICAL_MATCH table.
AQ_LOOK Lookup table for ANALYTICAL table.
ASPECT Lookup table for SITE_COMMON table.
CHEM_LOOK Lookup table for CHEMISTRY_LIBRARY table.
G_ADMN Lookup table for SITE_COMMON table.
G_COUNTRY Lookup table for SITE_COMMON table.
G_ENTITY Lookup table for SITE_COMMON table.
G_LOCALE Lookup table for SITE_COMMON table.
G_REGION Lookup table for SITE_COMMON table.
M_FOME Lookup table for N_MICRO_SOURCE table.
M_HAZARD Lookup table for N_COLLECT_MICRO table.
M_METHOD Lookup table for N_MICRO_SOURCE table.
M_QUALITY Lookup table for N_MICRO_SOURCE table.
M_SOIL_CLASS Lookup table for N_MICRO_SOURCE table.
M_TREATMENT Lookup table for N_COLLECT_MICRO table.
N_COLOR Lookup table for N_COLLECT_COMMON, N_COLLECT_MICRO, and N_MICRO_SOURCE tables.
N_CONTAIN Lookup table for sample containers, many tables.
N_GRAZING Lookup table for N_COLLECT_PLANT table.
N_MORPH Lookup table for N_COLLECT_COMMON table.
N_MUCUS_QUAL Lookup table for N_COLLECT_MARINE table.
N_ORGANISM Lookup table for N_SAMPLE_COMMON, N_MICRO_SOURCE_O, and NCI_MEDUSE tables.
N_RATIONALE Lookup table for N_COLLECT_COMMON table.
N_STATUS Lookup table for sample status, many tables.
N_TEXTURE Lookup table for N_COLLECT_MARINE table.
N_WASTING Lookup table for N_COLLECT_PLANT table.
NCI_ABUND Lookup table for N_COLLECT_COMMON table. NCI convention.
NCI_COLOR Lookup table for N_COLLECT_COMMON, N_MICRO_SOURCE, and N_MICRO_SOURCE_O tables.
NCI_EPI_CV Lookup table for N_COLLECT_MARINE table. NCI convention.
NCI_FIX Lookup table for N_COLLECT_MARINE table. NCI convention.
NCI_HAZARD Lookup table for N_SAMPLE_COMMON table. NCI convention.
NCI_LN Lookup table for NCI_OTHER_NAME table. NCI convention.
NCI_MUCUS Lookup table for N_COLLECT_MARINE table. NCI convention.
NCI_MUU Lookup table for NCI_MED_USE table. NCI convention.
NCI_ODOR Lookup table for N_COLLECT_COMMON table. NCI convention.
NCI_PRES Lookup table for N_COLLECT_COMMON table. NCI convention.
NCI_RELAX Lookup table for N_COLLECT_MARINE table. NCI convention.
PL_CAT Lookup table for PLATE table.
PL_CONTENT Lookup table for PLATE_DETAIL table.
PL_FORMAT Lookup table for PLATE table. Defines formatting of microtiter plate.
PL_IMPORT Lookup table for Plate Import Utility.
PL_SOLUTION Lookup table for PLATE_DETAIL table.
PL_TYPE Lookup table for PLATE table.
PROJECT Lookup table for projects, many tables.
SEASON Lookup table for SITE_COMMON table.
SITE_BIOME Lookup table for SITE_COMMON table.
SITE_DATUM Lookup table for SITE_COMMON table.
SITE_ENERGY Lookup table for SITE_COMMON table, marine only.
SITE_ENVIRONMENT Lookup table for SITE_COMMON table.
SITE_EXPOSURE Lookup table for SITE_COMMON table.
SITE_SUBSTRATE Lookup table for SITE_COMMON table.
SITE_ZONE Lookup table for SITE_COMMON table.
UNITS Lookup table for units, many tables.

To the top