Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Herring Fishing Event

Description

Herring Fishing Event

Entity Information

Entity Type
Spreadsheet

Data Attribute / Type Description
TRIP_ID
NUMBER
Unique trip identifier generated when the data is loaded to Oracle raw tables.
REVIEWER_ID
VARCHAR2
A unique reviewer identifier assigned to each reviewer of EM videos. See the REVIEWERS table for a list of reviewer names and their affliation.
FE_ID
NUMBER
Unique identifier for this fishing event record for the associated trip identifer. It is generated when the data is loaded to Oracle raw tables.
HAUL_NUMBER
NUMBER
Unique haul number assigned by the reviewer for this fishing event record for the associated trip identifer.
BEGIN_TIME
NUMBER
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.
BEGIN_DATE_TIME_UTC
VARCHAR2
UTC translation of BEGIN_TIME
BEGIN_YEAR_UTC
VARCHAR2
Extract UTC year from BEGIN_TIME
BEGIN_MONTH_UTC
VARCHAR2
Extract UTC month from BEGIN_TIME
BEGIN_DAY_UTC
VARCHAR2
Extract UTC day from BEGIN_TIME
BEGIN_TIME_UTC
VARCHAR2
Extract UTC time from BEGIN_TIME
END_TIME
NUMBER
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.
END_DATE_TIME_UTC
VARCHAR2
UTC translation of END_TIME
END_YEAR_UTC
VARCHAR2
Extract UTC year from END_TIME
END_MONTH_UTC
VARCHAR2
Extract UTC month from END_TIME
END_DAY_UTC
VARCHAR2
Extract UTC day from END_TIME
END_TIME_UTC
VARCHAR2
Extract UTC time from END_TIME
BEGIN_LATITUDE
NUMBER
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.
BEGIN_LONGITUDE
NUMBER
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.
END_LATITUDE
NUMBER
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.
END_LONGITUDE
NUMBER
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.
SENSOR_DETECTION
VARCHAR2
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.
VESSEL_PUMPED_FISH
VARCHAR2
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.
SEE_CODEEND_BUNT_CONTENTS
VARCHAR2
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.
DISCARD_EVENT_OCCURRED
VARCHAR2
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.
TRIPLEX_USED
VARCHAR2
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.
FISH_PUMPED_TO_OTHER_VESSEL
VARCHAR2
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.
IMAGE_QUALITY_ASSESSMENT
VARCHAR2
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.
NOTES
VARCHAR2
Comments provided by the reviewer during the video review process.
VIDEO_ISSUES_STR
VARCHAR2
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.

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

Herring Fishing Event

Entity Information

Entity Type: Spreadsheet
Active Version?: Yes
Description:

Herring Fishing Event

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
TRIP_ID NUMBER Unique trip identifier generated when the data is loaded to Oracle raw tables.
100
REVIEWER_ID VARCHAR2 A unique reviewer identifier assigned to each reviewer of EM videos. See the REVIEWERS table for a list of reviewer names and their affliation.
100
FE_ID NUMBER Unique identifier for this fishing event record for the associated trip identifer. It is generated when the data is loaded to Oracle raw tables.
100
HAUL_NUMBER NUMBER Unique haul number assigned by the reviewer for this fishing event record for the associated trip identifer.
100
BEGIN_TIME NUMBER 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.
100
BEGIN_DATE_TIME_UTC VARCHAR2 UTC translation of BEGIN_TIME
100
BEGIN_YEAR_UTC VARCHAR2 Extract UTC year from BEGIN_TIME
100
BEGIN_MONTH_UTC VARCHAR2 Extract UTC month from BEGIN_TIME
100
BEGIN_DAY_UTC VARCHAR2 Extract UTC day from BEGIN_TIME
100
BEGIN_TIME_UTC VARCHAR2 Extract UTC time from BEGIN_TIME
100
END_TIME NUMBER 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.
100
END_DATE_TIME_UTC VARCHAR2 UTC translation of END_TIME
100
END_YEAR_UTC VARCHAR2 Extract UTC year from END_TIME
100
END_MONTH_UTC VARCHAR2 Extract UTC month from END_TIME
100
END_DAY_UTC VARCHAR2 Extract UTC day from END_TIME
100
END_TIME_UTC VARCHAR2 Extract UTC time from END_TIME
100
BEGIN_LATITUDE NUMBER 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.
100
BEGIN_LONGITUDE NUMBER 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.
100
END_LATITUDE NUMBER 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.
100
END_LONGITUDE NUMBER 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.
100
SENSOR_DETECTION VARCHAR2 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.
100
VESSEL_PUMPED_FISH VARCHAR2 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.
100
SEE_CODEEND_BUNT_CONTENTS VARCHAR2 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.
100
DISCARD_EVENT_OCCURRED VARCHAR2 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.
100
TRIPLEX_USED VARCHAR2 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.
100
FISH_PUMPED_TO_OTHER_VESSEL VARCHAR2 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.
100
IMAGE_QUALITY_ASSESSMENT VARCHAR2 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.
100
NOTES VARCHAR2 Comments provided by the reviewer during the video review process.
100
VIDEO_ISSUES_STR VARCHAR2 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.

