Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
PIFSC Metadata Library > PIFSC Historical Datasets Metadata Portfolio > Historical Research Pelagics Metadata Portfolio > Surface School Fishing data collected during NO... >

RP052AA1_V

Entity (ENT)  |  Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:67550  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Surface fishing data collected during NOAA research cruises.

Description

Surface fishing data collected during NOAA research cruises.

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 number of the cruise, e.g., 0022.
YEAR
VARCHAR2 		Local year.
MONTH
VARCHAR2 		Local month.
DAY
VARCHAR2 		Local day.
LOCAL_TIME
VARCHAR2 		Local time school sighted.
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).
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 was used to determine LATITUDE_DIRECTION (N/S).
LATITUDE_DD
NUMBER 		Computed latitude, in decimal degrees, of the sampling site. 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. OCTANT was used to determine the first digit (0 or 1). Units for values are degrees.
LONGITUDE_MINUTES
VARCHAR2 		Longitude minutes. Units for values are minutes.
LONGITUDE_DIRECTION
VARCHAR2 		Longitude direction. OCTANT was 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.
STATION_NUMBER
VARCHAR2 		Station number.
LOCAL_TIME_SCHOOL_ABANDONED
VARCHAR2 		Local time school was abandoned.
SPECIES_CODE_IN_SCHOOL
VARCHAR2 		2-digit species code in school.
FIRST_SPECIES_CODE_IN_CATCH
VARCHAR2 		2-digit species code of first species in catch. This may or may not be the same as SPECIES_CODE_IN_SCHOOL. The school may have been fished witout results, or it may have been a mixed school with a mixed catch.
FIRST_SPECIES_NUMBER_CAUGHT
VARCHAR2 		Number of first species caught.
FIRST_SPECIES_AVERAGE_LENGTH
VARCHAR2 		Average length, in centimeters, of first species. Units for values are centimeters.
SECOND_SPECIES_CODE_IN_CATCH
VARCHAR2 		2-digit species code of second species in catch.
SECOND_SPECIES_NUMBER_CAUGHT
VARCHAR2 		Number of second species caught.
SECOND_SPECIES_AVERAGE_LENGTH
VARCHAR2 		Average length, in centimeters, of second species. Units for values are centimeters.
TOTAL_NUMBER_PASSES
VARCHAR2 		Total number of passes.
NUMBER_MEN_HOOKING
VARCHAR2 		Number of men hooking; the collection form field label is NUMBER_HOOKS_FISHING.
SCHOOL_LOCATED_BY_CODE
VARCHAR2 		Code for how the school was located.
TYPE_OF_SCHOOL_CODE
VARCHAR2 		Code for the type of school.
NUMBER_BIRDS_IN_FLOCK_CODE
VARCHAR2 		Code for the number of birds in the flock.
FISH_TAGGED_YN
VARCHAR2 		Code for whether any fish was tagged.
STOMACH_CONTENTS_YN
VARCHAR2 		Code for whether the stomach contents were enumerated or preserved.
GONADS_YN
VARCHAR2 		Code for whether the gonads were examined or preserved.
ADDITIONAL_INFO_YN
VARCHAR2 		Code for whether there is additional information on other logs.
NUMBER_BUCKETS_BAIT_USED
VARCHAR2 		Number of buckets of bait used.
BAIT_SPECIES_CODE
VARCHAR2 		2-digit code for the bait species.
SURFACE_WATER_TEMPERATURE
VARCHAR2 		Surface water temperature, in tenths of a centigrade. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are centigrade. Measures are reported with a precision of 3.
SURFACE_SALINITY
VARCHAR2 		Surface salinity, in parts per thousand. During data entry, the "3" and the decimal point were omitted; they have been inserted into the data. Units for values are parts per thousand. Measures are reported with a precision of 2.
NUMBER_SPECIES_MEASURED
VARCHAR2 		This is an additional field that was written on the data collection form. It had no descriptive field name, other than Column 79. And the record format sheet did not have a field name or data description. It may be the number of different species that were measured for the date and time.
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: RP052AA1_V
Short Name: RP052AA1_V
Status: Completed
Abstract:

Surface fishing data collected during NOAA research cruises.

Entity Information

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

Surface fishing data collected during NOAA research cruises.

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 number of the cruise, e.g., 0022.
100
 YEAR VARCHAR2 Local year.
100
 MONTH VARCHAR2 Local month.
100
 DAY VARCHAR2 Local day.
