RP024AA1_CONF_V
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:67431 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Longline effort and summarized catch for data collected during NOAA research cruises.
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_CONF_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
|
|
|
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
| 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. |
VERSION_CODE
| 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. |
VESSEL_CODE
| Seq. Order: | 3 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Code for the vessel. |
CRUISE_NUMBER
| 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. |
YEAR
| 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. |
MONTH
| 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. |
DAY
| 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. |
FLOATLINE_LENGTH
| 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. |
| Unit of Measure: | fathoms |
MAINLINE_LENGTH
| 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. |
| Unit of Measure: | fathoms |
OCTANT
| 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. |
| 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
| 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. |
| Unit of Measure: | degrees |
LATITUDE_MINUTES
| 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. |
| Unit of Measure: | minutes |
LATITUDE_DIRECTION
| 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). |
| Allowed Values: | N = NORTH; S = SOUTH |
LATITUDE_DD
| 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. |
| Unit of Measure: | degrees |
LONGITUDE_DEGREES
| 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. |
| Unit of Measure: | degrees |
LONGITUDE_MINUTES
| 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. |
| Unit of Measure: | minutes |
LONGITUDE_DIRECTION
| 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). |
| Allowed Values: | E = EAST; W = WEST |
LONGITUDE_DD
| 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. |
| Unit of Measure: | degrees |
GEAR_TYPE_CODE
| Seq. Order: | 19 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Code for the type of gear. |
| Allowed Values: | 1 = STANDARD OR COMMERCIAL GEAR; 2 = EXPERIMENTAL GEAR |
NUMBER_HOOKS_PER_BASKET
| Seq. Order: | 20 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Number of hooks per basket. |
TOTAL_NUMBER_BASKETS_FISHED
| Seq. Order: | 21 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Total number of baskets fished. |
TOTAL_NUMBER_HOOKS_FISHED
| Seq. Order: | 22 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 4 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Total number of hooks fished. |
NUMBER_YELLOWFIN
| Seq. Order: | 23 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Number of Yellowfin caught. |
NUMBER_ALBACORE
| Seq. Order: | 24 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Number of Albacore caught. |
NUMBER_AUST_S_BLUEFIN
| Seq. Order: | 25 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Number of Australian Southern Bluefin caught. |
NUMBER_AUST_N_BLUEFIN
| Seq. Order: | 26 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Number of Australian Northern Bluefin caught. |
NUMBER_BIGEYE
| Seq. Order: | 27 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Number of Bigeye caught. |
NUMBER_SKIPJACK
| Seq. Order: | 28 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Number of Skipjack caught. |
NUMBER_BLACK_MARLIN
| Seq. Order: | 29 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Number of Black Marlin caught. |
NUMBER_STRIPED_MARLIN
| Seq. Order: | 30 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Number of Striped Marlin caught. |
NUMBER_WHITE_MARLIN
| Seq. Order: | 31 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Number of White Marlin caught. |
NUMBER_BROADBILL_SWORDFISH
| Seq. Order: | 32 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Number of Broadbill Swordfish caught. |
NUMBER_SAILFISH
| Seq. Order: | 33 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Number of Sailfish caught. |
NUMBER_SHORTNOSE_SPEARFISH
| Seq. Order: | 34 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Number of Shortnose Spearfish caught. |
NUMBER_WAHOO
| Seq. Order: | 35 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Number of Wahoo (Ono) caught. |
NUMBER_MAHIMAHI
| Seq. Order: | 36 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Number of Mahimahi caught. |
NUMBER_WHITE_TIP_SHARK
| Seq. Order: | 37 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Number of White Tip Shark caught. |
NUMBER_SILKY_SHARK
| Seq. Order: | 38 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Number of Silky Shark caught. |
NUMBER_GREAT_BLUE_SHARK
| Seq. Order: | 39 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Number of Great Blue Shark caught. |
NUMBER_BLACK_TUNA
| 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. |
NUMBER_AMERICAN_BLUEFIN
| Seq. Order: | 41 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Number of American Bluefin caught. |
NUMBER_OTHER_SHARKS
| Seq. Order: | 42 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Number of Other Sharks caught. |
NUMBER_OTHER_MISC_FISH
| Seq. Order: | 43 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Number of Other Miscellaneous Fish caught. |
TIME_ZONE_CODE
| Seq. Order: | 44 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Code for the Time Zone. |
| 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
| 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. |
DATE_LOADED
| 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. |
Catalog Details
| Catalog Item ID: | 67431 |
|---|---|
| GUID: | gov.noaa.nmfs.inport:67431 |
| Metadata Record Created By: | Brent M Miyamoto |
| Metadata Record Created: | 2022-06-17 22:30+0000 |
| Metadata Record Last Modified By: | SysAdmin InPortAdmin |
| Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
| Metadata Record Published: | 2022-06-23 |
| Owner Org: | PIFSC |
| Metadata Publication Status: | Published Externally |
| Do Not Publish?: | N |
| Metadata Last Review Date: | 2022-06-23 |
| Metadata Review Frequency: | 1 Year |
| Metadata Next Review Date: | 2023-06-23 |
