Table: POP_ANIMAL_LOG_EXP
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:5324 | Updated: August 9, 2022 | Published / External
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
|
|
Name | Type | Description |
|---|---|---|---|---|
|
100
|
|
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 |