Slide Menu
Search Help Show/Hide Menu

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