Item Identification

Title: RI014AA2_RSCH_V
Short Name: RI014AA2_RSCH_V
Status: Completed
Abstract:

This view contains data for R/V Townsend Cromwell (001) and R/V Charles H. Gilbert (007).

.

Entity Information

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

This view contains data for R/V Townsend Cromwell (001) and R/V Charles H. Gilbert (007).

.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
DATASET_CODE Character Source ID Code assigned by data entry staff (RI014).
100
VERSION_CODE Character Format version of the data assigned by data entry staff.
100
VESSEL_CODE Number Code for vessel.
100
CRUISE_NUMBER Number Last two digits of the year of the cruise and two digits for the consecutive number of the cruise for the year.
100
LOCAL_YEAR Number Local year of fishing.
100
LOCAL_MONTH Number Local month of fishing.
100
LOCAL_DAY Number Local day of fishing.
100
LOCAL_TIME_FISHING_START Number Local time fishing started.
100
OCTANT Number Number assigned to each octant of the globe, 0-3,5-8.
100
LATITUDE_DEGREES Number Latitude degrees. Units for values are degrees.
100
LATITUDE_MINUTES Number Latitude minutes. Units for values are minutes.
100
LATITUDE_DIRECTION Character Latitude direction of fishing. During data entry, LATITUDE_DIRECTION was not entered, and users found it in OCTANT. This field has been inserted into this database, based on OCTANT.
100
LATITUDE_DD Number Computed latitude, in decimal degrees, using LATITUDE_DEGREES,LATITUDE_MINUTES and LATITUDE_DIRECTION. Negative value is South latitude. Units for values are degrees. Measures are reported with a precision of 15.
100
LONGITUDE_DEGREES Number Longitude degrees. Units for values are degrees.
100
LONGITUDE_MINUTES Number Longitude minutes. Units for values are minutes.
100
LONGITUDE_DIRECTION Character Longitude direction of fishing. During data entry, LONGITUDE_DIRECTION was not entered, and users found it in OCTANT. This field has been inserted into this database, based on OCTANT.
100
LONGITUDE_DD Number Computed longitude, in decimal degrees, using LONGITUDE_DEGREES, LONGITUDE_MINUTES, LONGITUDE_DIRECTION. Negative value is West longitude. Units for values are degrees. Measures are reported with a precision of 15.
100
AREA_CODE Number Code for general area or bank fished.
100
STATION_NUMBER Number Consecutive number assigned to a cruise operation; station number for handline fishing operation.
100
LOCAL_TIME_FISHING_END Number Local time fishing ended.
100
NUMBER_LINES Number Average number of lines fished, in tenths of a line. During data entry, the decimal point was left off; it has been inserted into the data. Measures are reported with a precision of 3.
100
NUMBER_HOOKS_PER_LINE Number Average number of hooks per line, in tenths of a hook. During data entry, the decimal point was left off; it has been inserted into the data. Measures are reported with a precision of 3.
100
MINIMUM_DEPTH Number Minimum depth, in fathoms. Units for values are fathoms.
100
MAXIMUM_DEPTH Number Maximum depth, in fathoms. Units for values are fathoms.
100
DRIFTING_ANCHORED_CODE Number Code for drifting or anchored.
100
BAIT_CODE Number Code for kind(s) of bait used.
100
SPECIES_CODE Number Code for the species caught.
100
NUMBER_WEIGHED Number Number weighed of species.
100
WEIGHT Number Weight of species caught, in tenths of kilogram. During data entry, the decimal point was left off; it has been inserted into the data. Units for values are kilogram.
100
HOOK_SIZE Number Size of the hook used.
100
NUMBER_CAUGHT Number Number caught of species.
100
JOB_NUMBER Character Consecutive number assigned by the data entry staff to a unit of data that is entered and verified. Format MYYNNN, where M 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., M84059.
100
SEQUENCE_NUMBER Number Consecutive number that is assigned to each record for a block of data.
100
DATE_LOADED Date Date when the record was loaded into the Oracle view or last modified.

Attribute Details

DATASET_CODE

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

Source ID Code assigned by data entry staff (RI014).

General Data Type: Character
Allowed Values: RI014

VERSION_CODE

CC ID: 752944
Seq. Order: 2
Data Storage Type: Character
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Format version of the data assigned by data entry staff.

General Data Type: Character

VESSEL_CODE

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

Code for vessel.

General Data Type: Number
Allowed Values: 001 = NOAA R/V TOWNSEND CROMWELL 007 = NOAA R/V CHARLES H GILBERT

CRUISE_NUMBER

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

Last two digits of the year of the cruise and two digits for the consecutive number of the cruise for the year.

General Data Type: Number

LOCAL_YEAR

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

Local year of fishing.

General Data Type: Number

LOCAL_MONTH

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

