Metadata Rubric

100%

6 / 6

SEFSC Metadata Library > Fisheries Statistics Division > Observer Programs > Pelagic Longline Observer Program > PELAGIC OBSERVER PROGRAM (POP). Catch/Effort d... >

Table: POP_ANIMAL_LOG

Entity (ENT) | Southeast Fisheries Science Center (SEFSC)
GUID: gov.noaa.nmfs.inport:5323 | Updated: June 14, 2024 | Published / External

Summary

Item Identification

Keywords

Entity Info

Data Attributes

Distribution Info

Catalog Details

Abstract

Animal Log for NON-experimental hauls

Description

Animal Log for NON-experimental hauls

Entity Type
Data Table

Data Attribute / Type	Description
ANIMAL_LOG_KEY NUMBER	Primary Key
HAUL_LOG_KEY NUMBER	Haul Log Key
CARCASS_TAG_NUMBER VARCHAR2	Number assigned by the sampler to the carcass of the fish.
ALPHA_SPECIES_CODE VARCHAR2	POP Spc. Code
LENGTH_MEASUREMENT_ONE NUMBER	First Length Measurement Taken
LENGTH_MEASUREMENT_TWO NUMBER	Second Length Measurement Taken
LENGTH_MEASUREMENT_THREE NUMBER	Third Length Measurement Taken
LENGTH_TYPE_ONE VARCHAR2	What was measured in Length Measurement One
LENGTH_TYPE_TWO VARCHAR2	What was measured in Length Measurement Two
LENGTH_TYPE_THREE VARCHAR2	What was measured in Length Measurement Three
LENGTH_MEASUREMENT_TAKEN_CODE VARCHAR2	Length Measurement Taken Code
DRESSED_WEIGHT NUMBER	Dressed weight of the fish landed. (should not be estimated)
TAG_NUMBER VARCHAR2	Theoretically a link could be made to the CTS system here.
SEX VARCHAR2	Can be: Undetermined, Male, Female
TAG_ACTION VARCHAR2	Coded item describing, what if anything happened with respect to the tagging of the fish.
BOARDING_STATUS VARCHAR2	Code For how the animal was boarded (Dead, Alive etc)
KEPT_OR_RELEASED VARCHAR2	Code to indicate whether animal caught was kept or released
KEPT_OR_RELEASED2 VARCHAR2	Valid Values: Dead, AliveThe column only had data in it when KEPT_OR_RELEASED is RELEASED
ESTIMATED_WEIGHT NUMBER	In Pounds
COMMENTS VARCHAR2	Comments
CREATED_BY_USER_ID VARCHAR2	Created by whom
CREATED_DATE DATE	Created when
MODIFIED_BY_USER_ID VARCHAR2	Modified by whom
MODIFIED_DATE DATE	Modified when
PAGE_NO NUMBER	Which Page Number Of The Animal Log Form record is found on. This column was added during conversion between POP and POPOL
LINE_NO NUMBER	Which Line Number Of The Animal Log Form record is found on. This column was added during conversion between POP and POPOL
DAMAGE_TYPE VARCHAR2	Code assigned to indicate observed damge on the fish

Data Attribute / Type

Description

ANIMAL_LOG_KEY
NUMBER

Primary Key

HAUL_LOG_KEY
NUMBER

Haul Log Key

CARCASS_TAG_NUMBER
VARCHAR2

Number assigned by the sampler to the carcass of the fish.

ALPHA_SPECIES_CODE
VARCHAR2

POP Spc. Code

LENGTH_MEASUREMENT_ONE
NUMBER

First Length Measurement Taken

LENGTH_MEASUREMENT_TWO
NUMBER

Second Length Measurement Taken

LENGTH_MEASUREMENT_THREE
NUMBER

Third Length Measurement Taken

LENGTH_TYPE_ONE
VARCHAR2

What was measured in Length Measurement One

LENGTH_TYPE_TWO
VARCHAR2

What was measured in Length Measurement Two

LENGTH_TYPE_THREE
VARCHAR2

What was measured in Length Measurement Three

LENGTH_MEASUREMENT_TAKEN_CODE
VARCHAR2

Length Measurement Taken Code

DRESSED_WEIGHT
NUMBER

Dressed weight of the fish landed. (should not be estimated)

TAG_NUMBER
VARCHAR2

Theoretically a link could be made to the CTS system here.

SEX
VARCHAR2

Can be: Undetermined, Male, Female

TAG_ACTION
VARCHAR2

Coded item describing, what if anything happened with respect to the tagging of the fish.

BOARDING_STATUS
VARCHAR2

Code For how the animal was boarded (Dead, Alive etc)

