Maintenance Notice: Tuesday May 21 @ 12pm-1:30pm Eastern. InPort and its associated services will be under maintenance and unavailable for the deployment of InPort Release 5.3.6. Downtime Schedule Tuesday, May 21, 2024 12:00pm - 1:30pm Eastern / 9:00am - 10:30am Pacific / 6:00am - 8:30am Hawaii Impacted Areas - InPort Website: https://www.fisheries.noaa.gov/inport - InPort WAF: h...
View All
Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Longline effort and summarized catch for data collected during NOAA research cruises.

Description

Longline effort and summarized catch.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
DATASET_CODE
VARCHAR2
Source ID Code assigned by the data entry staff.
VERSION_CODE
VARCHAR2
Code for the format version assigned by the data entry staff.
VESSEL_CODE
VARCHAR2
Code for the vessel.
CRUISE_NUMBER
VARCHAR2
Four digit incremental cruise number of the vessel, e.g., 0032.
YEAR
VARCHAR2
Year of haul of the first basket.
MONTH
VARCHAR2
Month of haul of the first basket.
DAY
VARCHAR2
Day of haul of the first basket.
FLOATLINE_LENGTH
VARCHAR2
Length of the Float Line, in fathoms. Units for values are fathoms.
MAINLINE_LENGTH
VARCHAR2
Length of the Mainline for one basket of gear, in tens of fathoms, e.g., 24 = 240. Units for values are fathoms.
OCTANT
VARCHAR2
Octant of the globe. OCTANT used to determine latitude direction (N/S), longitude direction (E/W) and the first digit of LONGITUDE_DEGREES (0/1). Units for values are fathoms.
LATITUDE_DEGREES
VARCHAR2
Latitude degrees. Units for values are degrees.
LATITUDE_MINUTES
VARCHAR2
Latitude minutes. Units for values are minutes.
LATITUDE_DIRECTION
VARCHAR2
Latitude direction. OCTANT used to determine LATITUDE_DIRECTION (N/S).
LATITUDE_DD
NUMBER
Computed latitude, in decimal degrees. Postive values are North latitudes; negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 40.
LONGITUDE_DEGREES
VARCHAR2
Longitude degrees. During data entry, the first digit (0 or 1) was omitted. It has been inserted into the data using OCTANT. Units for values are degrees.
LONGITUDE_MINUTES
VARCHAR2
Longitude minutes. Units for values are minutes.
LONGITUDE_DIRECTION
VARCHAR2
Longitude direction. OCTANT used to determine LONGITUDE_DIRECTION (E/W).
LONGITUDE_DD
NUMBER
Computed longitude, in decimal degrees, of the sampling site. Postive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39.
GEAR_TYPE_CODE
VARCHAR2
Code for the type of gear.
NUMBER_HOOKS_PER_BASKET
VARCHAR2
Number of hooks per basket.
TOTAL_NUMBER_BASKETS_FISHED
VARCHAR2
Total number of baskets fished.
TOTAL_NUMBER_HOOKS_FISHED
VARCHAR2
Total number of hooks fished.
NUMBER_YELLOWFIN
VARCHAR2
Number of Yellowfin caught.
NUMBER_ALBACORE
VARCHAR2
Number of Albacore caught.
NUMBER_AUST_S_BLUEFIN
VARCHAR2
Number of Australian Southern Bluefin caught.
NUMBER_AUST_N_BLUEFIN
VARCHAR2
Number of Australian Northern Bluefin caught.
NUMBER_BIGEYE
VARCHAR2
Number of Bigeye caught.
NUMBER_SKIPJACK
VARCHAR2
Number of Skipjack caught.
NUMBER_BLACK_MARLIN
VARCHAR2
Number of Black Marlin caught.
NUMBER_STRIPED_MARLIN
VARCHAR2
Number of Striped Marlin caught.
NUMBER_WHITE_MARLIN
VARCHAR2
Number of White Marlin caught.
NUMBER_BROADBILL_SWORDFISH
VARCHAR2
Number of Broadbill Swordfish caught.
NUMBER_SAILFISH
VARCHAR2
Number of Sailfish caught.
NUMBER_SHORTNOSE_SPEARFISH
VARCHAR2
Number of Shortnose Spearfish caught.
NUMBER_WAHOO
VARCHAR2
Number of Wahoo (Ono) caught.
NUMBER_MAHIMAHI
VARCHAR2
Number of Mahimahi caught.
NUMBER_WHITE_TIP_SHARK
VARCHAR2
Number of White Tip Shark caught.
NUMBER_SILKY_SHARK
VARCHAR2
Number of Silky Shark caught.
NUMBER_GREAT_BLUE_SHARK
VARCHAR2
Number of Great Blue Shark caught.
NUMBER_BLACK_TUNA
VARCHAR2
Number of Black Tuna caught. This column contains Number of Mako/Bonito Shark caught; see the Issues Tab for more information.
NUMBER_AMERICAN_BLUEFIN
VARCHAR2
Number of American Bluefin caught.
NUMBER_OTHER_SHARKS
VARCHAR2
Number of Other Sharks caught.
NUMBER_OTHER_MISC_FISH
VARCHAR2
Number of Other Miscellaneous Fish caught.
TIME_ZONE_CODE
VARCHAR2
Code for the Time Zone.
SEQUENCE_NUMBER
VARCHAR2
A consecutive number assigned to each record for a block of data.
DATE_LOADED
DATE
Date when the record was loaded into Oracle or updated.

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (PIFSC) for inquiries on this record.

