View: CTS_LETTERS_V
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:7054 | Updated: August 9, 2022 | Published / External
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
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 |