Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

NA

Description

NA

Entity Information

Data Attribute / Type Description
ID
NUMBER
A numeric field that does not accept null values, acceptable values are any unique integer, this is the primary key for the table.
ID_1
NUMBER
A numeric field that does not accept null values, identifies a given sample.
PairMatch
VARCHAR2
A text field that indicates the integer portion of ID_1 of a matched pair of tissue samples (matching different tissue types from the same fish), acceptable values the integer value of ID_1 and NONE.
Species
Unknown
A text field indicating the species from which a sample was collected.
Length(mm)
NUMBER
A numeric field indicating specimen length, acceptable values are any numeric value.
Tissue
VARCHAR2
A text field indicating tissue type, accaptable values are MUSCLE, LIVER, NEITHER.
Haul
NUMBER
A numeric field indicating haul number from which the sample was collected, acceptable values are any integer
Vessel
NUMBER
A text field indicating the vessel code from which the sample was collected, acceptable values are any integer, this is set to null for observer collected samples.
Cruise
NUMBER
A numeric field indicating the cruise from which the sample was collected, acceptable values are any integer, this is set to null for observer collected samples.
Region
VARCHAR2
A text field indicating region from which the sample was collected, acceptable values are B for Bering Sea, G for Gulf of Alaska, and null.
Lat
NUMBER
A numeric field containing Latitude (dd.dd), this is set to null for observer collected samples.
Lon
NUMBER
A numeric field containing Longitude (dd.dd), this is set to null for observer collected samples.
Date
Unknown
A date field indicating the date that the sample was collected, acceptable values are date or NULL, this is set to null for observer collected samples.
Year
NUMBER
A numeric field that indicates the year the sample was collected, acceptable values are any integer.
Gear_depth
NUMBER
A numeric field containing gear depth (m) of the haul from which the sample was collected, this is set to null for observer collected samples.
Bottom_depth
NUMBER
A numeric field containing botttom depth (m) of the haul from which the sample was collected, set to null for observer collected samples.
Haul_type
NUMBER
A numeric field that indicates haul type, acceptable values are NULL, 1 for off-bottom haul, 3 for bottom haul.
Mass
NUMBER
A numeric field that indicates the dry weight (g) of the tissue sample as submitted to isotopic analysis, acceptable values are numeric > 0, or NULL if not available.
CO2 Ampl
NUMBER
A numeric field, or NULL if not available, containing the amplitude of the C02 peak (volts) from the mass spectrometer, useful for debugging isotopic outliers outside the working range of the instrument.
N2 Ampl
NUMBER
A numeric field, or NULL if not available, containing the amplitude of the N2 peak (volts) from the mass spectrometer, useful for debugging isotopic outliers outside the working range of the instrument.
CO2 Area
NUMBER
A numeric field, or NULL if not available, containing the area of the C02 peak (volts/sec) from the mass spectrometer, useful for debugging isotopic outliers outside the working range of the instrument.
N2 Area
NUMBER
A numeric field, or NULL if not available, containing the area of the N2 peak (volts/sec) from the mass spectrometer, useful for debugging isotopic outliers outside the working range of the instrument.
d13C
NUMBER
A numeric field containing the isotopic ratio (d13C) of 13C to 12C in dried tissue samples, as difference (parts per thousand) from reference samples.
d15N
NUMBER
A numeric field containing the isotopic ratio (d15N) of 15N to 14N in dried tissue samples, as difference (parts per thousand) from reference samples.
perC
NUMBER
A numeric field, or NULL if not available, containing the percent by weight of carbon in the dried tissue sample.
perN
NUMBER
A numeric field, or NULL if not available, containing the percent by weight of nitrogen in the dried tissue sample.
C_N
NUMBER
A numeric field, or NULL if not available, containing the ratio of carbon to nitrogen by weight in the dried tissue sample.

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (AFSC) for inquiries on this record.

Item Identification

Title: Isotopes
Short Name: Isotopes
Status: In Work
Abstract:

NA

Notes:

Loaded by FGDC Metadata Uploader, batch 6535, 07-15-2015 13:15

Entity Information

Description:

NA

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
ID NUMBER A numeric field that does not accept null values, acceptable values are any unique integer, this is the primary key for the table.
100
ID_1 NUMBER A numeric field that does not accept null values, identifies a given sample.
100
PairMatch VARCHAR2 A text field that indicates the integer portion of ID_1 of a matched pair of tissue samples (matching different tissue types from the same fish), acceptable values the integer value of ID_1 and NONE.
100
Species Unknown A text field indicating the species from which a sample was collected.
100
Length(mm) NUMBER A numeric field indicating specimen length, acceptable values are any numeric value.
100
Tissue VARCHAR2 A text field indicating tissue type, accaptable values are MUSCLE, LIVER, NEITHER.
100
Haul NUMBER A numeric field indicating haul number from which the sample was collected, acceptable values are any integer
100
Vessel NUMBER A text field indicating the vessel code from which the sample was collected, acceptable values are any integer, this is set to null for observer collected samples.
100
Cruise NUMBER A numeric field indicating the cruise from which the sample was collected, acceptable values are any integer, this is set to null for observer collected samples.
100
Region VARCHAR2 A text field indicating region from which the sample was collected, acceptable values are B for Bering Sea, G for Gulf of Alaska, and null.
100
Lat NUMBER A numeric field containing Latitude (dd.dd), this is set to null for observer collected samples.
100
Lon NUMBER A numeric field containing Longitude (dd.dd), this is set to null for observer collected samples.
100
Date Unknown A date field indicating the date that the sample was collected, acceptable values are date or NULL, this is set to null for observer collected samples.
100
Year NUMBER A numeric field that indicates the year the sample was collected, acceptable values are any integer.
100
Gear_depth NUMBER A numeric field containing gear depth (m) of the haul from which the sample was collected, this is set to null for observer collected samples.
100
Bottom_depth NUMBER A numeric field containing botttom depth (m) of the haul from which the sample was collected, set to null for observer collected samples.
100
Haul_type NUMBER A numeric field that indicates haul type, acceptable values are NULL, 1 for off-bottom haul, 3 for bottom haul.
100
Mass NUMBER A numeric field that indicates the dry weight (g) of the tissue sample as submitted to isotopic analysis, acceptable values are numeric > 0, or NULL if not available.
100
CO2 Ampl NUMBER A numeric field, or NULL if not available, containing the amplitude of the C02 peak (volts) from the mass spectrometer, useful for debugging isotopic outliers outside the working range of the instrument.
100
N2 Ampl NUMBER A numeric field, or NULL if not available, containing the amplitude of the N2 peak (volts) from the mass spectrometer, useful for debugging isotopic outliers outside the working range of the instrument.
100
CO2 Area NUMBER A numeric field, or NULL if not available, containing the area of the C02 peak (volts/sec) from the mass spectrometer, useful for debugging isotopic outliers outside the working range of the instrument.
100
N2 Area NUMBER A numeric field, or NULL if not available, containing the area of the N2 peak (volts/sec) from the mass spectrometer, useful for debugging isotopic outliers outside the working range of the instrument.
100
d13C NUMBER A numeric field containing the isotopic ratio (d13C) of 13C to 12C in dried tissue samples, as difference (parts per thousand) from reference samples.
100
d15N NUMBER A numeric field containing the isotopic ratio (d15N) of 15N to 14N in dried tissue samples, as difference (parts per thousand) from reference samples.
100
perC NUMBER A numeric field, or NULL if not available, containing the percent by weight of carbon in the dried tissue sample.
100
perN NUMBER A numeric field, or NULL if not available, containing the percent by weight of nitrogen in the dried tissue sample.
100
C_N NUMBER A numeric field, or NULL if not available, containing the ratio of carbon to nitrogen by weight in the dried tissue sample.

Attribute Details

ID

CC ID: 276088
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

A numeric field that does not accept null values, acceptable values are any unique integer, this is the primary key for the table.

Unit of Measure: Integer
Allowed Values: 1 - 2119

ID_1

CC ID: 276089
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

A numeric field that does not accept null values, identifies a given sample.

Unit of Measure: AlphaNumeric
Allowed Values: 100a - m99

PairMatch

CC ID: 276090
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

A text field that indicates the integer portion of ID_1 of a matched pair of tissue samples (matching different tissue types from the same fish), acceptable values the integer value of ID_1 and NONE.

Allowed Values: ID_1, None

Species

CC ID: 276091
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

A text field indicating the species from which a sample was collected.

Allowed Values: unknown

Length(mm)

CC ID: 276092
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

A numeric field indicating specimen length, acceptable values are any numeric value.

Unit of Measure: mm
Allowed Values: 6.9 - 1420

Tissue

CC ID: 276093
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

A text field indicating tissue type, accaptable values are MUSCLE, LIVER, NEITHER.

Allowed Values: Muscle, Liver, Neither

Haul

CC ID: 276094
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

A numeric field indicating haul number from which the sample was collected, acceptable values are any integer

Unit of Measure: Integer
Allowed Values: 3 - 860

Vessel

CC ID: 276095
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

A text field indicating the vessel code from which the sample was collected, acceptable values are any integer, this is set to null for observer collected samples.

Unit of Measure: Integer
Allowed Values: 21 - 143

