Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
SEFSC Metadata Library > Fisheries Statistics Division > Observer Programs > Pelagic Longline Observer Program > PELAGIC OBSERVER PROGRAM (POP). Catch/Effort d... >

View: POP_ANIMAL_LOG_EXP_V

Entity (ENT)  |  Southeast Fisheries Science Center (SEFSC)
GUID: gov.noaa.nmfs.inport:5325  |  Updated: June 14, 2024  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

View Of Experimental Animal Logs.

Description

View Of Experimental Animal Logs.

Entity Information

Entity Type
Data View

Data Attribute / Type Description
TRIP_NUMBER
VARCHAR2 		TRIP_NUMBER
BEGIN_HAUL_DATE
DATE 		Date and Time of when haul began includes year, date, hours and minutes.
HAUL_NUMBER
NUMBER 		HAUL_NUMBER
CARCASS_TAG_NUMBER
VARCHAR2 		Number assigned by the sampler to the carcass of the fish.
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
ALPHA_SPECIES_CODE
VARCHAR2 		POP Spc. Code
HOW_HOOKED
VARCHAR2 		How the animal was hooked
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
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_MEASUREMENT_TAKEN_CODE
VARCHAR2 		Length Measurement Taken Code
DRESSED_WEIGHT
NUMBER 		Dressed weight of the fish landed. (should not be estimated)
SEX
VARCHAR2 		Can be: Undetermined, Male, Female
TAG_NUMBER
VARCHAR2 		Theoretically a link could be made to the CTS system here.
TAG_ACTION
VARCHAR2 		Coded item describing, what if anything happened with respect to the tagging of the fish.
HOOK_TIMER_ELAPSED_TIME
VARCHAR2 		Hook Timer elapsed time
ESTIMATED_WEIGHT
NUMBER 		In Pounds

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: View: POP_ANIMAL_LOG_EXP_V
Short Name: POP_ANIMAL_LOG_EXP_V
Status: Completed
Abstract:

View Of Experimental Animal Logs.
Notes:

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

Entity Information

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

View Of Experimental Animal Logs.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 TRIP_NUMBER VARCHAR2 TRIP_NUMBER
100
 BEGIN_HAUL_DATE DATE Date and Time of when haul began includes year, date, hours and minutes.
100
 HAUL_NUMBER NUMBER HAUL_NUMBER
100
 CARCASS_TAG_NUMBER VARCHAR2 Number assigned by the sampler to the carcass of the fish.
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
 ALPHA_SPECIES_CODE VARCHAR2 POP Spc. Code
100
 HOW_HOOKED VARCHAR2 How the animal was hooked
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
 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_MEASUREMENT_TAKEN_CODE VARCHAR2 Length Measurement Taken Code
100
 DRESSED_WEIGHT NUMBER Dressed weight of the fish landed. (should not be estimated)
100
 SEX VARCHAR2 Can be: Undetermined, Male, Female
100
 TAG_NUMBER VARCHAR2 Theoretically a link could be made to the CTS system here.
100
 TAG_ACTION VARCHAR2 Coded item describing, what if anything happened with respect to the tagging of the fish.
100
 HOOK_TIMER_ELAPSED_TIME VARCHAR2 Hook Timer elapsed time
100
 ESTIMATED_WEIGHT NUMBER In Pounds

Attribute Details

TRIP_NUMBER

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

TRIP_NUMBER
General Data Type: VARCHAR2

BEGIN_HAUL_DATE

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

Date and Time of when haul began includes year, date, hours and minutes.
General Data Type: DATE

HAUL_NUMBER

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

HAUL_NUMBER
General Data Type: NUMBER

CARCASS_TAG_NUMBER

CC ID: 15610
Seq. Order: 4
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

SECTION

CC ID: 15613
Seq. Order: 5
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: 15611
Seq. Order: 6
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: 15607
Seq. Order: 7
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

When the animal was boarded
General Data Type: DATE

ALPHA_SPECIES_CODE

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

POP Spc. Code
General Data Type: VARCHAR2

HOW_HOOKED

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

How the animal was hooked
General Data Type: VARCHAR2

BOARDING_STATUS

CC ID: 15595
Seq. Order: 10
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: 15614
Seq. Order: 11
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: 15597
Seq. Order: 12
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

LENGTH_MEASUREMENT_ONE

CC ID: 15593
Seq. Order: 13
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: 15606
Seq. Order: 14
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: 15594
Seq. Order: 15
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_MEASUREMENT_TAKEN_CODE

CC ID: 15605
Seq. Order: 16
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: 15609
Seq. Order: 17
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

SEX

CC ID: 15598
Seq. Order: 18
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_NUMBER

CC ID: 15604
Seq. Order: 19
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

TAG_ACTION

CC ID: 15596
Seq. Order: 20
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

HOOK_TIMER_ELAPSED_TIME

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

Hook Timer elapsed time
General Data Type: VARCHAR2

ESTIMATED_WEIGHT

CC ID: 15600
Seq. Order: 22
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

Catalog Details

Catalog Item ID: 5325
GUID: gov.noaa.nmfs.inport:5325
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