Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
NEFSC Metadata Library > Population and Ecosystems Monitoring and Analys... > Population Biology Branch > Food Web Dynamics Program > Food Habits Database (FHDBS) >

Table: FHPD

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

Summary

Abstract

Predator Data

Description

Predator 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.
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
TOW
VARCHAR2 		Sequential number representing order in which station was selected within a stratum.
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.
CATSEX
VARCHAR2 		Numeric sex code: 0=unsexed, 1=male, 2=female.
TOWDATE
DATE 		Date of tow.
TOWTIME
VARCHAR2 		Time at beginning of tow in EST, 24 hour time notation.
BEGLAT
NUMBER 		Beginning latitude of tow.
BEGLON
NUMBER 		Beginning longitude of tow.
SETDEPTH
NUMBER 		A four digit number recording the depth, to the nearest meter, at the start of a trawl, dredge, or other survey gear deployment.
BOTTEMP
NUMBER 		Bottom temperature.
SVSEAS
VARCHAR2 		Survey season for routine groundfish cruises.
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.
FHSEX
VARCHAR2 		Predator sex code: M=male, F=female, X=unknown, I=unknown, U=unknown.
FHPDLEN
NUMBER 		Predator length to the nearest CM.
PDLEN
NUMBER 		Predator length in CM, rounded up.
SVPDLEN
NUMBER 		Predator length from Survey data measured in centimeters.
PDWGT
NUMBER 		Total body weight of predator in grams.
PDMINL
NUMBER 		Predator minimum length in CM
PDMAXL
NUMBER 		Predator maximum length in CM.
PDAVEL
NUMBER 		Predator average length in CM (grouped data).
PDSVOL
NUMBER 		Total stomach volume for an individual predator in cubic centimeters.
PDSWGT
NUMBER 		Total stomach weight for an individual predator in grams.
FHMAT
VARCHAR2 		Predator maturity code:I=immature,D=developing,R=ripe, U=ripe and running,S=spent,T=resting
PDMAT
VARCHAR2 		Predator maturity code: I=immature,D=developing,R=ripe,U=ripe and runing,S=spent,T=resting,E=eyed,X=unknown
PDAGE
NUMBER 		Predator age in years.
PDSAMP
NUMBER 		Number of predators sampled.
PDEMPT
NUMBER 		Number of empty predator stomachs in sample.
PYMINL
NUMBER 		Minimum length of all fish prey measured in a single predator.
PYMAXL
NUMBER 		Maximum length of all the fish prey measured in a single predator.
PYAVEL
NUMBER 		Average length for all fish prey measusred in a single predator in millimeters.
FHDAT
VARCHAR2 		Code for food habits data: E=examined at sea, P=preserved.
MATDAT
VARCHAR2 		Null data field
REMARK
VARCHAR2 		Indicates remark entered on log.
WRITER
VARCHAR2 		Person recording data on log sheet.
CUTTER
VARCHAR2 		A thirty character field indicating the individual who was measuring and cutting fish at a FSCS workstation.
A_UPDATE
DATE 		Last date record was edited.
A_USERID
VARCHAR2 		Initials of person editing record.
T_FHMOD
VARCHAR2 		Data auditing flag
T_PDCOM
VARCHAR2 		Predator comments field
T_SVMOD
VARCHAR2 		Data auditing flag
SUNRIS
VARCHAR2 		Null data field
SUNSET
VARCHAR2 		Null data field
DIEL
VARCHAR2 		Null data 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: FHPD
Short Name: FHPD
Status: Completed
Abstract:

Predator Data
Notes:

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

Entity Information

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

Predator 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
 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
 TOW VARCHAR2 Sequential number representing order in which station was selected within a stratum.
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
 CATSEX VARCHAR2 Numeric sex code: 0=unsexed, 1=male, 2=female.
100
 TOWDATE DATE Date of tow.
100
 TOWTIME VARCHAR2 Time at beginning of tow in EST, 24 hour time notation.
100
 BEGLAT NUMBER Beginning latitude of tow.
100
 BEGLON NUMBER Beginning longitude of tow.
100
 SETDEPTH NUMBER A four digit number recording the depth, to the nearest meter, at the start of a trawl, dredge, or other survey gear deployment.
100
 BOTTEMP NUMBER Bottom temperature.
100
 SVSEAS VARCHAR2 Survey season for routine groundfish cruises.
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
 FHSEX VARCHAR2 Predator sex code: M=male, F=female, X=unknown, I=unknown, U=unknown.
100
 FHPDLEN NUMBER Predator length to the nearest CM.
100
 PDLEN NUMBER Predator length in CM, rounded up.
100
 SVPDLEN NUMBER Predator length from Survey data measured in centimeters.
100
 PDWGT NUMBER Total body weight of predator in grams.
100
 PDMINL NUMBER Predator minimum length in CM
100
 PDMAXL NUMBER Predator maximum length in CM.
100
 PDAVEL NUMBER Predator average length in CM (grouped data).
100
 PDSVOL NUMBER Total stomach volume for an individual predator in cubic centimeters.
100
 PDSWGT NUMBER Total stomach weight for an individual predator in grams.
100
 FHMAT VARCHAR2 Predator maturity code:I=immature,D=developing,R=ripe, U=ripe and running,S=spent,T=resting
100
 PDMAT VARCHAR2 Predator maturity code: I=immature,D=developing,R=ripe,U=ripe and runing,S=spent,T=resting,E=eyed,X=unknown
100
 PDAGE NUMBER Predator age in years.
100
 PDSAMP NUMBER Number of predators sampled.
100
 PDEMPT NUMBER Number of empty predator stomachs in sample.
