Table: FOREIGN_HAUL
Alaska Fisheries Science Center
Entity
(ENT)
| ID: 9572
| Published / External
Created: 2009-06-29
|
Last Modified: 2022-08-09
Data Set (DS) | ID: 9556
ID: 9572
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | Table: FOREIGN_HAUL |
---|---|
Short Name | FOREIGN_HAUL |
* Status | Completed |
Creation Date | |
Revision Date | |
• Publication Date | |
* » Abstract |
This table contains haul-by-haul vessel data, fishing effort, and total catch in the foreign and joint venture groundfish fishery. |
* Purpose | |
Notes |
Loaded by batch 2364, 06-29-2009 18:15 |
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 |
This table contains haul-by-haul vessel data, fishing effort, and total catch in the foreign and joint venture groundfish fishery. |
Change Summary |
Data Attributes
Attribute Summary
Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
---|---|---|---|---|---|
100 | Yes | No | CRUISE | NUMBER | If a U. S. vessel delivered the haul to a vessel carrying an observer, this field contains the A unique four-digit number assigned to the observer for the length of their contract period. This number alone identifies and groups a set of observer information. |
100 | Yes | No | VESSEL | VARCHAR2 | A unique four-digit, alpha-numeric code identifying each vessel that contracts for observer coverage. All vessel codes begin with the alpha code B, followed by a three-digit number. |
100 | Yes | No | YEAR | NUMBER | A four-digit number identifying the year in which the gear retrieval of the haul began or in which the noon position occurred. |
100 | Yes | No | DT | DATE | Similar to NORPAC.DOMESTIC_HAUL.HAUL_DATE, this is the date in Greenwich Mean Time. Format is stored in the database as DD-MON-YY format (i.e., 15-MAR-86), and displayed as MM/DD/YYYY HH:MI:SS (i.e., 3/15/86 00:00:00). |
100 | Yes | No | HAUL | NUMBER | A unique number which identifies a specific occurrence of net, pot, or longline fishing effort. Additionally, a day in which a vessel was on grounds is occasionally recorded with a haul number of 0 (zero) if no codend, longline set, or pot group retrievals were begun. |
100 | Yes | No | LOCATION_ID | VARCHAR2 | A one-digit alpha code that indicates what type of fishing activity occurred at the latitude and longitude recorded. R = the position of the vessel when the retrieval of the haul/set was begun, D = the position of the vessel when a delivery was completed to a mothership, N = the position of the vessel at noon (Greenwich Mean Time) on a day when no fishing took place and the vessel was not in port, S = the position of the vessel when gear began being set. |
100 | Yes | No | LATITUDE | NUMBER | A four-digit number recorded in degrees and minutes north. The geographical position associated with the LOCATION_ID. |
100 | Yes | No | E_W | VARCHAR2 | Direction of longitude, E = east and W = west of the 180th meridian. |
100 | Yes | No | LONGITUDE | NUMBER | A five-digit number recorded in degrees and minutes west of 0 degrees. Any position west of 180 degrees is stored as a value greater than 18000, e.g., 170 degrees east longitude = 19000. The geographical position associated with the LOCATION_ID. |
100 | No | No | FISHING_DEPTH | NUMBER | The average fishing depth at which fishing took place, in meters. |
100 | No | No | BOTTOM_DEPTH | NUMBER | The average of the lowest points on the ocean floor where fishing took place (in meters). This is only recorded for joint venture vessels. |
100 | No | No | NETS_ON_BOTTOM | NUMBER | The time when the net reached fishing depth (in Greenwich Mean Time). Use DURATION and NETS_OFF_BOTTOM and subtract to determine the date. |
100 | No | No | NETS_OFF_BOTTOM | NUMBER | The time when the net began to be retrieved from fishing depth (in Greenwich Mean Time). The date is the same date as DT. |
100 | No | No | DURATION | NUMBER | For longline or pot vessels, the time interval from the time that the first part of the line/pot-group was set until the time that the last of the line/pot-group was retrieved (also known as soak time). For trawlers, duration is the length of time during which the net was at fishing level. Duration is the difference between the NETS_ON_BOTTOM and the NETS_OFF_BOTTOM. Recorded in minutes. |
100 | No | No | NUMBER_OF_TOWS | NUMBER | Is only not null for vessels where fishing information is recorded as a daily event. Prior to 1977, all data were compiled as a daily event and are associated with a Noon Position. When HAUL=0, then NUMBER_OF_TOWS is the number of tows that occurred that day. After 1976, only true motherships and, through 1983, joint venture motherships were combined on a daily basis. In 1988, two cruises (2943 B002 and 2977 B002) were the exception to this rule. The observers made a mistake and the data were combined by day. For an unknown reason, there are also 17 records where HAUL=0, NUMBER_OF_TOWS>0, and OFFICIAL_TOTAL_CATCH is null. |
100 | No | No | OFFICIAL_TOTAL_CATCH | NUMBER | Final estimate of catch weight (MT) for the set or haul, made by vessel personnel, includes both retained and discarded species, and is recorded to the nearest one-hundredth of a metric ton. If original_ships_estimate is not null, official_total_catch is the original_ships_estimate adjusted by the observer to include prohibited species and non-allocated species. If NUMBER_OF_TOWS>0, then OFFICIAL_TOTAL_CATCH is the total catch for the day. |
100 | No | No | SPEED | NUMBER | Average towing speed of the vessel during the tow, recorded to the tenth of a knot. Recorded from the vessel logbook. |
100 | No | No | WEATHER | NUMBER | A one-digit numeric code identifying the weather conditions during the fishing operation. NORPAC.FOREIGN_WEATHER provides a description of the codes. |
100 | No | No | SEA | NUMBER | A one-digit numeric code identifying the sea conditions during the fishing operation. NORPAC.FOREIGN_SEA provides a description of the codes. |
100 | No | No | SURFACE_WATER_TEMP | NUMBER | The temperature of the surface water in degrees Celsius. |
100 | No | No | BOTTOM_WATER_TEMP | NUMBER | The temperature of the water at fishing depth in degrees Celsius. |
100 | No | No | DELIVERY_TIME | NUMBER | The time (Greenwich Mean Time) when the tow was delivered to the joint venture mothership. Recorded from vessel logs or observer observation. |
100 | No | No | NUMBER_OF_SKATES | NUMBER | The number of hachi (skates) for a single set. |
100 | No | No | HOOKS_PER_SKATE | NUMBER | The average number of hooks in a (hachi) skate. |
100 | No | No | OBSERVER_CATCH_ESTIMATE | NUMBER | Estimate of total catch for the set or haul made by the observer, recorded to the nearest one-hundredth of a metric ton. See observer instruction manuals for specific information on possible estimation methods. |
100 | No | No | ORIGINAL_SHIPS_ESTIMATE | NUMBER | Similar to NORPAC.DOMESTIC_HAUL.VESSEL_ESTIMATE, this is the initial estimate of the catch made by the vessel, recorded to one-hundredth of a metric ton. |
100 | No | No | ADFG_NUMBER | NUMBER | If a U. S. vessel delivered the haul to a vessel carrying an observer, this field contains the Alaska Department of Fish and Game (ADF&G) vessel code number of the delivering vessel. NORPAC.FOREIGN_CATCHER_BOAT provides the names of the catcher boats and the coast guard numbers associated with the codes. |
100 | No | No | NUMBER_OF_POTS | NUMBER | For pot vessels, the total number of pots in a set, i.e., the number of pots or group of pots in the set that were retrieved. |
100 | No | No | MM_MONITORED_RANDOM | VARCHAR2 | This field is null. |
100 | Yes | Yes | HAUL_JOIN | NUMBER | An assigned, unique number (up to 6 digits) that uniquely identifies each haul/set associated with vessel data. NORPAC.FOREIGN_HAUL.HAUL_JOIN links a single haul record to records in many of the foreign tables. |
100 | Yes | No | GENERIC_AREA | NUMBER | A three-digit number representing NORPAC database management subareas which, in most cases, are similar to NPFMC management areas. NORPAC.AREA links latitude and longitude to GENERIC_AREA (called GENERIC). |
100 | No | No | HAUL_SAMPLED_BY | VARCHAR2 | A one-digit numeric code indicating whether or not a haul was sampled for species composition: 0 = not sampled, 9 = sampled. If more than one observer was onboard the vessel, there is no way of knowing which observer sampled the haul.. |
Attribute Details
Attribute Name | CRUISE |
---|---|
Seq. Order | 1 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | 4 |
Scale | 0 |
Status | Active |
Description |
If a U. S. vessel delivered the haul to a vessel carrying an observer, this field contains the A unique four-digit number assigned to the observer for the length of their contract period. This number alone identifies and groups a set of observer information. |
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 |
NORPAC.FOREIGN_FISHING_OPERATI |
Derivation | |
Validation Rules |
Attribute Name | VESSEL |
---|---|
Seq. Order | 2 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
A unique four-digit, alpha-numeric code identifying each vessel that contracts for observer coverage. All vessel codes begin with the alpha code B, followed by a three-digit number. |
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 |
Refers to more than one entity |
Derivation | |
Validation Rules |
Attribute Name | YEAR |
---|---|
Seq. Order | 3 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | 4 |
Scale | 0 |
Status | Active |
Description |
A four-digit number identifying the year in which the gear retrieval of the haul began or in which the noon position occurred. |
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 | DT |
---|---|
Seq. Order | 4 |
Data Storage Type | DATE |
Max Length | 7 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Similar to NORPAC.DOMESTIC_HAUL.HAUL_DATE, this is the date in Greenwich Mean Time. Format is stored in the database as DD-MON-YY format (i.e., 15-MAR-86), and displayed as MM/DD/YYYY HH:MI:SS (i.e., 3/15/86 00:00:00). |
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 | HAUL |
---|---|
Seq. Order | 5 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | 3 |
Scale | 0 |
Status | Active |
Description |
A unique number which identifies a specific occurrence of net, pot, or longline fishing effort. Additionally, a day in which a vessel was on grounds is occasionally recorded with a haul number of 0 (zero) if no codend, longline set, or pot group retrievals were begun. |
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 | LOCATION_ID |
---|---|
Seq. Order | 6 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
A one-digit alpha code that indicates what type of fishing activity occurred at the latitude and longitude recorded. R = the position of the vessel when the retrieval of the haul/set was begun, D = the position of the vessel when a delivery was completed to a mothership, N = the position of the vessel at noon (Greenwich Mean Time) on a day when no fishing took place and the vessel was not in port, S = the position of the vessel when gear began being 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 | LATITUDE |
---|---|
Seq. Order | 7 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | 4 |
Scale | 0 |
Status | Active |
Description |
A four-digit number recorded in degrees and minutes north. The geographical position associated with the LOCATION_ID. |
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 | E_W |
---|---|
Seq. Order | 8 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Direction of longitude, E = east and W = west of the 180th meridian. |
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 | LONGITUDE |
---|---|
Seq. Order | 9 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | 5 |
Scale | 0 |
Status | Active |
Description |
A five-digit number recorded in degrees and minutes west of 0 degrees. Any position west of 180 degrees is stored as a value greater than 18000, e.g., 170 degrees east longitude = 19000. The geographical position associated with the LOCATION_ID. |
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 | 10 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | 0 |
Status | Active |
Description |
The average fishing depth at which fishing took place, in meters. |
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 | 11 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | 0 |
Status | Active |
Description |
The average of the lowest points on the ocean floor where fishing took place (in meters). This is only recorded for joint venture vessels. |
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 | NETS_ON_BOTTOM |
---|---|
Seq. Order | 12 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | 0 |
Status | Active |
Description |
The time when the net reached fishing depth (in Greenwich Mean Time). Use DURATION and NETS_OFF_BOTTOM and subtract to determine the date. |
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 | NETS_OFF_BOTTOM |
---|---|
Seq. Order | 13 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | 0 |
Status | Active |
Description |
The time when the net began to be retrieved from fishing depth (in Greenwich Mean Time). The date is the same date as DT. |
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 | DURATION |
---|---|
Seq. Order | 14 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 5 |
Scale | 0 |
Status | Active |
Description |
For longline or pot vessels, the time interval from the time that the first part of the line/pot-group was set until the time that the last of the line/pot-group was retrieved (also known as soak time). For trawlers, duration is the length of time during which the net was at fishing level. Duration is the difference between the NETS_ON_BOTTOM and the NETS_OFF_BOTTOM. Recorded in minutes. |
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_TOWS |
---|---|
Seq. Order | 15 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 3 |
Scale | 0 |
Status | Active |
Description |
Is only not null for vessels where fishing information is recorded as a daily event. Prior to 1977, all data were compiled as a daily event and are associated with a Noon Position. When HAUL=0, then NUMBER_OF_TOWS is the number of tows that occurred that day. After 1976, only true motherships and, through 1983, joint venture motherships were combined on a daily basis. In 1988, two cruises (2943 B002 and 2977 B002) were the exception to this rule. The observers made a mistake and the data were combined by day. For an unknown reason, there are also 17 records where HAUL=0, NUMBER_OF_TOWS>0, and OFFICIAL_TOTAL_CATCH is 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 | OFFICIAL_TOTAL_CATCH |
---|---|
Seq. Order | 16 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 6 |
Scale | 2 |
Status | Active |
Description |
Final estimate of catch weight (MT) for the set or haul, made by vessel personnel, includes both retained and discarded species, and is recorded to the nearest one-hundredth of a metric ton. If original_ships_estimate is not null, official_total_catch is the original_ships_estimate adjusted by the observer to include prohibited species and non-allocated species. If NUMBER_OF_TOWS>0, then OFFICIAL_TOTAL_CATCH is the total catch for the day. |
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 | SPEED |
---|---|
Seq. Order | 17 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 2 |
Scale | 1 |
Status | Active |
Description |
Average towing speed of the vessel during the tow, recorded to the tenth of a knot. Recorded from the vessel logbook. |
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 | WEATHER |
---|---|
Seq. Order | 18 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 1 |
Scale | 0 |
Status | Active |
Description |
A one-digit numeric code identifying the weather conditions during the fishing operation. NORPAC.FOREIGN_WEATHER provides a description of the codes. |
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 |
NORPAC.FOREIGN_WEATHER |
Derivation | |
Validation Rules |
Attribute Name | SEA |
---|---|
Seq. Order | 19 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 1 |
Scale | 0 |
Status | Active |
Description |
A one-digit numeric code identifying the sea conditions during the fishing operation. NORPAC.FOREIGN_SEA provides a description of the codes. |
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 |
NORPAC.FOREIGN_SEA |
Derivation | |
Validation Rules |
Attribute Name | SURFACE_WATER_TEMP |
---|---|
Seq. Order | 20 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 3 |
Scale | 1 |
Status | Active |
Description |
The temperature of the surface water in degrees Celsius. |
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_WATER_TEMP |
---|---|
Seq. Order | 21 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 3 |
Scale | 1 |
Status | Active |
Description |
The temperature of the water at fishing depth in degrees Celsius. |
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_TIME |
---|---|
Seq. Order | 22 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | 0 |
Status | Active |
Description |
The time (Greenwich Mean Time) when the tow was delivered to the joint venture mothership. Recorded from vessel logs or observer observation. |
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 | 23 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 3 |
Scale | 0 |
Status | Active |
Description |
The number of hachi (skates) for a single set. |
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 | HOOKS_PER_SKATE |
---|---|
Seq. Order | 24 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 6 |
Scale | 0 |
Status | Active |
Description |
The average number of hooks in a (hachi) skate. |
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 | OBSERVER_CATCH_ESTIMATE |
---|---|
Seq. Order | 25 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 6 |
Scale | 2 |
Status | Active |
Description |
Estimate of total catch for the set or haul made by the observer, recorded to the nearest one-hundredth of a metric ton. See observer instruction manuals for specific information on possible estimation methods. |
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 | ORIGINAL_SHIPS_ESTIMATE |
---|---|
Seq. Order | 26 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 6 |
Scale | 2 |
Status | Active |
Description |
Similar to NORPAC.DOMESTIC_HAUL.VESSEL_ESTIMATE, this is the initial estimate of the catch made by the vessel, recorded to one-hundredth of a metric ton. |
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 | ADFG_NUMBER |
---|---|
Seq. Order | 27 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 6 |
Scale | 0 |
Status | Active |
Description |
If a U. S. vessel delivered the haul to a vessel carrying an observer, this field contains the Alaska Department of Fish and Game (ADF&G) vessel code number of the delivering vessel. NORPAC.FOREIGN_CATCHER_BOAT provides the names of the catcher boats and the coast guard numbers associated with the codes. |
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 |
NORPAC.FOREIGN_CATCHER_BOAT |
Derivation | |
Validation Rules |
Attribute Name | NUMBER_OF_POTS |
---|---|
Seq. Order | 28 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 3 |
Scale | 0 |
Status | Active |
Description |
For pot vessels, the total number of pots in a set, i.e., the number of pots or group of pots in the set that were retrieved. |
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 | MM_MONITORED_RANDOM |
---|---|
Seq. Order | 29 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
This field is null. |
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 | HAUL_JOIN |
---|---|
Seq. Order | 30 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | Yes |
Primary Key | Yes |
Precision | 6 |
Scale | 0 |
Status | Active |
Description |
An assigned, unique number (up to 6 digits) that uniquely identifies each haul/set associated with vessel data. NORPAC.FOREIGN_HAUL.HAUL_JOIN links a single haul record to records in many of the foreign tables. |
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 | GENERIC_AREA |
---|---|
Seq. Order | 31 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | 3 |
Scale | 0 |
Status | Active |
Description |
A three-digit number representing NORPAC database management subareas which, in most cases, are similar to NPFMC management areas. NORPAC.AREA links latitude and longitude to GENERIC_AREA (called GENERIC). |
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_SAMPLED_BY |
---|---|
Seq. Order | 32 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
A one-digit numeric code indicating whether or not a haul was sampled for species composition: 0 = not sampled, 9 = sampled. If more than one observer was onboard the vessel, there is no way of knowing which observer sampled the 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 | |
---|---|
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 | 9572 |
---|---|
Metadata Record Created By | Doug Turnbull |
Metadata Record Created | 2009-06-29 18:15+0000 |
Metadata Record Last Modified By | SysAdmin InPortAdmin |
» Metadata Record Last Modified | 2022-08-09 17:11+0000 |
Metadata Record Published | 2016-05-18 |
Owner Org | AFSC |
Metadata Publication Status | Published Externally |
Do Not Publish? | N |
Metadata Workflow State | Published / External |
Metadata Last Review Date | 2016-05-18 |
Metadata Review Frequency | 1 Year |
Metadata Next Review Date | 2017-05-18 |
Tags |
---|