9626 ATLW_MAMMAL_SPECIMEN Entity Published / External 7284 AFSC/FMA/North Pacific Groundfish and Halibut Observer Program, Post 2008 Fishery Statistics. Data Set Completed This entity maps to the Norpac Domestic_Mammal_Specimen Table, and records sampling information for marine mammal tissue and measurements recorded for hauls, offloads, or trips. 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 maps to the Norpac Domestic_Mammal_Specimen Table 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 MAMMAL_SPECIMEN_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier of a mammal specimen record. NUMBER 4 ANIMAL_NUMBER NUMBER 22 Yes No 3 0 Active User Entered identifier or a particular animal within a mammal interaction. This number is unique in combination with a specimen type. NUMBER 5 SPECIMEN_TYPE_SEQ NUMBER 22 Yes No 9 0 Active Foreign Key value identifying the type of speciment collected. NUMBER 6 INTERACTION_SEQ NUMBER 22 Yes No 9 0 Active Sequence within Mammal Parent record NUMBER 7 SPECIMEN_NUMBER NUMBER 22 No No 9 0 Active A specimen number is unique with a mammal record. It is auser defined identifier. NUMBER 8 SEX VARCHAR2 1 Yes No Active Sex of a mammal speciem (M)ale, (F)emale, (U)nknown or undertermined. VARCHAR2 9 VALUE VARCHAR2 10 No No Active If the Specimen Type requires a value to be entered this attribute is the data store. VARCHAR2 10 COMMENTS VARCHAR2 1000 No No Active Observer entered comments VARCHAR2 11 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 gov.noaa.nmfs.inport:9626 Doug Turnbull 2009-06-30T16:11:11 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