Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
NEFSC Metadata Library > Population and Ecosystems Monitoring and Analys... > Population Biology Branch > Enhanced Biological Sampling Data >

FOOD_HABITS

Entity (ENT)  |  Northeast Fisheries Science Center (NEFSC)
GUID: gov.noaa.nmfs.inport:35892  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Stomach sample data from a specimen. Only collected during the first two years of sampling and for certain species.

Description

Stomach sample data from a specimen. Only collected during the first two years of sampling and for certain species.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
PREY_ID
NUMBER 		Sequential number for individual prey items
FISH_ID_CODE
VARCHAR2 		Unique code for each sampled fish.
PREY_NAME
VARCHAR2 		Prey species name. Taken from FHPY in the FHDBS.
PREY_MASS
NUMBER 		Mass in grams for each prey type found in a specimen
NUMBER_OF_PREY
NUMBER 		Count for each prey type found in a specimen
PREY_CONDITION
CHAR 		Relative state of digestion: F = fresh, P = partially digested, W = well digested, blank = unknown.
PREY_LENGTH
NUMBER 		Prey size (length or width) in mm for one specimen of each prey type. Measurement type depends on prey type. Additional prey sizes recorded in comments.
LENGTH_TYPE
CHAR 		Prey length was M = measured or E = estimated
COMMENTS
VARCHAR2 		Comments field for the stomach sample from each specimen
STOMACH_CONDITION
VARCHAR2 		Status of stomach sampled: BLOWN, EMPTY, or null
WORK_UP_CONDITION
VARCHAR2 		Stomach contents examined while FRESH or from a PRESERVED sample

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

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

Item Identification

Title: FOOD_HABITS
Short Name: FOOD_HABITS
Status: Completed
Abstract:

Stomach sample data from a specimen. Only collected during the first two years of sampling and for certain species.

Entity Information

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

Stomach sample data from a specimen. Only collected during the first two years of sampling and for certain species.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key PREY_ID NUMBER Sequential number for individual prey items
100
 FISH_ID_CODE VARCHAR2 Unique code for each sampled fish.
100
 PREY_NAME VARCHAR2 Prey species name. Taken from FHPY in the FHDBS.
100
 PREY_MASS NUMBER Mass in grams for each prey type found in a specimen
100
 NUMBER_OF_PREY NUMBER Count for each prey type found in a specimen
100
 PREY_CONDITION CHAR Relative state of digestion: F = fresh, P = partially digested, W = well digested, blank = unknown.
100
 PREY_LENGTH NUMBER Prey size (length or width) in mm for one specimen of each prey type. Measurement type depends on prey type. Additional prey sizes recorded in comments.
100
 LENGTH_TYPE CHAR Prey length was M = measured or E = estimated
100
 COMMENTS VARCHAR2 Comments field for the stomach sample from each specimen
100
 STOMACH_CONDITION VARCHAR2 Status of stomach sampled: BLOWN, EMPTY, or null
100
 WORK_UP_CONDITION VARCHAR2 Stomach contents examined while FRESH or from a PRESERVED sample

Attribute Details

PREY_ID

CC ID: 362220
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 8
Scale: 0
Status: Active
Description:

Sequential number for individual prey items
General Data Type: NUMBER

FISH_ID_CODE

CC ID: 362221
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 20
Required: Yes
Primary Key: No
Status: Active
Description:

Unique code for each sampled fish.
General Data Type: VARCHAR2
Foreign Key Relations:

FISH_ORGANISM.FISH_ID_CODE

PREY_NAME

CC ID: 362222
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

Prey species name. Taken from FHPY in the FHDBS.
General Data Type: VARCHAR2

PREY_MASS

CC ID: 362223
Seq. Order: 4
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 3
Status: Active
Description:

Mass in grams for each prey type found in a specimen
General Data Type: NUMBER

NUMBER_OF_PREY

CC ID: 362224
Seq. Order: 5
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Count for each prey type found in a specimen
General Data Type: NUMBER

PREY_CONDITION

CC ID: 362225
Seq. Order: 6
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Relative state of digestion: F = fresh, P = partially digested, W = well digested, blank = unknown.
General Data Type: CHAR

PREY_LENGTH

CC ID: 362226
Seq. Order: 7
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 0
Status: Active
Description:

Prey size (length or width) in mm for one specimen of each prey type. Measurement type depends on prey type. Additional prey sizes recorded in comments.
General Data Type: NUMBER

LENGTH_TYPE

CC ID: 362227
Seq. Order: 8
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Prey length was M = measured or E = estimated
General Data Type: CHAR

COMMENTS

CC ID: 362228
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 500
Required: No
Primary Key: No
Status: Active
Description:

Comments field for the stomach sample from each specimen
General Data Type: VARCHAR2

STOMACH_CONDITION

CC ID: 362229
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Status of stomach sampled: BLOWN, EMPTY, or null
General Data Type: VARCHAR2

WORK_UP_CONDITION

CC ID: 362230
Seq. Order: 11
Data Storage Type: VARCHAR2
Max Length: 15
Required: No
Primary Key: No
Status: Active
Description:

Stomach contents examined while FRESH or from a PRESERVED sample
General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 35892
GUID: gov.noaa.nmfs.inport:35892
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2016-12-07 13:27+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-12-12
Owner Org: NEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-12-12
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-12-12