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

Summary

Abstract

snapshot table for snapshot OBSINT.EM_OBSINT_OUTPUT_LONGLINE_MV

Description

snapshot table for snapshot OBSINT.EM_OBSINT_OUTPUT_LONGLINE_MV

Entity Information

Entity Type
Data View

Data Attribute / Type Description
VESSEL_NAME
VARCHAR2
Name of the vessel with electronic monitoring equipment.
PERMIT
VARCHAR2
Unique vessel identification number of the vessel with electronic monitoring equipment.
ODDS_TRIP_NUMBER
NUMBER
The generated Observer Declare and Deploy (ODDS) trip number that was created when the trip was logged.
EM_TRIP_NUMBER
NUMBER
Same as the ORIGINAL_EM_TRIP_NUMBER without the alpha characters.
TRIP_START_DATE
DATE
Date/time the trip started as recorded by the electronic monitoring equipment.
EM_HAUL_NUMBER
NUMBER
The unique fishing event number as assigned by the electronic monitoring (EM) reviewer. For longline/snap gear a haul is the start of a buoy retrieved to the end anchor.
EM_GEAR_CODE
NUMBER
The numeric gear code identifying the specific type of gear used by the electronic monitoring (EM) vessel for that haul.
EM_GEAR_TYPE
VARCHAR2
The definition of the numeric EM_GEAR_CODE.
START_HAULING_DATE
DATE
Begin date/time when the haul was retrieved. For longline/snap gear it was the date/time when the buoy marking the start of the line was retrieved.
START_HAULING_LATITUDE_DD
NUMBER
Start latitude position in decimal degrees of where the gear was retrieved. For longline/snap gear it was the latitude of the vessel's position when the buoy marking the start of the line was retrieved.
START_HAULING_LONGITUDE_DD
NUMBER
Start longitude position in decimal degrees of where the gear was retrieved. For longline/snap gear it was the longitude of the vessel's position when the buoy marking the start of the line was retrieved.
END_HAULING_DATE
DATE
End date/time when the haul was retrieved. For longline/snap gear it was the date/time of the vessel when the end anchor came up for that line.
END_HAULING_LATITUDE_DD
NUMBER
End latitude position in decimal degrees where the gear was retrieved. For longline/snap gear it was the latitude of the vessel's position when the end anchor came up for that line.
END_HAULING_LONGITUDE_DD
NUMBER
End longitude position in decimal degrees where the gear was retrieved. For longline/snap gear it was the longitude of the vessel's position when the end anchor came up for that line.
NMFS_AREA
NUMBER
The three-digit National Marine Fisheries Service (NMFS) fishery management area that is assigned during data processing using the end position. If the end position is missing in the raw electronic monitoring data then it is calculated using the start position.
SPECIES_CODE
NUMBER
Observer program species code of fish identified by the electronic monitoring reviewer.
TOTAL_TALLY
NUMBER
Total number of individuals tallied of that species code for that EM_HAUL_NUMBER.
TOTAL_WEIGHT_KG
NUMBER
Total weight in kilograms of each species for that EM_HAUL_NUMBER. Weight is determined by using observer data.
DISPOSITION
VARCHAR2
The fate (Discarded or Retained) of that species code for that EM_HAUL_NUMBER.
ORIGINAL_EM_TRIP_NUMBER
VARCHAR2
Original electronic monitoring (EM) trip number created by the EM reviewer.
FILE_IMPORT_DATE
DATE
The date and time the data was received by the AFSC oracle database.
VESSEL_TYPE
NUMBER
Numeric code number that identifies the type of vessel. Currently only catcher vessels (vessel type 3) carry electronic monitoring equipment.
HAUL_PURPOSE_CODE
VARCHAR2
Haul purpose code of CA (catch accounting) that is need by the Regional office to process the data in the catch accounting system.
TTL_HAULS
NUMBER
The total number of hauls retrieved during the unique trip for that vessel.
TTL_SAMPLED_HAULS
NUMBER
The total number of hauls that were reviewed and sampled by the electronic monitoring reviewer.
IFQ_FLAG
VARCHAR2
Y or N (yes or no) flag that is selected when the vessel operator logs the trip. Y identifies that the vessel operator intends to fish IFQ on this trip and N identifies that vessel operator will not fish IFQ during the trip. This is self reported data.
MULTIPLE_AREA
VARCHAR2
Y or N (yes or no) flag that is selected when the vessel operator logs the trip. Y identifies that the vessel operator will fish in more than one Individual Fishing Quota (IFQ) area during this trip and N identifies that the vessel operator will fish in only a single IFQ area during the trip. This is self-reported data. This column is for NMFS Alaska Regional Office use.
USER_REQST_COVERAGE
VARCHAR2
Y or N (yes or no) flag that is selected when the vessel operator logs a trip that will be an Individual Fishing Quota (IFQ) trip and fishing in multiple IFQ areas. In this specific case then the vessel operator may need observer coverage due to IFQ regulations thus requesting an observer. This column is for NMFS Alaska Regional Office use.
INHERIT_OBSERVER_COVERAGE
VARCHAR2
Y or N (yes or no) flag if the specific trip was selected for observer coverage because the previous selected observer trip was canceled by the vessel operator. This column is for NMFS Alaska Regional Office use.
RANDOM_NUMBER_USED
NUMBER
The specific random number assigned by the Observer Declare and Deploy (ODDS) system when the trip was logged by the vessel operator. This column is for NMFS Alaska Regional Office use.
EFFECTIVE_RATE
NUMBER
Selection rate as defined by the Annual Deployment Plan (ADP) for that year. This column is for NMFS Alaska Regional Office use.

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (AFSC) for inquiries on this record.

