Isotopes
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:25974 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
NA
DescriptionNA
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
![]() |
![]() |
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
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
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
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
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)
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 |