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

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 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
Metadata Record Created By: Brent M Miyamoto
Metadata Record Created: 2020-08-30 03:04+0000
Metadata Record Last Modified By: Brent M Miyamoto
Metadata Record Last Modified: 2020-10-01 01:57+0000
Metadata Record Published: 2020-10-01
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2021-10-02