100
 LOCAL_TIME VARCHAR2 Local time school sighted.
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).
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 was used to determine LATITUDE_DIRECTION (N/S).
100
 LATITUDE_DD NUMBER Computed latitude, in decimal degrees, of the sampling site. 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. OCTANT was used to determine the first digit (0 or 1). Units for values are degrees.
100
 LONGITUDE_MINUTES VARCHAR2 Longitude minutes. Units for values are minutes.
100
 LONGITUDE_DIRECTION VARCHAR2 Longitude direction. OCTANT was 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
 STATION_NUMBER VARCHAR2 Station number.
100
 LOCAL_TIME_SCHOOL_ABANDONED VARCHAR2 Local time school was abandoned.
100
 SPECIES_CODE_IN_SCHOOL VARCHAR2 2-digit species code in school.
100
 FIRST_SPECIES_CODE_IN_CATCH VARCHAR2 2-digit species code of first species in catch. This may or may not be the same as SPECIES_CODE_IN_SCHOOL. The school may have been fished witout results, or it may have been a mixed school with a mixed catch.
100
 FIRST_SPECIES_NUMBER_CAUGHT VARCHAR2 Number of first species caught.
100
 FIRST_SPECIES_AVERAGE_LENGTH VARCHAR2 Average length, in centimeters, of first species. Units for values are centimeters.
100
 SECOND_SPECIES_CODE_IN_CATCH VARCHAR2 2-digit species code of second species in catch.
100
 SECOND_SPECIES_NUMBER_CAUGHT VARCHAR2 Number of second species caught.
100
 SECOND_SPECIES_AVERAGE_LENGTH VARCHAR2 Average length, in centimeters, of second species. Units for values are centimeters.
100
 TOTAL_NUMBER_PASSES VARCHAR2 Total number of passes.
100
 NUMBER_MEN_HOOKING VARCHAR2 Number of men hooking; the collection form field label is NUMBER_HOOKS_FISHING.
100
 SCHOOL_LOCATED_BY_CODE VARCHAR2 Code for how the school was located.
100
 TYPE_OF_SCHOOL_CODE VARCHAR2 Code for the type of school.
100
 NUMBER_BIRDS_IN_FLOCK_CODE VARCHAR2 Code for the number of birds in the flock.
100
 FISH_TAGGED_YN VARCHAR2 Code for whether any fish was tagged.
100
 STOMACH_CONTENTS_YN VARCHAR2 Code for whether the stomach contents were enumerated or preserved.
100
 GONADS_YN VARCHAR2 Code for whether the gonads were examined or preserved.
100
 ADDITIONAL_INFO_YN VARCHAR2 Code for whether there is additional information on other logs.
100
 NUMBER_BUCKETS_BAIT_USED VARCHAR2 Number of buckets of bait used.
100
 BAIT_SPECIES_CODE VARCHAR2 2-digit code for the bait species.
100
 SURFACE_WATER_TEMPERATURE VARCHAR2 Surface water temperature, in tenths of a centigrade. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are centigrade. Measures are reported with a precision of 3.
100
 SURFACE_SALINITY VARCHAR2 Surface salinity, in parts per thousand. During data entry, the "3" and the decimal point were omitted; they have been inserted into the data. Units for values are parts per thousand. Measures are reported with a precision of 2.
100
 NUMBER_SPECIES_MEASURED VARCHAR2 This is an additional field that was written on the data collection form. It had no descriptive field name, other than Column 79. And the record format sheet did not have a field name or data description. It may be the number of different species that were measured for the date and time.
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: 1178225
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: 1178226
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: 1178227
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: 004 = HUGH M SMITH; 005 = JOHN R MANNING; 007 = CHARLES H GILBERT

CRUISE_NUMBER

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

Four digit incremental number of the cruise, e.g., 0022.
General Data Type: VARCHAR2

YEAR

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

Local year.
General Data Type: VARCHAR2

MONTH

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

Local month.
General Data Type: VARCHAR2

DAY

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

Local day.
General Data Type: VARCHAR2

LOCAL_TIME

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

Local time school sighted.
General Data Type: VARCHAR2

OCTANT

CC ID: 1178233
Seq. Order: 9
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).
General Data Type: VARCHAR2
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: 1178234
Seq. Order: 10
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: 1178235
Seq. Order: 11
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: 1178236
Seq. Order: 12
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Latitude direction. OCTANT was used to determine LATITUDE_DIRECTION (N/S).
General Data Type: VARCHAR2
Allowed Values: N = NORTH; S = SOUTH

LATITUDE_DD

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

