53917 DEBRIEFED_AGE_SQUASH_CONCAT Entity Published / External 10657 AFSC/FMA/North Pacific Observer Debriefed Data Presentation Layer (OBSINT) Data Set Completed snapshot table for snapshot OBSINT.DEBRIEFED_AGE_SQUASH_CONCAT Data View Yes OBSINT snapshot table for snapshot OBSINT.DEBRIEFED_AGE_SQUASH_CONCAT Debriefed_age_squash_concat is a materialized view created from the data in the debriefed_age table in a summary format presenting all specimen_types sampled for a single distinct individual animal are concatenated into one column. Also there is another column for all the corresponding concatenated specimen_type_descriptions. The debriefed_age table is a bridge object between the Domestic data (pre 2008) and the ATL data (2008 onwards) As such, refinements to the structure and statistical reliability realized in the redevelopment of Norpac are lost. The use of this table is primarily for status of stocks authors who require a longitudinal view of observer data. 1 ADIPOSE_PRESENT VARCHAR2 1 No No Active Is adipose on a specimen Y, N or U. Null for non adipose specimen. As of 01/01/2014, this attribute is only used for hake data (where atl_haul.haul_purpose_code = 'HAK'). VARCHAR2 2 AGE NUMBER 22 No No 3 0 Active Age of the animal (Specimen) in years. Populated by Age and Growth Staff without system validation. NUMBER 3 BARCODE NUMBER 22 No No Active Whenever a barcode is printed on a vial (otolith) or bag (tag and bag) this attribute contains the value. See salmon_snout_barcode column for barcodes of salmon snouts (used by hake fishery observers only). NUMBER 4 SALMON_SNOUT_BARCODE NUMBER 22 No No Active Barcode for salmon snout; used by hake fishery observers only. NUMBER 5 BOTTOM_DEPTH_FATHOMS NUMBER 22 No No Active Inherited from parent haul when appropriate NULL for offloads. This attribute is null for Domestic Table age records. NUMBER 6 CRUISE NUMBER 22 No No 8 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER 7 CDQ_CODE VARCHAR2 3 No No Active Unique AlphaNumeric code representing a CDQ or research group. VARCHAR2 8 FISHING_DEPTH_FATHOMS NUMBER 22 No No Active Inherited from parent haul when appropriate NULL for offloads. This attribute is null for Domestic Table age records. NUMBER 9 GEAR NUMBER 22 No No Active Numeric value from Norpac Domestic Gear or atl_lov_gear_type that combined with the Form defines the unique identifier for a gear record. NUMBER 10 HAUL_JOIN NUMBER 22 No No Active Surrogate FK to haul if length record is so derived Composed of concatenation of cruise, permit and haul_seq. For domestic table records this is a sequence generated unique identifier for a haul. NUMBER 11 HAUL_OFFLOAD NUMBER 22 No No Active Number which is entered by the observer identifying a unique haul or offload depending on which was the ultimate data source. NUMBER 12 HAUL_OFFLOAD_DATE DATE 7 No No Active Date of offload or haul retrieval depending on whether this length frequency record was derived from an offload or a haul. DATE 13 INJURY VARCHAR2 40 No No Active Halibut injury code. VARCHAR2 14 LATDD_END NUMBER 22 No No Active Inherited from parent haul when appropriate NULL for offloads. This attribute is null for Domestic Table age records. NUMBER 15 LATDD_START NUMBER 22 No No Active Inherited from parent haul when appropriate NULL for offloads. This attribute is null for Domestic Table age records. NUMBER 16 LENGTH NUMBER 22 No No Active Inherited from atl_length or observer entered for Domestic Table age records. NUMBER 17 LENGTH_SEQ NUMBER 22 No No Active All post 2008 specimen records are derived from length records. length_seq is the FK, This attribute is null for Domestic Table age records. NUMBER 18 LONDD_END NUMBER 22 No No Active Inherited from parent haul when appropriate NULL for offloads. This attribute is null for Domestic Table age records. NUMBER 19 LONDD_START NUMBER 22 No No Active Inherited from parent haul when appropriate NULL for offloads. This attribute is null for Domestic Table age records. NUMBER 20 MATURITY_CODE VARCHAR2 2 No No Active Sexual maturity code. VARCHAR2 21 MATURITY_DESCRIPTION VARCHAR2 60 No No Active Sexual maturity code description. This attribute is null for Domestic Table age records. VARCHAR2 22 NMFS_AREA NUMBER 22 No No 3 0 Active Inherited from parent haul when appropriate NULL for offloads. This attribute is null for Domestic Table age records. NUMBER 23 PERFORMANCE NUMBER 22 No No Active Inherited from parent haul when appropriate NULL for offloads. This attribute is null for Domestic Table age records. NUMBER 24 PERMIT VARCHAR2 6 No No Active Unique Code identifying a Vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau. VARCHAR2 25 PLANT_SEQ NUMBER 22 No No 9 0 Active Sequence generated unique identifier for a processing plant. NUMBER 26 PORT_JOIN NUMBER 22 No No Active Surrogate FK to offload if length record is so derived. Composed of concatenation of cruise, permit and offload_seq. For domestic table records this is a sequence generated unique identifier for a port. NUMBER 27 SAMPLE_SYSTEM NUMBER 22 No No Active Code for sampling system employed by the observer. NUMBER 28 SEX VARCHAR2 1 No No Active Sex either inherited from length or recorded in age/atl_fish_inv_specimen if different. VARCHAR2 29 SPECIAL_PROJECT_CODES VARCHAR2 4000 No No Active No longer used. VARCHAR2 30 SPECIES NUMBER 22 No No Active Species either inherited from length or recorded in age/atl_fish_inv_specimen if different. NUMBER 31 SPECIMEN_NUMBER NUMBER 22 No No Active A specimen number is unique within a length and specimen type, user defined identifier. In the case of an otolith it is the bar coded sample identifier attached to the collection vial. NUMBER 32 SPECIMEN_TYPES VARCHAR2 4000 No No Active All Specimen_type_codes for an individual specimen concatenated in this attribute. VARCHAR2 33 SPECIMEN_TYPE_DESCRIPTIONS VARCHAR2 4000 No No Active All specimen_type_descriptions for an individual specimen concatenated in this attribute. This attribute is null for Domestic Table age records. VARCHAR2 34 T_TABLE VARCHAR2 50 No No Active Identifier of Source Table. VARCHAR2 35 VESSEL_CODE VARCHAR2 7 No No Active Alpha Numeric code from ATL_Lov_Vessel table, which identifies the vessel. VARCHAR2 36 VESSEL_SEQ NUMBER 22 No No 9 0 Active Sequence generated unique identifier for a vessel. NUMBER 37 VIABILITY VARCHAR2 1 No No Active Halibut viability code. VARCHAR2 38 WEIGHT NUMBER 22 No No Active Weight in kg of the specimen. NUMBER 39 MATURITY_WEIGHT NUMBER 22 No No Active Weight of the animal with sex organs removed. No longer used. NUMBER 40 YEAR NUMBER 22 No No Active Year extracted from haul retrieval date or offload deleivery end date. NUMBER gov.noaa.nmfs.inport:53917 Renold Narita 2018-09-25T18:41:12 SysAdmin InPortAdmin 2022-08-09T17:11:41 2018-09-25 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-25 1 Year 2019-09-25