54811 HER_PUMP_STOP_DUR Entity Published / External 53562 Herring Fishery Electronic Monitoring Project Data (EMREVIEW) Data Set Completed Herring Duration of Stopped Pumping Event Spreadsheet Yes Herring Duration of Stopped Pumping Event 1 TRIP_ID NUMBER 6 Yes No 6 0 Active Unique trip identifier generated when the data is loaded to Oracle raw tables. NUMBER 2 REVIEWER_ID VARCHAR2 4 Yes No Active A unique reviewer identifier assigned to each reviewer of EM videos. See the REVIEWERS table for a list of reviewer names and their affliation. VARCHAR2 3 PSD_ID NUMBER 3 Yes No 3 0 Active Unique identifier for this pump stop duration event record for the associated trip identifer and reviewer identifier combination. It is generated when the data is loaded to Oracle raw tables. NUMBER 4 HAUL_NUMBER NUMBER 6 No No 6 0 Active Fishing event haul number in which this pump stop duration record occurred. NUMBER 5 BEGIN_TIME NUMBER 16 Yes No 16 2 Active Date and time that this pump stop duration event began as determined by the video reviewer. Actual pump stop duration began time as defined by when the incident occurred may be different than this date and time. NUMBER 6 BEGIN_DATE_TIME_UTC VARCHAR2 19 No No Active UTC translation of BEGIN_TIME VARCHAR2 7 BEGIN_YEAR_UTC VARCHAR2 4 No No Active Extract UTC year from BEGIN_TIME VARCHAR2 8 BEGIN_MONTH_UTC VARCHAR2 2 No No Active Extract UTC month from BEGIN_TIME VARCHAR2 9 BEGIN_DAY_UTC VARCHAR2 2 No No Active Extract UTC day from BEGIN_TIME VARCHAR2 10 BEGIN_TIME_UTC VARCHAR2 8 No No Active Extract UTC time from BEGIN_TIME VARCHAR2 11 END_TIME NUMBER 16 Yes No 16 2 Active Date and time that this pump stop duration event ended as determined by the video reviewer. Actual pump stop duration end time as defined by when the incident occurred may be different than this date and time. NUMBER 12 END_DATE_TIME_UTC VARCHAR2 19 No No Active UTC translation of END_TIME VARCHAR2 13 END_YEAR_UTC VARCHAR2 4 No No Active Extract UTC year from END_TIME VARCHAR2 14 END_MONTH_UTC VARCHAR2 2 No No Active Extract UTC month from END_TIME VARCHAR2 15 END_DAY_UTC VARCHAR2 2 No No Active Extract UTC day from END_TIME VARCHAR2 16 END_TIME_UTC VARCHAR2 8 No No Active Extract UTC time from END_TIME VARCHAR2 17 BEGIN_LATITUDE NUMBER 9 Yes No 9 4 Active Beginning latitude where this pump stop duration event started as determined by the video reviewer. Actual beginning latitude as defined by when the pump stop duration event may be different than this beginning latitude. NUMBER 18 BEGIN_LONGITUDE NUMBER 9 Yes No 9 4 Active Beginning longitude where this pump stop duration event started as determined by the video reviewer. Actual beginning longitude as defined by when the pump stop duration event may be different than this beginning longitude. NUMBER 19 END_LATITUDE NUMBER 9 Yes No 9 4 Active Ending latitude where this pump stop duration event ended as determined by the video reviewer. Actual ending latitude as defined by when the pump stop duration event ended may be different than this ending latitude. NUMBER 20 END_LONGITUDE NUMBER 9 Yes No 9 4 Active Ending longitude where this pump stop duration event ended as determined by the video reviewer. Actual ending longitude as defined by when the pump stop duration event may be different than this ending longitude. NUMBER 21 NOTES VARCHAR2 500 No No Active Comments provided by the reviewer during the video review process. VARCHAR2 22 PUMP_STOP_REASON_CODE_STR VARCHAR2 200 No No Active String value which includes all of the pump stop reason codes for this pump stop duration event. Note that this value: may or may not include square brackets around the entire list; individual values may be surrounded by single quotes, double quotes or no quotes; and multiple values will be separated by a pipe symbol (|). See individual codes in the HER_PSD_PUMP_STOP_REASON table. VARCHAR2 gov.noaa.nmfs.inport:54811 Patricia Jones 2018-11-13T16:56:31 SysAdmin InPortAdmin 2022-08-09T17:11:42 2018-11-14 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 2018-11-14 1 Year 2019-11-14