Metadata Rubric

100%

6 / 6

Alaska Fisheries Science Center Metadata Librar... > Fisheries Management and Analysis Division > Electronic Monitoring > AFSC/FMA/Electronic Monitoring (EM) Data Transf... >

View: EM_OBSINT_OUTPUT_POT_MV

Entity (ENT) | Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:56772 | Updated: August 9, 2022 | Published / External

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

snapshot table for snapshot OBSINT.EM_OBSINT_OUTPUT_POT_MV

Description

snapshot table for snapshot OBSINT.EM_OBSINT_OUTPUT_POT_MV

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 pot gear a haul is a single pot.
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 pot gear it was the date/time when the buoy of the individual pot was retrieved.
START_HAULING_LATITUDE_DD NUMBER	Start latitude position in decimal degrees where the gear was retrieved. For pot gear it was the latitude of the vessel's position when the buoy of the individual pot was retrieved.
START_HAULING_LONGITUDE_DD NUMBER	Start longitude position in decimal degrees where the gear was retrieved. For pot gear it was the longitude of the vessel's position when the buoy of the individual pot was retrieved.
END_HAULING_DATE DATE	End date/time when the haul was retrieved. For pot gear it was when the pot was retrieved and placed on the launcher.
END_HAULING_LATITUDE_DD NUMBER	End latitude position in decimal degrees where the gear was retrieved. For pot gear it was the latitude of the vessel's position when the pot was retrieved and placed on the launcher.
END_HAULING_LONGITUDE_DD NUMBER	End longitude position in decimal degrees where the gear was retrieved. For pot gear it was the longitude of the vessel's position when the pot was retrieved and placed on the launcher.
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 needed by the Regional office to process the data in the catch accounting system.
TTL_HAULS NUMBER	Total weight in kilograms of each species for that EM_HAUL_NUMBER. Weight is determined by using observer data.
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.

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 pot gear a haul is a single pot.

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 pot gear it was the date/time when the buoy of the individual pot was retrieved.

START_HAULING_LATITUDE_DD
NUMBER

Start latitude position in decimal degrees where the gear was retrieved. For pot gear it was the latitude of the vessel's position when the buoy of the individual pot was retrieved.

START_HAULING_LONGITUDE_DD
NUMBER

Start longitude position in decimal degrees where the gear was retrieved. For pot gear it was the longitude of the vessel's position when the buoy of the individual pot was retrieved.

END_HAULING_DATE
DATE

End date/time when the haul was retrieved. For pot gear it was when the pot was retrieved and placed on the launcher.

END_HAULING_LATITUDE_DD
NUMBER

End latitude position in decimal degrees where the gear was retrieved. For pot gear it was the latitude of the vessel's position when the pot was retrieved and placed on the launcher.

END_HAULING_LONGITUDE_DD
NUMBER

End longitude position in decimal degrees where the gear was retrieved. For pot gear it was the longitude of the vessel's position when the pot was retrieved and placed on the launcher.

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 needed by the Regional office to process the data in the catch accounting system.

TTL_HAULS
NUMBER

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

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.

No Child Items for this record.

No contact information is available for this record.

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

Title:	View: EM_OBSINT_OUTPUT_POT_MV
Short Name:	EM_OBSINT_OUTPUT_POT_MV
Status:	Completed
Creation Date:	2017-02-20
Abstract:	snapshot table for snapshot OBSINT.EM_OBSINT_OUTPUT_POT_MV
Purpose:	Video review data equivalent of observer pot data for catch accounting purposes of AKR.

Entity Type:	Data View
Active Version?:	Yes
Schema Name:	OBSINT
Description:	snapshot table for snapshot OBSINT.EM_OBSINT_OUTPUT_POT_MV

Attribute Summary

	Name	Type	Description
100	VESSEL_NAME	VARCHAR2	Name of the vessel with electronic monitoring equipment.
100	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	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	EM_HAUL_NUMBER	NUMBER	The unique fishing event number as assigned by the electronic monitoring (EM) reviewer. For pot gear a haul is a single pot.
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 pot gear it was the date/time when the buoy of the individual pot was retrieved.
100	START_HAULING_LATITUDE_DD	NUMBER	Start latitude position in decimal degrees where the gear was retrieved. For pot gear it was the latitude of the vessel's position when the buoy of the individual pot was retrieved.
100	START_HAULING_LONGITUDE_DD	NUMBER	Start longitude position in decimal degrees where the gear was retrieved. For pot gear it was the longitude of the vessel's position when the buoy of the individual pot was retrieved.
100	END_HAULING_DATE	DATE	End date/time when the haul was retrieved. For pot gear it was when the pot was retrieved and placed on the launcher.
100	END_HAULING_LATITUDE_DD	NUMBER	End latitude position in decimal degrees where the gear was retrieved. For pot gear it was the latitude of the vessel's position when the pot was retrieved and placed on the launcher.
100	END_HAULING_LONGITUDE_DD	NUMBER	End longitude position in decimal degrees where the gear was retrieved. For pot gear it was the longitude of the vessel's position when the pot was retrieved and placed on the launcher.
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	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	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 needed by the Regional office to process the data in the catch accounting system.
100	TTL_HAULS	NUMBER	Total weight in kilograms of each species for that EM_HAUL_NUMBER. Weight is determined by using observer data.
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.

