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

Summary

Abstract

Animal Log for Experimental Hauls

Description

Animal Log for Experimental Hauls

Entity Information

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
SECTION
NUMBER
Section of the gear the animal was caught in
TREATMENT
VARCHAR2
Treatment the animal received
TIME_BOARDED
DATE
When the animal was boarded
HOOK_TIMER_ELAPSED_TIME
VARCHAR2
Hook Timer elapsed time
HOW_HOOKED
VARCHAR2
How the animal was hooked
ENTANGLED
VARCHAR2
Was it entangled?
COMMENTS
VARCHAR2
Comments
HOOK_DEPTH
VARCHAR2
Hook Depth
UNK_CODE
VARCHAR2
Unknow Code
TDR
VARCHAR2
Time Depth Recorder
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

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

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