Table: ATL_HAUL_H
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:9676 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Hauls are unique fishing events of gear deployment and retrieval and may also contain information unique to a day where no fishing occured.
DescriptionHauls are unique fishing events of gear deployment and retrieval and may also contain information unique to a day where no fishing occurred.
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
SEQ_NUMBER
NUMBER |
Sequence generated unique identifier for a history table. Every history table has a unique sequence assigned to it all start with 1, icrement by 1 and do not cycle. |
CHANGED_BY
VARCHAR2 |
Oracle user who made a change to the transaction table record. |
DATE_CHANGED
DATE |
Timestamp of change to transaction record. |
CRUISE
NUMBER |
Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. |
HAUL_SEQ
NUMBER |
Sequence generated unique identifier for a haul record. |
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). |
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. |
CDQ_CODE
VARCHAR2 |
Unique AlphaNumeric code representing a CDQ or research group |
TRIP_SEQ
NUMBER |
Sequence generated unique identifier of a trip. |
DELIVERY_VESSEL_ADFG
VARCHAR2 |
ADFG number entered by the observer if the delivering vessel does not exist in the vessel lookup table. |
VESSEL_TYPE
NUMBER |
Unique identifier of a vessel type. |
GEAR_PERFORMANCE_CODE
NUMBER |
Unique performance code for a gear type. |
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. |
GEAR_TYPE_CODE
NUMBER |
Numeric value from Norpac Domestic Gear that combined with the Form defines the unique identifier for a gear record |
RBT_CODE
VARCHAR2 |
Random Break Table identifier Currently limted to Y (es) or N(o) |
RST_CODE
VARCHAR2 |
Random Sample Reference Table code reference. |
DETERRENCE_CODE
VARCHAR2 |
Deterrence code from NORPAC bird or mammal deterance tables. |
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. |
LOCATION_CODE
VARCHAR2 |
Identifies whether the information in a haul is based on retrieval or delivery (as in a mother ship). |
RETRV_DATE_TIME
DATE |
Date recorded by the observer from the vessel log. |
RETRV_EW
VARCHAR2 |
Location of gear retrieval. |
RETRV_LATITUDE_DEGREES
NUMBER |
Location of gear retrieval. |
RETRV_LATITUDE_MINUTES
NUMBER |
Location of gear retrieval. |
RETRV_LATITUDE_SECONDS
NUMBER |
Location of gear retrieval. |
RETRV_LONGITUDE_DEGREES
NUMBER |
Location of gear retrieval. |
RETRV_LONGITUDE_MINUTES
NUMBER |
Location of gear retrieval. |
RETRV_LONGITUDE_SECONDS
NUMBER |
Location of gear retrieval. |
NMFS_AREA
NUMBER |
This is a calculated value from retrieval lat-long. It is stored for the convenience of the user community. |
DEPLOY_DATE_TIME
DATE |
Date and time recorded by the observer from the vessel log. Gear deployment for trawls was defined as, prior to 2012, the time that the net reached fishing depth; for 2012 and later, the time of the beginning of the set, i.e. the time that the net first entered the water. |
DEPLOY_EW
VARCHAR2 |
Location of gear deployment.Gear deployment for trawls was defined as, prior to 2012, the time that the net reached fishing depth; for 2012 and later, the time of the beginning of the set, i.e. the time that the net first entered the water. |
DEPLOY_LATITUDE_DEGREES
NUMBER |
Location of gear deployment. Gear deployment for trawls was defined as, prior to 2012, the time that the net reached fishing depth; for 2012 and later, the time of the beginning of the set, i.e. the time that the net first entered the water. |
DEPLOY_LATITUDE_MINUTES
NUMBER |
Location of gear deployment. Gear deployment for trawls was defined as, prior to 2012, the time that the net reached fishing depth; for 2012 and later, the time of the beginning of the set, i.e. the time that the net first entered the water. |
DEPLOY_LATITUDE_SECONDS
NUMBER |
Location of gear deployment. Gear deployment for trawls was defined as, prior to 2012, the time that the net reached fishing depth; for 2012 and later, the time of the beginning of the set, i.e. the time that the net first entered the water. |
DEPLOY_LONGITUDE_DEGREES
NUMBER |
Location of gear deployment. Gear deployment for trawls was defined as, prior to 2012, the time that the net reached fishing depth; for 2012 and later, the time of the beginning of the set, i.e. the time that the net first entered the water. |
DEPLOY_LONGITUDE_MINUTES
NUMBER |
Location of gear deployment. Gear deployment for trawls was defined as, prior to 2012, the time that the net reached fishing depth; for 2012 and later, the time of the beginning of the set, i.e. the time that the net first entered the water. |
DEPLOY_LONGITUDE_SECONDS
NUMBER |
Location of gear deployment. Gear deployment for trawls was defined as, prior to 2012, the time that the net reached fishing depth; for 2012 and later, the time of the beginning of the set, i.e. the time that the net first entered the water. |
BOTTOM_DEPTH
NUMBER |
Average bottom depth recorded by the observer from the vessel log. |
FISHING_DEPTH
NUMBER |
Average fishing depth recorded by the observer from the vessel log. |
DEPTH_METER_FATHOM
VARCHAR2 |
Identifies whether depth is recorded in meters or fathoms. |
VESSEL_EST_CATCH
NUMBER |
Total catch weight in metric tons as recorded in the vessel log. |
OBSVR_EST_CATCH
NUMBER |
Total catch weight as estimated by the observer in kgs. |
OBSVR_EST_DISCARDS
NUMBER |
Observer estimate of total discards in kgs. |
OBSVR_EST_METHOD
VARCHAR2 |
Method used to determine the observer estimated catch. |
DENSITY
NUMBER |
Density used by the observer to determine the total catch weights. Recorded in kgs per m3. |
INDIV_FISHING_QUOTA_FLAG
VARCHAR2 |
Identifies whether fishing is on an IFQ quota with the subsequent application of IFQ rules. |
SAMPLED_BY
NUMBER |
Identifies where a haul is sampled by an observer and in some cases by which observer. The observer of a haul is not necessarily the primary observer recorded for a cruise. |
NUMBER_OF_SKATES
NUMBER |
Number of skates for longline fishing. |
NUMBER_OF_HOOKS_PER_SKATE
NUMBER |
Number of hooks per skate for longline fishing. |
TOTAL_HOOKS
NUMBER |
Total number of hooks deployed for this haul |
TOTAL_POTS
NUMBER |
Total number of pots deployed for this haul. |
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. |
PERMIT
VARCHAR2 |
Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau |
VOLUME
NUMBER |
Estimate of volume of catch |
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 recalculation. |
BIRD_MONITOR_LEVEL_CODE
VARCHAR2 |
Portion of the haulback that was monitored by the observer for bird interactions. |
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. |
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. |
SAMPLE_SYSTEM_CODE
NUMBER |
Unique numeric identifier of a sample coding system. |
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: | Table: ATL_HAUL_H |
---|---|
Short Name: | ATL_HAUL_H |
Status: | Completed |
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: |
Histories of all changes to data are maintained by trigger code on the parent table; allowing change control by user and datetime for all updates and delete events. |
Notes: |
Loaded by batch 2390, 06-30-2009 16:11 |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
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 occurred. |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
SEQ_NUMBER | NUMBER | Sequence generated unique identifier for a history table. Every history table has a unique sequence assigned to it all start with 1, icrement by 1 and do not cycle. | |
100
|
CHANGED_BY | VARCHAR2 | Oracle user who made a change to the transaction table record. | |
100
|
DATE_CHANGED | DATE | Timestamp of change to transaction record. | |
100
|
CRUISE | NUMBER | Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. | |
100
|
HAUL_SEQ | NUMBER | Sequence generated unique identifier for a haul record. | |
100
|
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
|
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
|
CDQ_CODE | VARCHAR2 | Unique AlphaNumeric code representing a CDQ or research group | |
100
|
TRIP_SEQ | NUMBER | Sequence generated unique identifier of a trip. | |
100
|
DELIVERY_VESSEL_ADFG | VARCHAR2 | ADFG number entered by the observer if the delivering vessel does not exist in the vessel lookup table. | |
100
|
VESSEL_TYPE | NUMBER | Unique identifier of a vessel type. | |
100
|
GEAR_PERFORMANCE_CODE | NUMBER | Unique performance code for a gear type. | |
100
|
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
|
GEAR_TYPE_CODE | NUMBER | Numeric value from Norpac Domestic Gear that combined with the Form defines the unique identifier for a gear record | |
100
|
RBT_CODE | VARCHAR2 | Random Break Table identifier Currently limted to Y (es) or N(o) | |
100
|
RST_CODE | VARCHAR2 | Random Sample Reference Table code reference. | |
100
|
DETERRENCE_CODE | VARCHAR2 | Deterrence code from NORPAC bird or mammal deterance tables. | |
100
|
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
|
LOCATION_CODE | VARCHAR2 | Identifies whether the information in a haul is based on retrieval or delivery (as in a mother ship). | |
100
|
RETRV_DATE_TIME | DATE | Date recorded by the observer from the vessel log. | |
100
|
RETRV_EW | VARCHAR2 | Location of gear retrieval. | |
100
|
RETRV_LATITUDE_DEGREES | NUMBER | Location of gear retrieval. | |
100
|
RETRV_LATITUDE_MINUTES | NUMBER | Location of gear retrieval. | |
100
|
RETRV_LATITUDE_SECONDS | NUMBER | Location of gear retrieval. | |
100
|
RETRV_LONGITUDE_DEGREES | NUMBER | Location of gear retrieval. | |
100
|
RETRV_LONGITUDE_MINUTES | NUMBER | Location of gear retrieval. | |
100
|
RETRV_LONGITUDE_SECONDS | NUMBER | Location of gear retrieval. | |
100
|
NMFS_AREA | NUMBER | This is a calculated value from retrieval lat-long. It is stored for the convenience of the user community. | |
100
|
DEPLOY_DATE_TIME | DATE | Date and time recorded by the observer from the vessel log. Gear deployment for trawls was defined as, prior to 2012, the time that the net reached fishing depth; for 2012 and later, the time of the beginning of the set, i.e. the time that the net first entered the water. | |
100
|
DEPLOY_EW | VARCHAR2 | Location of gear deployment.Gear deployment for trawls was defined as, prior to 2012, the time that the net reached fishing depth; for 2012 and later, the time of the beginning of the set, i.e. the time that the net first entered the water. | |
100
|
DEPLOY_LATITUDE_DEGREES | NUMBER | Location of gear deployment. Gear deployment for trawls was defined as, prior to 2012, the time that the net reached fishing depth; for 2012 and later, the time of the beginning of the set, i.e. the time that the net first entered the water. | |
100
|
DEPLOY_LATITUDE_MINUTES | NUMBER | Location of gear deployment. Gear deployment for trawls was defined as, prior to 2012, the time that the net reached fishing depth; for 2012 and later, the time of the beginning of the set, i.e. the time that the net first entered the water. | |
100
|
DEPLOY_LATITUDE_SECONDS | NUMBER | Location of gear deployment. Gear deployment for trawls was defined as, prior to 2012, the time that the net reached fishing depth; for 2012 and later, the time of the beginning of the set, i.e. the time that the net first entered the water. | |
100
|
DEPLOY_LONGITUDE_DEGREES | NUMBER | Location of gear deployment. Gear deployment for trawls was defined as, prior to 2012, the time that the net reached fishing depth; for 2012 and later, the time of the beginning of the set, i.e. the time that the net first entered the water. | |
100
|
DEPLOY_LONGITUDE_MINUTES | NUMBER | Location of gear deployment. Gear deployment for trawls was defined as, prior to 2012, the time that the net reached fishing depth; for 2012 and later, the time of the beginning of the set, i.e. the time that the net first entered the water. | |
100
|
DEPLOY_LONGITUDE_SECONDS | NUMBER | Location of gear deployment. Gear deployment for trawls was defined as, prior to 2012, the time that the net reached fishing depth; for 2012 and later, the time of the beginning of the set, i.e. the time that the net first entered the water. | |
100
|
BOTTOM_DEPTH | NUMBER | Average bottom depth recorded by the observer from the vessel log. | |
100
|
FISHING_DEPTH | NUMBER | Average fishing depth recorded by the observer from the vessel log. | |
100
|
DEPTH_METER_FATHOM | VARCHAR2 | Identifies whether depth is recorded in meters or fathoms. | |
100
|
VESSEL_EST_CATCH | NUMBER | Total catch weight in metric tons as recorded in the vessel log. | |
100
|
OBSVR_EST_CATCH | NUMBER | Total catch weight as estimated by the observer in kgs. | |
100
|
OBSVR_EST_DISCARDS | NUMBER | Observer estimate of total discards in kgs. | |
100
|
OBSVR_EST_METHOD | VARCHAR2 | Method used to determine the observer estimated catch. | |
100
|
DENSITY | NUMBER | Density used by the observer to determine the total catch weights. Recorded in kgs per m3. | |
100
|
INDIV_FISHING_QUOTA_FLAG | VARCHAR2 | Identifies whether fishing is on an IFQ quota with the subsequent application of IFQ rules. | |
100
|
SAMPLED_BY | NUMBER | Identifies where a haul is sampled by an observer and in some cases by which observer. The observer of a haul is not necessarily the primary observer recorded for a cruise. | |
100
|
NUMBER_OF_SKATES | NUMBER | Number of skates for longline fishing. | |
100
|
NUMBER_OF_HOOKS_PER_SKATE | NUMBER | Number of hooks per skate for longline fishing. | |
100
|
TOTAL_HOOKS | NUMBER | Total number of hooks deployed for this haul | |
100
|
TOTAL_POTS | NUMBER | Total number of pots deployed for this haul. | |
100
|
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
|
PERMIT | VARCHAR2 | Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau | |
100
|
VOLUME | NUMBER | Estimate of volume of catch | |
100
|
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 recalculation. | |
100
|
BIRD_MONITOR_LEVEL_CODE | VARCHAR2 | Portion of the haulback that was monitored by the observer for bird interactions. | |
100
|
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
|
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
|
SAMPLE_SYSTEM_CODE | NUMBER | Unique numeric identifier of a sample coding system. |
Attribute Details
SEQ_NUMBER
Seq. Order: | 1 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | Yes |
Precision: | 10 |
Scale: | 0 |
Status: | Active |
Description: |
Sequence generated unique identifier for a history table. Every history table has a unique sequence assigned to it all start with 1, icrement by 1 and do not cycle. |
General Data Type: | NUMBER |
CHANGED_BY
Seq. Order: | 2 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 30 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Oracle user who made a change to the transaction table record. |
General Data Type: | VARCHAR2 |
DATE_CHANGED
Seq. Order: | 3 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Timestamp of change to transaction record. |
General Data Type: | DATE |
CRUISE
Seq. Order: | 4 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 22 |
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 |
HAUL_SEQ
Seq. Order: | 5 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 22 |
Scale: | 0 |
Status: | Active |
Description: |
Sequence generated unique identifier for a haul record. |
General Data Type: | NUMBER |
HAUL_NUMBER
Seq. Order: | 6 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 22 |
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 |
HAUL_PURPOSE_CODE
Seq. Order: | 7 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | Yes |
Primary Key: | No |
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 |
CDQ_CODE
Seq. Order: | 8 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Unique AlphaNumeric code representing a CDQ or research group |
General Data Type: | VARCHAR2 |
TRIP_SEQ
Seq. Order: | 9 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 22 |
Scale: | 0 |
Status: | Active |
Description: |
Sequence generated unique identifier of a trip. |
General Data Type: | NUMBER |
DELIVERY_VESSEL_ADFG
Seq. Order: | 10 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 6 |
Required: | No |
Primary Key: | No |
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 |
VESSEL_TYPE
Seq. Order: | 11 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 22 |
Scale: | 0 |
Status: | Active |
Description: |
Unique identifier of a vessel type. |
General Data Type: | NUMBER |
GEAR_PERFORMANCE_CODE
Seq. Order: | 12 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 22 |
Scale: | 0 |
Status: | Active |
Description: |
Unique performance code for a gear type. |
General Data Type: | NUMBER |
GEARTYPE_FORM
Seq. Order: | 13 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
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 |
GEAR_TYPE_CODE
Seq. Order: | 14 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 22 |
Scale: | 0 |
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 |
RBT_CODE
Seq. Order: | 15 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Random Break Table identifier Currently limted to Y (es) or N(o) |
General Data Type: | VARCHAR2 |
RST_CODE
Seq. Order: | 16 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Random Sample Reference Table code reference. |
General Data Type: | VARCHAR2 |
DETERRENCE_CODE
Seq. Order: | 17 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Deterrence code from NORPAC bird or mammal deterance tables. |
General Data Type: | VARCHAR2 |
ANIMAL_TYPE_CODE
Seq. Order: | 18 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
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 |
LOCATION_CODE
Seq. Order: | 19 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
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 |
RETRV_DATE_TIME
Seq. Order: | 20 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date recorded by the observer from the vessel log. |
General Data Type: | DATE |
RETRV_EW
Seq. Order: | 21 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Location of gear retrieval. |
General Data Type: | VARCHAR2 |
RETRV_LATITUDE_DEGREES
Seq. Order: | 22 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 22 |
Scale: | 0 |
Status: | Active |
Description: |
Location of gear retrieval. |
General Data Type: | NUMBER |
RETRV_LATITUDE_MINUTES
Seq. Order: | 23 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 22 |
Scale: | 0 |
Status: | Active |
Description: |
Location of gear retrieval. |
General Data Type: | NUMBER |
RETRV_LATITUDE_SECONDS
Seq. Order: | 24 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 22 |
Scale: | 0 |
Status: | Active |
Description: |
Location of gear retrieval. |
General Data Type: | NUMBER |
RETRV_LONGITUDE_DEGREES
Seq. Order: | 25 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 22 |
Scale: | 0 |
Status: | Active |
Description: |
Location of gear retrieval. |
General Data Type: | NUMBER |
RETRV_LONGITUDE_MINUTES
Seq. Order: | 26 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 22 |
Scale: | 0 |
Status: | Active |
Description: |
Location of gear retrieval. |
General Data Type: | NUMBER |
RETRV_LONGITUDE_SECONDS
Seq. Order: | 27 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 22 |
Scale: | 0 |
Status: | Active |
Description: |
Location of gear retrieval. |
General Data Type: | NUMBER |
NMFS_AREA
Seq. Order: | 28 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 22 |
Scale: | 0 |
Status: | Active |
Description: |
This is a calculated value from retrieval lat-long. It is stored for the convenience of the user community. |
General Data Type: | NUMBER |
DEPLOY_DATE_TIME
Seq. Order: | 29 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date and time recorded by the observer from the vessel log. Gear deployment for trawls was defined as, prior to 2012, the time that the net reached fishing depth; for 2012 and later, the time of the beginning of the set, i.e. the time that the net first entered the water. |
General Data Type: | DATE |
DEPLOY_EW
Seq. Order: | 30 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Location of gear deployment.Gear deployment for trawls was defined as, prior to 2012, the time that the net reached fishing depth; for 2012 and later, the time of the beginning of the set, i.e. the time that the net first entered the water. |
General Data Type: | VARCHAR2 |
DEPLOY_LATITUDE_DEGREES
Seq. Order: | 31 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 22 |
Scale: | 0 |
Status: | Active |
Description: |
Location of gear deployment. Gear deployment for trawls was defined as, prior to 2012, the time that the net reached fishing depth; for 2012 and later, the time of the beginning of the set, i.e. the time that the net first entered the water. |
General Data Type: | NUMBER |
DEPLOY_LATITUDE_MINUTES
Seq. Order: | 32 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 22 |
Scale: | 0 |
Status: | Active |
Description: |
Location of gear deployment. Gear deployment for trawls was defined as, prior to 2012, the time that the net reached fishing depth; for 2012 and later, the time of the beginning of the set, i.e. the time that the net first entered the water. |
General Data Type: | NUMBER |
DEPLOY_LATITUDE_SECONDS
Seq. Order: | 33 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 22 |
Scale: | 0 |
Status: | Active |
Description: |
Location of gear deployment. Gear deployment for trawls was defined as, prior to 2012, the time that the net reached fishing depth; for 2012 and later, the time of the beginning of the set, i.e. the time that the net first entered the water. |
General Data Type: | NUMBER |
DEPLOY_LONGITUDE_DEGREES
Seq. Order: | 34 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 22 |
Scale: | 0 |
Status: | Active |
Description: |
Location of gear deployment. Gear deployment for trawls was defined as, prior to 2012, the time that the net reached fishing depth; for 2012 and later, the time of the beginning of the set, i.e. the time that the net first entered the water. |
General Data Type: | NUMBER |
DEPLOY_LONGITUDE_MINUTES
Seq. Order: | 35 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 22 |
Scale: | 0 |
Status: | Active |
Description: |
Location of gear deployment. Gear deployment for trawls was defined as, prior to 2012, the time that the net reached fishing depth; for 2012 and later, the time of the beginning of the set, i.e. the time that the net first entered the water. |
General Data Type: | NUMBER |
DEPLOY_LONGITUDE_SECONDS
Seq. Order: | 36 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 22 |
Scale: | 0 |
Status: | Active |
Description: |
Location of gear deployment. Gear deployment for trawls was defined as, prior to 2012, the time that the net reached fishing depth; for 2012 and later, the time of the beginning of the set, i.e. the time that the net first entered the water. |
General Data Type: | NUMBER |
BOTTOM_DEPTH
Seq. Order: | 37 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
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 |
FISHING_DEPTH
Seq. Order: | 38 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
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 |
DEPTH_METER_FATHOM
Seq. Order: | 39 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Identifies whether depth is recorded in meters or fathoms. |
General Data Type: | VARCHAR2 |
VESSEL_EST_CATCH
Seq. Order: | 40 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
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 |
OBSVR_EST_CATCH
Seq. Order: | 41 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 6 |
Scale: | 2 |
Status: | Active |
Description: |
Total catch weight as estimated by the observer in kgs. |
General Data Type: | NUMBER |
OBSVR_EST_DISCARDS
Seq. Order: | 42 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 6 |
Scale: | 2 |
Status: | Active |
Description: |
Observer estimate of total discards in kgs. |
General Data Type: | NUMBER |
OBSVR_EST_METHOD
Seq. Order: | 43 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Method used to determine the observer estimated catch. |
General Data Type: | VARCHAR2 |
DENSITY
Seq. Order: | 44 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 3 |
Scale: | 2 |
Status: | Active |
Description: |
Density used by the observer to determine the total catch weights. Recorded in kgs per m3. |
General Data Type: | NUMBER |
INDIV_FISHING_QUOTA_FLAG
Seq. Order: | 45 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Identifies whether fishing is on an IFQ quota with the subsequent application of IFQ rules. |
General Data Type: | VARCHAR2 |
SAMPLED_BY
Seq. Order: | 46 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 8 |
Scale: | 0 |
Status: | Active |
Description: |
Identifies where a haul is sampled by an observer and in some cases by which observer. The observer of a haul is not necessarily the primary observer recorded for a cruise. |
General Data Type: | NUMBER |
NUMBER_OF_SKATES
Seq. Order: | 47 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 4 |
Scale: | 0 |
Status: | Active |
Description: |
Number of skates for longline fishing. |
General Data Type: | NUMBER |
NUMBER_OF_HOOKS_PER_SKATE
Seq. Order: | 48 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 4 |
Scale: | 0 |
Status: | Active |
Description: |
Number of hooks per skate for longline fishing. |
General Data Type: | NUMBER |
TOTAL_HOOKS
Seq. Order: | 49 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 6 |
Scale: | 0 |
Status: | Active |
Description: |
Total number of hooks deployed for this haul |
General Data Type: | NUMBER |
TOTAL_POTS
Seq. Order: | 50 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 5 |
Scale: | 0 |
Status: | Active |
Description: |
Total number of pots deployed for this haul. |
General Data Type: | NUMBER |
MMAMMAL_MONITR_PCT
Seq. Order: | 51 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
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 |
PERMIT
Seq. Order: | 52 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 6 |
Required: | No |
Primary Key: | No |
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 |
VOLUME
Seq. Order: | 53 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 6 |
Scale: | 2 |
Status: | Active |
Description: |
Estimate of volume of catch |
General Data Type: | NUMBER |
TOTAL_HOOKS_OVERIDE_FLAG
Seq. Order: | 54 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
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 recalculation. |
General Data Type: | VARCHAR2 |
BIRD_MONITOR_LEVEL_CODE
Seq. Order: | 55 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Portion of the haulback that was monitored by the observer for bird interactions. |
General Data Type: | VARCHAR2 |
SHORTWIRED_FLAG
Seq. Order: | 56 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | Yes |
Primary Key: | No |
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 |
SAMPLE_UNIT_CODE
Seq. Order: | 57 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 6 |
Required: | No |
Primary Key: | No |
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 |
SAMPLE_SYSTEM_CODE
Seq. Order: | 58 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Unique numeric identifier of a sample coding system. |
General Data Type: | NUMBER |
Catalog Details
Catalog Item ID: | 9676 |
---|---|
GUID: | gov.noaa.nmfs.inport:9676 |
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 Last Review Date: | 2018-09-26 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2019-09-26 |