Item Identification

Title: RP024AA1_RSCH_V
Short Name: RP024AA1_RSCH_V
Status: Completed
Abstract:

Longline effort and summarized catch for data collected during NOAA research cruises.

Entity Information

Entity Type: Data Table
Active Version?: Yes
Description:

Longline effort and summarized catch.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
DATASET_CODE VARCHAR2 Source ID Code assigned by the data entry staff.
100
VERSION_CODE VARCHAR2 Code for the format version assigned by the data entry staff.
100
VESSEL_CODE VARCHAR2 Code for the vessel.
100
CRUISE_NUMBER VARCHAR2 Four digit incremental cruise number of the vessel, e.g., 0032.
100
YEAR VARCHAR2 Year of haul of the first basket.
100
MONTH VARCHAR2 Month of haul of the first basket.
100
DAY VARCHAR2 Day of haul of the first basket.
100
FLOATLINE_LENGTH VARCHAR2 Length of the Float Line, in fathoms. Units for values are fathoms.
100
MAINLINE_LENGTH VARCHAR2 Length of the Mainline for one basket of gear, in tens of fathoms, e.g., 24 = 240. Units for values are fathoms.
100
OCTANT VARCHAR2 Octant of the globe. OCTANT used to determine latitude direction (N/S), longitude direction (E/W) and the first digit of LONGITUDE_DEGREES (0/1). Units for values are fathoms.
100
LATITUDE_DEGREES VARCHAR2 Latitude degrees. Units for values are degrees.
100
LATITUDE_MINUTES VARCHAR2 Latitude minutes. Units for values are minutes.
100
LATITUDE_DIRECTION VARCHAR2 Latitude direction. OCTANT used to determine LATITUDE_DIRECTION (N/S).
100
LATITUDE_DD NUMBER Computed latitude, in decimal degrees. Postive values are North latitudes; negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 40.
100
LONGITUDE_DEGREES VARCHAR2 Longitude degrees. During data entry, the first digit (0 or 1) was omitted. It has been inserted into the data using OCTANT. Units for values are degrees.
100
LONGITUDE_MINUTES VARCHAR2 Longitude minutes. Units for values are minutes.
100
LONGITUDE_DIRECTION VARCHAR2 Longitude direction. OCTANT used to determine LONGITUDE_DIRECTION (E/W).
100
LONGITUDE_DD NUMBER Computed longitude, in decimal degrees, of the sampling site. Postive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39.
100
GEAR_TYPE_CODE VARCHAR2 Code for the type of gear.
100
NUMBER_HOOKS_PER_BASKET VARCHAR2 Number of hooks per basket.
100
TOTAL_NUMBER_BASKETS_FISHED VARCHAR2 Total number of baskets fished.
100
TOTAL_NUMBER_HOOKS_FISHED VARCHAR2 Total number of hooks fished.
100
NUMBER_YELLOWFIN VARCHAR2 Number of Yellowfin caught.
100
NUMBER_ALBACORE VARCHAR2 Number of Albacore caught.
100
NUMBER_AUST_S_BLUEFIN VARCHAR2 Number of Australian Southern Bluefin caught.
100
NUMBER_AUST_N_BLUEFIN VARCHAR2 Number of Australian Northern Bluefin caught.
100
NUMBER_BIGEYE VARCHAR2 Number of Bigeye caught.
100
NUMBER_SKIPJACK VARCHAR2 Number of Skipjack caught.
100
NUMBER_BLACK_MARLIN VARCHAR2 Number of Black Marlin caught.
100
NUMBER_STRIPED_MARLIN VARCHAR2 Number of Striped Marlin caught.
100
NUMBER_WHITE_MARLIN VARCHAR2 Number of White Marlin caught.
100
NUMBER_BROADBILL_SWORDFISH VARCHAR2 Number of Broadbill Swordfish caught.
100
NUMBER_SAILFISH VARCHAR2 Number of Sailfish caught.
100
NUMBER_SHORTNOSE_SPEARFISH VARCHAR2 Number of Shortnose Spearfish caught.
100
NUMBER_WAHOO VARCHAR2 Number of Wahoo (Ono) caught.
100
NUMBER_MAHIMAHI VARCHAR2 Number of Mahimahi caught.
100
NUMBER_WHITE_TIP_SHARK VARCHAR2 Number of White Tip Shark caught.
100
NUMBER_SILKY_SHARK VARCHAR2 Number of Silky Shark caught.
100
NUMBER_GREAT_BLUE_SHARK VARCHAR2 Number of Great Blue Shark caught.
100
NUMBER_BLACK_TUNA VARCHAR2 Number of Black Tuna caught. This column contains Number of Mako/Bonito Shark caught; see the Issues Tab for more information.
100
NUMBER_AMERICAN_BLUEFIN VARCHAR2 Number of American Bluefin caught.
100
NUMBER_OTHER_SHARKS VARCHAR2 Number of Other Sharks caught.
100
NUMBER_OTHER_MISC_FISH VARCHAR2 Number of Other Miscellaneous Fish caught.
100
TIME_ZONE_CODE VARCHAR2 Code for the Time Zone.
100
SEQUENCE_NUMBER VARCHAR2 A consecutive number assigned to each record for a block of data.
100
DATE_LOADED DATE Date when the record was loaded into Oracle or updated.

