Table: ATLW_HAUL

Alaska Fisheries Science Center
Entity (ENT) | ID: 9619 | Published / External
Created: 2009-06-30 | Last Modified: 2022-08-09

Parent: AFSC/FMA/North Pacific Groundfish and Halibut Observer Program, Post 2008 Fishery Statistics.
Data Set (DS) | ID: 7284

ID: 9619
Entity (ENT)

* Discovery
• First Pass
» Metadata Rubric

Item Identification

* » Title	Table: ATLW_HAUL
Short Name	ATLW_HAUL
* Status	Completed
Creation Date
Revision Date
• Publication Date
* » Abstract	Hauls are unique fishing events of gear deployment and retrieval and may also contain information unique to a day where no fishing occured.
* Purpose
Notes	Loaded by batch 2390, 06-30-2009 16:11
Other Citation Details
• Supplemental Information
DOI (Digital Object Identifier)
DOI Registration Authority
DOI Issue Date

Keywords

Theme Keywords

Thesaurus	Keyword

Temporal Keywords

Thesaurus	Keyword

* Spatial Keywords

Thesaurus	Keyword

Stratum Keywords

Thesaurus	Keyword

Instrument Keywords

Thesaurus	Keyword

Platform Keywords

Thesaurus	Keyword

Physical Location

• » Organization
• » City
• » State/Province
• Country
• » Location Description

Entity Information

Entity Type	Data Table
Active Version?	Y
Alias
Schema Name	NORPAC
» Description	Hauls are unique fishing events of gear deployment and retrieval and may also contain information unique to a day where no fishing occured.
Change Summary

Data Attributes

Attribute Summary

