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: VERS_TRIP_TRANSMIT

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

Summary

Abstract

Table logs each transmission and/or upload attempt for ELB data files; trips created on the VERS Web Portal are not applicable

Description

Table logs each transmission and/or upload attempt for ELB data files; trips created on the VERS Web Portal are not applicable

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
TRIP_ID
NUMBER 		Unique trip identifier
TRANSMISSION_DATE_GMT
DATE 		Datetime (UTC) the raw data file was transmitted from the vessel
UPLOAD_DATE_GMT
DATE 		Datetime (UTC) when the data file was loaded to NEFSC databases
EMAIL_RECEIVE_DATE_GMT
DATE 		Datetime (GMT) when the email containing the raw data file was received by NEFSC servers
EMAIL_SENDER
VARCHAR2 		Type or method of email submission (see FVTR_SENDER_TYPES)
FILE_NAME
VARCHAR2 		File name of the raw data file which was submitted and archived (the legal record for eVTR reporting)
LOAD_STATUS
VARCHAR2 		Codes used to describe the load status of the file submission (see FVTR_LOAD_STATUS_CODES)
FILE_SEQ_NUM
NUMBER 		File segment number used for instances of partial trip transmission
NUM_FILE_EFFORTS
NUMBER 		Count of efforts included in the raw data file or segment (reported by ELB application)
NUM_FILE_LANDINGS
NUMBER 		Count of landings included in the raw data file or segment (reported by ELB application)
TOTAL_TRIP_EFFORTS
NUMBER 		Total count of efforts conducted within the trip as of the time of transmission (reported by ELB application)
TOTAL_TRIP_LANDINGS
NUMBER 		Total count of landings conducted within the trip as of the time of transmission (reported by ELB application)
PROG_COMMENT
VARCHAR2 		Additional trip status comments relevant to the file transmission and upload
SENDER_ADDRESS
VARCHAR2 		Email address of the raw data file sender
TRIP_STATUS
VARCHAR2 		Code used to describe the trip status of the data after load processing (see FVTR_TRIP_STATUS_CODES)

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

Table logs each transmission and/or upload attempt for ELB data files; trips created on the VERS Web Portal are not applicable
Notes:

Loaded by batch 9189, 08-11-2016 10:02

Entity Information

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

Table logs each transmission and/or upload attempt for ELB data files; trips created on the VERS Web Portal are not applicable

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 TRIP_ID NUMBER Unique trip identifier
100
 TRANSMISSION_DATE_GMT DATE Datetime (UTC) the raw data file was transmitted from the vessel
100
 UPLOAD_DATE_GMT DATE Datetime (UTC) when the data file was loaded to NEFSC databases
100
 EMAIL_RECEIVE_DATE_GMT DATE Datetime (GMT) when the email containing the raw data file was received by NEFSC servers
100
 EMAIL_SENDER VARCHAR2 Type or method of email submission (see FVTR_SENDER_TYPES)
100
 FILE_NAME VARCHAR2 File name of the raw data file which was submitted and archived (the legal record for eVTR reporting)
100
 LOAD_STATUS VARCHAR2 Codes used to describe the load status of the file submission (see FVTR_LOAD_STATUS_CODES)
100
 FILE_SEQ_NUM NUMBER File segment number used for instances of partial trip transmission
100
 NUM_FILE_EFFORTS NUMBER Count of efforts included in the raw data file or segment (reported by ELB application)
100
 NUM_FILE_LANDINGS NUMBER Count of landings included in the raw data file or segment (reported by ELB application)
100
 TOTAL_TRIP_EFFORTS NUMBER Total count of efforts conducted within the trip as of the time of transmission (reported by ELB application)
100
 TOTAL_TRIP_LANDINGS NUMBER Total count of landings conducted within the trip as of the time of transmission (reported by ELB application)
100
 PROG_COMMENT VARCHAR2 Additional trip status comments relevant to the file transmission and upload
100
 SENDER_ADDRESS VARCHAR2 Email address of the raw data file sender
100
 TRIP_STATUS VARCHAR2 Code used to describe the trip status of the data after load processing (see FVTR_TRIP_STATUS_CODES)

Attribute Details

TRIP_ID

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

Unique trip identifier
General Data Type: NUMBER

TRANSMISSION_DATE_GMT

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

Datetime (UTC) the raw data file was transmitted from the vessel
General Data Type: DATE

UPLOAD_DATE_GMT

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

Datetime (UTC) when the data file was loaded to NEFSC databases
General Data Type: DATE

EMAIL_RECEIVE_DATE_GMT

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

Datetime (GMT) when the email containing the raw data file was received by NEFSC servers
General Data Type: DATE

EMAIL_SENDER

CC ID: 344092
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 15
Required: Yes
Primary Key: No
Status: Active
Description:

Type or method of email submission (see FVTR_SENDER_TYPES)
General Data Type: VARCHAR2
Foreign Key Relations:

FVTR.FVTR_SENDER_TYPES

FILE_NAME

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

File name of the raw data file which was submitted and archived (the legal record for eVTR reporting)
General Data Type: VARCHAR2

LOAD_STATUS

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

Codes used to describe the load status of the file submission (see FVTR_LOAD_STATUS_CODES)
General Data Type: VARCHAR2

FILE_SEQ_NUM

CC ID: 344105
Seq. Order: 8
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

File segment number used for instances of partial trip transmission
General Data Type: NUMBER

NUM_FILE_EFFORTS

CC ID: 344106
Seq. Order: 9
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Count of efforts included in the raw data file or segment (reported by ELB application)
General Data Type: NUMBER

NUM_FILE_LANDINGS

CC ID: 344095
Seq. Order: 10
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Count of landings included in the raw data file or segment (reported by ELB application)
General Data Type: NUMBER

TOTAL_TRIP_EFFORTS

CC ID: 344096
Seq. Order: 11
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Total count of efforts conducted within the trip as of the time of transmission (reported by ELB application)
General Data Type: NUMBER

TOTAL_TRIP_LANDINGS

CC ID: 344097
Seq. Order: 12
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Total count of landings conducted within the trip as of the time of transmission (reported by ELB application)
General Data Type: NUMBER

PROG_COMMENT

CC ID: 344098
Seq. Order: 13
Data Storage Type: VARCHAR2
Max Length: 500
Required: No
Primary Key: No
Status: Active
Description:

Additional trip status comments relevant to the file transmission and upload
General Data Type: VARCHAR2

SENDER_ADDRESS

CC ID: 344099
Seq. Order: 14
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

Email address of the raw data file sender
General Data Type: VARCHAR2

TRIP_STATUS

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

Code used to describe the trip status of the data after load processing (see FVTR_TRIP_STATUS_CODES)
General Data Type: VARCHAR2
Foreign Key Relations:

FVTR.FVTR_TRIP_STATUS_CODES

Catalog Details

Catalog Item ID: 34249
GUID: gov.noaa.nmfs.inport:34249
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