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_DISTRIBUTED_TAGS

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

Summary

Abstract

CTS.CTS_DISTRIBUTED_TAGS describes what tags were issued to individual anglersand what rewards were paid for recovering tags.

Description

CTS.CTS_DISTRIBUTED_TAGS describes what tags were issued to individual anglersand what rewards were paid for recovering tags.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
AGENCY_ID
VARCHAR2 		Code for agency assigning the tags.
TAG_TYPE_ID
VARCHAR2 		Key to Type Of Tag
BEGINTAG
VARCHAR2 		Lowest tag number of a set of consecutive tags assigned to an angler.
ENDTAG
VARCHAR2 		Highest tag number of a set of consecutive tags assigned to an angler. Format: aannnnnn where: aa = tag prefix. (must be same as BEGINTAG) nnnnnn = tag number. (must be = > than BEGINTAG nnnnnn)
FIRST_COLOR
VARCHAR2 		First Color On Tag
SECOND_COLOR
VARCHAR2 		Second Color On Tag
LENGTH_CM
NUMBER 		Tag Length In Centimeters
RECEIVING_AGENCY_ID
VARCHAR2 		Code for agency receiving the set of tags. (Required if ANGLER is .99999)
RETURN_ADDRESS_ID
NUMBER 		Address code where tags should be returned.
TAGS_ASSIGNED
VARCHAR2 		Flag to indicate if this set has been assigned to an angler. Options: Y-yes, N-no, U-unknown.
TAGS_ASSIGNED_DATE
DATE 		Date set of tags were assigned. (Required if ASSIGNED = Yes) Format: mm/dd/yy
ANGLER_AGENCY_ID
VARCHAR2 		Angler code of angler assigned the set of tags. (Required if RECEIVAGE is blank)
ANGLER_ID
NUMBER 		Name of angler, agency, or party assigned the set of tags.
KIT_SENT
VARCHAR2 		Flag indicating if complete kit was sent to party receiving tags. Options: Y-yes, N-no. U-unknown
REPLY_DATE
DATE 		Date reply acknowledgement was received.
REWARD_AMOUNT
NUMBER 		Whole dollar amount of the reward sent for the return of the tag. Where: nnn = 0 to 998 Or 999 for non-monetary incentive offered, i.e. hats, t-shirts, flags.
AV_EDITCYC
NUMBER 		A control field, (0) indicates an add, (1) indicates an update. Once updated, records are stored with a value of 0 in this field.
AV_EDITDAT
DATE 		The date the record was initially entered, or last updated, whichever is later.
AV_DELEDAT
DATE 		A control field used to delete existing records from this table. No records are stored with a value in this field.

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

CTS.CTS_DISTRIBUTED_TAGS describes what tags were issued to individual anglersand what rewards were paid for recovering tags.
Notes:

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

Entity Information

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

CTS.CTS_DISTRIBUTED_TAGS describes what tags were issued to individual anglersand what rewards were paid for recovering tags.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key AGENCY_ID VARCHAR2 Code for agency assigning the tags.
100
 Primary Key TAG_TYPE_ID VARCHAR2 Key to Type Of Tag
100
 Primary Key BEGINTAG VARCHAR2 Lowest tag number of a set of consecutive tags assigned to an angler.
100
 ENDTAG VARCHAR2 Highest tag number of a set of consecutive tags assigned to an angler. Format: aannnnnn where: aa = tag prefix. (must be same as BEGINTAG) nnnnnn = tag number. (must be = > than BEGINTAG nnnnnn)
100
 FIRST_COLOR VARCHAR2 First Color On Tag
100
 SECOND_COLOR VARCHAR2 Second Color On Tag
100
 LENGTH_CM NUMBER Tag Length In Centimeters
100
 RECEIVING_AGENCY_ID VARCHAR2 Code for agency receiving the set of tags. (Required if ANGLER is .99999)
100
 RETURN_ADDRESS_ID NUMBER Address code where tags should be returned.
100
 TAGS_ASSIGNED VARCHAR2 Flag to indicate if this set has been assigned to an angler. Options: Y-yes, N-no, U-unknown.