Score	Req'd?	PKey?	» Name	Data Storage Type	Description
100	Yes	Yes	RECORD_SET_STATUS_SEQ	NUMBER	Sequence generated unique identifier of a record set header
100	Yes	Yes	CRUISE	NUMBER	Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record.
100	Yes	Yes	HAUL_SEQ	NUMBER	Sequence generated unique identifier for a haul record
100	Yes	No	HAUL_NUMBER	NUMBER	Number which is entered by the observer identifying a unique haul within a trip. Since records are not physically deleted, trigger code preserves uniqueness by allowing only a single active record to exist (delete_marker IS NOT NULL).
100	Yes	No	HAUL_PURPOSE_CODE	VARCHAR2	Haul data may be utilized for catch accounting, stock assessment, or for various special projects. This field is entered by the observer and not validated by ATLAS. Validation is performed when loaded into the production NORPAC data set.
100	No	No	CDQ_CODE	VARCHAR2	Unique AlphaNumeric code representing a CDQ or research group
100	Yes	No	TRIP_SEQ	NUMBER	Sequence generated unique identifier of a trip
100	No	No	DELIVERY_VESSEL_ADFG	VARCHAR2	ADFG number entered by the observer if the delivering vessel does not exist in the vessel lookup table.
100	Yes	No	GEAR_PERFORMANCE_CODE	NUMBER	Unique performance code for a gear type.
100	Yes	No	RBT_CODE	VARCHAR2	Currently limted to Y (es) or N(o)
100	Yes	No	VESSEL_TYPE	NUMBER	Unique identifier of a vessel type
100	Yes	No	GEARTYPE_FORM	VARCHAR2	Form that the gear is valid for. For example the gear may be Unknown for a delivery but will always be determined for a haul.
100	Yes	No	GEAR_TYPE_CODE	NUMBER	Numeric value from Norpac Domestic Gear that combined with the Form defines the unique identifier for a gear record
67	No	No	RST_CODE	VARCHAR2
100	No	No	DETERRENCE_CODE	VARCHAR2	Deterrence code from NORPAC bird or mammal deterance tables
100	No	No	ANIMAL_TYPE_CODE	VARCHAR2	Optional FK from LOV_Deterrence. Class of animal mammal (M), bird (B) for which the deterrence (if it exists) was utilized
100	Yes	No	LOCATION_CODE	VARCHAR2	Identifies whether the information in a haul is based on retrieval or delivery (as in a mother ship)
100	Yes	No	RETRV_DATE_TIME	DATE	Date and time recorded by the observer from the vessel log.
100	Yes	No	RETRV_LATITUDE_DEGREES	NUMBER	Location of gear retrieval.
100	Yes	No	RETRV_LATITUDE_MINUTES	NUMBER	Location of gear retrieval.
100	No	No	RETRV_LATITUDE_SECONDS	NUMBER	Location of gear retrieval.
100	Yes	No	RETRV_EW	VARCHAR2	Location of gear retrieval.
100	Yes	No	RETRV_LONGITUDE_DEGREES	NUMBER	Location of gear retrieval.
100	Yes	No	RETRV_LONGITUDE_MINUTES	NUMBER	Location of gear retrieval.
100	No	No	RETRV_LONGITUDE_SECONDS	NUMBER	Location of gear retrieval.
100	No	No	DEPLOY_DATE_TIME	DATE	Date and time recorded by the observer from the vessel log.
100	No	No	DEPLOY_LATITUDE_DEGREES	NUMBER	Location of gear deployment.
100	No	No	DEPLOY_LATITUDE_MINUTES	NUMBER	Location of gear deployment.
100	No	No	DEPLOY_LATITUDE_SECONDS	NUMBER	Location of gear deployment.
100	No	No	DEPLOY_EW	VARCHAR2	Location of gear deployment.
100	No	No	DEPLOY_LONGITUDE_DEGREES	NUMBER	Location of gear deployment.
100	No	No	DEPLOY_LONGITUDE_MINUTES	NUMBER	Location of gear deployment.
100	No	No	DEPLOY_LONGITUDE_SECONDS	NUMBER	Location of gear deployment.
100	No	No	BOTTOM_DEPTH	NUMBER	Average bottom depth recorded by the observer from the vessel log.
100	No	No	FISHING_DEPTH	NUMBER	Average fishing depth recorded by the observer from the vessel log.
100	No	No	DEPTH_METER_FATHOM	VARCHAR2	Identifies whether depth is recorded in meters or fathoms.
100	No	No	VESSEL_EST_CATCH	NUMBER	Total catch weight in metric tons as recorded in the vessel log.
100	No	No	OBSVR_EST_CATCH	NUMBER	Total catch weight as estimated by the observer in metric tons.
100	No	No	OBSVR_EST_METHOD	VARCHAR2	Method used to determine the observer estimated catch
100	No	No	OBSVR_EST_DISCARDS	NUMBER	Observer estimate of total discards
100	No	No	DENSITY	NUMBER	Density used by the observer to determine the total catch weights.
100	Yes	No	INDIV_FISHING_QUOTA_FLAG	VARCHAR2	Identifies whether fishing is on an IFQ quota with the subsequent application of IFQ rules.
100	Yes	No	SAMPLED_BY	NUMBER	Identifies where a haul is sampled by an observer and in some cases by which observer.
100	No	No	NUMBER_OF_SKATES	NUMBER	Number of skates for longline fishing.
100	No	No	NUMBER_OF_HOOKS_PER_SKATE	NUMBER	Number of hooks per skate for longline fishing.
100	No	No	TOTAL_HOOKS	NUMBER	Total number of hooks deployed for this haul
100	No	No	TOTAL_POTS	NUMBER	Total number of pots deployed for this haul.
100	No	No	MMAMMAL_MONITR_PCT	NUMBER	Percentage of time for this haul where marine mammal monitoring occured. For fixed gear deployments the valid values are anywhere in the range. For mobile gear deployments the values may be either 0 or 100.
100	Yes	Yes	PERMIT	VARCHAR2	Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau
100	No	No	VOLUME	NUMBER	Estimate of volume of catch
100	No	No	TOTAL_HOOKS_OVERIDE_FLAG	VARCHAR2	If an observer believes that the calculated value of total hooks is not correct. It is allowed that the value is overridden. If that is the case then this flag will be set to Y by trigger code, and total-hooks will be protected from automatic recalculateion.
100	No	No	BIRD_MONITOR_LEVEL_CODE	VARCHAR2	Portion of the haulback that was monitored by the observer for bird interactions.
100	Yes	No	SHORTWIRED_FLAG	VARCHAR2	Denoting whether the net was shortwired during the haulback. Do not record a Y when the net is shortwired during the tow but then returned to fishing depth.
100	No	No	SAMPLE_UNIT_CODE	VARCHAR2	Unique code identifying the unit of measure for a sampling design. Sample Design and units are mandatory at the haul level and optional at the sample level.
100	No	No	SAMPLE_SYSTEM_CODE	NUMBER	Unique numeric identifier of a sample coding system.