Attribute Details

DATASET_CODE

CC ID: 1176208
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

Source ID Code assigned by the data entry staff.

General Data Type: VARCHAR2

VERSION_CODE

CC ID: 1176209
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Code for the format version assigned by the data entry staff.

General Data Type: VARCHAR2

VESSEL_CODE

CC ID: 1176210
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Code for the vessel.

General Data Type: VARCHAR2
Allowed Values: 001 = TOWNSEND CROMWELL; 004 = HUGH M SMITH; 005 = JOHN R MANNING; 007 = CHARLES H GILBERT

CRUISE_NUMBER

CC ID: 1176211
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Four digit incremental cruise number of the vessel, e.g., 0032.

General Data Type: VARCHAR2

YEAR

CC ID: 1176212
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Year of haul of the first basket.

General Data Type: VARCHAR2

MONTH

CC ID: 1176213
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Month of haul of the first basket.

General Data Type: VARCHAR2

DAY

CC ID: 1176214
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Day of haul of the first basket.

General Data Type: VARCHAR2

FLOATLINE_LENGTH

CC ID: 1176215
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Length of the Float Line, in fathoms. Units for values are fathoms.

General Data Type: VARCHAR2
Unit of Measure: fathoms

MAINLINE_LENGTH

CC ID: 1176216
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Length of the Mainline for one basket of gear, in tens of fathoms, e.g., 24 = 240. Units for values are fathoms.

General Data Type: VARCHAR2
Unit of Measure: fathoms

OCTANT

CC ID: 1176217
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Octant of the globe. OCTANT used to determine latitude direction (N/S), longitude direction (E/W) and the first digit of LONGITUDE_DEGREES (0/1). Units for values are fathoms.