100
 TAGS_ASSIGNED_DATE DATE Date set of tags were assigned. (Required if ASSIGNED = Yes) Format: mm/dd/yy
100
 ANGLER_AGENCY_ID VARCHAR2 Angler code of angler assigned the set of tags. (Required if RECEIVAGE is blank)
100
 ANGLER_ID NUMBER Name of angler, agency, or party assigned the set of tags.
100
 KIT_SENT VARCHAR2 Flag indicating if complete kit was sent to party receiving tags. Options: Y-yes, N-no. U-unknown
100
 REPLY_DATE DATE Date reply acknowledgement was received.
100
 REWARD_AMOUNT NUMBER Whole dollar amount of the reward sent for the return of the tag. Where: nnn = 0 to 998 Or 999 for non-monetary incentive offered, i.e. hats, t-shirts, flags.
100
 AV_EDITCYC NUMBER A control field, (0) indicates an add, (1) indicates an update. Once updated, records are stored with a value of 0 in this field.
100
 AV_EDITDAT DATE The date the record was initially entered, or last updated, whichever is later.
100
 AV_DELEDAT DATE A control field used to delete existing records from this table. No records are stored with a value in this field.

Attribute Details

AGENCY_ID

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

Code for agency assigning the tags.
General Data Type: VARCHAR2

TAG_TYPE_ID

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

Key to Type Of Tag
General Data Type: VARCHAR2

BEGINTAG

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

Lowest tag number of a set of consecutive tags assigned to an angler.
General Data Type: VARCHAR2

ENDTAG

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

Highest tag number of a set of consecutive tags assigned to an angler. Format: aannnnnn where: aa = tag prefix. (must be same as BEGINTAG) nnnnnn = tag number. (must be = > than BEGINTAG nnnnnn)
General Data Type: VARCHAR2

FIRST_COLOR

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

First Color On Tag
General Data Type: VARCHAR2

SECOND_COLOR

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

Second Color On Tag
General Data Type: VARCHAR2

LENGTH_CM

CC ID: 25674
Seq. Order: 7
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Tag Length In Centimeters
General Data Type: NUMBER

RECEIVING_AGENCY_ID

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

Code for agency receiving the set of tags. (Required if ANGLER is .99999)
General Data Type: VARCHAR2

RETURN_ADDRESS_ID

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

Address code where tags should be returned.
General Data Type: NUMBER

TAGS_ASSIGNED

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

Flag to indicate if this set has been assigned to an angler. Options: Y-yes, N-no, U-unknown.
General Data Type: VARCHAR2

TAGS_ASSIGNED_DATE

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

Date set of tags were assigned. (Required if ASSIGNED = Yes) Format: mm/dd/yy
General Data Type: DATE

ANGLER_AGENCY_ID

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

Angler code of angler assigned the set of tags. (Required if RECEIVAGE is blank)
General Data Type: VARCHAR2

ANGLER_ID

CC ID: 25680
Seq. Order: 13
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Name of angler, agency, or party assigned the set of tags.
General Data Type: NUMBER

KIT_SENT

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

Flag indicating if complete kit was sent to party receiving tags. Options: Y-yes, N-no. U-unknown
General Data Type: VARCHAR2

REPLY_DATE

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

Date reply acknowledgement was received.
General Data Type: DATE

REWARD_AMOUNT

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

Whole dollar amount of the reward sent for the return of the tag. Where: nnn = 0 to 998 Or 999 for non-monetary incentive offered, i.e. hats, t-shirts, flags.
General Data Type: NUMBER

AV_EDITCYC

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

A control field, (0) indicates an add, (1) indicates an update. Once updated, records are stored with a value of 0 in this field.
General Data Type: NUMBER

AV_EDITDAT

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

The date the record was initially entered, or last updated, whichever is later.
General Data Type: DATE

AV_DELEDAT

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

A control field used to delete existing records from this table. No records are stored with a value in this field.
General Data Type: DATE

Catalog Details

Catalog Item ID: 7040
GUID: gov.noaa.nmfs.inport:7040
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2008-02-22 12:10+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