Table: HAUL
Alaska Fisheries Science Center
Entity
(ENT)
| ID: 7510
| Published / External
Created: 2008-03-28
|
Last Modified: 2022-08-09
Data Set (DS) | ID: 7283
ID: 7510
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | Table: HAUL |
---|---|
Short Name | 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 2204, 03-28-2008 14:09 |
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 | TURNBULLD |
» 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 | 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 |
100 | No | No | RST_CODE | VARCHAR2 | Random Sample Reference Table. Y = Yes - The haul is an ON haul, N = No - The haul is NOT an ON haul, x = RST Table not Used - Sampling All Hauls |
100 | No | No | DETERRENCE_CODE | VARCHAR2 | Deterrence code from NORPAC bird or mammal deterance tables |
100 | No | No | DETERRENCE_ANIMAL_TYPE | 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 | Yes | No | DEPLOY_DATE_TIME | DATE | Date and time recorded by the observer from the vessel log. |
100 | Yes | No | DEPLOY_LATITUDE_DEGREES | NUMBER | Location of gear deployment. |
100 | Yes | No | DEPLOY_LATITUDE_MINUTES | NUMBER | Location of gear deployment. |
100 | No | No | DEPLOY_LATITUDE_SECONDS | NUMBER | Location of gear deployment. |
100 | Yes | No | DEPLOY_EW | VARCHAR2 | Location of gear deployment. |
100 | Yes | No | DEPLOY_LONGITUDE_DEGREES | NUMBER | Location of gear deployment. |
100 | Yes | 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. |
Attribute Details
Attribute Name | HAUL_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 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 | 2 |
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 | 3 |
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 | 4 |
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 |
TURNBULLD.LOV_CDQ |
Derivation | |
Validation Rules |
Attribute Name | TRIP_SEQ |
---|---|
Seq. Order | 5 |
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 |
TURNBULLD.FMA_TRIP |
Derivation | |
Validation Rules |
Attribute Name | DELIVERY_VESSEL_ADFG |
---|---|
Seq. Order | 6 |
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 | 7 |
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 |
TURNBULLD.LOV_GEAR_PERFORMANCE |
Derivation | |
Validation Rules |
Attribute Name | RBT_CODE |
---|---|
Seq. Order | 8 |
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 |
TURNBULLD.LOV_RBT_CODE |
Derivation | |
Validation Rules |
Attribute Name | VESSEL_TYPE |
---|---|
Seq. Order | 9 |
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 |
TURNBULLD.LOV_VESSEL_TYPE |
Derivation | |
Validation Rules |
Attribute Name | GEARTYPE_FORM |
---|---|
Seq. Order | 10 |
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 |
TURNBULLD.LOV_GEAR_TYPE |
Derivation | |
Validation Rules |
Attribute Name | GEAR_TYPE_CODE |
---|---|
Seq. Order | 11 |
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 |
TURNBULLD.LOV_GEAR_TYPE |
Derivation | |
Validation Rules |
Attribute Name | RST_CODE |
---|---|
Seq. Order | 12 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Random Sample Reference Table. Y = Yes - The haul is an ON haul, N = No - The haul is NOT an ON haul, x = RST Table not Used - Sampling All Hauls |
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 |
TURNBULLD.LOV_RST_CODE |
Derivation | |
Validation Rules |
Attribute Name | DETERRENCE_CODE |
---|---|
Seq. Order | 13 |
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 |
TURNBULLD.LOV_DETERRENCE |
Derivation | |
Validation Rules |
Attribute Name | DETERRENCE_ANIMAL_TYPE |
---|---|
Seq. Order | 14 |
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 |
TURNBULLD.LOV_DETERRENCE |
Derivation | |
Validation Rules |
Attribute Name | LOCATION_CODE |
---|---|
Seq. Order | 15 |
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 | 16 |
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 | 17 |
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 | 18 |
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 | 19 |
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 | 20 |
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 | 21 |
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 | 22 |
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 | 23 |
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 | 24 |
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 | DEPLOY_LATITUDE_DEGREES |
---|---|
Seq. Order | 25 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | Yes |
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 | 26 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | Yes |
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 | 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_EW |
---|---|
Seq. Order | 28 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | Yes |
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 | 29 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | Yes |
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 | 30 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | Yes |
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 | 31 |
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 | 32 |
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 | 33 |
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 | 34 |
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 | 35 |
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 | 36 |
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 | 37 |
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 | 38 |
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 | 39 |
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 | 40 |
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 | 41 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | Yes |
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. |
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 | 42 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | 0 |
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 | 43 |
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 | 44 |
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 | 45 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 6 |
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 | 46 |
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 | |
---|---|
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
* » 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 | 7510 |
---|---|
Metadata Record Created By | Doug Turnbull |
Metadata Record Created | 2008-03-28 14:09+0000 |
Metadata Record Last Modified By | SysAdmin InPortAdmin |
» Metadata Record Last Modified | 2022-08-09 17:11+0000 |
Metadata Record Published | 2018-10-03 |
Owner Org | AFSC |
Metadata Publication Status | Published Externally |
Do Not Publish? | N |
Metadata Workflow State | Published / External |
Metadata Last Review Date | 2018-10-03 |
Metadata Review Frequency | 1 Year |
Metadata Next Review Date | 2019-10-03 |
Tags |
---|