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

Summary

Abstract

Prey Data

Description

Prey Data

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
CRUISE6
VARCHAR2
Code uniquely identifying cruise. The first four digits indicate the year and the last two digit uniquely identify the cruise within the year.
CRUISE
VARCHAR2
Cruise code - first to digits reflect year and second 2 are numbers sequentially assigned to indicate the order in which the cruises were coded.
STATION
VARCHAR2
Unique sequential order in which stations have been completed. Hangups and short tows each receive a non-repeated consecutive number.
SVSPP
VARCHAR2
A three digit alphanumeric filed used to code each species caught in a trawl or dredge. Refer to the svdbs.svspecies_list table for all 3 digit species codes.
PDSEX
VARCHAR2
Predator sex code: 0=unknown, 1=male, 2=female, 4=transitional.
PDID
NUMBER
Predator ID number beginning in 1991.
TOWDATE
DATE
Date of tow.
TOWTIME
VARCHAR2
Time at beginning of tow in EST, 24 hour time notation.
STRATUM
VARCHAR2
A predefined area where a net dredge, or other piece of gear was deployed. Code consists of 3 parts: Stratum group code number (2 bytes) and stratum number (3 bytes). Stratum group refers to if area fished is inshore or offshore North or South of Cape Hatteras or the type of cruise (shellfish, State of MA, offshore deepwater). The stratum number (third and fourth digits of code) refers to area defined by depth zone. See svdbs.svmstrata. The fifth digit of the code increases the length of the stratum number for revised strata after the Hague Line was established. Stratum group code: 01 = Trawl, offshore north of Hatteras 02 = BIOME 03 = Trawl, inshore north of Hatteras 04 = Shrimp 05 = Scotian shelf 06 = Shellfish 07 = Trawl, inshore south of Hatteras 08 = Trawl, Offhore south of Hatteras 09 = MA DMF 99 = Offshore deepwater (outside the stratified area) A change in Bottom Trawl Stratum for the Gulf of Maine-Bay of Fundy has been in effect since Spring 1987, and may be summarized as follows: Previous strata: 01350 Present strata: 01351, 01352
CRUTYP
VARCHAR2
Food habits study type: BE=Biological Effects, GC=Gear Comoparison, GF=Ground Fish, GM=Gulf of Maine,BLM=Bureau of Land Management,MS=Mackerel,JF=Juvenile Fish.
FHTYPE
VARCHAR2
Code to indicate how samples were collected and measured:2=individual, percent fullness, 6=individual, weight (1973-1980), 8=individual, volume (1981 - present).
LOGNUM
VARCHAR2
Prior to 1991, unique number assigned to each predator. In 1991 the LOGNUM was replaced with PDID.
PYDIG
VARCHAR2
Relative state of digestion: F=fresh, P=partially digested,W=well digested, blank = unknown.
PYNAM
VARCHAR2
Prey scientific name.
PYSPP
VARCHAR2
Prey species name.
PYABBR
VARCHAR2
Prey abbreviation.
PYWGTA
NUMBER
Prey species weight for grouped predator sampling.
PYWGTI
NUMBER
Prey weight for individual predator.
PYPERI
NUMBER
Prey species measured as percent of the total predator stomach fullness.
PYVOLA
NUMBER
Volume of prey for grouped predators.
PYVOLI
NUMBER
Volume of prey for individual predator.
PYNUM
NUMBER
Number of prey per prey species.
PYMEAS
NUMBER
Number of prey lengths measured, summed up by program.
A_UPDATE
DATE
Last date record was edited.
A_USERID
VARCHAR2
Initials of person editing record.
T_FHMOD
VARCHAR2
Data auditing flag
T_PYCOM
VARCHAR2
Prey comments field
DOC
DATE
Date when the current record was updated or changed. Date format (MM/DD/YY HH:MI:SS).
DOE
DATE
Date when record was inserted into Oracle. Date format (MM/DD/YY HH:MI:SS).
UOE
VARCHAR2
The Oracle username of the individual who entered the new record.
UOC
VARCHAR2
The Oracle username of the individual who changed the current record.

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: Table: FHPY
Short Name: FHPY
Status: Completed
Abstract:

Prey Data

Notes:

Loaded by batch 8930, 07-01-2016 13:03

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: FHDBS
Description:

Prey Data

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
CRUISE6 VARCHAR2 Code uniquely identifying cruise. The first four digits indicate the year and the last two digit uniquely identify the cruise within the year.
100
CRUISE VARCHAR2 Cruise code - first to digits reflect year and second 2 are numbers sequentially assigned to indicate the order in which the cruises were coded.
100
STATION VARCHAR2 Unique sequential order in which stations have been completed. Hangups and short tows each receive a non-repeated consecutive number.
100
SVSPP VARCHAR2 A three digit alphanumeric filed used to code each species caught in a trawl or dredge. Refer to the svdbs.svspecies_list table for all 3 digit species codes.
100
PDSEX VARCHAR2 Predator sex code: 0=unknown, 1=male, 2=female, 4=transitional.
100
PDID NUMBER Predator ID number beginning in 1991.
100
TOWDATE DATE Date of tow.
100
TOWTIME VARCHAR2 Time at beginning of tow in EST, 24 hour time notation.
100
STRATUM VARCHAR2 A predefined area where a net dredge, or other piece of gear was deployed. Code consists of 3 parts: Stratum group code number (2 bytes) and stratum number (3 bytes). Stratum group refers to if area fished is inshore or offshore North or South of Cape Hatteras or the type of cruise (shellfish, State of MA, offshore deepwater). The stratum number (third and fourth digits of code) refers to area defined by depth zone. See svdbs.svmstrata. The fifth digit of the code increases the length of the stratum number for revised strata after the Hague Line was established. Stratum group code: 01 = Trawl, offshore north of Hatteras 02 = BIOME 03 = Trawl, inshore north of Hatteras 04 = Shrimp 05 = Scotian shelf 06 = Shellfish 07 = Trawl, inshore south of Hatteras 08 = Trawl, Offhore south of Hatteras 09 = MA DMF 99 = Offshore deepwater (outside the stratified area) A change in Bottom Trawl Stratum for the Gulf of Maine-Bay of Fundy has been in effect since Spring 1987, and may be summarized as follows: Previous strata: 01350 Present strata: 01351, 01352
100
CRUTYP VARCHAR2 Food habits study type: BE=Biological Effects, GC=Gear Comoparison, GF=Ground Fish, GM=Gulf of Maine,BLM=Bureau of Land Management,MS=Mackerel,JF=Juvenile Fish.
100
FHTYPE VARCHAR2 Code to indicate how samples were collected and measured:2=individual, percent fullness, 6=individual, weight (1973-1980), 8=individual, volume (1981 - present).
100
LOGNUM VARCHAR2 Prior to 1991, unique number assigned to each predator. In 1991 the LOGNUM was replaced with PDID.
100
PYDIG VARCHAR2 Relative state of digestion: F=fresh, P=partially digested,W=well digested, blank = unknown.
100
PYNAM VARCHAR2 Prey scientific name.
100
PYSPP VARCHAR2 Prey species name.
100
PYABBR VARCHAR2 Prey abbreviation.
100
PYWGTA NUMBER Prey species weight for grouped predator sampling.
100
PYWGTI NUMBER Prey weight for individual predator.
100
PYPERI NUMBER Prey species measured as percent of the total predator stomach fullness.
100
PYVOLA NUMBER Volume of prey for grouped predators.
100
PYVOLI NUMBER Volume of prey for individual predator.
100
PYNUM NUMBER Number of prey per prey species.
100
PYMEAS NUMBER Number of prey lengths measured, summed up by program.
100
A_UPDATE DATE Last date record was edited.
100
A_USERID VARCHAR2 Initials of person editing record.
100
T_FHMOD VARCHAR2 Data auditing flag
100
T_PYCOM VARCHAR2 Prey comments field
100
DOC DATE Date when the current record was updated or changed. Date format (MM/DD/YY HH:MI:SS).
100
DOE DATE Date when record was inserted into Oracle. Date format (MM/DD/YY HH:MI:SS).
100
UOE VARCHAR2 The Oracle username of the individual who entered the new record.
100
UOC VARCHAR2 The Oracle username of the individual who changed the current record.

Attribute Details

CRUISE6

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

Code uniquely identifying cruise. The first four digits indicate the year and the last two digit uniquely identify the cruise within the year.

General Data Type: VARCHAR2

CRUISE

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

Cruise code - first to digits reflect year and second 2 are numbers sequentially assigned to indicate the order in which the cruises were coded.

General Data Type: VARCHAR2

STATION

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

Unique sequential order in which stations have been completed. Hangups and short tows each receive a non-repeated consecutive number.

General Data Type: VARCHAR2

SVSPP

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

A three digit alphanumeric filed used to code each species caught in a trawl or dredge. Refer to the svdbs.svspecies_list table for all 3 digit species codes.

General Data Type: VARCHAR2

PDSEX

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

Predator sex code: 0=unknown, 1=male, 2=female, 4=transitional.

General Data Type: VARCHAR2

PDID

CC ID: 328536
Seq. Order: 6
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 6
Scale: 0
Status: Active
Description:

Predator ID number beginning in 1991.

General Data Type: NUMBER

TOWDATE

CC ID: 328537
Seq. Order: 7
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date of tow.

General Data Type: DATE