Item Identification

Title: View: EM_OBSINT_OUTPUT_LONGLINE_MV
Short Name: EM_OBSINT_OUTPUT_LONGLINE_MV
Status: In Work
Creation Date: 2017-02-01
Abstract:

snapshot table for snapshot OBSINT.EM_OBSINT_OUTPUT_LONGLINE_MV

Purpose:

Video review data equivalent of observer longline data for catch accounting purposes of AKR.

Entity Information

Entity Type: Data View
Active Version?: Yes
Schema Name: OBSINT
Description:

snapshot table for snapshot OBSINT.EM_OBSINT_OUTPUT_LONGLINE_MV

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
VESSEL_NAME VARCHAR2 Name of the vessel with electronic monitoring equipment.
100
Primary Key PERMIT VARCHAR2 Unique vessel identification number of the vessel with electronic monitoring equipment.
100
ODDS_TRIP_NUMBER NUMBER The generated Observer Declare and Deploy (ODDS) trip number that was created when the trip was logged.
100
Primary Key EM_TRIP_NUMBER NUMBER Same as the ORIGINAL_EM_TRIP_NUMBER without the alpha characters.
100
TRIP_START_DATE DATE Date/time the trip started as recorded by the electronic monitoring equipment.
100
Primary Key EM_HAUL_NUMBER NUMBER The unique fishing event number as assigned by the electronic monitoring (EM) reviewer. For longline/snap gear a haul is the start of a buoy retrieved to the end anchor.
100
EM_GEAR_CODE NUMBER The numeric gear code identifying the specific type of gear used by the electronic monitoring (EM) vessel for that haul.
100
EM_GEAR_TYPE VARCHAR2 The definition of the numeric EM_GEAR_CODE.
100
START_HAULING_DATE DATE Begin date/time when the haul was retrieved. For longline/snap gear it was the date/time when the buoy marking the start of the line was retrieved.
100
START_HAULING_LATITUDE_DD NUMBER Start latitude position in decimal degrees of where the gear was retrieved. For longline/snap gear it was the latitude of the vessel's position when the buoy marking the start of the line was retrieved.
100
START_HAULING_LONGITUDE_DD NUMBER Start longitude position in decimal degrees of where the gear was retrieved. For longline/snap gear it was the longitude of the vessel's position when the buoy marking the start of the line was retrieved.
100
END_HAULING_DATE DATE End date/time when the haul was retrieved. For longline/snap gear it was the date/time of the vessel when the end anchor came up for that line.
100
END_HAULING_LATITUDE_DD NUMBER End latitude position in decimal degrees where the gear was retrieved. For longline/snap gear it was the latitude of the vessel's position when the end anchor came up for that line.
100
END_HAULING_LONGITUDE_DD NUMBER End longitude position in decimal degrees where the gear was retrieved. For longline/snap gear it was the longitude of the vessel's position when the end anchor came up for that line.
100
NMFS_AREA NUMBER The three-digit National Marine Fisheries Service (NMFS) fishery management area that is assigned during data processing using the end position. If the end position is missing in the raw electronic monitoring data then it is calculated using the start position.
100
Primary Key SPECIES_CODE NUMBER Observer program species code of fish identified by the electronic monitoring reviewer.
100
TOTAL_TALLY NUMBER Total number of individuals tallied of that species code for that EM_HAUL_NUMBER.
100
TOTAL_WEIGHT_KG NUMBER Total weight in kilograms of each species for that EM_HAUL_NUMBER. Weight is determined by using observer data.
100
Primary Key DISPOSITION VARCHAR2 The fate (Discarded or Retained) of that species code for that EM_HAUL_NUMBER.
100
ORIGINAL_EM_TRIP_NUMBER VARCHAR2 Original electronic monitoring (EM) trip number created by the EM reviewer.
100
FILE_IMPORT_DATE DATE The date and time the data was received by the AFSC oracle database.
100
VESSEL_TYPE NUMBER Numeric code number that identifies the type of vessel. Currently only catcher vessels (vessel type 3) carry electronic monitoring equipment.
100
HAUL_PURPOSE_CODE VARCHAR2 Haul purpose code of CA (catch accounting) that is need by the Regional office to process the data in the catch accounting system.
100
TTL_HAULS NUMBER The total number of hauls retrieved during the unique trip for that vessel.
100
TTL_SAMPLED_HAULS NUMBER The total number of hauls that were reviewed and sampled by the electronic monitoring reviewer.
100
IFQ_FLAG VARCHAR2 Y or N (yes or no) flag that is selected when the vessel operator logs the trip. Y identifies that the vessel operator intends to fish IFQ on this trip and N identifies that vessel operator will not fish IFQ during the trip. This is self reported data.
100
MULTIPLE_AREA VARCHAR2 Y or N (yes or no) flag that is selected when the vessel operator logs the trip. Y identifies that the vessel operator will fish in more than one Individual Fishing Quota (IFQ) area during this trip and N identifies that the vessel operator will fish in only a single IFQ area during the trip. This is self-reported data. This column is for NMFS Alaska Regional Office use.
100
USER_REQST_COVERAGE VARCHAR2 Y or N (yes or no) flag that is selected when the vessel operator logs a trip that will be an Individual Fishing Quota (IFQ) trip and fishing in multiple IFQ areas. In this specific case then the vessel operator may need observer coverage due to IFQ regulations thus requesting an observer. This column is for NMFS Alaska Regional Office use.
100
INHERIT_OBSERVER_COVERAGE VARCHAR2 Y or N (yes or no) flag if the specific trip was selected for observer coverage because the previous selected observer trip was canceled by the vessel operator. This column is for NMFS Alaska Regional Office use.
100
RANDOM_NUMBER_USED NUMBER The specific random number assigned by the Observer Declare and Deploy (ODDS) system when the trip was logged by the vessel operator. This column is for NMFS Alaska Regional Office use.
100
EFFECTIVE_RATE NUMBER Selection rate as defined by the Annual Deployment Plan (ADP) for that year. This column is for NMFS Alaska Regional Office use.

