Metadata Rubric

100%

6 / 6

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

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

	Name	Type	Description
100	AGENCY_ID	VARCHAR2	Code for agency assigning the tags.
100	TAG_TYPE_ID	VARCHAR2	Key to Type Of Tag
100	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.

Name

Type

Description

100

AGENCY_ID

VARCHAR2

Code for agency assigning the tags.

100

TAG_TYPE_ID

VARCHAR2

Key to Type Of Tag

100

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