TOWTIME

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

Time at beginning of tow in EST, 24 hour time notation.

General Data Type: VARCHAR2

STRATUM

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

A predefined area where a net dredge, or other piece of gear was deployed. Code consists of 3 parts: Stratum group code number (2 bytes) and stratum number (3 bytes). Stratum group refers to if area fished is inshore or offshore North or South of Cape Hatteras or the type of cruise (shellfish, State of MA, offshore deepwater). The stratum number (third and fourth digits of code) refers to area defined by depth zone. See svdbs.svmstrata. The fifth digit of the code increases the length of the stratum number for revised strata after the Hague Line was established. Stratum group code: 01 = Trawl, offshore north of Hatteras 02 = BIOME 03 = Trawl, inshore north of Hatteras 04 = Shrimp 05 = Scotian shelf 06 = Shellfish 07 = Trawl, inshore south of Hatteras 08 = Trawl, Offhore south of Hatteras 09 = MA DMF 99 = Offshore deepwater (outside the stratified area) A change in Bottom Trawl Stratum for the Gulf of Maine-Bay of Fundy has been in effect since Spring 1987, and may be summarized as follows: Previous strata: 01350 Present strata: 01351, 01352

General Data Type: VARCHAR2

CRUTYP

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

Food habits study type: BE=Biological Effects, GC=Gear Comoparison, GF=Ground Fish, GM=Gulf of Maine,BLM=Bureau of Land Management,MS=Mackerel,JF=Juvenile Fish.

General Data Type: VARCHAR2

FHTYPE

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

Code to indicate how samples were collected and measured:2=individual, percent fullness, 6=individual, weight (1973-1980), 8=individual, volume (1981 - present).

General Data Type: VARCHAR2

LOGNUM

CC ID: 328510
Seq. Order: 12
Data Storage Type: VARCHAR2
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

Prior to 1991, unique number assigned to each predator. In 1991 the LOGNUM was replaced with PDID.

General Data Type: VARCHAR2

PYDIG

CC ID: 328511
Seq. Order: 13
Data Storage Type: VARCHAR2
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: VARCHAR2

PYNAM

CC ID: 328512
Seq. Order: 14
Data Storage Type: VARCHAR2
Max Length: 45
Required: No
Primary Key: No
Status: Active
Description:

Prey scientific name.

General Data Type: VARCHAR2

PYSPP

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

Prey species name.

General Data Type: VARCHAR2

PYABBR

CC ID: 328515
Seq. Order: 17
Data Storage Type: VARCHAR2
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

Prey abbreviation.

General Data Type: VARCHAR2

PYWGTA

CC ID: 328516
Seq. Order: 18
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 8
Scale: 3
Status: Active
Description:

Prey species weight for grouped predator sampling.

General Data Type: NUMBER

PYWGTI

CC ID: 328517
Seq. Order: 19
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 8
Scale: 3
Status: Active
Description:

Prey weight for individual predator.

General Data Type: NUMBER

PYPERI

CC ID: 328519
Seq. Order: 20
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

Prey species measured as percent of the total predator stomach fullness.

General Data Type: NUMBER

PYVOLA

CC ID: 328520
Seq. Order: 21
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 1
Status: Active
Description:

Volume of prey for grouped predators.

General Data Type: NUMBER

PYVOLI

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

Volume of prey for individual predator.

General Data Type: NUMBER

PYNUM

CC ID: 328522
Seq. Order: 23
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

Number of prey per prey species.

General Data Type: NUMBER

PYMEAS

CC ID: 328523
Seq. Order: 24
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

Number of prey lengths measured, summed up by program.

General Data Type: NUMBER

A_UPDATE

CC ID: 328525
Seq. Order: 26
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Last date record was edited.

General Data Type: DATE

A_USERID

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

Initials of person editing record.

General Data Type: VARCHAR2

T_FHMOD

CC ID: 328527
Seq. Order: 28
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Data auditing flag

General Data Type: VARCHAR2

T_PYCOM

CC ID: 328528
Seq. Order: 29
Data Storage Type: VARCHAR2
Max Length: 60
Required: No
Primary Key: No
Status: Active
Description:

Prey comments field

General Data Type: VARCHAR2

DOC

CC ID: 328530
Seq. Order: 30
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date when the current record was updated or changed. Date format (MM/DD/YY HH:MI:SS).

General Data Type: DATE

DOE

CC ID: 328531
Seq. Order: 31
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date when record was inserted into Oracle. Date format (MM/DD/YY HH:MI:SS).

General Data Type: DATE

UOE

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

The Oracle username of the individual who entered the new record.

General Data Type: VARCHAR2

UOC

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

The Oracle username of the individual who changed the current record.

General Data Type: VARCHAR2

Catalog Details

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