Attribute Details

Attribute Name	RECORD_SET_STATUS_SEQ
Seq. Order	1
Data Storage Type	NUMBER
Max Length	22
Min Length
Required	Yes
Primary Key	Yes
Precision	9
Scale	0
Status	Active
Description	Sequence generated unique identifier of a record set header
General Data Type	NUMBER
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	CRUISE
Seq. Order	2
Data Storage Type	NUMBER
Max Length	22
Min Length
Required	Yes
Primary Key	Yes
Precision	8
Scale	0
Status	Active
Description	Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record.
General Data Type	NUMBER
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	HAUL_SEQ
Seq. Order	3
Data Storage Type	NUMBER
Max Length	22
Min Length
Required	Yes
Primary Key	Yes
Precision	9
Scale	0
Status	Active
Description	Sequence generated unique identifier for a haul record
General Data Type	NUMBER
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	HAUL_NUMBER
Seq. Order	4
Data Storage Type	NUMBER
Max Length	22
Min Length
Required	Yes
Primary Key	No
Precision	6
Scale	0
Status	Active
Description	Number which is entered by the observer identifying a unique haul within a trip. Since records are not physically deleted, trigger code preserves uniqueness by allowing only a single active record to exist (delete_marker IS NOT NULL).
General Data Type	NUMBER
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	HAUL_PURPOSE_CODE
Seq. Order	5
Data Storage Type	VARCHAR2
Max Length	3
Min Length
Required	Yes
Primary Key	No
Precision
Scale
Status	Active
Description	Haul data may be utilized for catch accounting, stock assessment, or for various special projects. This field is entered by the observer and not validated by ATLAS. Validation is performed when loaded into the production NORPAC data set.
General Data Type	VARCHAR2
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	CDQ_CODE
Seq. Order	6
Data Storage Type	VARCHAR2
Max Length	3
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Unique AlphaNumeric code representing a CDQ or research group
General Data Type	VARCHAR2
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	TRIP_SEQ
Seq. Order	7
Data Storage Type	NUMBER
Max Length	22
Min Length
Required	Yes
Primary Key	No
Precision	9
Scale	0
Status	Active
Description	Sequence generated unique identifier of a trip
General Data Type	NUMBER
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	DELIVERY_VESSEL_ADFG
Seq. Order	8
Data Storage Type	VARCHAR2
Max Length	6
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	ADFG number entered by the observer if the delivering vessel does not exist in the vessel lookup table.
General Data Type	VARCHAR2
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	GEAR_PERFORMANCE_CODE
Seq. Order	9
Data Storage Type	NUMBER
Max Length	22
Min Length
Required	Yes
Primary Key	No
Precision	38
Scale
Status	Active
Description	Unique performance code for a gear type.
General Data Type	NUMBER
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	RBT_CODE
Seq. Order	10
Data Storage Type	VARCHAR2
Max Length	1
Min Length
Required	Yes
Primary Key	No
Precision
Scale
Status	Active
Description	Currently limted to Y (es) or N(o)
General Data Type	VARCHAR2
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	VESSEL_TYPE
Seq. Order	11
Data Storage Type	NUMBER
Max Length	22
Min Length
Required	Yes
Primary Key	No
Precision	38
Scale
Status	Active
Description	Unique identifier of a vessel type
General Data Type	NUMBER
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	GEARTYPE_FORM
Seq. Order	12
Data Storage Type	VARCHAR2
Max Length	1
Min Length
Required	Yes
Primary Key	No
Precision
Scale
Status	Active
Description	Form that the gear is valid for. For example the gear may be Unknown for a delivery but will always be determined for a haul.
General Data Type	VARCHAR2
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	GEAR_TYPE_CODE
Seq. Order	13
Data Storage Type	NUMBER
Max Length	22
Min Length
Required	Yes
Primary Key	No
Precision	38
Scale
Status	Active
Description	Numeric value from Norpac Domestic Gear that combined with the Form defines the unique identifier for a gear record
General Data Type	NUMBER
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	RST_CODE
Seq. Order	14
Data Storage Type	VARCHAR2
Max Length	1
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description
General Data Type	VARCHAR2
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	DETERRENCE_CODE
Seq. Order	15
Data Storage Type	VARCHAR2
Max Length	2
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Deterrence code from NORPAC bird or mammal deterance tables
General Data Type	VARCHAR2
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	ANIMAL_TYPE_CODE
Seq. Order	16
Data Storage Type	VARCHAR2
Max Length	1
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Optional FK from LOV_Deterrence. Class of animal mammal (M), bird (B) for which the deterrence (if it exists) was utilized
General Data Type	VARCHAR2
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	LOCATION_CODE
Seq. Order	17
Data Storage Type	VARCHAR2
Max Length	1
Min Length
Required	Yes
Primary Key	No
Precision
Scale
Status	Active
Description	Identifies whether the information in a haul is based on retrieval or delivery (as in a mother ship)
General Data Type	VARCHAR2
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	RETRV_DATE_TIME
Seq. Order	18
Data Storage Type	DATE
Max Length	7
Min Length
Required	Yes
Primary Key	No
Precision
Scale
Status	Active
Description	Date and time recorded by the observer from the vessel log.
General Data Type	DATE
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	RETRV_LATITUDE_DEGREES
Seq. Order	19
Data Storage Type	NUMBER
Max Length	22
Min Length
Required	Yes
Primary Key	No
Precision	2
Scale	0
Status	Active
Description	Location of gear retrieval.
General Data Type	NUMBER
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	RETRV_LATITUDE_MINUTES
Seq. Order	20
Data Storage Type	NUMBER
Max Length	22
Min Length
Required	Yes
Primary Key	No
Precision	2
Scale	0
Status	Active
Description	Location of gear retrieval.
General Data Type	NUMBER
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	RETRV_LATITUDE_SECONDS
Seq. Order	21
Data Storage Type	NUMBER
Max Length	22
Min Length
Required	No
Primary Key	No
Precision	2
Scale	0
Status	Active
Description	Location of gear retrieval.
General Data Type	NUMBER
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	RETRV_EW
Seq. Order	22
Data Storage Type	VARCHAR2
Max Length	1
Min Length
Required	Yes
Primary Key	No
Precision
Scale
Status	Active
Description	Location of gear retrieval.
General Data Type	VARCHAR2
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	RETRV_LONGITUDE_DEGREES
Seq. Order	23
Data Storage Type	NUMBER
Max Length	22
Min Length
Required	Yes
Primary Key	No
Precision	3
Scale	0
Status	Active
Description	Location of gear retrieval.
General Data Type	NUMBER
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	RETRV_LONGITUDE_MINUTES
Seq. Order	24
Data Storage Type	NUMBER
Max Length	22
Min Length
Required	Yes
Primary Key	No
Precision	2
Scale	0
Status	Active
Description	Location of gear retrieval.
General Data Type	NUMBER
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	RETRV_LONGITUDE_SECONDS
Seq. Order	25
Data Storage Type	NUMBER
Max Length	22
Min Length
Required	No
Primary Key	No
Precision	2
Scale	0
Status	Active
Description	Location of gear retrieval.
General Data Type	NUMBER
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	DEPLOY_DATE_TIME
Seq. Order	26
Data Storage Type	DATE
Max Length	7
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Date and time recorded by the observer from the vessel log.
General Data Type	DATE
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	DEPLOY_LATITUDE_DEGREES
Seq. Order	27
Data Storage Type	NUMBER
Max Length	22
Min Length
Required	No
Primary Key	No
Precision	2
Scale	0
Status	Active
Description	Location of gear deployment.
General Data Type	NUMBER
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	DEPLOY_LATITUDE_MINUTES
Seq. Order	28
Data Storage Type	NUMBER
Max Length	22
Min Length
Required	No
Primary Key	No
Precision	2
Scale	0
Status	Active
Description	Location of gear deployment.
General Data Type	NUMBER
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	DEPLOY_LATITUDE_SECONDS
Seq. Order	29
Data Storage Type	NUMBER
Max Length	22
Min Length
Required	No
Primary Key	No
Precision	2
Scale	0
Status	Active
Description	Location of gear deployment.
General Data Type	NUMBER
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	DEPLOY_EW
Seq. Order	30
Data Storage Type	VARCHAR2
Max Length	1
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Location of gear deployment.
General Data Type	VARCHAR2
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	DEPLOY_LONGITUDE_DEGREES
Seq. Order	31
Data Storage Type	NUMBER
Max Length	22
Min Length
Required	No
Primary Key	No
Precision	3
Scale	0
Status	Active
Description	Location of gear deployment.
General Data Type	NUMBER
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	DEPLOY_LONGITUDE_MINUTES
Seq. Order	32
Data Storage Type	NUMBER
Max Length	22
Min Length
Required	No
Primary Key	No
Precision	2
Scale	0
Status	Active
Description	Location of gear deployment.
General Data Type	NUMBER
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	DEPLOY_LONGITUDE_SECONDS
Seq. Order	33
Data Storage Type	NUMBER
Max Length	22
Min Length
Required	No
Primary Key	No
Precision	2
Scale	0
Status	Active
Description	Location of gear deployment.
General Data Type	NUMBER
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	BOTTOM_DEPTH
Seq. Order	34
Data Storage Type	NUMBER
Max Length	22
Min Length
Required	No
Primary Key	No
Precision	5
Scale	0
Status	Active
Description	Average bottom depth recorded by the observer from the vessel log.
General Data Type	NUMBER
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	FISHING_DEPTH
Seq. Order	35
Data Storage Type	NUMBER
Max Length	22
Min Length
Required	No
Primary Key	No
Precision	5
Scale	0
Status	Active
Description	Average fishing depth recorded by the observer from the vessel log.
General Data Type	NUMBER
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	DEPTH_METER_FATHOM
Seq. Order	36
Data Storage Type	VARCHAR2
Max Length	1
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Identifies whether depth is recorded in meters or fathoms.
General Data Type	VARCHAR2
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	VESSEL_EST_CATCH
Seq. Order	37
Data Storage Type	NUMBER
Max Length	22
Min Length
Required	No
Primary Key	No
Precision	6
Scale	2
Status	Active
Description	Total catch weight in metric tons as recorded in the vessel log.
General Data Type	NUMBER
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	OBSVR_EST_CATCH
Seq. Order	38
Data Storage Type	NUMBER
Max Length	22
Min Length
Required	No
Primary Key	No
Precision	6
Scale	2
Status	Active
Description	Total catch weight as estimated by the observer in metric tons.
General Data Type	NUMBER
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	OBSVR_EST_METHOD
Seq. Order	39
Data Storage Type	VARCHAR2
Max Length	1
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Method used to determine the observer estimated catch
General Data Type	VARCHAR2
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	OBSVR_EST_DISCARDS
Seq. Order	40
Data Storage Type	NUMBER
Max Length	22
Min Length
Required	No
Primary Key	No
Precision	6
Scale	2
Status	Active
Description	Observer estimate of total discards
General Data Type	NUMBER
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	DENSITY
Seq. Order	41
Data Storage Type	NUMBER
Max Length	22
Min Length
Required	No
Primary Key	No
Precision	3
Scale	2
Status	Active
Description	Density used by the observer to determine the total catch weights.
General Data Type	NUMBER
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	INDIV_FISHING_QUOTA_FLAG
Seq. Order	42
Data Storage Type	VARCHAR2
Max Length	1
Min Length
Required	Yes
Primary Key	No
Precision
Scale
Status	Active
Description	Identifies whether fishing is on an IFQ quota with the subsequent application of IFQ rules.
General Data Type	VARCHAR2
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	SAMPLED_BY
Seq. Order	43
Data Storage Type	NUMBER
Max Length	22
Min Length
Required	Yes
Primary Key	No
Precision	38
Scale
Status	Active
Description	Identifies where a haul is sampled by an observer and in some cases by which observer.
General Data Type	NUMBER
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	NUMBER_OF_SKATES
Seq. Order	44
Data Storage Type	NUMBER
Max Length	22
Min Length
Required	No
Primary Key	No
Precision	4
Scale	2
Status	Active
Description	Number of skates for longline fishing.
General Data Type	NUMBER
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	NUMBER_OF_HOOKS_PER_SKATE
Seq. Order	45
Data Storage Type	NUMBER
Max Length	22
Min Length
Required	No
Primary Key	No
Precision	4
Scale	0
Status	Active
Description	Number of hooks per skate for longline fishing.
General Data Type	NUMBER
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	TOTAL_HOOKS
Seq. Order	46
Data Storage Type	NUMBER
Max Length	22
Min Length
Required	No
Primary Key	No
Precision	6
Scale	0
Status	Active
Description	Total number of hooks deployed for this haul
General Data Type	NUMBER
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	TOTAL_POTS
Seq. Order	47
Data Storage Type	NUMBER
Max Length	22
Min Length
Required	No
Primary Key	No
Precision	5
Scale	0
Status	Active
Description	Total number of pots deployed for this haul.
General Data Type	NUMBER
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	MMAMMAL_MONITR_PCT
Seq. Order	48
Data Storage Type	NUMBER
Max Length	22
Min Length
Required	No
Primary Key	No
Precision	3
Scale	0
Status	Active
Description	Percentage of time for this haul where marine mammal monitoring occured. For fixed gear deployments the valid values are anywhere in the range. For mobile gear deployments the values may be either 0 or 100.
General Data Type	NUMBER
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	PERMIT
Seq. Order	49
Data Storage Type	VARCHAR2
Max Length	6
Min Length
Required	Yes
Primary Key	Yes
Precision
Scale
Status	Active
Description	Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau
General Data Type	VARCHAR2
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	VOLUME
Seq. Order	50
Data Storage Type	NUMBER
Max Length	22
Min Length
Required	No
Primary Key	No
Precision	6
Scale	2
Status	Active
Description	Estimate of volume of catch
General Data Type	NUMBER
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	TOTAL_HOOKS_OVERIDE_FLAG
Seq. Order	51
Data Storage Type	VARCHAR2
Max Length	1
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	If an observer believes that the calculated value of total hooks is not correct. It is allowed that the value is overridden. If that is the case then this flag will be set to Y by trigger code, and total-hooks will be protected from automatic recalculateion.
General Data Type	VARCHAR2
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	BIRD_MONITOR_LEVEL_CODE
Seq. Order	52
Data Storage Type	VARCHAR2
Max Length	4
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Portion of the haulback that was monitored by the observer for bird interactions.
General Data Type	VARCHAR2
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	SHORTWIRED_FLAG
Seq. Order	53
Data Storage Type	VARCHAR2
Max Length	1
Min Length
Required	Yes
Primary Key	No
Precision
Scale
Status	Active
Description	Denoting whether the net was shortwired during the haulback. Do not record a Y when the net is shortwired during the tow but then returned to fishing depth.
General Data Type	VARCHAR2
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	SAMPLE_UNIT_CODE
Seq. Order	54
Data Storage Type	VARCHAR2
Max Length	6
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Unique code identifying the unit of measure for a sampling design. Sample Design and units are mandatory at the haul level and optional at the sample level.
General Data Type	VARCHAR2
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	SAMPLE_SYSTEM_CODE
Seq. Order	55
Data Storage Type	NUMBER
Max Length	22
Min Length
Required	No
Primary Key	No
Precision	38
Scale
Status	Active
Description	Unique numeric identifier of a sample coding system.
General Data Type	NUMBER
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name
Seq. Order
Data Storage Type
Max Length
Precision
Scale
Required
Primary Key
Status
Description
General Data Type
Case Restriction
Format Mask
Null Value
Null Value Meaning
Min Length
Unit of Measure
Display Example
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name
Seq. Order
Data Storage Type
Max Length
Precision
Scale
Required
Primary Key
Status
Description
General Data Type
Case Restriction
Format Mask
Null Value
Null Value Meaning
Min Length
Unit of Measure
Display Example
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name
Seq. Order
Data Storage Type
Max Length
Precision
Scale
Required
Primary Key
Status
Description
General Data Type
Case Restriction
Format Mask
Null Value
Null Value Meaning
Min Length
Unit of Measure
Display Example
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Support Roles

