Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
SEFSC Metadata Library > Sustainable Fisheries > Highly Migratory Species Branch > Cooperative Tagging System > Cooperative Tagging Center (CTC) >

View: CTS_LETTERS_V

Entity (ENT)  |  Southeast Fisheries Science Center (SEFSC)
GUID: gov.noaa.nmfs.inport:7054  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

View to hold information to create letters to anglers and ca[tians when a ftagged fish is recaptured

Description

View to hold information to create letters to anglers and ca[tians when a ftagged fish is recaptured

Entity Information

Entity Type
Data View

Data Attribute / Type Description
INTERACTION_ID
NUMBER 		Link to interaction record
ANIMAL_ID
NUMBER 		Animal Id
TAG_ID
VARCHAR2 		Tagnumber
SPECIES_ID
VARCHAR2 		Species Code
SPECIES_NAME
VARCHAR2 		Species Name
TAG_DATE
VARCHAR2 		Date animal was tagged
LOCATION
VARCHAR2 		location of recapture
LENGTH
NUMBER 		Length Of recpatured fish
WEIGHT
NUMBER 		Weight of recaptured fish
FISHERMAN_NAME
VARCHAR2 		Fisherman's name
ADDRESS_1
VARCHAR2 		First Line address
ADDRESS_2
VARCHAR2 		Second Line address
CITY
VARCHAR2 		CIty
STATE_NAME
VARCHAR2 		State
ZIPCODE
VARCHAR2 		Zipcode
COUNTRY_NAME
VARCHAR2 		country

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (SEFSC) for inquiries on this record.

Item Identification

Title: View: CTS_LETTERS_V
Short Name: CTS_LETTERS_V
Status: Completed
Abstract:

View to hold information to create letters to anglers and ca[tians when a ftagged fish is recaptured
Notes:

Loaded by batch 2083, 02-22-2008 12:10

Entity Information

Entity Type: Data View
Active Version?: Yes
Schema Name: CTSPAT
Description:

View to hold information to create letters to anglers and ca[tians when a ftagged fish is recaptured

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 INTERACTION_ID NUMBER Link to interaction record
100
 ANIMAL_ID NUMBER Animal Id
100
 TAG_ID VARCHAR2 Tagnumber
100
 SPECIES_ID VARCHAR2 Species Code
100
 SPECIES_NAME VARCHAR2 Species Name
100
 TAG_DATE VARCHAR2 Date animal was tagged
100
 LOCATION VARCHAR2 location of recapture
100
 LENGTH NUMBER Length Of recpatured fish
100
 WEIGHT NUMBER Weight of recaptured fish
100
 FISHERMAN_NAME VARCHAR2 Fisherman's name
100
 ADDRESS_1 VARCHAR2 First Line address
100
 ADDRESS_2 VARCHAR2 Second Line address
100
 CITY VARCHAR2 CIty
100
 STATE_NAME VARCHAR2 State
100
 ZIPCODE VARCHAR2 Zipcode
100
 COUNTRY_NAME VARCHAR2 country

Attribute Details

INTERACTION_ID

CC ID: 25908
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Link to interaction record
General Data Type: NUMBER

ANIMAL_ID

CC ID: 25909
Seq. Order: 2
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

Animal Id
General Data Type: NUMBER

TAG_ID

CC ID: 25896
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 12
Required: No
Primary Key: No
Status: Active
Description:

Tagnumber
General Data Type: VARCHAR2

SPECIES_ID

CC ID: 25903
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Species Code
General Data Type: VARCHAR2

SPECIES_NAME

CC ID: 25906
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 21
Required: No
Primary Key: No
Status: Active
Description:

Species Name
General Data Type: VARCHAR2

TAG_DATE

CC ID: 25907
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Date animal was tagged
General Data Type: VARCHAR2

LOCATION

CC ID: 25904
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 13
Required: No
Primary Key: No
Status: Active
Description:

location of recapture
General Data Type: VARCHAR2

LENGTH

CC ID: 25905
Seq. Order: 8
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

Length Of recpatured fish
General Data Type: NUMBER

WEIGHT

CC ID: 25894
Seq. Order: 9
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 2
Status: Active
Description:

Weight of recaptured fish
General Data Type: NUMBER

FISHERMAN_NAME

CC ID: 25898
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 61
Required: No
Primary Key: No
Status: Active
Description:

Fisherman's name
General Data Type: VARCHAR2

ADDRESS_1

CC ID: 25900
Seq. Order: 11
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

First Line address
General Data Type: VARCHAR2

ADDRESS_2

CC ID: 25902
Seq. Order: 12
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Second Line address
General Data Type: VARCHAR2

CITY

CC ID: 25895
Seq. Order: 13
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

CIty
General Data Type: VARCHAR2

STATE_NAME

CC ID: 25901
Seq. Order: 14
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

State
General Data Type: VARCHAR2

ZIPCODE

CC ID: 25897
Seq. Order: 15
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Zipcode
General Data Type: VARCHAR2

COUNTRY_NAME

CC ID: 25899
Seq. Order: 16
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

country
General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 7054
GUID: gov.noaa.nmfs.inport:7054
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2008-02-22 12:11+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2021-05-05
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2021-05-05
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2022-05-05