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

Item Identification

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

Entity Information

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

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

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.

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 Details

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