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 | 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. |