KEPT_OR_RELEASED
VARCHAR2

Code to indicate whether animal caught was kept or released

KEPT_OR_RELEASED2
VARCHAR2

Valid Values: Dead, AliveThe column only had data in it when KEPT_OR_RELEASED is RELEASED

ESTIMATED_WEIGHT
NUMBER

In Pounds

COMMENTS
VARCHAR2

Comments

CREATED_BY_USER_ID
VARCHAR2

Created by whom

CREATED_DATE
DATE

Created when

MODIFIED_BY_USER_ID
VARCHAR2

Modified by whom

MODIFIED_DATE
DATE

Modified when

PAGE_NO
NUMBER

Which Page Number Of The Animal Log Form record is found on. This column was added during conversion between POP and POPOL

LINE_NO
NUMBER

Which Line Number Of The Animal Log Form record is found on. This column was added during conversion between POP and POPOL

DAMAGE_TYPE
VARCHAR2

Code assigned to indicate observed damge on the fish

video data

x

No Child Items for this record.

No contact information is available for this record.

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

Title:	Table: POP_ANIMAL_LOG
Short Name:	POP_ANIMAL_LOG
Status:	Completed
Abstract:	Animal Log for NON-experimental hauls
Notes:	Loaded by batch 1683, 10-12-2007 05:01

Temporal Keywords

Thesaurus	Keyword
UNCONTROLLED
None	1992
None	1993
None	1994
None	1995
None	1996
None	1997
None	1998
None	1999
None	2000
None	2001
None	2002
None	2003
None	2004
None	2005
None	2006
None	2007
None	2008
None	2009
None	2010
None	2011

Entity Type:	Data Table
Active Version?:	Yes
Schema Name:	POPOL
Description:	Animal Log for NON-experimental hauls

Attribute Summary

	Name	Type	Description
100	ANIMAL_LOG_KEY	NUMBER	Primary Key
100	HAUL_LOG_KEY	NUMBER	Haul Log Key
100	CARCASS_TAG_NUMBER	VARCHAR2	Number assigned by the sampler to the carcass of the fish.
100	ALPHA_SPECIES_CODE	VARCHAR2	POP Spc. Code
100	LENGTH_MEASUREMENT_ONE	NUMBER	First Length Measurement Taken
100	LENGTH_MEASUREMENT_TWO	NUMBER	Second Length Measurement Taken
100	LENGTH_MEASUREMENT_THREE	NUMBER	Third Length Measurement Taken
100	LENGTH_TYPE_ONE	VARCHAR2	What was measured in Length Measurement One
100	LENGTH_TYPE_TWO	VARCHAR2	What was measured in Length Measurement Two
100	LENGTH_TYPE_THREE	VARCHAR2	What was measured in Length Measurement Three
100	LENGTH_MEASUREMENT_TAKEN_CODE	VARCHAR2	Length Measurement Taken Code
100	DRESSED_WEIGHT	NUMBER	Dressed weight of the fish landed. (should not be estimated)
100	TAG_NUMBER	VARCHAR2	Theoretically a link could be made to the CTS system here.
100	SEX	VARCHAR2	Can be: Undetermined, Male, Female
100	TAG_ACTION	VARCHAR2	Coded item describing, what if anything happened with respect to the tagging of the fish.
100	BOARDING_STATUS	VARCHAR2	Code For how the animal was boarded (Dead, Alive etc)
100	KEPT_OR_RELEASED	VARCHAR2	Code to indicate whether animal caught was kept or released
100	KEPT_OR_RELEASED2	VARCHAR2	Valid Values: Dead, AliveThe column only had data in it when KEPT_OR_RELEASED is RELEASED
100	ESTIMATED_WEIGHT	NUMBER	In Pounds
100	COMMENTS	VARCHAR2	Comments
100	CREATED_BY_USER_ID	VARCHAR2	Created by whom
100	CREATED_DATE	DATE	Created when
100	MODIFIED_BY_USER_ID	VARCHAR2	Modified by whom
100	MODIFIED_DATE	DATE	Modified when
100	PAGE_NO	NUMBER	Which Page Number Of The Animal Log Form record is found on. This column was added during conversion between POP and POPOL
100	LINE_NO	NUMBER	Which Line Number Of The Animal Log Form record is found on. This column was added during conversion between POP and POPOL
100	DAMAGE_TYPE	VARCHAR2	Code assigned to indicate observed damge on the fish

Name

Type

Description

100

ANIMAL_LOG_KEY

NUMBER

Primary Key

100

HAUL_LOG_KEY

NUMBER

Haul Log Key

100

CARCASS_TAG_NUMBER

VARCHAR2

Number assigned by the sampler to the carcass of the fish.