» At least one Distributor Org, one Metadata Contact, one Point of Contact, and one Data Steward should be listed.

* » Support Role
* » Date Effective From
Date Effective To
* » Contact
* Contact Instructions

* » Support Role
* » Date Effective From
Date Effective To
* » Contact
* Contact Instructions

* » Support Role
* » Date Effective From
Date Effective To
* » Contact
* Contact Instructions

Extents

Currentness Reference

Extent Group 1

Extent Description

Extent Group 1 / Geographic Area

* » W° Bound
* » E° Bound
* » N° Bound
* » S° Bound
* » Description

Extent Group 1 / Vertical Extent

EPSG Code
Vertical Minimum
Vertical Maximum

Extent Group 1 / Time Frame

* » Time Frame Type
* » Start
End
Alternate Start as of Info
Alternate End as of Info
Description

Access Information

* » Security Class
* Security Classification System
Security Handling Description
• Data Access Policy
» Data Access Procedure
• » Data Access Constraints
• Data Use Constraints
Metadata Access Constraints
Metadata Use Constraints

Distribution Information

Start Date
End Date
» Download URL
Distributor
File Name
Description
File Date/Time
File Type
FGDC Content Type
File Size
Application Version
Compression
Review Status

Start Date
End Date
» Download URL
Distributor
File Name
Description
File Date/Time
File Type
FGDC Content Type
File Size
Application Version
Compression
Review Status

Start Date
End Date
» Download URL
Distributor
File Name
Description
File Date/Time
File Type
FGDC Content Type
File Size
Application Version
Compression
Review Status

Activity Log

Activity Time
Activity Type
Responsible Party
Description

Activity Time
Activity Type
Responsible Party
Description

Activity Time
Activity Type
Responsible Party
Description

Issues

Issue Date
Author
Issue

Issue Date
Author
Issue

Issue Date
Author
Issue

FAQs

Date
Author
Question
Answer

Child Items

Rubric scores updated every 15m

Score	Type	Title

Related Items

Item Type	Relationship Type	Title

Catalog Details

Catalog Item ID	9619
Metadata Record Created By	Doug Turnbull
Metadata Record Created	2009-06-30 16:11+0000
Metadata Record Last Modified By	SysAdmin InPortAdmin
» Metadata Record Last Modified	2022-08-09 17:11+0000
Metadata Record Published	2018-09-26
Owner Org	AFSC
Metadata Publication Status	Published Externally
Do Not Publish?	N
Metadata Workflow State	Published / External
Metadata Last Review Date	2018-09-26
Metadata Review Frequency	1 Year
Metadata Next Review Date	2019-09-26

Tags