Metadata Rubric

100%

6 / 6

PIFSC Metadata Library > PIFSC Historical Datasets Metadata Portfolio > Historical Research Insular Metadata Portfolio > Fish tagging data collected during NOAA R/V Tow... >

RI006AA2_V

Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:62823 | Updated: August 9, 2022 | Published / External

Item Identification

Title:	RI006AA2_V
Short Name:	RI006AA2_V
Status:	Completed
Abstract:	Fish tagging data collected on NOAA R/V Townsend Cromwell.

Entity Information

Entity Type:	Data Table
Active Version?:	Yes
Description:	Fish tagging data collected on NOAA R/V Townsend Cromwell.

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 digits incremental number of the cruise for the year.
100	AGENCY_CODE	VARCHAR2	Code for the agency that collected the data.
100	LINE_NUMBER	VARCHAR2	Consecutive number on the collection form for each fish recorded on the form.
100	YEAR	VARCHAR2	Year.
100	MONTH	VARCHAR2	Month.
100	DAY	VARCHAR2	Day.
100	STATION_NUMBER	VARCHAR2	Station number.
100	BANK_CODE	VARCHAR2	7-digit code of bank.
100	LATITUDE_DEGREES	VARCHAR2	Latitude degrees. Units for values are degrees.
100	LATITUDE_MINUTES	VARCHAR2	Latitude minutes, in tenths of a minute. 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.
100	LATITUDE_DD	NUMBER	Computed latitude, in decimal degrees. Positive values are North latitude and negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 40.
100	LONGITUDE_DEGREES	VARCHAR2	Longitude degrees. Units for values are degrees.
100	LONGITUDE_MINUTES	VARCHAR2	Longitude minutes, in tenths of a minute, of capture. 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.
100	LONGITUDE_DD	NUMBER	Computed longitude, in decimal degrees. Positive values are East longitude and negative values are West longitude. Units for values are degrees. Measures are reported with a precision of 39.
100	SPECIES_CODE	VARCHAR2	CZM 10-digit species code of fish.
100	LENGTH	VARCHAR2	Total or fork length of fish, 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 6.
100	DEPTH	VARCHAR2	Depth, in fathoms. Units for values are fathoms.
100	GEAR_CODE	VARCHAR2	Code for the type of gear that caught the species.
100	TAG_NUMBER	VARCHAR2	Tag number.
100	JOB_NUMBER	VARCHAR2	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., D83023.
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 digits incremental number of the cruise for the year.

100

AGENCY_CODE

VARCHAR2

Code for the agency that collected the data.

100

LINE_NUMBER

VARCHAR2

Consecutive number on the collection form for each fish recorded on the form.

100

YEAR

VARCHAR2

Year.

100

MONTH

VARCHAR2

Month.

100

DAY

VARCHAR2

Day.

100

STATION_NUMBER

VARCHAR2

Station number.

100

BANK_CODE

VARCHAR2

7-digit code of bank.

100

LATITUDE_DEGREES

VARCHAR2

Latitude degrees. Units for values are degrees.

100

LATITUDE_MINUTES

VARCHAR2

Latitude minutes, in tenths of a minute. 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.

100

LATITUDE_DD

NUMBER

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

100

LONGITUDE_DEGREES

VARCHAR2

Longitude degrees. Units for values are degrees.

100

LONGITUDE_MINUTES

VARCHAR2

Longitude minutes, in tenths of a minute, of capture. 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.

100

LONGITUDE_DD

NUMBER

Computed longitude, in decimal degrees. Positive values are East longitude and negative values are West longitude. Units for values are degrees. Measures are reported with a precision of 39.

100

SPECIES_CODE

VARCHAR2

CZM 10-digit species code of fish.

100

LENGTH

VARCHAR2

Total or fork length of fish, 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 6.

100

DEPTH

VARCHAR2

Depth, in fathoms. Units for values are fathoms.

100

GEAR_CODE

VARCHAR2

Code for the type of gear that caught the species.

100

TAG_NUMBER

VARCHAR2

Tag number.

100

JOB_NUMBER

VARCHAR2

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., D83023.

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

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

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

Seq. Order:	3
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	Code for the vessel.
General Data Type:	VARCHAR2
Allowed Values:	001 = NOAA R/V TOWNSEND CROMWELL

CRUISE_NUMBER

CC ID: 988449

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 digits incremental number of the cruise for the year.
General Data Type:	VARCHAR2

AGENCY_CODE

CC ID: 988450

Seq. Order:	5
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	Code for the agency that collected the data.
General Data Type:	VARCHAR2
Allowed Values:	NMFS = NATIONAL MARINE FISHERIES SERVICE

LINE_NUMBER

CC ID: 988451

Seq. Order:	6
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	Consecutive number on the collection form for each fish recorded on the form.
General Data Type:	VARCHAR2

