Table: VERS_ELEMENT_COLLECTION
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:34237 | 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, program relationships and rules for 'dynamic data' collection
DescriptionTable is used to configure element data, program relationships and rules for 'dynamic data' collection
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
VP_PROGRAM_CODE
VARCHAR2 |
Program code for the element rule (see VERS_PROGRAMS) |
VELE_ELEMENT_ID
VARCHAR2 |
Element ID (see VERS_ELEMENTS) |
VELE_VET_ELEMENT_LEVEL
NUMBER |
Reporting level of data element (see VERS_ELEMENT_TABLE) |
DISPLAY_SEQ_NO
NUMBER |
Sequencial display order of elements collection; 1=first or top left of the display area |
REQUIRED
NUMBER |
Binary code indicating whether the data element is required in order to complete the ELB trip |
ELEMENT_BEGIN_DATE
DATE |
Start date (local) for the collection of the data element within the program |
ELEMENT_END_DATE
DATE |
End date (local) for the collection of the data element within the program |
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_COLLECTION |
---|---|
Short Name: | VERS_ELEMENT_COLLECTION |
Status: | Completed |
Abstract: |
Table is used to configure element data, program 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, program relationships and rules for 'dynamic data' collection |
Data Attributes
Attribute Summary
![]() |
![]() |
Name | Type | Description |
---|---|---|---|---|
100
|
![]() |
VP_PROGRAM_CODE | VARCHAR2 | Program code for the element rule (see VERS_PROGRAMS) |
100
|
![]() |
VELE_ELEMENT_ID | VARCHAR2 | Element ID (see VERS_ELEMENTS) |
100
|
![]() |
VELE_VET_ELEMENT_LEVEL | NUMBER | Reporting level of data element (see VERS_ELEMENT_TABLE) |
100
|
DISPLAY_SEQ_NO | NUMBER | Sequencial display order of elements collection; 1=first or top left of the display area | |
100
|
REQUIRED | NUMBER | Binary code indicating whether the data element is required in order to complete the ELB trip | |
100
|
![]() |
ELEMENT_BEGIN_DATE | DATE | Start date (local) for the collection of the data element within the program |
100
|
ELEMENT_END_DATE | DATE | End date (local) for the collection of the data element within the program |
Attribute Details
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 element rule (see VERS_PROGRAMS) |
General Data Type: | VARCHAR2 |
Foreign Key Relations: |
FVTR.VERS_PROGRAMS |
VELE_ELEMENT_ID
Seq. Order: | 2 |
---|---|
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
Seq. Order: | 3 |
---|---|
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 |
DISPLAY_SEQ_NO
Seq. Order: | 4 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 3 |
Scale: | 0 |
Status: | Active |
Description: |
Sequencial display order of elements collection; 1=first or top left of the display area |
General Data Type: | NUMBER |
REQUIRED
Seq. Order: | 5 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 1 |
Scale: | 0 |
Status: | Active |
Description: |
Binary code indicating whether the data element is required in order to complete the ELB trip |
General Data Type: | NUMBER |
ELEMENT_BEGIN_DATE
Seq. Order: | 6 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | Yes |
Primary Key: | Yes |
Status: | Active |
Description: |
Start date (local) for the collection of the data element within the program |
General Data Type: | DATE |
ELEMENT_END_DATE
Seq. Order: | 7 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
End date (local) for the collection of the data element within the program |
General Data Type: | DATE |
Catalog Details
Catalog Item ID: | 34237 |
---|---|
GUID: | gov.noaa.nmfs.inport:34237 |
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 |