Search Help Show/Hide Menu
Summary
Item Identification
Keywords
Physical Location
Entity Info
Data Attributes
Support Roles
Extents
Access Info
Catalog Details

Summary

Abstract

This ORACLE flatfile contains the lobster logbook data.

Description

NMFS 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

Time Frame 1
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

Rubric Score Primary Key? 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

CC ID: 1023
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

CC ID: 1024
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

CC ID: 1025
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

CC ID: 1026
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

CC ID: 1027
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

CC ID: 1041
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

CC ID: 1042
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

CC ID: 1043
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

CC ID: 1044
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

CC ID: 1045
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

CC ID: 1046
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

CC ID: 1047
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

CC ID: 1048
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

CC ID: 1049
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

CC ID: 1050
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

CC ID: 1051
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

CC ID: 1052
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

CC ID: 1053
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

CC ID: 1054
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

CC ID: 1055
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

CC ID: 1056
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

CC ID: 1057
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

CC ID: 1058
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

CC ID: 1059
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

CC ID: 1060
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

CC ID: 1061
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

CC ID: 1062
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

CC ID: 1063
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

CC ID: 1064
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

CC ID: 1065
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

CC ID: 1066
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

CC ID: 1067
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

CC ID: 1068
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

CC ID: 1069
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

CC ID: 1070
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

CC ID: 1071
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

CC ID: 1072
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

CC ID: 1073
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

CC ID: 1074
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

CC ID: 1075
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

CC ID: 1076
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

CC ID: 1077
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

CC ID: 1078
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

CC ID: 1079
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

CC ID: 1080
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

CC ID: 1081
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

CC ID: 1082
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

CC ID: 1083
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

CC ID: 1084
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

CC ID: 1085
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

CC ID: 1086
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

CC ID: 1087
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

CC ID: 1088
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

CC ID: 1089
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

CC ID: 1090
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

CC ID: 1091
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

CC ID: 1092
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

CC ID: 1093
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

CC ID: 1094
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

CC ID: 1095
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

CC ID: 1096
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

CC ID: 1097
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

CC ID: 1098
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

CC ID: 1099
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

CC ID: 1100
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

CC ID: 1101
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

CC ID: 1102
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

CC ID: 1103
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

CC ID: 1104
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

CC ID: 1105
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

CC ID: 1106
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

CC ID: 1107
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

CC ID: 1108
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

CC ID: 1109
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

CC ID: 1110
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

CC ID: 1111
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

CC ID: 1112
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

CC ID: 1113
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

CC ID: 1114
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

CC ID: 1115
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

CC ID: 1116
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

CC ID: 1117
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

CC ID: 1118
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

CC ID: 1119
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

CC ID: 1120
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

CC ID: 1121
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

CC ID: 1122
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

CC ID: 1123
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

CC ID: 1124
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

CC ID: 1125
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

CC ID: 1126
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

CC ID: 1127
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

CC ID: 1128
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

CC ID: 9666
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

CC ID: 9665
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

View Historical Support Roles

Extents

Extent Group 1

Extent Group 1 / Time Frame 1

CC ID: 1022
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