Metadata Rubric

100%

6 / 6

NEFSC Metadata Library > Population and Ecosystems Monitoring and Analys... > Population Biology Branch > Food Web Dynamics Program > Food Habits Database (FHDBS) >

Table: FHPY

Entity (ENT) | Northeast Fisheries Science Center (NEFSC)
GUID: gov.noaa.nmfs.inport:33191 | Updated: August 9, 2022 | Published / External

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

Prey Data

Description

Prey Data

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.

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.

No Child Items for this record.

No contact information is available for this record.

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

Title:	Table: FHPY
Short Name:	FHPY
Status:	Completed
Abstract:	Prey Data
Notes:	Loaded by batch 8930, 07-01-2016 13:03

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

Attribute Summary

	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.

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

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 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

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

CRUISE6

CRUISE

STATION

SVSPP

PDSEX

PDID

TOWDATE

TOWTIME

STRATUM

CRUTYP

FHTYPE

LOGNUM

PYDIG

PYNAM

PYSPP

PYABBR

PYWGTA

PYWGTI

PYPERI

PYVOLA

PYVOLI

PYNUM

PYMEAS

A_UPDATE

A_USERID

T_FHMOD

T_PYCOM

DOC

DOE

UOE

UOC

Catalog Details