28550
Table: LOV_LIST
LOV_LIST
Entity
Published / External
27501
U.S. Caribbean Commercial Landings (CCL) Tables in new format since July 2011 for U.S. Virgin Islands and January 2012 for Puerto Rico
Data Set
Completed
Table Of List Of Values Used In This application
Loaded by batch 7533, 11-05-2015 16:10
Data Table
Yes
CCL
Table Of List Of Values Used In This application
1
LOV_CD
VARCHAR2
30
Yes
Yes
Active
Primary key for this table.
VARCHAR2
2
LOV_NM
VARCHAR2
60
Yes
No
Active
Unique name of LOV lists.
VARCHAR2
3
LOV_DESC
VARCHAR2
250
No
No
Active
Description of the value (list).
VARCHAR2
4
IS_ENABLED
NUMBER
22
Yes
No
38
0
Active
Is the list item enabled?
NUMBER
5
LOV_GROUP_CD
VARCHAR2
30
No
No
Active
Generic field for list item group code when applicable
VARCHAR2
6
LOV_ALT_CD
VARCHAR2
30
No
No
Active
Generic field for list item alternate code value such as species ERDMAN code
VARCHAR2
7
LU_DT
DATE
7
Yes
No
Active
Last update date.
DATE
8
LU_USER_ID
NUMBER
22
Yes
No
38
Active
Last update user.
NUMBER
9
SEQ
NUMBER
22
No
No
2
0
Active
Display Sequence
NUMBER
10
LOV_GROUP_TYPE
VARCHAR2
30
No
No
Active
Single (drop-down-list) or Multiple choice group list
VARCHAR2
11
LOV_GROUP_NM
VARCHAR2
60
No
No
Active
The list to dipslay where there is a group (LOV_GROUP_TYPE)
VARCHAR2
12
IS_CORE
VARCHAR2
1
No
No
Active
Flag to indicate if the list can be edited only by administrator
VARCHAR2
gov.noaa.nmfs.inport:28550
Joshua Bennett
2015-11-05T16:10:54
SysAdmin InPortAdmin
2022-08-09T17:11:13
2021-05-06
Southeast Fisheries Science Center
SEFSC
75 Virginia Beach Drive
Miami
FL
33149
USA
(305)361-5761
www.sefsc.noaa.gov
8:00 a.m. - 4:30 p.m. EST
1001
Public
No
2021-05-06
1 Year
2022-05-06