Slide Menu
InPort and its associated services will be under maintenance and unavailable for the deployment of InPort Release 5.2.3. Downtime Schedule Tuesday, November 29, 2022 12:00pm - 1:30pm Eastern / 10:00am - 11:30pm Pacific / 7:00am - 8:30pm Hawaii Impacted Areas - InPort Website: https://www.fisheries.noaa.gov/inport - InPort WAF: https://www.fisheries.noaa.gov/inportserve/waf What's...
View All
Search Help Show/Hide Menu

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