5453
Cooperative Tagging Center (CTC)
Cooperative Tagging Data
Data Set
Published / External
1946
Cooperative Tagging System
Project
In Work
The Cooperative Tagging Center (CTC) began as the Cooperative Game Fish Tagging Program (GTP) at Woods Hole Oceanographic Institute (WHOI) in 1954. The GTP was started by Dr. Frank J. Mather III with an initial focus on bluefin tuna. The program quickly expanded to include billfish in 1973 and became a joint effort between the National Marine Fisheries Service (NMFS) and WHOI. In 1980 the Miami Laboratory of the NMFSs Southeast Fisheries Science Center (SEFSC) took complete responsibility for the operation, funding, and maintenance of the GTP (CTC History). In 1992 the SEFSC changed the program name to the CTC due to an increase in tagging efforts for a wider variety of species, as well as an increase in tagging research needs and requests for tagging data. Constituents have tagged over 270,000 fish of nearly 80 different species, however, today the CTC focuses solely on the tagging of billfish and tuna in the Atlantic Ocean, Gulf of Mexico, and Caribbean Sea.
The purpose of the data set is to examine movement patterns of highly migratorty fish species. The data set is also useful for estimating mortality rates and determining species longevity. The dataset is provided to The International Commission for the Conservation of Atlantic Tunas on a yearly basis and is used for species stock assessments.
The majority of data is on highly migratory species such as billfish and tuna, however there is data on nearly 80 species
Theme
Fisheries-Independent Data
Theme
Tagging
Theme
Tuna
Theme
anglers
Theme
billfish
Theme
fishery-dependent
Theme
gear
Theme
marlin
Theme
swordfish
Theme
waterbody
Temporal
1940-present
Spatial
Atlantic Ocean
Spatial
Caribbean
Spatial
Gulf Of Mexico
Spatial
mediterarean
Spatial
pacific
Southeast Fisheries Science Center
Miami
FL
USA
Location Of The Main Office Of The South East Fisheries Science Center
Data Set
Database
As Needed
Table (digital)
Entities May Be Oracle Tables and/or Oracle Views.
N/A
N/A
N/A
7022
View: CHECKTRANMISSIONS
CHECKTRANMISSIONS
Published / External
Completed
View Of information about depl;oyed archival tags
Loaded by batch 2083, 02-22-2008 12:10
Data View
Yes
CTSPAT
View Of information about depl;oyed archival tags
1
ARGOS_PTT_ID
VARCHAR2
10
Yes
No
Active
Link to ARGOS Table
VARCHAR2
2
ARCHIVAL_TAG_ID
VARCHAR2
10
Yes
No
Active
Archival Tagnumber
VARCHAR2
3
FIRST_TRANSMISSION
VARCHAR2
10
No
No
Active
First Transmission Date
VARCHAR2
4
LAST_TRANSMISSION
VARCHAR2
10
No
No
Active
Last transmission Dare
VARCHAR2
5
TRANSMISSIONS
NUMBER
22
No
No
38
Active
Numner Of transmissions
NUMBER
6
DAYS_TRANSMITTING
NUMBER
22
No
No
38
Active
Number of days transmitting
NUMBER
7
DEPLOYMENT_DATE
VARCHAR2
10
No
No
Active
Date Deployed
VARCHAR2
8
POP_OFF_DATE
VARCHAR2
10
No
No
Active
Date tagged poped off
VARCHAR2
9
DEPLOYMENT_LATITUDE
VARCHAR2
7
No
No
Active
Deployment Latitude
VARCHAR2
10
DEPLOYMENT_LONGITUDE
VARCHAR2
7
No
No
Active
Deployment Longitude
VARCHAR2
11
PAT_NAME
VARCHAR2
50
No
No
Active
Name Of Archival tag series
VARCHAR2
7023
View: CHECK_TRANSMISSIONS
CHECK_TRANSMISSIONS
Published / External
Completed
Table listing information about archival tags by principal investigators
Loaded by batch 2083, 02-22-2008 12:10
Data View
Yes
CTSPAT
Table listing information about archival tags by principal investigators
1
INVESTIGATOR
VARCHAR2
100
No
No
Active
Name of Investigator
VARCHAR2
2
ARGOS_PTT_ID
VARCHAR2
10
Yes
No
Active
Link to Argos table
VARCHAR2
3
ARCHIVAL_TAG_ID
VARCHAR2
10
Yes
No
Active
Archival Tag Number
VARCHAR2
4
PAT_NAME
VARCHAR2
50
No
No
Active
Name Of Popup Archival Tag
VARCHAR2
5
FIRST_TRANSMISSION
DATE
7
No
No
Active
Date Of First transmission
DATE
6
LAST_TRANSMISSION
DATE
7
No
No
Active
Date Of Last transmission
DATE
7
TRANSMISSIONS
NUMBER
22
No
No
38
Active
Number Of transmission
NUMBER
8
DAYS_TRANSMITTING
NUMBER
22
No
No
38
Active
Number Of Days Tag was transmitting information
NUMBER
9
DEPLOYMENT_DATE
DATE
7
No
No
Active
Date tag was deployed
DATE
10
POP_OFF_DATE
DATE
7
No
No
Active
Date popoff archival tag popped off
DATE
11
DEPLOYMENT_LATITUDE
NUMBER
22
No
No
38
Active
Latitude Of tag deployment
NUMBER
12
DEPLOYMENT_LONGITUDE
NUMBER
22
No
No
38
Active
Longitude Of tag deployment
NUMBER
7024
Table: CTS_ADDRESS_LOCATIONS
CTS_ADDRESS_LOCATIONS
Published / External
Completed
Code Table Listing Location Codes and their descriptions
Loaded by batch 2083, 02-22-2008 12:10
Data Table
Yes
CTSPAT
Code Table Listing Location Codes and their descriptions
1
LOCATION_CODE
NUMBER
22
Yes
No
38
Active
Location Code
NUMBER
2
LOCATION_DESCRIPTION
VARCHAR2
50
No
No
Active
Description Of Location
VARCHAR2
7025
Table: CTS_ADDRESS_STATUS
CTS_ADDRESS_STATUS
Published / External
Completed
Code Table Listing Status Codes and their descriptions
Loaded by batch 2083, 02-22-2008 12:10
Data Table
Yes
CTSPAT
Code Table Listing Status Codes and their descriptions
1
STATUS_CODE
NUMBER
22
Yes
No
38
Active
Status Code
NUMBER
2
STATUS_DESCRIPTION
VARCHAR2
50
No
No
Active
Status description
VARCHAR2
7026
Table: CTS_AGENCIES
CTS_AGENCIES
Published / External
Completed
Table Of Valid Agencies/Organizations
Loaded by batch 2083, 02-22-2008 12:10
Data Table
Yes
CTSPAT
Table Of Valid Agencies/Organizations
1
AGENCY_ID
VARCHAR2
3
Yes
Yes
Active
The three character agency code.
VARCHAR2
2
NAME
VARCHAR2
50
No
No
Active
The agency name.
VARCHAR2
3
ADDRESS_1
VARCHAR2
100
No
No
Active
First Line Of Agency Address
VARCHAR2
4
ADDRESS_2
VARCHAR2
100
No
No
Active
Second line of agency address.
VARCHAR2
5
ADDRESS_3
VARCHAR2
100
No
No
Active
Third line of agency address.
VARCHAR2
6
ADDRESS_4
VARCHAR2
100
No
No
Active
Fourth line of agency address.
VARCHAR2
7
CONTACT_NAME
VARCHAR2
50
No
No
Active
The person who can answer questions about this agency's data.
VARCHAR2
8
CONTACT_PHONE
VARCHAR2
13
No
No
Active
The agency phone number.
VARCHAR2
7027
Table: CTS_ANGLERS
CTS_ANGLERS
Published / External
Completed
CTSPAT.CTS_ANGLERS tells who released or recaptured an animal.Each angler is identified by a unique 1 to 6 digit number assigned bytheir agency.
Loaded by batch 2083, 02-22-2008 12:10
Data Table
Yes
CTSPAT
CTSPAT.CTS_ANGLERS tells who released or recaptured an animal.Each angler is identified by a unique 1 to 6 digit number assigned bytheir agency.
1
AGENCY_ID
VARCHAR2
3
Yes
Yes
Active
Code for the agency assigning angler codes.
VARCHAR2
2
ANGLER_ID
NUMBER
22
Yes
Yes
6
0
Active
Unique numeric code assigned to an individual angler. Must be greater than zero.
NUMBER
3
TITLE
VARCHAR2
30
No
No
Active
The title or salutation for greeting this angler when letters are sent.
VARCHAR2
4
FNAME
VARCHAR2
30
No
No
Active
The angler's first name.
VARCHAR2
5
M_INITIAL
VARCHAR2
1
No
No
Active
The angler's middle initial.
VARCHAR2
6
LNAME
VARCHAR2
30
Yes
No
Active
The angler's last name.
VARCHAR2
7
SUFFIX
VARCHAR2
20
No
No
Active
The suffix such as Jr. or Sr. for an angler.
VARCHAR2
8
ADDRESS_1
VARCHAR2
50
No
No
Active
The first line of the angler's address.
VARCHAR2
9
ADDRESS_2
VARCHAR2
30
No
No
Active
The second line of the angler's address.
VARCHAR2
10
CITY
VARCHAR2
30
Yes
No
Active
City where angler receives mail.
VARCHAR2
11
STATE_ID
VARCHAR2
30
No
No
Active
U.S. state where angler receives mail. Not allowed for a foreign address.
VARCHAR2
12
ZIPCODE
VARCHAR2
10
No
No
Active
The angler's zip code.
VARCHAR2
13
COUNTRY_ID
VARCHAR2
30
No
No
Active
Country where angler receives mail.
VARCHAR2
14
HOME_NUMBER
VARCHAR2
30
No
No
Active
The angler's home phone number.
VARCHAR2
15
WORK_NUMBER
VARCHAR2
30
No
No
Active
The angler's work phone number.
VARCHAR2
16
MOBILE_NUMBER
VARCHAR2
30
No
No
Active
The angler's mobilephone number.
VARCHAR2
17
FAX_NUMBER
VARCHAR2
30
No
No
Active
The angler's facsimile phone number.
VARCHAR2
18
EMAIL
VARCHAR2
50
No
No
Active
The angler's email address
VARCHAR2
19
NOTES
NUMBER
22
No
No
3
0
Active
The number for a note on the angler.
NUMBER
20
EDITCYC
NUMBER
22
No
No
2
0
Active
A control field, (0) indicates an add, (1) indicates an update. Once updated, records are stored with a value of 0 in this field.
NUMBER
7028
View: CTS_ANGLERS_V
CTS_ANGLERS_V
Published / External
Completed
View Of Anglers with decodes
Loaded by batch 2083, 02-22-2008 12:10
Data View
Yes
CTSPAT
View Of Anglers with decodes
1
ANGLER_ID
NUMBER
22
Yes
No
6
0
Active
Unique numeric code assigned to an individual angler. Must be greater than zero.
NUMBER
2
AGENCY_ID
VARCHAR2
3
Yes
No
Active
Code for the agency assigning angler codes.
VARCHAR2
3
AGENCY_NAME
VARCHAR2
50
No
No
Active
Agency Name Corresponding To Agency ID
VARCHAR2
4
FNAME
VARCHAR2
30
No
No
Active
The angler's first name.
VARCHAR2
5
M_INITIAL
VARCHAR2
1
No
No
Active
The angler's middle initial.
VARCHAR2
6
LNAME
VARCHAR2
30
Yes
No
Active
The angler's last name.
VARCHAR2
7
TITLE
VARCHAR2
30
No
No
Active
The title or salutation for greeting this angler when letters are sent.
VARCHAR2
8
SUFFIX
VARCHAR2
20
No
No
Active
The suffix such as Jr. or Sr. for an angler.
VARCHAR2
9
ADDRESS_1
VARCHAR2
50
No
No
Active
The first line of the angler's address.
VARCHAR2
10
ADDRESS_2
VARCHAR2
30
No
No
Active
The second line of the angler's address.
VARCHAR2
11
CITY
VARCHAR2
30
Yes
No
Active
City where angler receives mail.
VARCHAR2
12
STATE_ID
VARCHAR2
30
No
No
Active
U.S. state where angler receives mail. Not allowed for a foreign address.
VARCHAR2
13
STATE_NAME
VARCHAR2
30
No
No
Active
State Name COrresponding to State Code
VARCHAR2
14
COUNTRY_ID
VARCHAR2
30
No
No
Active
Country where angler receives mail.
VARCHAR2
15
COUNTRY_NAME
VARCHAR2
50
No
No
Active
Country Name Corresponding to Country Code
VARCHAR2
16
ZIPCODE
VARCHAR2
10
No
No
Active
The angler's zip code.
VARCHAR2
17
HOME_NUMBER
VARCHAR2
30
No
No
Active
The angler's home phone number.
VARCHAR2
18
WORK_NUMBER
VARCHAR2
30
No
No
Active
The angler's work phone number.
VARCHAR2
19
MOBILE_NUMBER
VARCHAR2
30
No
No
Active
The angler's mobilephone number.
VARCHAR2
20
FAX_NUMBER
VARCHAR2
30
No
No
Active
The angler's facsimile phone number.
VARCHAR2
21
EMAIL
VARCHAR2
50
No
No
Active
The angler's email address
VARCHAR2
22
NOTES
NUMBER
22
No
No
3
0
Active
The number for a note on the angler.
NUMBER
23
NOTE_DESCRIPTION
VARCHAR2
50
No
No
Active
Description Of Note Code
VARCHAR2
7029
Table: CTS_ANGLER_NOTES
CTS_ANGLER_NOTES
Published / External
Completed
Code Table Listing Possible Notes
Loaded by batch 2083, 02-22-2008 12:10
Data Table
Yes
CTSPAT
Code Table Listing Possible Notes
1
NOTE_ID
NUMBER
22
Yes
No
38
Active
Numeric Note Code
NUMBER
2
NOTE_DESCRIPTION
VARCHAR2
50
No
No
Active
Description associated With Code
VARCHAR2
7030
Table: CTS_ANIMALS
CTS_ANIMALS
Published / External
Completed
Table Of Animals
Loaded by batch 2083, 02-22-2008 12:10
Data Table
Yes
CTSPAT
Table Of Animals
1
ANIMAL_ID
NUMBER
22
Yes
Yes
10
0
Active
Sequential Key
NUMBER
2
SPECIES_ID
VARCHAR2
3
Yes
No
Active
Species Of Animal
VARCHAR2
3
SEX
VARCHAR2
1
No
No
Active
Sex Of Animal
VARCHAR2
4
GEOM
SDO_GEOMETRY
1
No
No
Active
Geospacial Component Of Record
SDO_GEOMETRY
7031
View: CTS_ANIMALS_SEARCH_V
CTS_ANIMALS_SEARCH_V
Published / External
Completed
View Of animal with species and sex decoded which is a result of a search
Loaded by batch 2083, 02-22-2008 12:10
Data View
Yes
CTSPAT
View Of animal with species and sex decoded which is a result of a search
1
ANIMAL_ID
NUMBER
22
Yes
No
10
0
Active
Sequential Key / Link To CTS_INTERACTION Record
NUMBER
2
SPECIES_ID
VARCHAR2
3
Yes
No
Active
Species Code
VARCHAR2
3
SPECIES_NAME
VARCHAR2
21
No
No
Active
Common Name
VARCHAR2
4
SEX
VARCHAR2
1
No
No
Active
Code To Indicate Sex Of Animal
VARCHAR2
5
SEX_DESCRIPTION
VARCHAR2
10
Yes
No
Active
Decode Of Code To Indicate Sez Of Animal
VARCHAR2
7032
View: CTS_ANIMALS_V
CTS_ANIMALS_V
Published / External
Completed
View Of animal with species and sex decoded
Loaded by batch 2083, 02-22-2008 12:10
Data View
Yes
CTSPAT
View Of animal with species and sex decoded
1
ANIMAL_ID
NUMBER
22
Yes
No
10
0
Active
Sequential Key / Link To CTS_INTERACTION Record
NUMBER
2
SPECIES_ID
VARCHAR2
3
Yes
No
Active
Species Code
VARCHAR2
3
SPECIES_NAME
VARCHAR2
21
No
No
Active
Common Name
VARCHAR2
4
SEX
VARCHAR2
1
No
No
Active
Code To Indicate Sex Of Animal
VARCHAR2
5
SEX_DESCRIPTION
VARCHAR2
10
Yes
No
Active
Decode Of Code To Indicate Sez Of Animal
VARCHAR2
7033
Table: CTS_ANIMAL_NOTES
CTS_ANIMAL_NOTES
Published / External
Completed
Table Of Valid Notes Describing Animal Condition at Tagging
Loaded by batch 2083, 02-22-2008 12:10
Data Table
Yes
CTSPAT
Table Of Valid Notes Describing Animal Condition at Tagging
1
NOTE_ID
NUMBER
22
Yes
No
38
Active
Note Cpde
NUMBER
2
NOTE_DESCRIPTION
VARCHAR2
50
No
No
Active
Code Description
VARCHAR2
7034
Table: CTS_ARGOS
CTS_ARGOS
Published / External
Completed
Table Of Transmission Records Of Archival Tags
Loaded by batch 2083, 02-22-2008 12:10
Data Table
Yes
CTSPAT
Table Of Transmission Records Of Archival Tags
1
ARGOS_PTT_ID
VARCHAR2
10
Yes
No
Active
The unique PTT id of the transmitter used by the Argos Satellite Transmission Service provider.
VARCHAR2
2
TRANSMISSION_DATE
DATE
7
Yes
No
Active
Date Information Was Transmitted (Just the information to the date level)
DATE
3
TRANSMISSION_TIME
VARCHAR2
10
Yes
No
Active
Transmitted (Just the information to the time level)
VARCHAR2
4
LOCATION_CODE
VARCHAR2
3
No
No
Active
Location Code
VARCHAR2
5
X_QUALITY_INDICATOR
NUMBER
22
No
No
38
Active
Characterizes the residual error on the frequency calculation. 0 means the residual error is not calculated, 6 means the error is less than 0.15 Hz. .
NUMBER
6
Y_QUALITY_INDICATOR
NUMBER
22
No
No
1
0
Active
Concerns the medium-term oscillator drift between two satellite passes. 0 means the results are more than 12 hours apart, 8 means that the drift is less than 0.2 Hz/minute.
NUMBER
7
X1_COORD
NUMBER
22
No
No
11
6
Active
First longitude value given by the Argos Satellite to identify the possible location of the transmitter during transmission.
NUMBER
8
Y1_COORD
NUMBER
22
No
No
11
6
Active
First latitude value given by the Argos Satellite to identify the possible location of the transmitter during transmission.
NUMBER
9
X2_COORD
NUMBER
22
No
No
11
6
Active
Second longitude value given by the Argos Satellite to identify the possible location of the transmitter during transmission.
NUMBER
10
Y2_COORD
NUMBER
22
No
No
11
6
Active
Second longitude value given by the Argos Satellite to identify the possible location of the transmitter during transmission.
NUMBER
11
MESSAGE_COUNT
NUMBER
22
No
No
38
0
Active
Number of messages send during the transmission.
NUMBER
12
ARCHIVAL_TAG_ID
VARCHAR2
10
No
No
Active
Archival Tag ID provided by the manufacturer.
VARCHAR2
13
ID
NUMBER
22
Yes
Yes
38
Active
Sequential Key
NUMBER
7035
View: CTS_ARGOS_COUNT_V
CTS_ARGOS_COUNT_V
Published / External
Completed
List Of Archival Tags and the number of messages recieved per that tag
Loaded by batch 2083, 02-22-2008 12:10
Data View
Yes
CTSPAT
List Of Archival Tags and the number of messages recieved per that tag
1
ARCHIVAL_TAG_ID
VARCHAR2
10
No
No
Active
Archival Tag Id
VARCHAR2
2
MESSAGES
NUMBER
22
No
No
38
Active
Number Of Messages
NUMBER
7036
Table: CTS_BAIT_TYPES
CTS_BAIT_TYPES
Published / External
Completed
Table Of Valid Bait Types Used while fishing
Loaded by batch 2083, 02-22-2008 12:10
Data Table
Yes
CTSPAT
Table Of Valid Bait Types Used while fishing
1
BAIT_TYPE
VARCHAR2
50
No
No
Active
Bait Type Description
VARCHAR2
2
BAIT_ID
VARCHAR2
1
No
No
Active
Code Associated WIth Bait Type
VARCHAR2
7037
Table: CTS_BLEEDING
CTS_BLEEDING
Published / External
Completed
Table Of Valid Bleeding Levels
Loaded by batch 2083, 02-22-2008 12:10
Data Table
Yes
CTSPAT
Table Of Valid Bleeding Levels
1
BLEEDING_LEVELS
VARCHAR2
20
No
No
Active
Bleeding Level
VARCHAR2
7038
Table: CTS_COLORS
CTS_COLORS
Published / External
Completed
Table of Valid Tag Colors
Loaded by batch 2083, 02-22-2008 12:10
Data Table
Yes
CTSPAT
Table of Valid Tag Colors
1
COLOR_ID
VARCHAR2
3
Yes
No
Active
Mnemonic Color Code
VARCHAR2
2
COLOR_DESCRIPTION
VARCHAR2
50
No
No
Active
Code Description
VARCHAR2
7039
Table: CTS_COUNTRIES
CTS_COUNTRIES
Published / External
Completed
Table Of Valid Country Codes
Loaded by batch 2083, 02-22-2008 12:10
Data Table
Yes
CTSPAT
Table Of Valid Country Codes
1
COUNTRY_ID
VARCHAR2
2
Yes
Yes
Active
The 3 character country code.
VARCHAR2
2
COUNTRY_NAME
VARCHAR2
50
No
No
Active
The country name.
VARCHAR2
7040
Table: CTS_DISTRIBUTED_TAGS
CTS_DISTRIBUTED_TAGS
Published / External
Completed
CTS.CTS_DISTRIBUTED_TAGS describes what tags were issued to individual anglersand what rewards were paid for recovering tags.
Loaded by batch 2083, 02-22-2008 12:10
Data Table
Yes
CTSPAT
CTS.CTS_DISTRIBUTED_TAGS describes what tags were issued to individual anglersand what rewards were paid for recovering tags.
1
AGENCY_ID
VARCHAR2
5
Yes
Yes
Active
Code for agency assigning the tags.
VARCHAR2
2
TAG_TYPE_ID
VARCHAR2
3
Yes
Yes
Active
Key to Type Of Tag
VARCHAR2
3
BEGINTAG
VARCHAR2
8
Yes
Yes
Active
Lowest tag number of a set of consecutive tags assigned to an angler.
VARCHAR2
4
ENDTAG
VARCHAR2
8
Yes
No
Active
Highest tag number of a set of consecutive tags assigned to an angler. Format: aannnnnn where: aa = tag prefix. (must be same as BEGINTAG) nnnnnn = tag number. (must be = > than BEGINTAG nnnnnn)
VARCHAR2
5
FIRST_COLOR
VARCHAR2
3
No
No
Active
First Color On Tag
VARCHAR2
6
SECOND_COLOR
VARCHAR2
3
No
No
Active
Second Color On Tag
VARCHAR2
7
LENGTH_CM
NUMBER
22
No
No
38
Active
Tag Length In Centimeters
NUMBER
8
RECEIVING_AGENCY_ID
VARCHAR2
3
No
No
Active
Code for agency receiving the set of tags. (Required if ANGLER is .99999)
VARCHAR2
9
RETURN_ADDRESS_ID
NUMBER
22
Yes
No
2
0
Active
Address code where tags should be returned.
NUMBER
10
TAGS_ASSIGNED
VARCHAR2
1
No
No
Active
Flag to indicate if this set has been assigned to an angler. Options: Y-yes, N-no, U-unknown.
VARCHAR2
11
TAGS_ASSIGNED_DATE
DATE
7
No
No
Active
Date set of tags were assigned. (Required if ASSIGNED = Yes) Format: mm/dd/yy
DATE
12
ANGLER_AGENCY_ID
VARCHAR2
5
No
No
Active
Angler code of angler assigned the set of tags. (Required if RECEIVAGE is blank)
VARCHAR2
13
ANGLER_ID
NUMBER
22
No
No
38
Active
Name of angler, agency, or party assigned the set of tags.
NUMBER
14
KIT_SENT
VARCHAR2
1
No
No
Active
Flag indicating if complete kit was sent to party receiving tags. Options: Y-yes, N-no. U-unknown
VARCHAR2
15
REPLY_DATE
DATE
7
No
No
Active
Date reply acknowledgement was received.
DATE
16
REWARD_AMOUNT
NUMBER
22
No
No
6
2
Active
Whole dollar amount of the reward sent for the return of the tag. Where: nnn = 0 to 998 Or 999 for non-monetary incentive offered, i.e. hats, t-shirts, flags.
NUMBER
17
AV_EDITCYC
NUMBER
22
No
No
2
0
Active
A control field, (0) indicates an add, (1) indicates an update. Once updated, records are stored with a value of 0 in this field.
NUMBER
18
AV_EDITDAT
DATE
7
No
No
Active
The date the record was initially entered, or last updated, whichever is later.
DATE
19
AV_DELEDAT
DATE
7
No
No
Active
A control field used to delete existing records from this table. No records are stored with a value in this field.
DATE
7041
Table: CTS_EVENTS
CTS_EVENTS
Published / External
Completed
Table Of Valid Tagging Events
Loaded by batch 2083, 02-22-2008 12:10
Data Table
Yes
CTSPAT
Table Of Valid Tagging Events
1
EVENT_ID
NUMBER
22
Yes
Yes
2
0
Active
The numeric code assigned to this event.
NUMBER
2
EVENT_DESCRIPTION
VARCHAR2
40
No
No
Active
The description of the event.
VARCHAR2
7042
Table: CTS_FISHING_METHODS
CTS_FISHING_METHODS
Published / External
Completed
Table Of Valid Fishing Methods
Loaded by batch 2083, 02-22-2008 12:10
Data Table
Yes
CTSPAT
Table Of Valid Fishing Methods
1
FISHING_METHOD
VARCHAR2
50
No
No
Active
Fishing Method
VARCHAR2
7043
Table: CTS_GEAR
CTS_GEAR
Published / External
Completed
Table Of Valid Gear Codes
Loaded by batch 2083, 02-22-2008 12:10
Data Table
Yes
CTSPAT
Table Of Valid Gear Codes
1
GEAR_ID
VARCHAR2
3
Yes
Yes
Active
The mnemonic code for the gear.
VARCHAR2
2
GEAR_NAME
VARCHAR2
25
No
No
Active
The description of the gear.
VARCHAR2
7044
Table: CTS_HOOK_LOCATIONS
CTS_HOOK_LOCATIONS
Published / External
Completed
Table of Valid Hook Locations
Loaded by batch 2083, 02-22-2008 12:10
Data Table
Yes
CTSPAT
Table of Valid Hook Locations
1
LOCATION
VARCHAR2
50
No
No
Active
Hook Location
VARCHAR2
7045
Table: CTS_HOOK_TYPES
CTS_HOOK_TYPES
Published / External
Completed
Table Of Valid Hook Types
Loaded by batch 2083, 02-22-2008 12:10
Data Table
Yes
CTSPAT
Table Of Valid Hook Types
1
HOOK_TYPE
VARCHAR2
50
No
No
Active
Type Of Hook Used
VARCHAR2
7046
Table: CTS_INTERACTIONS
CTS_INTERACTIONS
Published / External
Completed
Table Of All Tagging Interactions
Loaded by batch 2083, 02-22-2008 12:10
Data Table
Yes
CTSPAT
Table Of All Tagging Interactions
1
ANIMAL_ID
NUMBER
22
Yes
No
10
0
Active
Foreign Key to Animals Table
NUMBER
2
AGENCY_ID
VARCHAR2
3
Yes
No
Active
Identifies Agency/Organization That Issued The Tag
VARCHAR2
3
TAG_ID
VARCHAR2
8
Yes
No
Active
Initial tag number applied to an animal. It consists of a 2 or 3 letter prefix and a 5 or 6 digit number.
VARCHAR2
4
EVENT_ID
NUMBER
22
Yes
No
2
0
Active
A code indicating (1) release or (2) recapture.
NUMBER
5
TAG_DATE
DATE
7
Yes
No
Active
Date animal was released or recaptured.
DATE
6
NEXT_TAG_AGENCY_ID
VARCHAR2
3
No
No
Active
Indetifies Agency That Supplied The Next_tag_id for the animal
VARCHAR2
7
NEXT_TAG_ID
VARCHAR2
8
No
No
Active
Additional tag applied to another animal. Used if two or more tags are applied at the same time.
VARCHAR2
8
INTERACTION_ORDER
NUMBER
22
Yes
No
2
0
Active
Number denoting which tag on a multi-tagged animal.
NUMBER
9
LENGTH
NUMBER
22
No
No
4
0
Active
Length of animal tagged based on the lengthunit, lengthtype, and lengthdet.
NUMBER
10
LENGTHUNIT
VARCHAR2
2
No
No
Active
Length measurement used: (IN) inches, (FT) feet, (MM) millimeters, (M ) meters, (UN) unknown, (CM) centimeters
VARCHAR2
11
LENGTHTYPE
VARCHAR2
1
No
No
Active
Type of length measurement:(E)ye fork, (F)ork length, (L)ower jaw fork length, (S)tandard length, (T)otal length, (U)nknown length
VARCHAR2
12
LENGTHDET
VARCHAR2
1
No
No
Active
Method of determining length: (E)stimated, (M)easured, (U)nknown
VARCHAR2
13
WEIGHT
NUMBER
22
No
No
6
2
Active
Weight of an animal tagged, based upon weightunit, weighttype and weightdet.
NUMBER
14
WEIGHTUNIT
VARCHAR2
2
No
No
Active
Weight measurement used: (OZ) ounces, (LB) pounds, (GM) grams, (KG) Kilograms, (UN) Unknown
VARCHAR2
15
WEIGHTTYPE
VARCHAR2
1
No
No
Active
Weight measurement type: (R)ound, (D)ressed, (U)nknown
VARCHAR2
16
WEIGHTDET
VARCHAR2
1
No
No
Active
Method of determining weight: (E)stimated, (M)easured, (U)nknown.
VARCHAR2
17
LATITUDE
NUMBER
22
No
No
30
16
Active
Latitufe of location where Tagging operation was done
NUMBER
18
LONGITUDE
NUMBER
22
No
No
30
16
Active
Longitude of location where Tagging operation was done
NUMBER
19
STAT_ZONE_ID
NUMBER
22
No
No
4
1
Active
Statistical Zone Code where the release occurred. Gulf of Mexico 1.0 - 40.9, Caribbean 41.0 -75.0, Atlantic 630.0 - 751.0
NUMBER
20
COUNTRY_ID
VARCHAR2
2
No
No
Active
FIPS territorial Country Code where release/recapture occurred.
VARCHAR2
21
STATE_ID
VARCHAR2
2
No
No
Active
U.S. state code if Country is US.
VARCHAR2
22
WATER_BODY_ID
NUMBER
22
No
No
6
3
Active
Statistical Zone Code for an in shore bay, river or water body.
NUMBER
23
PLACE_ID
VARCHAR2
3
No
No
Active
Code identifying an unusual place where TAG1 was found.
VARCHAR2
24
GEAR_ID
VARCHAR2
3
No
No
Active
Code for gear used to catch the animal.
VARCHAR2
25
BAIT_TYPE
VARCHAR2
1
No
No
Active
Code for bait used: (A)rtificial, (L)ive, (D)ead, (U)nknown
VARCHAR2
26
METHOD_ID
NUMBER
22
No
No
6
0
Active
Code identifying a record in CTS_METHODS that contains the description of the methodology used in tagging this animal.
NUMBER
27
SAMPLE_ID
NUMBER
22
No
No
6
0
Active
Code identifying a record in CTS_SAMPLES describing this sample.
NUMBER
28
CAPTAIN_AGENCY
VARCHAR2
3
No
No
Active
Identifies Agency Associated With Captain_id
VARCHAR2
29
CAPTAIN_ID
NUMBER
22
No
No
6
0
Active
Unique numeric code assigned to an individual captain. Must be greater than zero or -99999.
NUMBER
30
TAGGER_INITIALS
VARCHAR2
3
No
No
Active
Initials of person attaching or removing a tag. 3 characters are required. Use X for any missing characters.
VARCHAR2
31
TAGGER_TYPE
VARCHAR2
1
No
No
Active
Classification of the person who releases or recaptures an animal. (C)ommercial fishermen, (N)mfs worker, (R)ecreational fisherman, (S)cientist, (U)nknown or missing.
VARCHAR2
32
TAGGER_AFFILIATION
VARCHAR2
3
No
No
Active
Code for the agency the tagging is affiliated with.
VARCHAR2
33
VESSEL_AGENCY
VARCHAR2
3
No
No
Active
Indentifies Agency That indicated vesseld code
VARCHAR2
34
VESSEL_ID
NUMBER
22
No
No
6
0
Active
Agency supplied code identifying the vessel involved in the release or recapture of the animal.
NUMBER
35
PHYSICAL_DATA_ID
NUMBER
22
No
No
6
0
Active
Code to identify a record in CTS_Environ describing the conditions at the release/recapture site.
NUMBER
36
NOTES
NUMBER
22
No
No
3
0
Active
Note code for the first message associated with this record.
NUMBER
37
FIGHTHRS
NUMBER
22
No
No
2
0
Active
The number of hours spent fighting the fish before it was tagged.
NUMBER
38
FIGHTMINS
NUMBER
22
No
No
2
0
Active
The minutes part of the time spent fighting the fish before it was tagged.
NUMBER
39
ANGLER_AGENCY_ID
VARCHAR2
3
No
No
Active
Identifies Agency Associated With Angler_id
VARCHAR2
40
ANGLER_ID
NUMBER
22
No
No
6
0
Active
Number Of Angler That Did The tagging
NUMBER
41
GEOM
SDO_GEOMETRY
1
No
No
Active
GIS component Of record
SDO_GEOMETRY
42
ID
NUMBER
22
Yes
Yes
38
Active
Sequential Key
NUMBER
43
DATE_ENTERED
DATE
7
No
No
Active
Date Record was entered into the system
DATE
7047
View: CTS_INTERACTIONS_EXTRACT_V
CTS_INTERACTIONS_EXTRACT_V
Published / External
Completed
View Of data starting with 01/01/2003
Loaded by batch 2083, 02-22-2008 12:10
Data View
Yes
CTSPAT
View Of data starting with 01/01/2003
1
ANIMAL_ID
NUMBER
22
Yes
No
10
0
Active
Key to Identifies Animal
NUMBER
2
AGENCY_ID
VARCHAR2
3
Yes
No
Active
Code to Indicate Tagging agency of identifying tag on animal (tag1)
VARCHAR2
3
AGENCY_NAME
VARCHAR2
50
No
No
Active
Agency Name
VARCHAR2
4
TAG_ID
VARCHAR2
8
Yes
No
Active
Tagnumber
VARCHAR2
5
EVENT_ID
NUMBER
22
Yes
No
2
0
Active
Code to identify tagging event
NUMBER
6
TAG_DATE
VARCHAR2
10
No
No
Active
Date animal was released or recaptured.
VARCHAR2
7
NEXT_TAG_AGENCY_ID
VARCHAR2
3
No
No
Active
Agency Id associated with value in the nexttag column
VARCHAR2
8
NEXT_TAG_ID
VARCHAR2
8
No
No
Active
Code to Indicate Tagging agency of identifying tag on animal (nexttag)
VARCHAR2
9
INTERACTION_ORDER
NUMBER
22
Yes
No
2
0
Active
Number denoting the order of the interaction.
NUMBER
10
LENGTH
NUMBER
22
No
No
4
0
Active
Length of animal tagged based on the lengthunit, lengthtype, and lengthdet.
NUMBER
11
LENGTHUNIT
VARCHAR2
2
No
No
Active
Length Units
VARCHAR2
12
LENGTHTYPE
VARCHAR2
1
No
No
Active
Type Of Length Measurment Taken
VARCHAR2
13
LENGTHDET
VARCHAR2
1
No
No
Active
How Length Was Measurment was determined
VARCHAR2
14
WEIGHT
NUMBER
22
No
No
6
2
Active
Weight of an animal tagged, based upon weightunit, weighttype and weightdet.
NUMBER
15
WEIGHTUNIT
VARCHAR2
2
No
No
Active
Weight Units
VARCHAR2
16
WEIGHTTYPE
VARCHAR2
1
No
No
Active
Type Of Weight Mesurment Taken
VARCHAR2
17
WEIGHTDET
VARCHAR2
1
No
No
Active
How weight measurement was determined
VARCHAR2
18
LATITUDE
NUMBER
22
No
No
30
16
Active
Numeric value for the latitude of the tagging location.
NUMBER
19
LONGITUDE
NUMBER
22
No
No
30
16
Active
Numeric value the the longitude of the tagging location.
NUMBER
20
STAT_ZONE_ID
NUMBER
22
No
No
4
1
Active
Code to indciate State Zone
NUMBER
21
COUNTRY_ID
VARCHAR2
2
No
No
Active
Cde to indicate Country
VARCHAR2
22
STATE_ID
VARCHAR2
2
No
No
Active
Code to indicate state
VARCHAR2
23
WATER_BODY_ID
NUMBER
22
No
No
6
3
Active
Code to Indicate waterbody of where tagging took place
NUMBER
24
PLACE_ID
VARCHAR2
3
No
No
Active
Code to indicate place of wheer tagging took palce
VARCHAR2
25
GEAR_ID
VARCHAR2
3
No
No
Active
Code for gear used to catch the animal.
VARCHAR2
26
GEAR_NAME
VARCHAR2
25
No
No
Active
Common Name For Gear used in fishing
VARCHAR2
27
BAIT_TYPE
VARCHAR2
1
No
No
Active
Code for bait used: (A)rtificial, (L)ive, (D)ead, (U)nknown
VARCHAR2
28
METHOD_ID
NUMBER
22
No
No
6
0
Active
Code To indicate tagging methodology Used
NUMBER
29
SAMPLE_ID
NUMBER
22
No
No
6
0
Active
Code to indicate Sampling Methodology
NUMBER
30
CAPTAIN_AGENCY
VARCHAR2
3
No
No
Active
COde to indicate agency which assigned angler code for boat captain
VARCHAR2
31
CAPTAIN_ID
NUMBER
22
No
No
6
0
Active
Unique numeric code assigned to an individual captain. Must be greater than zero or -99999.
NUMBER
32
TAGGER_INITIALS
VARCHAR2
3
No
No
Active
Initials Of Taggers
VARCHAR2
33
TAGGER_AFFILIATION
VARCHAR2
3
No
No
Active
Code Of Agency that is affiliated With The Tagger
VARCHAR2
34
VESSEL_AGENCY
VARCHAR2
3
No
No
Active
Agency For Vessel COode
VARCHAR2
35
VESSEL_ID
NUMBER
22
No
No
6
0
Active
Agency supplied code identifying the vessel involved in the release or recapture of the animal.
NUMBER
36
PHYSICAL_DATA_ID
NUMBER
22
No
No
6
0
Active
Physical Data Identification Number
NUMBER
37
NOTES
NUMBER
22
No
No
3
0
Active
Any Other Notes On Tagging
NUMBER
38
FIGHTHRS
NUMBER
22
No
No
2
0
Active
Whole Number Of houirs spent landing The animal
NUMBER
39
FIGHTMINS
NUMBER
22
No
No
2
0
Active
Number Of minutes (up to 59) landing the animal
NUMBER
40
ANGLER_AGENCY_ID
VARCHAR2
3
No
No
Active
Agency Id associated with the angler number is
VARCHAR2
41
ANGLER_ID
NUMBER
22
No
No
6
0
Active
Unique identifier for each person in the database.
NUMBER
42
ID
NUMBER
22
Yes
No
38
Active
Identifies Ang;er
NUMBER
43
DATE_ENTERED
VARCHAR2
10
No
No
Active
The date the data was entered.
VARCHAR2
44
SPECIES_ID
VARCHAR2
3
No
No
Active
Species Code
VARCHAR2
45
SEX
VARCHAR2
1
No
No
Active
Code to indicate sex of the animal
VARCHAR2
7048
View: CTS_INTERACTIONS_SEARCH_V
CTS_INTERACTIONS_SEARCH_V
Published / External
Completed
View Of data starting with 01/01/2003
Loaded by batch 2083, 02-22-2008 12:10
Data View
Yes
CTSPAT
View Of data starting with 01/01/2003
1
ANIMAL_ID
NUMBER
22
Yes
No
10
0
Active
Key to Identifies Animal
NUMBER
2
AGENCY_ID
VARCHAR2
3
Yes
No
Active
Code to Indicate Tagging agency of identifying tag on animal (tag1)
VARCHAR2
3
TAG_ID
VARCHAR2
8
Yes
No
Active
Tagnumber
VARCHAR2
4
EVENT_ID
NUMBER
22
Yes
No
2
0
Active
Code to identify tagging event
NUMBER
5
TAG_DATE
VARCHAR2
10
No
No
Active
Date animal was released or recaptured.
VARCHAR2
6
TAGDATE
DATE
7
Yes
No
Active
Date Animal Was Tagged
DATE
7
NEXT_TAG_AGENCY_ID
VARCHAR2
3
No
No
Active
Agency Id associated with value in the nexttag column
VARCHAR2
8
NEXT_TAG_ID
VARCHAR2
8
No
No
Active
Code to Indicate Tagging agency of identifying tag on animal (nexttag)
VARCHAR2
9
INTERACTION_ORDER
NUMBER
22
Yes
No
2
0
Active
Number denoting the order of the interaction.
NUMBER
10
LENGTH
NUMBER
22
No
No
4
0
Active
Length of animal tagged based on the lengthunit, lengthtype, and lengthdet.
NUMBER
11
LENGTHUNIT
VARCHAR2
2
No
No
Active
Length Units
VARCHAR2
12
LENGTHTYPE
VARCHAR2
1
No
No
Active
Type Of Length Measurment Taken
VARCHAR2
13
LENGTHDET
VARCHAR2
1
No
No
Active
How Length Was Measurment was determined
VARCHAR2
14
WEIGHT
NUMBER
22
No
No
6
2
Active
Weight of an animal tagged, based upon weightunit, weighttype and weightdet.
NUMBER
15
WEIGHTUNIT
VARCHAR2
2
No
No
Active
Weight Units
VARCHAR2
16
WEIGHTTYPE
VARCHAR2
1
No
No
Active
Type Of Weight Mesurment Taken
VARCHAR2
17
WEIGHTDET
VARCHAR2
1
No
No
Active
How weight measurement was determined
VARCHAR2
18
LATITUDE
NUMBER
22
No
No
30
16
Active
Numeric value for the latitude of the tagging location.
NUMBER
19
LONGITUDE
NUMBER
22
No
No
30
16
Active
Numeric value the the longitude of the tagging location.
NUMBER
20
STAT_ZONE_ID
NUMBER
22
No
No
4
1
Active
Code to indciate State Zone
NUMBER
21
COUNTRY_ID
VARCHAR2
2
No
No
Active
Cde to indicate Country
VARCHAR2
22
STATE_ID
VARCHAR2
2
No
No
Active
Code to indicate state
VARCHAR2
23
WATER_BODY_ID
NUMBER
22
No
No
6
3
Active
Code to Indicate waterbody of where tagging took place
NUMBER
24
PLACE_ID
VARCHAR2
3
No
No
Active
Code to indicate place of wheer tagging took palce
VARCHAR2
25
GEAR_ID
VARCHAR2
3
No
No
Active
Code for gear used to catch the animal.
VARCHAR2
26
BAIT_TYPE
VARCHAR2
1
No
No
Active
Code for bait used: (A)rtificial, (L)ive, (D)ead, (U)nknown
VARCHAR2
27
METHOD_ID
NUMBER
22
No
No
6
0
Active
Code To indicate tagging methodology Used
NUMBER
28
SAMPLE_ID
NUMBER
22
No
No
6
0
Active
Code to indicate Sampling Methodology
NUMBER
29
CAPTAIN_AGENCY
VARCHAR2
3
No
No
Active
COde to indicate agency which assigned angler code for boat captain
VARCHAR2
30
CAPTAIN_ID
NUMBER
22
No
No
6
0
Active
Unique numeric code assigned to an individual captain. Must be greater than zero or -99999.
NUMBER
31
TAGGER_INITIALS
VARCHAR2
3
No
No
Active
Initials Of Taggers
VARCHAR2
32
TAGGER_TYPE
VARCHAR2
1
No
No
Active
Code to indicate the type of tagger that tagged this animal
VARCHAR2
33
TAGGER_AFFILIATION
VARCHAR2
3
No
No
Active
Code Of Agency that is affiliated With The Tagger
VARCHAR2
34
VESSEL_AGENCY
VARCHAR2
3
No
No
Active
Agency For Vessel COode
VARCHAR2
35
VESSEL_ID
NUMBER
22
No
No
6
0
Active
Agency supplied code identifying the vessel involved in the release or recapture of the animal.
NUMBER
36
PHYSICAL_DATA_ID
NUMBER
22
No
No
6
0
Active
Physical Data Identification Number
NUMBER
37
NOTES
NUMBER
22
No
No
3
0
Active
Any Other Notes On Tagging
NUMBER
38
FIGHTHRS
NUMBER
22
No
No
2
0
Active
Whole Number Of houirs spent landing The animal
NUMBER
39
FIGHTMINS
NUMBER
22
No
No
2
0
Active
Number Of minutes (up to 59) landing the animal
NUMBER
40
ANGLER_AGENCY_ID
VARCHAR2
3
No
No
Active
Agency Id associated with the angler number is
VARCHAR2
41
ANGLER_ID
NUMBER
22
No
No
6
0
Active
Unique identifier for each person in the database.
NUMBER
42
ID
NUMBER
22
Yes
No
38
Active
Identifies Ang;er
NUMBER
43
DATE_ENTERED
VARCHAR2
10
No
No
Active
The date the data was entered.
VARCHAR2
44
SPECIES_ID
VARCHAR2
3
Yes
No
Active
Species Code
VARCHAR2
45
SEX
VARCHAR2
1
No
No
Active
Code to indicate sex of the animal
VARCHAR2
7049
View: CTS_INTERACTIONS_V
CTS_INTERACTIONS_V
Published / External
Completed
View Of data starting with 01/01/2003
Loaded by batch 2083, 02-22-2008 12:10
Data View
Yes
CTSPAT
View Of data starting with 01/01/2003
1
ANIMAL_ID
NUMBER
22
Yes
No
10
0
Active
Key to Identifies Animal
NUMBER
2
AGENCY_ID
VARCHAR2
3
Yes
No
Active
Code to Indicate Tagging agency of identifying tag on animal (tag1)
VARCHAR2
3
TAG_ID
VARCHAR2
8
Yes
No
Active
Tagnumber
VARCHAR2
4
EVENT_ID
NUMBER
22
Yes
No
2
0
Active
Code to identify tagging event
NUMBER
5
TAG_DATE
VARCHAR2
10
No
No
Active
Date animal was released or recaptured.
VARCHAR2
6
NEXT_TAG_AGENCY_ID
VARCHAR2
3
No
No
Active
Agency Id associated with value in the nexttag column
VARCHAR2
7
NEXT_TAG_ID
VARCHAR2
8
No
No
Active
Code to Indicate Tagging agency of identifying tag on animal (nexttag)
VARCHAR2
8
INTERACTION_ORDER
NUMBER
22
Yes
No
2
0
Active
Number denoting the order of the interaction.
NUMBER
9
LENGTH
NUMBER
22
No
No
4
0
Active
Length of animal tagged based on the lengthunit, lengthtype, and lengthdet.
NUMBER
10
LENGTHUNIT
VARCHAR2
2
No
No
Active
Length Units
VARCHAR2
11
LENGTHTYPE
VARCHAR2
1
No
No
Active
Type Of Length Measurment Taken
VARCHAR2
12
LENGTHDET
VARCHAR2
1
No
No
Active
How Length Was Measurment was determined
VARCHAR2
13
WEIGHT
NUMBER
22
No
No
6
2
Active
Weight of an animal tagged, based upon weightunit, weighttype and weightdet.
NUMBER
14
WEIGHTUNIT
VARCHAR2
2
No
No
Active
Weight Units
VARCHAR2
15
WEIGHTTYPE
VARCHAR2
1
No
No
Active
Type Of Weight Mesurment Taken
VARCHAR2
16
WEIGHTDET
VARCHAR2
1
No
No
Active
How weight measurement was determined
VARCHAR2
17
LATITUDE
NUMBER
22
No
No
30
16
Active
Numeric value for the latitude of the tagging location.
NUMBER
18
LONGITUDE
NUMBER
22
No
No
30
16
Active
Numeric value the the longitude of the tagging location.
NUMBER
19
STAT_ZONE_ID
NUMBER
22
No
No
4
1
Active
Code to indciate State Zone
NUMBER
20
COUNTRY_ID
VARCHAR2
2
No
No
Active
Cde to indicate Country
VARCHAR2
21
STATE_ID
VARCHAR2
2
No
No
Active
Code to indicate state
VARCHAR2
22
WATER_BODY_ID
NUMBER
22
No
No
6
3
Active
Code to Indicate waterbody of where tagging took place
NUMBER
23
PLACE_ID
VARCHAR2
3
No
No
Active
Code to indicate place of wheer tagging took palce
VARCHAR2
24
GEAR_ID
VARCHAR2
3
No
No
Active
Code for gear used to catch the animal.
VARCHAR2
25
BAIT_TYPE
VARCHAR2
1
No
No
Active
Code for bait used: (A)rtificial, (L)ive, (D)ead, (U)nknown
VARCHAR2
26
METHOD_ID
NUMBER
22
No
No
6
0
Active
Code To indicate tagging methodology Used
NUMBER
27
SAMPLE_ID
NUMBER
22
No
No
6
0
Active
Code to indicate Sampling Methodology
NUMBER
28
CAPTAIN_AGENCY
VARCHAR2
3
No
No
Active
COde to indicate agency which assigned angler code for boat captain
VARCHAR2
29
CAPTAIN_ID
NUMBER
22
No
No
6
0
Active
Unique numeric code assigned to an individual captain. Must be greater than zero or -99999.
NUMBER
30
TAGGER_INITIALS
VARCHAR2
3
No
No
Active
Initials Of Taggers
VARCHAR2
31
TAGGER_AFFILIATION
VARCHAR2
3
No
No
Active
Code Of Agency that is affiliated With The Tagger
VARCHAR2
32
VESSEL_AGENCY
VARCHAR2
3
No
No
Active
Agency For Vessel COode
VARCHAR2
33
VESSEL_ID
NUMBER
22
No
No
6
0
Active
Agency supplied code identifying the vessel involved in the release or recapture of the animal.
NUMBER
34
PHYSICAL_DATA_ID
NUMBER
22
No
No
6
0
Active
Physical Data Identification Number
NUMBER
35
NOTES
NUMBER
22
No
No
3
0
Active
Any Other Notes On Tagging
NUMBER
36
FIGHTHRS
NUMBER
22
No
No
2
0
Active
Whole Number Of houirs spent landing The animal
NUMBER
37
FIGHTMINS
NUMBER
22
No
No
2
0
Active
Number Of minutes (up to 59) landing the animal
NUMBER
38
ANGLER_AGENCY_ID
VARCHAR2
3
No
No
Active
Agency Id associated with the angler number is
VARCHAR2
39
ANGLER_ID
NUMBER
22
No
No
6
0
Active
Unique identifier for each person in the database.
NUMBER
40
ID
NUMBER
22
Yes
No
38
Active
Identifies Ang;er
NUMBER
41
DATE_ENTERED
VARCHAR2
10
No
No
Active
The date the data was entered.
VARCHAR2
42
SPECIES_ID
VARCHAR2
3
No
No
Active
Species Code
VARCHAR2
43
SEX
VARCHAR2
1
No
No
Active
Code to indicate sex of the animal
VARCHAR2
7050
Table: CTS_KFTRACK
CTS_KFTRACK
Published / External
Completed
This table contains the results of the Kalman Filter geolocation algorithm.
Loaded by batch 2083, 02-22-2008 12:10
Data Table
Yes
CTSPAT
This table contains the results of the Kalman Filter geolocation algorithm.
1
ARCHIVAL_TAG_ID
VARCHAR2
10
Yes
No
Active
Archival Tag ID provided by the manufacturer.
VARCHAR2
2
POINT_ID
NUMBER
22
Yes
No
38
Active
The identification number of the point
NUMBER
3
POINT_DATE
DATE
7
Yes
No
Active
The date the location was generated.
DATE
4
DAYS
NUMBER
22
No
No
38
Active
Number of days from the beginning
NUMBER
5
J
NUMBER
22
No
No
38
Active
Julian Date
NUMBER
6
VY
NUMBER
22
No
No
38
Active
Model parameter
NUMBER
7
AX
NUMBER
22
No
No
38
Active
Model parameter
NUMBER
8
AY
NUMBER
22
No
No
38
Active
Model parameter
NUMBER
9
OX
NUMBER
22
No
No
38
Active
Original Longitude
NUMBER
10
OY
NUMBER
22
No
No
38
Active
Original Latitude
NUMBER
11
PX
NUMBER
22
No
No
38
Active
Kalman Filter Longitude
NUMBER
12
PY
NUMBER
22
No
No
38
Active
Kalman Filter Latitude
NUMBER
13
SX
NUMBER
22
No
No
38
Active
Smoothed Longitude
NUMBER
14
SY
NUMBER
22
No
No
38
Active
Smoother Latitude
NUMBER
15
O_GEOM
SDO_GEOMETRY
1
No
No
Active
Oracle SDO_Geometry of the original track
SDO_GEOMETRY
16
P_GEOM
SDO_GEOMETRY
1
No
No
Active
Oracle SDO_Geometry of the KF track
SDO_GEOMETRY
17
S_GEOM
SDO_GEOMETRY
1
No
No
Active
Oracle SDO_Geometry of the smoothed KF track
SDO_GEOMETRY
18
ID
NUMBER
22
Yes
Yes
38
Active
Sequential Key
NUMBER
7051
Table: CTS_LENGTH_DETERMINATION
CTS_LENGTH_DETERMINATION
Published / External
Completed
Table Of Valid Methods Of Length Determination/Measurement
Loaded by batch 2083, 02-22-2008 12:10
Data Table
Yes
CTSPAT
Table Of Valid Methods Of Length Determination/Measurement
1
LENGTH_CODE
VARCHAR2
1
Yes
No
Active
Mnemonic Length Determination Code
VARCHAR2
2
LENGTH_DESCRIPTION
VARCHAR2
50
No
No
Active
Code Description
VARCHAR2
7052
Table: CTS_LENGTH_TYPE
CTS_LENGTH_TYPE
Published / External
Completed
Table Of Valid Length Type Codes and their descriptions
Loaded by batch 2083, 02-22-2008 12:10
Data Table
Yes
CTSPAT
Table Of Valid Length Type Codes and their descriptions
1
TYPE_CODE
VARCHAR2
1
Yes
No
Active
Length Type Code
VARCHAR2
2
TYPE_DESCRIPTION
VARCHAR2
50
No
No
Active
Description Of Length Type Code
VARCHAR2
7053
Table: CTS_LENGTH_UNIT
CTS_LENGTH_UNIT
Published / External
Completed
Table Of Valid Length Codes
Loaded by batch 2083, 02-22-2008 12:10
Data Table
Yes
CTSPAT
Table Of Valid Length Codes
1
UNIT_CODE
VARCHAR2
2
Yes
No
Active
Mnemonic Length Code/Unit
VARCHAR2
2
UNIT_DESCRIPTION
VARCHAR2
50
No
No
Active
Description
VARCHAR2
7054
View: CTS_LETTERS_V
CTS_LETTERS_V
Published / External
Completed
View to hold information to create letters to anglers and ca[tians when a ftagged fish is recaptured
Loaded by batch 2083, 02-22-2008 12:10
Data View
Yes
CTSPAT
View to hold information to create letters to anglers and ca[tians when a ftagged fish is recaptured
1
INTERACTION_ID
NUMBER
22
No
No
38
Active
Link to interaction record
NUMBER
2
ANIMAL_ID
NUMBER
22
No
No
10
0
Active
Animal Id
NUMBER
3
TAG_ID
VARCHAR2
12
No
No
Active
Tagnumber
VARCHAR2
4
SPECIES_ID
VARCHAR2
3
No
No
Active
Species Code
VARCHAR2
5
SPECIES_NAME
VARCHAR2
21
No
No
Active
Species Name
VARCHAR2
6
TAG_DATE
VARCHAR2
10
No
No
Active
Date animal was tagged
VARCHAR2
7
LOCATION
VARCHAR2
13
No
No
Active
location of recapture
VARCHAR2
8
LENGTH
NUMBER
22
No
No
4
0
Active
Length Of recpatured fish
NUMBER
9
WEIGHT
NUMBER
22
No
No
6
2
Active
Weight of recaptured fish
NUMBER
10
FISHERMAN_NAME
VARCHAR2
61
No
No
Active
Fisherman's name
VARCHAR2
11
ADDRESS_1
VARCHAR2
50
No
No
Active
First Line address
VARCHAR2
12
ADDRESS_2
VARCHAR2
30
No
No
Active
Second Line address
VARCHAR2
13
CITY
VARCHAR2
30
No
No
Active
CIty
VARCHAR2
14
STATE_NAME
VARCHAR2
30
No
No
Active
State
VARCHAR2
15
ZIPCODE
VARCHAR2
10
No
No
Active
Zipcode
VARCHAR2
16
COUNTRY_NAME
VARCHAR2
50
No
No
Active
country
VARCHAR2
7055
Table: CTS_LOCATION_LATLONG
CTS_LOCATION_LATLONG
Published / External
Completed
Table Of Valid Location Codes
Loaded by batch 2083, 02-22-2008 12:10
Data Table
Yes
CTSPAT
Table Of Valid Location Codes
1
ID
NUMBER
22
No
No
38
Active
Sequential Key
NUMBER
2
LOCATION_NAME
VARCHAR2
200
No
No
Active
Location Name
VARCHAR2
3
LOCALITY_1
VARCHAR2
100
Yes
No
Active
Locality One Description (Most specific Locality Description)
VARCHAR2
4
LOCALITY_2
VARCHAR2
100
Yes
No
Active
Locality Two Description (Next most descriptive locality description)
VARCHAR2
5
LOCALITY_3
VARCHAR2
100
Yes
No
Active
Locality Three Information (most gernal locality description. It is often at the US stete or country level)
VARCHAR2
6
LATITUDE
NUMBER
22
Yes
No
38
Active
Specified Latitude
NUMBER
7
LONGITUDE
NUMBER
22
Yes
No
38
Active
Specified Longitude
NUMBER
7056
Table: CTS_MULTITAG
CTS_MULTITAG
Published / External
Completed
Keeps Track of Multi Tagged Fish
Loaded by batch 2083, 02-22-2008 12:10
Data Table
Yes
CTSPAT
Keeps Track of Multi Tagged Fish
1
CTS_INTERACTIONS_ANIMAL_ID
NUMBER
22
Yes
Yes
10
0
Active
Foreign Key To Animal record
NUMBER
2
CTS_INTERACTIONS_INTERACTION_O
NUMBER
22
Yes
Yes
2
0
Active
Foreign Key To CTS_INTERACTIONS Record
NUMBER
3
AGENCY_ID
VARCHAR2
3
Yes
Yes
Active
Foriegn Key to Agency Table For Tag ID
VARCHAR2
4
TAG_ID
VARCHAR2
8
Yes
Yes
Active
Tag Id Number
VARCHAR2
5
NEXT_TAG_AGENCY_ID
VARCHAR2
3
Yes
Yes
Active
Foriegn Key to Agency Table For Next Tag ID
VARCHAR2
6
NEXT_TAG_ID
VARCHAR2
8
Yes
Yes
Active
Next Tag ID Number
VARCHAR2
7
DATE_APPLIED
DATE
7
Yes
No
Active
Date tag was applied
DATE
8
DATE_REMOVED
DATE
7
No
No
Active
Date Tabe was removed
DATE
7057
Table: CTS_PAT_INVESTIGATORS
CTS_PAT_INVESTIGATORS
Published / External
Completed
Table Of Popup ARchival Tag Investigators
Loaded by batch 2083, 02-22-2008 12:10
Data Table
Yes
CTSPAT
Table Of Popup ARchival Tag Investigators
1
AGENCY_ID
VARCHAR2
5
Yes
No
Active
Foreign Key To Agency Table
VARCHAR2
2
INVESTIGATOR_ID
NUMBER
22
Yes
Yes
5
0
Active
Primary Key
NUMBER
3
NAME
VARCHAR2
100
No
No
Active
Investigator Name
VARCHAR2
4
ADDRESS_1
VARCHAR2
100
No
No
Active
First Line Of Address For Investigator
VARCHAR2
5
ADDRESS_2
VARCHAR2
100
No
No
Active
Second Line Of Address For Investigator
VARCHAR2
6
CITY
VARCHAR2
50
No
No
Active
City of Mailing address For Investigator
VARCHAR2
7
STATE
VARCHAR2
50
No
No
Active
State of Mailing address For Investigator
VARCHAR2
8
ZIPCODE
VARCHAR2
10
No
No
Active
Zipcode of Mailing address For Investigator
VARCHAR2
9
COUNTRY
VARCHAR2
100
No
No
Active
Country of Mailing address For Investigator
VARCHAR2
10
PHONE
VARCHAR2
20
No
No
Active
Phone Number of Investigator
VARCHAR2
11
FAX
VARCHAR2
20
No
No
Active
Facsimilie Number For Investigator
VARCHAR2
12
EMAIL
VARCHAR2
50
No
No
Active
Electronic mail address For Investigator
VARCHAR2
7058
Table: CTS_PAT_LOCATIONS
CTS_PAT_LOCATIONS
Published / External
Completed
Table Of Popup Archival Tag Locations Generated Using the Light-based Geolocation Algorithm.
Loaded by batch 2083, 02-22-2008 12:10
Data Table
Yes
CTSPAT
Table Of Popup Archival Tag Locations Generated Using the Light-based Geolocation Algorithm.
1
ARGOS_PTT_ID
VARCHAR2
10
Yes
No
Active
The unique PTT id of the transmitter used by the Argos Satellite Transmission Service provider.
VARCHAR2
2
LONGITUDE
NUMBER
22
No
No
20
14
Active
Longitude value estimated using the midday algorithm where the highest light levels were recorded.
NUMBER
3
YEAR
NUMBER
22
Yes
No
4
0
Active
(Year Component) Times Of Reading
NUMBER
4
MONTH
NUMBER
22
Yes
No
2
0
Active
(Month Component) Times Of Reading
NUMBER
5
DAY
NUMBER
22
Yes
No
2
0
Active
(Day Component) Times Of Reading
NUMBER
6
MIDHOUR
NUMBER
22
No
No
2
0
Active
The hour when the lowest light level was recorded.
NUMBER
7
MIDMINUTE
NUMBER
22
No
No
2
0
Active
The minute when the lowest light level was recorded.
NUMBER
8
LATITUDE
NUMBER
22
No
No
20
14
Active
Latitude estimate using the light-based (length of day) geolocation algorithm.
NUMBER
9
LAT_MSD
FLOAT
22
No
No
126
Active
Mean standard deviation for latitude value.
FLOAT
10
LON_MSD
FLOAT
22
No
No
126
Active
Mean standard deviation for longitude value.
FLOAT
11
LOC_RECORD
NUMBER
22
Yes
No
38
Active
Location Record
NUMBER
12
GEOM
SDO_GEOMETRY
1
No
No
Active
The Oracle SDO_Geometry object used to store the point location.
SDO_GEOMETRY
13
ARCHIVAL_TAG_ID
VARCHAR2
10
Yes
No
Active
Archival Tag ID provided by the manufacturer.
VARCHAR2
14
ID
NUMBER
22
Yes
Yes
38
Active
Sequence to uniquely identify each record in this table.
NUMBER
7059
View: CTS_PAT_LOCATIONS_PERF_V
CTS_PAT_LOCATIONS_PERF_V
Published / External
Completed
View Listing number of location records per Archival Tag
Loaded by batch 2083, 02-22-2008 12:10
Data View
Yes
CTSPAT
View Listing number of location records per Archival Tag
1
ARCHIVAL_TAG_ID
VARCHAR2
10
Yes
No
Active
Archival Tag Number
VARCHAR2
2
LOCATIONS_COUNT
NUMBER
22
No
No
38
Active
Number of Records Per Archival Tag
NUMBER
3
RELEASE_DATE
DATE
7
No
No
Active
Date Animal was released with Archival Tag
DATE
4
ACTUAL_POP_OFF_DATE
DATE
7
No
No
Active
Date Archival Tag popped off of the animal
DATE
7060
Table: CTS_PAT_PDT
CTS_PAT_PDT
Published / External
Completed
Profile at Depth and Time (PDT) - a sampling of the depths that the tag experienced with minimum and maximum values for temperature at each.
Loaded by batch 2083, 02-22-2008 12:10
Data Table
Yes
CTSPAT
Profile at Depth and Time (PDT) - a sampling of the depths that the tag experienced with minimum and maximum values for temperature at each.
1
ARGOS_PTT_ID
VARCHAR2
10
Yes
No
Active
Link to ARGOS Table
VARCHAR2
2
RECEPTION_DATE
DATE
7
Yes
No
Active
Date Information Wa Received
DATE
3
RECEPTION_TIME
VARCHAR2
10
Yes
No
Active
Time Information Was Recieved
VARCHAR2
4
DEPTH_1
NUMBER
22
No
No
4
0
Active
Depth One Measurement
NUMBER
5
D1_MIN_TEMP
NUMBER
22
No
No
5
1
Active
Depth One Minimum Temperature
NUMBER
6
D1_MAX_TEMP
NUMBER
22
No
No
5
1
Active
Depth One Maximum Temperature
NUMBER
7
DEPTH_2
NUMBER
22
No
No
4
0
Active
Depth Two Measurement
NUMBER
8
D2_MIN_TEMP
NUMBER
22
No
No
5
1
Active
Depth Two Minimum Temperature
NUMBER
9
D2_MAX_TEMP
NUMBER
22
No
No
5
1
Active
Depth Two Maximum Temperature
NUMBER
10
DEPTH_3
NUMBER
22
No
No
4
0
Active
Depth Three Measurement
NUMBER
11
D3_MIN_TEMP
NUMBER
22
No
No
5
1
Active
Depth Three Minimum Temperature
NUMBER
12
D3_MAX_TEMP
NUMBER
22
No
No
5
1
Active
Depth Three Maximum Temperature
NUMBER
13
DEPTH_4
VARCHAR2
240
No
No
Active
Depth Four Measurement
VARCHAR2
14
D4_MIN_TEMP
NUMBER
22
No
No
5
1
Active
Depth Four Minimum Temperature
NUMBER
15
D4_MAX_TEMP
NUMBER
22
No
No
5
1
Active
Depth Four Maximum Temperature
NUMBER
16
DEPTH_5
NUMBER
22
No
No
38
Active
Depth five measurement
NUMBER
17
D5_MIN_TEMP
NUMBER
22
No
No
5
1
Active
Depth Five Minimum Temperature
NUMBER
18
D5_MAX_TEMP
NUMBER
22
No
No
5
1
Active
Depth Fivet Maximum Temperature
NUMBER
19
DEPTH_6
NUMBER
22
No
No
4
0
Active
Depth Six Measurement
NUMBER
20
D6_MIN_TEMP
NUMBER
22
No
No
5
1
Active
Depth Six Minimum Temperature
NUMBER
21
D6_MAX_TEMP
NUMBER
22
No
No
5
1
Active
Depth Six Maximum Temperature
NUMBER
22
DEPTH_7
NUMBER
22
No
No
4
0
Active
Depth Seven Measurement
NUMBER
23
D7_MIN_TEMP
NUMBER
22
No
No
5
1
Active
Depth Seven Minimum Temperature
NUMBER
24
D7_MAX_TEMP
NUMBER
22
No
No
5
1
Active
Depth Seven Maximum Temperature
NUMBER
25
DEPTH_8
NUMBER
22
No
No
4
0
Active
Depth Eight Measurement
NUMBER
26
D8_MIN_TEMP
NUMBER
22
No
No
5
1
Active
Depth Eight Minimum Temperature
NUMBER
27
D8_MAX_TEMP
NUMBER
22
No
No
5
1
Active
Depth Eight Maximum Temperature
NUMBER
28
YEAR
NUMBER
22
Yes
No
4
0
Active
Calender Year Measurement Was Taken
NUMBER
29
MONTH
NUMBER
22
Yes
No
2
0
Active
Calender Month Measurement Was Taken
NUMBER
30
DAY
NUMBER
22
Yes
No
2
0
Active
Calender Day Measurement Was Taken
NUMBER
31
HOUR
NUMBER
22
Yes
No
2
0
Active
Time Measurement Was Taken
NUMBER
32
REPEATS
NUMBER
22
No
No
3
0
Active
Number Of Times Measurement Was Repeated
NUMBER
33
ARCHIVAL_TAG_ID
VARCHAR2
10
Yes
No
Active
Archival Tag ID provided by the manufacturer.
VARCHAR2
34
ID
NUMBER
22
Yes
Yes
38
Active
Sequential Key
NUMBER
7061
View: CTS_PAT_PDT_PERF_V
CTS_PAT_PDT_PERF_V
Published / External
Completed
PAT PDT Performance View
Loaded by batch 2083, 02-22-2008 12:10
Data View
Yes
CTSPAT
PAT PDT Performance View
1
ARCHIVAL_TAG_ID
VARCHAR2
10
Yes
No
Active
Archival Tag ID provided by the manufacturer.
VARCHAR2
2
PDT_HISTOGRAM_COUNT
NUMBER
22
No
No
38
Active
Histogram Count
NUMBER
3
RELEASE_DATE
DATE
7
No
No
Active
Date Tag Was Applied On Fish
DATE
4
ACTUAL_POP_OFF_DATE
DATE
7
No
No
Active
Date Tag Popped Off Of The Fish
DATE
7062
Table: CTS_PAT_RAW
CTS_PAT_RAW
Published / External
Completed
Raw Data Transmitted By The satelite
Loaded by batch 2083, 02-22-2008 12:10
Data Table
Yes
CTSPAT
Raw Data Transmitted By The satelite
1
ARGOS_PTT_ID
VARCHAR2
10
Yes
No
Active
The unique PTT id of the transmitter used by the Argos Satellite Transmission Service provider.
VARCHAR2
2
RECEPTION_DATE
DATE
7
Yes
No
Active
The date the data was received by the satellite.
DATE
3
RECEPTION_TIME
VARCHAR2
10
Yes
No
Active
The time the data was received by the satellite.
VARCHAR2
4
BYTE01
NUMBER
22
No
No
38
Active
The first byte transmitted by the transmitter to the satellite.
NUMBER
5
BYTE02
NUMBER
22
No
No
38
Active
The second byte transmitted by the transmitter to the satellite.
NUMBER
6
BYTE03
NUMBER
22
No
No
38
Active
The third byte transmitted by the transmitter to the satellite.
NUMBER
7
BYTE04
NUMBER
22
No
No
38
Active
The fourth byte transmitted by the transmitter to the satellite.
NUMBER
8
BYTE05
NUMBER
22
No
No
38
Active
The fifth byte transmitted by the transmitter to the satellite.
NUMBER
9
BYTE06
NUMBER
22
No
No
38
Active
The sixth byte transmitted by the transmitter to the satellite.
NUMBER
10
BYTE07
NUMBER
22
No
No
38
Active
The seventh byte transmitted by the transmitter to the satellite.
NUMBER
11
BYTE08
NUMBER
22
No
No
38
Active
The eigth byte transmitted by the transmitter to the satellite.
NUMBER
12
BYTE09
NUMBER
22
No
No
38
Active
The ninth byte transmitted by the transmitter to the satellite.
NUMBER
13
BYTE10
NUMBER
22
No
No
38
Active
The tenth byte transmitted by the transmitter to the satellite.
NUMBER
14
BYTE11
NUMBER
22
No
No
38
Active
The eleventh byte transmitted by the transmitter to the satellite.
NUMBER
15
BYTE12
NUMBER
22
No
No
38
Active
The twelveth byte transmitted by the transmitter to the satellite.
NUMBER
16
BYTE13
NUMBER
22
No
No
38
Active
The thirteenth byte transmitted by the transmitter to the satellite.
NUMBER
17
BYTE14
NUMBER
22
No
No
38
Active
The fourteenth byte transmitted by the transmitter to the satellite.
NUMBER
18
BYTE15
NUMBER
22
No
No
38
Active
The fifteenth byte transmitted by the transmitter to the satellite.
NUMBER
19
BYTE16
NUMBER
22
No
No
38
Active
The sixteenth byte transmitted by the transmitter to the satellite.
NUMBER
20
BYTE17
NUMBER
22
No
No
38
Active
The seventeenth byte transmitted by the transmitter to the satellite.
NUMBER
21
BYTE18
NUMBER
22
No
No
38
Active
The eigthteenth byte transmitted by the transmitter to the satellite.
NUMBER
22
BYTE19
NUMBER
22
No
No
38
Active
The nineteenth byte transmitted by the transmitter to the satellite.
NUMBER
23
BYTE20
NUMBER
22
No
No
38
Active
The twentieth byte transmitted by the transmitter to the satellite.
NUMBER
24
BYTE21
NUMBER
22
No
No
38
Active
The 21st byte transmitted by the transmitter to the satellite.
NUMBER
25
BYTE22
NUMBER
22
No
No
38
Active
The 22nd byte transmitted by the transmitter to the satellite.
NUMBER
26
BYTE23
NUMBER
22
No
No
38
Active
The 23rd byte transmitted by the transmitter to the satellite.
NUMBER
27
BYTE24
NUMBER
22
No
No
38
Active
The 24th byte transmitted by the transmitter to the satellite.
NUMBER
28
BYTE25
NUMBER
22
No
No
38
Active
The 25th byte transmitted by the transmitter to the satellite.
NUMBER
29
BYTE26
NUMBER
22
No
No
38
Active
The 26th byte transmitted by the transmitter to the satellite.
NUMBER
30
BYTE27
NUMBER
22
No
No
38
Active
The 27th byte transmitted by the transmitter to the satellite.
NUMBER
31
BYTE28
NUMBER
22
No
No
38
Active
The 28th byte transmitted by the transmitter to the satellite.
NUMBER
32
BYTE29
NUMBER
22
No
No
38
Active
The 29th byte transmitted by the transmitter to the satellite.
NUMBER
33
BYTE30
NUMBER
22
No
No
38
Active
The 30th byte transmitted by the transmitter to the satellite.
NUMBER
34
BYTE31
NUMBER
22
No
No
38
Active
The 31st byte transmitted by the transmitter to the satellite.
NUMBER
35
BYTE32
NUMBER
22
No
No
38
Active
The 32nd byte transmitted by the transmitter to the satellite.
NUMBER
36
YEAR
NUMBER
22
Yes
No
4
0
Active
The year the data was collected by the tag.
NUMBER
37
MONTH
NUMBER
22
Yes
No
2
0
Active
The month the data was collected by the tag.
NUMBER
38
DAY
NUMBER
22
Yes
No
2
0
Active
The day the data was collected by the tag.
NUMBER
39
HOUR
NUMBER
22
Yes
No
2
0
Active
The hour the data was collected by the tag.
NUMBER
40
DATE_CHECKSUM
NUMBER
22
No
No
38
Active
Error catching values developed by the tag manufacturer.
NUMBER
41
DEPTH_CHECKSUM
NUMBER
22
No
No
38
Active
Error catching values developed by the tag manufacturer.
NUMBER
42
TEMP_CHECKSUM
NUMBER
22
No
No
38
Active
Error catching values developed by the tag manufacturer.
NUMBER
43
LOCATION_CHECKSUM
NUMBER
22
No
No
38
Active
Error catching values developed by the tag manufacturer.
NUMBER
44
ARCHIVAL_TAG_ID
VARCHAR2
10
Yes
No
Active
Archival Tag ID provided by the manufacturer.
VARCHAR2
45
ID
NUMBER
22
Yes
Yes
38
Active
Sequence to give each record a unique identifier.
NUMBER
7063
Table: CTS_PAT_STATUS
CTS_PAT_STATUS
Published / External
Completed
The status of the tag at the time of transmission.
Loaded by batch 2083, 02-22-2008 12:10
Data Table
Yes
CTSPAT
The status of the tag at the time of transmission.
1
ARGOS_PTT_ID
VARCHAR2
10
Yes
No
Active
The unique PTT id of the transmitter used by the Argos Satellite Transmission Service provider.
VARCHAR2
2
RECEPTION_DATE
DATE
7
Yes
No
Active
The data the satellite received the data from the transmitter.
DATE
3
RECEPTION_TIME
VARCHAR2
10
Yes
No
Active
The time the satellite received the data from the transmitter.
VARCHAR2
4
TRANSMISSIONS
NUMBER
22
No
No
10
0
Active
The number of transmissions received.
NUMBER
5
TRANSMISSION_TIME
VARCHAR2
10
No
No
Active
The amount of time it took to receive the transmissions.
VARCHAR2
6
DEEP_DIVE_COUNT
NUMBER
22
No
No
4
0
Active
The number of deep dives registered by the tag.
NUMBER
7
BATTERY_VOLTAGE
NUMBER
22
No
No
5
2
Active
Current battery voltage at time of transmission. Gives an indication of how many transmissions the tag could send.
NUMBER
8
PREMATURE_RELEASE_DEPTH
NUMBER
22
No
No
5
0
Active
The depth at which a premature release occured (if any).
NUMBER
9
PR_DETECTION_YEAR
NUMBER
22
No
No
4
0
Active
The year when the premature release occurred.
NUMBER
10
PR_DETECTION_MONTH
NUMBER
22
No
No
2
0
Active
The month when the premature release occurred.
NUMBER
11
PR_DETECTION_DAY
NUMBER
22
No
No
2
0
Active
The day when the premature release occurred.
NUMBER
12
PR_DETECTION_HOUR
NUMBER
22
No
No
2
0
Active
The hour when the premature release occurred.
NUMBER
13
PR_DETECTION_MINUTE
NUMBER
22
No
No
2
0
Active
The minute when the premature release occurred.
NUMBER
14
LAST_DEEP_DIVE_M
NUMBER
22
No
No
6
2
Active
The depth of the last deepest dive in meters.
NUMBER
15
LAST_DEEP_DIVE_YEAR
NUMBER
22
No
No
4
0
Active
The year when the deepest dive occurred.
NUMBER
16
LAST_DEEP_DIVE_MONTH
NUMBER
22
No
No
2
0
Active
The month when the deepest dive occurred.
NUMBER
17
LAST_DEEP_DIVE_DAY
NUMBER
22
No
No
2
0
Active
The day when the deepest dive occurred.
NUMBER
18
LAST_DEEP_DIVE_HOUR
NUMBER
22
No
No
2
0
Active
The hour when the deepest dive occurred.
NUMBER
19
LAST_DEEP_DIVE_MINUTE
NUMBER
22
No
No
2
0
Active
The minute when the deepest dive occurred.
NUMBER
20
ARCHIVAL_TAG_ID
VARCHAR2
10
Yes
No
Active
Archival Tag ID provided by the manufacturer.
VARCHAR2
21
ID
NUMBER
22
Yes
Yes
38
Active
Sequence to give each record a unique identifier.
NUMBER
7064
View: CTS_PAT_STATUS_PERF_V
CTS_PAT_STATUS_PERF_V
Published / External
Completed
PAT Status Performance View
Loaded by batch 2083, 02-22-2008 12:10
Data View
Yes
CTSPAT
PAT Status Performance View
1
ARCHIVAL_TAG_ID
VARCHAR2
10
Yes
No
Active
Archival Tag ID provided by the manufacturer.
VARCHAR2
2
MAX_TRANSMISSIONS
NUMBER
22
No
No
38
Active
Maximum Number Of Transmissions
NUMBER
3
MAX_BATTERY
NUMBER
22
No
No
38
Active
Maximum Battery Voltage
NUMBER
4
MIN_BATTERY
NUMBER
22
No
No
38
Active
Minimum Battery Voltage
NUMBER
7065
Table: CTS_PAT_TAD
CTS_PAT_TAD
Published / External
Completed
Time At Depth (TAD) - the amount of time the tag spent in a pre-defined depth bin.
Loaded by batch 2083, 02-22-2008 12:10
Data Table
Yes
CTSPAT
Time At Depth (TAD) - the amount of time the tag spent in a pre-defined depth bin.
1
ARGOS_PTT_ID
VARCHAR2
10
Yes
No
Active
The unique PTT id of the transmitter used by the Argos Satellite Transmission Service provider.
VARCHAR2
2
RECEPTION_DATE
DATE
7
Yes
No
Active
The date the data was received by the satellite.
DATE
3
RECEPTION_TIME
VARCHAR2
10
Yes
No
Active
The time the data was received by the satellite.
VARCHAR2
4
BIN_1
FLOAT
22
No
No
9
Active
The percentage of time the tag spent in the first depth bin as defined by the user and reported in CTS_PAT_TAG_BIN.
FLOAT
5
BIN_2
FLOAT
22
No
No
9
Active
The percentage of time the tag spent in the second depth bin as defined by the user and reported in CTS_PAT_TAG_BIN.
FLOAT
6
BIN_3
FLOAT
22
No
No
9
Active
The percentage of time the tag spent in the third depth bin as defined by the user and reported in CTS_PAT_TAG_BIN.
FLOAT
7
BIN_4
FLOAT
22
No
No
9
Active
The percentage of time the tag spent in the fourth depth bin as defined by the user and reported in CTS_PAT_TAG_BIN.
FLOAT
8
BIN_5
FLOAT
22
No
No
9
Active
The percentage of time the tag spent in the fifth depth bin as defined by the user and reported in CTS_PAT_TAG_BIN.
FLOAT
9
BIN_6
FLOAT
22
No
No
9
Active
The percentage of time the tag spent in the sixth depth bin as defined by the user and reported in CTS_PAT_TAG_BIN.
FLOAT
10
BIN_7
FLOAT
22
No
No
9
Active
The percentage of time the tag spent in the seventh depth bin as defined by the user and reported in CTS_PAT_TAG_BIN.
FLOAT
11
BIN_8
FLOAT
22
No
No
9
Active
The percentage of time the tag spent in the eigth depth bin as defined by the user and reported in CTS_PAT_TAG_BIN.
FLOAT
12
BIN_9
FLOAT
22
No
No
9
Active
The percentage of time the tag spent in the ninth depth bin as defined by the user and reported in CTS_PAT_TAG_BIN.
FLOAT
13
BIN_10
FLOAT
22
No
No
9
Active
The percentage of time the tag spent in the tenth depth bin as defined by the user and reported in CTS_PAT_TAG_BIN.
FLOAT
14
BIN_11
FLOAT
22
No
No
9
Active
The percentage of time the tag spent in the eleventh depth bin as defined by the user and reported in CTS_PAT_TAG_BIN.
FLOAT
15
BIN_12
FLOAT
22
No
No
9
Active
The percentage of time the tag spent in the twelvth depth bin as defined by the user and reported in CTS_PAT_TAG_BIN.
FLOAT
16
YEAR
NUMBER
22
Yes
No
4
0
Active
The year the data was collected.
NUMBER
17
MONTH
NUMBER
22
Yes
No
2
0
Active
The month the data was collected.
NUMBER
18
DAY
NUMBER
22
Yes
No
2
0
Active
The day the data was collected.
NUMBER
19
HOUR
NUMBER
22
Yes
No
2
0
Active
The hour the data was collected.
NUMBER
20
REPEATS
NUMBER
22
No
No
4
0
Active
The number of times the data from this day was transmitted.
NUMBER
21
ARCHIVAL_TAG_ID
VARCHAR2
10
Yes
No
Active
Archival Tag ID provided by the manufacturer.
VARCHAR2
22
ID
NUMBER
22
Yes
Yes
38
Active
Sequence to give each record a unique identifier.
NUMBER
7066
View: CTS_PAT_TAD_PERF_V
CTS_PAT_TAD_PERF_V
Published / External
Completed
PAT TAD Performance View
Loaded by batch 2083, 02-22-2008 12:10
Data View
Yes
CTSPAT
PAT TAD Performance View
1
ARCHIVAL_TAG_ID
VARCHAR2
10
Yes
No
Active
Archival Tagn Number
VARCHAR2
2
DEPTH_HISTOGRAM_COUNT
NUMBER
22
No
No
38
Active
Depth Histogram Count
NUMBER
3
RELEASE_DATE
DATE
7
No
No
Active
Date Archival Tag Was Applied
DATE
4
ACTUAL_POP_OFF_DATE
DATE
7
No
No
Active
Actual Data Arhcival Tag Popped Off Of Fish
DATE
7067
Table: CTS_PAT_TAG
CTS_PAT_TAG
Published / External
Completed
Information about the tag, its hardware configuration, and programming parameters.
Loaded by batch 2083, 02-22-2008 12:10
Data Table
Yes
CTSPAT
Information about the tag, its hardware configuration, and programming parameters.
1
ANIMAL_ID
NUMBER
22
No
No
10
0
Active
The unique identifier for the animal that the tag was attached. Foreign key to the CTS_ANIMALS table.
NUMBER
2
ARGOS_PTT_ID
VARCHAR2
10
Yes
No
Active
The unique PTT id of the transmitter used by the Argos Satellite Transmission Service provider.
VARCHAR2
3
ARCHIVAL_TAG_ID
VARCHAR2
10
Yes
No
Active
Archival Tag ID provided by the manufacturer.
VARCHAR2
4
INVESTIGATOR_ID
NUMBER
22
Yes
No
5
0
Active
The unique identifier of the investigator that is reponsible for the deployment of the tag. This is a foreign key to the CTS_PAT_INVESTIGATORS table.
NUMBER
5
BIN_PROFILE_ID
NUMBER
22
Yes
No
5
0
Active
The id of the bin profile used by this tag. Foreign key to the CTS_PAT_TAG_BIN table.
NUMBER
6
TAG_RESOLUTION_ID
NUMBER
22
Yes
No
38
Active
The resolution parameters associated with the tag. Foreign key to the CTS_PAT_TAG_RESOLUTION table.
NUMBER
7
PROGRAM_DATE
DATE
7
No
No
Active
The date the tag was programmed by the user.
DATE
8
RELEASE_DATE
DATE
7
No
No
Active
The date the tag was released on an animal.
DATE
9
RELEASE_LATITUDE
NUMBER
22
No
No
38
Active
The latitude of the location where the animal and the tag were released.
NUMBER
10
RELEASE_LONGITUDE
NUMBER
22
No
No
38
Active
The longitude of the location where the animal and the tag were released.
NUMBER
11
POPOFF_LATITUDE
NUMBER
22
No
No
38
Active
The latitude of the location where the tag popped off and began transmitting.
NUMBER
12
POPOFF_LONGITUDE
NUMBER
22
No
No
38
Active
The longitude of the location where the tag popped off and began transmitting.
NUMBER
13
ACTUAL_POP_OFF_DATE
DATE
7
No
No
Active
The actual date when the tag popped off. This may be the date the tag started transmitting or some days before depending on the premature release parameters.
DATE
14
PROGRAMMED_POP_OFF_DATE
DATE
7
No
No
Active
When the tag was programmed to pop off and begin transmitting.
DATE
15
REPORTING_FREQ_HOURS
NUMBER
22
No
No
38
Active
The reporting frequency in hours. This parameter determines how often the tag will summarize the data. The data will be collected and a summary report will be generated for the specified period .
NUMBER
16
DEPTH_OPERATIONAL_MIN_MTR
NUMBER
22
No
No
38
Active
The minimum operational depth of the tag.
NUMBER
17
DEPTH_OPERATIONAL_MAX_MTR
NUMBER
22
No
No
38
Active
The maximum operational depth of the tag.
NUMBER
18
DEPTH_OPERATIONAL_RES_MTR
NUMBER
22
No
No
38
Active
The resolution of the depth sensor.
NUMBER
19
LIGHT_OPERATIONAL_MIN_LLU
NUMBER
22
No
No
38
Active
The minimum operational light level.
NUMBER
20
LIGHT_OPERATIONAL_MAX_LLU
NUMBER
22
No
No
38
Active
The maximum operational light level.
NUMBER
21
TEMP_OPERATIONAL_MIN_C
NUMBER
22
No
No
38
Active
The minimum operational temperature.
NUMBER
22
TEMP_OPERATIONAL_MAX_C
NUMBER
22
No
No
38
Active
The maximum operational temperature.
NUMBER
23
LIGHT_OPERATIONAL_RES_LLU
NUMBER
22
No
No
38
Active
The resolution of the light sensor.
NUMBER
24
TEMP_OPERATIONAL_RES_C
NUMBER
22
No
No
38
Active
The resolution of the temperature sensor.
NUMBER
25
DEPTH_SAMPLE_FREQ_MINUTES
NUMBER
22
No
No
38
Active
How often the depth will be sampled.
NUMBER
26
TEMP_SAMPLE_FREQ_MINUTES
NUMBER
22
No
No
38
Active
How often the temperature will be sampled.
NUMBER
27
LIGHT_SAMPLE_FREQ_MINUTES
NUMBER
22
No
No
38
Active
How often the light level will be sampled.
NUMBER
28
RTC_TEMP_SAMPLE_FREQ_MINUTES
NUMBER
22
No
No
38
Active
How often the RTC Temperature will be sampled.
NUMBER
29
BATTERY_SAMPLE_FREQ_MINUTES
NUMBER
22
No
No
38
Active
How often the battery level will be sampled.
NUMBER
30
DEPTH_TEMP_SAMPLE_FREQ_MINUTES
NUMBER
22
No
No
38
Active
How often the minimum and maximum temperature at depth will be sampled.
NUMBER
31
HISTOGRAM_MEMORY_KB
NUMBER
22
No
No
38
Active
The amount of system memory dedicated to storing histograms.
NUMBER
32
HISTOGRAM_PRIORITY
VARCHAR2
10
No
No
Active
The priority of transmitting the histogram data.
VARCHAR2
33
PDT_MEMORY_KB
NUMBER
22
No
No
38
Active
The amount of system memory dedicated to storing PDT data.
NUMBER
34
PDT_PRIORITY
VARCHAR2
10
No
No
Active
The priority of transmitting the PDT data.
VARCHAR2
35
LOCATION_MEMORY_KB
NUMBER
22
No
No
38
Active
The amount of system memory dedicated to storing location information.
NUMBER
36
LOCATION_PRIORITY
VARCHAR2
10
No
No
Active
The priority of transmitting the location data.
VARCHAR2
37
ARCHIVAL_MEMORY_KB
NUMBER
22
No
No
38
Active
The amount of system memory dedicated to storing the high-frequency archival data.
NUMBER
38
STATUS_INTERVAL
NUMBER
22
No
No
38
Active
How often the transmitter will send status messages to the satellite.
NUMBER
39
PREMATURE_RELEASE
VARCHAR2
1
No
No
Active
Is the Premature Release feature enabled.
VARCHAR2
40
PREMATURE_RELEASE_TIME_HRS
NUMBER
22
No
No
38
Active
The amount of time used to determine if the premature release criteria has been met.
NUMBER
41
NUMBER_OF_OUTLIERS
NUMBER
22
No
No
38
Active
The number of outliers allowed during the evaluation of the premature release criteria.
NUMBER
42
DETECTION_DEPTH
NUMBER
22
No
No
38
Active
The depth to begin implementing the premature release criteria.
NUMBER
43
FIRST_TRANSMISSION_DATE
DATE
7
No
No
Active
The date the first transmission was received by the satellite.
DATE
44
DEPLOYER
VARCHAR2
30
No
No
Active
The person who deployed the tag.
VARCHAR2
45
HOOK_LOCATION
VARCHAR2
20
No
No
Active
The location of the hook on the animal.
VARCHAR2
46
HOOK_TYPE
VARCHAR2
20
No
No
Active
The type of hook used to catch the animal.
VARCHAR2
47
FISHING_METHOD
VARCHAR2
50
No
No
Active
The fishing method used to capture the animal.
VARCHAR2
48
BLEEDING
VARCHAR2
20
No
No
Active
Whether the animal was bleeding during tagging.
VARCHAR2
49
BAIT_TYPE
VARCHAR2
20
No
No
Active
The bait used to capture the animal.
VARCHAR2
50
SNOOTER
VARCHAR2
1
No
No
Active
Did the deployer use a Snooter to capture and restrain the animal.
VARCHAR2
51
RESUSCITATION
VARCHAR2
1
No
No
Active
Was the animal resuscitated prior to release.
VARCHAR2
52
RELEASE_CONDITION
VARCHAR2
50
No
No
Active
The condition of the animal when it was released.
VARCHAR2
53
COMMENTS
VARCHAR2
500
No
No
Active
Any comments pertaining to the capture, tagging, and release of the animal.
VARCHAR2
54
RESUSCITATION_TIME
NUMBER
22
No
No
38
Active
The amount of time the animal was resuscitated.
NUMBER
55
BLEEDING_TIME
NUMBER
22
No
No
38
Active
The amount of time the animal was bleeding.
NUMBER
56
PAT_NAME
VARCHAR2
50
No
No
Active
The name given to the Pop-off Archival Tag.
VARCHAR2
57
RELEAST_TIME_HOUR
NUMBER
22
No
No
38
Active
The hour the animal and the tag were released.
NUMBER
58
RELEASE_TIME_MINUTE
NUMBER
22
No
No
38
Active
The minute the animal and the tag were released.
NUMBER
59
DETECTION_RES
NUMBER
22
No
No
5
0
Active
The resolution used for the premature release detection.
NUMBER
60
TRIP_ID
VARCHAR2
6
No
No
Active
The unique identifier for the trip.
VARCHAR2
61
HOOK_REMOVED
VARCHAR2
1
No
No
Active
Was the hook removed from the animal prior to release.
VARCHAR2
62
ATTACHED_LINE_LENGTH
FLOAT
22
No
No
126
Active
The length of line attached to the animal if the hook was not removed.
FLOAT
63
REC_MESSAGES
NUMBER
22
No
No
38
Active
The number of messages received by the tag. Used as an indicator of tag performance.
NUMBER
64
CONV_TAG_AGENCY
VARCHAR2
3
No
No
Active
Conventional Tag Agency
VARCHAR2
65
CONV_TAG_ID
VARCHAR2
8
No
No
Active
Conventional Tag ID
VARCHAR2
66
DEPLOY_GEOM
SDO_GEOMETRY
1
No
No
Active
The Oracle SDO_Geometry representing the point location of the deployment.
SDO_GEOMETRY
67
POPOFF_GEOM
SDO_GEOMETRY
1
No
No
Active
The Oracle SDO_Geometry representing the point location of the pop-off/first transmission.
SDO_GEOMETRY
68
OTRACK_GEOM
SDO_GEOMETRY
1
No
No
Active
The Oracle SDO_Geometry representing the polyline of the original track derived from the light-based geolocations.
SDO_GEOMETRY
69
PTRACK_GEOM
SDO_GEOMETRY
1
No
No
Active
The Oracle SDO_Geometry representing the polyline of the probability track generated by the Kalman Filter algorithm.
SDO_GEOMETRY
70
STRACK_GEOM
SDO_GEOMETRY
1
No
No
Active
The Oracle SDO_Geometry representing the polyline of the smoothed track generated by the Kalman Filter algorithm.
SDO_GEOMETRY
71
VERSION
NUMBER
22
Yes
No
38
Active
The version of the pop-off archival tag.
NUMBER
72
MANUFACTURE_DATE
DATE
7
Yes
No
Active
The date the tag was manufactured.
DATE
73
ID
NUMBER
22
Yes
Yes
38
Active
Sequence to give each record a unique identifier.
NUMBER
7068
Table: CTS_PAT_TAG_BIN
CTS_PAT_TAG_BIN
Published / External
Completed
The bins defined for each tag. Each tag can be programmed to collect data in different temperature and depth bins.
Loaded by batch 2083, 02-22-2008 12:10
Data Table
Yes
CTSPAT
The bins defined for each tag. Each tag can be programmed to collect data in different temperature and depth bins.
1
BIN_PROFILE_ID
NUMBER
22
Yes
Yes
5
0
Active
Unique identifier given to each record.
NUMBER
2
BIN01
NUMBER
22
No
No
5
0
Active
The percentage of time the tag spent in the first temperature bin as defined by the user and reported in CTS_PAT_TAG_BIN.
NUMBER
3
BIN02
NUMBER
22
No
No
5
0
Active
The maximum depth of the second bin.
NUMBER
4
BIN03
NUMBER
22
No
No
5
0
Active
The maximum depth of the third bin.
NUMBER
5
BIN04
NUMBER
22
No
No
5
0
Active
The maximum depth of the fourth bin.
NUMBER
6
BIN05
NUMBER
22
No
No
5
0
Active
The maximum depth of the fifth bin.
NUMBER
7
BIN06
NUMBER
22
No
No
5
0
Active
The maximum depth of the sixth bin.
NUMBER
8
BIN07
NUMBER
22
No
No
5
0
Active
The maximum depth of the seventh bin.
NUMBER
9
BIN08
NUMBER
22
No
No
5
0
Active
The maximum depth of the eigth bin.
NUMBER
10
BIN09
NUMBER
22
No
No
5
0
Active
The maximum depth of the ninth bin.
NUMBER
11
BIN10
NUMBER
22
No
No
5
0
Active
The maximum depth of the tenth bin.
NUMBER
12
BIN11
NUMBER
22
No
No
5
0
Active
The maximum depth of the eleventh bin.
NUMBER
13
BIN12
NUMBER
22
No
No
5
0
Active
The maximum depth of the 12th bin.
NUMBER
14
BIN13
NUMBER
22
No
No
5
0
Active
The maximum temperature of the first bin.
NUMBER
15
BIN14
NUMBER
22
No
No
5
0
Active
The maximum temperature of the second bin.
NUMBER
16
BIN15
NUMBER
22
No
No
5
0
Active
The maximum temperature of the third bin.
NUMBER
17
BIN16
NUMBER
22
No
No
5
0
Active
The maximum temperature of the fourth bin.
NUMBER
18
BIN17
NUMBER
22
No
No
5
0
Active
The maximum temperature of the fifth bin.
NUMBER
19
BIN18
NUMBER
22
No
No
5
0
Active
The maximum temperature of the sixth bin.
NUMBER
20
BIN19
NUMBER
22
No
No
5
0
Active
The maximum temperature of the seventh bin.
NUMBER
21
BIN20
NUMBER
22
No
No
5
0
Active
The maximum temperature of the eigth bin.
NUMBER
22
BIN21
NUMBER
22
No
No
5
0
Active
The maximum temperature of the ninth bin.
NUMBER
23
BIN22
NUMBER
22
No
No
5
0
Active
The maximum temperature of the tenth bin.
NUMBER
24
BIN23
NUMBER
22
No
No
5
0
Active
The maximum temperature of the eleventh bin.
NUMBER
25
BIN24
NUMBER
22
No
No
5
0
Active
The maximum temperature of the 12th bin.
NUMBER
7069
View: CTS_PAT_TAG_DAYS_V
CTS_PAT_TAG_DAYS_V
Published / External
Completed
View Of PAT information With Decodes
Loaded by batch 2083, 02-22-2008 12:10
Data View
Yes
CTSPAT
View Of PAT information With Decodes
1
ID
NUMBER
22
Yes
No
38
Active
Sequential Key
NUMBER
2
ARCHIVAL_TAG_ID
VARCHAR2
10
Yes
No
Active
Archival Tag ID provided by the manufacturer.
VARCHAR2
3
PAT_NAME
VARCHAR2
50
No
No
Active
Manufacturer Of Archival Tag
VARCHAR2
4
INVESTIGATOR_ID
NUMBER
22
Yes
No
5
0
Active
Key to Principal Investigator Table
NUMBER
5
RELEASE_DATE
DATE
7
No
No
Active
Date Archival Tag was applied
DATE
6
PROGRAMMED_POP_OFF_DATE
DATE
7
No
No
Active
Date That Tag was Programmed To Popoff
DATE
7
ACTUAL_POP_OFF_DATE
DATE
7
No
No
Active
Actual Date Tag Popped Off
DATE
8
FIRST_TRANSMISSION_DATE
DATE
7
No
No
Active
Date Of First Transmission Of Archival Tag
DATE
9
DAYS_AT_LARGE
NUMBER
22
No
No
38
Active
Number Of Days Tag was sending data
NUMBER
10
DAYS_ON_ANIMAL
NUMBER
22
No
No
38
Active
Number of days tag was on animal
NUMBER
11
FULL_DEPLOY_100
NUMBER
22
No
No
38
Active
Full Deployment %
NUMBER
12
ACTUAL_DEPLOY_100
NUMBER
22
No
No
38
Active
Actual Deployment %
NUMBER
13
LOCATION_PRIORITY
VARCHAR2
10
No
No
Active
Location Priority
VARCHAR2
14
HISTOGRAM_PRIORITY
VARCHAR2
10
No
No
Active
Histogram Priority
VARCHAR2
15
PDT_PRIORITY
VARCHAR2
10
No
No
Active
PDT Priority
VARCHAR2
16
REPORTING_FREQ_HOURS
NUMBER
22
No
No
38
Active
Reporting Frequency In Hours
NUMBER
17
LOCATION_MEMORY_KB
NUMBER
22
No
No
38
Active
LOcation Memory In KB
NUMBER
18
HISTOGRAM_MEMORY_KB
NUMBER
22
No
No
38
Active
Histogram Memory In KB
NUMBER
19
PDT_MEMORY_KB
NUMBER
22
No
No
38
Active
PDT Memory In KB
NUMBER
20
NAME
VARCHAR2
100
No
No
Active
Name Of Primary Investigator
VARCHAR2
7070
View: CTS_PAT_TAG_PERFORMANCE_V
CTS_PAT_TAG_PERFORMANCE_V
Published / External
Completed
PAT TAG Performance View
Loaded by batch 2083, 02-22-2008 12:10
Data View
Yes
CTSPAT
PAT TAG Performance View
1
ID
NUMBER
22
Yes
No
38
Active
Sequential Key
NUMBER
2
NAME
VARCHAR2
100
No
No
Active
Name Of Primary Investigator
VARCHAR2
3
ARCHIVAL_TAG_ID
VARCHAR2
10
Yes
No
Active
Archival Tag Number
VARCHAR2
4
PAT_NAME
VARCHAR2
50
No
No
Active
Archival Tag Name
VARCHAR2
5
INVESTIGATOR_ID
NUMBER
22
Yes
No
5
0
Active
Key To Primary Investigator Table
NUMBER
6
RELEASE_DATE
DATE
7
No
No
Active
Date Tag was applied to animal
DATE
7
PROGRAMMED_POP_OFF_DATE
DATE
7
No
No
Active
Date Tag is programmed to fall off of animal
DATE
8
ACTUAL_POP_OFF_DATE
DATE
7
No
No
Active
Actual Date Tag popped Off of animal
DATE
9
FIRST_TRANSMISSION_DATE
DATE
7
No
No
Active
First Tranmission date Of archival tag
DATE
10
DAYS_AT_LARGE
NUMBER
22
No
No
38
Active
Number Of Days Archival Tag is transmitting data
NUMBER
11
DAYS_ON_ANIMAL
NUMBER
22
No
No
38
Active
Number Of Days Archival Tag is on animal
NUMBER
12
FULL_DEPLOY_100
NUMBER
22
No
No
38
Active
Full Deployment %
NUMBER
13
ACTUAL_DEPLOY_100
NUMBER
22
No
No
38
Active
Actual Deployment %
NUMBER
14
LOCATION_PRIORITY
VARCHAR2
10
No
No
Active
Location Priority
VARCHAR2
15
HISTOGRAM_PRIORITY
VARCHAR2
10
No
No
Active
Histogram Priority
VARCHAR2
16
PDT_PRIORITY
VARCHAR2
10
No
No
Active
PDT Priority
VARCHAR2
17
REPORTING_FREQ_HOURS
NUMBER
22
No
No
38
Active
Archival Tag Reporting Frequency In Hours
NUMBER
18
LOCATION_MEMORY_KB
NUMBER
22
No
No
38
Active
Location Memory IN KB
NUMBER
19
HISTOGRAM_MEMORY_KB
NUMBER
22
No
No
38
Active
Histogram Memory in KB
NUMBER
20
PDT_MEMORY_KB
NUMBER
22
No
No
38
Active
PDT Memory In KB
NUMBER
21
DEPTH_HISTOGRAM_COUNT
NUMBER
22
No
No
38
Active
Depth Histogram Count
NUMBER
22
TEMP_HISTOGRAM_COUNT
NUMBER
22
No
No
38
Active
Temporary Histogram Count
NUMBER
23
PDT_HISTOGRAM_COUNT
NUMBER
22
No
No
38
Active
PDT Histogram Count
NUMBER
24
LOCATIONS_COUNT
NUMBER
22
No
No
38
Active
Number Of Locations
NUMBER
25
MESSAGES
NUMBER
22
No
No
38
Active
Number Of Messages
NUMBER
26
MAX_TRANSMISSIONS
NUMBER
22
No
No
38
Active
Maimum Number Of Transmissions
NUMBER
27
MAX_BATTERY
NUMBER
22
No
No
38
Active
Maximum Battery Voltage
NUMBER
28
MIN_BATTERY
NUMBER
22
No
No
38
Active
Minimum Battert Voltage
NUMBER
7071
Table: CTS_PAT_TAG_RESOLUTION
CTS_PAT_TAG_RESOLUTION
Published / External
Completed
The resolution of the sensors (depth, temperature, light, etc.) used in the tag.
Loaded by batch 2083, 02-22-2008 12:10
Data Table
Yes
CTSPAT
The resolution of the sensors (depth, temperature, light, etc.) used in the tag.
1
TAG_RESOLUTION_ID
NUMBER
22
Yes
No
38
Active
Identifier to associate all resolution records to a particular resolution profile.
NUMBER
2
TYPE
VARCHAR2
10
Yes
No
Active
The type of sensor (light, temperature, depth, etc.)
VARCHAR2
3
MINIMUM
NUMBER
22
Yes
No
38
Active
The minimum operating parameter of the sensor.
NUMBER
4
RESOLUTION
NUMBER
22
No
No
38
Active
The resolution of the sensor.
NUMBER
5
ID
NUMBER
22
Yes
Yes
38
Active
Unique identifer for each resolution record.
NUMBER
7072
Table: CTS_PAT_TAT
CTS_PAT_TAT
Published / External
Completed
Time At Temperature (TAT) - the amount of time the tag spent in a pre-defined temperature bin.
Loaded by batch 2083, 02-22-2008 12:10
Data Table
Yes
CTSPAT
Time At Temperature (TAT) - the amount of time the tag spent in a pre-defined temperature bin.
1
ARGOS_PTT_ID
VARCHAR2
10
Yes
No
Active
The unique PTT id of the transmitter used by the Argos Satellite Transmission Service provider.
VARCHAR2
2
RECEPTION_DATE
DATE
7
Yes
No
Active
The date the data was received by the satellite.
DATE
3
RECEPTION_TIME
VARCHAR2
10
Yes
No
Active
The time the data was received by the satellite.
VARCHAR2
4
BIN_1
FLOAT
22
No
No
9
Active
The percentage of time the tag spent in the first temperature bin as defined by the user and reported in CTS_PAT_TAG_BIN.
FLOAT
5
BIN_2
FLOAT
22
No
No
9
Active
The percentage of time the tag spent in the second temperature bin as defined by the user and reported in CTS_PAT_TAG_BIN.
FLOAT
6
BIN_3
FLOAT
22
No
No
9
Active
The percentage of time the tag spent in the third temperature bin as defined by the user and reported in CTS_PAT_TAG_BIN.
FLOAT
7
BIN_4
FLOAT
22
No
No
9
Active
The percentage of time the tag spent in the fourth temperature bin as defined by the user and reported in CTS_PAT_TAG_BIN.
FLOAT
8
BIN_5
FLOAT
22
No
No
9
Active
The percentage of time the tag spent in the fifth temperature bin as defined by the user and reported in CTS_PAT_TAG_BIN.
FLOAT
9
BIN_6
FLOAT
22
No
No
9
Active
The percentage of time the tag spent in the sixth temperature bin as defined by the user and reported in CTS_PAT_TAG_BIN.
FLOAT
10
BIN_7
FLOAT
22
No
No
9
Active
The percentage of time the tag spent in the seventh temperature bin as defined by the user and reported in CTS_PAT_TAG_BIN.
FLOAT
11
BIN_8
FLOAT
22
No
No
9
Active
The percentage of time the tag spent in the eighth temperature bin as defined by the user and reported in CTS_PAT_TAG_BIN.
FLOAT
12
BIN_9
FLOAT
22
No
No
9
Active
The percentage of time the tag spent in the ninth temperature bin as defined by the user and reported in CTS_PAT_TAG_BIN.
FLOAT
13
BIN_10
FLOAT
22
No
No
9
Active
The percentage of time the tag spent in the tenth temperature bin as defined by the user and reported in CTS_PAT_TAG_BIN.
FLOAT
14
BIN_11
FLOAT
22
No
No
9
Active
The percentage of time the tag spent in the eleventh temperature bin as defined by the user and reported in CTS_PAT_TAG_BIN.
FLOAT
15
BIN_12
FLOAT
22
No
No
9
Active
The percentage of time the tag spent in the twelveth temperature bin as defined by the user and reported in CTS_PAT_TAG_BIN.
FLOAT
16
YEAR
NUMBER
22
Yes
No
4
0
Active
The year the data was collected.
NUMBER
17
MONTH
NUMBER
22
Yes
No
2
0
Active
The month the data was collected.
NUMBER
18
DAY
NUMBER
22
Yes
No
2
0
Active
The day the data was collected.
NUMBER
19
HOUR
NUMBER
22
Yes
No
2
0
Active
The hour the data was collected.
NUMBER
20
REPEATS
NUMBER
22
No
No
4
0
Active
The number of times the data from this day was transmitted.
NUMBER
21
ARCHIVAL_TAG_ID
VARCHAR2
10
Yes
No
Active
Archival Tag ID provided by the manufacturer.
VARCHAR2
22
ID
NUMBER
22
Yes
Yes
38
Active
Sequence to give each record a unique identifier.
NUMBER
7073
View: CTS_PAT_TAT_PERF_V
CTS_PAT_TAT_PERF_V
Published / External
Completed
PAT TAT Performance View
Loaded by batch 2083, 02-22-2008 12:10
Data View
Yes
CTSPAT
PAT TAT Performance View
1
ARCHIVAL_TAG_ID
VARCHAR2
10
Yes
No
Active
Archival Tag Applied
VARCHAR2
2
TEMP_HISTOGRAM_COUNT
NUMBER
22
No
No
38
Active
Temporary Histogram Count Per Tag
NUMBER
3
RELEASE_DATE
DATE
7
No
No
Active
Date Tag was applied to animal
DATE
4
ACTUAL_POP_OFF_DATE
DATE
7
No
No
Active
Date Tag popped off of animal
DATE
7074
Table: CTS_PHYSICAL_DATA
CTS_PHYSICAL_DATA
Published / External
Completed
Environmental observations of the location where the animal was caught.
Loaded by batch 2083, 02-22-2008 12:10
Data Table
Yes
CTSPAT
Environmental observations of the location where the animal was caught.
1
PHYSICAL_DATA_ID
NUMBER
22
Yes
Yes
6
0
Active
Code for agency collecting the environment data.
NUMBER
2
WATERCOLOR
VARCHAR2
3
No
No
Active
Code to identify water color.
VARCHAR2
3
WATER_DEPTH_M
NUMBER
22
No
No
4
0
Active
Depth of water in feet at site.
NUMBER
4
SURFACE_TEMP_DEGC
NUMBER
22
No
No
4
2
Active
The surface temperature of the water in degrees centigrade.
NUMBER
5
SURFACE_SALINITY_PPT
NUMBER
22
No
No
4
2
Active
Surface salinity in PARTS/1000 at the site.
NUMBER
6
SURFACE_DO_MGPL
NUMBER
22
No
No
4
1
Active
Surface dissolved oxygen at the site (milligrams/liter of water).
NUMBER
7
AIR_TEMP_DEGC
NUMBER
22
No
No
4
1
Active
Air temperature at the site in degrees centigrade.
NUMBER
8
WIND_SPEED_KNOTS
NUMBER
22
No
No
2
0
Active
Wind speed at the site in knots.
NUMBER
9
WIND_DIRECTION_DEG
NUMBER
22
No
No
3
0
Active
Wind direction at the site in compass degrees.
NUMBER
10
PERCENT_CLOUD_COVER
NUMBER
22
No
No
3
0
Active
Percentage of cloud cover at the site.
NUMBER
11
EDITCYC
NUMBER
22
No
No
2
0
Active
A control field, (0) indicates an add, (1) indicates an update. Once update, records are stored with a value of 0 in this field.
NUMBER
12
EDITDAT
DATE
7
No
No
Active
The date the record was initially entered, or last updated, whichever is later.
DATE
13
DELEDAT
DATE
7
No
No
Active
A control field used to delete existing records from this table. No records are stored with a value in this field.
DATE
7075
Table: CTS_PLACES
CTS_PLACES
Published / External
Completed
Table Of Valid Place Codes
Loaded by batch 2083, 02-22-2008 12:10
Data Table
Yes
CTSPAT
Table Of Valid Place Codes
1
PLACE_ID
VARCHAR2
3
Yes
Yes
Active
The place code where the tag was found.
VARCHAR2
2
PLACE_DESCRIPTION
VARCHAR2
30
No
No
Active
Place name.
VARCHAR2
7076
Table: CTS_PRIORITY
CTS_PRIORITY
Published / External
Completed
Table Of Valid Priority Descriptions.
Loaded by batch 2083, 02-22-2008 12:10
Data Table
Yes
CTSPAT
Table Of Valid Priority Descriptions.
1
PRIORITY
VARCHAR2
10
No
No
Active
Property Description
VARCHAR2
7077
View: CTS_RECAPTURE_LOOKUP_V
CTS_RECAPTURE_LOOKUP_V
Published / External
Completed
View of Tags
Loaded by batch 2083, 02-22-2008 12:10
Data View
Yes
CTSPAT
View of Tags
1
ANIMAL_ID
NUMBER
22
No
No
10
0
Active
Sequential Key
NUMBER
2
INTERACTION_ORDER
NUMBER
22
No
No
2
0
Active
Code To indicate last cycle of release recapture. 1 = initial release, 2 = recpature,3=release after recapture,4=recapture after second release etc
NUMBER
3
AGENCY_ID
VARCHAR2
3
No
No
Active
Agency Cose Associated With First Tag
VARCHAR2
4
TAG_ID
VARCHAR2
8
No
No
Active
First Tag Number
VARCHAR2
5
NEXT_TAG_AGENCY_ID
VARCHAR2
3
No
No
Active
Code Of Agency Associated With Second Tag On Record
VARCHAR2
6
NEXT_TAG_ID
VARCHAR2
8
No
No
Active
Tag Number Of Second Tag On Record
VARCHAR2
7
TAG_DATE
VARCHAR2
10
No
No
Active
Date Tag Was Applied
VARCHAR2
7078
Table: CTS_RELEASE_CONDITIONS
CTS_RELEASE_CONDITIONS
Published / External
Completed
Table Of Valid Release Conditions
Loaded by batch 2083, 02-22-2008 12:10
Data Table
Yes
CTSPAT
Table Of Valid Release Conditions
1
RELEASE_CONDITION
VARCHAR2
50
No
No
Active
Release condition
VARCHAR2
7079
Table: CTS_RETURNED_TAGS
CTS_RETURNED_TAGS
Published / External
Completed
Used To hold information on returned tags until they are processed
Loaded by batch 2083, 02-22-2008 12:10
Data Table
Yes
CTSPAT
Used To hold information on returned tags until they are processed
1
TAG_ID
VARCHAR2
8
No
No
Active
Tag Number
VARCHAR2
2
TAG_DATE
DATE
7
No
No
Active
Date Animal was recaptured
DATE
3
MY_COMMENTS
VARCHAR2
200
No
No
Active
ANy Other comment about this fish or record
VARCHAR2
7080
Table: CTS_SAMPLES
CTS_SAMPLES
Published / External
Completed
Data Table describing sampling done
Loaded by batch 2083, 02-22-2008 12:10
Data Table
Yes
CTSPAT
Data Table describing sampling done
1
SAMPLE_ID
NUMBER
22
Yes
Yes
6
0
Active
Code for agency collecting the sample data.
NUMBER
2
SAMPLE_TYPE
VARCHAR2
30
Yes
Yes
Active
Code to indicate type of sample done
VARCHAR2
3
AMOUNT_SAMPLED
NUMBER
22
No
No
6
2
Active
Measurement of the quantity of what was sampled.
NUMBER
4
SAMPLE_UNITS
VARCHAR2
4
No
No
Active
Units Of Sampling Meausrements
VARCHAR2
5
SAMPLE_DESCRIPTION
VARCHAR2
200
No
No
Active
Description Of Sampling Methodology
VARCHAR2
6
EDITCYC
NUMBER
22
No
No
2
0
Active
A control field, (0) indicates an add, (1) indicates an update. Once update, records are stored with a value of 0 in this field.
NUMBER
7
EDITDAT
DATE
7
No
No
Active
The date the record was initially entered, or last updated, whichever is later.
DATE
8
DELEDAT
DATE
7
No
No
Active
A control field used to delete existing records from this table. No records are stored with a value in this field.
DATE
7081
Table: CTS_SEX
CTS_SEX
Published / External
Completed
Table Of Valid Sex Codes
Loaded by batch 2083, 02-22-2008 12:10
Data Table
Yes
CTSPAT
Table Of Valid Sex Codes
1
SEX_ID
VARCHAR2
1
Yes
No
Active
Mnemonic Sex Code
VARCHAR2
2
SEX_DESCRIPTION
VARCHAR2
10
Yes
No
Active
Code Description
VARCHAR2
7082
Table: CTS_SPECIES
CTS_SPECIES
Published / External
Completed
Table Of Valid Species Codes Used in NMFS Cooperative Tagging System
Loaded by batch 2083, 02-22-2008 12:10
Data Table
Yes
CTSPAT
Table Of Valid Species Codes Used in NMFS Cooperative Tagging System
1
SPECIES_ID
VARCHAR2
3
Yes
Yes
Active
The 3 letter species code Used in the CTS System
VARCHAR2
2
COMMON_NAME
VARCHAR2
21
No
No
Active
The common name for the fish species.
VARCHAR2
3
SCIENTIFIC_NAME
VARCHAR2
46
No
No
Active
The scientific name for the fish's species.
VARCHAR2
4
MAX_SUST_VELOCITY
NUMBER
22
No
No
3
0
Active
Maxium Sustained Velocity (often null)
NUMBER
7083
Table: CTS_STATES
CTS_STATES
Published / External
Completed
Table Of Valid State Codes
Loaded by batch 2083, 02-22-2008 12:10
Data Table
Yes
CTSPAT
Table Of Valid State Codes
1
STATE_ID
VARCHAR2
2
Yes
Yes
Active
Mnemonic state code.
VARCHAR2
2
STATE_NAME
VARCHAR2
30
No
No
Active
The state name.
VARCHAR2
7084
View: CTS_STATES_V
CTS_STATES_V
Published / External
Completed
View Of Valid State Codes with the associated state name
Loaded by batch 2083, 02-22-2008 12:10
Data View
Yes
CTSPAT
View Of Valid State Codes with the associated state name
1
STATE_ID
VARCHAR2
30
No
No
Active
State Code
VARCHAR2
2
STATE_NAME
VARCHAR2
30
No
No
Active
State Name
VARCHAR2
7085
Table: CTS_SUBAREAS
CTS_SUBAREAS
Published / External
Completed
Table Of Valid subarea codes
Loaded by batch 2083, 02-22-2008 12:10
Data Table
Yes
CTSPAT
Table Of Valid subarea codes
1
SUBAREA_ID
VARCHAR2
3
Yes
No
Active
Menmonic Subarea Code
VARCHAR2
2
SUBAREA_DESCRIPTION
VARCHAR2
50
No
No
Active
Subarea Description
VARCHAR2
3
SUBAREA_COUNTRY
VARCHAR2
10
No
No
Active
Country Code Associated WIth Subarea
VARCHAR2
4
SUBAREA_STATE
VARCHAR2
10
No
No
Active
State Code Associated WIth Subarea
VARCHAR2
7086
Table: CTS_TAGGER_TYPE
CTS_TAGGER_TYPE
Published / External
Completed
Table Of Valid Tagger Types
Loaded by batch 2083, 02-22-2008 12:10
Data Table
Yes
CTSPAT
Table Of Valid Tagger Types
1
TAGGER_ID
VARCHAR2
3
Yes
No
Active
Tagger Type Mnemonic Code
VARCHAR2
2
TAGGER_DESCRIPTION
VARCHAR2
50
No
No
Active
Tagger Type Description
VARCHAR2
7087
Table: CTS_TAGGING_LOCATION
CTS_TAGGING_LOCATION
Published / External
Completed
Table Of Valid Location Codes
Loaded by batch 2083, 02-22-2008 12:10
Data Table
Yes
CTSPAT
Table Of Valid Location Codes
1
LOCATION_ID
VARCHAR2
3
Yes
No
Active
Mnemonic Location Code
VARCHAR2
2
LOCATION_DESCRIPTION
VARCHAR2
50
No
No
Active
LOcation Description
VARCHAR2
7088
Table: CTS_TAGGING_METHODS
CTS_TAGGING_METHODS
Published / External
Completed
Table Of Valid Tagging Methods
Loaded by batch 2083, 02-22-2008 12:10
Data Table
Yes
CTSPAT
Table Of Valid Tagging Methods
1
METHOD_ID
NUMBER
22
Yes
Yes
6
0
Active
Code identifying this description of the methodology used in the tagging of this animal.
NUMBER
2
TAG_TIME_MINS
NUMBER
22
No
No
4
0
Active
Time taken to tag and release the animal.
NUMBER
3
TAGGING_PLATFORM
VARCHAR2
1
No
No
Active
Place fish was tagged: B-boat, W-water, N-net, U-unknown
VARCHAR2
4
HOOKS_REMOVED
VARCHAR2
1
No
No
Active
Were hooks removed from animal?Y-yes, N-no, U-unknown
VARCHAR2
5
ANIMAL_RETAINED
VARCHAR2
1
No
No
Active
Was animal kept alive and retained after catch for later determination of survival rates? Y-yes, N-no, U-unknown
VARCHAR2
6
ANIMAL_MOVED
VARCHAR2
1
No
No
Active
Was tagged animal removed to new location before release? Y-yes, N-no, U-unknown
VARCHAR2
7089
Table: CTS_TAG_TYPES
CTS_TAG_TYPES
Published / External
Completed
Table Of Valid Tah Types
Loaded by batch 2083, 02-22-2008 12:10
Data Table
Yes
CTSPAT
Table Of Valid Tah Types
1
TAG_TYPE
VARCHAR2
3
Yes
No
Active
Mnemonic Tag Type Code
VARCHAR2
2
TAG_DESCRIPTION
VARCHAR2
50
No
No
Active
Tag Type Description
VARCHAR2
7090
View: CTS_USER_APPLICATIONS_V
CTS_USER_APPLICATIONS_V
Published / External
Completed
Table to indicate valid users of CTSPAT Tables
Loaded by batch 2083, 02-22-2008 12:10
Data View
Yes
CTSPAT
Table to indicate valid users of CTSPAT Tables
1
ID
NUMBER
22
No
No
38
Active
Sequential Key
NUMBER
2
USERNAME
VARCHAR2
50
No
No
Active
Oracle Id
VARCHAR2
3
APPLICATION
CHAR
3
No
No
Active
Indicates Application For Which user is authrorized
CHAR
7091
Table: CTS_USER_PROFILES
CTS_USER_PROFILES
Published / External
Completed
Control Table Used For System Access
Loaded by batch 2083, 02-22-2008 12:10
Data Table
Yes
CTSPAT
Control Table Used For System Access
1
ID
NUMBER
22
Yes
No
38
Active
Sequential Key
NUMBER
2
FULLNAME
VARCHAR2
200
No
No
Active
Full Name Of User
VARCHAR2
3
USERNAME
VARCHAR2
50
No
No
Active
Oracle Id of system user
VARCHAR2
4
PASSWORD
VARCHAR2
50
No
No
Active
password for this system
VARCHAR2
5
IS_CTS
VARCHAR2
1
No
No
Active
Is This person a CTS User
VARCHAR2
6
IS_PAT
VARCHAR2
1
No
No
Active
Is This person a Popup Arhcival Tag User
VARCHAR2
7092
Table: CTS_VESSELS
CTS_VESSELS
Published / External
Completed
Table Of Valid Vessels
Loaded by batch 2083, 02-22-2008 12:10
Data Table
Yes
CTSPAT
Table Of Valid Vessels
1
AGENCY_ID
VARCHAR2
3
Yes
Yes
Active
Code for agency collecting this vessel information.
VARCHAR2
2
VESSEL_ID
NUMBER
22
Yes
Yes
6
0
Active
Agency-supplied code identifying the vessel involved in the release or recapture of the animal.
NUMBER
3
VESSEL_NAME
VARCHAR2
25
No
No
Active
Vessel name.
VARCHAR2
4
COUNTRY_ID
VARCHAR2
2
No
No
Active
Country of registration of the vessel.
VARCHAR2
7093
Table: CTS_WATER_BODIES
CTS_WATER_BODIES
Published / External
Completed
Table Of Valid Water Body Code
Loaded by batch 2083, 02-22-2008 12:10
Data Table
Yes
CTSPAT
Table Of Valid Water Body Code
1
WATER_BODY_ID
NUMBER
22
Yes
Yes
6
3
Active
The water body code.
NUMBER
2
WATER_BODY_NAME
VARCHAR2
60
No
No
Active
The name of the water body.
VARCHAR2
3
LATITUDE
NUMBER
22
No
No
14
6
Active
Latitude Where Waterbody can be found
NUMBER
4
LONGITUDE
NUMBER
22
No
No
14
6
Active
Longitude Where Waterbody can be found
NUMBER
7094
Table: CTS_WEIGHT_DETERMINATION
CTS_WEIGHT_DETERMINATION
Published / External
Completed
Table of Valid Weight Determination Codes
Loaded by batch 2083, 02-22-2008 12:10
Data Table
Yes
CTSPAT
Table of Valid Weight Determination Codes
1
WEIGHT_ID
VARCHAR2
1
Yes
No
Active
Weight Determination Code
VARCHAR2
2
WEIGHT_DESCRIPTION
VARCHAR2
50
No
No
Active
Weight Determination Description.
VARCHAR2
7095
Table: CTS_WEIGHT_TYPE
CTS_WEIGHT_TYPE
Published / External
Completed
Table Of Valid Weight Types
Loaded by batch 2083, 02-22-2008 12:10
Data Table
Yes
CTSPAT
Table Of Valid Weight Types
1
TYPE_ID
VARCHAR2
1
Yes
No
Active
Mnemonic Code
VARCHAR2
2
TYPE_DESCRIPTION
VARCHAR2
50
No
No
Active
Code Description
VARCHAR2
7096
Table: CTS_WEIGHT_UNIT
CTS_WEIGHT_UNIT
Published / External
Completed
Table Of Valid Weight Units
Loaded by batch 2083, 02-22-2008 12:10
Data Table
Yes
CTSPAT
Table Of Valid Weight Units
1
UNIT_ID
VARCHAR2
3
Yes
No
Active
Mnemonic Weight Unit Code
VARCHAR2
2
UNIT_DESCRIPTION
VARCHAR2
50
No
No
Active
Weight Unit Code Description
VARCHAR2
7097
Table: CTS_YESNO
CTS_YESNO
Published / External
Completed
Table Of Valid Answer Codes
Loaded by batch 2083, 02-22-2008 12:10
Data Table
Yes
CTSPAT
Table Of Valid Answer Codes
1
ANSWER_CODE
VARCHAR2
1
No
No
Active
Mnemonic Answer Code
VARCHAR2
2
ANSWER
VARCHAR2
3
No
No
Active
Answer Code Description
VARCHAR2
7098
View: FIFTH_INTERACTIONS_V
FIFTH_INTERACTIONS_V
Published / External
Completed
View Of Fifth Tagging Interactions
Loaded by batch 2083, 02-22-2008 12:10
Data View
Yes
CTSPAT
View Of Fifth Tagging Interactions
1
ANIMAL_ID
NUMBER
22
Yes
No
10
0
Active
Key to Identifies Animal
NUMBER
2
SPECIES
VARCHAR2
3
Yes
No
Active
Species Code Used In NMFS Tagging Program
VARCHAR2
3
SEX
VARCHAR2
1
No
No
Active
Code to indicate sex of the animal
VARCHAR2
4
AGENCY_ID
VARCHAR2
3
Yes
No
Active
Code to Indicate Tagging agency of identifying tag on animal (tag1)
VARCHAR2
5
TAG_ID
VARCHAR2
8
Yes
No
Active
Tagnumber
VARCHAR2
6
EVENT_ID
NUMBER
22
Yes
No
2
0
Active
Code to identify tagging event
NUMBER
7
TAG_DATE
DATE
7
Yes
No
Active
Date animal was released or recaptured.
DATE
8
NEXT_TAG_AGENCY
VARCHAR2
3
No
No
Active
Code For Agency That Issued the next tag (second tag) on this record
VARCHAR2
9
NEXT_TAG_ID
VARCHAR2
8
No
No
Active
Code to Indicate Tagging agency of identifying tag on animal (nexttag)
VARCHAR2
10
INTERACTION_ORDER
NUMBER
22
Yes
No
2
0
Active
Number denoting the order of the interaction.
NUMBER
11
LENGTH
NUMBER
22
No
No
4
0
Active
Length of animal tagged based on the lengthunit, lengthtype, and lengthdet.
NUMBER
12
LENGTH_UNIT
VARCHAR2
2
No
No
Active
Units for Length Measurement
VARCHAR2
13
LENGTH_TYPE
VARCHAR2
1
No
No
Active
Code to determine The Type Of Length MEasurement taken
VARCHAR2
14
LENGTH_DETERMINATION
VARCHAR2
1
No
No
Active
Code To Indicate How Length Was determined
VARCHAR2
15
WEIGHT
NUMBER
22
No
No
6
2
Active
Weight of an animal tagged, based upon weightunit, weighttype and weightdet.
NUMBER
16
WEIGHT_UNIT
VARCHAR2
2
No
No
Active
Units for Weight Measurement
VARCHAR2
17
WEIGHT_TYPE
VARCHAR2
1
No
No
Active
Code For Type Of Weight Measurement
VARCHAR2
18
WEIGHT_DETERMINATION
VARCHAR2
1
No
No
Active
Code For How Weight Was Determined
VARCHAR2
19
LATITUDE
NUMBER
22
No
No
30
16
Active
Numeric value for the latitude of the tagging location.
NUMBER
20
LONGITUDE
NUMBER
22
No
No
30
16
Active
Numeric value the the longitude of the tagging location.
NUMBER
21
STAT_ZONE_ID
NUMBER
22
No
No
4
1
Active
Code to indciate State Zone
NUMBER
22
COUNTRY_ID
VARCHAR2
2
No
No
Active
Cde to indicate Country
VARCHAR2
23
STATE_ID
VARCHAR2
2
No
No
Active
Code to indicate state
VARCHAR2
24
WATER_BODY_ID
NUMBER
22
No
No
6
3
Active
Code to Indicate waterbody of where tagging took place
NUMBER
25
PLACE_ID
VARCHAR2
3
No
No
Active
Code to indicate place of wheer tagging took palce
VARCHAR2
26
GEAR_ID
VARCHAR2
3
No
No
Active
Code for gear used to catch the animal.
VARCHAR2
27
BAIT_TYPE
VARCHAR2
1
No
No
Active
Code for bait used: (A)rtificial, (L)ive, (D)ead, (U)nknown
VARCHAR2
28
METHOD_ID
NUMBER
22
No
No
6
0
Active
Code To indicate tagging methodology Used
NUMBER
29
SAMPLE_ID
NUMBER
22
No
No
6
0
Active
Code to indicate Sampling Methodology
NUMBER
30
CAPTAIN_AGENCY
VARCHAR2
3
No
No
Active
COde to indicate agency which assigned angler code for boat captain
VARCHAR2
31
CAPTAIN_ID
NUMBER
22
No
No
6
0
Active
Unique numeric code assigned to an individual captain. Must be greater than zero or -99999.
NUMBER
32
TAGGER_INITIALS
VARCHAR2
3
No
No
Active
Initials Of Taggers
VARCHAR2
33
TAGGER_TYPE
VARCHAR2
1
No
No
Active
Indicates Type Of Tagger
VARCHAR2
34
TAGGER_AFFILIATION
VARCHAR2
3
No
No
Active
Code Of Agency that is affiliated With The Tagger
VARCHAR2
35
VESSEL_AGENCY
VARCHAR2
3
No
No
Active
Agency For Vessel COode
VARCHAR2
36
VESSEL_ID
NUMBER
22
No
No
6
0
Active
Agency supplied code identifying the vessel involved in the release or recapture of the animal.
NUMBER
37
PHYSICAL_DATA_ID
NUMBER
22
No
No
6
0
Active
Physical Data Identification Number
NUMBER
38
NOTES
NUMBER
22
No
No
3
0
Active
Any Other Notes On Tagging
NUMBER
39
FIGHT_HOURS
NUMBER
22
No
No
2
0
Active
Number Of Hours Spent FIghting/Landings Fish
NUMBER
40
FIGHT_MINUTES
NUMBER
22
No
No
2
0
Active
Number Of Minutes (up to 59) spent FIghting/Landings Fish
NUMBER
41
ANGLER_AGENCY
VARCHAR2
3
No
No
Active
Agency That Has Angler Code list
VARCHAR2
42
ANGLER_ID
NUMBER
22
No
No
6
0
Active
Unique identifier for each person in the database.
NUMBER
43
DATE_ENTERED
DATE
7
No
No
Active
The date the data was entered.
DATE
7099
View: FIRST_INTERACTIONS_V
FIRST_INTERACTIONS_V
Published / External
Completed
View Of FIrst Tagging Interactions
Loaded by batch 2083, 02-22-2008 12:10
Data View
Yes
CTSPAT
View Of FIrst Tagging Interactions
1
ANIMAL_ID
NUMBER
22
Yes
No
10
0
Active
Key to Identifies Animal
NUMBER
2
SPECIES
VARCHAR2
3
Yes
No
Active
Species Code Used In NMFS Tagging Program
VARCHAR2
3
SEX
VARCHAR2
1
No
No
Active
Code to indicate sex of the animal
VARCHAR2
4
AGENCY_ID
VARCHAR2
3
Yes
No
Active
Code to Indicate Tagging agency of identifying tag on animal (tag1)
VARCHAR2
5
TAG_ID
VARCHAR2
8
Yes
No
Active
Tagnumber
VARCHAR2
6
EVENT_ID
NUMBER
22
Yes
No
2
0
Active
Code to identify tagging event
NUMBER
7
TAG_DATE
DATE
7
Yes
No
Active
Date animal was released or recaptured.
DATE
8
NEXT_TAG_AGENCY
VARCHAR2
3
No
No
Active
Code For Agency That Issued the next tag (second tag) on this record
VARCHAR2
9
NEXT_TAG_ID
VARCHAR2
8
No
No
Active
Code to Indicate Tagging agency of identifying tag on animal (nexttag)
VARCHAR2
10
INTERACTION_ORDER
NUMBER
22
Yes
No
2
0
Active
Number denoting the order of the interaction.
NUMBER
11
LENGTH
NUMBER
22
No
No
4
0
Active
Length of animal tagged based on the lengthunit, lengthtype, and lengthdet.
NUMBER
12
LENGTH_UNIT
VARCHAR2
2
No
No
Active
Units for Length Measurement
VARCHAR2
13
LENGTH_TYPE
VARCHAR2
1
No
No
Active
Code to determine The Type Of Length MEasurement taken
VARCHAR2
14
LENGTH_DETERMINATION
VARCHAR2
1
No
No
Active
Code To Indicate How Length Was determined
VARCHAR2
15
WEIGHT
NUMBER
22
No
No
6
2
Active
Weight of an animal tagged, based upon weightunit, weighttype and weightdet.
NUMBER
16
WEIGHT_UNIT
VARCHAR2
2
No
No
Active
Units for Weight Measurement
VARCHAR2
17
WEIGHT_TYPE
VARCHAR2
1
No
No
Active
Code For Type Of Weight Measurement
VARCHAR2
18
WEIGHT_DETERMINATION
VARCHAR2
1
No
No
Active
Code For How Weight Was Determined
VARCHAR2
19
LATITUDE
NUMBER
22
No
No
30
16
Active
Numeric value for the latitude of the tagging location.
NUMBER
20
LONGITUDE
NUMBER
22
No
No
30
16
Active
Numeric value the the longitude of the tagging location.
NUMBER
21
STAT_ZONE_ID
NUMBER
22
No
No
4
1
Active
Code to indciate State Zone
NUMBER
22
COUNTRY_ID
VARCHAR2
2
No
No
Active
Cde to indicate Country
VARCHAR2
23
STATE_ID
VARCHAR2
2
No
No
Active
Code to indicate state
VARCHAR2
24
WATER_BODY_ID
NUMBER
22
No
No
6
3
Active
Code to Indicate waterbody of where tagging took place
NUMBER
25
PLACE_ID
VARCHAR2
3
No
No
Active
Code to indicate place of wheer tagging took palce
VARCHAR2
26
GEAR_ID
VARCHAR2
3
No
No
Active
Code for gear used to catch the animal.
VARCHAR2
27
BAIT_TYPE
VARCHAR2
1
No
No
Active
Code for bait used: (A)rtificial, (L)ive, (D)ead, (U)nknown
VARCHAR2
28
METHOD_ID
NUMBER
22
No
No
6
0
Active
Code To indicate tagging methodology Used
NUMBER
29
SAMPLE_ID
NUMBER
22
No
No
6
0
Active
Code to indicate Sampling Methodology
NUMBER
30
CAPTAIN_AGENCY
VARCHAR2
3
No
No
Active
COde to indicate agency which assigned angler code for boat captain
VARCHAR2
31
CAPTAIN_ID
NUMBER
22
No
No
6
0
Active
Unique numeric code assigned to an individual captain. Must be greater than zero or -99999.
NUMBER
32
TAGGER_INITIALS
VARCHAR2
3
No
No
Active
Initials Of Taggers
VARCHAR2
33
TAGGER_TYPE
VARCHAR2
1
No
No
Active
Indicates Type Of Tagger
VARCHAR2
34
TAGGER_AFFILIATION
VARCHAR2
3
No
No
Active
Code Of Agency that is affiliated With The Tagger
VARCHAR2
35
VESSEL_AGENCY
VARCHAR2
3
No
No
Active
Agency For Vessel COode
VARCHAR2
36
VESSEL_ID
NUMBER
22
No
No
6
0
Active
Agency supplied code identifying the vessel involved in the release or recapture of the animal.
NUMBER
37
PHYSICAL_DATA_ID
NUMBER
22
No
No
6
0
Active
Physical Data Identification Number
NUMBER
38
NOTES
NUMBER
22
No
No
3
0
Active
Any Other Notes On Tagging
NUMBER
39
FIGHT_HOURS
NUMBER
22
No
No
2
0
Active
Number Of Hours Spent FIghting/Landings Fish
NUMBER
40
FIGHT_MINUTES
NUMBER
22
No
No
2
0
Active
Number Of Minutes (up to 59) spent FIghting/Landings Fish
NUMBER
41
ANGLER_AGENCY
VARCHAR2
3
No
No
Active
Agency That Has Angler Code list
VARCHAR2
42
ANGLER_ID
NUMBER
22
No
No
6
0
Active
Unique identifier for each person in the database.
NUMBER
43
DATE_ENTERED
DATE
7
No
No
Active
The date the data was entered.
DATE
7100
View: FOURTH_INTERACTIONS_V
FOURTH_INTERACTIONS_V
Published / External
Completed
View Of Fourth Tagging Interaction
Loaded by batch 2083, 02-22-2008 12:10
Data View
Yes
CTSPAT
View Of Fourth Tagging Interaction
1
ANIMAL_ID
NUMBER
22
Yes
No
10
0
Active
Key to Identifies Animal
NUMBER
2
SPECIES
VARCHAR2
3
Yes
No
Active
Species Code Used In NMFS Tagging Program
VARCHAR2
3
SEX
VARCHAR2
1
No
No
Active
Code to indicate sex of the animal
VARCHAR2
4
AGENCY_ID
VARCHAR2
3
Yes
No
Active
Code to Indicate Tagging agency of identifying tag on animal (tag1)
VARCHAR2
5
TAG_ID
VARCHAR2
8
Yes
No
Active
Tagnumber
VARCHAR2
6
EVENT_ID
NUMBER
22
Yes
No
2
0
Active
Code to identify tagging event
NUMBER
7
TAG_DATE
DATE
7
Yes
No
Active
Date animal was released or recaptured.
DATE
8
NEXT_TAG_AGENCY
VARCHAR2
3
No
No
Active
Code For Agency That Issued the next tag (second tag) on this record
VARCHAR2
9
NEXT_TAG_ID
VARCHAR2
8
No
No
Active
Code to Indicate Tagging agency of identifying tag on animal (nexttag)
VARCHAR2
10
INTERACTION_ORDER
NUMBER
22
Yes
No
2
0
Active
Number denoting the order of the interaction.
NUMBER
11
LENGTH
NUMBER
22
No
No
4
0
Active
Length of animal tagged based on the lengthunit, lengthtype, and lengthdet.
NUMBER
12
LENGTH_UNIT
VARCHAR2
2
No
No
Active
Units for Length Measurement
VARCHAR2
13
LENGTH_TYPE
VARCHAR2
1
No
No
Active
Code to determine The Type Of Length MEasurement taken
VARCHAR2
14
LENGTH_DETERMINATION
VARCHAR2
1
No
No
Active
Code To Indicate How Length Was determined
VARCHAR2
15
WEIGHT
NUMBER
22
No
No
6
2
Active
Weight of an animal tagged, based upon weightunit, weighttype and weightdet.
NUMBER
16
WEIGHT_UNIT
VARCHAR2
2
No
No
Active
Units for Weight Measurement
VARCHAR2
17
WEIGHT_TYPE
VARCHAR2
1
No
No
Active
Code For Type Of Weight Measurement
VARCHAR2
18
WEIGHT_DETERMINATION
VARCHAR2
1
No
No
Active
Code For How Weight Was Determined
VARCHAR2
19
LATITUDE
NUMBER
22
No
No
30
16
Active
Numeric value for the latitude of the tagging location.
NUMBER
20
LONGITUDE
NUMBER
22
No
No
30
16
Active
Numeric value the the longitude of the tagging location.
NUMBER
21
STAT_ZONE_ID
NUMBER
22
No
No
4
1
Active
Code to indciate State Zone
NUMBER
22
COUNTRY_ID
VARCHAR2
2
No
No
Active
Cde to indicate Country
VARCHAR2
23
STATE_ID
VARCHAR2
2
No
No
Active
Code to indicate state
VARCHAR2
24
WATER_BODY_ID
NUMBER
22
No
No
6
3
Active
Code to Indicate waterbody of where tagging took place
NUMBER
25
PLACE_ID
VARCHAR2
3
No
No
Active
Code to indicate place of wheer tagging took palce
VARCHAR2
26
GEAR_ID
VARCHAR2
3
No
No
Active
Code for gear used to catch the animal.
VARCHAR2
27
BAIT_TYPE
VARCHAR2
1
No
No
Active
Code for bait used: (A)rtificial, (L)ive, (D)ead, (U)nknown
VARCHAR2
28
METHOD_ID
NUMBER
22
No
No
6
0
Active
Code To indicate tagging methodology Used
NUMBER
29
SAMPLE_ID
NUMBER
22
No
No
6
0
Active
Code to indicate Sampling Methodology
NUMBER
30
CAPTAIN_AGENCY
VARCHAR2
3
No
No
Active
COde to indicate agency which assigned angler code for boat captain
VARCHAR2
31
CAPTAIN_ID
NUMBER
22
No
No
6
0
Active
Unique numeric code assigned to an individual captain. Must be greater than zero or -99999.
NUMBER
32
TAGGER_INITIALS
VARCHAR2
3
No
No
Active
Initials Of Taggers
VARCHAR2
33
TAGGER_TYPE
VARCHAR2
1
No
No
Active
Indicates Type Of Tagger
VARCHAR2
34
TAGGER_AFFILIATION
VARCHAR2
3
No
No
Active
Code Of Agency that is affiliated With The Tagger
VARCHAR2
35
VESSEL_AGENCY
VARCHAR2
3
No
No
Active
Agency For Vessel COode
VARCHAR2
36
VESSEL_ID
NUMBER
22
No
No
6
0
Active
Agency supplied code identifying the vessel involved in the release or recapture of the animal.
NUMBER
37
PHYSICAL_DATA_ID
NUMBER
22
No
No
6
0
Active
Physical Data Identification Number
NUMBER
38
NOTES
NUMBER
22
No
No
3
0
Active
Any Other Notes On Tagging
NUMBER
39
FIGHT_HOURS
NUMBER
22
No
No
2
0
Active
Number Of Hours Spent FIghting/Landings Fish
NUMBER
40
FIGHT_MINUTES
NUMBER
22
No
No
2
0
Active
Number Of Minutes (up to 59) spent FIghting/Landings Fish
NUMBER
41
ANGLER_AGENCY
VARCHAR2
3
No
No
Active
Agency That Has Angler Code list
VARCHAR2
42
ANGLER_ID
NUMBER
22
No
No
6
0
Active
Unique identifier for each person in the database.
NUMBER
43
DATE_ENTERED
DATE
7
No
No
Active
The date the data was entered.
DATE
7101
View: HABITATMATRIX_V
HABITATMATRIX_V
Published / External
Completed
View Of Habitat Matrix
Loaded by batch 2083, 02-22-2008 12:10
Data View
Yes
CTSPAT
View Of Habitat Matrix
1
ARCHIVAL_TAG_ID
VARCHAR2
10
Yes
No
Active
Archival Tag (Number)
VARCHAR2
2
RECEPTION_DATE
DATE
7
Yes
No
Active
Date INformation Wa Received
DATE
3
RECEPTION_TIME
VARCHAR2
10
Yes
No
Active
Time Information Was Recieved
VARCHAR2
4
DEPTH_1
NUMBER
22
No
No
38
Active
Depth One Measurement
NUMBER
5
D1_MIN_TEMP
NUMBER
22
No
No
38
Active
Depth One Minimum Temperature
NUMBER
6
D1_MAX_TEMP
NUMBER
22
No
No
38
Active
Depth One Maximum Temperature
NUMBER
7
DEPTH_2
NUMBER
22
No
No
38
Active
Depth Two Measurement
NUMBER
8
D2_MIN_TEMP
NUMBER
22
No
No
38
Active
Depth Two Minimum Temperature
NUMBER
9
D2_MAX_TEMP
NUMBER
22
No
No
38
Active
Depth Two Maximum Temperature
NUMBER
10
DEPTH_3
NUMBER
22
No
No
38
Active
Depth Three Measurement
NUMBER
11
D3_MIN_TEMP
NUMBER
22
No
No
38
Active
Depth Three Minimum Temperature
NUMBER
12
D3_MAX_TEMP
NUMBER
22
No
No
38
Active
Depth Three Maximum Temperature
NUMBER
13
DEPTH_4
VARCHAR2
240
No
No
Active
Depth Four Measurement
VARCHAR2
14
D4_MIN_TEMP
NUMBER
22
No
No
38
Active
Depth Four Minimum Temperature
NUMBER
15
D4_MAX_TEMP
NUMBER
22
No
No
38
Active
Depth Four Maximum Temperature
NUMBER
16
DEPTH_5
NUMBER
22
No
No
38
Active
Depth Five Measurement
NUMBER
17
D5_MIN_TEMP
NUMBER
22
No
No
38
Active
Depth Five Minimum Temperature
NUMBER
18
D5_MAX_TEMP
NUMBER
22
No
No
38
Active
Depth Fivet Maximum Temperature
NUMBER
19
DEPTH_6
NUMBER
22
No
No
38
Active
Depth Six Measurement
NUMBER
20
D6_MIN_TEMP
NUMBER
22
No
No
38
Active
Depth Six Minimum Temperature
NUMBER
21
D6_MAX_TEMP
NUMBER
22
No
No
38
Active
Depth Six Maximum Temperature
NUMBER
22
DEPTH_7
NUMBER
22
No
No
38
Active
Depth Seven Measurement
NUMBER
23
D7_MIN_TEMP
NUMBER
22
No
No
38
Active
Depth Seven Minimum Temperature
NUMBER
24
D7_MAX_TEMP
NUMBER
22
No
No
38
Active
Depth Seven Maximum Temperature
NUMBER
25
DEPTH_8
NUMBER
22
No
No
38
Active
Depth Eight Measurement
NUMBER
26
D8_MIN_TEMP
NUMBER
22
No
No
38
Active
Depth Eight Minimum Temperature
NUMBER
27
D8_MAX_TEMP
NUMBER
22
No
No
38
Active
Depth Eight Maximum Temperature
NUMBER
28
YEAR
NUMBER
22
Yes
No
4
0
Active
Calender Year Measurement Was Taken
NUMBER
29
MONTH
NUMBER
22
Yes
No
2
0
Active
Calender Month Measurement Was Taken
NUMBER
30
DAY
NUMBER
22
Yes
No
2
0
Active
Calender Day Measurement Was Taken
NUMBER
31
HOUR
NUMBER
22
Yes
No
2
0
Active
Time MEasurement Was Taken
NUMBER
32
REPEATS
NUMBER
22
No
No
3
0
Active
Number Of Times Measurement Was Repeated
NUMBER
7102
View: ICCAT_V
ICCAT_V
Published / External
Completed
View Of Data That is used for ICCAT Report
Loaded by batch 2083, 02-22-2008 12:10
Data View
Yes
CTSPAT
View Of Data That is used for ICCAT Report
1
ANIMAL_ID
NUMBER
22
Yes
No
10
0
Active
Key to Identifies Animal
NUMBER
2
SPECIES
VARCHAR2
3
Yes
No
Active
Species Code Used In NMFS Tagging Program
VARCHAR2
3
SEX
VARCHAR2
1
No
No
Active
Code to indicate sex of the animal
VARCHAR2
4
AGENCY_ID_1
VARCHAR2
3
Yes
No
Active
Code to Indicate Tagging agency of identifying tag on animal (tag1) at first tagging interaction
VARCHAR2
5
TAG_ID_1
VARCHAR2
8
Yes
No
Active
Tagnumber at first tagging interaction
VARCHAR2
6
EVENT_ID_1
NUMBER
22
Yes
No
2
0
Active
Code to Indicate Tagging Event at first tagging interaction
NUMBER
7
TAG_DATE_1
VARCHAR2
10
No
No
Active
Date animal was released or recaptured t first tagging interaction.
VARCHAR2
8
NEXT_TAG_AGENCY_1
VARCHAR2
3
No
No
Active
Code For Agency That Issued the next tag (second tag) on this record at first tagging interaction
VARCHAR2
9
NEXT_TAG_ID_1
VARCHAR2
8
No
No
Active
Code to Indicate Tagging agency of identifying tag on animal (nexttag) at first tagging interaction
VARCHAR2
10
INTERACTION_ORDER_1
NUMBER
22
Yes
No
2
0
Active
Number denoting the order of the interaction at first tagging interaction.
NUMBER
11
LENGTH_1
NUMBER
22
No
No
4
0
Active
Length of animal tagged based on the lengthunit, lengthtype, and lengthdet at first tagging interaction.
NUMBER
12
LENGTH_UNIT_1
VARCHAR2
2
No
No
Active
Units for Length Measurement at first tagging interaction.
VARCHAR2
13
LENGTH_TYPE_1
VARCHAR2
1
No
No
Active
Code to determine The Type Of Length Measurement taken at first tagging interaction.
VARCHAR2
14
LENGTH_DETERMINATION_1
VARCHAR2
1
No
No
Active
Code To Indicate How Length Was determined at first tagging interaction
VARCHAR2
15
WEIGHT_1
NUMBER
22
No
No
6
2
Active
Weight of an animal tagged, based upon weightunit, weighttype and weightdet at first tagging interaction.
NUMBER
16
WEIGHT_UNIT_1
VARCHAR2
2
No
No
Active
Units for Weight Measurement t first tagging interaction.
VARCHAR2
17
WEIGHT_TYPE_1
VARCHAR2
1
No
No
Active
Code For Type Of Weight Measurement at first tagging interaction.
VARCHAR2
18
WEIGHT_DETERMINATION_1
VARCHAR2
1
No
No
Active
Code For How Weight Was Determined at first tagging interaction.
VARCHAR2
19
LATITUDE_1
NUMBER
22
No
No
30
16
Active
Numeric value for the latitude of the tagging location at first tagging interaction.
NUMBER
20
LONGITUDE_1
NUMBER
22
No
No
30
16
Active
Numeric value the the longitude of the tagging location at first tagging interaction.
NUMBER
21
STAT_ZONE_ID_1
NUMBER
22
No
No
4
1
Active
Code to indciate State Zone at first tagging interaction
NUMBER
22
COUNTRY_ID_1
VARCHAR2
2
No
No
Active
Code to indicate Country at first tagging interaction
VARCHAR2
23
STATE_ID_1
VARCHAR2
2
No
No
Active
Code to indicate state at first tagging interaction
VARCHAR2
24
WATER_BODY_ID_1
NUMBER
22
No
No
6
3
Active
Code to Indicate waterbody of where tagging took place at first tagging interaction
NUMBER
25
PLACE_ID_1
VARCHAR2
3
No
No
Active
Code to indicate place of wheer tagging took place at first tagging interaction
VARCHAR2
26
GEAR_ID_1
VARCHAR2
3
No
No
Active
Code for gear used to catch the animal at first tagging interaction.
VARCHAR2
27
BAIT_TYPE_1
VARCHAR2
1
No
No
Active
Code for bait used: (A)rtificial, (L)ive, (D)ead, (U)nknown at first tagging interaction.
VARCHAR2
28
METHOD_ID_1
NUMBER
22
No
No
6
0
Active
Code To indicate tagging methodology Used at first tagging interaction
NUMBER
29
SAMPLE_ID_1
NUMBER
22
No
No
6
0
Active
Code to indicate Sampling Methodology at first tagging interaction
NUMBER
30
CAPTAIN_AGENCY_1
VARCHAR2
3
No
No
Active
Code to indicate agency which assigned angler code for boat captain at first tagging interaction.
VARCHAR2
31
CAPTAIN_ID_1
NUMBER
22
No
No
6
0
Active
Unique numeric code assigned to an individual captain. Must be greater than zero or -99999 at first tagging interaction.
NUMBER
32
TAGGER_INITIALS_1
VARCHAR2
3
No
No
Active
Initials Of Taggers at first tagging interaction.
VARCHAR2
33
TAGGER_TYPE_1
VARCHAR2
1
No
No
Active
Indicates Type Of Tagger at first tagging interaction.
VARCHAR2
34
TAGGER_AFFILIATION_1
VARCHAR2
3
No
No
Active
Code Of Agency that is affiliated With The Tagger at first tagging interaction.
VARCHAR2
35
VESSEL_AGENCY_1
VARCHAR2
3
No
No
Active
Agency For Vessel Code at first tagging interaction.
VARCHAR2
36
VESSEL_ID_1
NUMBER
22
No
No
6
0
Active
Agency supplied code identifying the vessel involved in the release or recapture of the animal at first tagging interaction.
NUMBER
37
PHYSICAL_DATA_ID_1
NUMBER
22
No
No
6
0
Active
Physical Data Identification Number at first tagging interaction
NUMBER
38
NOTES_1
NUMBER
22
No
No
3
0
Active
Any Other Notes On Tagging at first tagging interaction
NUMBER
39
FIGHT_HOURS_1
NUMBER
22
No
No
2
0
Active
Number Of Hours Spent FIghting/Landings Fish at first tagging interaction
NUMBER
40
FIGHT_MINUTES_1
NUMBER
22
No
No
2
0
Active
Number Of Minutes (up to 59) spent FIghting/Landings Fish at first tagging interaction
NUMBER
41
ANGLER_AGENCY_1
VARCHAR2
3
No
No
Active
Agency That Has Angler Code list at first tagging interaction
VARCHAR2
42
ANGLER_ID_1
NUMBER
22
No
No
6
0
Active
Angler Code at first tagging interaction .
NUMBER
43
DATE_ENTERED_1
DATE
7
No
No
Active
The date the data was entered at first tagging interaction.
DATE
44
AGENCY_ID_2
VARCHAR2
3
No
No
Active
Code to Indicate Tagging agency of identifying tag on animal (tag1) at second tagging interaction
VARCHAR2
45
TAG_ID_2
VARCHAR2
8
No
No
Active
Tagnumber at second tagging interaction
VARCHAR2
46
EVENT_ID_2
NUMBER
22
No
No
2
0
Active
Code to Indicate Tagging Event at second tagging interaction
NUMBER
47
TAG_DATE_2
VARCHAR2
10
No
No
Active
Date animal was released or recaptured t second tagging interaction.
VARCHAR2
48
NEXT_TAG_AGENCY_2
VARCHAR2
3
No
No
Active
Code For Agency That Issued the next tag (second tag) on this record at second tagging interaction
VARCHAR2
49
NEXT_TAG_ID_2
VARCHAR2
8
No
No
Active
Code to Indicate Tagging agency of identifying tag on animal (nexttag) at second tagging interaction
VARCHAR2
50
INTERACTION_ORDER_2
NUMBER
22
No
No
2
0
Active
Number denoting the order of the interaction at second tagging interaction.
NUMBER
51
LENGTH_2
NUMBER
22
No
No
4
0
Active
Length of animal tagged based on the lengthunit, lengthtype, and lengthdet at second tagging interaction.
NUMBER
52
LENGTH_UNIT_2
VARCHAR2
2
No
No
Active
Units for Length Measurement at second tagging interaction.
VARCHAR2
53
LENGTH_TYPE_2
VARCHAR2
1
No
No
Active
Code to determine The Type Of Length Measurement taken at second tagging interaction.
VARCHAR2
54
LENGTH_DETERMINATION_2
VARCHAR2
1
No
No
Active
Code To Indicate How Length Was determined at second tagging interaction
VARCHAR2
55
WEIGHT_2
NUMBER
22
No
No
6
2
Active
Weight of an animal tagged, based upon weightunit, weighttype and weightdet at second tagging interaction.
NUMBER
56
WEIGHT_UNIT_2
VARCHAR2
2
No
No
Active
Units for Weight Measurement t second tagging interaction.
VARCHAR2
57
WEIGHT_TYPE_2
VARCHAR2
1
No
No
Active
Code For Type Of Weight Measurement at second tagging interaction.
VARCHAR2
58
WEIGHT_DETERMINATION_2
VARCHAR2
1
No
No
Active
Code For How Weight Was Determined at second tagging interaction.
VARCHAR2
59
LATITUDE_2
NUMBER
22
No
No
30
16
Active
Numeric value for the latitude of the tagging location at second tagging interaction.
NUMBER
60
LONGITUDE_2
NUMBER
22
No
No
30
16
Active
Numeric value the the longitude of the tagging location at second tagging interaction.
NUMBER
61
STAT_ZONE_ID_2
NUMBER
22
No
No
4
1
Active
Code to indciate State Zone at second tagging interaction
NUMBER
62
COUNTRY_ID_2
VARCHAR2
2
No
No
Active
Code to indicate Country at second tagging interaction
VARCHAR2
63
STATE_ID_2
VARCHAR2
2
No
No
Active
Code to indicate state at second tagging interaction
VARCHAR2
64
WATER_BODY_ID_2
NUMBER
22
No
No
6
3
Active
Code to Indicate waterbody of where tagging took place at second tagging interaction
NUMBER
65
PLACE_ID_2
VARCHAR2
3
No
No
Active
Code to indicate place of wheer tagging took place at second tagging interaction
VARCHAR2
66
GEAR_ID_2
VARCHAR2
3
No
No
Active
Code for gear used to catch the animal at second tagging interaction.
VARCHAR2
67
BAIT_TYPE_2
VARCHAR2
1
No
No
Active
Code for bait used: (A)rtificial, (L)ive, (D)ead, (U)nknown at second tagging interaction.
VARCHAR2
68
METHOD_ID_2
NUMBER
22
No
No
6
0
Active
Code To indicate tagging methodology Used at second tagging interaction
NUMBER
69
SAMPLE_ID_2
NUMBER
22
No
No
6
0
Active
Code to indicate Sampling Methodology at second tagging interaction
NUMBER
70
CAPTAIN_AGENCY_2
VARCHAR2
3
No
No
Active
Code to indicate agency which assigned angler code for boat captain at second tagging interaction.
VARCHAR2
71
CAPTAIN_ID_2
NUMBER
22
No
No
6
0
Active
Unique numeric code assigned to an individual captain. Must be greater than zero or -99999 at second tagging interaction.
NUMBER
72
TAGGER_INITIALS_2
VARCHAR2
3
No
No
Active
Initials Of Taggers at second tagging interaction.
VARCHAR2
73
TAGGER_TYPE_2
VARCHAR2
1
No
No
Active
Indicates Type Of Tagger at second tagging interaction.
VARCHAR2
74
TAGGER_AFFILIATION_2
VARCHAR2
3
No
No
Active
Code Of Agency that is affiliated With The Tagger at second tagging interaction.
VARCHAR2
75
VESSEL_AGENCY_2
VARCHAR2
3
No
No
Active
Agency For Vessel Code at second tagging interaction.
VARCHAR2
76
VESSEL_ID_2
NUMBER
22
No
No
6
0
Active
Agency supplied code identifying the vessel involved in the release or recapture of the animal at second tagging interaction.
NUMBER
77
PHYSICAL_DATA_ID_2
NUMBER
22
No
No
6
0
Active
Physical Data Identification Number at second tagging interaction
NUMBER
78
NOTES_2
NUMBER
22
No
No
3
0
Active
Any Other Notes On Tagging at second tagging interaction
NUMBER
79
FIGHT_HOURS_2
NUMBER
22
No
No
2
0
Active
Number Of Hours Spent FIghting/Landings Fish at second tagging interaction
NUMBER
80
FIGHT_MINUTES_2
NUMBER
22
No
No
2
0
Active
Number Of Minutes (up to 59) spent FIghting/Landings Fish at second tagging interaction
NUMBER
81
ANGLER_AGENCY_2
VARCHAR2
3
No
No
Active
Agency That Has Angler Code list at second tagging interaction
VARCHAR2
82
ANGLER_ID_2
NUMBER
22
No
No
6
0
Active
Angler Code at second tagging interaction .
NUMBER
83
DATE_ENTERED_2
DATE
7
No
No
Active
The date the data was entered at second tagging interaction.
DATE
84
AGENCY_ID_3
VARCHAR2
3
No
No
Active
Code to Indicate Tagging agency of identifying tag on animal (tag1) at third tagging interaction
VARCHAR2
85
TAG_ID_3
VARCHAR2
8
No
No
Active
Tagnumber at third tagging interaction
VARCHAR2
86
EVENT_ID_3
NUMBER
22
No
No
2
0
Active
Code to Indicate Tagging Event at third tagging interaction
NUMBER
87
TAG_DATE_3
VARCHAR2
10
No
No
Active
Date animal was released or recaptured t third tagging interaction.
VARCHAR2
88
NEXT_TAG_AGENCY_3
VARCHAR2
3
No
No
Active
Code For Agency That Issued the next tag (third tag) on this record at third tagging interaction
VARCHAR2
89
NEXT_TAG_ID_3
VARCHAR2
8
No
No
Active
Code to Indicate Tagging agency of identifying tag on animal (nexttag) at third tagging interaction
VARCHAR2
90
INTERACTION_ORDER_3
NUMBER
22
No
No
2
0
Active
Number denoting the order of the interaction at third tagging interaction.
NUMBER
91
LENGTH_3
NUMBER
22
No
No
4
0
Active
Length of animal tagged based on the lengthunit, lengthtype, and lengthdet at third tagging interaction.
NUMBER
92
LENGTH_UNIT_3
VARCHAR2
2
No
No
Active
Units for Length Measurement at third tagging interaction.
VARCHAR2
93
LENGTH_TYPE_3
VARCHAR2
1
No
No
Active
Code to determine The Type Of Length Measurement taken at third tagging interaction.
VARCHAR2
94
LENGTH_DETERMINATION_3
VARCHAR2
1
No
No
Active
Code To Indicate How Length Was determined at third tagging interaction
VARCHAR2
95
WEIGHT_3
NUMBER
22
No
No
6
2
Active
Weight of an animal tagged, based upon weightunit, weighttype and weightdet at third tagging interaction.
NUMBER
96
WEIGHT_UNIT_3
VARCHAR2
2
No
No
Active
Units for Weight Measurement t third tagging interaction.
VARCHAR2
97
WEIGHT_TYPE_3
VARCHAR2
1
No
No
Active
Code For Type Of Weight Measurement at third tagging interaction.
VARCHAR2
98
WEIGHT_DETERMINATION_3
VARCHAR2
1
No
No
Active
Code For How Weight Was Determined at third tagging interaction.
VARCHAR2
99
LATITUDE_3
NUMBER
22
No
No
30
16
Active
Numeric value for the latitude of the tagging location at third tagging interaction.
NUMBER
100
LONGITUDE_3
NUMBER
22
No
No
30
16
Active
Numeric value the the longitude of the tagging location at third tagging interaction.
NUMBER
101
STAT_ZONE_ID_3
NUMBER
22
No
No
4
1
Active
Code to indciate State Zone at third tagging interaction
NUMBER
102
COUNTRY_ID_3
VARCHAR2
2
No
No
Active
Code to indicate Country at third tagging interaction
VARCHAR2
103
STATE_ID_3
VARCHAR2
2
No
No
Active
Code to indicate state at third tagging interaction
VARCHAR2
104
WATER_BODY_ID_3
NUMBER
22
No
No
6
3
Active
Code to Indicate waterbody of where tagging took place at third tagging interaction
NUMBER
105
PLACE_ID_3
VARCHAR2
3
No
No
Active
Code to indicate place of wheer tagging took place at third tagging interaction
VARCHAR2
106
GEAR_ID_3
VARCHAR2
3
No
No
Active
Code for gear used to catch the animal at third tagging interaction.
VARCHAR2
107
BAIT_TYPE_3
VARCHAR2
1
No
No
Active
Code for bait used: (A)rtificial, (L)ive, (D)ead, (U)nknown at third tagging interaction.
VARCHAR2
108
METHOD_ID_3
NUMBER
22
No
No
6
0
Active
Code To indicate tagging methodology Used at third tagging interaction
NUMBER
109
SAMPLE_ID_3
NUMBER
22
No
No
6
0
Active
Code to indicate Sampling Methodology at third tagging interaction
NUMBER
110
CAPTAIN_AGENCY_3
VARCHAR2
3
No
No
Active
Code to indicate agency which assigned angler code for boat captain at third tagging interaction.
VARCHAR2
111
CAPTAIN_ID_3
NUMBER
22
No
No
6
0
Active
Unique numeric code assigned to an individual captain. Must be greater than zero or -99999 at third tagging interaction.
NUMBER
112
TAGGER_INITIALS_3
VARCHAR2
3
No
No
Active
Initials Of Taggers at third tagging interaction.
VARCHAR2
113
TAGGER_TYPE_3
VARCHAR2
1
No
No
Active
Indicates Type Of Tagger at third tagging interaction.
VARCHAR2
114
TAGGER_AFFILIATION_3
VARCHAR2
3
No
No
Active
Code Of Agency that is affiliated With The Tagger at third tagging interaction.
VARCHAR2
115
VESSEL_AGENCY_3
VARCHAR2
3
No
No
Active
Agency For Vessel Code at third tagging interaction.
VARCHAR2
116
VESSEL_ID_3
NUMBER
22
No
No
6
0
Active
Agency supplied code identifying the vessel involved in the release or recapture of the animal at third tagging interaction.
NUMBER
117
PHYSICAL_DATA_ID_3
NUMBER
22
No
No
6
0
Active
Physical Data Identification Number at third tagging interaction
NUMBER
118
NOTES_3
NUMBER
22
No
No
3
0
Active
Any Other Notes On Tagging at third tagging interaction
NUMBER
119
FIGHT_HOURS_3
NUMBER
22
No
No
2
0
Active
Number Of Hours Spent FIghting/Landings Fish at third tagging interaction
NUMBER
120
FIGHT_MINUTES_3
NUMBER
22
No
No
2
0
Active
Number Of Minutes (up to 59) spent FIghting/Landings Fish at third tagging interaction
NUMBER
121
ANGLER_AGENCY_3
VARCHAR2
3
No
No
Active
Agency That Has Angler Code list at third tagging interaction
VARCHAR2
122
ANGLER_ID_3
NUMBER
22
No
No
6
0
Active
Angler Code at third tagging interaction .
NUMBER
123
DATE_ENTERED_3
DATE
7
No
No
Active
The date the data was entered at third tagging interaction.
DATE
124
AGENCY_ID_4
VARCHAR2
3
No
No
Active
Code to Indicate Tagging agency of identifying tag on animal (tag1) at fourth tagging interaction
VARCHAR2
125
TAG_ID_4
VARCHAR2
8
No
No
Active
Tagnumber at fourth tagging interaction
VARCHAR2
126
EVENT_ID_4
NUMBER
22
No
No
2
0
Active
Code to Indicate Tagging Event at fourth tagging interaction
NUMBER
127
TAG_DATE_4
VARCHAR2
10
No
No
Active
Date animal was released or recaptured t fourth tagging interaction.
VARCHAR2
128
NEXT_TAG_AGENCY_4
VARCHAR2
3
No
No
Active
Code For Agency That Issued the next tag (fourth tag) on this record at fourth tagging interaction
VARCHAR2
129
NEXT_TAG_ID_4
VARCHAR2
8
No
No
Active
Code to Indicate Tagging agency of identifying tag on animal (nexttag) at fourth tagging interaction
VARCHAR2
130
INTERACTION_ORDER_4
NUMBER
22
No
No
2
0
Active
Number denoting the order of the interaction at fourth tagging interaction.
NUMBER
131
LENGTH_4
NUMBER
22
No
No
4
0
Active
Length of animal tagged based on the lengthunit, lengthtype, and lengthdet at fourth tagging interaction.
NUMBER
132
LENGTH_UNIT_4
VARCHAR2
2
No
No
Active
Units for Length Measurement at fourth tagging interaction.
VARCHAR2
133
LENGTH_TYPE_4
VARCHAR2
1
No
No
Active
Code to determine The Type Of Length Measurement taken at fourth tagging interaction.
VARCHAR2
134
LENGTH_DETERMINATION_4
VARCHAR2
1
No
No
Active
Code To Indicate How Length Was determined at fourth tagging interaction
VARCHAR2
135
WEIGHT_4
NUMBER
22
No
No
6
2
Active
Weight of an animal tagged, based upon weightunit, weighttype and weightdet at fourth tagging interaction.
NUMBER
136
WEIGHT_UNIT_4
VARCHAR2
2
No
No
Active
Units for Weight Measurement t fourth tagging interaction.
VARCHAR2
137
WEIGHT_TYPE_4
VARCHAR2
1
No
No
Active
Code For Type Of Weight Measurement at fourth tagging interaction.
VARCHAR2
138
WEIGHT_DETERMINATION_4
VARCHAR2
1
No
No
Active
Code For How Weight Was Determined at fourth tagging interaction.
VARCHAR2
139
LATITUDE_4
NUMBER
22
No
No
30
16
Active
Numeric value for the latitude of the tagging location at fourth tagging interaction.
NUMBER
140
LONGITUDE_4
NUMBER
22
No
No
30
16
Active
Numeric value the the longitude of the tagging location at fourth tagging interaction.
NUMBER
141
STAT_ZONE_ID_4
NUMBER
22
No
No
4
1
Active
Code to indciate State Zone at fourth tagging interaction
NUMBER
142
COUNTRY_ID_4
VARCHAR2
2
No
No
Active
Code to indicate Country at fourth tagging interaction
VARCHAR2
143
STATE_ID_4
VARCHAR2
2
No
No
Active
Code to indicate state at fourth tagging interaction
VARCHAR2
144
WATER_BODY_ID_4
NUMBER
22
No
No
6
3
Active
Code to Indicate waterbody of where tagging took place at fourth tagging interaction
NUMBER
145
PLACE_ID_4
VARCHAR2
3
No
No
Active
Code to indicate place of wheer tagging took place at fourth tagging interaction
VARCHAR2
146
GEAR_ID_4
VARCHAR2
3
No
No
Active
Code for gear used to catch the animal at fourth tagging interaction.
VARCHAR2
147
BAIT_TYPE_4
VARCHAR2
1
No
No
Active
Code for bait used: (A)rtificial, (L)ive, (D)ead, (U)nknown at fourth tagging interaction.
VARCHAR2
148
METHOD_ID_4
NUMBER
22
No
No
6
0
Active
Code To indicate tagging methodology Used at fourth tagging interaction
NUMBER
149
SAMPLE_ID_4
NUMBER
22
No
No
6
0
Active
Code to indicate Sampling Methodology at fourth tagging interaction
NUMBER
150
CAPTAIN_AGENCY_4
VARCHAR2
3
No
No
Active
Code to indicate agency which assigned angler code for boat captain at fourth tagging interaction.
VARCHAR2
151
CAPTAIN_ID_4
NUMBER
22
No
No
6
0
Active
Unique numeric code assigned to an individual captain. Must be greater than zero or -99999 at fourth tagging interaction.
NUMBER
152
TAGGER_INITIALS_4
VARCHAR2
3
No
No
Active
Initials Of Taggers at fourth tagging interaction.
VARCHAR2
153
TAGGER_TYPE_4
VARCHAR2
1
No
No
Active
Indicates Type Of Tagger at fourth tagging interaction.
VARCHAR2
154
TAGGER_AFFILIATION_4
VARCHAR2
3
No
No
Active
Code Of Agency that is affiliated With The Tagger at fourth tagging interaction.
VARCHAR2
155
VESSEL_AGENCY_4
VARCHAR2
3
No
No
Active
Agency For Vessel Code at fourth tagging interaction.
VARCHAR2
156
VESSEL_ID_4
NUMBER
22
No
No
6
0
Active
Agency supplied code identifying the vessel involved in the release or recapture of the animal at fourth tagging interaction.
NUMBER
157
PHYSICAL_DATA_ID_4
NUMBER
22
No
No
6
0
Active
Physical Data Identification Number at fourth tagging interaction
NUMBER
158
NOTES_4
NUMBER
22
No
No
3
0
Active
Any Other Notes On Tagging at fourth tagging interaction
NUMBER
159
FIGHT_HOURS_4
NUMBER
22
No
No
2
0
Active
Number Of Hours Spent FIghting/Landings Fish at fourth tagging interaction
NUMBER
160
FIGHT_MINUTES_4
NUMBER
22
No
No
2
0
Active
Number Of Minutes (up to 59) spent FIghting/Landings Fish at fourth tagging interaction
NUMBER
161
ANGLER_AGENCY_4
VARCHAR2
3
No
No
Active
Agency That Has Angler Code list at fourth tagging interaction
VARCHAR2
162
ANGLER_ID_4
NUMBER
22
No
No
6
0
Active
Angler Code at fourth tagging interaction .
NUMBER
163
DATE_ENTERED_4
DATE
7
No
No
Active
The date the data was entered at fourth tagging interaction.
DATE
164
AGENCY_ID_5
VARCHAR2
3
No
No
Active
Code to Indicate Tagging agency of identifying tag on animal (tag1) at fifth tagging interaction
VARCHAR2
165
TAG_ID_5
VARCHAR2
8
No
No
Active
Tagnumber at fifth tagging interaction
VARCHAR2
166
EVENT_ID_5
NUMBER
22
No
No
2
0
Active
Code to Indicate Tagging Event at fifth tagging interaction
NUMBER
167
TAG_DATE_5
VARCHAR2
10
No
No
Active
Date animal was released or recaptured t fifth tagging interaction.
VARCHAR2
168
NEXT_TAG_AGENCY_5
VARCHAR2
3
No
No
Active
Code For Agency That Issued the next tag (fifth tag) on this record at fifth tagging interaction
VARCHAR2
169
NEXT_TAG_ID_5
VARCHAR2
8
No
No
Active
Code to Indicate Tagging agency of identifying tag on animal (nexttag) at fifth tagging interaction
VARCHAR2
170
INTERACTION_ORDER_5
NUMBER
22
No
No
2
0
Active
Number denoting the order of the interaction at fifth tagging interaction.
NUMBER
171
LENGTH_5
NUMBER
22
No
No
4
0
Active
Length of animal tagged based on the lengthunit, lengthtype, and lengthdet at fifth tagging interaction.
NUMBER
172
LENGTH_UNIT_5
VARCHAR2
2
No
No
Active
Units for Length Measurement at fifth tagging interaction.
VARCHAR2
173
LENGTH_TYPE_5
VARCHAR2
1
No
No
Active
Code to determine The Type Of Length Measurement taken at fifth tagging interaction.
VARCHAR2
174
LENGTH_DETERMINATION_5
VARCHAR2
1
No
No
Active
Code To Indicate How Length Was determined at fifth tagging interaction
VARCHAR2
175
WEIGHT_5
NUMBER
22
No
No
6
2
Active
Weight of an animal tagged, based upon weightunit, weighttype and weightdet at fifth tagging interaction.
NUMBER
176
WEIGHT_UNIT_5
VARCHAR2
2
No
No
Active
Units for Weight Measurement t fifth tagging interaction.
VARCHAR2
177
WEIGHT_TYPE_5
VARCHAR2
1
No
No
Active
Code For Type Of Weight Measurement at fifth tagging interaction.
VARCHAR2
178
WEIGHT_DETERMINATION_5
VARCHAR2
1
No
No
Active
Code For How Weight Was Determined at fifth tagging interaction.
VARCHAR2
179
LATITUDE_5
NUMBER
22
No
No
30
16
Active
Numeric value for the latitude of the tagging location at fifth tagging interaction.
NUMBER
180
LONGITUDE_5
NUMBER
22
No
No
30
16
Active
Numeric value the the longitude of the tagging location at fifth tagging interaction.
NUMBER
181
STAT_ZONE_ID_5
NUMBER
22
No
No
4
1
Active
Code to indciate State Zone at fifth tagging interaction
NUMBER
182
COUNTRY_ID_5
VARCHAR2
2
No
No
Active
Code to indicate Country at fifth tagging interaction
VARCHAR2
183
STATE_ID_5
VARCHAR2
2
No
No
Active
Code to indicate state at fifth tagging interaction
VARCHAR2
184
WATER_BODY_ID_5
NUMBER
22
No
No
6
3
Active
Code to Indicate waterbody of where tagging took place at fifth tagging interaction
NUMBER
185
PLACE_ID_5
VARCHAR2
3
No
No
Active
Code to indicate place of wheer tagging took place at fifth tagging interaction
VARCHAR2
186
GEAR_ID_5
VARCHAR2
3
No
No
Active
Code for gear used to catch the animal at fifth tagging interaction.
VARCHAR2
187
BAIT_TYPE_5
VARCHAR2
1
No
No
Active
Code for bait used: (A)rtificial, (L)ive, (D)ead, (U)nknown at fifth tagging interaction.
VARCHAR2
188
METHOD_ID_5
NUMBER
22
No
No
6
0
Active
Code To indicate tagging methodology Used at fifth tagging interaction
NUMBER
189
SAMPLE_ID_5
NUMBER
22
No
No
6
0
Active
Code to indicate Sampling Methodology at fifth tagging interaction
NUMBER
190
CAPTAIN_AGENCY_5
VARCHAR2
3
No
No
Active
Code to indicate agency which assigned angler code for boat captain at fifth tagging interaction.
VARCHAR2
191
CAPTAIN_ID_5
NUMBER
22
No
No
6
0
Active
Unique numeric code assigned to an individual captain. Must be greater than zero or -99999 at fifth tagging interaction.
NUMBER
192
TAGGER_INITIALS_5
VARCHAR2
3
No
No
Active
Initials Of Taggers at fifth tagging interaction.
VARCHAR2
193
TAGGER_TYPE_5
VARCHAR2
1
No
No
Active
Indicates Type Of Tagger at fifth tagging interaction.
VARCHAR2
194
TAGGER_AFFILIATION_5
VARCHAR2
3
No
No
Active
Code Of Agency that is affiliated With The Tagger at fifth tagging interaction.
VARCHAR2
195
VESSEL_AGENCY_5
VARCHAR2
3
No
No
Active
Agency For Vessel Code at fifth tagging interaction.
VARCHAR2
196
VESSEL_ID_5
NUMBER
22
No
No
6
0
Active
Agency supplied code identifying the vessel involved in the release or recapture of the animal at fifth tagging interaction.
NUMBER
197
PHYSICAL_DATA_ID_5
NUMBER
22
No
No
6
0
Active
Physical Data Identification Number at fifth tagging interaction
NUMBER
198
NOTES_5
NUMBER
22
No
No
3
0
Active
Any Other Notes On Tagging at fifth tagging interaction
NUMBER
199
FIGHT_HOURS_5
NUMBER
22
No
No
2
0
Active
Number Of Hours Spent FIghting/Landings Fish at fifth tagging interaction
NUMBER
200
FIGHT_MINUTES_5
NUMBER
22
No
No
2
0
Active
Number Of Minutes (up to 59) spent FIghting/Landings Fish at fifth tagging interaction
NUMBER
201
ANGLER_AGENCY_5
VARCHAR2
3
No
No
Active
Agency That Has Angler Code list at fifth tagging interaction
VARCHAR2
202
ANGLER_ID_5
NUMBER
22
No
No
6
0
Active
Angler Code at fifth tagging interaction .
NUMBER
203
DATE_ENTERED_5
DATE
7
No
No
Active
The date the data was entered at fifth tagging interaction.
DATE
7103
View: LOCATIONS_VIEW
LOCATIONS_VIEW
Published / External
Completed
View Of Archival Tag Locations
Loaded by batch 2083, 02-22-2008 12:10
Data View
Yes
CTSPAT
View Of Archival Tag Locations
1
ARCHIVAL_TAG_ID
VARCHAR2
10
No
No
Active
Archival Tag Number
VARCHAR2
2
DAY
NUMBER
22
No
No
38
Active
Day
NUMBER
3
MONTH
NUMBER
22
No
No
38
Active
Month
NUMBER
4
YEAR
NUMBER
22
No
No
38
Active
Year
NUMBER
5
LONGITUDE
NUMBER
22
No
No
38
Active
Latitude Location
NUMBER
6
LATITUDE
NUMBER
22
No
No
38
Active
Longitude Location
NUMBER
7104
Table: PAT_TAG_BIN_TYPES
PAT_TAG_BIN_TYPES
Published / External
Completed
Table Of Valid PAT Bin Types
Loaded by batch 2083, 02-22-2008 12:10
Data Table
Yes
CTSPAT
Table Of Valid PAT Bin Types
1
TYPE
VARCHAR2
10
Yes
No
Active
Bin Type Description
VARCHAR2
7105
View: PDT_AGG_V
PDT_AGG_V
Published / External
Completed
Profile at Depth and Time (PDT) - giving only temperature ranges and first depth measurement
Loaded by batch 2083, 02-22-2008 12:10
Data View
Yes
CTSPAT
Profile at Depth and Time (PDT) - giving only temperature ranges and first depth measurement
1
DEPTH
NUMBER
22
No
No
4
0
Active
Depth
NUMBER
2
MIN_TEMP
NUMBER
22
No
No
5
1
Active
Minimum Temperature
NUMBER
3
MAX_TEMP
NUMBER
22
No
No
5
1
Active
Maximum Temperature
NUMBER
4
AVE_TEMP
NUMBER
22
No
No
38
Active
Average Temperature
NUMBER
7106
View: RECAPTURES_VW
RECAPTURES_VW
Published / External
Completed
View Of Recaptured animals with the GIS Components Of The recpature
Loaded by batch 2083, 02-22-2008 12:10
Data View
Yes
CTSPAT
View Of Recaptured animals with the GIS Components Of The recpature
1
ANIMAL_ID
NUMBER
22
Yes
No
10
0
Active
Anumal ID
NUMBER
2
GEOM
SDO_GEOMETRY
64
No
No
Active
GIS Information
SDO_GEOMETRY
7107
View: SECOND_INTERACTIONS_V
SECOND_INTERACTIONS_V
Published / External
Completed
View of First Recapture Records
Loaded by batch 2083, 02-22-2008 12:10
Data View
Yes
CTSPAT
View of First Recapture Records
1
ANIMAL_ID
NUMBER
22
Yes
No
10
0
Active
Key to Identifies Animal
NUMBER
2
SPECIES
VARCHAR2
3
Yes
No
Active
Species Code Used In NMFS Tagging Program
VARCHAR2
3
SEX
VARCHAR2
1
No
No
Active
Code to indicate sex of the animal
VARCHAR2
4
AGENCY_ID
VARCHAR2
3
Yes
No
Active
Code to Indicate Tagging agency of identifying tag on animal (tag1)
VARCHAR2
5
TAG_ID
VARCHAR2
8
Yes
No
Active
Tagnumber
VARCHAR2
6
EVENT_ID
NUMBER
22
Yes
No
2
0
Active
Code to identify tagging event
NUMBER
7
TAG_DATE
DATE
7
Yes
No
Active
Date animal was released or recaptured.
DATE
8
NEXT_TAG_AGENCY
VARCHAR2
3
No
No
Active
Code For Agency That Issued the next tag (second tag) on this record
VARCHAR2
9
NEXT_TAG_ID
VARCHAR2
8
No
No
Active
Code to Indicate Tagging agency of identifying tag on animal (nexttag)
VARCHAR2
10
INTERACTION_ORDER
NUMBER
22
Yes
No
2
0
Active
Number denoting the order of the interaction.
NUMBER
11
LENGTH
NUMBER
22
No
No
4
0
Active
Length of animal tagged based on the lengthunit, lengthtype, and lengthdet.
NUMBER
12
LENGTH_UNIT
VARCHAR2
2
No
No
Active
Units for Length Measurement
VARCHAR2
13
LENGTH_TYPE
VARCHAR2
1
No
No
Active
Code to determine The Type Of Length MEasurement taken
VARCHAR2
14
LENGTH_DETERMINATION
VARCHAR2
1
No
No
Active
Code To Indicate How Length Was determined
VARCHAR2
15
WEIGHT
NUMBER
22
No
No
6
2
Active
Weight of an animal tagged, based upon weightunit, weighttype and weightdet.
NUMBER
16
WEIGHT_UNIT
VARCHAR2
2
No
No
Active
Units for Weight Measurement
VARCHAR2
17
WEIGHT_TYPE
VARCHAR2
1
No
No
Active
Code For Type Of Weight Measurement
VARCHAR2
18
WEIGHT_DETERMINATION
VARCHAR2
1
No
No
Active
Code For How Weight Was Determined
VARCHAR2
19
LATITUDE
NUMBER
22
No
No
30
16
Active
Numeric value for the latitude of the tagging location.
NUMBER
20
LONGITUDE
NUMBER
22
No
No
30
16
Active
Numeric value the the longitude of the tagging location.
NUMBER
21
STAT_ZONE_ID
NUMBER
22
No
No
4
1
Active
Code to indciate State Zone
NUMBER
22
COUNTRY_ID
VARCHAR2
2
No
No
Active
Cde to indicate Country
VARCHAR2
23
STATE_ID
VARCHAR2
2
No
No
Active
Code to indicate state
VARCHAR2
24
WATER_BODY_ID
NUMBER
22
No
No
6
3
Active
Code to Indicate waterbody of where tagging took place
NUMBER
25
PLACE_ID
VARCHAR2
3
No
No
Active
Code to indicate place of wheer tagging took palce
VARCHAR2
26
GEAR_ID
VARCHAR2
3
No
No
Active
Code for gear used to catch the animal.
VARCHAR2
27
BAIT_TYPE
VARCHAR2
1
No
No
Active
Code for bait used: (A)rtificial, (L)ive, (D)ead, (U)nknown
VARCHAR2
28
METHOD_ID
NUMBER
22
No
No
6
0
Active
Code To indicate tagging methodology Used
NUMBER
29
SAMPLE_ID
NUMBER
22
No
No
6
0
Active
Code to indicate Sampling Methodology
NUMBER
30
CAPTAIN_AGENCY
VARCHAR2
3
No
No
Active
COde to indicate agency which assigned angler code for boat captain
VARCHAR2
31
CAPTAIN_ID
NUMBER
22
No
No
6
0
Active
Unique numeric code assigned to an individual captain. Must be greater than zero or -99999.
NUMBER
32
TAGGER_INITIALS
VARCHAR2
3
No
No
Active
Initials Of Taggers
VARCHAR2
33
TAGGER_TYPE
VARCHAR2
1
No
No
Active
Indicates Type Of Tagger
VARCHAR2
34
TAGGER_AFFILIATION
VARCHAR2
3
No
No
Active
Code Of Agency that is affiliated With The Tagger
VARCHAR2
35
VESSEL_AGENCY
VARCHAR2
3
No
No
Active
Agency For Vessel COode
VARCHAR2
36
VESSEL_ID
NUMBER
22
No
No
6
0
Active
Agency supplied code identifying the vessel involved in the release or recapture of the animal.
NUMBER
37
PHYSICAL_DATA_ID
NUMBER
22
No
No
6
0
Active
Physical Data Identification Number
NUMBER
38
NOTES
NUMBER
22
No
No
3
0
Active
Any Other Notes On Tagging
NUMBER
39
FIGHT_HOURS
NUMBER
22
No
No
2
0
Active
Number Of Hours Spent FIghting/Landings Fish
NUMBER
40
FIGHT_MINUTES
NUMBER
22
No
No
2
0
Active
Number Of Minutes (up to 59) spent FIghting/Landings Fish
NUMBER
41
ANGLER_AGENCY
VARCHAR2
3
No
No
Active
Agency That Has Angler Code list
VARCHAR2
42
ANGLER_ID
NUMBER
22
No
No
6
0
Active
Unique identifier for each person in the database.
NUMBER
43
DATE_ENTERED
DATE
7
No
No
Active
The date the data was entered.
DATE
7108
View: SEL_ANIMALS_DATA
SEL_ANIMALS_DATA
Published / External
Completed
View Listing Selected Animals and their associated species code and code to indicate sex of animal
Loaded by batch 2083, 02-22-2008 12:10
Data View
Yes
CTSPAT
View Listing Selected Animals and their associated species code and code to indicate sex of animal
1
ANIMAL_ID
NUMBER
22
Yes
No
10
0
Active
Sequential Key To identify animal
NUMBER
2
SPECIES_ID
VARCHAR2
3
Yes
No
Active
Species Code
VARCHAR2
3
SEX
VARCHAR2
1
No
No
Active
Code To Indicate Sex Of Animal
VARCHAR2
7109
View: SEL_ANIMALS_V
SEL_ANIMALS_V
Published / External
Completed
ANimals in 2001 That Had Interactions
Loaded by batch 2083, 02-22-2008 12:10
Data View
Yes
CTSPAT
ANimals in 2001 That Had Interactions
1
ANIMAL_ID
NUMBER
22
Yes
No
10
0
Active
Animal ID
NUMBER
7110
Table: SEL_TBF_INTERACTIONS
SEL_TBF_INTERACTIONS
Published / External
Completed
Table Of Selected Tagging Interactions
Loaded by batch 2083, 02-22-2008 12:10
Data Table
Yes
CTSPAT
Table Of Selected Tagging Interactions
1
TAG_ID
VARCHAR2
8
No
No
Active
Tag Id Number
VARCHAR2
7111
Table: TBF_ANGLERS
TBF_ANGLERS
Published / External
Completed
Copy of Angler Table From The Bullfish Foundation
Loaded by batch 2083, 02-22-2008 12:10
Data Table
Yes
CTSPAT
Copy of Angler Table From The Bullfish Foundation
1
ANGLER_ID
NUMBER
22
Yes
Yes
38
0
Active
Angler Number (Artificial Key)
NUMBER
2
DATEENTERED
DATE
7
No
No
Active
Date Record Was Entered
DATE
3
ORGANIZATION
VARCHAR2
100
No
No
Active
Organization Angler Noted to be being a member of
VARCHAR2
4
TITLE
VARCHAR2
20
No
No
Active
Title Of Angler (Mr, Captain, DR etc)
VARCHAR2
5
FIRSTNAME
VARCHAR2
30
No
No
Active
Angler FIrst Name
VARCHAR2
6
LASTNAME
VARCHAR2
30
Yes
No
Active
Angler Last Name
VARCHAR2
7
SUFFIX
VARCHAR2
20
No
No
Active
Suffic Of Angler Name (Jr. Sr. 111 etc)
VARCHAR2
8
ADDRESS1
VARCHAR2
100
No
No
Active
First Line Of Angler Address
VARCHAR2
9
ADDRESS2
VARCHAR2
100
No
No
Active
Second Line Of Angler Address
VARCHAR2
10
CITY
VARCHAR2
50
Yes
No
Active
City Of Angler Address
VARCHAR2
11
STATE
VARCHAR2
30
Yes
No
Active
State Of Angler Address
VARCHAR2
12
ZIP
VARCHAR2
30
Yes
No
Active
ZIp Code Of Angler Address
VARCHAR2
13
COUNTRY
VARCHAR2
30
No
No
Active
Country Of Angler Address
VARCHAR2
14
HOMEPHONE
VARCHAR2
30
No
No
Active
Home phone Number Of Angler
VARCHAR2
15
WORKPHONE
VARCHAR2
30
No
No
Active
Work phone Number Of Angler
VARCHAR2
16
MISC
VARCHAR2
100
No
No
Active
Miscellaneous Note About the Angler
VARCHAR2
17
FAX
VARCHAR2
15
No
No
Active
Fax Of Angler
VARCHAR2
18
LAST_UPDATE
DATE
7
No
No
Active
Data Record Was Last Updated
DATE
19
CLEAN
VARCHAR2
5
No
No
Active
Code to indicate cleanliness of data
VARCHAR2
20
FOREIGN_ZIP
VARCHAR2
30
No
No
Active
vetigal column having no use
VARCHAR2
21
BOAT
VARCHAR2
50
No
No
Active
Boat Name Of WHere Angler Fished,
VARCHAR2
22
FLEET
VARCHAR2
10
No
No
Active
Is a fleet associated with the boat. (Y if YEs, otherwise blank(
VARCHAR2
23
FLEETNAME
VARCHAR2
20
No
No
Active
Fleetname When Boat is associated WIth a Fleet
VARCHAR2
7112
Table: TBF_ANIMALS
TBF_ANIMALS
Published / External
Completed
List Of Animal From The BIll Fish Foundation with Species Codes Converted To Codes Used in Tagging Application
Loaded by batch 2083, 02-22-2008 12:10
Data Table
Yes
CTSPAT
List Of Animal From The BIll Fish Foundation with Species Codes Converted To Codes Used in Tagging Application
1
ANIMAL_ID
NUMBER
22
Yes
Yes
10
0
Active
Animal Id Number
NUMBER
2
SPECIES_ID
VARCHAR2
3
Yes
No
Active
Species Code
VARCHAR2
3
SEX
VARCHAR2
1
No
No
Active
Sex Code
VARCHAR2
4
GEOM
SDO_GEOMETRY
1
No
No
Active
Geometry
SDO_GEOMETRY
7113
Table: TBF_CAPTURE
TBF_CAPTURE
Published / External
Completed
CTS.TBF_CAPTURE is the primary table of the CTS systems.It contains the information on the actual tagging event, such as,the initial release, the recapture or the re-release of an animal.
Loaded by batch 2083, 02-22-2008 12:10
Data Table
Yes
CTSPAT
CTS.TBF_CAPTURE is the primary table of the CTS systems.It contains the information on the actual tagging event, such as,the initial release, the recapture or the re-release of an animal.
1
TAG_ID
VARCHAR2
8
Yes
Yes
Active
Initial tag number applied to an animal. It consists of a 2 or 3 letter prefix and a 5 or 6 digit number.
VARCHAR2
2
TAG_DATE
DATE
7
No
No
Active
Date animal was released or recaptured.
DATE
3
FISHCODE
VARCHAR2
10
Yes
No
Active
TBF Fish Code
VARCHAR2
4
FISH
VARCHAR2
50
No
No
Active
Name Of Fish
VARCHAR2
5
RERELEASED
VARCHAR2
20
No
No
Active
Was Fish Released After It was Recaptured
VARCHAR2
6
RECAPTURE_DATE
DATE
7
Yes
Yes
Active
Date Animal Was Recaptured
DATE
7
LOCALITY
VARCHAR2
130
No
No
Active
Locality Where Fish Was Recaptured
VARCHAR2
8
LENGTH2
VARCHAR2
30
No
No
Active
Length MEasurement at time of second recpature
VARCHAR2
9
WEIGHT2
VARCHAR2
30
No
No
Active
Weight measurement at time of second recapture
VARCHAR2
10
ANGLER2
VARCHAR2
30
No
No
Active
Angler Number Of recapturing Angler
VARCHAR2
11
A2FIRST
VARCHAR2
50
No
No
Active
Recapturing Angler First Name
VARCHAR2
12
A2LAST
VARCHAR2
50
No
No
Active
Recapturing Angler Last Name
VARCHAR2
13
FISH_CONDITION
VARCHAR2
50
No
No
Active
Descriptive Fish Condition at time of recapture
VARCHAR2
14
DAYSATLARGE
VARCHAR2
50
No
No
Active
Number Of Days ANimal Was At Large
VARCHAR2
15
NMFS_SHED
VARCHAR2
20
No
No
Active
Was The NMFS Tag Shed At time of recapture
VARCHAR2
16
LAT2
VARCHAR2
30
No
No
Active
Latitude at Time Of Recapture
VARCHAR2
17
LON2
VARCHAR2
30
No
No
Active
Longitude at Time Of Recapture
VARCHAR2
18
REMARKS2
VARCHAR2
130
No
No
Active
Remarks About Recapture
VARCHAR2
19
RETAG
VARCHAR2
20
No
No
Active
Inicates If animal Was animal retagged
VARCHAR2
20
NEWTAG
VARCHAR2
10
No
No
Active
If a new tag is applied to a fish upon re-release, this is the number of that tag
VARCHAR2
21
LORAN
VARCHAR2
50
No
No
Active
Loran reading for location of recapture
VARCHAR2
22
RECAPTURE
VARCHAR2
20
No
No
Active
Was This a Recapture Record
VARCHAR2
23
EDIT
VARCHAR2
20
No
No
Active
Was Recorded Editted After Entry
VARCHAR2
24
NS
VARCHAR2
20
No
No
Active
Second Latitude Hemisphere Meaurement
VARCHAR2
25
EW
VARCHAR2
20
No
No
Active
Second Longitde Hemiphere Measurement
VARCHAR2
26
WT1
VARCHAR2
30
No
No
Active
Second Weight Measurment
VARCHAR2
27
LTH1
VARCHAR2
30
No
No
Active
Second Length Measurement
VARCHAR2
28
CODE2
FLOAT
22
No
No
126
Active
Second Tagnumber
FLOAT
29
CODE4
FLOAT
22
No
No
126
Active
Fourth Tagnumber
FLOAT
30
C2FIRST
VARCHAR2
50
No
No
Active
Boat Captain First Name
VARCHAR2
31
C2LAST
VARCHAR2
50
No
No
Active
Boat Captain Last Name
VARCHAR2
32
BOAT
VARCHAR2
100
No
No
Active
Boat Name
VARCHAR2
33
GEAR
VARCHAR2
30
No
No
Active
Code for gear used to catch the animal.
VARCHAR2
34
LASTUPDATE
DATE
7
No
No
Active
Date Record has last been updated
DATE
35
OCEAN
VARCHAR2
50
No
No
Active
Logical Flag to indicate If Fish was caught in the opern waters of an ocean
VARCHAR2
36
KILLED
VARCHAR2
20
No
No
Active
Was Fished Killed Upon Recapture
VARCHAR2
37
NMFS_STUDY
VARCHAR2
20
No
No
Active
Is This data used as part of NMFS (tag shedding) study
VARCHAR2
38
LONGLINE
VARCHAR2
20
No
No
Active
Was a longline used to catch fish
VARCHAR2
39
LJFT
VARCHAR2
20
No
No
Active
LJFT Measurement
VARCHAR2
40
ORIG_FOUND
VARCHAR2
20
No
No
Active
Was original tag still on fish
VARCHAR2
41
OLD_LOCALITY
VARCHAR2
100
No
No
Active
Old Location Code
VARCHAR2
42
LATDEG
FLOAT
22
No
No
126
Active
Degrees latitude where animal was released/recaptured. Range 0 to 90 degrees.
FLOAT
43
LATMIN
FLOAT
22
No
No
126
Active
Minutes of latitude where animal was released/recaptured. Range 0 - 59.99 minutes.
FLOAT
44
LATHEM
VARCHAR2
10
No
No
Active
Hemisphere of latitude where animal was released/recaptured. (N)orth, (S)outh, (U)nknown
VARCHAR2
45
LONDEG
FLOAT
22
No
No
126
Active
Degrees of longitude where animal was released/recaptured. Range 0 to 180 degrees
FLOAT
46
LONMIN
FLOAT
22
No
No
126
Active
Minutes of longitude where animal was released/recaptured. Range 0 - 59.99 minutes.
FLOAT
47
LONHEM
VARCHAR2
10
No
No
Active
Hemisphere of longitude where animal was released/recaptured: (E)ast, (W)est, (U)nknown
VARCHAR2
48
LENGTH
FLOAT
22
No
No
126
Active
Length of animal tagged based on the lengthunit, lengthtype, and lengthdet.
FLOAT
49
LENGTHUNIT
VARCHAR2
10
No
No
Active
Length measurement used: (IN) inches, (FT) feet, (MM) millimeters, (M ) meters, (UN) unknown, (CM) centimeters
VARCHAR2
50
LENGTHTYPE
VARCHAR2
10
No
No
Active
Type of length measurement:(E)ye fork, (F)ork length, (L)ower jaw fork length, (S)tandard length, (T)otal length, (U)nknown length
VARCHAR2
51
LENGTHDETERMINATION
VARCHAR2
10
No
No
Active
How Length Was Determined
VARCHAR2
52
WEIGHT
FLOAT
22
No
No
126
Active
Weight of an animal tagged, based upon weightunit, weighttype and weightdet.
FLOAT
53
WEIGHTUNIT
VARCHAR2
10
No
No
Active
Weight measurement used: (OZ) ounces, (LB) pounds, (GM) grams, (KG) Kilograms, (UN) Unknown
VARCHAR2
54
WEIGHTTYPE
VARCHAR2
10
No
No
Active
Weight measurement type: (R)ound, (D)ressed, (U)nknown
VARCHAR2
55
WEIGHTDETERMINATION
VARCHAR2
10
No
No
Active
How Weight Was Determined
VARCHAR2
56
FIGHT_HRS
FLOAT
22
No
No
126
Active
Number Of Hours Spent Fighting FIsh Until Landings
FLOAT
57
FIGHT_MINS
FLOAT
22
No
No
126
Active
Number Of Minutes Spent Fighting FIsh Until Landings
FLOAT
58
DUPLICATE_NAME
VARCHAR2
8
No
No
Active
Tag Number To Refernce For Doubly Tagged Fished
VARCHAR2
7114
View: TBF_CAPTURE_ANIMALS_V
TBF_CAPTURE_ANIMALS_V
Published / External
Completed
View Of Animals Captured That had been tagged with (TBF) Tags
Loaded by batch 2083, 02-22-2008 12:10
Data View
Yes
CTSPAT
View Of Animals Captured That had been tagged with (TBF) Tags
1
TBF_TAG
VARCHAR2
8
Yes
No
Active
(TBF) Tagnumber
VARCHAR2
2
TBF_SPECIES
VARCHAR2
10
Yes
No
Active
(TBF) Species Code
VARCHAR2
3
ANIMAL_ID
NUMBER
22
No
No
10
0
Active
Animal Id
NUMBER
4
INTERACTION_ORDER
NUMBER
22
No
No
2
0
Active
Interaction Order
NUMBER
7115
View: TBF_CAPTURE_DISTINCT_TAGS_V
TBF_CAPTURE_DISTINCT_TAGS_V
Published / External
Completed
View Of Distinct Billfish Foundation Tags That Have Been Recaptured
Loaded by batch 2083, 02-22-2008 12:10
Data View
Yes
CTSPAT
View Of Distinct Billfish Foundation Tags That Have Been Recaptured
1
TBF_TAG
VARCHAR2
8
Yes
No
Active
(TBF) Tagnumber
VARCHAR2
2
TBF_SPECIES
VARCHAR2
10
Yes
No
Active
(TBF) Species Code
VARCHAR2
7116
View: TBF_CAPTURE_LINK_V
TBF_CAPTURE_LINK_V
Published / External
Completed
View Connecting Data In Billfish Assocation Tables WIth that iof tables in CTS System
Loaded by batch 2083, 02-22-2008 12:10
Data View
Yes
CTSPAT
View Connecting Data In Billfish Assocation Tables WIth that iof tables in CTS System
1
TBF_TAG
VARCHAR2
8
Yes
No
Active
Billfish Agency Tag Number
VARCHAR2
2
TBF_DATE
DATE
7
Yes
No
Active
Date Billfish Agency Tag Was Applied
DATE
3
TBF_SPECIES
VARCHAR2
10
Yes
No
Active
Billfish Association Species Code
VARCHAR2
4
ANIMAL_ID
NUMBER
22
No
No
10
0
Active
Sequential Key
NUMBER
5
CTS_TAG
VARCHAR2
8
No
No
Active
Tag Number Of Agency In CTS System
VARCHAR2
6
CTS_AGENCY
VARCHAR2
3
No
No
Active
CTS Agency Code
VARCHAR2
7
CTS_DATE
VARCHAR2
10
No
No
Active
Date Other (CTS) Tag was Applied
VARCHAR2
8
INTERACTION_ORDER
NUMBER
22
No
No
2
0
Active
Code To indicate Whether Tagging Action Was A Release Or Recpature
NUMBER
7117
View: TBF_CTS_ANGLERS_V
TBF_CTS_ANGLERS_V
Published / External
Completed
View Joing ANgler Table For Agency MIA and TBF Angler Table to see difference in spelling between names
Loaded by batch 2083, 02-22-2008 12:10
Data View
Yes
CTSPAT
View Joing ANgler Table For Agency MIA and TBF Angler Table to see difference in spelling between names
1
ANGLER_ID
NUMBER
22
Yes
No
38
0
Active
Angler Number
NUMBER
2
FIRSTNAME
VARCHAR2
30
No
No
Active
Angler FIrst Name In TBF Angler Table
VARCHAR2
3
LASTNAME
VARCHAR2
30
Yes
No
Active
Angler Last Name In TBF Angler Table
VARCHAR2
4
FNAME
VARCHAR2
30
No
No
Active
Angler FIrst Name In Angler Table For Agency MIA
VARCHAR2
5
LNAME
VARCHAR2
30
No
No
Active
Angler Last Name In Angler Table For Agency MIA
VARCHAR2
7118
View: TBF_FIRST_RECAPTURES_V
TBF_FIRST_RECAPTURES_V
Published / External
Completed
CTS.TBF_FIRST_RECAPTURES_V contains informat on first recaptures by TBF.
Loaded by batch 2083, 02-22-2008 12:10
Data View
Yes
CTSPAT
CTS.TBF_FIRST_RECAPTURES_V contains informat on first recaptures by TBF.
1
ANIMAL_ID
NUMBER
22
Yes
No
10
0
Active
Unique identifier for each animal
NUMBER
2
SPECIES_ID
VARCHAR2
3
Yes
No
Active
Species Code (used in MIA Tagging System)
VARCHAR2
3
SEX
VARCHAR2
1
No
No
Active
Code to Indicate Sex Of Animal
VARCHAR2
4
ID
NUMBER
22
Yes
No
38
Active
A unique identifier for each interaction.
NUMBER
5
TAG_ID
VARCHAR2
8
Yes
No
Active
Initial tag number applied to an animal. It consists of a 2 or 3 letter prefix and a 5 or 6 digit number.
VARCHAR2
6
TAG_DATE
DATE
7
Yes
No
Active
Date animal was released or recaptured.
DATE
7
PRIOR_TAG
VARCHAR2
8
No
No
Active
Any previous tag that may have been on the animal.
VARCHAR2
8
INTERACTION_ORDER
NUMBER
22
Yes
No
2
0
Active
Number denoting the order of the interaction.
NUMBER
9
LENGTH
NUMBER
22
No
No
4
0
Active
Length of animal tagged based on the lengthunit, lengthtype, and lengthdet.
NUMBER
10
LENGTHUNIT
VARCHAR2
2
No
No
Active
Length measurement used: (IN) inches, (FT) feet, (MM) millimeters, (M ) meters, (UN) unknown, (CM) centimeters
VARCHAR2
11
LENGTHTYPE
VARCHAR2
1
No
No
Active
Type of length measurement:(E)ye fork, (F)ork length, (L)ower jaw fork length, (S)tandard length, (T)otal length, (U)nknown length
VARCHAR2
12
LENGTHDET
VARCHAR2
1
No
No
Active
Method of determining length: (E)stimated, (M)easured, (U)nknown
VARCHAR2
13
WEIGHT
NUMBER
22
No
No
6
2
Active
Weight of an animal tagged, based upon weightunit, weighttype and weightdet.
NUMBER
14
WEIGHTUNIT
VARCHAR2
2
No
No
Active
Weight measurement used: (OZ) ounces, (LB) pounds, (GM) grams, (KG) Kilograms, (UN) Unknown
VARCHAR2
15
WEIGHTTYPE
VARCHAR2
1
No
No
Active
Weight measurement type: (R)ound, (D)ressed, (U)nknown
VARCHAR2
16
WEIGHTDET
VARCHAR2
1
No
No
Active
Method of determining weight: (E)stimated, (M)easured, (U)nknown.
VARCHAR2
17
LATITUDE
NUMBER
22
No
No
30
16
Active
Numeric value for the latitude of the tagging location.
NUMBER
18
LONGITUDE
NUMBER
22
No
No
30
16
Active
Numeric value the the longitude of the tagging location.
NUMBER
19
LOCATION_NAME
VARCHAR2
255
No
No
Active
Text string describing the location where the animal was caught.
VARCHAR2
20
GEAR_ID
VARCHAR2
3
No
No
Active
Code for gear used to catch the animal.
VARCHAR2
21
BAIT_TYPE
VARCHAR2
1
No
No
Active
Code for bait used: (A)rtificial, (L)ive, (D)ead, (U)nknown
VARCHAR2
22
FIGHTHRS
NUMBER
22
No
No
3
1
Active
The number of hours spent fighting the fish before it was tagged.
NUMBER
23
FIGHTMINS
NUMBER
22
No
No
3
1
Active
The minutes part of the time spent fighting the fish before it was tagged.
NUMBER
24
CAPTAIN_AGENCY_ID
VARCHAR2
3
No
No
Active
The agency code for the captain.
VARCHAR2
25
CAPTAIN_ID
NUMBER
22
No
No
6
0
Active
Unique numeric code assigned to an individual captain. Must be greater than zero or -99999.
NUMBER
26
ANGLER_AGENCY_ID
VARCHAR2
3
No
No
Active
The agency code for the angler.
VARCHAR2
27
ANGLER_ID
NUMBER
22
No
No
6
0
Active
Unique identifier for each person in the database.
NUMBER
28
VESSEL_AGENCY_ID
VARCHAR2
3
No
No
Active
The agency code for the vessel.
VARCHAR2
29
VESSEL_ID
NUMBER
22
No
No
6
0
Active
Agency supplied code identifying the vessel involved in the release or recapture of the animal.
NUMBER
7119
Table: TBF_INTERACTIONS
TBF_INTERACTIONS
Published / External
Completed
CTS.TBF_INTERACTIONS is the primary table of the CTS systems.It contains the information on the actual tagging event, such as,the initial release, the recapture or the re-release of an animal.
Loaded by batch 2083, 02-22-2008 12:10
Data Table
Yes
CTSPAT
CTS.TBF_INTERACTIONS is the primary table of the CTS systems.It contains the information on the actual tagging event, such as,the initial release, the recapture or the re-release of an animal.
1
ANIMAL_ID
NUMBER
22
Yes
No
10
0
Active
Unique identifier for each animal
NUMBER
2
TAG_ID
VARCHAR2
8
Yes
No
Active
Initial tag number applied to an animal. It consists of a 2 or 3 letter prefix and a 5 or 6 digit number.
VARCHAR2
3
TAG_DATE
DATE
7
Yes
No
Active
Date animal was released or recaptured.
DATE
4
PRIOR_TAG
VARCHAR2
8
No
No
Active
Any previous tag that may have been on the animal.
VARCHAR2
5
INTERACTION_ORDER
NUMBER
22
Yes
No
2
0
Active
Number denoting the order of the interaction.
NUMBER
6
LENGTH
NUMBER
22
No
No
4
0
Active
Length of animal tagged based on the lengthunit, lengthtype, and lengthdet.
NUMBER
7
LENGTHUNIT
VARCHAR2
2
No
No
Active
Length measurement used: (IN) inches, (FT) feet, (MM) millimeters, (M ) meters, (UN) unknown, (CM) centimeters
VARCHAR2
8
LENGTHTYPE
VARCHAR2
1
No
No
Active
Type of length measurement:(E)ye fork, (F)ork length, (L)ower jaw fork length, (S)tandard length, (T)otal length, (U)nknown length
VARCHAR2
9
LENGTHDET
VARCHAR2
1
No
No
Active
Method of determining length: (E)stimated, (M)easured, (U)nknown
VARCHAR2
10
WEIGHT
NUMBER
22
No
No
6
2
Active
Weight of an animal tagged, based upon weightunit, weighttype and weightdet.
NUMBER
11
WEIGHTUNIT
VARCHAR2
2
No
No
Active
Weight measurement used: (OZ) ounces, (LB) pounds, (GM) grams, (KG) Kilograms, (UN) Unknown
VARCHAR2
12
WEIGHTTYPE
VARCHAR2
1
No
No
Active
Weight measurement type: (R)ound, (D)ressed, (U)nknown
VARCHAR2
13
WEIGHTDET
VARCHAR2
1
No
No
Active
Method of determining weight: (E)stimated, (M)easured, (U)nknown.
VARCHAR2
14
LATITUDE
NUMBER
22
No
No
30
16
Active
Numeric value for the latitude of the tagging location.
NUMBER
15
LONGITUDE
NUMBER
22
No
No
30
16
Active
Numeric value the the longitude of the tagging location.
NUMBER
16
LOCATION_NAME
VARCHAR2
255
No
No
Active
Text string describing the location where the animal was caught.
VARCHAR2
17
GEAR_ID
VARCHAR2
3
No
No
Active
Code for gear used to catch the animal.
VARCHAR2
18
BAIT_TYPE
VARCHAR2
1
No
No
Active
Code for bait used: (A)rtificial, (L)ive, (D)ead, (U)nknown
VARCHAR2
19
CAPTAIN_AGENCY_ID
VARCHAR2
3
No
No
Active
The agency code for the captain.
VARCHAR2
20
CAPTAIN_ID
NUMBER
22
No
No
6
0
Active
Unique numeric code assigned to an individual captain. Must be greater than zero or -99999.
NUMBER
21
VESSEL_AGENCY_ID
VARCHAR2
3
No
No
Active
The agency code for the vessel.
VARCHAR2
22
VESSEL_ID
NUMBER
22
No
No
6
0
Active
Agency supplied code identifying the vessel involved in the release or recapture of the animal.
NUMBER
23
FIGHTHRS
NUMBER
22
No
No
3
1
Active
The number of hours spent fighting the fish before it was tagged.
NUMBER
24
FIGHTMINS
NUMBER
22
No
No
3
1
Active
The minutes part of the time spent fighting the fish before it was tagged.
NUMBER
25
ANGLER_AGENCY_ID
VARCHAR2
3
No
No
Active
The agency code for the angler.
VARCHAR2
26
ANGLER_ID
NUMBER
22
No
No
6
0
Active
Unique identifier for each person in the database.
NUMBER
27
GEOM
SDO_GEOMETRY
1
No
No
Active
Oracle Spatial vector geometry object to store the track.
SDO_GEOMETRY
28
ID
NUMBER
22
Yes
Yes
38
Active
A unique identifier for each interaction.
NUMBER
29
DATE_ENTERED
DATE
7
No
No
Active
The date the data was entered.
DATE
7120
View: TBF_NEW_DISTINCT_TAGS_V
TBF_NEW_DISTINCT_TAGS_V
Published / External
Completed
List Of Distinct TBF Tags
Loaded by batch 2083, 02-22-2008 12:10
Data View
Yes
CTSPAT
List Of Distinct TBF Tags
1
TBF_TAG
VARCHAR2
8
Yes
No
Active
TBF Tagnumber
VARCHAR2
2
TBF_SPECIES
VARCHAR2
10
Yes
No
Active
TBF Species Code
VARCHAR2
7121
Table: TBF_PERSONS
TBF_PERSONS
Published / External
Completed
Person Table From The Bill Fish Foundation
Loaded by batch 2083, 02-22-2008 12:10
Data Table
Yes
CTSPAT
Person Table From The Bill Fish Foundation
1
AGENCY_ID
VARCHAR2
3
Yes
No
Active
Code identifying the agency the person is affiliated.
VARCHAR2
2
ID
NUMBER
22
Yes
Yes
38
Active
Unique identifer for each person.
NUMBER
3
TITLE
VARCHAR2
20
No
No
Active
The persons official title ('CAPT.', 'Mr.', 'Mrs.')
VARCHAR2
4
FIRSTNAME
VARCHAR2
30
No
No
Active
First Name
VARCHAR2
5
LASTNAME
VARCHAR2
30
Yes
No
Active
Last Name
VARCHAR2
6
M_INITIAL
VARCHAR2
2
No
No
Active
Midle Iniitial
VARCHAR2
7
SUFFIX
VARCHAR2
20
No
No
Active
Name Suffix (like Jr)
VARCHAR2
8
ADDRESS1
VARCHAR2
100
No
No
Active
First Line Of Address
VARCHAR2
9
ADDRESS2
VARCHAR2
100
No
No
Active
Second Line Of Address
VARCHAR2
10
CITY
VARCHAR2
50
No
No
Active
City of mailing address
VARCHAR2
11
STATE
VARCHAR2
30
No
No
Active
Stae Of mailling address
VARCHAR2
12
ZIP
VARCHAR2
30
No
No
Active
Zipcode Of Mailing Address
VARCHAR2
13
COUNTRY
VARCHAR2
30
No
No
Active
Country Of Mailing Address
VARCHAR2
14
HOME_NUMBER
VARCHAR2
30
No
No
Active
Home Phone Number
VARCHAR2
15
WORK_NUMBER
VARCHAR2
30
No
No
Active
Work Phone Number
VARCHAR2
16
MOBILE_NUMBER
VARCHAR2
100
No
No
Active
Mobile/Celluar Number
VARCHAR2
17
FAX_NUMBER
VARCHAR2
15
No
No
Active
Facsimile Number
VARCHAR2
18
EMAIL
VARCHAR2
50
No
No
Active
Email Address
VARCHAR2
Data Steward
2000
Person
Orbesen, Eric
Eric.Orbesen@noaa.gov
75 Virginia Beach Drive
Miami
33149
305-361-4253
Contact by email preferred.
Data Steward
1985-01-01
2011
Person
Prince, Eric
Distributor
1954
Organization
Southeast Fisheries Science Center
SEFSC
75 Virginia Beach Drive
Miami
FL
33149
USA
(305)361-5761
https://www.fisheries.noaa.gov/about/southeast-fisheries-science-center
About SEFSC
Online Resource
8:00 a.m. - 4:30 p.m. EST
Metadata Contact
2000
Person
Orbesen, Eric
Eric.Orbesen@noaa.gov
75 Virginia Beach Drive
Miami
33149
305-361-4253
Contact by email preferred.
Point of Contact
2015
Person
Hoolihan, John
john.hoolihan@noaa.gov
75 Virginia Beach Drive
Miami
FL
33149
USA
305-365-4116
Ground Condition
-97
-64
42
3
CTS uses latitude and longitude to identify where the animal is released and recaptured. Most of the events occurs between latitude 3 - 42 N and 64 - 97 W.
It includes the Atlantic Ocean, Gulf of Mexico, and Caribbean Sea
Continuing
2011
-179
179
50
-50
Global
Range
1954
2010
Sensitive
.
TBD
The data will be available from a public web server once an access methodology has been developed.
Angler names and addresses
TBD
If the tag date for an initial release in Jan 1, 1940, it means that the the initial tag data is not known
Oracle Database
Constituent based tagging programs are susceptible to both recording and input errors. We are currently scanning historical data cards and examining the database for suspect locations (on land, or in an unexpected location based on species preferences) and correcting any errors.
No
0
Yes
Yes
No
365
This data is currently wavered under the current NOAA guidelines for relational databases.
To Be Determined
365
The data resides on a secure government network requiring multi-factor authentication for network access.
1
Data is inputted into an oracle database and yearly the data is examined using arcgis to identify suspect locations.
7024
Entity
Table: CTS_ADDRESS_LOCATIONS
7025
Entity
Table: CTS_ADDRESS_STATUS
7026
Entity
Table: CTS_AGENCIES
7027
Entity
Table: CTS_ANGLERS
7029
Entity
Table: CTS_ANGLER_NOTES
7030
Entity
Table: CTS_ANIMALS
7033
Entity
Table: CTS_ANIMAL_NOTES
7034
Entity
Table: CTS_ARGOS
7036
Entity
Table: CTS_BAIT_TYPES
7037
Entity
Table: CTS_BLEEDING
7038
Entity
Table: CTS_COLORS
7039
Entity
Table: CTS_COUNTRIES
7040
Entity
Table: CTS_DISTRIBUTED_TAGS
7041
Entity
Table: CTS_EVENTS
7042
Entity
Table: CTS_FISHING_METHODS
7043
Entity
Table: CTS_GEAR
7044
Entity
Table: CTS_HOOK_LOCATIONS
7045
Entity
Table: CTS_HOOK_TYPES
7046
Entity
Table: CTS_INTERACTIONS
7050
Entity
Table: CTS_KFTRACK
7051
Entity
Table: CTS_LENGTH_DETERMINATION
7052
Entity
Table: CTS_LENGTH_TYPE
7053
Entity
Table: CTS_LENGTH_UNIT
7055
Entity
Table: CTS_LOCATION_LATLONG
7056
Entity
Table: CTS_MULTITAG
7057
Entity
Table: CTS_PAT_INVESTIGATORS
7058
Entity
Table: CTS_PAT_LOCATIONS
7060
Entity
Table: CTS_PAT_PDT
7062
Entity
Table: CTS_PAT_RAW
7063
Entity
Table: CTS_PAT_STATUS
7065
Entity
Table: CTS_PAT_TAD
7067
Entity
Table: CTS_PAT_TAG
7068
Entity
Table: CTS_PAT_TAG_BIN
7071
Entity
Table: CTS_PAT_TAG_RESOLUTION
7072
Entity
Table: CTS_PAT_TAT
7074
Entity
Table: CTS_PHYSICAL_DATA
7075
Entity
Table: CTS_PLACES
7076
Entity
Table: CTS_PRIORITY
7078
Entity
Table: CTS_RELEASE_CONDITIONS
7079
Entity
Table: CTS_RETURNED_TAGS
7080
Entity
Table: CTS_SAMPLES
7081
Entity
Table: CTS_SEX
7082
Entity
Table: CTS_SPECIES
7083
Entity
Table: CTS_STATES
7085
Entity
Table: CTS_SUBAREAS
7086
Entity
Table: CTS_TAGGER_TYPE
7087
Entity
Table: CTS_TAGGING_LOCATION
7088
Entity
Table: CTS_TAGGING_METHODS
7089
Entity
Table: CTS_TAG_TYPES
7091
Entity
Table: CTS_USER_PROFILES
7092
Entity
Table: CTS_VESSELS
7093
Entity
Table: CTS_WATER_BODIES
7094
Entity
Table: CTS_WEIGHT_DETERMINATION
7095
Entity
Table: CTS_WEIGHT_TYPE
7096
Entity
Table: CTS_WEIGHT_UNIT
7097
Entity
Table: CTS_YESNO
7104
Entity
Table: PAT_TAG_BIN_TYPES
7110
Entity
Table: SEL_TBF_INTERACTIONS
7111
Entity
Table: TBF_ANGLERS
7112
Entity
Table: TBF_ANIMALS
7113
Entity
Table: TBF_CAPTURE
7119
Entity
Table: TBF_INTERACTIONS
7121
Entity
Table: TBF_PERSONS
7124
Entity
Table: TBF_TAGGED
7022
Entity
View: CHECKTRANMISSIONS
7023
Entity
View: CHECK_TRANSMISSIONS
7028
Entity
View: CTS_ANGLERS_V
7031
Entity
View: CTS_ANIMALS_SEARCH_V
7032
Entity
View: CTS_ANIMALS_V
7035
Entity
View: CTS_ARGOS_COUNT_V
7047
Entity
View: CTS_INTERACTIONS_EXTRACT_V
7048
Entity
View: CTS_INTERACTIONS_SEARCH_V
7049
Entity
View: CTS_INTERACTIONS_V
7054
Entity
View: CTS_LETTERS_V
7059
Entity
View: CTS_PAT_LOCATIONS_PERF_V
7061
Entity
View: CTS_PAT_PDT_PERF_V
7064
Entity
View: CTS_PAT_STATUS_PERF_V
7066
Entity
View: CTS_PAT_TAD_PERF_V
7069
Entity
View: CTS_PAT_TAG_DAYS_V
7070
Entity
View: CTS_PAT_TAG_PERFORMANCE_V
7073
Entity
View: CTS_PAT_TAT_PERF_V
7077
Entity
View: CTS_RECAPTURE_LOOKUP_V
7084
Entity
View: CTS_STATES_V
7090
Entity
View: CTS_USER_APPLICATIONS_V
7098
Entity
View: FIFTH_INTERACTIONS_V
7099
Entity
View: FIRST_INTERACTIONS_V
7100
Entity
View: FOURTH_INTERACTIONS_V
7101
Entity
View: HABITATMATRIX_V
7102
Entity
View: ICCAT_V
7103
Entity
View: LOCATIONS_VIEW
7105
Entity
View: PDT_AGG_V
7106
Entity
View: RECAPTURES_VW
7107
Entity
View: SECOND_INTERACTIONS_V
7108
Entity
View: SEL_ANIMALS_DATA
7109
Entity
View: SEL_ANIMALS_V
7114
Entity
View: TBF_CAPTURE_ANIMALS_V
7115
Entity
View: TBF_CAPTURE_DISTINCT_TAGS_V
7116
Entity
View: TBF_CAPTURE_LINK_V
7117
Entity
View: TBF_CTS_ANGLERS_V
7118
Entity
View: TBF_FIRST_RECAPTURES_V
7120
Entity
View: TBF_NEW_DISTINCT_TAGS_V
7122
Entity
View: TBF_RELEASES_V
7123
Entity
View: TBF_SECOND_RECAPTURES_V
7125
Entity
View: TBF_TAGGED_LINK_V
7126
Entity
View: THIRD_INTERACTIONS_V
gov.noaa.nmfs.inport:5453
Lee Weinberger
2007-10-16T08:26:31
Bryson Anderson
2023-02-01T17:45:58
2021-05-05
Southeast Fisheries Science Center
SEFSC
75 Virginia Beach Drive
Miami
FL
33149
USA
(305)361-5761
www.sefsc.noaa.gov
8:00 a.m. - 4:30 p.m. EST
1001
Public
No
2021-05-05
1 Year
2022-05-05