View: CTS_LETTERS_V
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:7054 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
View to hold information to create letters to anglers and ca[tians when a ftagged fish is recaptured
DescriptionView 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
![]() |
![]() |
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Seq. Order: | 14 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 30 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
State |
General Data Type: | VARCHAR2 |
ZIPCODE
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
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 |