Local month of fishing.

General Data Type: Number

LOCAL_DAY

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

Local day of fishing.

General Data Type: Number

LOCAL_TIME_FISHING_START

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

Local time fishing started.

General Data Type: Number

OCTANT

CC ID: 752951
Seq. Order: 9
Data Storage Type: Number
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Number assigned to each octant of the globe, 0-3,5-8.

General Data Type: Number

LATITUDE_DEGREES

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

Latitude degrees. Units for values are degrees.

General Data Type: Number
Unit of Measure: degrees

LATITUDE_MINUTES

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

Latitude minutes. Units for values are minutes.

General Data Type: Number
Unit of Measure: minutes

LATITUDE_DIRECTION

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

Latitude direction of fishing. During data entry, LATITUDE_DIRECTION was not entered, and users found it in OCTANT. This field has been inserted into this database, based on OCTANT.

General Data Type: Character
Allowed Values: N = NORTH S = SOUTH

LATITUDE_DD

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

Computed latitude, in decimal degrees, using LATITUDE_DEGREES,LATITUDE_MINUTES and LATITUDE_DIRECTION. Negative value is South latitude. Units for values are degrees. Measures are reported with a precision of 15.

General Data Type: Number
Unit of Measure: degrees

LONGITUDE_DEGREES

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

Longitude degrees. Units for values are degrees.

General Data Type: Number
Unit of Measure: degrees

LONGITUDE_MINUTES

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

Longitude minutes. Units for values are minutes.

General Data Type: Number
Unit of Measure: minutes

LONGITUDE_DIRECTION

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

Longitude direction of fishing. During data entry, LONGITUDE_DIRECTION was not entered, and users found it in OCTANT. This field has been inserted into this database, based on OCTANT.

General Data Type: Character
Allowed Values: E = EAST W = WEST

LONGITUDE_DD

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

Computed longitude, in decimal degrees, using LONGITUDE_DEGREES, LONGITUDE_MINUTES, LONGITUDE_DIRECTION. Negative value is West longitude. Units for values are degrees. Measures are reported with a precision of 15.

General Data Type: Number
Unit of Measure: degrees

AREA_CODE

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

Code for general area or bank fished.

General Data Type: Number

STATION_NUMBER

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

Consecutive number assigned to a cruise operation; station number for handline fishing operation.

General Data Type: Number

LOCAL_TIME_FISHING_END

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

Local time fishing ended.

General Data Type: Number

NUMBER_LINES

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

Average number of lines fished, in tenths of a line. During data entry, the decimal point was left off; it has been inserted into the data. Measures are reported with a precision of 3.

General Data Type: Number

NUMBER_HOOKS_PER_LINE

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

Average number of hooks per line, in tenths of a hook. During data entry, the decimal point was left off; it has been inserted into the data. Measures are reported with a precision of 3.

General Data Type: Number

MINIMUM_DEPTH

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

Minimum depth, in fathoms. Units for values are fathoms.

General Data Type: Number
Unit of Measure: fathoms

MAXIMUM_DEPTH

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

Maximum depth, in fathoms. Units for values are fathoms.

General Data Type: Number
Unit of Measure: fathoms

DRIFTING_ANCHORED_CODE

CC ID: 752967
Seq. Order: 25
Data Storage Type: Number
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Code for drifting or anchored.

General Data Type: Number

BAIT_CODE

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

Code for kind(s) of bait used.

General Data Type: Number

SPECIES_CODE

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

Code for the species caught.

General Data Type: Number

NUMBER_WEIGHED

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

Number weighed of species.

General Data Type: Number

WEIGHT

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

Weight of species caught, in tenths of kilogram. During data entry, the decimal point was left off; it has been inserted into the data. Units for values are kilogram.

General Data Type: Number
Unit of Measure: kilogram

HOOK_SIZE

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

Size of the hook used.

General Data Type: Number

NUMBER_CAUGHT

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

Number caught of species.

General Data Type: Number

JOB_NUMBER

CC ID: 752974
Seq. Order: 32
Data Storage Type: Character
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

Consecutive number assigned by the data entry staff to a unit of data that is entered and verified. Format MYYNNN, where M 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., M84059.

General Data Type: Character

SEQUENCE_NUMBER

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

Consecutive number that is assigned to each record for a block of data.

General Data Type: Number

DATE_LOADED

CC ID: 752976
Seq. Order: 34
Data Storage Type: Date
Max Length: 11
Required: No
Primary Key: No
Status: Active
Description:

Date when the record was loaded into the Oracle view or last modified.

General Data Type: Date

Catalog Details

Catalog Item ID: 52523
Metadata Record Created By: Brent M Miyamoto
Metadata Record Created: 2018-05-02 17:22+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2019-06-04 13:14+0000
Metadata Record Published: 2018-05-02
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2019-05-03