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

Summary

Abstract

Table lists individual 'dynamic data' elements, collection bounds and associated descriptions

Description

Table lists individual 'dynamic data' elements, collection bounds and associated descriptions

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
ELEMENT_ID
VARCHAR2
Unique element identifier
VET_ELEMENT_LEVEL
NUMBER
Reporting level of data element (see VERS_ELEMENT_TABLE)
ELEMENT_NAME
VARCHAR2
Element name displayed in the ELB application
ELEMENT_DESCR
VARCHAR2
Element description
VEF_ELEMENT_FORMAT
VARCHAR2
Data value format of the reported element (see VERS_ELEMENT_FORMATS)
MIN_VALUE
NUMBER
Minimum acceptable value of the reported element (only applicable to numeric formats)
MAX_VALUE
NUMBER
Maximum acceptable value of the reported element (only applicable to numeric formats)
VAT_AUDIT_TYPE
VARCHAR2
Audit type code for the data audit to be performed by the ELB on the entered value (see VERS_AUDIT_TYPE)

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_ELEMENTS
Short Name: VERS_ELEMENTS
Status: Completed
Abstract:

Table lists individual 'dynamic data' elements, collection bounds and associated descriptions

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 individual 'dynamic data' elements, collection bounds and associated descriptions

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key ELEMENT_ID VARCHAR2 Unique element identifier
100
Primary Key VET_ELEMENT_LEVEL NUMBER Reporting level of data element (see VERS_ELEMENT_TABLE)
100
ELEMENT_NAME VARCHAR2 Element name displayed in the ELB application
100
ELEMENT_DESCR VARCHAR2 Element description
100
VEF_ELEMENT_FORMAT VARCHAR2 Data value format of the reported element (see VERS_ELEMENT_FORMATS)
100
MIN_VALUE NUMBER Minimum acceptable value of the reported element (only applicable to numeric formats)
100
MAX_VALUE NUMBER Maximum acceptable value of the reported element (only applicable to numeric formats)
100
VAT_AUDIT_TYPE VARCHAR2 Audit type code for the data audit to be performed by the ELB on the entered value (see VERS_AUDIT_TYPE)

Attribute Details

ELEMENT_ID

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

Unique element identifier

General Data Type: VARCHAR2

VET_ELEMENT_LEVEL

CC ID: 344003
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_ELEMENT_LEVELS

ELEMENT_NAME

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

Element name displayed in the ELB application

General Data Type: VARCHAR2

ELEMENT_DESCR

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

Element description

General Data Type: VARCHAR2

VEF_ELEMENT_FORMAT

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

Data value format of the reported element (see VERS_ELEMENT_FORMATS)

General Data Type: VARCHAR2
Foreign Key Relations:

FVTR.VERS_ELEMENT_FORMATS

MIN_VALUE

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

Minimum acceptable value of the reported element (only applicable to numeric formats)

General Data Type: NUMBER

MAX_VALUE

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

Maximum acceptable value of the reported element (only applicable to numeric formats)

General Data Type: NUMBER

VAT_AUDIT_TYPE

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

Audit type code for the data audit to be performed by the ELB on the entered value (see VERS_AUDIT_TYPE)

General Data Type: VARCHAR2
Foreign Key Relations:

FVTR.VERS_AUDIT_TYPE

Catalog Details

Catalog Item ID: 34236
GUID: gov.noaa.nmfs.inport:34236
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