Metadata Rubric

100%

6 / 6

Alaska Fisheries Science Center Metadata Librar... > Fisheries Management and Analysis Division > Special Projects > Alternative catch monitoring of Alaskan groundf... > AFSC/FMA/NPRB Alternative Catch Monitoring Tabl... >

Table: ATL_BIRD_SPECIES_TAG

Entity (ENT) | Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:18971 | Updated: August 9, 2022 | Published / External

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

This entity represents the tag or leg band(s) observed on an individual animal. It requires that a specimen record be created even if the band(s) are only noted and described.

Description

This entity represents the tag or leg band(s) observed on an individual animal. It requires that a specimen record be created even if the band(s) are only noted and described.

Entity Type
Data Table

Data Attribute / Type	Description
TAG_SEQ NUMBER	sequence generated unique identifier for this tag record.
CRUISE NUMBER	Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record.
PERMIT VARCHAR2	Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau
TYPE_CODE NUMBER	Unique code identifying the type of recovered tag.
LOCATION_CODE NUMBER	Unique Code for the found location of a bird tag. For example rtleg;
COLOR_CODE NUMBER	Color Code
SPECIMEN_SEQ NUMBER	Sequence generated unique identifier of a bird specimen.
TAG_NUMBER VARCHAR2	If a tag is present and if read this field records the USFWS number or other number.
POSITION_CODE NUMBER	Position on the leg of a bird reletive to other bands 1 = Only Band, 2 = Top, 3 = 2nd, 4 = 3rd, 5 = 4th.

Data Attribute / Type

Description

TAG_SEQ
NUMBER

sequence generated unique identifier for this tag record.

CRUISE
NUMBER

Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record.

PERMIT
VARCHAR2

Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau

TYPE_CODE
NUMBER

Unique code identifying the type of recovered tag.

LOCATION_CODE
NUMBER

Unique Code for the found location of a bird tag. For example rtleg;

COLOR_CODE
NUMBER

Color Code

SPECIMEN_SEQ
NUMBER

Sequence generated unique identifier of a bird specimen.

TAG_NUMBER
VARCHAR2

If a tag is present and if read this field records the USFWS number or other number.

POSITION_CODE
NUMBER

Position on the leg of a bird reletive to other bands 1 = Only Band, 2 = Top, 3 = 2nd, 4 = 3rd, 5 = 4th.

No Child Items for this record.

No contact information is available for this record.

Please contact the owner organization (AFSC) for inquiries on this record.

Title:	Table: ATL_BIRD_SPECIES_TAG
Short Name:	ATL_BIRD_SPECIES_TAG
Status:	Completed
Abstract:	This entity represents the tag or leg band(s) observed on an individual animal. It requires that a specimen record be created even if the band(s) are only noted and described.
Notes:	Loaded by batch 4574, 05-03-2013 17:18

Entity Type:	Data Table
Active Version?:	Yes
Schema Name:	NPRB_1017
Description:	This entity represents the tag or leg band(s) observed on an individual animal. It requires that a specimen record be created even if the band(s) are only noted and described.

Attribute Summary

	Name	Type	Description
100	TAG_SEQ	NUMBER	sequence generated unique identifier for this tag record.
100	CRUISE	NUMBER	Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record.
100	PERMIT	VARCHAR2	Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau
100	TYPE_CODE	NUMBER	Unique code identifying the type of recovered tag.
100	LOCATION_CODE	NUMBER	Unique Code for the found location of a bird tag. For example rtleg;
100	COLOR_CODE	NUMBER	Color Code
100	SPECIMEN_SEQ	NUMBER	Sequence generated unique identifier of a bird specimen.
100	TAG_NUMBER	VARCHAR2	If a tag is present and if read this field records the USFWS number or other number.
100	POSITION_CODE	NUMBER	Position on the leg of a bird reletive to other bands 1 = Only Band, 2 = Top, 3 = 2nd, 4 = 3rd, 5 = 4th.

Name

Type

Description

100

TAG_SEQ

NUMBER

sequence generated unique identifier for this tag record.

100

CRUISE

NUMBER

Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record.

100