Cruise

CC ID: 276096
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

A numeric field indicating the cruise from which the sample was collected, acceptable values are any integer, this is set to null for observer collected samples.

Unit of Measure: Integer
Allowed Values: 200501 - 200801

Region

CC ID: 276097
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

A text field indicating region from which the sample was collected, acceptable values are B for Bering Sea, G for Gulf of Alaska, and null.

Allowed Values: G, B

Lat

CC ID: 276098
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

A numeric field containing Latitude (dd.dd), this is set to null for observer collected samples.

Unit of Measure: Latitude
Allowed Values: 51.68 - 62.0

Lon

CC ID: 276099
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

A numeric field containing Longitude (dd.dd), this is set to null for observer collected samples.

Unit of Measure: Longitude
Allowed Values: 173.26 - 226.23

Date

CC ID: 276100
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

A date field indicating the date that the sample was collected,

acceptable values are date or NULL, this is set to null for observer collected samples.

Allowed Values: unknown

Year

CC ID: 276101
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

A numeric field that indicates the year the sample was collected, acceptable values are any integer.

Unit of Measure: Integer
Allowed Values: 2005 - 2008

Gear_depth

CC ID: 276102
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

A numeric field containing gear depth (m) of the haul from which the sample was collected, this is set to null for observer collected samples.

Unit of Measure: m
Allowed Values: 0 - 1178

Bottom_depth

CC ID: 276103
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

A numeric field containing botttom depth (m) of the haul from which the sample was collected, set to null for observer collected samples.

Unit of Measure: m
Allowed Values: 0 - 1184

Haul_type

CC ID: 276104
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

A numeric field that indicates haul type, acceptable values are NULL, 1 for off-bottom haul, 3 for bottom haul.

Unit of Measure: Integer
Allowed Values: 1 - 3

Mass

CC ID: 276105
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

A numeric field that indicates the dry weight (g) of the tissue sample as submitted to isotopic analysis, acceptable values are numeric > 0, or NULL if not available.

Unit of Measure: g
Allowed Values: .6 - 1.2

CO2 Ampl

CC ID: 276106
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

A numeric field, or NULL if not available, containing the amplitude of the C02 peak (volts) from the mass spectrometer, useful for debugging isotopic outliers outside the working range of the instrument.

Unit of Measure: Volts
Allowed Values: 1.54 - 14.318

N2 Ampl

CC ID: 276107
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

A numeric field, or NULL if not available, containing the amplitude of the N2 peak (volts) from the mass spectrometer, useful for debugging isotopic outliers outside the working range of the instrument.

Unit of Measure: Volts
Allowed Values: .19 - 13.361

CO2 Area

CC ID: 276108
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

A numeric field, or NULL if not available, containing the area of the C02 peak (volts/sec) from the mass spectrometer, useful for debugging isotopic outliers outside the working range of the instrument.

Unit of Measure: volts/sec
Allowed Values: 37.633 - 351.981

N2 Area

CC ID: 276109
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

A numeric field, or NULL if not available, containing the area of the N2 peak (volts/sec) from the mass spectrometer, useful for debugging isotopic outliers outside the working range of the instrument.

Unit of Measure: volts/sec
Allowed Values: 4.08 - 279.314

d13C

CC ID: 276110
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

A numeric field containing the isotopic ratio (d13C) of 13C to 12C in dried tissue samples, as difference (parts per thousand) from reference samples.

Unit of Measure: ppt
Allowed Values: -29.54 - -14.29

d15N

CC ID: 276111
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

A numeric field containing the isotopic ratio (d15N) of 15N to 14N in dried tissue samples, as difference (parts per thousand) from reference samples.

Unit of Measure: ppt
Allowed Values: 6.56 - 20.41

perC

CC ID: 276112
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

A numeric field, or NULL if not available, containing the percent by weight of carbon in the dried tissue sample.

Unit of Measure: percent weight
Allowed Values: 19.2 - 185.75

perN

CC ID: 276113
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

A numeric field, or NULL if not available, containing the percent by weight of nitrogen in the dried tissue sample.

Unit of Measure: percent weight
Allowed Values: .57 - 27.03

C_N

CC ID: 276114
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

A numeric field, or NULL if not available, containing the ratio of carbon to nitrogen by weight in the dried tissue sample.

Unit of Measure: ratio numeric
Allowed Values: 2.71 - 114.0

Catalog Details

Catalog Item ID: 25974
GUID: gov.noaa.nmfs.inport:25974
Metadata Record Created By: Angie Greig
Metadata Record Created: 2015-07-15 13:15+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-04-28
Owner Org: AFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-04-28
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-04-28