Metadata Rubric

100%

6 / 6

PIFSC Metadata Library > PIFSC Historical Datasets Metadata Portfolio > Historical Research Insular Metadata Portfolio > Fish Sampling Log data collected during NOAA R/... >

RI003AA4_V

Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:73365 | Updated: September 13, 2024 | Published / External

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

Fish Sampling Log.

Description

Fish Sampling Log.

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	Last two digits of the year of the cruise and two-digit incremental number of the cruise for the year, e.g., 8202.
AGENCY_CODE VARCHAR2	Code for the agency collecting the data, NMFS = National Marine Fisheries Service.
YEAR VARCHAR2	Year of capture.
MONTH VARCHAR2	Month of capture.
DAY VARCHAR2	Day of capture.
STATION_NUMBER VARCHAR2	Station number of the activity.
BANK_CODE_ALL VARCHAR2	Code for the bank where the activity occurred, 5-digit (with leading '00', TC 8205 and TC 8302) and 7-digit CZM bank codes.
BANK_CODE_5 VARCHAR2	5-digit CZM bank code,filed created using sql.
BANK_CODE VARCHAR2	7-digit-czm bank code; 5-digit bank_code converted to 7-digit bank code using sql.
LATITUDE_DEGREES VARCHAR2	Latitude degrees of the activity. Units for values are degrees.
LATITUDE_MINUTES VARCHAR2	Latitude minutes, in tenths of a minute, of the activity. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are minutes. Measures are reported with a precision of 3.
LATITUDE_DIRECTION VARCHAR2	Latitude direction of the activity.
LATITUDE_DD NUMBER	Computed latitude, in decimal degrees, of the activity. Positive 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 of the activity. Units for values are degrees.
LONGITUDE_MINUTES VARCHAR2	Longitude minutes, in tenths of a minute, of the activity. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are minutes. Measures are reported with a precision of 3.
LONGITUDE_DIRECTION VARCHAR2	Longitude direction of activity.
LONGITUDE_DD NUMBER	Computed longitude, in decimal degrees, of the sampling site. Positive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39.
FISH_NUMBER VARCHAR2	Unique consecutive number assigned to each specimen of the cruise.
SPECIES_CODE VARCHAR2	Ten digit CZM species code.
SEX_CODE VARCHAR2	Code for sex of specimen (F=FEMALE, M=MALE, I=IMMATURE, U=UNDETERMINED, BLANK=NOT SEXED).
STANDARD_LENGTH VARCHAR2	Standard Length, in tenths of a centimeters. The decimal point was omitted during data entry; it has been inserted into the data. Units for values are centimeters. Measures are reported with a precision of 4.
TOTAL_OR_FORK_LENGTH VARCHAR2	Total or Fork Length, in tenths of a centimeter. The decimal point was omitted during data entry (00000 =>0000.0); TC 88-08 S. MITSUKURII NORMAL TOTAL LENGTH ENTERED. Units for values are centimeters. Measures are reported with a precision of 4.
WEIGHT VARCHAR2	Weight, in hundreths of a kilogram. Units for values are kilograms. Measures are reported with a precision of 5.
DEPTH_MIN VARCHAR2	Minimum depth, in fathoms (data collection form). Units for values are fathoms.
DEPTH_MAX VARCHAR2	Maximum depth, in fathoms (data collection form). Units for values are fathoms.
GEAR_CODE VARCHAR2	3-digit gear code.
GONAD_CODE VARCHAR2	Gonad code, 1 = SAVED (CHECKED OR X'D), NULL= BLANK; moved H = HEART (TC 90-06) to HEART_CODE.
STOMACH_CODE VARCHAR2	Stomach code, 1 = SAVED (CHECKED OR X'D); 2 = EVERTED; B = BAIT ONLY; E = EMPTY; F= FULL; P = PARTIAL, 1/2 FULL; V = VISCERA, WHOLE TRACT OR GI TRACT; NULL = BLANK.
OTOLITH_CODE VARCHAR2	Otolith code, 1 = SAVED (CHECKED OR X'D); NULL = BLANK; moved E to STOMACH_CODE (TC 88-05).
WHOLE_FISH_CODE VARCHAR2	Whole Fish code, 1 = SAVED (CHECKED OR X'D); NULL = BLANK.
CIGUATERA_SAMPLE_CODE VARCHAR2	Ciguatera Sample code, 1 = SAVED (CHECKED OR X'D); NULL = BLANK.
MATURITY_CODE VARCHAR2	Maturity code, 1 = COLLECTED (CHECKED OR X'D); NULL = BLANK.
GILL_CODE VARCHAR2	Gill code, parasite code, parasite sample / gills, 1 = SAVED (CHECKED OR X'D); NULL = BLANK.
BODY_DEPTH VARCHAR2	Body Depth (for Armorhead only), in tenths of a centimeter. During data entry the decimal point was omitted. It has been inserted into the data. Units for values are centimeters. Measures are reported with a precision of 3.
BODY_TYPE_CODE VARCHAR2	Body Type code (for Armorhead only), F = FAT, I = INTERMEDIATE, L = LEAN.
HEART_CODE VARCHAR2	Heart code, 1 = SAVED (CHECKED OR X'D); NULL = BLANK.
SPINE_CODE VARCHAR2	Spine code, 1 = SAVED (CHECKED OR X'D); NULL = BLANK.
NUMBER_DORSAL_RAYS VARCHAR2	Number of dorsal rays.
NUMBER_ANAL_RAYS VARCHAR2	Number of anal rays.
JOB_NUMBER VARCHAR2	Job_number. A consecutive number assigned by the data entry staff to a block of data that is entered and verified. Format DYYNNN, where D is constant, YY is the last two digits of the year and NNN is the consecutive number that starts with 001 at the beginning of each calendar year, e.g., D84084.
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.

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

Last two digits of the year of the cruise and two-digit incremental number of the cruise for the year, e.g., 8202.

AGENCY_CODE
VARCHAR2

Code for the agency collecting the data, NMFS = National Marine Fisheries Service.

YEAR
VARCHAR2

Year of capture.

MONTH
VARCHAR2

Month of capture.

DAY
VARCHAR2

Day of capture.

STATION_NUMBER
VARCHAR2

Station number of the activity.

BANK_CODE_ALL
VARCHAR2

Code for the bank where the activity occurred, 5-digit (with leading '00', TC 8205 and TC 8302) and 7-digit CZM bank codes.

BANK_CODE_5
VARCHAR2

5-digit CZM bank code,filed created using sql.

BANK_CODE
VARCHAR2

7-digit-czm bank code; 5-digit bank_code converted to 7-digit bank code using sql.

LATITUDE_DEGREES
VARCHAR2

Latitude degrees of the activity. Units for values are degrees.

LATITUDE_MINUTES
VARCHAR2

Latitude minutes, in tenths of a minute, of the activity. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are minutes. Measures are reported with a precision of 3.

LATITUDE_DIRECTION
VARCHAR2

Latitude direction of the activity.

LATITUDE_DD
NUMBER

Computed latitude, in decimal degrees, of the activity. Positive 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 of the activity. Units for values are degrees.

LONGITUDE_MINUTES
VARCHAR2

Longitude minutes, in tenths of a minute, of the activity. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are minutes. Measures are reported with a precision of 3.

LONGITUDE_DIRECTION
VARCHAR2

Longitude direction of activity.

LONGITUDE_DD
NUMBER

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

FISH_NUMBER
VARCHAR2

Unique consecutive number assigned to each specimen of the cruise.

SPECIES_CODE
VARCHAR2

Ten digit CZM species code.

SEX_CODE
VARCHAR2

Code for sex of specimen (F=FEMALE, M=MALE, I=IMMATURE, U=UNDETERMINED, BLANK=NOT SEXED).

STANDARD_LENGTH
VARCHAR2

Standard Length, in tenths of a centimeters. The decimal point was omitted during data entry; it has been inserted into the data. Units for values are centimeters. Measures are reported with a precision of 4.

TOTAL_OR_FORK_LENGTH
VARCHAR2

Total or Fork Length, in tenths of a centimeter. The decimal point was omitted during data entry (00000 =>0000.0); TC 88-08 S. MITSUKURII NORMAL TOTAL LENGTH ENTERED. Units for values are centimeters. Measures are reported with a precision of 4.

WEIGHT
VARCHAR2

Weight, in hundreths of a kilogram. Units for values are kilograms. Measures are reported with a precision of 5.

DEPTH_MIN
VARCHAR2

Minimum depth, in fathoms (data collection form). Units for values are fathoms.

DEPTH_MAX
VARCHAR2

Maximum depth, in fathoms (data collection form). Units for values are fathoms.

GEAR_CODE
VARCHAR2

3-digit gear code.

GONAD_CODE
VARCHAR2

Gonad code, 1 = SAVED (CHECKED OR X'D), NULL= BLANK; moved H = HEART (TC 90-06) to HEART_CODE.

STOMACH_CODE
VARCHAR2

Stomach code, 1 = SAVED (CHECKED OR X'D); 2 = EVERTED; B = BAIT ONLY; E = EMPTY; F= FULL; P = PARTIAL, 1/2 FULL; V = VISCERA, WHOLE TRACT OR GI TRACT; NULL = BLANK.

OTOLITH_CODE
VARCHAR2

Otolith code, 1 = SAVED (CHECKED OR X'D); NULL = BLANK; moved E to STOMACH_CODE (TC 88-05).

WHOLE_FISH_CODE
VARCHAR2

Whole Fish code, 1 = SAVED (CHECKED OR X'D); NULL = BLANK.

CIGUATERA_SAMPLE_CODE
VARCHAR2

Ciguatera Sample code, 1 = SAVED (CHECKED OR X'D); NULL = BLANK.

MATURITY_CODE
VARCHAR2

Maturity code, 1 = COLLECTED (CHECKED OR X'D); NULL = BLANK.

GILL_CODE
VARCHAR2

Gill code, parasite code, parasite sample / gills, 1 = SAVED (CHECKED OR X'D); NULL = BLANK.

BODY_DEPTH
VARCHAR2

Body Depth (for Armorhead only), in tenths of a centimeter. During data entry the decimal point was omitted. It has been inserted into the data. Units for values are centimeters. Measures are reported with a precision of 3.

BODY_TYPE_CODE
VARCHAR2

Body Type code (for Armorhead only), F = FAT, I = INTERMEDIATE, L = LEAN.

HEART_CODE
VARCHAR2

Heart code, 1 = SAVED (CHECKED OR X'D); NULL = BLANK.

SPINE_CODE
VARCHAR2

Spine code, 1 = SAVED (CHECKED OR X'D); NULL = BLANK.

NUMBER_DORSAL_RAYS
VARCHAR2

Number of dorsal rays.

NUMBER_ANAL_RAYS
VARCHAR2

Number of anal rays.

JOB_NUMBER
VARCHAR2

Job_number. A consecutive number assigned by the data entry staff to a block of data that is entered and verified. Format DYYNNN, where D is constant, YY is the last two digits of the year and NNN is the consecutive number that starts with 001 at the beginning of each calendar year, e.g., D84084.

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.

No Child Items for this record.

No contact information is available for this record.

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

Title:	RI003AA4_V
Short Name:	RI003AA4_V
Status:	Completed
Abstract:	Fish Sampling Log.

Entity Type:	Data Table
Active Version?:	Yes
Description:	Fish Sampling Log.

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	Last two digits of the year of the cruise and two-digit incremental number of the cruise for the year, e.g., 8202.
100	AGENCY_CODE	VARCHAR2	Code for the agency collecting the data, NMFS = National Marine Fisheries Service.
100	YEAR	VARCHAR2	Year of capture.
100	MONTH	VARCHAR2	Month of capture.
100	DAY	VARCHAR2	Day of capture.
100	STATION_NUMBER	VARCHAR2	Station number of the activity.
100	BANK_CODE_ALL	VARCHAR2	Code for the bank where the activity occurred, 5-digit (with leading '00', TC 8205 and TC 8302) and 7-digit CZM bank codes.
100	BANK_CODE_5	VARCHAR2	5-digit CZM bank code,filed created using sql.
100	BANK_CODE	VARCHAR2	7-digit-czm bank code; 5-digit bank_code converted to 7-digit bank code using sql.
100	LATITUDE_DEGREES	VARCHAR2	Latitude degrees of the activity. Units for values are degrees.
100	LATITUDE_MINUTES	VARCHAR2	Latitude minutes, in tenths of a minute, of the activity. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are minutes. Measures are reported with a precision of 3.
100	LATITUDE_DIRECTION	VARCHAR2	Latitude direction of the activity.
100	LATITUDE_DD	NUMBER	Computed latitude, in decimal degrees, of the activity. Positive 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 of the activity. Units for values are degrees.
100	LONGITUDE_MINUTES	VARCHAR2	Longitude minutes, in tenths of a minute, of the activity. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are minutes. Measures are reported with a precision of 3.
100	LONGITUDE_DIRECTION	VARCHAR2	Longitude direction of activity.
100	LONGITUDE_DD	NUMBER	Computed longitude, in decimal degrees, of the sampling site. Positive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39.
100	FISH_NUMBER	VARCHAR2	Unique consecutive number assigned to each specimen of the cruise.
100	SPECIES_CODE	VARCHAR2	Ten digit CZM species code.
100	SEX_CODE	VARCHAR2	Code for sex of specimen (F=FEMALE, M=MALE, I=IMMATURE, U=UNDETERMINED, BLANK=NOT SEXED).
100	STANDARD_LENGTH	VARCHAR2	Standard Length, in tenths of a centimeters. The decimal point was omitted during data entry; it has been inserted into the data. Units for values are centimeters. Measures are reported with a precision of 4.
100	TOTAL_OR_FORK_LENGTH	VARCHAR2	Total or Fork Length, in tenths of a centimeter. The decimal point was omitted during data entry (00000 =>0000.0); TC 88-08 S. MITSUKURII NORMAL TOTAL LENGTH ENTERED. Units for values are centimeters. Measures are reported with a precision of 4.
100	WEIGHT	VARCHAR2	Weight, in hundreths of a kilogram. Units for values are kilograms. Measures are reported with a precision of 5.
100	DEPTH_MIN	VARCHAR2	Minimum depth, in fathoms (data collection form). Units for values are fathoms.
100	DEPTH_MAX	VARCHAR2	Maximum depth, in fathoms (data collection form). Units for values are fathoms.
100	GEAR_CODE	VARCHAR2	3-digit gear code.
100	GONAD_CODE	VARCHAR2	Gonad code, 1 = SAVED (CHECKED OR X'D), NULL= BLANK; moved H = HEART (TC 90-06) to HEART_CODE.
100	STOMACH_CODE	VARCHAR2	Stomach code, 1 = SAVED (CHECKED OR X'D); 2 = EVERTED; B = BAIT ONLY; E = EMPTY; F= FULL; P = PARTIAL, 1/2 FULL; V = VISCERA, WHOLE TRACT OR GI TRACT; NULL = BLANK.
100	OTOLITH_CODE	VARCHAR2	Otolith code, 1 = SAVED (CHECKED OR X'D); NULL = BLANK; moved E to STOMACH_CODE (TC 88-05).
100	WHOLE_FISH_CODE	VARCHAR2	Whole Fish code, 1 = SAVED (CHECKED OR X'D); NULL = BLANK.
100	CIGUATERA_SAMPLE_CODE	VARCHAR2	Ciguatera Sample code, 1 = SAVED (CHECKED OR X'D); NULL = BLANK.
100	MATURITY_CODE	VARCHAR2	Maturity code, 1 = COLLECTED (CHECKED OR X'D); NULL = BLANK.
100	GILL_CODE	VARCHAR2	Gill code, parasite code, parasite sample / gills, 1 = SAVED (CHECKED OR X'D); NULL = BLANK.
100	BODY_DEPTH	VARCHAR2	Body Depth (for Armorhead only), in tenths of a centimeter. During data entry the decimal point was omitted. It has been inserted into the data. Units for values are centimeters. Measures are reported with a precision of 3.
100	BODY_TYPE_CODE	VARCHAR2	Body Type code (for Armorhead only), F = FAT, I = INTERMEDIATE, L = LEAN.
100	HEART_CODE	VARCHAR2	Heart code, 1 = SAVED (CHECKED OR X'D); NULL = BLANK.
100	SPINE_CODE	VARCHAR2	Spine code, 1 = SAVED (CHECKED OR X'D); NULL = BLANK.
100	NUMBER_DORSAL_RAYS	VARCHAR2	Number of dorsal rays.
100	NUMBER_ANAL_RAYS	VARCHAR2	Number of anal rays.
100	JOB_NUMBER	VARCHAR2	Job_number. A consecutive number assigned by the data entry staff to a block of data that is entered and verified. Format DYYNNN, where D is constant, YY is the last two digits of the year and NNN is the consecutive number that starts with 001 at the beginning of each calendar year, e.g., D84084.
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.

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

Last two digits of the year of the cruise and two-digit incremental number of the cruise for the year, e.g., 8202.

100

AGENCY_CODE

VARCHAR2

Code for the agency collecting the data, NMFS = National Marine Fisheries Service.

100

YEAR

VARCHAR2

Year of capture.

100

MONTH

VARCHAR2

Month of capture.

100

DAY

VARCHAR2

Day of capture.

100

STATION_NUMBER

VARCHAR2

Station number of the activity.

100

BANK_CODE_ALL

VARCHAR2

Code for the bank where the activity occurred, 5-digit (with leading '00', TC 8205 and TC 8302) and 7-digit CZM bank codes.

100

BANK_CODE_5

VARCHAR2

5-digit CZM bank code,filed created using sql.

100

BANK_CODE

VARCHAR2

7-digit-czm bank code; 5-digit bank_code converted to 7-digit bank code using sql.

100

LATITUDE_DEGREES

VARCHAR2

Latitude degrees of the activity. Units for values are degrees.

100

LATITUDE_MINUTES

VARCHAR2

100

LATITUDE_DIRECTION

VARCHAR2

Latitude direction of the activity.

100

LATITUDE_DD

NUMBER

100

LONGITUDE_DEGREES

VARCHAR2

Longitude degrees of the activity. Units for values are degrees.

100

LONGITUDE_MINUTES

VARCHAR2

100

LONGITUDE_DIRECTION

VARCHAR2

Longitude direction of activity.

100

LONGITUDE_DD

NUMBER

100

FISH_NUMBER

VARCHAR2

Unique consecutive number assigned to each specimen of the cruise.

100

SPECIES_CODE

VARCHAR2

Ten digit CZM species code.

100

SEX_CODE

VARCHAR2

Code for sex of specimen (F=FEMALE, M=MALE, I=IMMATURE, U=UNDETERMINED, BLANK=NOT SEXED).

100

STANDARD_LENGTH

VARCHAR2

100

TOTAL_OR_FORK_LENGTH

VARCHAR2

100

WEIGHT

VARCHAR2

Weight, in hundreths of a kilogram. Units for values are kilograms. Measures are reported with a precision of 5.

100

DEPTH_MIN

VARCHAR2

Minimum depth, in fathoms (data collection form). Units for values are fathoms.

100

DEPTH_MAX

VARCHAR2

Maximum depth, in fathoms (data collection form). Units for values are fathoms.

100

GEAR_CODE

VARCHAR2

3-digit gear code.

100

GONAD_CODE

VARCHAR2

Gonad code, 1 = SAVED (CHECKED OR X'D), NULL= BLANK; moved H = HEART (TC 90-06) to HEART_CODE.

100

STOMACH_CODE

VARCHAR2

Stomach code, 1 = SAVED (CHECKED OR X'D); 2 = EVERTED; B = BAIT ONLY; E = EMPTY; F= FULL; P = PARTIAL, 1/2 FULL; V = VISCERA, WHOLE TRACT OR GI TRACT; NULL = BLANK.

100

OTOLITH_CODE

VARCHAR2

Otolith code, 1 = SAVED (CHECKED OR X'D); NULL = BLANK; moved E to STOMACH_CODE (TC 88-05).

100

WHOLE_FISH_CODE

VARCHAR2

Whole Fish code, 1 = SAVED (CHECKED OR X'D); NULL = BLANK.

100

CIGUATERA_SAMPLE_CODE

VARCHAR2

Ciguatera Sample code, 1 = SAVED (CHECKED OR X'D); NULL = BLANK.

100

MATURITY_CODE

VARCHAR2

Maturity code, 1 = COLLECTED (CHECKED OR X'D); NULL = BLANK.

100

GILL_CODE

VARCHAR2

Gill code, parasite code, parasite sample / gills, 1 = SAVED (CHECKED OR X'D); NULL = BLANK.

100

BODY_DEPTH

VARCHAR2

100

BODY_TYPE_CODE

VARCHAR2

Body Type code (for Armorhead only), F = FAT, I = INTERMEDIATE, L = LEAN.

100

HEART_CODE

VARCHAR2

Heart code, 1 = SAVED (CHECKED OR X'D); NULL = BLANK.

100

SPINE_CODE

VARCHAR2

Spine code, 1 = SAVED (CHECKED OR X'D); NULL = BLANK.

100

NUMBER_DORSAL_RAYS

VARCHAR2

Number of dorsal rays.

100

NUMBER_ANAL_RAYS

VARCHAR2

Number of anal rays.

100

JOB_NUMBER

VARCHAR2

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: 1346958

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: 1346959

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: 1346960

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

CRUISE_NUMBER

CC ID: 1346961

Seq. Order:	4
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	Last two digits of the year of the cruise and two-digit incremental number of the cruise for the year, e.g., 8202.
General Data Type:	VARCHAR2

AGENCY_CODE

CC ID: 1346962

Seq. Order:	5
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	Code for the agency collecting the data, NMFS = National Marine Fisheries Service.
General Data Type:	VARCHAR2

YEAR

CC ID: 1346963

Seq. Order:	6
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	Year of capture.
General Data Type:	VARCHAR2

MONTH

CC ID: 1346964

Seq. Order:	7
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Month of capture.
General Data Type:	VARCHAR2

DAY

CC ID: 1346965

Seq. Order:	8
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Day of capture.
General Data Type:	VARCHAR2

STATION_NUMBER

CC ID: 1346966

Seq. Order:	9
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	Station number of the activity.
General Data Type:	VARCHAR2

BANK_CODE_ALL

CC ID: 1346967

Seq. Order:	10
Data Storage Type:	VARCHAR2
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	Code for the bank where the activity occurred, 5-digit (with leading '00', TC 8205 and TC 8302) and 7-digit CZM bank codes.
General Data Type:	VARCHAR2

BANK_CODE_5

CC ID: 1346968

Seq. Order:	11
Data Storage Type:	VARCHAR2
Max Length:	5
Required:	No
Primary Key:	No
Status:	Active
Description:	5-digit CZM bank code,filed created using sql.
General Data Type:	VARCHAR2

BANK_CODE

CC ID: 1346969

Seq. Order:	12
Data Storage Type:	VARCHAR2
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	7-digit-czm bank code; 5-digit bank_code converted to 7-digit bank code using sql.
General Data Type:	VARCHAR2

LATITUDE_DEGREES

CC ID: 1346970

Seq. Order:	13
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Latitude degrees of the activity. Units for values are degrees.
General Data Type:	VARCHAR2
Unit of Measure:	degrees

LATITUDE_MINUTES

CC ID: 1346971

Seq. Order:	14
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Scale:	1
Status:	Active
Description:	Latitude minutes, in tenths of a minute, of the activity. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are minutes. Measures are reported with a precision of 3.
General Data Type:	VARCHAR2
Unit of Measure:	minutes

LATITUDE_DIRECTION

CC ID: 1346972

Seq. Order:	15
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Latitude direction of the activity.
General Data Type:	VARCHAR2
Allowed Values:	N = NORTH; S = SOUTH

LATITUDE_DD

CC ID: 1346973

Seq. Order:	16
Data Storage Type:	NUMBER
Max Length:	41
Required:	No
Primary Key:	No
Scale:	38
Status:	Active
Description:	Computed latitude, in decimal degrees, of the activity. Positive 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: 1346974

Seq. Order:	17
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	Longitude degrees of the activity. Units for values are degrees.
General Data Type:	VARCHAR2
Unit of Measure:	degrees

LONGITUDE_MINUTES

CC ID: 1346975

Seq. Order:	18
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Scale:	1
Status:	Active
Description:	Longitude minutes, in tenths of a minute, of the activity. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are minutes. Measures are reported with a precision of 3.
General Data Type:	VARCHAR2
Unit of Measure:	minutes

LONGITUDE_DIRECTION

CC ID: 1346976

Seq. Order:	19
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Longitude direction of activity.
General Data Type:	VARCHAR2
Allowed Values:	E = EAST; W = WEST

LONGITUDE_DD

CC ID: 1346977

Seq. Order:	20
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. Positive 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

FISH_NUMBER

CC ID: 1346978

Seq. Order:	21
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	Unique consecutive number assigned to each specimen of the cruise.
General Data Type:	VARCHAR2

SPECIES_CODE

CC ID: 1346979

Seq. Order:	22
Data Storage Type:	VARCHAR2
Max Length:	10
Required:	No
Primary Key:	No
Status:	Active
Description:	Ten digit CZM species code.
General Data Type:	VARCHAR2

SEX_CODE

CC ID: 1346980

Seq. Order:	23
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Code for sex of specimen (F=FEMALE, M=MALE, I=IMMATURE, U=UNDETERMINED, BLANK=NOT SEXED).
General Data Type:	VARCHAR2
Allowed Values:	F = FEMALE; I = IMMATURE; M = MALE; U = UNDETERMINED; NULL = NOT SEXED

STANDARD_LENGTH

CC ID: 1346981

Seq. Order:	24
Data Storage Type:	VARCHAR2
Max Length:	5
Required:	No
Primary Key:	No
Scale:	1
Status:	Active
Description:	Standard Length, in tenths of a centimeters. The decimal point was omitted during data entry; it has been inserted into the data. Units for values are centimeters. Measures are reported with a precision of 4.
General Data Type:	VARCHAR2
Unit of Measure:	centimeters

TOTAL_OR_FORK_LENGTH

CC ID: 1346982

Seq. Order:	25
Data Storage Type:	VARCHAR2
Max Length:	5
Required:	No
Primary Key:	No
Scale:	1
Status:	Active
Description:	Total or Fork Length, in tenths of a centimeter. The decimal point was omitted during data entry (00000 =>0000.0); TC 88-08 S. MITSUKURII NORMAL TOTAL LENGTH ENTERED. Units for values are centimeters. Measures are reported with a precision of 4.
General Data Type:	VARCHAR2
Unit of Measure:	centimeters

WEIGHT

CC ID: 1346983

Seq. Order:	26
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	No
Primary Key:	No
Scale:	2
Status:	Active
Description:	Weight, in hundreths of a kilogram. Units for values are kilograms. Measures are reported with a precision of 5.
General Data Type:	VARCHAR2
Unit of Measure:	kilograms

DEPTH_MIN

CC ID: 1346984

Seq. Order:	27
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	Minimum depth, in fathoms (data collection form). Units for values are fathoms.
General Data Type:	VARCHAR2
Unit of Measure:	fathoms

DEPTH_MAX

CC ID: 1346985

Seq. Order:	28
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	Maximum depth, in fathoms (data collection form). Units for values are fathoms.
General Data Type:	VARCHAR2
Unit of Measure:	fathoms

GEAR_CODE

CC ID: 1346986

Seq. Order:	29
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	3-digit gear code.
General Data Type:	VARCHAR2

GONAD_CODE

CC ID: 1346987

Seq. Order:	30
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Gonad code, 1 = SAVED (CHECKED OR X'D), NULL= BLANK; moved H = HEART (TC 90-06) to HEART_CODE.
General Data Type:	VARCHAR2
Allowed Values:	1 = SAVED (CHECKED OR X'D); NULL = BLANK

STOMACH_CODE

CC ID: 1346988

Seq. Order:	31
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Stomach code, 1 = SAVED (CHECKED OR X'D); 2 = EVERTED; B = BAIT ONLY; E = EMPTY; F= FULL; P = PARTIAL, 1/2 FULL; V = VISCERA, WHOLE TRACT OR GI TRACT; NULL = BLANK.
General Data Type:	VARCHAR2
Allowed Values:	1 = SAVED (CHECKED OR X'D); 2 = EVERTED; B = BAIT ONLY; E = EMPTY STOMACH; F = FULL; P = PARTIAL, 1/2 FULL; V = VISCERA, WHOLE TRACT; GI TRACT; NULL = BLANK

OTOLITH_CODE

CC ID: 1346989

Seq. Order:	32
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Otolith code, 1 = SAVED (CHECKED OR X'D); NULL = BLANK; moved E to STOMACH_CODE (TC 88-05).
General Data Type:	VARCHAR2
Allowed Values:	1 = SAVED (CHECKED OR X'D); NULL = BLANK

WHOLE_FISH_CODE

CC ID: 1346990

Seq. Order:	33
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Whole Fish code, 1 = SAVED (CHECKED OR X'D); NULL = BLANK.
General Data Type:	VARCHAR2
Allowed Values:	1 = SAVED (CHECKED OR X'D); NULL = BLANK

CIGUATERA_SAMPLE_CODE

CC ID: 1346991

Seq. Order:	34
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Ciguatera Sample code, 1 = SAVED (CHECKED OR X'D); NULL = BLANK.
General Data Type:	VARCHAR2
Allowed Values:	1 = SAVED (CHECKED OR X'D); NULL = BLANK

MATURITY_CODE

CC ID: 1346992

Seq. Order:	35
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Maturity code, 1 = COLLECTED (CHECKED OR X'D); NULL = BLANK.
General Data Type:	VARCHAR2
Allowed Values:	1 = COLLECTED (CHECKED OR X'D); NULL = BLANK

GILL_CODE

CC ID: 1346993

Seq. Order:	36
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Gill code, parasite code, parasite sample / gills, 1 = SAVED (CHECKED OR X'D); NULL = BLANK.
General Data Type:	VARCHAR2
Allowed Values:	1 = SAVED (CHECKED OR X;D); NULL = BLANK

BODY_DEPTH

CC ID: 1346994

Seq. Order:	37
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Scale:	1
Status:	Active
Description:	Body Depth (for Armorhead only), in tenths of a centimeter. During data entry the decimal point was omitted. It has been inserted into the data. Units for values are centimeters. Measures are reported with a precision of 3.
General Data Type:	VARCHAR2
Unit of Measure:	centimeters

BODY_TYPE_CODE

CC ID: 1346995

Seq. Order:	38
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Body Type code (for Armorhead only), F = FAT, I = INTERMEDIATE, L = LEAN.
General Data Type:	VARCHAR2

HEART_CODE

CC ID: 1346996

Seq. Order:	39
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Heart code, 1 = SAVED (CHECKED OR X'D); NULL = BLANK.
General Data Type:	VARCHAR2
Allowed Values:	1 = SAVED (CHECKED OR X'D); NULL = BLANK

SPINE_CODE

CC ID: 1346997

Seq. Order:	40
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Spine code, 1 = SAVED (CHECKED OR X'D); NULL = BLANK.
General Data Type:	VARCHAR2
Allowed Values:	1 = SAVED (CHECKED OR X'D); NULL = BLANK

NUMBER_DORSAL_RAYS

CC ID: 1346998

Seq. Order:	41
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Number of dorsal rays.
General Data Type:	VARCHAR2

NUMBER_ANAL_RAYS

CC ID: 1346999

Seq. Order:	42
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Number of anal rays.
General Data Type:	VARCHAR2

JOB_NUMBER

CC ID: 1347000

Seq. Order:	43
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	No
Primary Key:	No
Status:	Active
Description:	Job_number. A consecutive number assigned by the data entry staff to a block of data that is entered and verified. Format DYYNNN, where D is constant, YY is the last two digits of the year and NNN is the consecutive number that starts with 001 at the beginning of each calendar year, e.g., D84084.
General Data Type:	VARCHAR2

SEQUENCE_NUMBER

CC ID: 1347001

Seq. Order:	44
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: 1347002

Seq. Order:	45
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 Item ID:	73365
GUID:	gov.noaa.nmfs.inport:73365
Metadata Record Created By:	Brent M Miyamoto
Metadata Record Created:	2024-09-04 03:41+0000
Metadata Record Last Modified By:	Brent M Miyamoto
Metadata Record Last Modified:	2024-09-13 02:13+0000
Metadata Record Published:	2024-09-13
Owner Org:	PIFSC
Metadata Publication Status:	Published Externally
Do Not Publish?:	N
Metadata Last Review Date:	2024-09-13
Metadata Review Frequency:	1 Year
Metadata Next Review Date:	2025-09-13

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

DATASET_CODE

VERSION_CODE

VESSEL_CODE

CRUISE_NUMBER

AGENCY_CODE

YEAR

MONTH

DAY

STATION_NUMBER

BANK_CODE_ALL

BANK_CODE_5

BANK_CODE

LATITUDE_DEGREES

LATITUDE_MINUTES

LATITUDE_DIRECTION

LATITUDE_DD

LONGITUDE_DEGREES

LONGITUDE_MINUTES

LONGITUDE_DIRECTION

LONGITUDE_DD

FISH_NUMBER

SPECIES_CODE

SEX_CODE

STANDARD_LENGTH

TOTAL_OR_FORK_LENGTH

WEIGHT

DEPTH_MIN

DEPTH_MAX

GEAR_CODE

GONAD_CODE

STOMACH_CODE

OTOLITH_CODE

WHOLE_FISH_CODE

CIGUATERA_SAMPLE_CODE

MATURITY_CODE

GILL_CODE

BODY_DEPTH

BODY_TYPE_CODE

HEART_CODE

SPINE_CODE

NUMBER_DORSAL_RAYS

NUMBER_ANAL_RAYS

JOB_NUMBER

SEQUENCE_NUMBER

DATE_LOADED

Catalog Details