General Data Type: VARCHAR2
Unit of Measure: fathoms
Allowed Values: 0 = NORTH LATITUDE, 00 DEG WEST TO 89 DEG 59 MIN WEST LONGITUDE; 1 = NORTH LATITUDE, 90 DEG WEST TO 179 DEG 59 MIN WEST LONGITUDE; 2 = NORTH LATITUDE, 180 DEG TO 90 DEG 01 MIN EAST LONGITUDE; 3 = NORTH LATITUDE, 90 DEG EAST TO 00 DEG 01 MIN EAST LONGITUDE; 5 = SOUTH LATITUDE, 00 DEG WEST TO 89 DEG 59 MIN WEST LONGITUDE; 6 = SOUTH LATITUDE, 90 DEG WEST TO 179 DEG 59 MIN WEST LONGITUDE; 7 = SOUTH LATITUDE, 180 DEG TO 90 DEG 01 MIN EAST LONGITUDE; 8 = SOUTH LATITUDE, 90 DEG EAST TO 00 DEG 01 MIN EAST LONGITUDE

LATITUDE_DEGREES

CC ID: 1176218
Seq. Order: 11
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Latitude degrees. Units for values are degrees.

General Data Type: VARCHAR2
Unit of Measure: degrees

LATITUDE_MINUTES

CC ID: 1176219
Seq. Order: 12
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Latitude minutes. Units for values are minutes.

General Data Type: VARCHAR2
Unit of Measure: minutes

LATITUDE_DIRECTION

CC ID: 1176220
Seq. Order: 13
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Latitude direction. OCTANT used to determine LATITUDE_DIRECTION (N/S).

General Data Type: VARCHAR2
Allowed Values: N = NORTH; S = SOUTH

LATITUDE_DD

CC ID: 1176221
Seq. Order: 14
Data Storage Type: NUMBER
Max Length: 42
Required: No
Primary Key: No
Scale: 38
Status: Active
Description:

Computed latitude, in decimal degrees. Postive values are North latitudes; negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 40.

General Data Type: NUMBER
Unit of Measure: degrees

LONGITUDE_DEGREES

CC ID: 1176222
Seq. Order: 15
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Longitude degrees. During data entry, the first digit (0 or 1) was omitted. It has been inserted into the data using OCTANT. Units for values are degrees.

General Data Type: VARCHAR2
Unit of Measure: degrees

LONGITUDE_MINUTES

CC ID: 1176223
Seq. Order: 16
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Longitude minutes. Units for values are minutes.

General Data Type: VARCHAR2
Unit of Measure: minutes

LONGITUDE_DIRECTION

CC ID: 1176224
Seq. Order: 17
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Longitude direction. OCTANT used to determine LONGITUDE_DIRECTION (E/W).

General Data Type: VARCHAR2
Allowed Values: E = EAST; W = WEST

LONGITUDE_DD

CC ID: 1176225
Seq. Order: 18
Data Storage Type: NUMBER
Max Length: 40
Required: No
Primary Key: No
Scale: 36
Status: Active
Description:

Computed longitude, in decimal degrees, of the sampling site. Postive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39.

General Data Type: NUMBER
Unit of Measure: degrees

GEAR_TYPE_CODE

CC ID: 1176226
Seq. Order: 19
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Code for the type of gear.

General Data Type: VARCHAR2
Allowed Values: 1 = STANDARD OR COMMERCIAL GEAR; 2 = EXPERIMENTAL GEAR

NUMBER_HOOKS_PER_BASKET

CC ID: 1176227
Seq. Order: 20
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Number of hooks per basket.

General Data Type: VARCHAR2

TOTAL_NUMBER_BASKETS_FISHED

CC ID: 1176228
Seq. Order: 21
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Total number of baskets fished.

General Data Type: VARCHAR2

TOTAL_NUMBER_HOOKS_FISHED

CC ID: 1176229
Seq. Order: 22
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Total number of hooks fished.

General Data Type: VARCHAR2

NUMBER_YELLOWFIN

CC ID: 1176230
Seq. Order: 23
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Number of Yellowfin caught.

General Data Type: VARCHAR2

NUMBER_ALBACORE

CC ID: 1176231
Seq. Order: 24
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Number of Albacore caught.

General Data Type: VARCHAR2

NUMBER_AUST_S_BLUEFIN

CC ID: 1176232
Seq. Order: 25
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Number of Australian Southern Bluefin caught.

General Data Type: VARCHAR2

NUMBER_AUST_N_BLUEFIN

CC ID: 1176233
Seq. Order: 26
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Number of Australian Northern Bluefin caught.

General Data Type: VARCHAR2

