Table: VERS_ELEMENT_GEAR_COLLECTION
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:34240 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Table is used to configure element data, gear relationships and rules for 'dynamic data' collection
DescriptionTable is used to configure element data, gear relationships and rules for 'dynamic data' collection
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
VEC_VP_PROGRAM_CODE
VARCHAR2 |
Program code for the gear/element rule (see VERS_PROGRAMS) |
VEC_VELE_VET_ELEMENT_LEVEL
NUMBER |
Reporting level of data element (see VERS_ELEMENT_TABLE) |
VEC_VELE_ELEMENT_ID
VARCHAR2 |
Element ID (see VERS_ELEMENTS) |
FGC_GEAR_CODE
VARCHAR2 |
Gear code for the gear/element rule (see FVTR_GEAR_CODES) |
VEC_ELEMENT_BEGIN_DATE
DATE |
Begin date (local) for the element/gear data collection rule |
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_GEAR_COLLECTION |
---|---|
Short Name: | VERS_ELEMENT_GEAR_COLLECTION |
Status: | Completed |
Abstract: |
Table is used to configure element data, gear relationships and rules for 'dynamic data' collection |
Notes: |
Loaded by batch 9189, 08-11-2016 10:02 |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Schema Name: | FVTR |
Description: |
Table is used to configure element data, gear relationships and rules for 'dynamic data' collection |
Data Attributes
Attribute Summary
![]() |
![]() |
Name | Type | Description |
---|---|---|---|---|
100
|
![]() |
VEC_VP_PROGRAM_CODE | VARCHAR2 | Program code for the gear/element rule (see VERS_PROGRAMS) |
100
|
![]() |
VEC_VELE_VET_ELEMENT_LEVEL | NUMBER | Reporting level of data element (see VERS_ELEMENT_TABLE) |
100
|
![]() |
VEC_VELE_ELEMENT_ID | VARCHAR2 | Element ID (see VERS_ELEMENTS) |
100
|
![]() |
FGC_GEAR_CODE | VARCHAR2 | Gear code for the gear/element rule (see FVTR_GEAR_CODES) |
100
|
![]() |
VEC_ELEMENT_BEGIN_DATE | DATE | Begin date (local) for the element/gear data collection rule |
Attribute Details
VEC_VP_PROGRAM_CODE
Seq. Order: | 1 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | Yes |
Primary Key: | Yes |
Status: | Active |
Description: |
Program code for the gear/element rule (see VERS_PROGRAMS) |
General Data Type: | VARCHAR2 |
Foreign Key Relations: |
FVTR.VERS_ELEMENT_COLLECTION |
VEC_VELE_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_COLLECTION |
VEC_VELE_ELEMENT_ID
Seq. Order: | 3 |
---|---|
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_ELEMENT_COLLECTION |
FGC_GEAR_CODE
Seq. Order: | 4 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 6 |
Required: | Yes |
Primary Key: | Yes |
Status: | Active |
Description: |
Gear code for the gear/element rule (see FVTR_GEAR_CODES) |
General Data Type: | VARCHAR2 |
Foreign Key Relations: |
FVTR.FVTR_GEAR_CODES |
VEC_ELEMENT_BEGIN_DATE
Seq. Order: | 5 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | Yes |
Primary Key: | Yes |
Status: | Active |
Description: |
Begin date (local) for the element/gear data collection rule |
General Data Type: | DATE |
Foreign Key Relations: |
FVTR.VERS_ELEMENT_COLLECTION |
Catalog Details
Catalog Item ID: | 34240 |
---|---|
GUID: | gov.noaa.nmfs.inport:34240 |
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 |