NMFS Daily Lobster Catch Report
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:1140 | Updated: February 20, 2025 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
This ORACLE flatfile contains the lobster logbook data.
DescriptionNMFS Daily Lobster Catch Report.
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
DATASET_CODE
VARCHAR2 |
Number assigned by SIS Data staff (data set name) |
VERSION_CODE
VARCHAR2 |
Dataset version assigned by SIS Data staff |
VESSEL_NAME
VARCHAR2 |
Name of the fishing vessel |
PERMIT_NUMBER
VARCHAR2 |
U.S. Coast Guard document number of the vessel, which serves as the permit number |
TRIP_NUMBER
VARCHAR2 |
Sequential number assigned by FMSD staff to each set of vessel's logbook sheets after a fishing trip |
LANDING_YEAR
VARCHAR2 |
Year that the vessel arrived at port from a fishing trip |
LANDING_MONTH
VARCHAR2 |
Month that the vessel arrived at port from a fishing trip |
CREW_SIZE
VARCHAR2 |
Total number of crew members, including the vessel captain |
SET_YEAR
VARCHAR2 |
Year that the lobster traps were set |
SET_MONTH
VARCHAR2 |
Month that the lobster traps were set |
SET_DAY
VARCHAR2 |
Day that the lobster traps were set |
BEGIN_SET_TIME
VARCHAR2 |
Time that the setting of the lobster traps started |
NUMBER_OF_TRAPS_SET
VARCHAR2 |
Number of lobster traps that were set |
HAUL_YEAR
VARCHAR2 |
Year that the lobster traps were hauled |
HAUL_MONTH
VARCHAR2 |
Month that the lobster traps were hauled |
HAUL_DAY
VARCHAR2 |
Day that the lobster traps were hauled |
END_HAUL_TIME
VARCHAR2 |
Time that the hauling of the lobster traps ended |
NUMBER_OF_TRAPS_HAULED
VARCHAR2 |
Number of lobster traps that were hauled; lost or unhauled traps were not included. |
NUMBER_OF_TRAPS_LOST
VARCHAR2 |
Number of lobster traps that were lost |
SPECIES_CODE
VARCHAR2 |
10-digit CZM species code |
NUMBER_OF_LEGALS
VARCHAR2 |
Number of legal lobsters trapped |
NUMBER_OF_SUBLEGALS
VARCHAR2 |
Number of sublegal lobsters trapped |
NUMBER_OF_BERRIED
VARCHAR2 |
Number of berried lobsters trapped |
NUMBER_OF_RELEASED
VARCHAR2 |
Number of lobsters released |
TOTAL_NUMBER_CAUGHT
VARCHAR2 |
Total number of lobster caught |
NUMBER_OF_KEPT_NONBERRIED
VARCHAR2 |
Number of nonberried lobster that were kept |
NUMBER_OF_KEPT_BERRIED
VARCHAR2 |
Number of berried lobsters that were kept |
NUMBER_OF_DISCARD_NONBERRIED
VARCHAR2 |
Number of nonberried lobsters that were discarded |
NUMBER_OF_DISCARD_BERRIED
VARCHAR2 |
Number of berried lobsters that were discarded |
NEW_DAY_CODE
VARCHAR2 |
Code to indicate a new day (N, Y, T, F) |
NEW_SHEET_CODE
VARCHAR2 |
Code to indicate a new sheet (N, Y, T, F) |
WAVE_HEIGHT_CODE
VARCHAR2 |
Code for wave height, in feet: Code Wave Height 1 0 - 2 feet 2 2 - 4 feet 3 4 - 6 feet 4 6 - 8 feet 5 8 - 10 feet 6 10 - 15 feet 7 > 15 feet |
SEA_SURFACE_TEMPERATURE_F
VARCHAR2 |
Sea surface temperature in Fahrenheit, decimal point assumed. 759 -> 75.9 F |
SEA_SURFACE_TEMPERATURE_C
VARCHAR2 |
Sea surface temperature in Celsius. |
MINIMUM_WIND_SPEED
VARCHAR2 |
Wind speed - minimum |
MAXIMUM_WIND_SPEED
VARCHAR2 |
Wind speed - maximum |
NUMBER_OBS_IN_AREA_M_SEAL
VARCHAR2 |
Number of monk seals observed in the area |
NUMBER_OBS_IN_AREA_TURTLE
VARCHAR2 |
Number of turtles observed in the area |
NUMBER_OBS_VIC_GEAR_M_SEAL
VARCHAR2 |
Number of monk seals observed in the vicinity of the gear |
NUMBER_OBS_VIC_GEAR_TURTLE
VARCHAR2 |
Number of turtles observed in the vicinity of the gear |
NUMBER_INT_FISH_OP_M_SEAL
VARCHAR2 |
Number of monk seals interfering with the fishing operation |
NUMBER_INT_FISH_OP_TURTLE
VARCHAR2 |
Number of turtles interfering with the fishing operation |
NUMBER_PREY_RLS_LOB_M_SEAL
VARCHAR2 |
Number of monk seal preying on the released lobster |
NUMBER_PREY_RLS_LOB_TURTLE
VARCHAR2 |
Number of turtles preying on the released lobster |
NUMBER_ENTG_RLS_ALIVE_M_SEAL
VARCHAR2 |
Number of monk seals entangled and released alive |
NUMBER_ENTG_RLS_ALIVE_TURTLE
VARCHAR2 |
Number of turtles entangled and released alive |
NUMBER_ENTG_RLS_DEAD_M_SEAL
VARCHAR2 |
Number of monk seals entangled and released dead |
NUMBER_ENTG_RLS_DEAD_TURTLE
VARCHAR2 |
Number of turtles entangled and released dead |
STATISICAL_AREA_1
VARCHAR2 |
DAR statistical area where fishing occurred - line # 1 |
NWHI_SUBAREA_1_1
VARCHAR2 |
DAR NWHI Subarea where fishing occurred - line # 1 - 1 |
NWHI_SUBAREA_1_2
VARCHAR2 |
DAR NWHI Subarea where fishing occurred - line # 1 - 2 |
NWHI_SUBAREA_1_3
VARCHAR2 |
DAR NWHI Subarea where fishing occurred - line # 1 - 3 |
NWHI_SUBAREA_1_4
VARCHAR2 |
DAR NWHI Subarea where fishing occurred - line # 1 - 4 |
NUMBER_INT_FISH_OP_OTHER
VARCHAR2 |
Number of other protected species (identify in appropriate box) interfering with the fishing operation |
NUMBER_PREY_RLS_LOB_OTHER
VARCHAR2 |
Number of other protected species (identify in appropriate box) preying on the released lobster |
NUMBER_ENTG_RLS_ALIVE_OTHER
VARCHAR2 |
Number of other proteced species (identify in appropriate box) entangled and released alive |
NUMBER_ENTG_RLS_DEAD_OTHER
VARCHAR2 |
Number of other protected species (identify in appropriate box) entangled and released dead |
RADIO_CALL_SIGN
VARCHAR2 |
Radio call sign |
NUMBER_OF_TRAPS_CARRIED
VARCHAR2 |
Number of traps carried by the fishing vessel |
NUM_TRAPS_HAUL_1_NITE
VARCHAR2 |
Number of traps hauled - one night set |
NUM_TRAPS_HAUL_2_NITE
VARCHAR2 |
Number of traps hauled - two night set |
NUM_TRAPS_HAUL_3_NITE
VARCHAR2 |
Number of traps hauled - three night set |
NUM_TRAPS_HAUL_4_NITE
VARCHAR2 |
Number of traps hauled - four night set |
NUM_TRAPS_HAUL_5_NITE
VARCHAR2 |
Number of traps hauled - five night set |
NUM_TRAPS_HAUL_6_OR_MORE_NITE
VARCHAR2 |
Number of traps hauled - six or more night set |
STATISTICAL_AREA_2
VARCHAR2 |
DAR statistical area where fishing occurred - line # 2 |
NWHI_SUBAREA_2_1
VARCHAR2 |
DAR NWHI Subarea where fishing occurred - line # 2 - 1 |
NWHI_SUBAREA_2_2
VARCHAR2 |
DAR NWHI Subarea where fishing occurred - line # 2 - 2 |
NWHI_SUBAREA_2_3
VARCHAR2 |
DAR NWHI Subarea where fishing occurred - line # 2 - 3 |
NWHI_SUBAREA_2_4
VARCHAR2 |
DAR NWHI Subarea where fishing occurred - line # 2 - 4 |
STATISTICAL_AREA_3
VARCHAR2 |
DAR statistical area where fishing occurred - line # 3 |
NWHI_SUBAREA_3_1
VARCHAR2 |
DAR NWHI Subarea where fishing occurred - line # 3 - 1 |
NWHI_SUBAREA_3_2
VARCHAR2 |
DAR NWHI Subarea where fishing occurred - line # 3 - 2 |
NWHI_SUBAREA_3_3
VARCHAR2 |
DAR NWHI Subarea where fishing occurred - line # 3 - 3 |
NWHI_SUBAREA_3_4
VARCHAR2 |
DAR NWHI Subarea where fishing occurred - line # 3 - 4 |
STATISTICAL_AREA_4
VARCHAR2 |
DAR statistical area where fishing occurred - line # 4 |
NWHI_SUBAREA_4_1
VARCHAR2 |
DAR NWHI Subarea where fishing occurred - line # 4 - 1 |
NWHI_SUBAREA_4_2
VARCHAR2 |
DAR NWHI Subarea where fishing occurred - line # 4 - 2 |
NWHI_SUBAREA_4_3
VARCHAR2 |
DAR NWHI Subarea where fishing occurred - line # 4 - 3 |
NWHI_SUBAREA_4_4
VARCHAR2 |
DAR NWHI Subarea where fishing occurred - line # 4 - 4 |
STATISTICAL_AREA_5
VARCHAR2 |
DAR statistical area where fishing occurred - line # 5 |
NWHI_SUBAREA_5_1
VARCHAR2 |
DAR NWHI Subarea where fishing occurred - line # 5 - 1 |
NWHI_SUBAREA_5_2
VARCHAR2 |
DAR NWHI Subarea where fishing occurred - line # 5 - 2 |
NWHI_SUBAREA_5_3
VARCHAR2 |
DAR NWHI Subarea where fishing occurred - line # 5 - 3 |
NWHI_SUBAREA_5_4
VARCHAR2 |
DAR NWHI Subarea where fishing occurred - line # 5 - 4 |
STATISTICAL_AREA_6
VARCHAR2 |
DAR statistical area where fishing occurred - line # 6 |
NWHI_SUBAREA_6_1
VARCHAR2 |
DAR NWHI Subarea where fishing occurred - line # 6 - 1 |
NWHI_SUBAREA_6_2
VARCHAR2 |
DAR NWHI Subarea where fishing occurred - line # 6 - 2 |
NWHI_SUBAREA_6_3
VARCHAR2 |
DAR NWHI Subarea where fishing occurred - line # 6 - 3 |
NWHI_SUBAREA_6_4
VARCHAR2 |
DAR NWHI Subarea where fishing occurred - line # 6 - 4 |
BANK_FISHED
VARCHAR2 |
Name of the NWHI bank where the fishing operation occurred |
BATCH_NUMBER
VARCHAR2 |
Number assigned by FDMP staff (job number) |
SEQUENCE_NUMBER
VARCHAR2 |
Number assigned by FDMP staff; usually signifies the count for the specific batch that was loaded |
Child Items
No Child Items for this record.
Contact Information
Point of Contact
David C Hamm
david.hamm@noaa.gov
(808)983-5330
Extents
1980-06-19 - 1999-09-02
Item Identification
Title: | NMFS Daily Lobster Catch Report |
---|---|
Short Name: | FC022 NMFS Daily Lobster Catch Report |
Status: | Completed |
Abstract: |
This ORACLE flatfile contains the lobster logbook data. |
Supplemental Information: |
Current version: FC022AA7 |
Keywords
Theme Keywords
Thesaurus | Keyword |
---|---|
UNCONTROLLED | |
None | logbook |
None | protected species observation |
None | slipper lobster |
None | spiny lobster |
Temporal Keywords
Thesaurus | Keyword |
---|---|
UNCONTROLLED | |
None | 1980 - 1999 |
Spatial Keywords
Thesaurus | Keyword |
---|---|
UNCONTROLLED | |
None | Northwestern Hawaiian Island (NWHI) |
None | Pacific Ocean |
Physical Location
Organization: | Pacific Islands Fisheries Science Center |
---|---|
City: | Honolulu |
State/Province: | HI |
Country: | USA |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Alias: | FC022AA7 |
Schema Name: | ORADATA |
Description: |
NMFS Daily Lobster Catch Report. |
Data Attributes
Attribute Summary
![]() |
![]() |
Name | Type | Description |
---|---|---|---|---|
100
|
DATASET_CODE | VARCHAR2 | Number assigned by SIS Data staff (data set name) | |
100
|
VERSION_CODE | VARCHAR2 | Dataset version assigned by SIS Data staff | |
100
|
VESSEL_NAME | VARCHAR2 | Name of the fishing vessel | |
100
|
PERMIT_NUMBER | VARCHAR2 | U.S. Coast Guard document number of the vessel, which serves as the permit number | |
100
|
TRIP_NUMBER | VARCHAR2 | Sequential number assigned by FMSD staff to each set of vessel's logbook sheets after a fishing trip | |
100
|
LANDING_YEAR | VARCHAR2 | Year that the vessel arrived at port from a fishing trip | |
100
|
LANDING_MONTH | VARCHAR2 | Month that the vessel arrived at port from a fishing trip | |
100
|
CREW_SIZE | VARCHAR2 | Total number of crew members, including the vessel captain | |
100
|
SET_YEAR | VARCHAR2 | Year that the lobster traps were set | |
100
|
SET_MONTH | VARCHAR2 | Month that the lobster traps were set | |
100
|
SET_DAY | VARCHAR2 | Day that the lobster traps were set | |
100
|
BEGIN_SET_TIME | VARCHAR2 | Time that the setting of the lobster traps started | |
100
|
NUMBER_OF_TRAPS_SET | VARCHAR2 | Number of lobster traps that were set | |
100
|
HAUL_YEAR | VARCHAR2 | Year that the lobster traps were hauled | |
100
|
HAUL_MONTH | VARCHAR2 | Month that the lobster traps were hauled | |
100
|
HAUL_DAY | VARCHAR2 | Day that the lobster traps were hauled | |
100
|
END_HAUL_TIME | VARCHAR2 | Time that the hauling of the lobster traps ended | |
100
|
NUMBER_OF_TRAPS_HAULED | VARCHAR2 | Number of lobster traps that were hauled; lost or unhauled traps were not included. | |
100
|
NUMBER_OF_TRAPS_LOST | VARCHAR2 | Number of lobster traps that were lost | |
100
|
SPECIES_CODE | VARCHAR2 | 10-digit CZM species code | |
100
|
NUMBER_OF_LEGALS | VARCHAR2 | Number of legal lobsters trapped | |
100
|
NUMBER_OF_SUBLEGALS | VARCHAR2 | Number of sublegal lobsters trapped | |
100
|
NUMBER_OF_BERRIED | VARCHAR2 | Number of berried lobsters trapped | |
100
|
NUMBER_OF_RELEASED | VARCHAR2 | Number of lobsters released | |
100
|
TOTAL_NUMBER_CAUGHT | VARCHAR2 | Total number of lobster caught | |
100
|
NUMBER_OF_KEPT_NONBERRIED | VARCHAR2 | Number of nonberried lobster that were kept | |
100
|
NUMBER_OF_KEPT_BERRIED | VARCHAR2 | Number of berried lobsters that were kept | |
100
|
NUMBER_OF_DISCARD_NONBERRIED | VARCHAR2 | Number of nonberried lobsters that were discarded | |
100
|
NUMBER_OF_DISCARD_BERRIED | VARCHAR2 | Number of berried lobsters that were discarded | |
100
|
NEW_DAY_CODE | VARCHAR2 | Code to indicate a new day (N, Y, T, F) | |
100
|
NEW_SHEET_CODE | VARCHAR2 | Code to indicate a new sheet (N, Y, T, F) | |
100
|
WAVE_HEIGHT_CODE | VARCHAR2 | Code for wave height, in feet: Code Wave Height 1 0 - 2 feet 2 2 - 4 feet 3 4 - 6 feet 4 6 - 8 feet 5 8 - 10 feet 6 10 - 15 feet 7 > 15 feet | |
100
|
SEA_SURFACE_TEMPERATURE_F | VARCHAR2 | Sea surface temperature in Fahrenheit, decimal point assumed. 759 -> 75.9 F | |
100
|
SEA_SURFACE_TEMPERATURE_C | VARCHAR2 | Sea surface temperature in Celsius. | |
100
|
MINIMUM_WIND_SPEED | VARCHAR2 | Wind speed - minimum | |
100
|
MAXIMUM_WIND_SPEED | VARCHAR2 | Wind speed - maximum | |
100
|
NUMBER_OBS_IN_AREA_M_SEAL | VARCHAR2 | Number of monk seals observed in the area | |
100
|
NUMBER_OBS_IN_AREA_TURTLE | VARCHAR2 | Number of turtles observed in the area | |
100
|
NUMBER_OBS_VIC_GEAR_M_SEAL | VARCHAR2 | Number of monk seals observed in the vicinity of the gear | |
100
|
NUMBER_OBS_VIC_GEAR_TURTLE | VARCHAR2 | Number of turtles observed in the vicinity of the gear | |
100
|
NUMBER_INT_FISH_OP_M_SEAL | VARCHAR2 | Number of monk seals interfering with the fishing operation | |
100
|
NUMBER_INT_FISH_OP_TURTLE | VARCHAR2 | Number of turtles interfering with the fishing operation | |
100
|
NUMBER_PREY_RLS_LOB_M_SEAL | VARCHAR2 | Number of monk seal preying on the released lobster | |
100
|
NUMBER_PREY_RLS_LOB_TURTLE | VARCHAR2 | Number of turtles preying on the released lobster | |
100
|
NUMBER_ENTG_RLS_ALIVE_M_SEAL | VARCHAR2 | Number of monk seals entangled and released alive | |
100
|
NUMBER_ENTG_RLS_ALIVE_TURTLE | VARCHAR2 | Number of turtles entangled and released alive | |
100
|
NUMBER_ENTG_RLS_DEAD_M_SEAL | VARCHAR2 | Number of monk seals entangled and released dead | |
100
|
NUMBER_ENTG_RLS_DEAD_TURTLE | VARCHAR2 | Number of turtles entangled and released dead | |
100
|
STATISICAL_AREA_1 | VARCHAR2 | DAR statistical area where fishing occurred - line # 1 | |
100
|
NWHI_SUBAREA_1_1 | VARCHAR2 | DAR NWHI Subarea where fishing occurred - line # 1 - 1 | |
100
|
NWHI_SUBAREA_1_2 | VARCHAR2 | DAR NWHI Subarea where fishing occurred - line # 1 - 2 | |
100
|
NWHI_SUBAREA_1_3 | VARCHAR2 | DAR NWHI Subarea where fishing occurred - line # 1 - 3 | |
100
|
NWHI_SUBAREA_1_4 | VARCHAR2 | DAR NWHI Subarea where fishing occurred - line # 1 - 4 | |
100
|
NUMBER_INT_FISH_OP_OTHER | VARCHAR2 | Number of other protected species (identify in appropriate box) interfering with the fishing operation | |
100
|
NUMBER_PREY_RLS_LOB_OTHER | VARCHAR2 | Number of other protected species (identify in appropriate box) preying on the released lobster | |
100
|
NUMBER_ENTG_RLS_ALIVE_OTHER | VARCHAR2 | Number of other proteced species (identify in appropriate box) entangled and released alive | |
100
|
NUMBER_ENTG_RLS_DEAD_OTHER | VARCHAR2 | Number of other protected species (identify in appropriate box) entangled and released dead | |
100
|
RADIO_CALL_SIGN | VARCHAR2 | Radio call sign | |
100
|
NUMBER_OF_TRAPS_CARRIED | VARCHAR2 | Number of traps carried by the fishing vessel | |
100
|
NUM_TRAPS_HAUL_1_NITE | VARCHAR2 | Number of traps hauled - one night set | |
100
|
NUM_TRAPS_HAUL_2_NITE | VARCHAR2 | Number of traps hauled - two night set | |
100
|
NUM_TRAPS_HAUL_3_NITE | VARCHAR2 | Number of traps hauled - three night set | |
100
|
NUM_TRAPS_HAUL_4_NITE | VARCHAR2 | Number of traps hauled - four night set | |
100
|
NUM_TRAPS_HAUL_5_NITE | VARCHAR2 | Number of traps hauled - five night set | |
100
|
NUM_TRAPS_HAUL_6_OR_MORE_NITE | VARCHAR2 | Number of traps hauled - six or more night set | |
100
|
STATISTICAL_AREA_2 | VARCHAR2 | DAR statistical area where fishing occurred - line # 2 | |
100
|
NWHI_SUBAREA_2_1 | VARCHAR2 | DAR NWHI Subarea where fishing occurred - line # 2 - 1 | |
100
|
NWHI_SUBAREA_2_2 | VARCHAR2 | DAR NWHI Subarea where fishing occurred - line # 2 - 2 | |
100
|
NWHI_SUBAREA_2_3 | VARCHAR2 | DAR NWHI Subarea where fishing occurred - line # 2 - 3 | |
100
|
NWHI_SUBAREA_2_4 | VARCHAR2 | DAR NWHI Subarea where fishing occurred - line # 2 - 4 | |
100
|
STATISTICAL_AREA_3 | VARCHAR2 | DAR statistical area where fishing occurred - line # 3 | |
100
|
NWHI_SUBAREA_3_1 | VARCHAR2 | DAR NWHI Subarea where fishing occurred - line # 3 - 1 | |
100
|
NWHI_SUBAREA_3_2 | VARCHAR2 | DAR NWHI Subarea where fishing occurred - line # 3 - 2 | |
100
|
NWHI_SUBAREA_3_3 | VARCHAR2 | DAR NWHI Subarea where fishing occurred - line # 3 - 3 | |
100
|
NWHI_SUBAREA_3_4 | VARCHAR2 | DAR NWHI Subarea where fishing occurred - line # 3 - 4 | |
100
|
STATISTICAL_AREA_4 | VARCHAR2 | DAR statistical area where fishing occurred - line # 4 | |
100
|
NWHI_SUBAREA_4_1 | VARCHAR2 | DAR NWHI Subarea where fishing occurred - line # 4 - 1 | |
100
|
NWHI_SUBAREA_4_2 | VARCHAR2 | DAR NWHI Subarea where fishing occurred - line # 4 - 2 | |
100
|
NWHI_SUBAREA_4_3 | VARCHAR2 | DAR NWHI Subarea where fishing occurred - line # 4 - 3 | |
100
|
NWHI_SUBAREA_4_4 | VARCHAR2 | DAR NWHI Subarea where fishing occurred - line # 4 - 4 | |
100
|
STATISTICAL_AREA_5 | VARCHAR2 | DAR statistical area where fishing occurred - line # 5 | |
100
|
NWHI_SUBAREA_5_1 | VARCHAR2 | DAR NWHI Subarea where fishing occurred - line # 5 - 1 | |
100
|
NWHI_SUBAREA_5_2 | VARCHAR2 | DAR NWHI Subarea where fishing occurred - line # 5 - 2 | |
100
|
NWHI_SUBAREA_5_3 | VARCHAR2 | DAR NWHI Subarea where fishing occurred - line # 5 - 3 | |
100
|
NWHI_SUBAREA_5_4 | VARCHAR2 | DAR NWHI Subarea where fishing occurred - line # 5 - 4 | |
100
|
STATISTICAL_AREA_6 | VARCHAR2 | DAR statistical area where fishing occurred - line # 6 | |
100
|
NWHI_SUBAREA_6_1 | VARCHAR2 | DAR NWHI Subarea where fishing occurred - line # 6 - 1 | |
100
|
NWHI_SUBAREA_6_2 | VARCHAR2 | DAR NWHI Subarea where fishing occurred - line # 6 - 2 | |
100
|
NWHI_SUBAREA_6_3 | VARCHAR2 | DAR NWHI Subarea where fishing occurred - line # 6 - 3 | |
100
|
NWHI_SUBAREA_6_4 | VARCHAR2 | DAR NWHI Subarea where fishing occurred - line # 6 - 4 | |
100
|
BANK_FISHED | VARCHAR2 | Name of the NWHI bank where the fishing operation occurred | |
100
|
BATCH_NUMBER | VARCHAR2 | Number assigned by FDMP staff (job number) | |
100
|
SEQUENCE_NUMBER | VARCHAR2 | Number assigned by FDMP staff; usually signifies the count for the specific batch that was loaded |
Attribute Details
DATASET_CODE
Seq. Order: | 1 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 5 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number assigned by SIS Data staff (data set name) |
General Data Type: | CHARACTER |
Case Restriction: | Upper |
Display Example: | FC022 |
Allowed Values: | FC022 |
Default Value: | FC022 |
VERSION_CODE
Seq. Order: | 2 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Dataset version assigned by SIS Data staff |
General Data Type: | CHARACTER |
Case Restriction: | Upper |
Display Example: | AA7 |
Allowed Values: | AA1, AA2, AA3, AA4, AA5, AA6, AA7 |
VESSEL_NAME
Seq. Order: | 3 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 20 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Name of the fishing vessel |
General Data Type: | CHARACTER |
Case Restriction: | Upper |
Display Example: | ALASKA GULF |
PERMIT_NUMBER
Seq. Order: | 4 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
U.S. Coast Guard document number of the vessel, which serves as the permit number |
General Data Type: | INTEGER |
TRIP_NUMBER
Seq. Order: | 5 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Sequential number assigned by FMSD staff to each set of vessel's logbook sheets after a fishing trip |
General Data Type: | INTEGER |
LANDING_YEAR
Seq. Order: | 6 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Year that the vessel arrived at port from a fishing trip |
General Data Type: | INTEGER |
Display Example: | 1999 |
LANDING_MONTH
Seq. Order: | 7 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Month that the vessel arrived at port from a fishing trip |
General Data Type: | INTEGER |
CREW_SIZE
Seq. Order: | 8 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Total number of crew members, including the vessel captain |
General Data Type: | INTEGER |
SET_YEAR
Seq. Order: | 9 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Year that the lobster traps were set |
General Data Type: | INTEGER |
SET_MONTH
Seq. Order: | 10 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Month that the lobster traps were set |
General Data Type: | INTEGER |
SET_DAY
Seq. Order: | 11 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Day that the lobster traps were set |
General Data Type: | INTEGER |
BEGIN_SET_TIME
Seq. Order: | 12 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Time that the setting of the lobster traps started |
General Data Type: | INTEGER |
NUMBER_OF_TRAPS_SET
Seq. Order: | 13 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of lobster traps that were set |
General Data Type: | INTEGER |
HAUL_YEAR
Seq. Order: | 14 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Year that the lobster traps were hauled |
General Data Type: | INTEGER |
HAUL_MONTH
Seq. Order: | 15 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Month that the lobster traps were hauled |
General Data Type: | INTEGER |
HAUL_DAY
Seq. Order: | 16 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Day that the lobster traps were hauled |
General Data Type: | INTEGER |
END_HAUL_TIME
Seq. Order: | 17 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Time that the hauling of the lobster traps ended |
General Data Type: | INTEGER |
NUMBER_OF_TRAPS_HAULED
Seq. Order: | 18 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of lobster traps that were hauled; lost or unhauled traps were not included. |
General Data Type: | INTEGER |
NUMBER_OF_TRAPS_LOST
Seq. Order: | 19 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of lobster traps that were lost |
General Data Type: | INTEGER |
SPECIES_CODE
Seq. Order: | 20 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 10 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
10-digit CZM species code |
General Data Type: | INTEGER |
NUMBER_OF_LEGALS
Seq. Order: | 21 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of legal lobsters trapped |
General Data Type: | INTEGER |
NUMBER_OF_SUBLEGALS
Seq. Order: | 22 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of sublegal lobsters trapped |
General Data Type: | INTEGER |
NUMBER_OF_BERRIED
Seq. Order: | 23 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of berried lobsters trapped |
General Data Type: | INTEGER |
NUMBER_OF_RELEASED
Seq. Order: | 24 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of lobsters released |
General Data Type: | INTEGER |
TOTAL_NUMBER_CAUGHT
Seq. Order: | 25 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 5 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Total number of lobster caught |
General Data Type: | INTEGER |
NUMBER_OF_KEPT_NONBERRIED
Seq. Order: | 26 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of nonberried lobster that were kept |
General Data Type: | INTEGER |
NUMBER_OF_KEPT_BERRIED
Seq. Order: | 27 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of berried lobsters that were kept |
General Data Type: | INTEGER |
NUMBER_OF_DISCARD_NONBERRIED
Seq. Order: | 28 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of nonberried lobsters that were discarded |
General Data Type: | INTEGER |
NUMBER_OF_DISCARD_BERRIED
Seq. Order: | 29 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of berried lobsters that were discarded |
General Data Type: | INTEGER |
NEW_DAY_CODE
Seq. Order: | 30 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code to indicate a new day (N, Y, T, F) |
General Data Type: | CHARACTER |
NEW_SHEET_CODE
Seq. Order: | 31 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code to indicate a new sheet (N, Y, T, F) |
General Data Type: | CHARACTER |
WAVE_HEIGHT_CODE
Seq. Order: | 32 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code for wave height, in feet: Code Wave Height 1 0 - 2 feet 2 2 - 4 feet 3 4 - 6 feet 4 6 - 8 feet 5 8 - 10 feet 6 10 - 15 feet 7 > 15 feet |
General Data Type: | INTEGER |
SEA_SURFACE_TEMPERATURE_F
Seq. Order: | 33 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Sea surface temperature in Fahrenheit, decimal point assumed. 759 -> 75.9 F |
General Data Type: | INTEGER |
Unit of Measure: | Fahrenheit |
Display Example: | 759 |
SEA_SURFACE_TEMPERATURE_C
Seq. Order: | 34 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Sea surface temperature in Celsius. |
General Data Type: | INTEGER |
Unit of Measure: | Celcius |
MINIMUM_WIND_SPEED
Seq. Order: | 35 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Wind speed - minimum |
General Data Type: | INTEGER |
Unit of Measure: | Knots |
MAXIMUM_WIND_SPEED
Seq. Order: | 36 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Wind speed - maximum |
General Data Type: | INTEGER |
Unit of Measure: | Knots |
NUMBER_OBS_IN_AREA_M_SEAL
Seq. Order: | 37 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of monk seals observed in the area |
General Data Type: | INTEGER |
NUMBER_OBS_IN_AREA_TURTLE
Seq. Order: | 38 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of turtles observed in the area |
General Data Type: | INTEGER |
NUMBER_OBS_VIC_GEAR_M_SEAL
Seq. Order: | 39 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of monk seals observed in the vicinity of the gear |
General Data Type: | INTEGER |
NUMBER_OBS_VIC_GEAR_TURTLE
Seq. Order: | 40 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of turtles observed in the vicinity of the gear |
General Data Type: | INTEGER |
NUMBER_INT_FISH_OP_M_SEAL
Seq. Order: | 41 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of monk seals interfering with the fishing operation |
General Data Type: | INTEGER |
NUMBER_INT_FISH_OP_TURTLE
Seq. Order: | 42 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of turtles interfering with the fishing operation |
General Data Type: | INTEGER |
NUMBER_PREY_RLS_LOB_M_SEAL
Seq. Order: | 43 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of monk seal preying on the released lobster |
General Data Type: | INTEGER |
NUMBER_PREY_RLS_LOB_TURTLE
Seq. Order: | 44 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of turtles preying on the released lobster |
General Data Type: | INTEGER |
NUMBER_ENTG_RLS_ALIVE_M_SEAL
Seq. Order: | 45 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of monk seals entangled and released alive |
General Data Type: | INTEGER |
NUMBER_ENTG_RLS_ALIVE_TURTLE
Seq. Order: | 46 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of turtles entangled and released alive |
General Data Type: | INTEGER |
NUMBER_ENTG_RLS_DEAD_M_SEAL
Seq. Order: | 47 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of monk seals entangled and released dead |
General Data Type: | INTEGER |
NUMBER_ENTG_RLS_DEAD_TURTLE
Seq. Order: | 48 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of turtles entangled and released dead |
General Data Type: | INTEGER |
STATISICAL_AREA_1
Seq. Order: | 49 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 5 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
DAR statistical area where fishing occurred - line # 1 |
General Data Type: | INTEGER |
NWHI_SUBAREA_1_1
Seq. Order: | 50 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
DAR NWHI Subarea where fishing occurred - line # 1 - 1 |
General Data Type: | CHARACTER |
Case Restriction: | Upper |
Allowed Values: | A, B, C, D, E, F, G, H, I |
NWHI_SUBAREA_1_2
Seq. Order: | 51 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
DAR NWHI Subarea where fishing occurred - line # 1 - 2 |
General Data Type: | CHARACTER |
Case Restriction: | Upper |
Allowed Values: | A, B, C, D, E, F, G, H, I |
NWHI_SUBAREA_1_3
Seq. Order: | 52 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
DAR NWHI Subarea where fishing occurred - line # 1 - 3 |
General Data Type: | CHARACTER |
Case Restriction: | Upper |
Allowed Values: | A, B, C, D, E, F, G, H, I |
NWHI_SUBAREA_1_4
Seq. Order: | 53 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
DAR NWHI Subarea where fishing occurred - line # 1 - 4 |
General Data Type: | CHARACTER |
Case Restriction: | Upper |
Allowed Values: | A, B, C, D, E, F, G, H, I |
NUMBER_INT_FISH_OP_OTHER
Seq. Order: | 54 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of other protected species (identify in appropriate box) interfering with the fishing operation |
General Data Type: | INTEGER |
NUMBER_PREY_RLS_LOB_OTHER
Seq. Order: | 55 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of other protected species (identify in appropriate box) preying on the released lobster |
General Data Type: | INTEGER |
NUMBER_ENTG_RLS_ALIVE_OTHER
Seq. Order: | 56 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of other proteced species (identify in appropriate box) entangled and released alive |
General Data Type: | INTEGER |
NUMBER_ENTG_RLS_DEAD_OTHER
Seq. Order: | 57 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of other protected species (identify in appropriate box) entangled and released dead |
General Data Type: | INTEGER |
RADIO_CALL_SIGN
Seq. Order: | 58 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 10 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Radio call sign |
General Data Type: | CHARACTER |
Format Mask: | CCC0000000 |
NUMBER_OF_TRAPS_CARRIED
Seq. Order: | 59 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of traps carried by the fishing vessel |
General Data Type: | INTEGER |
NUM_TRAPS_HAUL_1_NITE
Seq. Order: | 60 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of traps hauled - one night set |
General Data Type: | INTEGER |
NUM_TRAPS_HAUL_2_NITE
Seq. Order: | 61 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of traps hauled - two night set |
General Data Type: | INTEGER |
NUM_TRAPS_HAUL_3_NITE
Seq. Order: | 62 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of traps hauled - three night set |
General Data Type: | INTEGER |
NUM_TRAPS_HAUL_4_NITE
Seq. Order: | 63 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of traps hauled - four night set |
General Data Type: | INTEGER |
NUM_TRAPS_HAUL_5_NITE
Seq. Order: | 64 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of traps hauled - five night set |
General Data Type: | INTEGER |
NUM_TRAPS_HAUL_6_OR_MORE_NITE
Seq. Order: | 65 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of traps hauled - six or more night set |
General Data Type: | INTEGER |
STATISTICAL_AREA_2
Seq. Order: | 66 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 5 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
DAR statistical area where fishing occurred - line # 2 |
General Data Type: | INTEGER |
NWHI_SUBAREA_2_1
Seq. Order: | 67 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
DAR NWHI Subarea where fishing occurred - line # 2 - 1 |
General Data Type: | CHARACTER |
Case Restriction: | Upper |
Allowed Values: | A, B, C, D, E, F, G, H, I |
NWHI_SUBAREA_2_2
Seq. Order: | 68 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
DAR NWHI Subarea where fishing occurred - line # 2 - 2 |
General Data Type: | CHARACTER |
Case Restriction: | Upper |
Allowed Values: | A, B, C, D, E, F, G, H, I |
NWHI_SUBAREA_2_3
Seq. Order: | 69 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
DAR NWHI Subarea where fishing occurred - line # 2 - 3 |
General Data Type: | CHARACTER |
Case Restriction: | Upper |
Allowed Values: | A, B, C, D, E, F, G, H, I |
NWHI_SUBAREA_2_4
Seq. Order: | 70 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
DAR NWHI Subarea where fishing occurred - line # 2 - 4 |
General Data Type: | CHARACTER |
Case Restriction: | Upper |
Allowed Values: | A, B, C, D, E, F, G, H, I |
STATISTICAL_AREA_3
Seq. Order: | 71 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 5 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
DAR statistical area where fishing occurred - line # 3 |
General Data Type: | INTEGER |
NWHI_SUBAREA_3_1
Seq. Order: | 72 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
DAR NWHI Subarea where fishing occurred - line # 3 - 1 |
General Data Type: | CHARACTER |
Case Restriction: | Upper |
Allowed Values: | A, B, C, D, E, F, G, H, I |
NWHI_SUBAREA_3_2
Seq. Order: | 73 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
DAR NWHI Subarea where fishing occurred - line # 3 - 2 |
General Data Type: | CHARACTER |
Case Restriction: | Upper |
Allowed Values: | A, B, C, D, E, F, G, H, I |
NWHI_SUBAREA_3_3
Seq. Order: | 74 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
DAR NWHI Subarea where fishing occurred - line # 3 - 3 |
General Data Type: | CHARACTER |
Case Restriction: | Upper |
Allowed Values: | A, B, C, D, E, F, G, H, I |
NWHI_SUBAREA_3_4
Seq. Order: | 75 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
DAR NWHI Subarea where fishing occurred - line # 3 - 4 |
General Data Type: | CHARACTER |
Case Restriction: | Upper |
Allowed Values: | A, B, C, D, E, F, G, H, I |
STATISTICAL_AREA_4
Seq. Order: | 76 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 5 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
DAR statistical area where fishing occurred - line # 4 |
General Data Type: | INTEGER |
NWHI_SUBAREA_4_1
Seq. Order: | 77 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
DAR NWHI Subarea where fishing occurred - line # 4 - 1 |
General Data Type: | CHARACTER |
Case Restriction: | Upper |
Allowed Values: | A, B, C, D, E, F, G, H, I |
NWHI_SUBAREA_4_2
Seq. Order: | 78 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
DAR NWHI Subarea where fishing occurred - line # 4 - 2 |
General Data Type: | CHARACTER |
Case Restriction: | Upper |
Allowed Values: | A, B, C, D, E, F, G, H, I |
NWHI_SUBAREA_4_3
Seq. Order: | 79 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
DAR NWHI Subarea where fishing occurred - line # 4 - 3 |
General Data Type: | CHARACTER |
Case Restriction: | Upper |
Allowed Values: | A, B, C, D, E, F, G, H, I |
NWHI_SUBAREA_4_4
Seq. Order: | 80 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
DAR NWHI Subarea where fishing occurred - line # 4 - 4 |
General Data Type: | CHARACTER |
Case Restriction: | Upper |
Allowed Values: | A, B, C, D, E, F, G, H, I |
STATISTICAL_AREA_5
Seq. Order: | 81 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 5 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
DAR statistical area where fishing occurred - line # 5 |
General Data Type: | INTEGER |
NWHI_SUBAREA_5_1
Seq. Order: | 82 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
DAR NWHI Subarea where fishing occurred - line # 5 - 1 |
General Data Type: | CHARACTER |
Case Restriction: | Upper |
Allowed Values: | A, B, C, D, E, F, G, H, I |
NWHI_SUBAREA_5_2
Seq. Order: | 83 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
DAR NWHI Subarea where fishing occurred - line # 5 - 2 |
General Data Type: | CHARACTER |
Case Restriction: | Upper |
Allowed Values: | A, B, C, D, E, F, G, H, I |
NWHI_SUBAREA_5_3
Seq. Order: | 84 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
DAR NWHI Subarea where fishing occurred - line # 5 - 3 |
General Data Type: | CHARACTER |
Case Restriction: | Upper |
Allowed Values: | A, B, C, D, E, F, G, H, I |
NWHI_SUBAREA_5_4
Seq. Order: | 85 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
DAR NWHI Subarea where fishing occurred - line # 5 - 4 |
General Data Type: | CHARACTER |
Case Restriction: | Upper |
Allowed Values: | A, B, C, D, E, F, G, H, I |
STATISTICAL_AREA_6
Seq. Order: | 86 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 5 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
DAR statistical area where fishing occurred - line # 6 |
General Data Type: | INTEGER |
NWHI_SUBAREA_6_1
Seq. Order: | 87 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
DAR NWHI Subarea where fishing occurred - line # 6 - 1 |
General Data Type: | CHARACTER |
Case Restriction: | Upper |
Allowed Values: | A, B, C, D, E, F, G, H, I |
NWHI_SUBAREA_6_2
Seq. Order: | 88 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
DAR NWHI Subarea where fishing occurred - line # 6 - 2 |
General Data Type: | CHARACTER |
Case Restriction: | Upper |
Allowed Values: | A, B, C, D, E, F, G, H, I |
NWHI_SUBAREA_6_3
Seq. Order: | 89 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
DAR NWHI Subarea where fishing occurred - line # 6 - 3 |
General Data Type: | CHARACTER |
Case Restriction: | Upper |
Allowed Values: | A, B, C, D, E, F, G, H, I |
NWHI_SUBAREA_6_4
Seq. Order: | 90 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
DAR NWHI Subarea where fishing occurred - line # 6 - 4 |
General Data Type: | CHARACTER |
Case Restriction: | Upper |
Allowed Values: | A, B, C, D, E, F, G, H, I |
BANK_FISHED
Seq. Order: | 91 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 20 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Name of the NWHI bank where the fishing operation occurred |
General Data Type: | CHARACTER |
Case Restriction: | Upper |
BATCH_NUMBER
Seq. Order: | 92 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 6 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number assigned by FDMP staff (job number) |
General Data Type: | CHARACTER |
Display Example: | D99429 |
Format Mask: | C00000 |
SEQUENCE_NUMBER
Seq. Order: | 93 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 8 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number assigned by FDMP staff; usually signifies the count for the specific batch that was loaded |
Format Mask: | 00000000 |
Support Roles
Data Steward
Date Effective From: | 2006-06-07 |
---|---|
Date Effective To: | |
Contact (Person): | Kawamoto, Kurt E |
Address: |
1845 Wasp Blvd. Honolulu, HI 96818 USA |
Email Address: | kurt.kawamoto@noaa.gov |
Phone: | (808)725-5326 |
Fax: | (808)725-5475 |
Contact Instructions: |
email kurt.kawamoto@noaa.gov |
Point of Contact
Date Effective From: | 2006-06-07 |
---|---|
Date Effective To: | |
Contact (Person): | Hamm, David C |
Address: |
2570 Dole Street Honolulu, HI 96822-2396 USA |
Email Address: | david.hamm@noaa.gov |
Phone: | (808)983-5330 |
Fax: | (808)983-2902 |
Business Hours: | 6:00 a.m. - 3:00 p.m. HST M-F |
Contact Instructions: |
email david.hamm@noaa.gov |
Extents
Extent Group 1
Extent Group 1 / Time Frame 1
Time Frame Type: | Range |
---|---|
Start: | 1980-06-19 |
End: | 1999-09-02 |
Access Information
Security Class: | Sensitive |
---|
Catalog Details
Catalog Item ID: | 1140 |
---|---|
GUID: | gov.noaa.nmfs.inport:1140 |
Metadata Record Created By: | Brent M Miyamoto |
Metadata Record Created: | 2006-04-05 16:57+0000 |
Metadata Record Last Modified By: | Bradley M Gough |
Metadata Record Last Modified: | 2025-02-20 00:36+0000 |
Metadata Record Published: | 2025-02-20 |
Owner Org: | PIFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Review Frequency: | 1 Year |