View: FIFTH_INTERACTIONS_V
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:7098 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
View Of Fifth Tagging Interactions
DescriptionView Of Fifth Tagging Interactions
Entity Information
Entity Type
Data View
Data Attribute / Type | Description |
---|---|
ANIMAL_ID
NUMBER |
Key to Identifies Animal |
SPECIES
VARCHAR2 |
Species Code Used In NMFS Tagging Program |
SEX
VARCHAR2 |
Code to indicate sex of the animal |
AGENCY_ID
VARCHAR2 |
Code to Indicate Tagging agency of identifying tag on animal (tag1) |
TAG_ID
VARCHAR2 |
Tagnumber |
EVENT_ID
NUMBER |
Code to identify tagging event |
TAG_DATE
DATE |
Date animal was released or recaptured. |
NEXT_TAG_AGENCY
VARCHAR2 |
Code For Agency That Issued the next tag (second tag) on this record |
NEXT_TAG_ID
VARCHAR2 |
Code to Indicate Tagging agency of identifying tag on animal (nexttag) |
INTERACTION_ORDER
NUMBER |
Number denoting the order of the interaction. |
LENGTH
NUMBER |
Length of animal tagged based on the lengthunit, lengthtype, and lengthdet. |
LENGTH_UNIT
VARCHAR2 |
Units for Length Measurement |
LENGTH_TYPE
VARCHAR2 |
Code to determine The Type Of Length MEasurement taken |
LENGTH_DETERMINATION
VARCHAR2 |
Code To Indicate How Length Was determined |
WEIGHT
NUMBER |
Weight of an animal tagged, based upon weightunit, weighttype and weightdet. |
WEIGHT_UNIT
VARCHAR2 |
Units for Weight Measurement |
WEIGHT_TYPE
VARCHAR2 |
Code For Type Of Weight Measurement |
WEIGHT_DETERMINATION
VARCHAR2 |
Code For How Weight Was Determined |
LATITUDE
NUMBER |
Numeric value for the latitude of the tagging location. |
LONGITUDE
NUMBER |
Numeric value the the longitude of the tagging location. |
STAT_ZONE_ID
NUMBER |
Code to indciate State Zone |
COUNTRY_ID
VARCHAR2 |
Cde to indicate Country |
STATE_ID
VARCHAR2 |
Code to indicate state |
WATER_BODY_ID
NUMBER |
Code to Indicate waterbody of where tagging took place |
PLACE_ID
VARCHAR2 |
Code to indicate place of wheer tagging took palce |
GEAR_ID
VARCHAR2 |
Code for gear used to catch the animal. |
BAIT_TYPE
VARCHAR2 |
Code for bait used: (A)rtificial, (L)ive, (D)ead, (U)nknown |
METHOD_ID
NUMBER |
Code To indicate tagging methodology Used |
SAMPLE_ID
NUMBER |
Code to indicate Sampling Methodology |
CAPTAIN_AGENCY
VARCHAR2 |
COde to indicate agency which assigned angler code for boat captain |
CAPTAIN_ID
NUMBER |
Unique numeric code assigned to an individual captain. Must be greater than zero or -99999. |
TAGGER_INITIALS
VARCHAR2 |
Initials Of Taggers |
TAGGER_TYPE
VARCHAR2 |
Indicates Type Of Tagger |
TAGGER_AFFILIATION
VARCHAR2 |
Code Of Agency that is affiliated With The Tagger |
VESSEL_AGENCY
VARCHAR2 |
Agency For Vessel COode |
VESSEL_ID
NUMBER |
Agency supplied code identifying the vessel involved in the release or recapture of the animal. |
PHYSICAL_DATA_ID
NUMBER |
Physical Data Identification Number |
NOTES
NUMBER |
Any Other Notes On Tagging |
FIGHT_HOURS
NUMBER |
Number Of Hours Spent FIghting/Landings Fish |
FIGHT_MINUTES
NUMBER |
Number Of Minutes (up to 59) spent FIghting/Landings Fish |
ANGLER_AGENCY
VARCHAR2 |
Agency That Has Angler Code list |
ANGLER_ID
NUMBER |
Unique identifier for each person in the database. |
DATE_ENTERED
DATE |
The date the data was entered. |
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: FIFTH_INTERACTIONS_V |
---|---|
Short Name: | FIFTH_INTERACTIONS_V |
Status: | Completed |
Abstract: |
View Of Fifth Tagging Interactions |
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 Fifth Tagging Interactions |
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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: | 7098 |
---|---|
GUID: | gov.noaa.nmfs.inport:7098 |
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 |