18971
Table: ATL_BIRD_SPECIES_TAG
ATL_BIRD_SPECIES_TAG
Entity
Published / External
18964
AFSC/FMA/NPRB Alternative Catch Monitoring Table and Column Definitions
Data Set
Completed
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.
Loaded by batch 4574, 05-03-2013 17:18
Data Table
Yes
NPRB_1017
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.
1
TAG_SEQ
NUMBER
22
Yes
Yes
8
0
Active
sequence generated unique identifier for this tag record.
NUMBER
2
CRUISE
NUMBER
22
Yes
Yes
8
0
Active
Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record.
NUMBER
NPRB_1017.ATL_BIRD_SPECIMEN
3
PERMIT
VARCHAR2
6
Yes
Yes
Active
Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau
VARCHAR2
NPRB_1017.ATL_BIRD_SPECIMEN
4
TYPE_CODE
NUMBER
22
Yes
No
38
0
Active
Unique code identifying the type of recovered tag.
NUMBER
NPRB_1017.ATL_LOV_BIRD_TAG_TYP
5
LOCATION_CODE
NUMBER
22
Yes
No
3
0
Active
Unique Code for the found location of a bird tag. For example rtleg;
NUMBER
NPRB_1017.ATL_LOV_BIRD_TAG_LOC
6
COLOR_CODE
NUMBER
22
Yes
No
3
0
Active
Color Code
NUMBER
NPRB_1017.ATL_LOV_BIRD_LEG_BAN
7
SPECIMEN_SEQ
NUMBER
22
Yes
No
9
0
Active
Sequence generated unique identifier of a bird specimen.
NUMBER
NPRB_1017.ATL_BIRD_SPECIMEN
8
TAG_NUMBER
VARCHAR2
20
No
No
Active
If a tag is present and if read this field records the USFWS number or other number.
VARCHAR2
9
POSITION_CODE
NUMBER
22
No
No
38
0
Active
Position on the leg of a bird reletive to other bands 1 = Only Band, 2 = Top, 3 = 2nd, 4 = 3rd, 5 = 4th.
NUMBER
gov.noaa.nmfs.inport:18971
Doug Turnbull
2013-05-03T17:18:46
SysAdmin InPortAdmin
2022-08-09T17:11:09
2016-05-18
Alaska Fisheries Science Center
AFSC
7600 Sand Point Way N.E., Building 4
Seattle
WA
98115
USA
http://www.afsc.noaa.gov
0700-1700 Pacific Time
1001
Public
No
2016-05-18
1 Year
2017-05-18