100

ALPHA_SPECIES_CODE

VARCHAR2

POP Spc. Code

100

LENGTH_MEASUREMENT_ONE

NUMBER

First Length Measurement Taken

100

LENGTH_MEASUREMENT_TWO

NUMBER

Second Length Measurement Taken

100

LENGTH_MEASUREMENT_THREE

NUMBER

Third Length Measurement Taken

100

LENGTH_TYPE_ONE

VARCHAR2

What was measured in Length Measurement One

100

LENGTH_TYPE_TWO

VARCHAR2

What was measured in Length Measurement Two

100

LENGTH_TYPE_THREE

VARCHAR2

What was measured in Length Measurement Three

100

LENGTH_MEASUREMENT_TAKEN_CODE

VARCHAR2

Length Measurement Taken Code

100

DRESSED_WEIGHT

NUMBER

Dressed weight of the fish landed. (should not be estimated)

100

TAG_NUMBER

VARCHAR2

Theoretically a link could be made to the CTS system here.

100

SEX

VARCHAR2

Can be: Undetermined, Male, Female

100

TAG_ACTION

VARCHAR2

Coded item describing, what if anything happened with respect to the tagging of the fish.

100

BOARDING_STATUS

VARCHAR2

Code For how the animal was boarded (Dead, Alive etc)

100

KEPT_OR_RELEASED

VARCHAR2

Code to indicate whether animal caught was kept or released

100

KEPT_OR_RELEASED2

VARCHAR2

Valid Values: Dead, AliveThe column only had data in it when KEPT_OR_RELEASED is RELEASED

100

ESTIMATED_WEIGHT

NUMBER

In Pounds

100

COMMENTS

VARCHAR2

Comments

100

CREATED_BY_USER_ID

VARCHAR2

Created by whom

100

CREATED_DATE

DATE

Created when

100

MODIFIED_BY_USER_ID

VARCHAR2

Modified by whom

100

MODIFIED_DATE

DATE

Modified when

100

PAGE_NO

NUMBER

Which Page Number Of The Animal Log Form record is found on. This column was added during conversion between POP and POPOL

100

LINE_NO

NUMBER

Which Line Number Of The Animal Log Form record is found on. This column was added during conversion between POP and POPOL

100

DAMAGE_TYPE

VARCHAR2

Code assigned to indicate observed damge on the fish

Attribute Details

ANIMAL_LOG_KEY

CC ID: 15556

Seq. Order:	1
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	Yes
Precision:	10
Scale:	0
Status:	Active
Description:	Primary Key
General Data Type:	NUMBER

HAUL_LOG_KEY

CC ID: 15555

Seq. Order:	2
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	Haul Log Key
General Data Type:	NUMBER

CARCASS_TAG_NUMBER

CC ID: 15554

Seq. Order:	3
Data Storage Type:	VARCHAR2
Max Length:	5
Required:	No
Primary Key:	No
Status:	Active
Description:	Number assigned by the sampler to the carcass of the fish.
General Data Type:	VARCHAR2

ALPHA_SPECIES_CODE

CC ID: 15553

Seq. Order:	4
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	POP Spc. Code
General Data Type:	VARCHAR2

LENGTH_MEASUREMENT_ONE

CC ID: 15552

Seq. Order:	5
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	First Length Measurement Taken
General Data Type:	NUMBER

LENGTH_MEASUREMENT_TWO

CC ID: 15551

Seq. Order:	6
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Second Length Measurement Taken
General Data Type:	NUMBER

LENGTH_MEASUREMENT_THREE

CC ID: 15550

Seq. Order:	7
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Third Length Measurement Taken
General Data Type:	NUMBER

LENGTH_TYPE_ONE

CC ID: 15549

Seq. Order:	8
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	What was measured in Length Measurement One
General Data Type:	VARCHAR2

LENGTH_TYPE_TWO

CC ID: 15548

Seq. Order:	9
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	What was measured in Length Measurement Two
General Data Type:	VARCHAR2

LENGTH_TYPE_THREE

CC ID: 15547

Seq. Order:	10
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	What was measured in Length Measurement Three
General Data Type:	VARCHAR2

LENGTH_MEASUREMENT_TAKEN_CODE

CC ID: 15546

Seq. Order:	11
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Length Measurement Taken Code
General Data Type:	VARCHAR2

DRESSED_WEIGHT

CC ID: 15545

Seq. Order:	12
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	Dressed weight of the fish landed. (should not be estimated)
General Data Type:	NUMBER

TAG_NUMBER

CC ID: 15544

Seq. Order:	13
Data Storage Type:	VARCHAR2
Max Length:	12
Required:	No
Primary Key:	No
Status:	Active
Description:	Theoretically a link could be made to the CTS system here.
General Data Type:	VARCHAR2

