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.

Item Identification

Title: Table: POP_ANIMAL_LOG_EXP
Short Name: POP_ANIMAL_LOG_EXP
Status: Completed
Abstract:

Animal Log for Experimental Hauls

Notes:

Loaded by batch 1683, 10-12-2007 05:01

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None experimental data
None protective species
None turtles

Temporal Keywords

Thesaurus Keyword
UNCONTROLLED
None 2002-2011

Spatial Keywords

Thesaurus Keyword
UNCONTROLLED
None Atantic Ocean
None Gulf of Mexico
None NED

Entity Information

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

Animal Log for Experimental Hauls

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key 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
SECTION NUMBER Section of the gear the animal was caught in
100
TREATMENT VARCHAR2 Treatment the animal received
100
TIME_BOARDED DATE When the animal was boarded
100
HOOK_TIMER_ELAPSED_TIME VARCHAR2 Hook Timer elapsed time
100
HOW_HOOKED VARCHAR2 How the animal was hooked
100
ENTANGLED VARCHAR2 Was it entangled?
100
COMMENTS VARCHAR2 Comments
100
HOOK_DEPTH VARCHAR2 Hook Depth
100
UNK_CODE VARCHAR2 Unknow Code
100
TDR VARCHAR2 Time Depth Recorder
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: 15592
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: 15591
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: 15590
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: 15589
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: 15588
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: 15587
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: 15586
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: 15585
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: 15584
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: 15583
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: 15582
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: 15581
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: 15580
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: 15579
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: 15578
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: 15577
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: 15576
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: 15575
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: 15574
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

SECTION

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

Section of the gear the animal was caught in

General Data Type: NUMBER

TREATMENT

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

Treatment the animal received

General Data Type: VARCHAR2

TIME_BOARDED

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

When the animal was boarded

General Data Type: DATE

HOOK_TIMER_ELAPSED_TIME

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

Hook Timer elapsed time

General Data Type: VARCHAR2

HOW_HOOKED

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

How the animal was hooked

General Data Type: VARCHAR2

ENTANGLED

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

Was it entangled?

General Data Type: VARCHAR2

COMMENTS

CC ID: 15567
Seq. Order: 26
Data Storage Type: VARCHAR2
Max Length: 2000
Required: No
Primary Key: No
Status: Active
Description:

Comments

General Data Type: VARCHAR2

HOOK_DEPTH

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

Hook Depth

General Data Type: VARCHAR2

UNK_CODE

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

Unknow Code

General Data Type: VARCHAR2

TDR

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

Time Depth Recorder

General Data Type: VARCHAR2

CREATED_BY_USER_ID

CC ID: 15563
Seq. Order: 30
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: 15562
Seq. Order: 31
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: 15561
Seq. Order: 32
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: 15560
Seq. Order: 33
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: 15559
Seq. Order: 34
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: 15558
Seq. Order: 35
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: 15557
Seq. Order: 36
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

Catalog Details

Catalog Item ID: 5324
GUID: gov.noaa.nmfs.inport:5324
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2007-10-12 05:01+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2021-05-06
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