Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

View Linking Billfish Foundation Tags to Mia NMFS Tags

Description

View Linking Billfish Foundation Tags to Mia NMFS Tags

Entity Information

Entity Type
Data View

Data Attribute / Type Description
TBF_TAG
VARCHAR2
Tagnumber Issued By The Billfish Foundation
TBF_DATE
DATE
Tag Date Per The Billfish Foundation
TBF_SPECIES
VARCHAR2
Bullifish Foundation Species Code
ANIMAL_ID
NUMBER
Unique Indentifier per fish
CTS_TAG
VARCHAR2
Tag Number
CTS_AGENCY
VARCHAR2
CTS Agency Code
CTS_DATE
VARCHAR2
Tag Date
INTERACTION_ORDER
NUMBER
Interaction Order

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

View Linking Billfish Foundation Tags to Mia NMFS 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 Linking Billfish Foundation Tags to Mia NMFS Tags

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
TBF_TAG VARCHAR2 Tagnumber Issued By The Billfish Foundation
100
TBF_DATE DATE Tag Date Per The Billfish Foundation
100
TBF_SPECIES VARCHAR2 Bullifish Foundation Species Code
100
ANIMAL_ID NUMBER Unique Indentifier per fish
100
CTS_TAG VARCHAR2 Tag Number
100
CTS_AGENCY VARCHAR2 CTS Agency Code
100
CTS_DATE VARCHAR2 Tag Date
100
INTERACTION_ORDER NUMBER Interaction Order

Attribute Details

TBF_TAG

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

Tagnumber Issued By The Billfish Foundation

General Data Type: VARCHAR2

TBF_DATE

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

Tag Date Per The Billfish Foundation

General Data Type: DATE

TBF_SPECIES

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

Bullifish Foundation Species Code

General Data Type: VARCHAR2

ANIMAL_ID

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

Unique Indentifier per fish

General Data Type: NUMBER

CTS_TAG

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

Tag Number

General Data Type: VARCHAR2

CTS_AGENCY

CC ID: 27071
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: 27068
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Tag Date

General Data Type: VARCHAR2

INTERACTION_ORDER

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

Interaction Order

General Data Type: NUMBER

Catalog Details

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