Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
NEFSC Metadata Library > Data Management Systems (DMS) > Vessel Electronic Reporting System (VERS) >

Table: FVTR_SOURCE_VERSIONS

Entity (ENT)  |  Northeast Fisheries Science Center (NEFSC)
GUID: gov.noaa.nmfs.inport:34266  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Table is used to validate electronic logbook data submissions. Vetted source versions must be listed in the table and have END_DATE=(null)

Description

Table is used to validate electronic logbook data submissions. Vetted source versions must be listed in the table and have END_DATE=(null)

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
SOURCE_VERSION
VARCHAR2 		Software version code for the electronic logbook used during data collection
SOURCE_DESCR
VARCHAR2 		Software version code description
RELEASE_DATE
DATE 		Date at which NEFSC/NERO review of the software was completed and software version was approved
ENABLE_ELEMENT_DATA
NUMBER 		Binary code used to indicate whether the software version is able to submit dynamic data (see VERS_ELEMENT tables)
END_DATE
DATE 		Expiration date for previous software versions (no longer supported) in local time
EVTR_APPROVED
NUMBER 		Numeric code used to indicate software versions currently approved for electronic VTR data reporting; 0=not approved, 1=approved for finfish/groundfish, 2=approved for surfclam/quahog

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

Table is used to validate electronic logbook data submissions. Vetted source versions must be listed in the table and have END_DATE=(null)
Notes:

Loaded by batch 9190, 08-11-2016 16:37

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: FVTR
Description:

Table is used to validate electronic logbook data submissions. Vetted source versions must be listed in the table and have END_DATE=(null)

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key SOURCE_VERSION VARCHAR2 Software version code for the electronic logbook used during data collection
100
 SOURCE_DESCR VARCHAR2 Software version code description
100
 RELEASE_DATE DATE Date at which NEFSC/NERO review of the software was completed and software version was approved
100
 ENABLE_ELEMENT_DATA NUMBER Binary code used to indicate whether the software version is able to submit dynamic data (see VERS_ELEMENT tables)
100
 END_DATE DATE Expiration date for previous software versions (no longer supported) in local time
100
 EVTR_APPROVED NUMBER Numeric code used to indicate software versions currently approved for electronic VTR data reporting; 0=not approved, 1=approved for finfish/groundfish, 2=approved for surfclam/quahog

Attribute Details

SOURCE_VERSION

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

Software version code for the electronic logbook used during data collection
General Data Type: VARCHAR2

SOURCE_DESCR

CC ID: 344204
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 30
Required: Yes
Primary Key: No
Status: Active
Description:

Software version code description
General Data Type: VARCHAR2

RELEASE_DATE

CC ID: 344205
Seq. Order: 3
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date at which NEFSC/NERO review of the software was completed and software version was approved
General Data Type: DATE

ENABLE_ELEMENT_DATA

CC ID: 344206
Seq. Order: 4
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 1
Scale: 0
Status: Active
Description:

Binary code used to indicate whether the software version is able to submit dynamic data (see VERS_ELEMENT tables)
General Data Type: NUMBER

END_DATE

CC ID: 344207
Seq. Order: 5
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Expiration date for previous software versions (no longer supported) in local time
General Data Type: DATE

EVTR_APPROVED

CC ID: 344208
Seq. Order: 6
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 1
Scale: 0
Status: Active
Description:

Numeric code used to indicate software versions currently approved for electronic VTR data reporting; 0=not approved, 1=approved for finfish/groundfish, 2=approved for surfclam/quahog
General Data Type: NUMBER

Catalog Details

Catalog Item ID: 34266
GUID: gov.noaa.nmfs.inport:34266
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2016-08-11 16:37+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