SEX

CC ID: 15543

Seq. Order:	14
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Can be: Undetermined, Male, Female
General Data Type:	VARCHAR2

TAG_ACTION

CC ID: 15542

Seq. Order:	15
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Coded item describing, what if anything happened with respect to the tagging of the fish.
General Data Type:	VARCHAR2

BOARDING_STATUS

CC ID: 15541

Seq. Order:	16
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Code For how the animal was boarded (Dead, Alive etc)
General Data Type:	VARCHAR2

KEPT_OR_RELEASED

CC ID: 15540

Seq. Order:	17
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Code to indicate whether animal caught was kept or released
General Data Type:	VARCHAR2

KEPT_OR_RELEASED2

CC ID: 15539

Seq. Order:	18
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Valid Values: Dead, AliveThe column only had data in it when KEPT_OR_RELEASED is RELEASED
General Data Type:	VARCHAR2

ESTIMATED_WEIGHT

CC ID: 15538

Seq. Order:	19
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	In Pounds
General Data Type:	NUMBER

COMMENTS

CC ID: 15537

Seq. Order:	20
Data Storage Type:	VARCHAR2
Max Length:	2000
Required:	No
Primary Key:	No
Status:	Active
Description:	Comments
General Data Type:	VARCHAR2

CREATED_BY_USER_ID

CC ID: 15536

Seq. Order:	21
Data Storage Type:	VARCHAR2
Max Length:	20
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Created by whom
General Data Type:	VARCHAR2

CREATED_DATE

CC ID: 15535

Seq. Order:	22
Data Storage Type:	DATE
Max Length:	7
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Created when
General Data Type:	DATE

MODIFIED_BY_USER_ID

CC ID: 15534

Seq. Order:	23
Data Storage Type:	VARCHAR2
Max Length:	20
Required:	No
Primary Key:	No
Status:	Active
Description:	Modified by whom
General Data Type:	VARCHAR2

MODIFIED_DATE

CC ID: 15533

Seq. Order:	24
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	Modified when
General Data Type:	DATE

PAGE_NO

CC ID: 15532

Seq. Order:	25
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	2
Scale:	0
Status:	Active
Description:	Which Page Number Of The Animal Log Form record is found on. This column was added during conversion between POP and POPOL
General Data Type:	NUMBER

LINE_NO

CC ID: 15531

Seq. Order:	26
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	2
Scale:	0
Status:	Active
Description:	Which Line Number Of The Animal Log Form record is found on. This column was added during conversion between POP and POPOL
General Data Type:	NUMBER

DAMAGE_TYPE

CC ID: 15530

Seq. Order:	27
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Code assigned to indicate observed damge on the fish
General Data Type:	VARCHAR2

Distribution 1

CC ID: 265057

Distributor:
File Name:	video data
Description:	x

Catalog Item ID:	5323
GUID:	gov.noaa.nmfs.inport:5323
Metadata Record Created By:	Lee M Weinberger
Metadata Record Created:	2007-10-12 05:01+0000
Metadata Record Last Modified By:	Lee M Weinberger
Metadata Record Last Modified:	2024-06-14 13:53+0000
Metadata Record Published:	2024-06-14
Owner Org:	SEFSC
Metadata Publication Status:	Published Externally
Do Not Publish?:	N
Metadata Last Review Date:	2021-05-06
Metadata Review Frequency:	1 Year
Metadata Next Review Date:	2022-05-06

Summary

Entity Information

Distribution Information

Child Items

Contact Information

Item Identification

Keywords

Temporal Keywords

Entity Information

Data Attributes

Attribute Summary

Attribute Details

ANIMAL_LOG_KEY

HAUL_LOG_KEY

CARCASS_TAG_NUMBER

ALPHA_SPECIES_CODE

LENGTH_MEASUREMENT_ONE

LENGTH_MEASUREMENT_TWO

LENGTH_MEASUREMENT_THREE

LENGTH_TYPE_ONE

LENGTH_TYPE_TWO

LENGTH_TYPE_THREE

LENGTH_MEASUREMENT_TAKEN_CODE

DRESSED_WEIGHT

TAG_NUMBER

SEX

TAG_ACTION

BOARDING_STATUS

KEPT_OR_RELEASED

KEPT_OR_RELEASED2

ESTIMATED_WEIGHT

COMMENTS

CREATED_BY_USER_ID

CREATED_DATE

MODIFIED_BY_USER_ID

MODIFIED_DATE

PAGE_NO

LINE_NO

DAMAGE_TYPE

Distribution Information

Distribution 1

Catalog Details