View: FOURTH_INTERACTIONS_V
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:7100 | Updated: August 9, 2022 | Published / External
Item Identification
| Title: | View: FOURTH_INTERACTIONS_V |
|---|---|
| Short Name: | FOURTH_INTERACTIONS_V |
| Status: | Completed |
| Abstract: |
View Of Fourth Tagging Interaction |
| Notes: |
Loaded by batch 2083, 02-22-2008 12:10 |
Entity Information
| Entity Type: | Data View |
|---|---|
| Active Version?: | Yes |
| Schema Name: | CTSPAT |
| Description: |
View Of Fourth Tagging Interaction |
Data Attributes
Attribute Summary
|
|
Name | Type | Description |
|---|---|---|---|---|
|
100
|
ANIMAL_ID | NUMBER | Key to Identifies Animal | |
|
100
|
SPECIES | VARCHAR2 | Species Code Used In NMFS Tagging Program | |
|
100
|
SEX | VARCHAR2 | Code to indicate sex of the animal | |
|
100
|
AGENCY_ID | VARCHAR2 | Code to Indicate Tagging agency of identifying tag on animal (tag1) | |
|
100
|
TAG_ID | VARCHAR2 | Tagnumber | |
|
100
|
EVENT_ID | NUMBER | Code to identify tagging event | |
|
100
|
TAG_DATE | DATE | Date animal was released or recaptured. | |
|
100
|
NEXT_TAG_AGENCY | VARCHAR2 | Code For Agency That Issued the next tag (second tag) on this record | |
|
100
|
NEXT_TAG_ID | VARCHAR2 | Code to Indicate Tagging agency of identifying tag on animal (nexttag) | |
|
100
|
INTERACTION_ORDER | NUMBER | Number denoting the order of the interaction. | |
|
100
|
LENGTH | NUMBER | Length of animal tagged based on the lengthunit, lengthtype, and lengthdet. | |
|
100
|
LENGTH_UNIT | VARCHAR2 | Units for Length Measurement | |
|
100
|
LENGTH_TYPE | VARCHAR2 | Code to determine The Type Of Length MEasurement taken | |
|
100
|
LENGTH_DETERMINATION | VARCHAR2 | Code To Indicate How Length Was determined | |
|
100
|
WEIGHT | NUMBER | Weight of an animal tagged, based upon weightunit, weighttype and weightdet. | |
|
100
|
WEIGHT_UNIT | VARCHAR2 | Units for Weight Measurement | |
|
100
|
WEIGHT_TYPE | VARCHAR2 | Code For Type Of Weight Measurement | |
|
100
|
WEIGHT_DETERMINATION | VARCHAR2 | Code For How Weight Was Determined | |
|
100
|
LATITUDE | NUMBER | Numeric value for the latitude of the tagging location. | |
|
100
|
LONGITUDE | NUMBER | Numeric value the the longitude of the tagging location. | |
|
100
|
STAT_ZONE_ID | NUMBER | Code to indciate State Zone | |
|
100
|
COUNTRY_ID | VARCHAR2 | Cde to indicate Country | |
|
100
|
STATE_ID | VARCHAR2 | Code to indicate state | |
|
100
|
WATER_BODY_ID | NUMBER | Code to Indicate waterbody of where tagging took place | |
|
100
|
PLACE_ID | VARCHAR2 | Code to indicate place of wheer tagging took palce | |
|
100
|
GEAR_ID | VARCHAR2 | Code for gear used to catch the animal. | |
|
100
|
BAIT_TYPE | VARCHAR2 | Code for bait used: (A)rtificial, (L)ive, (D)ead, (U)nknown | |
|
100
|
METHOD_ID | NUMBER | Code To indicate tagging methodology Used | |
|
100
|
SAMPLE_ID | NUMBER | Code to indicate Sampling Methodology | |
|
100
|
CAPTAIN_AGENCY | VARCHAR2 | COde to indicate agency which assigned angler code for boat captain | |
|
100
|
CAPTAIN_ID | NUMBER | Unique numeric code assigned to an individual captain. Must be greater than zero or -99999. | |
|
100
|
TAGGER_INITIALS | VARCHAR2 | Initials Of Taggers | |
|
100
|
TAGGER_TYPE | VARCHAR2 | Indicates Type Of Tagger | |
|
100
|
TAGGER_AFFILIATION | VARCHAR2 | Code Of Agency that is affiliated With The Tagger | |
|
100
|
VESSEL_AGENCY | VARCHAR2 | Agency For Vessel COode | |
|
100
|
VESSEL_ID | NUMBER | Agency supplied code identifying the vessel involved in the release or recapture of the animal. | |
|
100
|
PHYSICAL_DATA_ID | NUMBER | Physical Data Identification Number | |
|
100
|
NOTES | NUMBER | Any Other Notes On Tagging | |
|
100
|
FIGHT_HOURS | NUMBER | Number Of Hours Spent FIghting/Landings Fish | |
|
100
|
FIGHT_MINUTES | NUMBER | Number Of Minutes (up to 59) spent FIghting/Landings Fish | |
|
100
|
ANGLER_AGENCY | VARCHAR2 | Agency That Has Angler Code list | |
|
100
|
ANGLER_ID | NUMBER | Unique identifier for each person in the database. | |
|
100
|
DATE_ENTERED | DATE | The date the data was entered. |
Attribute Details
ANIMAL_ID
CC ID: 26470
| Seq. Order: | 1 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | Yes |
| Primary Key: | No |
| Precision: | 10 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Key to Identifies Animal |
| General Data Type: | NUMBER |
SPECIES
CC ID: 26462
| Seq. Order: | 2 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Species Code Used In NMFS Tagging Program |
| General Data Type: | VARCHAR2 |
SEX
CC ID: 26448
| Seq. Order: | 3 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Code to indicate sex of the animal |
| General Data Type: | VARCHAR2 |
AGENCY_ID
CC ID: 26451
| Seq. Order: | 4 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Code to Indicate Tagging agency of identifying tag on animal (tag1) |
| General Data Type: | VARCHAR2 |
TAG_ID
CC ID: 26478
| Seq. Order: | 5 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 8 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Tagnumber |
| General Data Type: | VARCHAR2 |
EVENT_ID
CC ID: 26473
| Seq. Order: | 6 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | Yes |
| Primary Key: | No |
| Precision: | 2 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Code to identify tagging event |
| General Data Type: | NUMBER |
TAG_DATE
CC ID: 26438
| Seq. Order: | 7 |
|---|---|
| Data Storage Type: | DATE |
| Max Length: | 7 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Date animal was released or recaptured. |
| General Data Type: | DATE |
NEXT_TAG_AGENCY
CC ID: 26463
| Seq. Order: | 8 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Code For Agency That Issued the next tag (second tag) on this record |
| General Data Type: | VARCHAR2 |
NEXT_TAG_ID
CC ID: 26454
| Seq. Order: | 9 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 8 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Code to Indicate Tagging agency of identifying tag on animal (nexttag) |
| General Data Type: | VARCHAR2 |
INTERACTION_ORDER
CC ID: 26443
| Seq. Order: | 10 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | Yes |
| Primary Key: | No |
| Precision: | 2 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Number denoting the order of the interaction. |
| General Data Type: | NUMBER |
LENGTH
CC ID: 26456
| Seq. Order: | 11 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 4 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Length of animal tagged based on the lengthunit, lengthtype, and lengthdet. |
| General Data Type: | NUMBER |
LENGTH_UNIT
CC ID: 26446
| Seq. Order: | 12 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Units for Length Measurement |
| General Data Type: | VARCHAR2 |
LENGTH_TYPE
CC ID: 26440
| Seq. Order: | 13 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Code to determine The Type Of Length MEasurement taken |
| General Data Type: | VARCHAR2 |
LENGTH_DETERMINATION
CC ID: 26471
| Seq. Order: | 14 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Code To Indicate How Length Was determined |
| General Data Type: | VARCHAR2 |
WEIGHT
CC ID: 26452
| Seq. Order: | 15 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 6 |
| Scale: | 2 |
| Status: | Active |
| Description: |
Weight of an animal tagged, based upon weightunit, weighttype and weightdet. |
| General Data Type: | NUMBER |
WEIGHT_UNIT
CC ID: 26472
| Seq. Order: | 16 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Units for Weight Measurement |
| General Data Type: | VARCHAR2 |
WEIGHT_TYPE
CC ID: 26447
| Seq. Order: | 17 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Code For Type Of Weight Measurement |
| General Data Type: | VARCHAR2 |
WEIGHT_DETERMINATION
CC ID: 26468
| Seq. Order: | 18 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Code For How Weight Was Determined |
| General Data Type: | VARCHAR2 |
LATITUDE
CC ID: 26449
| Seq. Order: | 19 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 30 |
| Scale: | 16 |
| Status: | Active |
| Description: |
Numeric value for the latitude of the tagging location. |
| General Data Type: | NUMBER |
LONGITUDE
CC ID: 26464
| Seq. Order: | 20 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 30 |
| Scale: | 16 |
| Status: | Active |
| Description: |
Numeric value the the longitude of the tagging location. |
| General Data Type: | NUMBER |
STAT_ZONE_ID
CC ID: 26465
| Seq. Order: | 21 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 4 |
| Scale: | 1 |
| Status: | Active |
| Description: |
Code to indciate State Zone |
| General Data Type: | NUMBER |
COUNTRY_ID
CC ID: 26442
| Seq. Order: | 22 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Cde to indicate Country |
| General Data Type: | VARCHAR2 |
STATE_ID
CC ID: 26475
| Seq. Order: | 23 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Code to indicate state |
| General Data Type: | VARCHAR2 |
WATER_BODY_ID
CC ID: 26439
| Seq. Order: | 24 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 6 |
| Scale: | 3 |
| Status: | Active |
| Description: |
Code to Indicate waterbody of where tagging took place |
| General Data Type: | NUMBER |
PLACE_ID
CC ID: 26459
| Seq. Order: | 25 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Code to indicate place of wheer tagging took palce |
| General Data Type: | VARCHAR2 |
GEAR_ID
CC ID: 26474
| Seq. Order: | 26 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Code for gear used to catch the animal. |
| General Data Type: | VARCHAR2 |
BAIT_TYPE
CC ID: 26445
| Seq. Order: | 27 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Code for bait used: (A)rtificial, (L)ive, (D)ead, (U)nknown |
| General Data Type: | VARCHAR2 |
METHOD_ID
CC ID: 26450
| Seq. Order: | 28 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 6 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Code To indicate tagging methodology Used |
| General Data Type: | NUMBER |
SAMPLE_ID
CC ID: 26455
| Seq. Order: | 29 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 6 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Code to indicate Sampling Methodology |
| General Data Type: | NUMBER |
CAPTAIN_AGENCY
CC ID: 26476
| Seq. Order: | 30 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
COde to indicate agency which assigned angler code for boat captain |
| General Data Type: | VARCHAR2 |
CAPTAIN_ID
CC ID: 26453
| Seq. Order: | 31 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 6 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Unique numeric code assigned to an individual captain. Must be greater than zero or -99999. |
| General Data Type: | NUMBER |
TAGGER_INITIALS
CC ID: 26466
| Seq. Order: | 32 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Initials Of Taggers |
| General Data Type: | VARCHAR2 |
TAGGER_TYPE
CC ID: 26461
| Seq. Order: | 33 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Indicates Type Of Tagger |
| General Data Type: | VARCHAR2 |
TAGGER_AFFILIATION
CC ID: 26479
| Seq. Order: | 34 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Code Of Agency that is affiliated With The Tagger |
| General Data Type: | VARCHAR2 |
VESSEL_AGENCY
CC ID: 26460
| Seq. Order: | 35 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Agency For Vessel COode |
| General Data Type: | VARCHAR2 |
VESSEL_ID
CC ID: 26458
| Seq. Order: | 36 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 6 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Agency supplied code identifying the vessel involved in the release or recapture of the animal. |
| General Data Type: | NUMBER |
PHYSICAL_DATA_ID
CC ID: 26477
| Seq. Order: | 37 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 6 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Physical Data Identification Number |
| General Data Type: | NUMBER |
NOTES
CC ID: 26467
| Seq. Order: | 38 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 3 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Any Other Notes On Tagging |
| General Data Type: | NUMBER |
FIGHT_HOURS
CC ID: 26469
| Seq. Order: | 39 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 2 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Number Of Hours Spent FIghting/Landings Fish |
| General Data Type: | NUMBER |
FIGHT_MINUTES
CC ID: 26444
| Seq. Order: | 40 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 2 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Number Of Minutes (up to 59) spent FIghting/Landings Fish |
| General Data Type: | NUMBER |
ANGLER_AGENCY
CC ID: 26441
| Seq. Order: | 41 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Agency That Has Angler Code list |
| General Data Type: | VARCHAR2 |
ANGLER_ID
CC ID: 26480
| Seq. Order: | 42 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 6 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Unique identifier for each person in the database. |
| General Data Type: | NUMBER |
DATE_ENTERED
CC ID: 26457
| Seq. Order: | 43 |
|---|---|
| Data Storage Type: | DATE |
| Max Length: | 7 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
The date the data was entered. |
| General Data Type: | DATE |
Catalog Details
| Catalog Item ID: | 7100 |
|---|---|
| GUID: | gov.noaa.nmfs.inport:7100 |
| Metadata Record Created By: | Lee M Weinberger |
| Metadata Record Created: | 2008-02-22 12:11+0000 |
| Metadata Record Last Modified By: | SysAdmin InPortAdmin |
| Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
| Metadata Record Published: | 2021-05-05 |
| Owner Org: | SEFSC |
| Metadata Publication Status: | Published Externally |
| Do Not Publish?: | N |
| Metadata Last Review Date: | 2021-05-05 |
| Metadata Review Frequency: | 1 Year |
| Metadata Next Review Date: | 2022-05-05 |