NUMBER_BIGEYE

CC ID: 1176234
Seq. Order: 27
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Number of Bigeye caught.

General Data Type: VARCHAR2

NUMBER_SKIPJACK

CC ID: 1176235
Seq. Order: 28
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Number of Skipjack caught.

General Data Type: VARCHAR2

NUMBER_BLACK_MARLIN

CC ID: 1176236
Seq. Order: 29
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Number of Black Marlin caught.

General Data Type: VARCHAR2

NUMBER_STRIPED_MARLIN

CC ID: 1176237
Seq. Order: 30
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Number of Striped Marlin caught.

General Data Type: VARCHAR2

NUMBER_WHITE_MARLIN

CC ID: 1176238
Seq. Order: 31
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Number of White Marlin caught.

General Data Type: VARCHAR2

NUMBER_BROADBILL_SWORDFISH

CC ID: 1176239
Seq. Order: 32
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Number of Broadbill Swordfish caught.

General Data Type: VARCHAR2

NUMBER_SAILFISH

CC ID: 1176240
Seq. Order: 33
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Number of Sailfish caught.

General Data Type: VARCHAR2

NUMBER_SHORTNOSE_SPEARFISH

CC ID: 1176241
Seq. Order: 34
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Number of Shortnose Spearfish caught.

General Data Type: VARCHAR2

NUMBER_WAHOO

CC ID: 1176242
Seq. Order: 35
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Number of Wahoo (Ono) caught.

General Data Type: VARCHAR2

NUMBER_MAHIMAHI

CC ID: 1176243
Seq. Order: 36
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Number of Mahimahi caught.

General Data Type: VARCHAR2

NUMBER_WHITE_TIP_SHARK

CC ID: 1176244
Seq. Order: 37
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Number of White Tip Shark caught.

General Data Type: VARCHAR2

NUMBER_SILKY_SHARK

CC ID: 1176245
Seq. Order: 38
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Number of Silky Shark caught.

General Data Type: VARCHAR2

NUMBER_GREAT_BLUE_SHARK

CC ID: 1176246
Seq. Order: 39
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Number of Great Blue Shark caught.

General Data Type: VARCHAR2

NUMBER_BLACK_TUNA

CC ID: 1176247
Seq. Order: 40
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Number of Black Tuna caught. This column contains Number of Mako/Bonito Shark caught; see the Issues Tab for more information.

General Data Type: VARCHAR2

NUMBER_AMERICAN_BLUEFIN

CC ID: 1176248
Seq. Order: 41
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Number of American Bluefin caught.

General Data Type: VARCHAR2

NUMBER_OTHER_SHARKS

CC ID: 1176249
Seq. Order: 42
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Number of Other Sharks caught.

General Data Type: VARCHAR2

NUMBER_OTHER_MISC_FISH

CC ID: 1176250
Seq. Order: 43
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Number of Other Miscellaneous Fish caught.

General Data Type: VARCHAR2

TIME_ZONE_CODE

CC ID: 1176251
Seq. Order: 44
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Code for the Time Zone.

General Data Type: VARCHAR2
Allowed Values: A = MINUS 1; B = MINUS 2; C = MINUS 3; D = MINUS 4; E = MINUS 5; F = MINUS 6; G = MINUS 7; H = MINUS 8; I = MINUS 9; K = MINUS 10; L = MINUS 11; M = MINUS 12; N = PLUS 1; O = PLUS 2; P = PLUS 3; Q = PLUS 4; R = PLUS 5; S = PLUS 6; T = PLUS 7; U = PLUS 8; V = PLUS 9; W = PLUS 10; X = PLUS 11; Y = PLUS 12; Z = 0

SEQUENCE_NUMBER

CC ID: 1176252
Seq. Order: 45
Data Storage Type: VARCHAR2
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

A consecutive number assigned to each record for a block of data.

General Data Type: VARCHAR2

DATE_LOADED

CC ID: 1176253
Seq. Order: 46
Data Storage Type: DATE
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Date when the record was loaded into Oracle or updated.

General Data Type: DATE

Catalog Details

Catalog Item ID: 67425
GUID: gov.noaa.nmfs.inport:67425
Metadata Record Created By: Brent M Miyamoto
Metadata Record Created: 2022-06-17 03:14+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2022-06-17
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2022-06-17
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2023-06-17