Attribute Details

VESSEL_NAME

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

Name of the vessel with electronic monitoring equipment.

General Data Type: VARCHAR2

PERMIT

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

Unique vessel identification number of the vessel with electronic monitoring equipment.

General Data Type: VARCHAR2

ODDS_TRIP_NUMBER

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

The generated Observer Declare and Deploy (ODDS) trip number that was created when the trip was logged.

General Data Type: NUMBER

EM_TRIP_NUMBER

CC ID: 858086
Seq. Order: 4
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Status: Active
Description:

Same as the ORIGINAL_EM_TRIP_NUMBER without the alpha characters.

General Data Type: NUMBER

TRIP_START_DATE

CC ID: 858087
Seq. Order: 5
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date/time the trip started as recorded by the electronic monitoring equipment.

General Data Type: DATE

EM_HAUL_NUMBER

CC ID: 858088
Seq. Order: 6
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 9
Scale: 0
Status: Active
Description:

The unique fishing event number as assigned by the electronic monitoring (EM) reviewer. For longline/snap gear a haul is the start of a buoy retrieved to the end anchor.

General Data Type: NUMBER

EM_GEAR_CODE

CC ID: 858089
Seq. Order: 7
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Scale: 0
Status: Active
Description:

The numeric gear code identifying the specific type of gear used by the electronic monitoring (EM) vessel for that haul.

General Data Type: NUMBER

EM_GEAR_TYPE

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

The definition of the numeric EM_GEAR_CODE.

General Data Type: VARCHAR2

START_HAULING_DATE

CC ID: 858091
Seq. Order: 9
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Begin date/time when the haul was retrieved. For longline/snap gear it was the date/time when the buoy marking the start of the line was retrieved.

General Data Type: DATE

START_HAULING_LATITUDE_DD

CC ID: 858092
Seq. Order: 10
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 10
Scale: 6
Status: Active
Description:

Start latitude position in decimal degrees of where the gear was retrieved. For longline/snap gear it was the latitude of the vessel's position when the buoy marking the start of the line was retrieved.

General Data Type: NUMBER

START_HAULING_LONGITUDE_DD

CC ID: 858093
Seq. Order: 11
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 11
Scale: 6
Status: Active
Description:

Start longitude position in decimal degrees of where the gear was retrieved. For longline/snap gear it was the longitude of the vessel's position when the buoy marking the start of the line was retrieved.

General Data Type: NUMBER

END_HAULING_DATE

CC ID: 858094
Seq. Order: 12
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

End date/time when the haul was retrieved. For longline/snap gear it was the date/time of the vessel when the end anchor came up for that line.

General Data Type: DATE

END_HAULING_LATITUDE_DD

