9610 ATLW_BIRD_SPECIES_TAG Entity Published / External 7284 AFSC/FMA/North Pacific Groundfish and Halibut Observer Program, Post 2008 Fishery Statistics. 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. Working Tables accept the raw data from field transmissions or data entry. They are unconstrained, Relational integrity data validation is performed when data are loaded into NORPAC transaction tables. Error checking is performed by batch processes on production data. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC 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 RECORD_SET_STATUS_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier of a record set header 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 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 4 TAG_SEQ NUMBER 22 Yes Yes 8 0 Active sequence generated unique identifier for this tag record. NUMBER 5 TYPE_CODE VARCHAR2 3 Yes No Active Unique code identifying the type of recovered tag. VARCHAR2 6 LOCATION_CODE VARCHAR2 10 Yes No Active Unique Code for the found location of a bird tag. For example rtleg; VARCHAR2 7 COLOR_CODE VARCHAR2 5 Yes No Active Color Code VARCHAR2 8 SPECIMEN_SEQ NUMBER 22 Yes No 9 0 Active Sequence generated unique identifier of a bird specimen. NUMBER 9 TAG_CODE VARCHAR2 3 No No Active Code (Domain) identifying presence, absence, applicability of banding. VARCHAR2 10 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 gov.noaa.nmfs.inport:9610 Doug Turnbull 2009-06-30T16:11:06 SysAdmin InPortAdmin 2022-08-09T17:11:03 2018-09-26 Alaska Fisheries Science Center AFSC 7600 Sand Point Way N.E., Building 4 Seattle WA 98115 USA https://www.afsc.noaa.gov 0700-1700 Pacific Time 1001 Public No 2018-09-26 1 Year 2019-09-26