Computed latitude, in decimal degrees, of the sampling site. 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: 1178238
Seq. Order: 14
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. OCTANT was used to determine the first digit (0 or 1). Units for values are degrees.
General Data Type: VARCHAR2
Unit of Measure: degrees

LONGITUDE_MINUTES

CC ID: 1178239
Seq. Order: 15
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: 1178240
Seq. Order: 16
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Longitude direction. OCTANT was used to determine LONGITUDE_DIRECTION (E/W).
General Data Type: VARCHAR2
Allowed Values: E = EAST; W = WEST

LONGITUDE_DD

CC ID: 1178241
Seq. Order: 17
Data Storage Type: NUMBER
Max Length: 41
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

STATION_NUMBER

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

Station number.
General Data Type: VARCHAR2

LOCAL_TIME_SCHOOL_ABANDONED

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

Local time school was abandoned.
General Data Type: VARCHAR2

SPECIES_CODE_IN_SCHOOL

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

2-digit species code in school.
General Data Type: VARCHAR2
Default Value: 00 = NO FISH; 32 = KATSUWONUS PELAMIS, SKIPJACK, AKU; 33 = EUTHYNNUS SPP., LITTLE TUNNY, KAWAKAWA; 34 = THUNNUS OBESUS, BIGEYE TUNA, AHI; 35 = THUNNUS ALBACARES, YELLOWFIN TUNA, AHI; 41 = AUXIS SPP., FRIGATE MACKEREL; 53 = CORYPHAENIDAE, DOLPHINFISH; MAHIMAHI; 73 = MODIDAE, HEADFISHES OR SUNFISHES, MOLAMOLA; 90 = COMBINATION IN SCHOOLS SKIPJACK-YELLOWFIN; 91 = COMBINATION IN SCHOOLS SKIPJACK-LITTLE TUNNY; 93 = COMBINATION IN SCHOOLS SKIPJACK-BIGEYE; 94 = COMBINATION IN SCHOOLS SKIPJACK-MAHIMAHI; 95 = COMBINATION IN SCHOOLS YELLOWFIN-MAHIMAHI; 96 = COMBINATION IN SCHOOLS OTHER FISH IN COMBINATION; 98 = OTHER THINGS; 99 = UNIDENTIFIED

FIRST_SPECIES_CODE_IN_CATCH

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

2-digit species code of first species in catch. This may or may not be the same as SPECIES_CODE_IN_SCHOOL. The school may have been fished witout results, or it may have been a mixed school with a mixed catch.
General Data Type: VARCHAR2
Allowed Values: 32 = KATSUWONUS PELAMIS, SKIPJACK, AKU; 33 = EUTHYNNUS SPP., LITTLE TUNNY, KAWAKAWA; 34 = THUNNUS OBESUS, BIGEYE TUNA, AHI; 35 = THUNNUS ALBACARES, YELLOWFIN TUNA, AHI; 41 = AUXIS SPP., FRIGATE MACKEREL; 53 = CORYPHAENIDAE, DOLPHINFISH; MAHIMAHI; 90 = COMBINATION IN SCHOOLS SKIPJACK-YELLOWFIN; 95 = COMBINATION IN SCHOOLS YELLOWFIN-MAHIMAHI; 96 = COMBINATION IN SCHOOLS OTHER FISH IN COMBINATION

FIRST_SPECIES_NUMBER_CAUGHT

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

Number of first species caught.
General Data Type: VARCHAR2

FIRST_SPECIES_AVERAGE_LENGTH

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

Average length, in centimeters, of first species. Units for values are centimeters.
General Data Type: VARCHAR2
Unit of Measure: centimeters

SECOND_SPECIES_CODE_IN_CATCH

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

2-digit species code of second species in catch.
General Data Type: VARCHAR2
Allowed Values: 00 = NO FISH; 32 = KATSUWONUS PELAMIS, SKIPJACK, AKU; 33 = EUTHYNNUS SPP., LITTLE TUNNY, KAWAKAWA; 34 = THUNNUS OBESUS, BIGEYE TUNA, AHI; 35 = THUNNUS ALBACARES, YELLOWFIN TUNA, AHI; 41 = AUXIS SPP., FRIGATE MACKEREL

SECOND_SPECIES_NUMBER_CAUGHT

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

Number of second species caught.
General Data Type: VARCHAR2

SECOND_SPECIES_AVERAGE_LENGTH

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

Average length, in centimeters, of second species. Units for values are centimeters.
General Data Type: VARCHAR2
Unit of Measure: centimeters

