Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

contains the various lookup values for the NIMM application

Description

contains the various lookup values for the NIMM application

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
LOOKUP_ID
NUMBER
the unique identifier for this particular lookup value
LV_TABLE_NAME
VARCHAR2
the reference table with which this lookup value is associated
LV_COLUMN_NAME
VARCHAR2
the column within the reference table with which this lookup value is associated
LV_ORDER_NBR
NUMBER
the display sequence for the lookup value
LV_VALUE
VARCHAR2
the code or lookup value itself
LV_DESC
VARCHAR2
the description of the lookup value; may be used as a pop-up description in the application

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (OPR) for inquiries on this record.

Item Identification

Title: Table: NIMM_LOOKUP_VALUES
Short Name: NIMM_LOOKUP_VALUES
Status: Completed
Abstract:

contains the various lookup values for the NIMM application

Notes:

Loaded by batch 7077, 09-17-2015 08:15

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: NIMM_APPS
Description:

contains the various lookup values for the NIMM application

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key LOOKUP_ID NUMBER the unique identifier for this particular lookup value
100
LV_TABLE_NAME VARCHAR2 the reference table with which this lookup value is associated
100
LV_COLUMN_NAME VARCHAR2 the column within the reference table with which this lookup value is associated
100
LV_ORDER_NBR NUMBER the display sequence for the lookup value
100
LV_VALUE VARCHAR2 the code or lookup value itself
100
LV_DESC VARCHAR2 the description of the lookup value; may be used as a pop-up description in the application

Attribute Details

LOOKUP_ID

CC ID: 219319
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 10
Scale: 0
Status: Active
Description:

the unique identifier for this particular lookup value

General Data Type: NUMBER

LV_TABLE_NAME

CC ID: 219320
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 30
Required: Yes
Primary Key: No
Status: Active
Description:

the reference table with which this lookup value is associated

General Data Type: VARCHAR2

LV_COLUMN_NAME

CC ID: 219321
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 30
Required: Yes
Primary Key: No
Status: Active
Description:

the column within the reference table with which this lookup value is associated

General Data Type: VARCHAR2

LV_ORDER_NBR

CC ID: 219322
Seq. Order: 4
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

the display sequence for the lookup value

General Data Type: NUMBER

LV_VALUE

CC ID: 219323
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 100
Required: Yes
Primary Key: No
Status: Active
Description:

the code or lookup value itself

General Data Type: VARCHAR2

LV_DESC

CC ID: 219324
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 4000
Required: Yes
Primary Key: No
Status: Active
Description:

the description of the lookup value; may be used as a pop-up description in the application

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 27002
GUID: gov.noaa.nmfs.inport:27002
Metadata Record Created By: Nathan Wilson
Metadata Record Created: 2015-09-17 08:15+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2018-05-16
Owner Org: OPR
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2018-05-16
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2019-05-16