34249 VERS_TRIP_TRANSMIT Entity Published / External 26730 Vessel Electronic Reporting System (VERS) Data Set Completed Table logs each transmission and/or upload attempt for ELB data files; trips created on the VERS Web Portal are not applicable Loaded by batch 9189, 08-11-2016 10:02 Data Table Yes FVTR Table logs each transmission and/or upload attempt for ELB data files; trips created on the VERS Web Portal are not applicable 1 TRIP_ID NUMBER 22 Yes No 14 0 Active Unique trip identifier NUMBER 2 TRANSMISSION_DATE_GMT DATE 7 No No Active Datetime (UTC) the raw data file was transmitted from the vessel DATE 3 UPLOAD_DATE_GMT DATE 7 Yes No Active Datetime (UTC) when the data file was loaded to NEFSC databases DATE 4 EMAIL_RECEIVE_DATE_GMT DATE 7 No No Active Datetime (GMT) when the email containing the raw data file was received by NEFSC servers DATE 5 EMAIL_SENDER VARCHAR2 15 Yes No Active Type or method of email submission (see FVTR_SENDER_TYPES) VARCHAR2 FVTR.FVTR_SENDER_TYPES 6 FILE_NAME VARCHAR2 30 No No Active File name of the raw data file which was submitted and archived (the legal record for eVTR reporting) VARCHAR2 7 LOAD_STATUS VARCHAR2 5 No No Active Codes used to describe the load status of the file submission (see FVTR_LOAD_STATUS_CODES) VARCHAR2 8 FILE_SEQ_NUM NUMBER 22 No No 3 0 Active File segment number used for instances of partial trip transmission NUMBER 9 NUM_FILE_EFFORTS NUMBER 22 No No 3 0 Active Count of efforts included in the raw data file or segment (reported by ELB application) NUMBER 10 NUM_FILE_LANDINGS NUMBER 22 No No 3 0 Active Count of landings included in the raw data file or segment (reported by ELB application) NUMBER 11 TOTAL_TRIP_EFFORTS NUMBER 22 No No 3 0 Active Total count of efforts conducted within the trip as of the time of transmission (reported by ELB application) NUMBER 12 TOTAL_TRIP_LANDINGS NUMBER 22 No No 3 0 Active Total count of landings conducted within the trip as of the time of transmission (reported by ELB application) NUMBER 13 PROG_COMMENT VARCHAR2 500 No No Active Additional trip status comments relevant to the file transmission and upload VARCHAR2 14 SENDER_ADDRESS VARCHAR2 50 No No Active Email address of the raw data file sender VARCHAR2 15 TRIP_STATUS VARCHAR2 15 Yes No Active Code used to describe the trip status of the data after load processing (see FVTR_TRIP_STATUS_CODES) VARCHAR2 FVTR.FVTR_TRIP_STATUS_CODES gov.noaa.nmfs.inport:34249 Patricia Jones 2016-08-11T10:02:33 SysAdmin InPortAdmin 2022-08-09T17:11:16 2016-08-23 Northeast Fisheries Science Center NEFSC 166 Water Street Woods Hole MA 02543-1026 USA (508)495-2000 https://www.nefsc.noaa.gov 8:00 a.m. to 4:30 p.m. Monday - Friday 1001 Public No 2016-08-23 1 Year 2017-08-23