YEAR

CC ID: 988452

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

MONTH

CC ID: 988453

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

DAY

CC ID: 988454

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

STATION_NUMBER

CC ID: 988455

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

BANK_CODE

CC ID: 988456

Seq. Order:	11
Data Storage Type:	VARCHAR2
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	7-digit code of bank.
General Data Type:	VARCHAR2
Allowed Values:	1071100 = NECKER ISLAND; 1101100 = RAITA BANK; 1270100 = SOUTH-EAST HANCOCK SEAMOUNT; 1270200 = NORTH-WEST HANCOCK SEAMOUNT; 2040200 = TINIAN; 2050100 = ARAKANE REEF; 2180000 = AGRIHAN; 2430000 = PATHFINDER REEF;

LATITUDE_DEGREES

CC ID: 988457

Seq. Order:	12
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: 988458

Seq. Order:	13
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Scale:	1
Status:	Active
Description:	Latitude minutes, in tenths of a minute. 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: 988459

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

LATITUDE_DD

CC ID: 988460

Seq. Order:	15
Data Storage Type:	NUMBER
Max Length:	41
Required:	No
Primary Key:	No
Scale:	38
Status:	Active
Description:	Computed latitude, in decimal degrees. Positive values are North latitude and 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: 988461

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

LONGITUDE_MINUTES

CC ID: 988462

Seq. Order:	17
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 capture. 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: 988463

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

LONGITUDE_DD

CC ID: 988464

Seq. Order:	19
Data Storage Type:	NUMBER
Max Length:	41
Required:	No
Primary Key:	No
Scale:	37
Status:	Active
Description:	Computed longitude, in decimal degrees. Positive values are East longitude and negative values are West longitude. Units for values are degrees. Measures are reported with a precision of 39.
General Data Type:	NUMBER
Unit of Measure:	degrees

SPECIES_CODE

CC ID: 988465

Seq. Order:	20
Data Storage Type:	VARCHAR2
Max Length:	10
Required:	No
Primary Key:	No
Status:	Active
Description:	CZM 10-digit species code of fish.
General Data Type:	VARCHAR2

LENGTH

CC ID: 988466

Seq. Order:	21
Data Storage Type:	VARCHAR2
Max Length:	7
Required:	No
Primary Key:	No
Scale:	1
Status:	Active
Description:	Total or fork length of fish, 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 6.
General Data Type:	VARCHAR2
Unit of Measure:	centimeters

DEPTH

CC ID: 988467

Seq. Order:	22
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	Depth, in fathoms. Units for values are fathoms.
General Data Type:	VARCHAR2
Unit of Measure:	fathoms

GEAR_CODE

CC ID: 988468

Seq. Order:	23
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Code for the type of gear that caught the species.
General Data Type:	VARCHAR2
Allowed Values:	02 = LONGLINE; 04 = HANDLINE; 05 = KAKA LINE; 06 = TROLLING LINE; 08 = ROD AND REEL; 14 = MACKEREL HANDLINE; 15 = NIGHT LIGHT; 19 = FISH TRAP (GENERAL); 21 = BOTTOM LONGLINE WITH MAGNESIUM TIMERS (5 HOOKS PER PVC DROPPER) (FIRST USED ON TC 86-05); 34 = SURFACE LONGLINE WITH SINGLE HOOK 1-M MONOFILAMENT DROPPERS OFF 5/16 IN NYLON MAIN LINE (3248 M LONG MAIN LINE CONSISTS OF 400-450 HOOKS OFF 72 24-FM SECTIONS WITH FLOATS 48 FM APART) (FIRST USED ON TC 89-09)

TAG_NUMBER

CC ID: 988469

Seq. Order:	24
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	No
Primary Key:	No
Status:	Active
Description:	Tag number.
General Data Type:	VARCHAR2

JOB_NUMBER

CC ID: 988470

Seq. Order:	25
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	No
Primary Key:	No
Status:	Active
Description:	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., D83023.
General Data Type:	VARCHAR2

SEQUENCE_NUMBER

CC ID: 988471

Seq. Order:	26
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: 988472

Seq. Order:	27
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:	62823
GUID:	gov.noaa.nmfs.inport:62823
Metadata Record Created By:	Brent M Miyamoto
Metadata Record Created:	2020-08-30 03:04+0000
Metadata Record Last Modified By:	SysAdmin InPortAdmin
Metadata Record Last Modified:	2022-08-09 17:11+0000
Metadata Record Published:	2020-10-01
Owner Org:	PIFSC
Metadata Publication Status:	Published Externally
Do Not Publish?:	N
Metadata Last Review Date:	2020-10-01
Metadata Review Frequency:	1 Year
Metadata Next Review Date:	2021-10-01