Table: VERS_ELEMENTS
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:34236 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Table lists individual 'dynamic data' elements, collection bounds and associated descriptions
DescriptionTable 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
Name | Type | Description | ||
---|---|---|---|---|
100
|
ELEMENT_ID | VARCHAR2 | Unique element identifier | |
100
|
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
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
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
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
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
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
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
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
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 |