Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: View: POP_ANIMAL_LOG_NON_EXP_V
Short Name: POP_ANIMAL_LOG_NON_EXP_V
Status: Completed
Abstract:

View Of Non 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 Non 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
ALPHA_SPECIES_CODE VARCHAR2 POP Spc. Code
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
ESTIMATED_WEIGHT NUMBER In Pounds

Attribute Details

TRIP_NUMBER

CC ID: 15621
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: 15631
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: 15629
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: 15622
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

ALPHA_SPECIES_CODE

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

POP Spc. Code

General Data Type: VARCHAR2

BOARDING_STATUS

CC ID: 15623
Seq. Order: 6
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: 15619
Seq. Order: 7
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: 15616
Seq. Order: 8
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: 15624
Seq. Order: 9
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: 15618
Seq. Order: 10
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: 15630
Seq. Order: 11
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: 15628
Seq. Order: 12
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: 15626
Seq. Order: 13
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: 15617
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_NUMBER

CC ID: 15625
Seq. Order: 15
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: 15627
Seq. Order: 16
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

ESTIMATED_WEIGHT

CC ID: 15620
Seq. Order: 17
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: 5326
GUID: gov.noaa.nmfs.inport:5326
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: 2021-05-06 22:24+0000
Metadata Record Published: 2021-05-06
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2022-05-07