Search Help Show/Hide Menu
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