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) >

Table: CTS_MULTITAG

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

Summary

Abstract

Keeps Track of Multi Tagged Fish

Description

Keeps Track of Multi Tagged Fish

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
CTS_INTERACTIONS_ANIMAL_ID
NUMBER 		Foreign Key To Animal record
CTS_INTERACTIONS_INTERACTION_O
NUMBER 		Foreign Key To CTS_INTERACTIONS Record
AGENCY_ID
VARCHAR2 		Foriegn Key to Agency Table For Tag ID
TAG_ID
VARCHAR2 		Tag Id Number
NEXT_TAG_AGENCY_ID
VARCHAR2 		Foriegn Key to Agency Table For Next Tag ID
NEXT_TAG_ID
VARCHAR2 		Next Tag ID Number
DATE_APPLIED
DATE 		Date tag was applied
DATE_REMOVED
DATE 		Date Tabe was removed

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: Table: CTS_MULTITAG
Short Name: CTS_MULTITAG
Status: Completed
Abstract:

Keeps Track of Multi Tagged Fish
Notes:

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

Entity Information

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

Keeps Track of Multi Tagged Fish

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key CTS_INTERACTIONS_ANIMAL_ID NUMBER Foreign Key To Animal record
100
 Primary Key CTS_INTERACTIONS_INTERACTION_O NUMBER Foreign Key To CTS_INTERACTIONS Record
100
 Primary Key AGENCY_ID VARCHAR2 Foriegn Key to Agency Table For Tag ID
100
 Primary Key TAG_ID VARCHAR2 Tag Id Number
100
 Primary Key NEXT_TAG_AGENCY_ID VARCHAR2 Foriegn Key to Agency Table For Next Tag ID
100
 Primary Key NEXT_TAG_ID VARCHAR2 Next Tag ID Number
100
 DATE_APPLIED DATE Date tag was applied
100
 DATE_REMOVED DATE Date Tabe was removed

Attribute Details

CTS_INTERACTIONS_ANIMAL_ID

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

Foreign Key To Animal record
General Data Type: NUMBER

CTS_INTERACTIONS_INTERACTION_O

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

Foreign Key To CTS_INTERACTIONS Record
General Data Type: NUMBER

AGENCY_ID

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

Foriegn Key to Agency Table For Tag ID
General Data Type: VARCHAR2

TAG_ID

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

Tag Id Number
General Data Type: VARCHAR2

NEXT_TAG_AGENCY_ID

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

Foriegn Key to Agency Table For Next Tag ID
General Data Type: VARCHAR2

NEXT_TAG_ID

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

Next Tag ID Number
General Data Type: VARCHAR2

DATE_APPLIED

CC ID: 25923
Seq. Order: 7
Data Storage Type: DATE
Max Length: 7
Required: Yes
Primary Key: No
Status: Active
Description:

Date tag was applied
General Data Type: DATE

DATE_REMOVED

CC ID: 25924
Seq. Order: 8
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date Tabe was removed
General Data Type: DATE

Catalog Details

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