Slide Menu
Jump to Section...
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 

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