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
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Table lists individual 'dynamic data' elements, collection bounds and associated descriptions
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
|
|
|
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 |