Name

Type

Description

100

VESSEL_NAME

VARCHAR2

Name of the vessel with electronic monitoring equipment.

100

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

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

EM_HAUL_NUMBER

NUMBER

The unique fishing event number as assigned by the electronic monitoring (EM) reviewer. For pot gear a haul is a single pot.

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 pot gear it was the date/time when the buoy of the individual pot was retrieved.

100

START_HAULING_LATITUDE_DD

NUMBER

Start latitude position in decimal degrees where the gear was retrieved. For pot gear it was the latitude of the vessel's position when the buoy of the individual pot was retrieved.

100

START_HAULING_LONGITUDE_DD

NUMBER

Start longitude position in decimal degrees where the gear was retrieved. For pot gear it was the longitude of the vessel's position when the buoy of the individual pot was retrieved.

100

END_HAULING_DATE

DATE

End date/time when the haul was retrieved. For pot gear it was when the pot was retrieved and placed on the launcher.

100

END_HAULING_LATITUDE_DD

NUMBER

End latitude position in decimal degrees where the gear was retrieved. For pot gear it was the latitude of the vessel's position when the pot was retrieved and placed on the launcher.

100

END_HAULING_LONGITUDE_DD

NUMBER

End longitude position in decimal degrees where the gear was retrieved. For pot gear it was the longitude of the vessel's position when the pot was retrieved and placed on the launcher.

100

NMFS_AREA

NUMBER

100

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

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 needed by the Regional office to process the data in the catch accounting system.

100

TTL_HAULS

NUMBER

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

100

TTL_SAMPLED_HAULS

NUMBER

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

100

IFQ_FLAG

VARCHAR2

100

MULTIPLE_AREA

VARCHAR2

100

USER_REQST_COVERAGE

VARCHAR2

100

INHERIT_OBSERVER_COVERAGE

VARCHAR2

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: 858114

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: 858115

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: 858116

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: 858117

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: 858118

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: 858119

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 pot gear a haul is a single pot.
General Data Type:	NUMBER

EM_GEAR_CODE

CC ID: 858120

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: 858121

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: 858122

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 pot gear it was the date/time when the buoy of the individual pot was retrieved.
General Data Type:	DATE

START_HAULING_LATITUDE_DD

CC ID: 858123

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 where the gear was retrieved. For pot gear it was the latitude of the vessel's position when the buoy of the individual pot was retrieved.
General Data Type:	NUMBER

START_HAULING_LONGITUDE_DD

CC ID: 858124

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 where the gear was retrieved. For pot gear it was the longitude of the vessel's position when the buoy of the individual pot was retrieved.
General Data Type:	NUMBER

END_HAULING_DATE

CC ID: 858125

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 pot gear it was when the pot was retrieved and placed on the launcher.
General Data Type:	DATE

END_HAULING_LATITUDE_DD

CC ID: 858126

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 pot gear it was the latitude of the vessel's position when the pot was retrieved and placed on the launcher.
General Data Type:	NUMBER

END_HAULING_LONGITUDE_DD

CC ID: 858127

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 pot gear it was the longitude of the vessel's position when the pot was retrieved and placed on the launcher.
General Data Type:	NUMBER

NMFS_AREA

CC ID: 858128

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: 858129

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: 858130

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: 858131

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: 858132

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: 858133

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: 858134

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: 858135

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: 858136

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 needed by the Regional office to process the data in the catch accounting system.
General Data Type:	VARCHAR2

TTL_HAULS

CC ID: 858137

Seq. Order:	24
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	0
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

TTL_SAMPLED_HAULS

CC ID: 858138

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: 858139

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: 858140

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: 858141

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: 858142

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: 858143

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: 858144

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 Item ID:	56772
GUID:	gov.noaa.nmfs.inport:56772
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

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

VESSEL_NAME

PERMIT

ODDS_TRIP_NUMBER

EM_TRIP_NUMBER

TRIP_START_DATE

EM_HAUL_NUMBER

EM_GEAR_CODE

EM_GEAR_TYPE

START_HAULING_DATE

START_HAULING_LATITUDE_DD

START_HAULING_LONGITUDE_DD

END_HAULING_DATE

END_HAULING_LATITUDE_DD

END_HAULING_LONGITUDE_DD

NMFS_AREA

SPECIES_CODE

TOTAL_TALLY

TOTAL_WEIGHT_KG

DISPOSITION

ORIGINAL_EM_TRIP_NUMBER

FILE_IMPORT_DATE

VESSEL_TYPE

HAUL_PURPOSE_CODE

TTL_HAULS

TTL_SAMPLED_HAULS

IFQ_FLAG

MULTIPLE_AREA

USER_REQST_COVERAGE

INHERIT_OBSERVER_COVERAGE

RANDOM_NUMBER_USED

EFFECTIVE_RATE

Catalog Details