View: ICCAT_V
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:7102 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
View Of Data That is used for ICCAT Report
DescriptionView Of Data That is used for ICCAT Report
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_1
VARCHAR2 |
Code to Indicate Tagging agency of identifying tag on animal (tag1) at first tagging interaction |
TAG_ID_1
VARCHAR2 |
Tagnumber at first tagging interaction |
EVENT_ID_1
NUMBER |
Code to Indicate Tagging Event at first tagging interaction |
TAG_DATE_1
VARCHAR2 |
Date animal was released or recaptured t first tagging interaction. |
NEXT_TAG_AGENCY_1
VARCHAR2 |
Code For Agency That Issued the next tag (second tag) on this record at first tagging interaction |
NEXT_TAG_ID_1
VARCHAR2 |
Code to Indicate Tagging agency of identifying tag on animal (nexttag) at first tagging interaction |
INTERACTION_ORDER_1
NUMBER |
Number denoting the order of the interaction at first tagging interaction. |
LENGTH_1
NUMBER |
Length of animal tagged based on the lengthunit, lengthtype, and lengthdet at first tagging interaction. |
LENGTH_UNIT_1
VARCHAR2 |
Units for Length Measurement at first tagging interaction. |
LENGTH_TYPE_1
VARCHAR2 |
Code to determine The Type Of Length Measurement taken at first tagging interaction. |
LENGTH_DETERMINATION_1
VARCHAR2 |
Code To Indicate How Length Was determined at first tagging interaction |
WEIGHT_1
NUMBER |
Weight of an animal tagged, based upon weightunit, weighttype and weightdet at first tagging interaction. |
WEIGHT_UNIT_1
VARCHAR2 |
Units for Weight Measurement t first tagging interaction. |
WEIGHT_TYPE_1
VARCHAR2 |
Code For Type Of Weight Measurement at first tagging interaction. |
WEIGHT_DETERMINATION_1
VARCHAR2 |
Code For How Weight Was Determined at first tagging interaction. |
LATITUDE_1
NUMBER |
Numeric value for the latitude of the tagging location at first tagging interaction. |
LONGITUDE_1
NUMBER |
Numeric value the the longitude of the tagging location at first tagging interaction. |
STAT_ZONE_ID_1
NUMBER |
Code to indciate State Zone at first tagging interaction |
COUNTRY_ID_1
VARCHAR2 |
Code to indicate Country at first tagging interaction |
STATE_ID_1
VARCHAR2 |
Code to indicate state at first tagging interaction |
WATER_BODY_ID_1
NUMBER |
Code to Indicate waterbody of where tagging took place at first tagging interaction |
PLACE_ID_1
VARCHAR2 |
Code to indicate place of wheer tagging took place at first tagging interaction |
GEAR_ID_1
VARCHAR2 |
Code for gear used to catch the animal at first tagging interaction. |
BAIT_TYPE_1
VARCHAR2 |
Code for bait used: (A)rtificial, (L)ive, (D)ead, (U)nknown at first tagging interaction. |
METHOD_ID_1
NUMBER |
Code To indicate tagging methodology Used at first tagging interaction |
SAMPLE_ID_1
NUMBER |
Code to indicate Sampling Methodology at first tagging interaction |
CAPTAIN_AGENCY_1
VARCHAR2 |
Code to indicate agency which assigned angler code for boat captain at first tagging interaction. |
CAPTAIN_ID_1
NUMBER |
Unique numeric code assigned to an individual captain. Must be greater than zero or -99999 at first tagging interaction. |
TAGGER_INITIALS_1
VARCHAR2 |
Initials Of Taggers at first tagging interaction. |
TAGGER_TYPE_1
VARCHAR2 |
Indicates Type Of Tagger at first tagging interaction. |
TAGGER_AFFILIATION_1
VARCHAR2 |
Code Of Agency that is affiliated With The Tagger at first tagging interaction. |
VESSEL_AGENCY_1
VARCHAR2 |
Agency For Vessel Code at first tagging interaction. |
VESSEL_ID_1
NUMBER |
Agency supplied code identifying the vessel involved in the release or recapture of the animal at first tagging interaction. |
PHYSICAL_DATA_ID_1
NUMBER |
Physical Data Identification Number at first tagging interaction |
NOTES_1
NUMBER |
Any Other Notes On Tagging at first tagging interaction |
FIGHT_HOURS_1
NUMBER |
Number Of Hours Spent FIghting/Landings Fish at first tagging interaction |
FIGHT_MINUTES_1
NUMBER |
Number Of Minutes (up to 59) spent FIghting/Landings Fish at first tagging interaction |
ANGLER_AGENCY_1
VARCHAR2 |
Agency That Has Angler Code list at first tagging interaction |
ANGLER_ID_1
NUMBER |
Angler Code at first tagging interaction . |
DATE_ENTERED_1
DATE |
The date the data was entered at first tagging interaction. |
AGENCY_ID_2
VARCHAR2 |
Code to Indicate Tagging agency of identifying tag on animal (tag1) at second tagging interaction |
TAG_ID_2
VARCHAR2 |
Tagnumber at second tagging interaction |
EVENT_ID_2
NUMBER |
Code to Indicate Tagging Event at second tagging interaction |
TAG_DATE_2
VARCHAR2 |
Date animal was released or recaptured t second tagging interaction. |
NEXT_TAG_AGENCY_2
VARCHAR2 |
Code For Agency That Issued the next tag (second tag) on this record at second tagging interaction |
NEXT_TAG_ID_2
VARCHAR2 |
Code to Indicate Tagging agency of identifying tag on animal (nexttag) at second tagging interaction |
INTERACTION_ORDER_2
NUMBER |
Number denoting the order of the interaction at second tagging interaction. |
LENGTH_2
NUMBER |
Length of animal tagged based on the lengthunit, lengthtype, and lengthdet at second tagging interaction. |
LENGTH_UNIT_2
VARCHAR2 |
Units for Length Measurement at second tagging interaction. |
LENGTH_TYPE_2
VARCHAR2 |
Code to determine The Type Of Length Measurement taken at second tagging interaction. |
LENGTH_DETERMINATION_2
VARCHAR2 |
Code To Indicate How Length Was determined at second tagging interaction |
WEIGHT_2
NUMBER |
Weight of an animal tagged, based upon weightunit, weighttype and weightdet at second tagging interaction. |
WEIGHT_UNIT_2
VARCHAR2 |
Units for Weight Measurement t second tagging interaction. |
WEIGHT_TYPE_2
VARCHAR2 |
Code For Type Of Weight Measurement at second tagging interaction. |
WEIGHT_DETERMINATION_2
VARCHAR2 |
Code For How Weight Was Determined at second tagging interaction. |
LATITUDE_2
NUMBER |
Numeric value for the latitude of the tagging location at second tagging interaction. |
LONGITUDE_2
NUMBER |
Numeric value the the longitude of the tagging location at second tagging interaction. |
STAT_ZONE_ID_2
NUMBER |
Code to indciate State Zone at second tagging interaction |
COUNTRY_ID_2
VARCHAR2 |
Code to indicate Country at second tagging interaction |
STATE_ID_2
VARCHAR2 |
Code to indicate state at second tagging interaction |
WATER_BODY_ID_2
NUMBER |
Code to Indicate waterbody of where tagging took place at second tagging interaction |
PLACE_ID_2
VARCHAR2 |
Code to indicate place of wheer tagging took place at second tagging interaction |
GEAR_ID_2
VARCHAR2 |
Code for gear used to catch the animal at second tagging interaction. |
BAIT_TYPE_2
VARCHAR2 |
Code for bait used: (A)rtificial, (L)ive, (D)ead, (U)nknown at second tagging interaction. |
METHOD_ID_2
NUMBER |
Code To indicate tagging methodology Used at second tagging interaction |
SAMPLE_ID_2
NUMBER |
Code to indicate Sampling Methodology at second tagging interaction |
CAPTAIN_AGENCY_2
VARCHAR2 |
Code to indicate agency which assigned angler code for boat captain at second tagging interaction. |
CAPTAIN_ID_2
NUMBER |
Unique numeric code assigned to an individual captain. Must be greater than zero or -99999 at second tagging interaction. |
TAGGER_INITIALS_2
VARCHAR2 |
Initials Of Taggers at second tagging interaction. |
TAGGER_TYPE_2
VARCHAR2 |
Indicates Type Of Tagger at second tagging interaction. |
TAGGER_AFFILIATION_2
VARCHAR2 |
Code Of Agency that is affiliated With The Tagger at second tagging interaction. |
VESSEL_AGENCY_2
VARCHAR2 |
Agency For Vessel Code at second tagging interaction. |
VESSEL_ID_2
NUMBER |
Agency supplied code identifying the vessel involved in the release or recapture of the animal at second tagging interaction. |
PHYSICAL_DATA_ID_2
NUMBER |
Physical Data Identification Number at second tagging interaction |
NOTES_2
NUMBER |
Any Other Notes On Tagging at second tagging interaction |
FIGHT_HOURS_2
NUMBER |
Number Of Hours Spent FIghting/Landings Fish at second tagging interaction |
FIGHT_MINUTES_2
NUMBER |
Number Of Minutes (up to 59) spent FIghting/Landings Fish at second tagging interaction |
ANGLER_AGENCY_2
VARCHAR2 |
Agency That Has Angler Code list at second tagging interaction |
ANGLER_ID_2
NUMBER |
Angler Code at second tagging interaction . |
DATE_ENTERED_2
DATE |
The date the data was entered at second tagging interaction. |
AGENCY_ID_3
VARCHAR2 |
Code to Indicate Tagging agency of identifying tag on animal (tag1) at third tagging interaction |
TAG_ID_3
VARCHAR2 |
Tagnumber at third tagging interaction |
EVENT_ID_3
NUMBER |
Code to Indicate Tagging Event at third tagging interaction |
TAG_DATE_3
VARCHAR2 |
Date animal was released or recaptured t third tagging interaction. |
NEXT_TAG_AGENCY_3
VARCHAR2 |
Code For Agency That Issued the next tag (third tag) on this record at third tagging interaction |
NEXT_TAG_ID_3
VARCHAR2 |
Code to Indicate Tagging agency of identifying tag on animal (nexttag) at third tagging interaction |
INTERACTION_ORDER_3
NUMBER |
Number denoting the order of the interaction at third tagging interaction. |
LENGTH_3
NUMBER |
Length of animal tagged based on the lengthunit, lengthtype, and lengthdet at third tagging interaction. |
LENGTH_UNIT_3
VARCHAR2 |
Units for Length Measurement at third tagging interaction. |
LENGTH_TYPE_3
VARCHAR2 |
Code to determine The Type Of Length Measurement taken at third tagging interaction. |
LENGTH_DETERMINATION_3
VARCHAR2 |
Code To Indicate How Length Was determined at third tagging interaction |
WEIGHT_3
NUMBER |
Weight of an animal tagged, based upon weightunit, weighttype and weightdet at third tagging interaction. |
WEIGHT_UNIT_3
VARCHAR2 |
Units for Weight Measurement t third tagging interaction. |
WEIGHT_TYPE_3
VARCHAR2 |
Code For Type Of Weight Measurement at third tagging interaction. |
WEIGHT_DETERMINATION_3
VARCHAR2 |
Code For How Weight Was Determined at third tagging interaction. |
LATITUDE_3
NUMBER |
Numeric value for the latitude of the tagging location at third tagging interaction. |
LONGITUDE_3
NUMBER |
Numeric value the the longitude of the tagging location at third tagging interaction. |
STAT_ZONE_ID_3
NUMBER |
Code to indciate State Zone at third tagging interaction |
COUNTRY_ID_3
VARCHAR2 |
Code to indicate Country at third tagging interaction |
STATE_ID_3
VARCHAR2 |
Code to indicate state at third tagging interaction |
WATER_BODY_ID_3
NUMBER |
Code to Indicate waterbody of where tagging took place at third tagging interaction |
PLACE_ID_3
VARCHAR2 |
Code to indicate place of wheer tagging took place at third tagging interaction |
GEAR_ID_3
VARCHAR2 |
Code for gear used to catch the animal at third tagging interaction. |
BAIT_TYPE_3
VARCHAR2 |
Code for bait used: (A)rtificial, (L)ive, (D)ead, (U)nknown at third tagging interaction. |
METHOD_ID_3
NUMBER |
Code To indicate tagging methodology Used at third tagging interaction |
SAMPLE_ID_3
NUMBER |
Code to indicate Sampling Methodology at third tagging interaction |
CAPTAIN_AGENCY_3
VARCHAR2 |
Code to indicate agency which assigned angler code for boat captain at third tagging interaction. |
CAPTAIN_ID_3
NUMBER |
Unique numeric code assigned to an individual captain. Must be greater than zero or -99999 at third tagging interaction. |
TAGGER_INITIALS_3
VARCHAR2 |
Initials Of Taggers at third tagging interaction. |
TAGGER_TYPE_3
VARCHAR2 |
Indicates Type Of Tagger at third tagging interaction. |
TAGGER_AFFILIATION_3
VARCHAR2 |
Code Of Agency that is affiliated With The Tagger at third tagging interaction. |
VESSEL_AGENCY_3
VARCHAR2 |
Agency For Vessel Code at third tagging interaction. |
VESSEL_ID_3
NUMBER |
Agency supplied code identifying the vessel involved in the release or recapture of the animal at third tagging interaction. |
PHYSICAL_DATA_ID_3
NUMBER |
Physical Data Identification Number at third tagging interaction |
NOTES_3
NUMBER |
Any Other Notes On Tagging at third tagging interaction |
FIGHT_HOURS_3
NUMBER |
Number Of Hours Spent FIghting/Landings Fish at third tagging interaction |
FIGHT_MINUTES_3
NUMBER |
Number Of Minutes (up to 59) spent FIghting/Landings Fish at third tagging interaction |
ANGLER_AGENCY_3
VARCHAR2 |
Agency That Has Angler Code list at third tagging interaction |
ANGLER_ID_3
NUMBER |
Angler Code at third tagging interaction . |
DATE_ENTERED_3
DATE |
The date the data was entered at third tagging interaction. |
AGENCY_ID_4
VARCHAR2 |
Code to Indicate Tagging agency of identifying tag on animal (tag1) at fourth tagging interaction |
TAG_ID_4
VARCHAR2 |
Tagnumber at fourth tagging interaction |
EVENT_ID_4
NUMBER |
Code to Indicate Tagging Event at fourth tagging interaction |
TAG_DATE_4
VARCHAR2 |
Date animal was released or recaptured t fourth tagging interaction. |
NEXT_TAG_AGENCY_4
VARCHAR2 |
Code For Agency That Issued the next tag (fourth tag) on this record at fourth tagging interaction |
NEXT_TAG_ID_4
VARCHAR2 |
Code to Indicate Tagging agency of identifying tag on animal (nexttag) at fourth tagging interaction |
INTERACTION_ORDER_4
NUMBER |
Number denoting the order of the interaction at fourth tagging interaction. |
LENGTH_4
NUMBER |
Length of animal tagged based on the lengthunit, lengthtype, and lengthdet at fourth tagging interaction. |
LENGTH_UNIT_4
VARCHAR2 |
Units for Length Measurement at fourth tagging interaction. |
LENGTH_TYPE_4
VARCHAR2 |
Code to determine The Type Of Length Measurement taken at fourth tagging interaction. |
LENGTH_DETERMINATION_4
VARCHAR2 |
Code To Indicate How Length Was determined at fourth tagging interaction |
WEIGHT_4
NUMBER |
Weight of an animal tagged, based upon weightunit, weighttype and weightdet at fourth tagging interaction. |
WEIGHT_UNIT_4
VARCHAR2 |
Units for Weight Measurement t fourth tagging interaction. |
WEIGHT_TYPE_4
VARCHAR2 |
Code For Type Of Weight Measurement at fourth tagging interaction. |
WEIGHT_DETERMINATION_4
VARCHAR2 |
Code For How Weight Was Determined at fourth tagging interaction. |
LATITUDE_4
NUMBER |
Numeric value for the latitude of the tagging location at fourth tagging interaction. |
LONGITUDE_4
NUMBER |
Numeric value the the longitude of the tagging location at fourth tagging interaction. |
STAT_ZONE_ID_4
NUMBER |
Code to indciate State Zone at fourth tagging interaction |
COUNTRY_ID_4
VARCHAR2 |
Code to indicate Country at fourth tagging interaction |
STATE_ID_4
VARCHAR2 |
Code to indicate state at fourth tagging interaction |
WATER_BODY_ID_4
NUMBER |
Code to Indicate waterbody of where tagging took place at fourth tagging interaction |
PLACE_ID_4
VARCHAR2 |
Code to indicate place of wheer tagging took place at fourth tagging interaction |
GEAR_ID_4
VARCHAR2 |
Code for gear used to catch the animal at fourth tagging interaction. |
BAIT_TYPE_4
VARCHAR2 |
Code for bait used: (A)rtificial, (L)ive, (D)ead, (U)nknown at fourth tagging interaction. |
METHOD_ID_4
NUMBER |
Code To indicate tagging methodology Used at fourth tagging interaction |
SAMPLE_ID_4
NUMBER |
Code to indicate Sampling Methodology at fourth tagging interaction |
CAPTAIN_AGENCY_4
VARCHAR2 |
Code to indicate agency which assigned angler code for boat captain at fourth tagging interaction. |
CAPTAIN_ID_4
NUMBER |
Unique numeric code assigned to an individual captain. Must be greater than zero or -99999 at fourth tagging interaction. |
TAGGER_INITIALS_4
VARCHAR2 |
Initials Of Taggers at fourth tagging interaction. |
TAGGER_TYPE_4
VARCHAR2 |
Indicates Type Of Tagger at fourth tagging interaction. |
TAGGER_AFFILIATION_4
VARCHAR2 |
Code Of Agency that is affiliated With The Tagger at fourth tagging interaction. |
VESSEL_AGENCY_4
VARCHAR2 |
Agency For Vessel Code at fourth tagging interaction. |
VESSEL_ID_4
NUMBER |
Agency supplied code identifying the vessel involved in the release or recapture of the animal at fourth tagging interaction. |
PHYSICAL_DATA_ID_4
NUMBER |
Physical Data Identification Number at fourth tagging interaction |
NOTES_4
NUMBER |
Any Other Notes On Tagging at fourth tagging interaction |
FIGHT_HOURS_4
NUMBER |
Number Of Hours Spent FIghting/Landings Fish at fourth tagging interaction |
FIGHT_MINUTES_4
NUMBER |
Number Of Minutes (up to 59) spent FIghting/Landings Fish at fourth tagging interaction |
ANGLER_AGENCY_4
VARCHAR2 |
Agency That Has Angler Code list at fourth tagging interaction |
ANGLER_ID_4
NUMBER |
Angler Code at fourth tagging interaction . |
DATE_ENTERED_4
DATE |
The date the data was entered at fourth tagging interaction. |
AGENCY_ID_5
VARCHAR2 |
Code to Indicate Tagging agency of identifying tag on animal (tag1) at fifth tagging interaction |
TAG_ID_5
VARCHAR2 |
Tagnumber at fifth tagging interaction |
EVENT_ID_5
NUMBER |
Code to Indicate Tagging Event at fifth tagging interaction |
TAG_DATE_5
VARCHAR2 |
Date animal was released or recaptured t fifth tagging interaction. |
NEXT_TAG_AGENCY_5
VARCHAR2 |
Code For Agency That Issued the next tag (fifth tag) on this record at fifth tagging interaction |
NEXT_TAG_ID_5
VARCHAR2 |
Code to Indicate Tagging agency of identifying tag on animal (nexttag) at fifth tagging interaction |
INTERACTION_ORDER_5
NUMBER |
Number denoting the order of the interaction at fifth tagging interaction. |
LENGTH_5
NUMBER |
Length of animal tagged based on the lengthunit, lengthtype, and lengthdet at fifth tagging interaction. |
LENGTH_UNIT_5
VARCHAR2 |
Units for Length Measurement at fifth tagging interaction. |
LENGTH_TYPE_5
VARCHAR2 |
Code to determine The Type Of Length Measurement taken at fifth tagging interaction. |
LENGTH_DETERMINATION_5
VARCHAR2 |
Code To Indicate How Length Was determined at fifth tagging interaction |
WEIGHT_5
NUMBER |
Weight of an animal tagged, based upon weightunit, weighttype and weightdet at fifth tagging interaction. |
WEIGHT_UNIT_5
VARCHAR2 |
Units for Weight Measurement t fifth tagging interaction. |
WEIGHT_TYPE_5
VARCHAR2 |
Code For Type Of Weight Measurement at fifth tagging interaction. |
WEIGHT_DETERMINATION_5
VARCHAR2 |
Code For How Weight Was Determined at fifth tagging interaction. |
LATITUDE_5
NUMBER |
Numeric value for the latitude of the tagging location at fifth tagging interaction. |
LONGITUDE_5
NUMBER |
Numeric value the the longitude of the tagging location at fifth tagging interaction. |
STAT_ZONE_ID_5
NUMBER |
Code to indciate State Zone at fifth tagging interaction |
COUNTRY_ID_5
VARCHAR2 |
Code to indicate Country at fifth tagging interaction |
STATE_ID_5
VARCHAR2 |
Code to indicate state at fifth tagging interaction |
WATER_BODY_ID_5
NUMBER |
Code to Indicate waterbody of where tagging took place at fifth tagging interaction |
PLACE_ID_5
VARCHAR2 |
Code to indicate place of wheer tagging took place at fifth tagging interaction |
GEAR_ID_5
VARCHAR2 |
Code for gear used to catch the animal at fifth tagging interaction. |
BAIT_TYPE_5
VARCHAR2 |
Code for bait used: (A)rtificial, (L)ive, (D)ead, (U)nknown at fifth tagging interaction. |
METHOD_ID_5
NUMBER |
Code To indicate tagging methodology Used at fifth tagging interaction |
SAMPLE_ID_5
NUMBER |
Code to indicate Sampling Methodology at fifth tagging interaction |
CAPTAIN_AGENCY_5
VARCHAR2 |
Code to indicate agency which assigned angler code for boat captain at fifth tagging interaction. |
CAPTAIN_ID_5
NUMBER |
Unique numeric code assigned to an individual captain. Must be greater than zero or -99999 at fifth tagging interaction. |
TAGGER_INITIALS_5
VARCHAR2 |
Initials Of Taggers at fifth tagging interaction. |
TAGGER_TYPE_5
VARCHAR2 |
Indicates Type Of Tagger at fifth tagging interaction. |
TAGGER_AFFILIATION_5
VARCHAR2 |
Code Of Agency that is affiliated With The Tagger at fifth tagging interaction. |
VESSEL_AGENCY_5
VARCHAR2 |
Agency For Vessel Code at fifth tagging interaction. |
VESSEL_ID_5
NUMBER |
Agency supplied code identifying the vessel involved in the release or recapture of the animal at fifth tagging interaction. |
PHYSICAL_DATA_ID_5
NUMBER |
Physical Data Identification Number at fifth tagging interaction |
NOTES_5
NUMBER |
Any Other Notes On Tagging at fifth tagging interaction |
FIGHT_HOURS_5
NUMBER |
Number Of Hours Spent FIghting/Landings Fish at fifth tagging interaction |
FIGHT_MINUTES_5
NUMBER |
Number Of Minutes (up to 59) spent FIghting/Landings Fish at fifth tagging interaction |
ANGLER_AGENCY_5
VARCHAR2 |
Agency That Has Angler Code list at fifth tagging interaction |
ANGLER_ID_5
NUMBER |
Angler Code at fifth tagging interaction . |
DATE_ENTERED_5
DATE |
The date the data was entered at fifth tagging interaction. |
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: ICCAT_V |
---|---|
Short Name: | ICCAT_V |
Status: | Completed |
Abstract: |
View Of Data That is used for ICCAT Report |
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 Data That is used for ICCAT Report |
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_1 | VARCHAR2 | Code to Indicate Tagging agency of identifying tag on animal (tag1) at first tagging interaction | |
100
|
TAG_ID_1 | VARCHAR2 | Tagnumber at first tagging interaction | |
100
|
EVENT_ID_1 | NUMBER | Code to Indicate Tagging Event at first tagging interaction | |
100
|
TAG_DATE_1 | VARCHAR2 | Date animal was released or recaptured t first tagging interaction. | |
100
|
NEXT_TAG_AGENCY_1 | VARCHAR2 | Code For Agency That Issued the next tag (second tag) on this record at first tagging interaction | |
100
|
NEXT_TAG_ID_1 | VARCHAR2 | Code to Indicate Tagging agency of identifying tag on animal (nexttag) at first tagging interaction | |
100
|
INTERACTION_ORDER_1 | NUMBER | Number denoting the order of the interaction at first tagging interaction. | |
100
|
LENGTH_1 | NUMBER | Length of animal tagged based on the lengthunit, lengthtype, and lengthdet at first tagging interaction. | |
100
|
LENGTH_UNIT_1 | VARCHAR2 | Units for Length Measurement at first tagging interaction. | |
100
|
LENGTH_TYPE_1 | VARCHAR2 | Code to determine The Type Of Length Measurement taken at first tagging interaction. | |
100
|
LENGTH_DETERMINATION_1 | VARCHAR2 | Code To Indicate How Length Was determined at first tagging interaction | |
100
|
WEIGHT_1 | NUMBER | Weight of an animal tagged, based upon weightunit, weighttype and weightdet at first tagging interaction. | |
100
|
WEIGHT_UNIT_1 | VARCHAR2 | Units for Weight Measurement t first tagging interaction. | |
100
|
WEIGHT_TYPE_1 | VARCHAR2 | Code For Type Of Weight Measurement at first tagging interaction. | |
100
|
WEIGHT_DETERMINATION_1 | VARCHAR2 | Code For How Weight Was Determined at first tagging interaction. | |
100
|
LATITUDE_1 | NUMBER | Numeric value for the latitude of the tagging location at first tagging interaction. | |
100
|
LONGITUDE_1 | NUMBER | Numeric value the the longitude of the tagging location at first tagging interaction. | |
100
|
STAT_ZONE_ID_1 | NUMBER | Code to indciate State Zone at first tagging interaction | |
100
|
COUNTRY_ID_1 | VARCHAR2 | Code to indicate Country at first tagging interaction | |
100
|
STATE_ID_1 | VARCHAR2 | Code to indicate state at first tagging interaction | |
100
|
WATER_BODY_ID_1 | NUMBER | Code to Indicate waterbody of where tagging took place at first tagging interaction | |
100
|
PLACE_ID_1 | VARCHAR2 | Code to indicate place of wheer tagging took place at first tagging interaction | |
100
|
GEAR_ID_1 | VARCHAR2 | Code for gear used to catch the animal at first tagging interaction. | |
100
|
BAIT_TYPE_1 | VARCHAR2 | Code for bait used: (A)rtificial, (L)ive, (D)ead, (U)nknown at first tagging interaction. | |
100
|
METHOD_ID_1 | NUMBER | Code To indicate tagging methodology Used at first tagging interaction | |
100
|
SAMPLE_ID_1 | NUMBER | Code to indicate Sampling Methodology at first tagging interaction | |
100
|
CAPTAIN_AGENCY_1 | VARCHAR2 | Code to indicate agency which assigned angler code for boat captain at first tagging interaction. | |
100
|
CAPTAIN_ID_1 | NUMBER | Unique numeric code assigned to an individual captain. Must be greater than zero or -99999 at first tagging interaction. | |
100
|
TAGGER_INITIALS_1 | VARCHAR2 | Initials Of Taggers at first tagging interaction. | |
100
|
TAGGER_TYPE_1 | VARCHAR2 | Indicates Type Of Tagger at first tagging interaction. | |
100
|
TAGGER_AFFILIATION_1 | VARCHAR2 | Code Of Agency that is affiliated With The Tagger at first tagging interaction. | |
100
|
VESSEL_AGENCY_1 | VARCHAR2 | Agency For Vessel Code at first tagging interaction. | |
100
|
VESSEL_ID_1 | NUMBER | Agency supplied code identifying the vessel involved in the release or recapture of the animal at first tagging interaction. | |
100
|
PHYSICAL_DATA_ID_1 | NUMBER | Physical Data Identification Number at first tagging interaction | |
100
|
NOTES_1 | NUMBER | Any Other Notes On Tagging at first tagging interaction | |
100
|
FIGHT_HOURS_1 | NUMBER | Number Of Hours Spent FIghting/Landings Fish at first tagging interaction | |
100
|
FIGHT_MINUTES_1 | NUMBER | Number Of Minutes (up to 59) spent FIghting/Landings Fish at first tagging interaction | |
100
|
ANGLER_AGENCY_1 | VARCHAR2 | Agency That Has Angler Code list at first tagging interaction | |
100
|
ANGLER_ID_1 | NUMBER | Angler Code at first tagging interaction . | |
100
|
DATE_ENTERED_1 | DATE | The date the data was entered at first tagging interaction. | |
100
|
AGENCY_ID_2 | VARCHAR2 | Code to Indicate Tagging agency of identifying tag on animal (tag1) at second tagging interaction | |
100
|
TAG_ID_2 | VARCHAR2 | Tagnumber at second tagging interaction | |
100
|
EVENT_ID_2 | NUMBER | Code to Indicate Tagging Event at second tagging interaction | |
100
|
TAG_DATE_2 | VARCHAR2 | Date animal was released or recaptured t second tagging interaction. | |
100
|
NEXT_TAG_AGENCY_2 | VARCHAR2 | Code For Agency That Issued the next tag (second tag) on this record at second tagging interaction | |
100
|
NEXT_TAG_ID_2 | VARCHAR2 | Code to Indicate Tagging agency of identifying tag on animal (nexttag) at second tagging interaction | |
100
|
INTERACTION_ORDER_2 | NUMBER | Number denoting the order of the interaction at second tagging interaction. | |
100
|
LENGTH_2 | NUMBER | Length of animal tagged based on the lengthunit, lengthtype, and lengthdet at second tagging interaction. | |
100
|
LENGTH_UNIT_2 | VARCHAR2 | Units for Length Measurement at second tagging interaction. | |
100
|
LENGTH_TYPE_2 | VARCHAR2 | Code to determine The Type Of Length Measurement taken at second tagging interaction. | |
100
|
LENGTH_DETERMINATION_2 | VARCHAR2 | Code To Indicate How Length Was determined at second tagging interaction | |
100
|
WEIGHT_2 | NUMBER | Weight of an animal tagged, based upon weightunit, weighttype and weightdet at second tagging interaction. | |
100
|
WEIGHT_UNIT_2 | VARCHAR2 | Units for Weight Measurement t second tagging interaction. | |
100
|
WEIGHT_TYPE_2 | VARCHAR2 | Code For Type Of Weight Measurement at second tagging interaction. | |
100
|
WEIGHT_DETERMINATION_2 | VARCHAR2 | Code For How Weight Was Determined at second tagging interaction. | |
100
|
LATITUDE_2 | NUMBER | Numeric value for the latitude of the tagging location at second tagging interaction. | |
100
|
LONGITUDE_2 | NUMBER | Numeric value the the longitude of the tagging location at second tagging interaction. | |
100
|
STAT_ZONE_ID_2 | NUMBER | Code to indciate State Zone at second tagging interaction | |
100
|
COUNTRY_ID_2 | VARCHAR2 | Code to indicate Country at second tagging interaction | |
100
|
STATE_ID_2 | VARCHAR2 | Code to indicate state at second tagging interaction | |
100
|
WATER_BODY_ID_2 | NUMBER | Code to Indicate waterbody of where tagging took place at second tagging interaction | |
100
|
PLACE_ID_2 | VARCHAR2 | Code to indicate place of wheer tagging took place at second tagging interaction | |
100
|
GEAR_ID_2 | VARCHAR2 | Code for gear used to catch the animal at second tagging interaction. | |
100
|
BAIT_TYPE_2 | VARCHAR2 | Code for bait used: (A)rtificial, (L)ive, (D)ead, (U)nknown at second tagging interaction. | |
100
|
METHOD_ID_2 | NUMBER | Code To indicate tagging methodology Used at second tagging interaction | |
100
|
SAMPLE_ID_2 | NUMBER | Code to indicate Sampling Methodology at second tagging interaction | |
100
|
CAPTAIN_AGENCY_2 | VARCHAR2 | Code to indicate agency which assigned angler code for boat captain at second tagging interaction. | |
100
|
CAPTAIN_ID_2 | NUMBER | Unique numeric code assigned to an individual captain. Must be greater than zero or -99999 at second tagging interaction. | |
100
|
TAGGER_INITIALS_2 | VARCHAR2 | Initials Of Taggers at second tagging interaction. | |
100
|
TAGGER_TYPE_2 | VARCHAR2 | Indicates Type Of Tagger at second tagging interaction. | |
100
|
TAGGER_AFFILIATION_2 | VARCHAR2 | Code Of Agency that is affiliated With The Tagger at second tagging interaction. | |
100
|
VESSEL_AGENCY_2 | VARCHAR2 | Agency For Vessel Code at second tagging interaction. | |
100
|
VESSEL_ID_2 | NUMBER | Agency supplied code identifying the vessel involved in the release or recapture of the animal at second tagging interaction. | |
100
|
PHYSICAL_DATA_ID_2 | NUMBER | Physical Data Identification Number at second tagging interaction | |
100
|
NOTES_2 | NUMBER | Any Other Notes On Tagging at second tagging interaction | |
100
|
FIGHT_HOURS_2 | NUMBER | Number Of Hours Spent FIghting/Landings Fish at second tagging interaction | |
100
|
FIGHT_MINUTES_2 | NUMBER | Number Of Minutes (up to 59) spent FIghting/Landings Fish at second tagging interaction | |
100
|
ANGLER_AGENCY_2 | VARCHAR2 | Agency That Has Angler Code list at second tagging interaction | |
100
|
ANGLER_ID_2 | NUMBER | Angler Code at second tagging interaction . | |
100
|
DATE_ENTERED_2 | DATE | The date the data was entered at second tagging interaction. | |
100
|
AGENCY_ID_3 | VARCHAR2 | Code to Indicate Tagging agency of identifying tag on animal (tag1) at third tagging interaction | |
100
|
TAG_ID_3 | VARCHAR2 | Tagnumber at third tagging interaction | |
100
|
EVENT_ID_3 | NUMBER | Code to Indicate Tagging Event at third tagging interaction | |
100
|
TAG_DATE_3 | VARCHAR2 | Date animal was released or recaptured t third tagging interaction. | |
100
|
NEXT_TAG_AGENCY_3 | VARCHAR2 | Code For Agency That Issued the next tag (third tag) on this record at third tagging interaction | |
100
|
NEXT_TAG_ID_3 | VARCHAR2 | Code to Indicate Tagging agency of identifying tag on animal (nexttag) at third tagging interaction | |
100
|
INTERACTION_ORDER_3 | NUMBER | Number denoting the order of the interaction at third tagging interaction. | |
100
|
LENGTH_3 | NUMBER | Length of animal tagged based on the lengthunit, lengthtype, and lengthdet at third tagging interaction. | |
100
|
LENGTH_UNIT_3 | VARCHAR2 | Units for Length Measurement at third tagging interaction. | |
100
|
LENGTH_TYPE_3 | VARCHAR2 | Code to determine The Type Of Length Measurement taken at third tagging interaction. | |
100
|
LENGTH_DETERMINATION_3 | VARCHAR2 | Code To Indicate How Length Was determined at third tagging interaction | |
100
|
WEIGHT_3 | NUMBER | Weight of an animal tagged, based upon weightunit, weighttype and weightdet at third tagging interaction. | |
100
|
WEIGHT_UNIT_3 | VARCHAR2 | Units for Weight Measurement t third tagging interaction. | |
100
|
WEIGHT_TYPE_3 | VARCHAR2 | Code For Type Of Weight Measurement at third tagging interaction. | |
100
|
WEIGHT_DETERMINATION_3 | VARCHAR2 | Code For How Weight Was Determined at third tagging interaction. | |
100
|
LATITUDE_3 | NUMBER | Numeric value for the latitude of the tagging location at third tagging interaction. | |
100
|
LONGITUDE_3 | NUMBER | Numeric value the the longitude of the tagging location at third tagging interaction. | |
100
|
STAT_ZONE_ID_3 | NUMBER | Code to indciate State Zone at third tagging interaction | |
100
|
COUNTRY_ID_3 | VARCHAR2 | Code to indicate Country at third tagging interaction | |
100
|
STATE_ID_3 | VARCHAR2 | Code to indicate state at third tagging interaction | |
100
|
WATER_BODY_ID_3 | NUMBER | Code to Indicate waterbody of where tagging took place at third tagging interaction | |
100
|
PLACE_ID_3 | VARCHAR2 | Code to indicate place of wheer tagging took place at third tagging interaction | |
100
|
GEAR_ID_3 | VARCHAR2 | Code for gear used to catch the animal at third tagging interaction. | |
100
|
BAIT_TYPE_3 | VARCHAR2 | Code for bait used: (A)rtificial, (L)ive, (D)ead, (U)nknown at third tagging interaction. | |
100
|
METHOD_ID_3 | NUMBER | Code To indicate tagging methodology Used at third tagging interaction | |
100
|
SAMPLE_ID_3 | NUMBER | Code to indicate Sampling Methodology at third tagging interaction | |
100
|
CAPTAIN_AGENCY_3 | VARCHAR2 | Code to indicate agency which assigned angler code for boat captain at third tagging interaction. | |
100
|
CAPTAIN_ID_3 | NUMBER | Unique numeric code assigned to an individual captain. Must be greater than zero or -99999 at third tagging interaction. | |
100
|
TAGGER_INITIALS_3 | VARCHAR2 | Initials Of Taggers at third tagging interaction. | |
100
|
TAGGER_TYPE_3 | VARCHAR2 | Indicates Type Of Tagger at third tagging interaction. | |
100
|
TAGGER_AFFILIATION_3 | VARCHAR2 | Code Of Agency that is affiliated With The Tagger at third tagging interaction. | |
100
|
VESSEL_AGENCY_3 | VARCHAR2 | Agency For Vessel Code at third tagging interaction. | |
100
|
VESSEL_ID_3 | NUMBER | Agency supplied code identifying the vessel involved in the release or recapture of the animal at third tagging interaction. | |
100
|
PHYSICAL_DATA_ID_3 | NUMBER | Physical Data Identification Number at third tagging interaction | |
100
|
NOTES_3 | NUMBER | Any Other Notes On Tagging at third tagging interaction | |
100
|
FIGHT_HOURS_3 | NUMBER | Number Of Hours Spent FIghting/Landings Fish at third tagging interaction | |
100
|
FIGHT_MINUTES_3 | NUMBER | Number Of Minutes (up to 59) spent FIghting/Landings Fish at third tagging interaction | |
100
|
ANGLER_AGENCY_3 | VARCHAR2 | Agency That Has Angler Code list at third tagging interaction | |
100
|
ANGLER_ID_3 | NUMBER | Angler Code at third tagging interaction . | |
100
|
DATE_ENTERED_3 | DATE | The date the data was entered at third tagging interaction. | |
100
|
AGENCY_ID_4 | VARCHAR2 | Code to Indicate Tagging agency of identifying tag on animal (tag1) at fourth tagging interaction | |
100
|
TAG_ID_4 | VARCHAR2 | Tagnumber at fourth tagging interaction | |
100
|
EVENT_ID_4 | NUMBER | Code to Indicate Tagging Event at fourth tagging interaction | |
100
|
TAG_DATE_4 | VARCHAR2 | Date animal was released or recaptured t fourth tagging interaction. | |
100
|
NEXT_TAG_AGENCY_4 | VARCHAR2 | Code For Agency That Issued the next tag (fourth tag) on this record at fourth tagging interaction | |
100
|
NEXT_TAG_ID_4 | VARCHAR2 | Code to Indicate Tagging agency of identifying tag on animal (nexttag) at fourth tagging interaction | |
100
|
INTERACTION_ORDER_4 | NUMBER | Number denoting the order of the interaction at fourth tagging interaction. | |
100
|
LENGTH_4 | NUMBER | Length of animal tagged based on the lengthunit, lengthtype, and lengthdet at fourth tagging interaction. | |
100
|
LENGTH_UNIT_4 | VARCHAR2 | Units for Length Measurement at fourth tagging interaction. | |
100
|
LENGTH_TYPE_4 | VARCHAR2 | Code to determine The Type Of Length Measurement taken at fourth tagging interaction. | |
100
|
LENGTH_DETERMINATION_4 | VARCHAR2 | Code To Indicate How Length Was determined at fourth tagging interaction | |
100
|
WEIGHT_4 | NUMBER | Weight of an animal tagged, based upon weightunit, weighttype and weightdet at fourth tagging interaction. | |
100
|
WEIGHT_UNIT_4 | VARCHAR2 | Units for Weight Measurement t fourth tagging interaction. | |
100
|
WEIGHT_TYPE_4 | VARCHAR2 | Code For Type Of Weight Measurement at fourth tagging interaction. | |
100
|
WEIGHT_DETERMINATION_4 | VARCHAR2 | Code For How Weight Was Determined at fourth tagging interaction. | |
100
|
LATITUDE_4 | NUMBER | Numeric value for the latitude of the tagging location at fourth tagging interaction. | |
100
|
LONGITUDE_4 | NUMBER | Numeric value the the longitude of the tagging location at fourth tagging interaction. | |
100
|
STAT_ZONE_ID_4 | NUMBER | Code to indciate State Zone at fourth tagging interaction | |
100
|
COUNTRY_ID_4 | VARCHAR2 | Code to indicate Country at fourth tagging interaction | |
100
|
STATE_ID_4 | VARCHAR2 | Code to indicate state at fourth tagging interaction | |
100
|
WATER_BODY_ID_4 | NUMBER | Code to Indicate waterbody of where tagging took place at fourth tagging interaction | |
100
|
PLACE_ID_4 | VARCHAR2 | Code to indicate place of wheer tagging took place at fourth tagging interaction | |
100
|
GEAR_ID_4 | VARCHAR2 | Code for gear used to catch the animal at fourth tagging interaction. | |
100
|
BAIT_TYPE_4 | VARCHAR2 | Code for bait used: (A)rtificial, (L)ive, (D)ead, (U)nknown at fourth tagging interaction. | |
100
|
METHOD_ID_4 | NUMBER | Code To indicate tagging methodology Used at fourth tagging interaction | |
100
|
SAMPLE_ID_4 | NUMBER | Code to indicate Sampling Methodology at fourth tagging interaction | |
100
|
CAPTAIN_AGENCY_4 | VARCHAR2 | Code to indicate agency which assigned angler code for boat captain at fourth tagging interaction. | |
100
|
CAPTAIN_ID_4 | NUMBER | Unique numeric code assigned to an individual captain. Must be greater than zero or -99999 at fourth tagging interaction. | |
100
|
TAGGER_INITIALS_4 | VARCHAR2 | Initials Of Taggers at fourth tagging interaction. | |
100
|
TAGGER_TYPE_4 | VARCHAR2 | Indicates Type Of Tagger at fourth tagging interaction. | |
100
|
TAGGER_AFFILIATION_4 | VARCHAR2 | Code Of Agency that is affiliated With The Tagger at fourth tagging interaction. | |
100
|
VESSEL_AGENCY_4 | VARCHAR2 | Agency For Vessel Code at fourth tagging interaction. | |
100
|
VESSEL_ID_4 | NUMBER | Agency supplied code identifying the vessel involved in the release or recapture of the animal at fourth tagging interaction. | |
100
|
PHYSICAL_DATA_ID_4 | NUMBER | Physical Data Identification Number at fourth tagging interaction | |
100
|
NOTES_4 | NUMBER | Any Other Notes On Tagging at fourth tagging interaction | |
100
|
FIGHT_HOURS_4 | NUMBER | Number Of Hours Spent FIghting/Landings Fish at fourth tagging interaction | |
100
|
FIGHT_MINUTES_4 | NUMBER | Number Of Minutes (up to 59) spent FIghting/Landings Fish at fourth tagging interaction | |
100
|
ANGLER_AGENCY_4 | VARCHAR2 | Agency That Has Angler Code list at fourth tagging interaction | |
100
|
ANGLER_ID_4 | NUMBER | Angler Code at fourth tagging interaction . | |
100
|
DATE_ENTERED_4 | DATE | The date the data was entered at fourth tagging interaction. | |
100
|
AGENCY_ID_5 | VARCHAR2 | Code to Indicate Tagging agency of identifying tag on animal (tag1) at fifth tagging interaction | |
100
|
TAG_ID_5 | VARCHAR2 | Tagnumber at fifth tagging interaction | |
100
|
EVENT_ID_5 | NUMBER | Code to Indicate Tagging Event at fifth tagging interaction | |
100
|
TAG_DATE_5 | VARCHAR2 | Date animal was released or recaptured t fifth tagging interaction. | |
100
|
NEXT_TAG_AGENCY_5 | VARCHAR2 | Code For Agency That Issued the next tag (fifth tag) on this record at fifth tagging interaction | |
100
|
NEXT_TAG_ID_5 | VARCHAR2 | Code to Indicate Tagging agency of identifying tag on animal (nexttag) at fifth tagging interaction | |
100
|
INTERACTION_ORDER_5 | NUMBER | Number denoting the order of the interaction at fifth tagging interaction. | |
100
|
LENGTH_5 | NUMBER | Length of animal tagged based on the lengthunit, lengthtype, and lengthdet at fifth tagging interaction. | |
100
|
LENGTH_UNIT_5 | VARCHAR2 | Units for Length Measurement at fifth tagging interaction. | |
100
|
LENGTH_TYPE_5 | VARCHAR2 | Code to determine The Type Of Length Measurement taken at fifth tagging interaction. | |
100
|
LENGTH_DETERMINATION_5 | VARCHAR2 | Code To Indicate How Length Was determined at fifth tagging interaction | |
100
|
WEIGHT_5 | NUMBER | Weight of an animal tagged, based upon weightunit, weighttype and weightdet at fifth tagging interaction. | |
100
|
WEIGHT_UNIT_5 | VARCHAR2 | Units for Weight Measurement t fifth tagging interaction. | |
100
|
WEIGHT_TYPE_5 | VARCHAR2 | Code For Type Of Weight Measurement at fifth tagging interaction. | |
100
|
WEIGHT_DETERMINATION_5 | VARCHAR2 | Code For How Weight Was Determined at fifth tagging interaction. | |
100
|
LATITUDE_5 | NUMBER | Numeric value for the latitude of the tagging location at fifth tagging interaction. | |
100
|
LONGITUDE_5 | NUMBER | Numeric value the the longitude of the tagging location at fifth tagging interaction. | |
100
|
STAT_ZONE_ID_5 | NUMBER | Code to indciate State Zone at fifth tagging interaction | |
100
|
COUNTRY_ID_5 | VARCHAR2 | Code to indicate Country at fifth tagging interaction | |
100
|
STATE_ID_5 | VARCHAR2 | Code to indicate state at fifth tagging interaction | |
100
|
WATER_BODY_ID_5 | NUMBER | Code to Indicate waterbody of where tagging took place at fifth tagging interaction | |
100
|
PLACE_ID_5 | VARCHAR2 | Code to indicate place of wheer tagging took place at fifth tagging interaction | |
100
|
GEAR_ID_5 | VARCHAR2 | Code for gear used to catch the animal at fifth tagging interaction. | |
100
|
BAIT_TYPE_5 | VARCHAR2 | Code for bait used: (A)rtificial, (L)ive, (D)ead, (U)nknown at fifth tagging interaction. | |
100
|
METHOD_ID_5 | NUMBER | Code To indicate tagging methodology Used at fifth tagging interaction | |
100
|
SAMPLE_ID_5 | NUMBER | Code to indicate Sampling Methodology at fifth tagging interaction | |
100
|
CAPTAIN_AGENCY_5 | VARCHAR2 | Code to indicate agency which assigned angler code for boat captain at fifth tagging interaction. | |
100
|
CAPTAIN_ID_5 | NUMBER | Unique numeric code assigned to an individual captain. Must be greater than zero or -99999 at fifth tagging interaction. | |
100
|
TAGGER_INITIALS_5 | VARCHAR2 | Initials Of Taggers at fifth tagging interaction. | |
100
|
TAGGER_TYPE_5 | VARCHAR2 | Indicates Type Of Tagger at fifth tagging interaction. | |
100
|
TAGGER_AFFILIATION_5 | VARCHAR2 | Code Of Agency that is affiliated With The Tagger at fifth tagging interaction. | |
100
|
VESSEL_AGENCY_5 | VARCHAR2 | Agency For Vessel Code at fifth tagging interaction. | |
100
|
VESSEL_ID_5 | NUMBER | Agency supplied code identifying the vessel involved in the release or recapture of the animal at fifth tagging interaction. | |
100
|
PHYSICAL_DATA_ID_5 | NUMBER | Physical Data Identification Number at fifth tagging interaction | |
100
|
NOTES_5 | NUMBER | Any Other Notes On Tagging at fifth tagging interaction | |
100
|
FIGHT_HOURS_5 | NUMBER | Number Of Hours Spent FIghting/Landings Fish at fifth tagging interaction | |
100
|
FIGHT_MINUTES_5 | NUMBER | Number Of Minutes (up to 59) spent FIghting/Landings Fish at fifth tagging interaction | |
100
|
ANGLER_AGENCY_5 | VARCHAR2 | Agency That Has Angler Code list at fifth tagging interaction | |
100
|
ANGLER_ID_5 | NUMBER | Angler Code at fifth tagging interaction . | |
100
|
DATE_ENTERED_5 | DATE | The date the data was entered at fifth tagging interaction. |
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_1
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) at first tagging interaction |
General Data Type: | VARCHAR2 |
TAG_ID_1
Seq. Order: | 5 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 8 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Tagnumber at first tagging interaction |
General Data Type: | VARCHAR2 |
EVENT_ID_1
Seq. Order: | 6 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 2 |
Scale: | 0 |
Status: | Active |
Description: |
Code to Indicate Tagging Event at first tagging interaction |
General Data Type: | NUMBER |
TAG_DATE_1
Seq. Order: | 7 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 10 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date animal was released or recaptured t first tagging interaction. |
General Data Type: | VARCHAR2 |
NEXT_TAG_AGENCY_1
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 at first tagging interaction |
General Data Type: | VARCHAR2 |
NEXT_TAG_ID_1
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) at first tagging interaction |
General Data Type: | VARCHAR2 |
INTERACTION_ORDER_1
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 at first tagging interaction. |
General Data Type: | NUMBER |
LENGTH_1
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 at first tagging interaction. |
General Data Type: | NUMBER |
LENGTH_UNIT_1
Seq. Order: | 12 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Units for Length Measurement at first tagging interaction. |
General Data Type: | VARCHAR2 |
LENGTH_TYPE_1
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 at first tagging interaction. |
General Data Type: | VARCHAR2 |
LENGTH_DETERMINATION_1
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 at first tagging interaction |
General Data Type: | VARCHAR2 |
WEIGHT_1
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 at first tagging interaction. |
General Data Type: | NUMBER |
WEIGHT_UNIT_1
Seq. Order: | 16 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Units for Weight Measurement t first tagging interaction. |
General Data Type: | VARCHAR2 |
WEIGHT_TYPE_1
Seq. Order: | 17 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code For Type Of Weight Measurement at first tagging interaction. |
General Data Type: | VARCHAR2 |
WEIGHT_DETERMINATION_1
Seq. Order: | 18 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code For How Weight Was Determined at first tagging interaction. |
General Data Type: | VARCHAR2 |
LATITUDE_1
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 at first tagging interaction. |
General Data Type: | NUMBER |
LONGITUDE_1
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 at first tagging interaction. |
General Data Type: | NUMBER |
STAT_ZONE_ID_1
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 at first tagging interaction |
General Data Type: | NUMBER |
COUNTRY_ID_1
Seq. Order: | 22 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code to indicate Country at first tagging interaction |
General Data Type: | VARCHAR2 |
STATE_ID_1
Seq. Order: | 23 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code to indicate state at first tagging interaction |
General Data Type: | VARCHAR2 |
WATER_BODY_ID_1
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 at first tagging interaction |
General Data Type: | NUMBER |
PLACE_ID_1
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 place at first tagging interaction |
General Data Type: | VARCHAR2 |
GEAR_ID_1
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 at first tagging interaction. |
General Data Type: | VARCHAR2 |
BAIT_TYPE_1
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 at first tagging interaction. |
General Data Type: | VARCHAR2 |
METHOD_ID_1
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 at first tagging interaction |
General Data Type: | NUMBER |
SAMPLE_ID_1
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 at first tagging interaction |
General Data Type: | NUMBER |
CAPTAIN_AGENCY_1
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 at first tagging interaction. |
General Data Type: | VARCHAR2 |
CAPTAIN_ID_1
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 at first tagging interaction. |
General Data Type: | NUMBER |
TAGGER_INITIALS_1
Seq. Order: | 32 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Initials Of Taggers at first tagging interaction. |
General Data Type: | VARCHAR2 |
TAGGER_TYPE_1
Seq. Order: | 33 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Indicates Type Of Tagger at first tagging interaction. |
General Data Type: | VARCHAR2 |
TAGGER_AFFILIATION_1
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 at first tagging interaction. |
General Data Type: | VARCHAR2 |
VESSEL_AGENCY_1
Seq. Order: | 35 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Agency For Vessel Code at first tagging interaction. |
General Data Type: | VARCHAR2 |
VESSEL_ID_1
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 at first tagging interaction. |
General Data Type: | NUMBER |
PHYSICAL_DATA_ID_1
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 at first tagging interaction |
General Data Type: | NUMBER |
NOTES_1
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 at first tagging interaction |
General Data Type: | NUMBER |
FIGHT_HOURS_1
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 at first tagging interaction |
General Data Type: | NUMBER |
FIGHT_MINUTES_1
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 at first tagging interaction |
General Data Type: | NUMBER |
ANGLER_AGENCY_1
Seq. Order: | 41 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Agency That Has Angler Code list at first tagging interaction |
General Data Type: | VARCHAR2 |
ANGLER_ID_1
Seq. Order: | 42 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 6 |
Scale: | 0 |
Status: | Active |
Description: |
Angler Code at first tagging interaction . |
General Data Type: | NUMBER |
DATE_ENTERED_1
Seq. Order: | 43 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The date the data was entered at first tagging interaction. |
General Data Type: | DATE |
AGENCY_ID_2
Seq. Order: | 44 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code to Indicate Tagging agency of identifying tag on animal (tag1) at second tagging interaction |
General Data Type: | VARCHAR2 |
TAG_ID_2
Seq. Order: | 45 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 8 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Tagnumber at second tagging interaction |
General Data Type: | VARCHAR2 |
EVENT_ID_2
Seq. Order: | 46 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 2 |
Scale: | 0 |
Status: | Active |
Description: |
Code to Indicate Tagging Event at second tagging interaction |
General Data Type: | NUMBER |
TAG_DATE_2
Seq. Order: | 47 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 10 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date animal was released or recaptured t second tagging interaction. |
General Data Type: | VARCHAR2 |
NEXT_TAG_AGENCY_2
Seq. Order: | 48 |
---|---|
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 at second tagging interaction |
General Data Type: | VARCHAR2 |
NEXT_TAG_ID_2
Seq. Order: | 49 |
---|---|
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) at second tagging interaction |
General Data Type: | VARCHAR2 |
INTERACTION_ORDER_2
Seq. Order: | 50 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 2 |
Scale: | 0 |
Status: | Active |
Description: |
Number denoting the order of the interaction at second tagging interaction. |
General Data Type: | NUMBER |
LENGTH_2
Seq. Order: | 51 |
---|---|
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 at second tagging interaction. |
General Data Type: | NUMBER |
LENGTH_UNIT_2
Seq. Order: | 52 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Units for Length Measurement at second tagging interaction. |
General Data Type: | VARCHAR2 |
LENGTH_TYPE_2
Seq. Order: | 53 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code to determine The Type Of Length Measurement taken at second tagging interaction. |
General Data Type: | VARCHAR2 |
LENGTH_DETERMINATION_2
Seq. Order: | 54 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code To Indicate How Length Was determined at second tagging interaction |
General Data Type: | VARCHAR2 |
WEIGHT_2
Seq. Order: | 55 |
---|---|
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 at second tagging interaction. |
General Data Type: | NUMBER |
WEIGHT_UNIT_2
Seq. Order: | 56 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Units for Weight Measurement t second tagging interaction. |
General Data Type: | VARCHAR2 |
WEIGHT_TYPE_2
Seq. Order: | 57 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code For Type Of Weight Measurement at second tagging interaction. |
General Data Type: | VARCHAR2 |
WEIGHT_DETERMINATION_2
Seq. Order: | 58 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code For How Weight Was Determined at second tagging interaction. |
General Data Type: | VARCHAR2 |
LATITUDE_2
Seq. Order: | 59 |
---|---|
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 at second tagging interaction. |
General Data Type: | NUMBER |
LONGITUDE_2
Seq. Order: | 60 |
---|---|
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 at second tagging interaction. |
General Data Type: | NUMBER |
STAT_ZONE_ID_2
Seq. Order: | 61 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 4 |
Scale: | 1 |
Status: | Active |
Description: |
Code to indciate State Zone at second tagging interaction |
General Data Type: | NUMBER |
COUNTRY_ID_2
Seq. Order: | 62 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code to indicate Country at second tagging interaction |
General Data Type: | VARCHAR2 |
STATE_ID_2
Seq. Order: | 63 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code to indicate state at second tagging interaction |
General Data Type: | VARCHAR2 |
WATER_BODY_ID_2
Seq. Order: | 64 |
---|---|
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 at second tagging interaction |
General Data Type: | NUMBER |
PLACE_ID_2
Seq. Order: | 65 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code to indicate place of wheer tagging took place at second tagging interaction |
General Data Type: | VARCHAR2 |
GEAR_ID_2
Seq. Order: | 66 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code for gear used to catch the animal at second tagging interaction. |
General Data Type: | VARCHAR2 |
BAIT_TYPE_2
Seq. Order: | 67 |
---|---|
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 at second tagging interaction. |
General Data Type: | VARCHAR2 |
METHOD_ID_2
Seq. Order: | 68 |
---|---|
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 at second tagging interaction |
General Data Type: | NUMBER |
SAMPLE_ID_2
Seq. Order: | 69 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 6 |
Scale: | 0 |
Status: | Active |
Description: |
Code to indicate Sampling Methodology at second tagging interaction |
General Data Type: | NUMBER |
CAPTAIN_AGENCY_2
Seq. Order: | 70 |
---|---|
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 at second tagging interaction. |
General Data Type: | VARCHAR2 |
CAPTAIN_ID_2
Seq. Order: | 71 |
---|---|
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 at second tagging interaction. |
General Data Type: | NUMBER |
TAGGER_INITIALS_2
Seq. Order: | 72 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Initials Of Taggers at second tagging interaction. |
General Data Type: | VARCHAR2 |
TAGGER_TYPE_2
Seq. Order: | 73 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Indicates Type Of Tagger at second tagging interaction. |
General Data Type: | VARCHAR2 |
TAGGER_AFFILIATION_2
Seq. Order: | 74 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code Of Agency that is affiliated With The Tagger at second tagging interaction. |
General Data Type: | VARCHAR2 |
VESSEL_AGENCY_2
Seq. Order: | 75 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Agency For Vessel Code at second tagging interaction. |
General Data Type: | VARCHAR2 |
VESSEL_ID_2
Seq. Order: | 76 |
---|---|
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 at second tagging interaction. |
General Data Type: | NUMBER |
PHYSICAL_DATA_ID_2
Seq. Order: | 77 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 6 |
Scale: | 0 |
Status: | Active |
Description: |
Physical Data Identification Number at second tagging interaction |
General Data Type: | NUMBER |
NOTES_2
Seq. Order: | 78 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 3 |
Scale: | 0 |
Status: | Active |
Description: |
Any Other Notes On Tagging at second tagging interaction |
General Data Type: | NUMBER |
FIGHT_HOURS_2
Seq. Order: | 79 |
---|---|
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 at second tagging interaction |
General Data Type: | NUMBER |
FIGHT_MINUTES_2
Seq. Order: | 80 |
---|---|
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 at second tagging interaction |
General Data Type: | NUMBER |
ANGLER_AGENCY_2
Seq. Order: | 81 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Agency That Has Angler Code list at second tagging interaction |
General Data Type: | VARCHAR2 |
ANGLER_ID_2
Seq. Order: | 82 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 6 |
Scale: | 0 |
Status: | Active |
Description: |
Angler Code at second tagging interaction . |
General Data Type: | NUMBER |
DATE_ENTERED_2
Seq. Order: | 83 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The date the data was entered at second tagging interaction. |
General Data Type: | DATE |
AGENCY_ID_3
Seq. Order: | 84 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code to Indicate Tagging agency of identifying tag on animal (tag1) at third tagging interaction |
General Data Type: | VARCHAR2 |
TAG_ID_3
Seq. Order: | 85 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 8 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Tagnumber at third tagging interaction |
General Data Type: | VARCHAR2 |
EVENT_ID_3
Seq. Order: | 86 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 2 |
Scale: | 0 |
Status: | Active |
Description: |
Code to Indicate Tagging Event at third tagging interaction |
General Data Type: | NUMBER |
TAG_DATE_3
Seq. Order: | 87 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 10 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date animal was released or recaptured t third tagging interaction. |
General Data Type: | VARCHAR2 |
NEXT_TAG_AGENCY_3
Seq. Order: | 88 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code For Agency That Issued the next tag (third tag) on this record at third tagging interaction |
General Data Type: | VARCHAR2 |
NEXT_TAG_ID_3
Seq. Order: | 89 |
---|---|
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) at third tagging interaction |
General Data Type: | VARCHAR2 |
INTERACTION_ORDER_3
Seq. Order: | 90 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 2 |
Scale: | 0 |
Status: | Active |
Description: |
Number denoting the order of the interaction at third tagging interaction. |
General Data Type: | NUMBER |
LENGTH_3
Seq. Order: | 91 |
---|---|
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 at third tagging interaction. |
General Data Type: | NUMBER |
LENGTH_UNIT_3
Seq. Order: | 92 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Units for Length Measurement at third tagging interaction. |
General Data Type: | VARCHAR2 |
LENGTH_TYPE_3
Seq. Order: | 93 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code to determine The Type Of Length Measurement taken at third tagging interaction. |
General Data Type: | VARCHAR2 |
LENGTH_DETERMINATION_3
Seq. Order: | 94 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code To Indicate How Length Was determined at third tagging interaction |
General Data Type: | VARCHAR2 |
WEIGHT_3
Seq. Order: | 95 |
---|---|
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 at third tagging interaction. |
General Data Type: | NUMBER |
WEIGHT_UNIT_3
Seq. Order: | 96 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Units for Weight Measurement t third tagging interaction. |
General Data Type: | VARCHAR2 |
WEIGHT_TYPE_3
Seq. Order: | 97 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code For Type Of Weight Measurement at third tagging interaction. |
General Data Type: | VARCHAR2 |
WEIGHT_DETERMINATION_3
Seq. Order: | 98 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code For How Weight Was Determined at third tagging interaction. |
General Data Type: | VARCHAR2 |
LATITUDE_3
Seq. Order: | 99 |
---|---|
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 at third tagging interaction. |
General Data Type: | NUMBER |
LONGITUDE_3
Seq. Order: | 100 |
---|---|
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 at third tagging interaction. |
General Data Type: | NUMBER |
STAT_ZONE_ID_3
Seq. Order: | 101 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 4 |
Scale: | 1 |
Status: | Active |
Description: |
Code to indciate State Zone at third tagging interaction |
General Data Type: | NUMBER |
COUNTRY_ID_3
Seq. Order: | 102 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code to indicate Country at third tagging interaction |
General Data Type: | VARCHAR2 |
STATE_ID_3
Seq. Order: | 103 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code to indicate state at third tagging interaction |
General Data Type: | VARCHAR2 |
WATER_BODY_ID_3
Seq. Order: | 104 |
---|---|
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 at third tagging interaction |
General Data Type: | NUMBER |
PLACE_ID_3
Seq. Order: | 105 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code to indicate place of wheer tagging took place at third tagging interaction |
General Data Type: | VARCHAR2 |
GEAR_ID_3
Seq. Order: | 106 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code for gear used to catch the animal at third tagging interaction. |
General Data Type: | VARCHAR2 |
BAIT_TYPE_3
Seq. Order: | 107 |
---|---|
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 at third tagging interaction. |
General Data Type: | VARCHAR2 |
METHOD_ID_3
Seq. Order: | 108 |
---|---|
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 at third tagging interaction |
General Data Type: | NUMBER |
SAMPLE_ID_3
Seq. Order: | 109 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 6 |
Scale: | 0 |
Status: | Active |
Description: |
Code to indicate Sampling Methodology at third tagging interaction |
General Data Type: | NUMBER |
CAPTAIN_AGENCY_3
Seq. Order: | 110 |
---|---|
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 at third tagging interaction. |
General Data Type: | VARCHAR2 |
CAPTAIN_ID_3
Seq. Order: | 111 |
---|---|
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 at third tagging interaction. |
General Data Type: | NUMBER |
TAGGER_INITIALS_3
Seq. Order: | 112 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Initials Of Taggers at third tagging interaction. |
General Data Type: | VARCHAR2 |
TAGGER_TYPE_3
Seq. Order: | 113 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Indicates Type Of Tagger at third tagging interaction. |
General Data Type: | VARCHAR2 |
TAGGER_AFFILIATION_3
Seq. Order: | 114 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code Of Agency that is affiliated With The Tagger at third tagging interaction. |
General Data Type: | VARCHAR2 |
VESSEL_AGENCY_3
Seq. Order: | 115 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Agency For Vessel Code at third tagging interaction. |
General Data Type: | VARCHAR2 |
VESSEL_ID_3
Seq. Order: | 116 |
---|---|
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 at third tagging interaction. |
General Data Type: | NUMBER |
PHYSICAL_DATA_ID_3
Seq. Order: | 117 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 6 |
Scale: | 0 |
Status: | Active |
Description: |
Physical Data Identification Number at third tagging interaction |
General Data Type: | NUMBER |
NOTES_3
Seq. Order: | 118 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 3 |
Scale: | 0 |
Status: | Active |
Description: |
Any Other Notes On Tagging at third tagging interaction |
General Data Type: | NUMBER |
FIGHT_HOURS_3
Seq. Order: | 119 |
---|---|
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 at third tagging interaction |
General Data Type: | NUMBER |
FIGHT_MINUTES_3
Seq. Order: | 120 |
---|---|
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 at third tagging interaction |
General Data Type: | NUMBER |
ANGLER_AGENCY_3
Seq. Order: | 121 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Agency That Has Angler Code list at third tagging interaction |
General Data Type: | VARCHAR2 |
ANGLER_ID_3
Seq. Order: | 122 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 6 |
Scale: | 0 |
Status: | Active |
Description: |
Angler Code at third tagging interaction . |
General Data Type: | NUMBER |
DATE_ENTERED_3
Seq. Order: | 123 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The date the data was entered at third tagging interaction. |
General Data Type: | DATE |
AGENCY_ID_4
Seq. Order: | 124 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code to Indicate Tagging agency of identifying tag on animal (tag1) at fourth tagging interaction |
General Data Type: | VARCHAR2 |
TAG_ID_4
Seq. Order: | 125 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 8 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Tagnumber at fourth tagging interaction |
General Data Type: | VARCHAR2 |
EVENT_ID_4
Seq. Order: | 126 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 2 |
Scale: | 0 |
Status: | Active |
Description: |
Code to Indicate Tagging Event at fourth tagging interaction |
General Data Type: | NUMBER |
TAG_DATE_4
Seq. Order: | 127 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 10 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date animal was released or recaptured t fourth tagging interaction. |
General Data Type: | VARCHAR2 |
NEXT_TAG_AGENCY_4
Seq. Order: | 128 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code For Agency That Issued the next tag (fourth tag) on this record at fourth tagging interaction |
General Data Type: | VARCHAR2 |
NEXT_TAG_ID_4
Seq. Order: | 129 |
---|---|
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) at fourth tagging interaction |
General Data Type: | VARCHAR2 |
INTERACTION_ORDER_4
Seq. Order: | 130 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 2 |
Scale: | 0 |
Status: | Active |
Description: |
Number denoting the order of the interaction at fourth tagging interaction. |
General Data Type: | NUMBER |
LENGTH_4
Seq. Order: | 131 |
---|---|
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 at fourth tagging interaction. |
General Data Type: | NUMBER |
LENGTH_UNIT_4
Seq. Order: | 132 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Units for Length Measurement at fourth tagging interaction. |
General Data Type: | VARCHAR2 |
LENGTH_TYPE_4
Seq. Order: | 133 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code to determine The Type Of Length Measurement taken at fourth tagging interaction. |
General Data Type: | VARCHAR2 |
LENGTH_DETERMINATION_4
Seq. Order: | 134 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code To Indicate How Length Was determined at fourth tagging interaction |
General Data Type: | VARCHAR2 |
WEIGHT_4
Seq. Order: | 135 |
---|---|
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 at fourth tagging interaction. |
General Data Type: | NUMBER |
WEIGHT_UNIT_4
Seq. Order: | 136 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Units for Weight Measurement t fourth tagging interaction. |
General Data Type: | VARCHAR2 |
WEIGHT_TYPE_4
Seq. Order: | 137 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code For Type Of Weight Measurement at fourth tagging interaction. |
General Data Type: | VARCHAR2 |
WEIGHT_DETERMINATION_4
Seq. Order: | 138 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code For How Weight Was Determined at fourth tagging interaction. |
General Data Type: | VARCHAR2 |
LATITUDE_4
Seq. Order: | 139 |
---|---|
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 at fourth tagging interaction. |
General Data Type: | NUMBER |
LONGITUDE_4
Seq. Order: | 140 |
---|---|
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 at fourth tagging interaction. |
General Data Type: | NUMBER |
STAT_ZONE_ID_4
Seq. Order: | 141 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 4 |
Scale: | 1 |
Status: | Active |
Description: |
Code to indciate State Zone at fourth tagging interaction |
General Data Type: | NUMBER |
COUNTRY_ID_4
Seq. Order: | 142 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code to indicate Country at fourth tagging interaction |
General Data Type: | VARCHAR2 |
STATE_ID_4
Seq. Order: | 143 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code to indicate state at fourth tagging interaction |
General Data Type: | VARCHAR2 |
WATER_BODY_ID_4
Seq. Order: | 144 |
---|---|
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 at fourth tagging interaction |
General Data Type: | NUMBER |
PLACE_ID_4
Seq. Order: | 145 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code to indicate place of wheer tagging took place at fourth tagging interaction |
General Data Type: | VARCHAR2 |
GEAR_ID_4
Seq. Order: | 146 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code for gear used to catch the animal at fourth tagging interaction. |
General Data Type: | VARCHAR2 |
BAIT_TYPE_4
Seq. Order: | 147 |
---|---|
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 at fourth tagging interaction. |
General Data Type: | VARCHAR2 |
METHOD_ID_4
Seq. Order: | 148 |
---|---|
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 at fourth tagging interaction |
General Data Type: | NUMBER |
SAMPLE_ID_4
Seq. Order: | 149 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 6 |
Scale: | 0 |
Status: | Active |
Description: |
Code to indicate Sampling Methodology at fourth tagging interaction |
General Data Type: | NUMBER |
CAPTAIN_AGENCY_4
Seq. Order: | 150 |
---|---|
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 at fourth tagging interaction. |
General Data Type: | VARCHAR2 |
CAPTAIN_ID_4
Seq. Order: | 151 |
---|---|
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 at fourth tagging interaction. |
General Data Type: | NUMBER |
TAGGER_INITIALS_4
Seq. Order: | 152 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Initials Of Taggers at fourth tagging interaction. |
General Data Type: | VARCHAR2 |
TAGGER_TYPE_4
Seq. Order: | 153 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Indicates Type Of Tagger at fourth tagging interaction. |
General Data Type: | VARCHAR2 |
TAGGER_AFFILIATION_4
Seq. Order: | 154 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code Of Agency that is affiliated With The Tagger at fourth tagging interaction. |
General Data Type: | VARCHAR2 |
VESSEL_AGENCY_4
Seq. Order: | 155 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Agency For Vessel Code at fourth tagging interaction. |
General Data Type: | VARCHAR2 |
VESSEL_ID_4
Seq. Order: | 156 |
---|---|
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 at fourth tagging interaction. |
General Data Type: | NUMBER |
PHYSICAL_DATA_ID_4
Seq. Order: | 157 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 6 |
Scale: | 0 |
Status: | Active |
Description: |
Physical Data Identification Number at fourth tagging interaction |
General Data Type: | NUMBER |
NOTES_4
Seq. Order: | 158 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 3 |
Scale: | 0 |
Status: | Active |
Description: |
Any Other Notes On Tagging at fourth tagging interaction |
General Data Type: | NUMBER |
FIGHT_HOURS_4
Seq. Order: | 159 |
---|---|
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 at fourth tagging interaction |
General Data Type: | NUMBER |
FIGHT_MINUTES_4
Seq. Order: | 160 |
---|---|
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 at fourth tagging interaction |
General Data Type: | NUMBER |
ANGLER_AGENCY_4
Seq. Order: | 161 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Agency That Has Angler Code list at fourth tagging interaction |
General Data Type: | VARCHAR2 |
ANGLER_ID_4
Seq. Order: | 162 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 6 |
Scale: | 0 |
Status: | Active |
Description: |
Angler Code at fourth tagging interaction . |
General Data Type: | NUMBER |
DATE_ENTERED_4
Seq. Order: | 163 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The date the data was entered at fourth tagging interaction. |
General Data Type: | DATE |
AGENCY_ID_5
Seq. Order: | 164 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code to Indicate Tagging agency of identifying tag on animal (tag1) at fifth tagging interaction |
General Data Type: | VARCHAR2 |
TAG_ID_5
Seq. Order: | 165 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 8 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Tagnumber at fifth tagging interaction |
General Data Type: | VARCHAR2 |
EVENT_ID_5
Seq. Order: | 166 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 2 |
Scale: | 0 |
Status: | Active |
Description: |
Code to Indicate Tagging Event at fifth tagging interaction |
General Data Type: | NUMBER |
TAG_DATE_5
Seq. Order: | 167 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 10 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date animal was released or recaptured t fifth tagging interaction. |
General Data Type: | VARCHAR2 |
NEXT_TAG_AGENCY_5
Seq. Order: | 168 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code For Agency That Issued the next tag (fifth tag) on this record at fifth tagging interaction |
General Data Type: | VARCHAR2 |
NEXT_TAG_ID_5
Seq. Order: | 169 |
---|---|
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) at fifth tagging interaction |
General Data Type: | VARCHAR2 |
INTERACTION_ORDER_5
Seq. Order: | 170 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 2 |
Scale: | 0 |
Status: | Active |
Description: |
Number denoting the order of the interaction at fifth tagging interaction. |
General Data Type: | NUMBER |
LENGTH_5
Seq. Order: | 171 |
---|---|
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 at fifth tagging interaction. |
General Data Type: | NUMBER |
LENGTH_UNIT_5
Seq. Order: | 172 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Units for Length Measurement at fifth tagging interaction. |
General Data Type: | VARCHAR2 |
LENGTH_TYPE_5
Seq. Order: | 173 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code to determine The Type Of Length Measurement taken at fifth tagging interaction. |
General Data Type: | VARCHAR2 |
LENGTH_DETERMINATION_5
Seq. Order: | 174 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code To Indicate How Length Was determined at fifth tagging interaction |
General Data Type: | VARCHAR2 |
WEIGHT_5
Seq. Order: | 175 |
---|---|
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 at fifth tagging interaction. |
General Data Type: | NUMBER |
WEIGHT_UNIT_5
Seq. Order: | 176 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Units for Weight Measurement t fifth tagging interaction. |
General Data Type: | VARCHAR2 |
WEIGHT_TYPE_5
Seq. Order: | 177 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code For Type Of Weight Measurement at fifth tagging interaction. |
General Data Type: | VARCHAR2 |
WEIGHT_DETERMINATION_5
Seq. Order: | 178 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code For How Weight Was Determined at fifth tagging interaction. |
General Data Type: | VARCHAR2 |
LATITUDE_5
Seq. Order: | 179 |
---|---|
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 at fifth tagging interaction. |
General Data Type: | NUMBER |
LONGITUDE_5
Seq. Order: | 180 |
---|---|
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 at fifth tagging interaction. |
General Data Type: | NUMBER |
STAT_ZONE_ID_5
Seq. Order: | 181 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 4 |
Scale: | 1 |
Status: | Active |
Description: |
Code to indciate State Zone at fifth tagging interaction |
General Data Type: | NUMBER |
COUNTRY_ID_5
Seq. Order: | 182 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code to indicate Country at fifth tagging interaction |
General Data Type: | VARCHAR2 |
STATE_ID_5
Seq. Order: | 183 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code to indicate state at fifth tagging interaction |
General Data Type: | VARCHAR2 |
WATER_BODY_ID_5
Seq. Order: | 184 |
---|---|
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 at fifth tagging interaction |
General Data Type: | NUMBER |
PLACE_ID_5
Seq. Order: | 185 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code to indicate place of wheer tagging took place at fifth tagging interaction |
General Data Type: | VARCHAR2 |
GEAR_ID_5
Seq. Order: | 186 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code for gear used to catch the animal at fifth tagging interaction. |
General Data Type: | VARCHAR2 |
BAIT_TYPE_5
Seq. Order: | 187 |
---|---|
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 at fifth tagging interaction. |
General Data Type: | VARCHAR2 |
METHOD_ID_5
Seq. Order: | 188 |
---|---|
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 at fifth tagging interaction |
General Data Type: | NUMBER |
SAMPLE_ID_5
Seq. Order: | 189 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 6 |
Scale: | 0 |
Status: | Active |
Description: |
Code to indicate Sampling Methodology at fifth tagging interaction |
General Data Type: | NUMBER |
CAPTAIN_AGENCY_5
Seq. Order: | 190 |
---|---|
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 at fifth tagging interaction. |
General Data Type: | VARCHAR2 |
CAPTAIN_ID_5
Seq. Order: | 191 |
---|---|
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 at fifth tagging interaction. |
General Data Type: | NUMBER |
TAGGER_INITIALS_5
Seq. Order: | 192 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Initials Of Taggers at fifth tagging interaction. |
General Data Type: | VARCHAR2 |
TAGGER_TYPE_5
Seq. Order: | 193 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Indicates Type Of Tagger at fifth tagging interaction. |
General Data Type: | VARCHAR2 |
TAGGER_AFFILIATION_5
Seq. Order: | 194 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code Of Agency that is affiliated With The Tagger at fifth tagging interaction. |
General Data Type: | VARCHAR2 |
VESSEL_AGENCY_5
Seq. Order: | 195 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Agency For Vessel Code at fifth tagging interaction. |
General Data Type: | VARCHAR2 |
VESSEL_ID_5
Seq. Order: | 196 |
---|---|
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 at fifth tagging interaction. |
General Data Type: | NUMBER |
PHYSICAL_DATA_ID_5
Seq. Order: | 197 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 6 |
Scale: | 0 |
Status: | Active |
Description: |
Physical Data Identification Number at fifth tagging interaction |
General Data Type: | NUMBER |
NOTES_5
Seq. Order: | 198 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 3 |
Scale: | 0 |
Status: | Active |
Description: |
Any Other Notes On Tagging at fifth tagging interaction |
General Data Type: | NUMBER |
FIGHT_HOURS_5
Seq. Order: | 199 |
---|---|
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 at fifth tagging interaction |
General Data Type: | NUMBER |
FIGHT_MINUTES_5
Seq. Order: | 200 |
---|---|
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 at fifth tagging interaction |
General Data Type: | NUMBER |
ANGLER_AGENCY_5
Seq. Order: | 201 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Agency That Has Angler Code list at fifth tagging interaction |
General Data Type: | VARCHAR2 |
ANGLER_ID_5
Seq. Order: | 202 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 6 |
Scale: | 0 |
Status: | Active |
Description: |
Angler Code at fifth tagging interaction . |
General Data Type: | NUMBER |
DATE_ENTERED_5
Seq. Order: | 203 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The date the data was entered at fifth tagging interaction. |
General Data Type: | DATE |
Catalog Details
Catalog Item ID: | 7102 |
---|---|
GUID: | gov.noaa.nmfs.inport:7102 |
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 |