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

Summary

Abstract

Table lists the 'dynamic data' elements and associated descriptions displayed on ELB applications

Description

Table lists the 'dynamic data' elements and associated descriptions displayed on ELB applications

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
VELE_ELEMENT_ID
VARCHAR2
Element ID (see VERS_ELEMENTS)
VELE_VET_ELEMENT_LEVEL
NUMBER
Reporting level of data element (see VERS_ELEMENT_TABLE)
LIST_VALUE
VARCHAR2
Value of the element selected and stored in the raw data file
LIST_DISPLAY
VARCHAR2
Short description displayed in the dropdown list
LIST_DESCR
VARCHAR2
Complete description of the dropdown list element value
DISPLAY_SEQ_NO
NUMBER
Sequencial order of dropdown list items; 1=first or top row of the dropdown list

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

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

Item Identification

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

Table lists the 'dynamic data' elements and associated descriptions displayed on ELB applications

Notes:

Loaded by batch 9189, 08-11-2016 10:02

Entity Information

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

Table lists the 'dynamic data' elements and associated descriptions displayed on ELB applications

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key VELE_ELEMENT_ID VARCHAR2 Element ID (see VERS_ELEMENTS)
100
Primary Key VELE_VET_ELEMENT_LEVEL NUMBER Reporting level of data element (see VERS_ELEMENT_TABLE)
100
Primary Key LIST_VALUE VARCHAR2 Value of the element selected and stored in the raw data file
100
LIST_DISPLAY VARCHAR2 Short description displayed in the dropdown list
100
LIST_DESCR VARCHAR2 Complete description of the dropdown list element value
100
DISPLAY_SEQ_NO NUMBER Sequencial order of dropdown list items; 1=first or top row of the dropdown list

Attribute Details

VELE_ELEMENT_ID

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

Element ID (see VERS_ELEMENTS)

General Data Type: VARCHAR2
Foreign Key Relations:

FVTR.VERS_ELEMENTS

VELE_VET_ELEMENT_LEVEL

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

Reporting level of data element (see VERS_ELEMENT_TABLE)

General Data Type: NUMBER
Foreign Key Relations:

FVTR.VERS_ELEMENTS

LIST_VALUE

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

Value of the element selected and stored in the raw data file

General Data Type: VARCHAR2

LIST_DISPLAY

CC ID: 344035
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 20
Required: Yes
Primary Key: No
Status: Active
Description:

Short description displayed in the dropdown list

General Data Type: VARCHAR2

LIST_DESCR

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

Complete description of the dropdown list element value

General Data Type: VARCHAR2

DISPLAY_SEQ_NO

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

Sequencial order of dropdown list items; 1=first or top row of the dropdown list

General Data Type: NUMBER

Catalog Details

Catalog Item ID: 34242
GUID: gov.noaa.nmfs.inport:34242
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2016-08-11 10:02+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-08-23
Owner Org: NEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-08-23
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-08-23