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: TBF_CAPTURE_LINK_V

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

Summary

Abstract

View Connecting Data In Billfish Assocation Tables WIth that iof tables in CTS System

Description

View Connecting Data In Billfish Assocation Tables WIth that iof tables in CTS System

Entity Information

Entity Type
Data View

Data Attribute / Type Description
TBF_TAG
VARCHAR2 		Billfish Agency Tag Number
TBF_DATE
DATE 		Date Billfish Agency Tag Was Applied
TBF_SPECIES
VARCHAR2 		Billfish Association Species Code
ANIMAL_ID
NUMBER 		Sequential Key
CTS_TAG
VARCHAR2 		Tag Number Of Agency In CTS System
CTS_AGENCY
VARCHAR2 		CTS Agency Code
CTS_DATE
VARCHAR2 		Date Other (CTS) Tag was Applied
INTERACTION_ORDER
NUMBER 		Code To indicate Whether Tagging Action Was A Release Or Recpature

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

View Connecting Data In Billfish Assocation Tables WIth that iof tables in CTS System
Notes:

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

Entity Information

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

View Connecting Data In Billfish Assocation Tables WIth that iof tables in CTS System

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 TBF_TAG VARCHAR2 Billfish Agency Tag Number
100
 TBF_DATE DATE Date Billfish Agency Tag Was Applied
100
 TBF_SPECIES VARCHAR2 Billfish Association Species Code
100
 ANIMAL_ID NUMBER Sequential Key
100
 CTS_TAG VARCHAR2 Tag Number Of Agency In CTS System
100
 CTS_AGENCY VARCHAR2 CTS Agency Code
100
 CTS_DATE VARCHAR2 Date Other (CTS) Tag was Applied
100
 INTERACTION_ORDER NUMBER Code To indicate Whether Tagging Action Was A Release Or Recpature

Attribute Details

TBF_TAG

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

Billfish Agency Tag Number
General Data Type: VARCHAR2

TBF_DATE

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

Date Billfish Agency Tag Was Applied
General Data Type: DATE

TBF_SPECIES

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

Billfish Association Species Code
General Data Type: VARCHAR2

ANIMAL_ID

CC ID: 26868
Seq. Order: 4
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

CTS_TAG

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

Tag Number Of Agency In CTS System
General Data Type: VARCHAR2

CTS_AGENCY

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

CTS Agency Code
General Data Type: VARCHAR2

CTS_DATE

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

Date Other (CTS) Tag was Applied
General Data Type: VARCHAR2

INTERACTION_ORDER

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

Code To indicate Whether Tagging Action Was A Release Or Recpature
General Data Type: NUMBER

Catalog Details

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