PERMIT

VARCHAR2

Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau

100

TYPE_CODE

NUMBER

Unique code identifying the type of recovered tag.

100

LOCATION_CODE

NUMBER

Unique Code for the found location of a bird tag. For example rtleg;

100

COLOR_CODE

NUMBER

Color Code

100

SPECIMEN_SEQ

NUMBER

Sequence generated unique identifier of a bird specimen.

100

TAG_NUMBER

VARCHAR2

If a tag is present and if read this field records the USFWS number or other number.

100

POSITION_CODE

NUMBER

Position on the leg of a bird reletive to other bands 1 = Only Band, 2 = Top, 3 = 2nd, 4 = 3rd, 5 = 4th.

Attribute Details

TAG_SEQ

CC ID: 111779

Seq. Order:	1
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	Yes
Precision:	8
Scale:	0
Status:	Active
Description:	sequence generated unique identifier for this tag record.
General Data Type:	NUMBER

CRUISE

CC ID: 111773

Seq. Order:	2
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	Yes
Precision:	8
Scale:	0
Status:	Active
Description:	Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record.
General Data Type:	NUMBER
Foreign Key Relations:	NPRB_1017.ATL_BIRD_SPECIMEN

PERMIT

CC ID: 111774

Seq. Order:	3
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	Yes
Primary Key:	Yes
Status:	Active
Description:	Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau
General Data Type:	VARCHAR2
Foreign Key Relations:	NPRB_1017.ATL_BIRD_SPECIMEN

TYPE_CODE

CC ID: 111778

Seq. Order:	4
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	38
Scale:	0
Status:	Active
Description:	Unique code identifying the type of recovered tag.
General Data Type:	NUMBER
Foreign Key Relations:	NPRB_1017.ATL_LOV_BIRD_TAG_TYP

LOCATION_CODE

CC ID: 111777

Seq. Order:	5
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Unique Code for the found location of a bird tag. For example rtleg;
General Data Type:	NUMBER
Foreign Key Relations:	NPRB_1017.ATL_LOV_BIRD_TAG_LOC

COLOR_CODE

CC ID: 111776

Seq. Order:	6
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Color Code
General Data Type:	NUMBER
Foreign Key Relations:	NPRB_1017.ATL_LOV_BIRD_LEG_BAN

SPECIMEN_SEQ

CC ID: 111775

Seq. Order:	7
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	9
Scale:	0
Status:	Active
Description:	Sequence generated unique identifier of a bird specimen.
General Data Type:	NUMBER
Foreign Key Relations:	NPRB_1017.ATL_BIRD_SPECIMEN

TAG_NUMBER

CC ID: 111780

Seq. Order:	8
Data Storage Type:	VARCHAR2
Max Length:	20
Required:	No
Primary Key:	No
Status:	Active
Description:	If a tag is present and if read this field records the USFWS number or other number.
General Data Type:	VARCHAR2

POSITION_CODE

CC ID: 111781

Seq. Order:	9
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Scale:	0
Status:	Active
Description:	Position on the leg of a bird reletive to other bands 1 = Only Band, 2 = Top, 3 = 2nd, 4 = 3rd, 5 = 4th.
General Data Type:	NUMBER

Catalog Item ID:	18971
GUID:	gov.noaa.nmfs.inport:18971
Metadata Record Created By:	Doug Turnbull
Metadata Record Created:	2013-05-03 17:18+0000
Metadata Record Last Modified By:	SysAdmin InPortAdmin
Metadata Record Last Modified:	2022-08-09 17:11+0000
Metadata Record Published:	2016-05-18
Owner Org:	AFSC
Metadata Publication Status:	Published Externally
Do Not Publish?:	N
Metadata Last Review Date:	2016-05-18
Metadata Review Frequency:	1 Year
Metadata Next Review Date:	2017-05-18

Table: ATL_BIRD_SPECIES_TAG

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

TAG_SEQ

CRUISE

PERMIT

TYPE_CODE

LOCATION_CODE

COLOR_CODE

SPECIMEN_SEQ

TAG_NUMBER

POSITION_CODE

Catalog Details