TOTAL_NUMBER_PASSES

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

Total number of passes.
General Data Type: VARCHAR2

NUMBER_MEN_HOOKING

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

Number of men hooking; the collection form field label is NUMBER_HOOKS_FISHING.
General Data Type: VARCHAR2

SCHOOL_LOCATED_BY_CODE

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

Code for how the school was located.
General Data Type: VARCHAR2
Allowed Values: 0 = BIRD FLOCK; 1 = JUMPERS; 2 = SURFACE PATCH; 3 = DEBRIS; 4 = BLIND CHUMMING; 9 = OTHER

TYPE_OF_SCHOOL_CODE

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

Code for the type of school.
General Data Type: VARCHAR2
Allowed Values: 0 = SUB-SURFACE; 1 = JUMPING; 2 = BREEZING; 3 = FINNING

NUMBER_BIRDS_IN_FLOCK_CODE

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

Code for the number of birds in the flock.
General Data Type: VARCHAR2
Allowed Values: BLANK, NULL = PRESENT BUT NUMBER NOT RECORDED; 1 = 1; 2 = 2 - 5; 3 = 6 - 10; 4 = 11 - 25; 5 = 26 - 50; 6 = 51 - 100; 7 = 101 - 500; 8 = 501 - 1000; 9 = 1001 - 2000; 0 = OVER 2000

FISH_TAGGED_YN

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

Code for whether any fish was tagged.
General Data Type: VARCHAR2
Allowed Values: 0 = YES; 1 = NO

STOMACH_CONTENTS_YN

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

Code for whether the stomach contents were enumerated or preserved.
General Data Type: VARCHAR2
Allowed Values: 0 = YES; 1 = NO

GONADS_YN

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

Code for whether the gonads were examined or preserved.
General Data Type: VARCHAR2
Allowed Values: 0 = YES; 1 = NO

ADDITIONAL_INFO_YN

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

Code for whether there is additional information on other logs.
General Data Type: VARCHAR2
Allowed Values: 0 = YES; 1 = NO

NUMBER_BUCKETS_BAIT_USED

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

Number of buckets of bait used.
General Data Type: VARCHAR2

BAIT_SPECIES_CODE

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

2-digit code for the bait species.
General Data Type: VARCHAR2
Allowed Values: 01 = ELOPIDAE, TENPOUNDERS, AWAAWA; 03 = HARENGULA VITTATA, MARQUESAN SARDINE; 07 = STOLEPHORUS PURPUREUS, ANCHOVY, NEHU; 22 = POECILIIDAE, TOP MINNOWS, MOSQUITO FISH, SWORDTAILS, MOLLIES; 28 = ATHERINIDAE, SILVERSIDES, IAO; 30 = MUGILIDAE, MULLETS, AMAAMA, UOUOA; 32 = KATSUWONUS PELAMIS, SKIPJACK, AKU; 3A = THREADFIN SHAD (FRESHWATER); 55 = CARANGIDAE, JACKS, SCAD, AMBERJACKS; 56 = KUHLIIDAE, MOUNTAIN BASSES, AHOLEHOLE; 59 = MULLIDAE, GOATFISHES, SURMULLETS, WEKE, MOANA, KUMU, OAMA, UPENEUS ARGE; 60 = CICHLIDAE, TILAPIAS; 97 = BAITFISH COMBINATION; 98 = OTHER THINGS

SURFACE_WATER_TEMPERATURE

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

Surface water temperature, in tenths of a centigrade. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are centigrade. Measures are reported with a precision of 3.
General Data Type: VARCHAR2
Unit of Measure: centigrade

SURFACE_SALINITY

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

Surface salinity, in parts per thousand. During data entry, the "3" and the decimal point were omitted; they have been inserted into the data. Units for values are parts per thousand. Measures are reported with a precision of 2.
General Data Type: VARCHAR2
Unit of Measure: parts per thousand

NUMBER_SPECIES_MEASURED

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

This is an additional field that was written on the data collection form. It had no descriptive field name, other than Column 79. And the record format sheet did not have a field name or data description. It may be the number of different species that were measured for the date and time.
General Data Type: VARCHAR2

TIME_ZONE_CODE

CC ID: 1178265
Seq. Order: 41
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: 1178266
Seq. Order: 42
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: 1178267
Seq. Order: 43
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: 67550
GUID: gov.noaa.nmfs.inport:67550
Metadata Record Created By: Brent M Miyamoto
Metadata Record Created: 2022-07-15 19:14+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2022-07-16
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2022-07-16
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2023-07-16