Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
SEFSC Metadata Library > Fisheries Statistics Division > FISHERIES MONITORING > Commercial Catch and Effort > Commercial Landings Project > Commercial Fisheries Landings for U.S. Caribbea... > U.S. Caribbean Commercial Landings (CCL) Tables... >

Table: LOV_LIST

Entity (ENT)  |  Southeast Fisheries Science Center (SEFSC)
GUID: gov.noaa.nmfs.inport:28550  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Table Of List Of Values Used In This application

Description

Table Of List Of Values Used In This application

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
LOV_CD
VARCHAR2 		Primary key for this table.
LOV_NM
VARCHAR2 		Unique name of LOV lists.
LOV_DESC
VARCHAR2 		Description of the value (list).
IS_ENABLED
NUMBER 		Is the list item enabled?
LOV_GROUP_CD
VARCHAR2 		Generic field for list item group code when applicable
LOV_ALT_CD
VARCHAR2 		Generic field for list item alternate code value such as species ERDMAN code
LU_DT
DATE 		Last update date.
LU_USER_ID
NUMBER 		Last update user.
SEQ
NUMBER 		Display Sequence
LOV_GROUP_TYPE
VARCHAR2 		Single (drop-down-list) or Multiple choice group list
LOV_GROUP_NM
VARCHAR2 		The list to dipslay where there is a group (LOV_GROUP_TYPE)
IS_CORE
VARCHAR2 		Flag to indicate if the list can be edited only by administrator

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

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

Item Identification

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

Table Of List Of Values Used In This application
Notes:

Loaded by batch 7533, 11-05-2015 16:10

Entity Information

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

Table Of List Of Values Used In This application

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key LOV_CD VARCHAR2 Primary key for this table.
100
 LOV_NM VARCHAR2 Unique name of LOV lists.
100
 LOV_DESC VARCHAR2 Description of the value (list).
100
 IS_ENABLED NUMBER Is the list item enabled?
100
 LOV_GROUP_CD VARCHAR2 Generic field for list item group code when applicable
100
 LOV_ALT_CD VARCHAR2 Generic field for list item alternate code value such as species ERDMAN code
100
 LU_DT DATE Last update date.
100
 LU_USER_ID NUMBER Last update user.
100
 SEQ NUMBER Display Sequence
100
 LOV_GROUP_TYPE VARCHAR2 Single (drop-down-list) or Multiple choice group list
100
 LOV_GROUP_NM VARCHAR2 The list to dipslay where there is a group (LOV_GROUP_TYPE)
100
 IS_CORE VARCHAR2 Flag to indicate if the list can be edited only by administrator

Attribute Details

LOV_CD

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

Primary key for this table.
General Data Type: VARCHAR2

LOV_NM

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

Unique name of LOV lists.
General Data Type: VARCHAR2

LOV_DESC

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

Description of the value (list).
General Data Type: VARCHAR2

IS_ENABLED

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

Is the list item enabled?
General Data Type: NUMBER

LOV_GROUP_CD

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

Generic field for list item group code when applicable
General Data Type: VARCHAR2

LOV_ALT_CD

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

Generic field for list item alternate code value such as species ERDMAN code
General Data Type: VARCHAR2

LU_DT

CC ID: 247020
Seq. Order: 7
Data Storage Type: DATE
Max Length: 7
Required: Yes
Primary Key: No
Status: Active
Description:

Last update date.
General Data Type: DATE

LU_USER_ID

CC ID: 247021
Seq. Order: 8
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 38
Status: Active
Description:

Last update user.
General Data Type: NUMBER

SEQ

CC ID: 247022
Seq. Order: 9
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Display Sequence
General Data Type: NUMBER

LOV_GROUP_TYPE

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

Single (drop-down-list) or Multiple choice group list
General Data Type: VARCHAR2

LOV_GROUP_NM

CC ID: 247013
Seq. Order: 11
Data Storage Type: VARCHAR2
Max Length: 60
Required: No
Primary Key: No
Status: Active
Description:

The list to dipslay where there is a group (LOV_GROUP_TYPE)
General Data Type: VARCHAR2

IS_CORE

CC ID: 247014
Seq. Order: 12
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Flag to indicate if the list can be edited only by administrator
General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 28550
GUID: gov.noaa.nmfs.inport:28550
Metadata Record Created By: Joshua Bennett
Metadata Record Created: 2015-11-05 16:10+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2021-05-06
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2021-05-06
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2022-05-06