100
 PYMINL NUMBER Minimum length of all fish prey measured in a single predator.
100
 PYMAXL NUMBER Maximum length of all the fish prey measured in a single predator.
100
 PYAVEL NUMBER Average length for all fish prey measusred in a single predator in millimeters.
100
 FHDAT VARCHAR2 Code for food habits data: E=examined at sea, P=preserved.
100
 MATDAT VARCHAR2 Null data field
100
 REMARK VARCHAR2 Indicates remark entered on log.
100
 WRITER VARCHAR2 Person recording data on log sheet.
100
 CUTTER VARCHAR2 A thirty character field indicating the individual who was measuring and cutting fish at a FSCS workstation.
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_PDCOM VARCHAR2 Predator comments field
100
 T_SVMOD VARCHAR2 Data auditing flag
100
 SUNRIS VARCHAR2 Null data field
100
 SUNSET VARCHAR2 Null data field
100
 DIEL VARCHAR2 Null data 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: 328451
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: 328462
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
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

STRATUM

CC ID: 328473
Seq. Order: 3
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

TOW

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

Sequential number representing order in which station was selected within a stratum.
General Data Type: VARCHAR2

STATION

CC ID: 328495
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
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: 328503
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
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: 328504
Seq. Order: 7
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: 328505
Seq. Order: 8
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 0
Status: Active
Description:

Predator ID number beginning in 1991.
General Data Type: NUMBER

CATSEX

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

Numeric sex code: 0=unsexed, 1=male, 2=female.
General Data Type: VARCHAR2

TOWDATE

CC ID: 328452
Seq. Order: 10
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: 328453
Seq. Order: 11
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

BEGLAT

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

Beginning latitude of tow.
General Data Type: NUMBER

BEGLON

CC ID: 328455
Seq. Order: 13
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 12
Scale: 8
Status: Active
Description:

Beginning longitude of tow.
General Data Type: NUMBER

SETDEPTH

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

A four digit number recording the depth, to the nearest meter, at the start of a trawl, dredge, or other survey gear deployment.
General Data Type: NUMBER

BOTTEMP

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

Bottom temperature.
General Data Type: NUMBER

SVSEAS

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

Survey season for routine groundfish cruises.
General Data Type: VARCHAR2

CRUTYP

CC ID: 328459
Seq. Order: 17
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: 328460
Seq. Order: 18
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: 328461
Seq. Order: 19
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

FHSEX

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

Predator sex code: M=male, F=female, X=unknown, I=unknown, U=unknown.
General Data Type: VARCHAR2

FHPDLEN

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

Predator length to the nearest CM.
General Data Type: NUMBER

PDLEN

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

Predator length in CM, rounded up.
General Data Type: NUMBER

SVPDLEN

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

Predator length from Survey data measured in centimeters.
General Data Type: NUMBER

PDWGT

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

Total body weight of predator in grams.
General Data Type: NUMBER

PDMINL

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

Predator minimum length in CM
General Data Type: NUMBER

PDMAXL

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

Predator maximum length in CM.
General Data Type: NUMBER

PDAVEL

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

Predator average length in CM (grouped data).
General Data Type: NUMBER

PDSVOL

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

Total stomach volume for an individual predator in cubic centimeters.
General Data Type: NUMBER

PDSWGT

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

Total stomach weight for an individual predator in grams.
General Data Type: NUMBER

FHMAT

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

Predator maturity code:I=immature,D=developing,R=ripe, U=ripe and running,S=spent,T=resting
General Data Type: VARCHAR2

PDMAT

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

Predator maturity code: I=immature,D=developing,R=ripe,U=ripe and runing,S=spent,T=resting,E=eyed,X=unknown
General Data Type: VARCHAR2

PDAGE

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

Predator age in years.
General Data Type: NUMBER

PDSAMP

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

Number of predators sampled.
General Data Type: NUMBER

PDEMPT

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

Number of empty predator stomachs in sample.
General Data Type: NUMBER

PYMINL

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

Minimum length of all fish prey measured in a single predator.
General Data Type: NUMBER

PYMAXL

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

Maximum length of all the fish prey measured in a single predator.
General Data Type: NUMBER

PYAVEL

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

Average length for all fish prey measusred in a single predator in millimeters.
General Data Type: NUMBER

FHDAT

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

Code for food habits data: E=examined at sea, P=preserved.
General Data Type: VARCHAR2

MATDAT

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

Null data field
General Data Type: VARCHAR2

REMARK

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

Indicates remark entered on log.
General Data Type: VARCHAR2

WRITER

CC ID: 328487
Seq. Order: 42
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Person recording data on log sheet.
General Data Type: VARCHAR2

CUTTER

CC ID: 328488
Seq. Order: 43
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

A thirty character field indicating the individual who was measuring and cutting fish at a FSCS workstation.
General Data Type: VARCHAR2

A_UPDATE

CC ID: 328490
Seq. Order: 45
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: 328491
Seq. Order: 46
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: 328492
Seq. Order: 47
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Data auditing flag
General Data Type: VARCHAR2

T_PDCOM

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

Predator comments field
General Data Type: VARCHAR2

T_SVMOD

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

Data auditing flag
General Data Type: VARCHAR2

SUNRIS

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

Null data field
General Data Type: VARCHAR2

SUNSET

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

Null data field
General Data Type: VARCHAR2

DIEL

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

Null data field
General Data Type: VARCHAR2

DOC

CC ID: 328499
Seq. Order: 53
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: 328500
Seq. Order: 54
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: 328501
Seq. Order: 55
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: 328502
Seq. Order: 56
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: 33190
GUID: gov.noaa.nmfs.inport:33190
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