Attribute Details

TRIP_ID

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

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

General Data Type: NUMBER

REVIEWER_ID

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

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

General Data Type: VARCHAR2

FE_ID

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

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

General Data Type: NUMBER

HAUL_NUMBER

CC ID: 798864
Seq. Order: 4
Data Storage Type: NUMBER
Max Length: 6
Required: No
Primary Key: No
Precision: 0
Scale: 0
Status: Active
Description:

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

General Data Type: NUMBER

BEGIN_TIME

CC ID: 798865
Seq. Order: 5
Data Storage Type: NUMBER
Max Length: 16
Required: No
Primary Key: No
Precision: 16
Scale: 2
Status: Active
Description:

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.

General Data Type: NUMBER

BEGIN_DATE_TIME_UTC

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

UTC translation of BEGIN_TIME

General Data Type: VARCHAR2

BEGIN_YEAR_UTC

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

Extract UTC year from BEGIN_TIME

General Data Type: VARCHAR2

BEGIN_MONTH_UTC

CC ID: 798868
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Extract UTC month from BEGIN_TIME

General Data Type: VARCHAR2

BEGIN_DAY_UTC

CC ID: 798869
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Extract UTC day from BEGIN_TIME

General Data Type: VARCHAR2

BEGIN_TIME_UTC

CC ID: 798870
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Extract UTC time from BEGIN_TIME

General Data Type: VARCHAR2

END_TIME

CC ID: 798871
Seq. Order: 11
Data Storage Type: NUMBER
Max Length: 16
Required: No
Primary Key: No
Precision: 16
Scale: 2
Status: Active
Description:

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.

General Data Type: NUMBER

END_DATE_TIME_UTC

CC ID: 798872
Seq. Order: 12
Data Storage Type: VARCHAR2
Max Length: 19
Required: No
Primary Key: No
Status: Active
Description:

UTC translation of END_TIME

General Data Type: VARCHAR2

END_YEAR_UTC

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

Extract UTC year from END_TIME

General Data Type: VARCHAR2

END_MONTH_UTC

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

Extract UTC month from END_TIME

General Data Type: VARCHAR2

END_DAY_UTC

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

Extract UTC day from END_TIME

General Data Type: VARCHAR2

END_TIME_UTC

CC ID: 798876
Seq. Order: 16
Data Storage Type: VARCHAR2
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Extract UTC time from END_TIME

General Data Type: VARCHAR2

BEGIN_LATITUDE

CC ID: 798877
Seq. Order: 17
Data Storage Type: NUMBER
Max Length: 9
Required: No
Primary Key: No
Precision: 9
Scale: 4
Status: Active
Description:

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.

General Data Type: NUMBER

BEGIN_LONGITUDE

CC ID: 798878
Seq. Order: 18
Data Storage Type: NUMBER
Max Length: 9
Required: No
Primary Key: No
Precision: 9
Scale: 4
Status: Active
Description:

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.

General Data Type: NUMBER

END_LATITUDE

CC ID: 798879
Seq. Order: 19
Data Storage Type: NUMBER
Max Length: 9
Required: No
Primary Key: No
Precision: 9
Scale: 4
Status: Active
Description:

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.

General Data Type: NUMBER

END_LONGITUDE

CC ID: 798880
Seq. Order: 20
Data Storage Type: NUMBER
Max Length: 9
Required: No
Primary Key: No
Precision: 9
Scale: 4
Status: Active
Description:

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.

General Data Type: NUMBER

SENSOR_DETECTION

CC ID: 798881
Seq. Order: 21
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

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.

General Data Type: VARCHAR2

VESSEL_PUMPED_FISH

CC ID: 798882
Seq. Order: 22
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

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.

General Data Type: VARCHAR2

SEE_CODEEND_BUNT_CONTENTS

CC ID: 798883
Seq. Order: 23
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

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.

General Data Type: VARCHAR2

DISCARD_EVENT_OCCURRED

CC ID: 798884
Seq. Order: 24
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

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.

General Data Type: VARCHAR2

TRIPLEX_USED

CC ID: 798885
Seq. Order: 25
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

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.

General Data Type: VARCHAR2

FISH_PUMPED_TO_OTHER_VESSEL

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

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.

General Data Type: VARCHAR2

IMAGE_QUALITY_ASSESSMENT

CC ID: 798887
Seq. Order: 27
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

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.

General Data Type: VARCHAR2

NOTES

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

Comments provided by the reviewer during the video review process.

General Data Type: VARCHAR2

VIDEO_ISSUES_STR

CC ID: 798889
Seq. Order: 29
Data Storage Type: VARCHAR2
Max Length: 200
Required: No
Primary Key: No
Status: Active
Description:

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.

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 54806
GUID: gov.noaa.nmfs.inport:54806
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2018-11-13 16:56+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2018-11-13
Owner Org: NEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2018-11-13
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2019-11-13