HER_FISHING_EVENT

Unique trip identifier generated when the data is loaded to Oracle raw tables.

A unique reviewer identifier assigned to each reviewer of EM videos. See the REVIEWERS table for a list of reviewer names and their affliation.

Unique identifier for this fishing event record for the associated trip identifer. It is generated when the data is loaded to Oracle raw tables.

Unique haul number assigned by the reviewer for this fishing event record for the associated trip identifer.

Date and time that this fishing event began as determined by the video reviewer. Actual fishing event begin time as defined by when the vessel departed to go fishing may be different than this date and time.

UTC translation of BEGIN_TIME

Extract UTC year from BEGIN_TIME

Extract UTC month from BEGIN_TIME

Extract UTC day from BEGIN_TIME

Extract UTC time from BEGIN_TIME

Date and time that this fishing event ended as determined by the video reviewer. Actual fishing event end time as defined by when the vessel returned from fishing may be different than this date and time.

UTC translation of END_TIME

Extract UTC year from END_TIME

Extract UTC month from END_TIME

Extract UTC day from END_TIME

Extract UTC time from END_TIME

Beginning latitude where this fishing event started as determined by the video reviewer. Actual beginning latitude as defined by when the vessel departed to go fishing may be different than this beginning latitude.

Beginning longitude where this fishing event started as determined by the video reviewer. Actual beginning longitude as defined by when the vessel departed to go fishing may be different than this beginning longitude.

Ending latitude where this fishing event ended as determined by the video reviewer. Actual ending latitude as defined by when the vessel returned from fishing may be different than this ending latitude.

Ending longitude where this fishing event ended as determined by the video reviewer. Actual ending longitude as defined by when the vessel returned from fishing may be different than this ending longitude.

Whether or not sensor detection was used on this trip as determined by the video reviewer. See the SENSOR_DETECTION table for a list of codes and their definitions.

Whether or not the vessel pumped fish on this trip as determined by the video reviewer. See the VESSEL_PUMPED_FISH table for a list of codes and their definitions.

Whether or not the video reviewer was able to see the codeend bunt contents when reviewing this trip. See the BUNT_CONTENTS table for a list of codes and their definitions.

Whether or not a discard event occurred on this trip as determined by the video reviewer. See the DISCARD_EVENT_OCCURRED table for a list of codes and their definitions.

Whether or not a triplex was used on this trip as determined by the video reviewer. See the TRIPLEX_USED table for a list of codes and their definitions.

If fish were pumped to another vessel, this would be the Federal or State vessel registration number for the other vessel and it is usually visable on the vessel hull. See the EMVESSELS table for a list of vessel registration numbers, names and permit numbers.

Code for the image quality assessment of the video for this trip as determined by the video reviewer. See the IMAGE_QUALITY table for a list of codes and their definitions.

Comments provided by the reviewer during the video review process.

String formatted value which includes all of the video issues codes for this fishing 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_FE_VIDEO_ISSUES table.