CC ID: 858095
Seq. Order: 13
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 10
Scale: 6
Status: Active
Description:

End latitude position in decimal degrees where the gear was retrieved. For longline/snap gear it was the latitude of the vessel's position when the end anchor came up for that line.

General Data Type: NUMBER

END_HAULING_LONGITUDE_DD

CC ID: 858096
Seq. Order: 14
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 11
Scale: 6
Status: Active
Description:

End longitude position in decimal degrees where the gear was retrieved. For longline/snap gear it was the longitude of the vessel's position when the end anchor came up for that line.

General Data Type: NUMBER

NMFS_AREA

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

The three-digit National Marine Fisheries Service (NMFS) fishery management area that is assigned during data processing using the end position. If the end position is missing in the raw electronic monitoring data then it is calculated using the start position.

General Data Type: NUMBER

SPECIES_CODE

CC ID: 858098
Seq. Order: 16
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Status: Active
Description:

Observer program species code of fish identified by the electronic monitoring reviewer.

General Data Type: NUMBER

TOTAL_TALLY

CC ID: 858099
Seq. Order: 17
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Total number of individuals tallied of that species code for that EM_HAUL_NUMBER.

General Data Type: NUMBER

TOTAL_WEIGHT_KG

CC ID: 858100
Seq. Order: 18
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Total weight in kilograms of each species for that EM_HAUL_NUMBER. Weight is determined by using observer data.

General Data Type: NUMBER

DISPOSITION

CC ID: 858101
Seq. Order: 19
Data Storage Type: VARCHAR2
Max Length: 25
Required: Yes
Primary Key: Yes
Status: Active
Description:

The fate (Discarded or Retained) of that species code for that EM_HAUL_NUMBER.

General Data Type: VARCHAR2

ORIGINAL_EM_TRIP_NUMBER

CC ID: 858102
Seq. Order: 20
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

Original electronic monitoring (EM) trip number created by the EM reviewer.

General Data Type: VARCHAR2

FILE_IMPORT_DATE

CC ID: 858103
Seq. Order: 21
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

The date and time the data was received by the AFSC oracle database.

General Data Type: DATE

VESSEL_TYPE

CC ID: 858104
Seq. Order: 22
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 0
Status: Active
Description:

Numeric code number that identifies the type of vessel. Currently only catcher vessels (vessel type 3) carry electronic monitoring equipment.

General Data Type: NUMBER

HAUL_PURPOSE_CODE

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

Haul purpose code of CA (catch accounting) that is need by the Regional office to process the data in the catch accounting system.

General Data Type: VARCHAR2

TTL_HAULS

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

The total number of hauls retrieved during the unique trip for that vessel.

General Data Type: NUMBER

TTL_SAMPLED_HAULS

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

The total number of hauls that were reviewed and sampled by the electronic monitoring reviewer.

General Data Type: NUMBER

IFQ_FLAG

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

Y or N (yes or no) flag that is selected when the vessel operator logs the trip. Y identifies that the vessel operator intends to fish IFQ on this trip and N identifies that vessel operator will not fish IFQ during the trip. This is self reported data.

General Data Type: VARCHAR2

MULTIPLE_AREA

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

Y or N (yes or no) flag that is selected when the vessel operator logs the trip. Y identifies that the vessel operator will fish in more than one Individual Fishing Quota (IFQ) area during this trip and N identifies that the vessel operator will fish in only a single IFQ area during the trip. This is self-reported data. This column is for NMFS Alaska Regional Office use.

General Data Type: VARCHAR2

USER_REQST_COVERAGE

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

Y or N (yes or no) flag that is selected when the vessel operator logs a trip that will be an Individual Fishing Quota (IFQ) trip and fishing in multiple IFQ areas. In this specific case then the vessel operator may need observer coverage due to IFQ regulations thus requesting an observer. This column is for NMFS Alaska Regional Office use.

General Data Type: VARCHAR2

INHERIT_OBSERVER_COVERAGE

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

Y or N (yes or no) flag if the specific trip was selected for observer coverage because the previous selected observer trip was canceled by the vessel operator. This column is for NMFS Alaska Regional Office use.

General Data Type: VARCHAR2

RANDOM_NUMBER_USED

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

The specific random number assigned by the Observer Declare and Deploy (ODDS) system when the trip was logged by the vessel operator. This column is for NMFS Alaska Regional Office use.

General Data Type: NUMBER

EFFECTIVE_RATE

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

Selection rate as defined by the Annual Deployment Plan (ADP) for that year. This column is for NMFS Alaska Regional Office use.

General Data Type: NUMBER

Catalog Details

Catalog Item ID: 56771
GUID: gov.noaa.nmfs.inport:56771
Metadata Record Created By: Renold E Narita
Metadata Record Created: 2019-06-28 19:48+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2019-09-13
Owner Org: AFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2019-09-13
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2020-09-13