Item Identification

Title: RI009AA1_V
Short Name: RI009AA1_V
Status: Completed
Abstract:

Identification of fish species caught in trawl hauls during 4 NOAA R/V Townsend Cromwell cruise in 1967 and 1968.

Entity Information

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

Identification of fish species caught in trawl hauls during 4 NOAA R/V Townsend Cromwell cruise in 1967 and 1968.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
DATASET_CODE Character Source ID Code assigned by the data entry staff.
100
VERSION_CODE Character Code for the format version assigned by the data entry staff.
100
VESSEL_CODE Number Code for the vessel. Coded as 'TC' on the collection form, converted to '001'.
100
CRUISE_NUMBER Number Two-digit incremental number of the cruise, expanded to 4 digits.
100
RI008_TRAWL_YEAR Number Year of trawl operation, from RI008 (InPort ID 5835), linked by VESSEL_CODE, CRUISE_NUMBER, STATION_NUMBER.
100
RI008_TRAWL_MONTH Number Month of trawl operation, from RI008 (InPort ID 5835), linked by VESSEL_CODE, CRUISE_NUMBER, STATION_NUMBER.
100
RI008_TRAWL_DAY Number Day of trawl operation, from RI008, from RI008 (InPort ID 5835), linked by VESSEL_CODE, CRUISE_NUMBER, STATION_NUMBER.
100
STATION_NUMBER Number Station number of trawl operation.
100
RI008_START_LATITUDE_DD Number Start latitude, in decimal degrees, from RI008 (InPort ID 5835), linked by VESSEL_CODE, CRUISE_NUMBER, STATION_NUMBER. Positive value is North latitude; negative value is South latitude. Measures are reported with a precision of 15.
100
RI008_START_LONGITUDE_DD Number Start longitude, in decimal degrees, from RI008 (InPort ID 5835), linked by VESSEL_CODE, CRUISE_NUMBER, STATION_NUMBER. Positive value is East longitude; negative value is West longitude. Measures are reported with a precision of 15.
100
RI008_END_LATITUDE_DD Number End latitude, in decimal degrees, from RI008 (InPort ID 5835), linked by VESSEL_CODE, CRUISE_NUMBER, STATION_NUMBER. Positive value is North latitude; negative value is South latitude. Measures are reported with a precision of 15.
100
RI008_END_LONGITUDE_DD Number End longitude, in decimal degrees, from RI008 (InPort ID 5835), linked by VESSEL_CODE, CRUISE_NUMBER, STATION_NUMBER. Positive value is East longitude; negative value is West longitude. Measures are reported with a precision of 15.
100
NUMBER_FISH_TAKEN Number Count of the fish species.
100
SPECIES_CODE Number Species code of the fish.
100
SPECIES_NAME Character Species name of the fish.
100
SEQUENCE_NUMBER Number A consecutive number assigned to each record for a block of data.
100
FROM_FILE Character Name of the flat ASCII file that was the source of the data.
100
DATE_LOADED Date Date when the record was loaded into Oracle or updated.

Attribute Details

DATASET_CODE

CC ID: 754561
Seq. Order: 1
Data Storage Type: Character
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

Source ID Code assigned by the data entry staff.

General Data Type: Character
Allowed Values: RI009

VERSION_CODE

CC ID: 754562
Seq. Order: 2
Data Storage Type: Character
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: Character

VESSEL_CODE

CC ID: 754563
Seq. Order: 3
Data Storage Type: Number
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Code for the vessel. Coded as 'TC' on the collection form, converted to '001'.

General Data Type: Number
Allowed Values: 001 = NOAA R/V TOWNSEND CROMWELL

CRUISE_NUMBER

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

Two-digit incremental number of the cruise, expanded to 4 digits.

General Data Type: Number

RI008_TRAWL_YEAR

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

Year of trawl operation, from RI008 (InPort ID 5835), linked by VESSEL_CODE, CRUISE_NUMBER, STATION_NUMBER.

General Data Type: Number

RI008_TRAWL_MONTH

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

Month of trawl operation, from RI008 (InPort ID 5835), linked by VESSEL_CODE, CRUISE_NUMBER, STATION_NUMBER.

General Data Type: Number

RI008_TRAWL_DAY

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

Day of trawl operation, from RI008, from RI008 (InPort ID 5835), linked by VESSEL_CODE, CRUISE_NUMBER, STATION_NUMBER.

General Data Type: Number

STATION_NUMBER

CC ID: 754568
Seq. Order: 8
Data Storage Type: Number
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Station number of trawl operation.

General Data Type: Number

RI008_START_LATITUDE_DD

CC ID: 754569
Seq. Order: 9
Data Storage Type: Number
Max Length: 16
Required: No
Primary Key: No
Scale: 13
Status: Active
Description:

Start latitude, in decimal degrees, from RI008 (InPort ID 5835), linked by VESSEL_CODE, CRUISE_NUMBER, STATION_NUMBER. Positive value is North latitude; negative value is South latitude. Measures are reported with a precision of 15.

General Data Type: Number

RI008_START_LONGITUDE_DD

CC ID: 754570
Seq. Order: 10
Data Storage Type: Number
Max Length: 17
Required: No
Primary Key: No
Scale: 12
Status: Active
Description:

Start longitude, in decimal degrees, from RI008 (InPort ID 5835), linked by VESSEL_CODE, CRUISE_NUMBER, STATION_NUMBER. Positive value is East longitude; negative value is West longitude. Measures are reported with a precision of 15.

General Data Type: Number

RI008_END_LATITUDE_DD

CC ID: 754571
Seq. Order: 11
Data Storage Type: Number
Max Length: 16
Required: No
Primary Key: No
Scale: 13
Status: Active
Description:

End latitude, in decimal degrees, from RI008 (InPort ID 5835), linked by VESSEL_CODE, CRUISE_NUMBER, STATION_NUMBER. Positive value is North latitude; negative value is South latitude. Measures are reported with a precision of 15.

General Data Type: Number

RI008_END_LONGITUDE_DD

CC ID: 754572
Seq. Order: 12
Data Storage Type: Number
Max Length: 17
Required: No
Primary Key: No
Scale: 12
Status: Active
Description:

End longitude, in decimal degrees, from RI008 (InPort ID 5835), linked by VESSEL_CODE, CRUISE_NUMBER, STATION_NUMBER. Positive value is East longitude; negative value is West longitude. Measures are reported with a precision of 15.

General Data Type: Number

NUMBER_FISH_TAKEN

CC ID: 754573
Seq. Order: 13
Data Storage Type: Number
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Count of the fish species.

General Data Type: Number

SPECIES_CODE

CC ID: 754574
Seq. Order: 14
Data Storage Type: Number
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

Species code of the fish.

General Data Type: Number

SPECIES_NAME

CC ID: 754575
Seq. Order: 15
Data Storage Type: Character
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Species name of the fish.

General Data Type: Character

SEQUENCE_NUMBER

CC ID: 754576
Seq. Order: 16
Data Storage Type: Number
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: Number

FROM_FILE

CC ID: 754577
Seq. Order: 17
Data Storage Type: Character
Max Length: 12
Required: No
Primary Key: No
Status: Active
Description:

Name of the flat ASCII file that was the source of the data.

General Data Type: Character

DATE_LOADED

CC ID: 754578
Seq. Order: 18
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: 52731
Metadata Record Created By: Brent M Miyamoto
Metadata Record Created: 2018-05-22 15:07+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2019-06-04 13:14+0000
Metadata Record Published: 2018-05-23
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2019-05-24