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_RECAPTURE_LOOKUP_V

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

Summary

Abstract

View of Tags

Description

View of Tags

Entity Information

Entity Type
Data View

Data Attribute / Type Description
ANIMAL_ID
NUMBER 		Sequential Key
INTERACTION_ORDER
NUMBER 		Code To indicate last cycle of release recapture. 1 = initial release, 2 = recpature,3=release after recapture,4=recapture after second release etc
AGENCY_ID
VARCHAR2 		Agency Cose Associated With First Tag
TAG_ID
VARCHAR2 		First Tag Number
NEXT_TAG_AGENCY_ID
VARCHAR2 		Code Of Agency Associated With Second Tag On Record
NEXT_TAG_ID
VARCHAR2 		Tag Number Of Second Tag On Record
TAG_DATE
VARCHAR2 		Date Tag Was Applied

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_RECAPTURE_LOOKUP_V
Short Name: CTS_RECAPTURE_LOOKUP_V
Status: Completed
Abstract:

View of Tags
Notes:

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

Entity Information

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

View of Tags

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 ANIMAL_ID NUMBER Sequential Key
100
 INTERACTION_ORDER NUMBER Code To indicate last cycle of release recapture. 1 = initial release, 2 = recpature,3=release after recapture,4=recapture after second release etc
100
 AGENCY_ID VARCHAR2 Agency Cose Associated With First Tag
100
 TAG_ID VARCHAR2 First Tag Number
100
 NEXT_TAG_AGENCY_ID VARCHAR2 Code Of Agency Associated With Second Tag On Record
100
 NEXT_TAG_ID VARCHAR2 Tag Number Of Second Tag On Record
100
 TAG_DATE VARCHAR2 Date Tag Was Applied

Attribute Details

ANIMAL_ID

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

Sequential Key
General Data Type: NUMBER

INTERACTION_ORDER

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

Code To indicate last cycle of release recapture. 1 = initial release, 2 = recpature,3=release after recapture,4=recapture after second release etc
General Data Type: NUMBER

AGENCY_ID

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

Agency Cose Associated With First Tag
General Data Type: VARCHAR2

TAG_ID

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

First Tag Number
General Data Type: VARCHAR2

NEXT_TAG_AGENCY_ID

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

Code Of Agency Associated With Second Tag On Record
General Data Type: VARCHAR2

NEXT_TAG_ID

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

Tag Number Of Second Tag On Record
General Data Type: VARCHAR2

TAG_DATE

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

Date Tag Was Applied
General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 7077
GUID: gov.noaa.nmfs.inport:7077
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