View: CTS_INTERACTIONS_SEARCH_V
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:7048 | Updated: August 9, 2022 | Published / External
Item Identification
| Title: | View: CTS_INTERACTIONS_SEARCH_V |
|---|---|
| Short Name: | CTS_INTERACTIONS_SEARCH_V |
| Status: | Completed |
| Abstract: |
View Of data starting with 01/01/2003 |
| 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 starting with 01/01/2003 |
Data Attributes
Attribute Summary
|
|
Name | Type | Description |
|---|---|---|---|---|
|
100
|
ANIMAL_ID | NUMBER | Key to Identifies Animal | |
|
100
|
AGENCY_ID | VARCHAR2 | Code to Indicate Tagging agency of identifying tag on animal (tag1) | |
|
100
|
TAG_ID | VARCHAR2 | Tagnumber | |
|
100
|
EVENT_ID | NUMBER | Code to identify tagging event | |
|
100
|
TAG_DATE | VARCHAR2 | Date animal was released or recaptured. | |
|
100
|
TAGDATE | DATE | Date Animal Was Tagged | |
|
100
|
NEXT_TAG_AGENCY_ID | VARCHAR2 | Agency Id associated with value in the nexttag column | |
|
100
|
NEXT_TAG_ID | VARCHAR2 | Code to Indicate Tagging agency of identifying tag on animal (nexttag) | |
|
100
|
INTERACTION_ORDER | NUMBER | Number denoting the order of the interaction. | |
|
100
|
LENGTH | NUMBER | Length of animal tagged based on the lengthunit, lengthtype, and lengthdet. | |
|
100
|
LENGTHUNIT | VARCHAR2 | Length Units | |
|
100
|
LENGTHTYPE | VARCHAR2 | Type Of Length Measurment Taken | |
|
100
|
LENGTHDET | VARCHAR2 | How Length Was Measurment was determined | |
|
100
|
WEIGHT | NUMBER | Weight of an animal tagged, based upon weightunit, weighttype and weightdet. | |
|
100
|
WEIGHTUNIT | VARCHAR2 | Weight Units | |
|
100
|
WEIGHTTYPE | VARCHAR2 | Type Of Weight Mesurment Taken | |
|
100
|
WEIGHTDET | VARCHAR2 | How weight measurement was determined | |
|
100
|
LATITUDE | NUMBER | Numeric value for the latitude of the tagging location. | |
|
100
|
LONGITUDE | NUMBER | Numeric value the the longitude of the tagging location. | |
|
100
|
STAT_ZONE_ID | NUMBER | Code to indciate State Zone | |
|
100
|
COUNTRY_ID | VARCHAR2 | Cde to indicate Country | |
|
100
|
STATE_ID | VARCHAR2 | Code to indicate state | |
|
100
|
WATER_BODY_ID | NUMBER | Code to Indicate waterbody of where tagging took place | |
|
100
|
PLACE_ID | VARCHAR2 | Code to indicate place of wheer tagging took palce | |
|
100
|
GEAR_ID | VARCHAR2 | Code for gear used to catch the animal. | |
|
100
|
BAIT_TYPE | VARCHAR2 | Code for bait used: (A)rtificial, (L)ive, (D)ead, (U)nknown | |
|
100
|
METHOD_ID | NUMBER | Code To indicate tagging methodology Used | |
|
100
|
SAMPLE_ID | NUMBER | Code to indicate Sampling Methodology | |
|
100
|
CAPTAIN_AGENCY | VARCHAR2 | COde to indicate agency which assigned angler code for boat captain | |
|
100
|
CAPTAIN_ID | NUMBER | Unique numeric code assigned to an individual captain. Must be greater than zero or -99999. | |
|
100
|
TAGGER_INITIALS | VARCHAR2 | Initials Of Taggers | |
|
100
|
TAGGER_TYPE | VARCHAR2 | Code to indicate the type of tagger that tagged this animal | |
|
100
|
TAGGER_AFFILIATION | VARCHAR2 | Code Of Agency that is affiliated With The Tagger | |
|
100
|
VESSEL_AGENCY | VARCHAR2 | Agency For Vessel COode | |
|
100
|
VESSEL_ID | NUMBER | Agency supplied code identifying the vessel involved in the release or recapture of the animal. | |
|
100
|
PHYSICAL_DATA_ID | NUMBER | Physical Data Identification Number | |
|
100
|
NOTES | NUMBER | Any Other Notes On Tagging | |
|
100
|
FIGHTHRS | NUMBER | Whole Number Of houirs spent landing The animal | |
|
100
|
FIGHTMINS | NUMBER | Number Of minutes (up to 59) landing the animal | |
|
100
|
ANGLER_AGENCY_ID | VARCHAR2 | Agency Id associated with the angler number is | |
|
100
|
ANGLER_ID | NUMBER | Unique identifier for each person in the database. | |
|
100
|
ID | NUMBER | Identifies Ang;er | |
|
100
|
DATE_ENTERED | VARCHAR2 | The date the data was entered. | |
|
100
|
SPECIES_ID | VARCHAR2 | Species Code | |
|
100
|
SEX | VARCHAR2 | Code to indicate sex of the animal |
Attribute Details
ANIMAL_ID
CC ID: 25783
| 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 |
AGENCY_ID
CC ID: 25786
| Seq. Order: | 2 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Code to Indicate Tagging agency of identifying tag on animal (tag1) |
| General Data Type: | VARCHAR2 |
TAG_ID
CC ID: 25814
| Seq. Order: | 3 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 8 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Tagnumber |
| General Data Type: | VARCHAR2 |
EVENT_ID
CC ID: 25793
| Seq. Order: | 4 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | Yes |
| Primary Key: | No |
| Precision: | 2 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Code to identify tagging event |
| General Data Type: | NUMBER |
TAG_DATE
CC ID: 25788
| Seq. Order: | 5 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 10 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Date animal was released or recaptured. |
| General Data Type: | VARCHAR2 |
TAGDATE
CC ID: 25824
| Seq. Order: | 6 |
|---|---|
| Data Storage Type: | DATE |
| Max Length: | 7 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Date Animal Was Tagged |
| General Data Type: | DATE |
NEXT_TAG_AGENCY_ID
CC ID: 25811
| Seq. Order: | 7 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Agency Id associated with value in the nexttag column |
| General Data Type: | VARCHAR2 |
NEXT_TAG_ID
CC ID: 25813
| Seq. Order: | 8 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 8 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Code to Indicate Tagging agency of identifying tag on animal (nexttag) |
| General Data Type: | VARCHAR2 |
INTERACTION_ORDER
CC ID: 25823
| Seq. Order: | 9 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | Yes |
| Primary Key: | No |
| Precision: | 2 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Number denoting the order of the interaction. |
| General Data Type: | NUMBER |
LENGTH
CC ID: 25806
| Seq. Order: | 10 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 4 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Length of animal tagged based on the lengthunit, lengthtype, and lengthdet. |
| General Data Type: | NUMBER |
LENGTHUNIT
CC ID: 25807
| Seq. Order: | 11 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Length Units |
| General Data Type: | VARCHAR2 |
LENGTHTYPE
CC ID: 25791
| Seq. Order: | 12 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Type Of Length Measurment Taken |
| General Data Type: | VARCHAR2 |
LENGTHDET
CC ID: 25790
| Seq. Order: | 13 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
How Length Was Measurment was determined |
| General Data Type: | VARCHAR2 |
WEIGHT
CC ID: 25809
| Seq. Order: | 14 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 6 |
| Scale: | 2 |
| Status: | Active |
| Description: |
Weight of an animal tagged, based upon weightunit, weighttype and weightdet. |
| General Data Type: | NUMBER |
WEIGHTUNIT
CC ID: 25822
| Seq. Order: | 15 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Weight Units |
| General Data Type: | VARCHAR2 |
WEIGHTTYPE
CC ID: 25805
| Seq. Order: | 16 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Type Of Weight Mesurment Taken |
| General Data Type: | VARCHAR2 |
WEIGHTDET
CC ID: 25808
| Seq. Order: | 17 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
How weight measurement was determined |
| General Data Type: | VARCHAR2 |
LATITUDE
CC ID: 25815
| Seq. Order: | 18 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 30 |
| Scale: | 16 |
| Status: | Active |
| Description: |
Numeric value for the latitude of the tagging location. |
| General Data Type: | NUMBER |
LONGITUDE
CC ID: 25804
| Seq. Order: | 19 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 30 |
| Scale: | 16 |
| Status: | Active |
| Description: |
Numeric value the the longitude of the tagging location. |
| General Data Type: | NUMBER |
STAT_ZONE_ID
CC ID: 25792
| Seq. Order: | 20 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 4 |
| Scale: | 1 |
| Status: | Active |
| Description: |
Code to indciate State Zone |
| General Data Type: | NUMBER |
COUNTRY_ID
CC ID: 25821
| Seq. Order: | 21 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Cde to indicate Country |
| General Data Type: | VARCHAR2 |
STATE_ID
CC ID: 25795
| Seq. Order: | 22 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Code to indicate state |
| General Data Type: | VARCHAR2 |
WATER_BODY_ID
CC ID: 25799
| Seq. Order: | 23 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 6 |
| Scale: | 3 |
| Status: | Active |
| Description: |
Code to Indicate waterbody of where tagging took place |
| General Data Type: | NUMBER |
PLACE_ID
CC ID: 25826
| Seq. Order: | 24 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Code to indicate place of wheer tagging took palce |
| General Data Type: | VARCHAR2 |
GEAR_ID
CC ID: 25816
| Seq. Order: | 25 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Code for gear used to catch the animal. |
| General Data Type: | VARCHAR2 |
BAIT_TYPE
CC ID: 25819
| Seq. Order: | 26 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Code for bait used: (A)rtificial, (L)ive, (D)ead, (U)nknown |
| General Data Type: | VARCHAR2 |
METHOD_ID
CC ID: 25802
| Seq. Order: | 27 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 6 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Code To indicate tagging methodology Used |
| General Data Type: | NUMBER |
SAMPLE_ID
CC ID: 25798
| 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 Sampling Methodology |
| General Data Type: | NUMBER |
CAPTAIN_AGENCY
CC ID: 25787
| Seq. Order: | 29 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
COde to indicate agency which assigned angler code for boat captain |
| General Data Type: | VARCHAR2 |
CAPTAIN_ID
CC ID: 25820
| Seq. Order: | 30 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 6 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Unique numeric code assigned to an individual captain. Must be greater than zero or -99999. |
| General Data Type: | NUMBER |
TAGGER_INITIALS
CC ID: 25812
| Seq. Order: | 31 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Initials Of Taggers |
| General Data Type: | VARCHAR2 |
TAGGER_TYPE
CC ID: 25789
| Seq. Order: | 32 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Code to indicate the type of tagger that tagged this animal |
| General Data Type: | VARCHAR2 |
TAGGER_AFFILIATION
CC ID: 25797
| Seq. Order: | 33 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Code Of Agency that is affiliated With The Tagger |
| General Data Type: | VARCHAR2 |
VESSEL_AGENCY
CC ID: 25782
| Seq. Order: | 34 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Agency For Vessel COode |
| General Data Type: | VARCHAR2 |
VESSEL_ID
CC ID: 25817
| Seq. Order: | 35 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 6 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Agency supplied code identifying the vessel involved in the release or recapture of the animal. |
| General Data Type: | NUMBER |
PHYSICAL_DATA_ID
CC ID: 25785
| Seq. Order: | 36 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 6 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Physical Data Identification Number |
| General Data Type: | NUMBER |
NOTES
CC ID: 25794
| Seq. Order: | 37 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 3 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Any Other Notes On Tagging |
| General Data Type: | NUMBER |
FIGHTHRS
CC ID: 25810
| Seq. Order: | 38 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 2 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Whole Number Of houirs spent landing The animal |
| General Data Type: | NUMBER |
FIGHTMINS
CC ID: 25818
| Seq. Order: | 39 |
|---|---|
| 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) landing the animal |
| General Data Type: | NUMBER |
ANGLER_AGENCY_ID
CC ID: 25803
| Seq. Order: | 40 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Agency Id associated with the angler number is |
| General Data Type: | VARCHAR2 |
ANGLER_ID
CC ID: 25801
| Seq. Order: | 41 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 6 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Unique identifier for each person in the database. |
| General Data Type: | NUMBER |
ID
CC ID: 25784
| Seq. Order: | 42 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | Yes |
| Primary Key: | No |
| Precision: | 38 |
| Status: | Active |
| Description: |
Identifies Ang;er |
| General Data Type: | NUMBER |
DATE_ENTERED
CC ID: 25800
| Seq. Order: | 43 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 10 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
The date the data was entered. |
| General Data Type: | VARCHAR2 |
SPECIES_ID
CC ID: 25825
| Seq. Order: | 44 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Species Code |
| General Data Type: | VARCHAR2 |
SEX
CC ID: 25796
| Seq. Order: | 45 |
|---|---|
| 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 |
Catalog Details
| Catalog Item ID: | 7048 |
|---|---|
| GUID: | gov.noaa.nmfs.inport:7048 |
| Metadata Record Created By: | Lee M Weinberger |
| Metadata Record Created: | 2008-02-22 12:10+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 |