10657 AFSC/FMA/North Pacific Observer Debriefed Data Presentation Layer Data Set Published / External 10637 Debriefed Observer Data Interface Project In Work Observer data span more than two decades and multiple database development interations. To facilitate status of stocks authors and other users of these records, a data set separate from the OLAP was created which reformats and repackages vetted (debriefed) observer data from NORPAC into a common structure, format, and syntax. The granularity of current production data is compromised, however for the purposes of longitudinal research the data set is internally consistant, and spans the developmental boundaries. Observer data span more than two decades and multiple database development interations. To facilitate status of stocks authors and other users of these records, a data set separate from the OLAP was created which reformats and repackages vetted (debriefed) observer data from NORPAC into a common structure, format, and syntax. The granularity of current production data is compromised, however for the purposes of longitudinal research the data set is internally consistant, and spans the developmental boundaries. All of these data are collected cooperatively from private commercial fishing interests and are protected from general release by confidentiality statutes. This protects the private business interests of industry while still providing NOAA Fisheries with the detailed information necessary to effectively manage the ecosystem. The staff authorized to use these data include NOAA Fisheries' scientists and managers participating in a broad range of activities including: stock assessments, marine mammal interactions, food habits, fish age analyses, economic analyses, fishery management plan development, in-season fishery management. The data are also shared with other authorized users in the Alaska Department of Fish and Game (ADF&G) and North Pacific Fishery Management Council staff with similar responsibilities. Aggregations of observer data which protect confidentiality are periodically developed and released to the public. Observer data serve as essential building blocks for numerous public analyses, reports, and scientific documents. Our Data-Spatial Maps page allows visitors use of the aggregated observer data to create ma Theme Fisheries Fishery-Dependent Theme Fisheries Tracked Asset Theme AFSC Theme DEBRIEFED Theme DOMESTIC Theme FMA Theme GROUNDFISH Theme HAKE Theme NORPAC Theme OBSERVER Theme OBSINT Theme POLLOCK Temporal CONTINUOUS Spatial AI Spatial ALASKA Spatial BS Spatial BSAI Spatial GOA Spatial NORTH PACIFIC Stratum DEMERSAL Stratum FIXED Stratum MOBILE Stratum OCEANIC Stratum PELEGIC Fisheries Monitoring and Analysis SEATTLE WA USA Alaska Fisheries Science Center Data Set Database As Needed Table (hardcopy) Norpac (Observer) ata are transformed and loaded into the presentation layer tables as the review of those data sets (cruise, permit) is completed and observer debriefing is finalized N/A N/A N/A N/A 10658 DEBRIEFED_AGE Published / External Completed The debriefed age table was created as a successor to the debriefed age materialized view. The 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. Loaded by batch 2535, 11-09-2010 10:55 Data Table Yes OBSINT The debriefed age table was created as a successor to the debriefed age materialized view. The 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 T_TABLE VARCHAR2 20 No No Active Identifier of Source Table. VARCHAR2 2 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 3 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 4 VESSEL VARCHAR2 7 No No Active Alpha Numeric code from ATL_Lov_Vessel table, which identifies the vessel. VARCHAR2 5 GEAR NUMBER 22 No No 38 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 6 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 7 LATDD_START NUMBER 22 No No 38 Active Inherited from parent haul when appropriate NULL for offloads. This attribute is null for Domestic Table age records. NUMBER 8 LONDD_START NUMBER 22 No No 38 Active Inherited from parent haul when appropriate NULL for offloads. This attribute is null for Domestic Table age records. NUMBER 9 LATDD_END NUMBER 22 No No 38 Active Inherited from parent haul when appropriate NULL for offloads. This attribute is null for Domestic Table age records. NUMBER 10 LONDD_END NUMBER 22 No No 38 Active Inherited from parent haul when appropriate NULL for offloads. This attribute is null for Domestic Table age records. NUMBER 11 LENGTH_SEQ NUMBER 22 No No 38 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 12 PERFORMANCE NUMBER 22 No No 38 Active Inherited from parent haul when appropriate NULL for offloads. This attribute is null for Domestic Table age records. NUMBER 13 FISHING_DEPTH NUMBER 22 No No 38 Active Inherited from parent haul when appropriate NULL for offloads. This attribute is null for Domestic Table age records. NUMBER 14 BOTTOM_DEPTH NUMBER 22 No No 38 Active Inherited from parent haul when appropriate NULL for offloads. This attribute is null for Domestic Table age records. NUMBER 15 LENGTH NUMBER 22 No No 38 Active Inherited from atl_length or observer entered for Domestic Table age records. NUMBER 16 WEIGHT NUMBER 22 No No 38 Active Weight in kg of the specimen. NUMBER 17 SPECIES NUMBER 22 No No 38 Active Species either inherited from length or recorded in age/atl_fish_inv_specimen if different. NUMBER 18 SEX VARCHAR2 1 No No Active Sex either inherited from length or recorded in age/atl_fish_inv_specimen if different. VARCHAR2 19 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 20 HAUL_OFFLOAD NUMBER 22 No No 38 Active Number which is entered by the observer identifying a unique haul or offload depending on which was the ultimate data source. NUMBER 21 SPECIMEN_NUMBER NUMBER 22 No No 38 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 22 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 23 MATURITY_CODE VARCHAR2 2 No No Active Sexual maturity code. VARCHAR2 24 MATURITY_DESCRIPTION VARCHAR2 60 No No Active Sexual maturity code description. This attribute is null for Domestic Table age records. VARCHAR2 25 SPECIMEN_TYPE NUMBER 22 No No 38 Active Specimen type code. NUMBER 26 SPECIMEN_TYPE_DESCRIPTION VARCHAR2 25 No No Active Speciment type code description. This attribute is null for Domestic Table age records. VARCHAR2 27 HAUL_JOIN NUMBER 22 No No 38 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 28 PORT_JOIN NUMBER 22 No No 38 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 29 YEAR NUMBER 22 No No 38 Active Year extracted from haul retrieval date or offload deleivery end date. NUMBER 30 VIABILITY VARCHAR2 1 No No Active Halibut viability code. VARCHAR2 31 INJURY VARCHAR2 40 No No Active Halibut injury code. VARCHAR2 32 SPECIAL_PROJECT_CODE VARCHAR2 3 No No Active No longer used. VARCHAR2 33 SAMPLE_SYSTEM NUMBER 22 No No 38 Active Code for sampling system employed by the observer. NUMBER 34 BARCODE NUMBER 9 No No Active Whenever a barcode is printed on a vial (otolith) or bag (tag and bag) this attribute contains the value. INTEGER 0 - 99999999 10659 DEBRIEFED_HAUL Published / External Completed The debriefed haul table was created as a successor to the debriefed haul materialized view. The 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. Loaded by batch 2535, 11-09-2010 10:55 Data Table Yes OBSINT The debriefed haul table was created as a successor to the debriefed haul materialized view. The 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 T_TABLE VARCHAR2 8 Yes No Active Identifier of Source Table VARCHAR2 2 CRUISE NUMBER 22 Yes No 9 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 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 4 VESSEL VARCHAR2 6 No No Active Alpha Numeric code from ATL_Lov_Vessel table, which identifies the vessel. VARCHAR2 5 HAUL_SEQ NUMBER 22 No No 9 0 Active Sequence generated unique identifier for a haul record NUMBER 6 HAUL_JOIN NUMBER 22 Yes Yes 38 Active This is a uniquie identifier of a haul record composed by concatenation of cruise, permit and haul_seq. For domestic table records this is a sequence generated unique identifier for a haul. NUMBER 7 TRIP_SEQ NUMBER 22 No No 9 0 Active Sequence generated unique identifier for a trip as defined in ATL_fma_trip. NUMBER 8 TRIP_JOIN NUMBER 22 No No 38 Active Surrogate FK to haul, It is a unique identifier of a trip record created by concatenating cruise, permit, and trip_seq (TO_NUMBER ( t.cruise||LPAD (t.permit, 6,'0')||LPAD (t.trip_seq, 9, '0')) AS trip_join) NUMBER OBSINT.DEBRIEFED_TRIP 9 HAUL_DATE DATE 7 No No Active Date of haul retrieval. DATE 10 HAUL NUMBER 22 No No 6 0 Active Number which is entered by the observer identifying a unique haul within a trip. NUMBER 11 HAUL_PURPOSE_CODE VARCHAR2 3 No No Active Haul data may be utilized for catch accounting, stock assessment, or for various special projects. This field is entered by the observer and not validated by ATLAS. Validation is performed when loaded into the production NORPAC data set. VARCHAR2 12 GEAR_TYPE NUMBER 22 No No 38 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 13 PERFORMANCE NUMBER 22 No No 38 Active Unique performance code for a gear type. see ATL_LOV_gear_perfomrance. NUMBER 14 VESSEL_TYPE NUMBER 22 No No 38 Active Unique identifier of a vessel type, see ATL_LOV_vessel_type NUMBER 15 DEPLOYMENT_DATE DATE 7 No No Active Date and time of gear deployment DATE 16 DEPLOY_LATITUDE NUMBER 22 No No 38 Active Gear deployment position. NUMBER 17 DEPLOY_LONGITUDE NUMBER 22 No No 38 Active Gear deployment position NUMBER 18 DEPLOY_LONGITUDE_CONVERTED NUMBER 22 No No 38 Active The conversion of longitude is required of values to the east of the 180th meridian. The configuration within Oracle Spatial uses a 360 degree globe - 179 E must therefore be submitted as 181. The calling program must, as in the conversion to decimal degrees submit latitude to the east of the 180th meridian as a negative number. NUMBER 19 DEPLOY_LONGITUDE_SECONDS NUMBER 22 No No 38 Active Gear deployment position. NUMBER 20 DEPLOY_LATITUDE_SECONDS NUMBER 22 No No 38 Active Gear deployment position. NUMBER 21 DEPLOY_E_W VARCHAR2 1 No No Active Gear deployment position. VARCHAR2 22 FISHING_DEPTH_FATHOMS NUMBER 22 No No 38 Active Average fishing depth recorded by the observer from the vessel log. NUMBER 23 BOTTOM_DEPTH_FATHOMS NUMBER 22 No No 38 Active Average bottom depth recorded by the observer from the vessel log. NUMBER 24 RETRIEVAL_DATE DATE 7 No No Active Date and time of gear retrieval. DATE 25 DURATION_IN_MIN NUMBER 22 No No 38 Active Duration of a haul calculated in minutes. NUMBER 26 LOCATION VARCHAR2 1 No No Active Identifies whether the information in a haul is based on retrieval or delivery (as in a mother ship). VARCHAR2 27 RETRV_LATITUDE NUMBER 22 No No 38 Active Retrieval location. NUMBER 28 RETRV_LONGITUDE NUMBER 22 No No 38 Active Retrieval location. NUMBER 29 RETRV_LONGITUDE_SECONDS NUMBER 22 No No 38 Active Gear retrieval position. NUMBER 30 RETRV_LATITUDE_SECONDS NUMBER 22 No No 38 Active Gear retrieval position. NUMBER 31 RETRV_LONGITUDE_CONVERTED NUMBER 22 No No 38 Active Retrieval location. The conversion of longitude is required of values to the east of the 180th meridian. The configuration within Oracle Spatial uses a 360 degree globe - 179 E must therefore be submitted as 181. The calling program must, as in the conversion to decimal degrees submit latitude to the east of the 180th meridian as a negative number. NUMBER 32 RETRV_E_W VARCHAR2 1 No No Active Retrieval location. VARCHAR2 33 GENERIC_AREA NUMBER 22 No No 38 Active This attirbute is no longer collected, but is retained for the domestic data set. NUMBER 34 NMFS_AREA NUMBER 22 No No 38 Active This attribute is computed using the MDSYS.SDO_GEOMETRY package and an ESRI shape file. NUMBER 35 COBLZ_AREA VARCHAR2 1 No No Active This attribute is computed using the MDSYS.SDO_GEOMETRY package and an ESRI shape file. VARCHAR2 36 VESSEL_ESTIMATE NUMBER 22 No No 6 2 Active Total catch weight in metric tons as recorded in the vessel log. NUMBER 37 OFFICIAL_TOTAL_CATCH NUMBER 22 No No 38 Active Total catch weight as estimated by the observer in kgs and converted to MT for this presentation. NUMBER 38 OBSERVER_ESTIMATE NUMBER 22 No No 38 Active Total catch weight as estimated by the observer in kgs and converted to MT for this presentation. NUMBER 39 OBSERVER_ESTIMATE_METHOD VARCHAR2 1 No No Active Method used to determine the observer estimated catch. VARCHAR2 40 DENSITY NUMBER 22 No No 38 Active Density used by the observer to determine the total catch weights. Recorded in kgs per m3. NUMBER 41 CATCHER_BOAT_ADFG NUMBER 22 No No 38 Active If this haul was delivered to a mothership or catcher processor, this attibute records the adfg negistration number of that vessel. NUMBER 42 IFQ VARCHAR2 1 No No Active Flag which identifies whether fishing is on an IFQ quota with the subsequent application of IFQ rules. VARCHAR2 43 CDQ_CODE VARCHAR2 3 No No Active Unique AlphaNumeric code representing a CDQ or research group. VARCHAR2 44 SKATES_IN_SET NUMBER 22 No No 38 Active Number of skates for longline fishing. NUMBER 45 HOOKS_PER_SKATE NUMBER 22 No No 38 Active Number of hooks per skate for longline fishing usually calculated as the average number of hooks per segment from the atl_haul_hook_count table. NUMBER 46 TOTAL_HOOKS_POTS NUMBER 22 No No 38 Active Total number of hooks deployed for this haul, usually calculated as the average number of hooks per segment from the atl_haul_hook_count table * the number of skates in set. Or in the case of a pot fishery the total number of pots deployed in a haul. NUMBER 47 HAUL_SAMPLED_BY NUMBER 22 No No 38 Active Identifies where a haul is sampled by an observer and in some cases by which observer. The observer of a haul is not necessarily the primary observer recorded for a cruise. NUMBER 48 RANDOM_SAMPLE_TABLE VARCHAR2 1 No No Active Random Sample Reference Table code reference. VARCHAR2 49 RANDOM_BREAK_TABLE VARCHAR2 1 No No Active Random Break Table identifier Currently limted to Y (es) or N(o). VARCHAR2 50 MM_PERCENT_MONITORED NUMBER 22 No No 3 0 Active Percentage of time for this haul where marine mammal monitoring occured. For fixed gear deployments the valid values are anywhere in the range. For mobile gear deployments the values may be either 0 or 100. NUMBER 51 BIRD_DETERRENCE VARCHAR2 2 No No Active Deterrence code from NORPAC bird or mammal deterance tables. VARCHAR2 52 BIRD_VERIFICATION VARCHAR2 1 No No Active This attirbute is no longer collected, but is retained from the domestic data set. See the atl_bird _module deployed in 2010 for complete observer seabird data. VARCHAR2 53 PROCESSOR VARCHAR2 6 No No Active Processor is computed by atl_utilities, and returns the shore plant processor code for catcher vessels who have an offload, and the processor permit for catcher processors and motherships. VARCHAR2 54 FISHING_START_DATE DATE 7 No No Active Fishing start date is defined as the first haul deployment of a trip. If the deployment date is null due to unverifiable observer data then the trip start date is used; if null the default is a mandatory value haul retrieval date. DATE 55 DATE_OF_ENTRY DATE 7 No No Active Date of entry is now (2010) recorded when a haul is loaded into the Norpac data set. In the case that that value is null then it is computed from the latest load date recorded in atl_record_status.'; DATE 56 YEAR NUMBER 22 No No 38 Active Year is extracted from the haul rettrv_date_time field. NUMBER 57 LATDD_END NUMBER 22 No No 38 Active Latitude decimal degrees is computed from the retrieval latitude. NUMBER 58 LONDD_END NUMBER 22 No No 38 Active Longitude decimal degrees is computed from the retrieval longitude. NUMBER 59 LATDD_START NUMBER 22 No No 38 Active Latitude decimal degrees is computed from the deployment latitude. NUMBER 60 LONDD_START NUMBER 22 No No 38 Active Longitude decimal degrees is computed from the deployment longitude. NUMBER 61 SEABIRD_SAMPLE_TYPE VARCHAR2 1 No No Active This attirbute is no longer collected, but is retained from the domestic data set. See the atl_bird _module deployed in 2010 for complete observer seabird data. VARCHAR2 62 ATLAS_VERSION NUMBER 22 No No 38 Active If this haul data was transmitted from the field. This attribute records the version of the software used. NUMBER 63 OBSVR_EST_DISCARDS NUMBER 10 No No 2 Active Observer estimate of total discards in kgs. 10660 DEBRIEFED_HAUL_HOOK_COUNT Published / External Completed This table contains a flattened view of longline hook count data. Observers are required to determine the number and spacing of hooks used in fishing operations. These counts are assembled into deployable sets of hooks and assigned by the observer to a haul. Average hook counts and spacing is insufficient as mixed gear is allowed (sablefish and halobut for example). So this presentation layer provides detail information for analysis. Loaded by batch 2535, 11-09-2010 10:55 Data Table Yes OBSINT This table contains a flattened view of longline hook count data. Observers are required to determine the number and spacing of hooks used in fishing operations. These counts are assembled into deployable sets of hooks and assigned by the observer to a haul. Average hook counts and spacing is insufficient as mixed gear is allowed (sablefish and halobut for example). So this presentation layer provides detail information for analysis. 1 T_TABLE VARCHAR2 3 No No Active Source Table VARCHAR2 2 CRUISE NUMBER 22 Yes No 9 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 No Active Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau VARCHAR2 4 HAUL_SEQ NUMBER 22 Yes No 9 0 Active Sequence generated unique identifier for a haul record NUMBER 5 HAUL_JOIN NUMBER 22 Yes No 38 Active This is a uniquie identifier of a haul record composed by concatenation of cruise, permit and haul_seq. For domestic table records this is a sequence generated unique identifier for a haul. NUMBER OBSINT.DEBRIEFED_HAUL 6 HAUL_NUMBER NUMBER 22 Yes No 5 0 Active Unique haul for an observer vessel cruise, defaulted to an incremented sequence by the GUI. May be entered and defined by the observer. NUMBER 7 COLLECTION_NUMBER NUMBER 22 Yes No 5 0 Active User Defined Hook Count Set number unique for a cruise permit. NUMBER 8 SEGMENT_NUMBER NUMBER 22 No No 3 0 Active This attribute represents a user defined integer identifying a unit of line for counting and spacing hooks. It must be unique within a hook_count_set. NUMBER 9 NUMBER_OF_HOOKS NUMBER 22 Yes No 8 0 Active Number of hooks as determined by the observer for this segment, contained within a counted set. NUMBER 10 HOOK_SPACING_IN_CM NUMBER 22 No No 4 0 Active Spacing between hooks on a segment. This value is optional for any specific segment except the first set of spacing-count on a trip NUMBER 11 VESSEL VARCHAR2 8 No No Active Vessel code from the ATL_LOV vessel table. VARCHAR2 10661 DEBRIEFED_LENGTH Published / External Completed The debriefed length table was created as a successor to the debriefed length materialized view. The 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. Loaded by batch 2535, 11-09-2010 10:55 Data Table Yes OBSINT The debriefed length table was created as a successor to the debriefed length materialized view. The 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 T_TABLE VARCHAR2 18 No No Active Identifier of Source Table. VARCHAR2 2 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 3 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 4 HAUL_JOIN NUMBER 22 No No 38 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 OBSINT.DEBRIEFED_HAUL 5 PORT_JOIN NUMBER 22 No No 38 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 6 LENGTH_SEQ NUMBER 22 No No 38 Active Sequence generated unique identifier of an atl_length. NUMBER 7 VESSEL VARCHAR2 7 No No Active Alpha Numeric code from ATL_Lov_Vessel table, which identifies the vessel. VARCHAR2 8 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 9 HAUL_OFFLOAD NUMBER 22 No No 38 Active Number which is entered by the observer identifying a unique haul or offload depending on which was the ultimate data source. NUMBER 10 GEAR NUMBER 22 No No 38 Active Gear type code. NUMBER 11 NMFS_AREA NUMBER 22 No No 3 0 Active Inherited from parent haul when appropriate NULL for offloads and domestic table data. NUMBER 12 LATDD_START NUMBER 22 No No 38 Active Inherited from parent haul when appropriate NULL for offloads and domestic table data. NUMBER 13 LONDD_START NUMBER 22 No No 38 Active Inherited from parent haul when appropriate NULL for offloads and domestic table data. NUMBER 14 LATDD_END NUMBER 22 No No 38 Active Inherited from parent haul when appropriate NULL for offloads and domestic table data. NUMBER 15 LONDD_END NUMBER 22 No No 38 Active Inherited from parent haul when appropriate NULL for offloads and domestic table data. NUMBER 16 SPECIES NUMBER 22 No No 38 Active Species either inherited from species composition or recorded in length if different, or if the length record is a child of haul or offload. NUMBER 17 SEX VARCHAR2 1 No No Active Sex of length frequency animals VARCHAR2 18 LENGTH NUMBER 22 No No 38 Active Measured length of organism. NUMBER 19 FREQUENCY NUMBER 22 No No 38 Active Number of animals measured. NUMBER 20 EGGS VARCHAR2 1 No No Active Indicator of presence or absence of eggs. VARCHAR2 21 YEAR NUMBER 22 No No 38 Active Year extracted from haul retrieval date or offload deleivery end date NUMBER 22 VIABILITY VARCHAR2 1 No No Active Halibut viability code. VARCHAR2 23 INJURY VARCHAR2 40 No No Active Halibut injury code. VARCHAR2 24 SAMPLE_SYSTEM NUMBER 22 No No 38 Active Code for sampling system employed by the observer. NUMBER 25 VESSEL_TYPE NUMBER 2 No No Active A one-digit numeric code that indicates whether the vessel processes fish or delivers it to a processing plant where: 1 = a catcher processor vessel, 2 = a mothership or a ship that receives unsorted codends from other vessels, 3 = a catcher only vessel that delivers unprocessed fish to a shoreside or floating plant or vessel, 4 = a mothership that receives sorted codends, 5 = a vessel that sells the majority of their catch over the side to other fishing vessels who will utilize the fish for bait, 6 = vessels that discard all catch from a haul. Would be used for codend dumping of an entire haul. 26 GEAR_PERFORMANCE NUMBER 2 No No Active Unique performance code for a gear type. FK to atl_lov_gear_performance 10662 DEBRIEFED_SPCOMP Published / External Completed This table contains species composition data that bridges the gap between the domestic data (pre 2008) and current data collection protocols (post 2008). The old system did not provide for discrete and repteated sampling of an observer haul. To provide this longitudinal view that newer feature has been flattened and the presentation mirrors the domestic model. Loaded by batch 2535, 11-09-2010 10:55 Data Table Yes OBSINT This table contains species composition data that bridges the gap between the domestic data (pre 2008) and current data collection protocols (post 2008). The old system did not provide for discrete and repteated sampling of an observer haul. To provide this longitudinal view that newer feature has been flattened and the presentation mirrors the domestic model. 1 T_TABLE VARCHAR2 8 Yes No Active Identifier of Source Table VARCHAR2 2 CRUISE NUMBER 22 Yes No 9 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 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 4 HAUL_SEQ NUMBER 22 No No 9 0 Active Sequence generated unique identifier of an atl_haul record. NUMBER 5 HAUL_JOIN NUMBER 22 Yes No 38 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 OBSINT.DEBRIEFED_HAUL 6 VESSEL VARCHAR2 6 Yes No Active Alpha Numeric code from ATL_Lov_Vessel table, which identifies the vessel VARCHAR2 7 HAUL_DATE DATE 7 No No Active Date of haul retrieval. DATE 8 HAUL NUMBER 22 No No 6 0 Active Number which is entered by the observer identifying a unique haul within a trip. NUMBER 9 SEX VARCHAR2 1 No No Active Sex if so identified. VARCHAR2 10 SPECIES NUMBER 22 Yes No 4 0 Active Unique identifier for a species imported from Norpac NUMBER 11 SPECIES_NAME VARCHAR2 60 No No Active Common Name for a species imported from Norpac VARCHAR2 12 SAMPLE_TYPE VARCHAR2 1 No No Active Computed for atl_data - this value was assigned by observers prior to 2008 and reflects the fact that samples were not identified except as within a haul record. VARCHAR2 13 SAMPLE_NUMBER NUMBER 22 No No 6 0 Active Sum of the count of a species for a haul NUMBER 14 SAMPLE_SIZE NUMBER 22 No No 9 0 Active Sum of all parent samples recorded for a haul NUMBER 15 SAMPLE_WEIGHT NUMBER 22 No No 10 2 Active Sum of the weights of a species for a haul NUMBER 16 EXTRAPOLATED_WEIGHT NUMBER 22 No No 38 Active Weight in kilograms of a species extrapolated to the haul. This algorithm differs by gear type. NUMBER 17 EXTRAPOLATED_NUMBER NUMBER 22 No No 38 Active Number of a species extrapolated to the haul. This algorithm differs by gear type. NUMBER 18 PERCENT_RETAINED NUMBER 22 No No 3 0 Active Percent of this species that was retained from the total catch. NUMBER 19 YEAR NUMBER 22 No No 4 0 Active Year extracted from haul retrieval date NUMBER 20 DATE_OF_ENTRY DATE 7 No No Active Computed value for date of entry from haul - has little meaning. DATE 10663 DEBRIEFED_TRIP Published / External Completed The debriefed trip table was created as a successor to the debriefed haul materialized view. As vessel trip information was rolled into the haul objects of the Domestic data set, the values recorded here represent the notion of a trip as defined in the ATL data (2008 onwards) This definition may be defined as "cast off - tie up". Any movement of a vessel is defined as a trip regardless of fishing activity. The use of this table is primarily for status of stocks authors who require a longitudinal view of observer data. Loaded by batch 2535, 11-09-2010 10:55 Data Table Yes OBSINT The debriefed trip table was created as a successor to the debriefed haul materialized view. As vessel trip information was rolled into the haul objects of the Domestic data set, the values recorded here represent the notion of a trip as defined in the ATL data (2008 onwards) This definition may be defined as "cast off - tie up". Any movement of a vessel is defined as a trip regardless of fishing activity. The use of this table is primarily for status of stocks authors who require a longitudinal view of observer data. 1 T_TABLE CHAR 3 No No Active Identifier of Source Table CHAR 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 TRIP_NUMBER NUMBER 22 Yes No 4 0 Active Number which is entered by the observer which must be unique within a cruise - vessel combination. NUMBER 5 TRIP_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier for a trip as defined in ATL_fma_trip. NUMBER 6 TRIP_JOIN NUMBER 22 Yes No 38 Active Unique identifier of a trip record created by concatenating cruise, permit, and trip_seq. NUMBER 7 VESSEL_CODE VARCHAR2 8 No No Active Alpha Numeric code from ATL_Lov_Vessel table, which identifies the vessel VARCHAR2 8 VESSEL_NAME VARCHAR2 50 No No Active Name of Vessel from ATL_lov_vessel VARCHAR2 9 ADFG_NUMBER VARCHAR2 6 No No Active ADFG permit number VARCHAR2 10 CG_NUMBER NUMBER 22 No No 7 0 Active USCG registration number NUMBER 11 EMBARKED_PORT NUMBER 22 No No 38 Active User defined unique identifier of a port currently limited to 1 - 12 NUMBER 12 DISEMBARKED_PORT NUMBER 22 No No 38 Active User defined unique identifier of a port currently limited to 1 - 12 NUMBER 13 CREW_SIZE NUMBER 22 No No 38 Active Number of personnel on the vessel. NUMBER 14 DID_FISHING_OCCUR_FLAG VARCHAR2 1 Yes No Active Idetifies whether fishing took place or not. VARCHAR2 15 FISH_IN_HOLD_AT_START_FLAG VARCHAR2 1 Yes No Active Identifies whether there were fish present in the hold at the start of a fishing trip. VARCHAR2 16 TRIP_START DATE 7 No No Active Date of embarkation. DATE 17 TRIP_END DATE 7 No No Active Date of landing, tying up to a mothership, transfer of fish between codends or other interaction signifying the ending of a trip. DATE 18 YEAR NUMBER 22 No No 38 Active Current Year extracted from trip start date. NUMBER 19 TRIP_START_LAT_DEG NUMBER 22 No No 2 0 Active Latitude of embarkation in degrees NUMBER 20 TRIP_START_LAT_MIN NUMBER 22 No No 2 0 Active Latitude of embarkation in minutes. NUMBER 21 TRIP_START_LAT_SEC NUMBER 22 No No 2 0 Active Latitude of embarkation in seconds. NUMBER 22 TRIP_START_LONG_DEG NUMBER 22 No No 3 0 Active Longitude of embarkation in degrees. NUMBER 23 TRIP_START_LONG_MIN NUMBER 22 No No 2 0 Active Longitude of embarkation in minutes. NUMBER 24 TRIP_START_LONG_SEC NUMBER 22 No No 2 0 Active Longitude of embarkation in seconds. NUMBER 25 TRIP_START_LONG_EW VARCHAR2 1 No No Active East West longitude identifier for Embarkation. VARCHAR2 26 TRIP_END_LAT_DEG NUMBER 22 No No 2 0 Active Latitude of disembarkation in degrees, if not a defined port. NUMBER 27 TRIP_END_LAT_MIN NUMBER 22 No No 2 0 Active Latitude of disembarkation in minutes, if not a defined port. NUMBER 28 TRIP_END_LAT_SEC NUMBER 22 No No 2 0 Active Latitude of disembarkation in seconds, if not a defined port. NUMBER 29 TRIP_END_LONG_DEG NUMBER 22 No No 3 0 Active Longitude of disembarkation in degrees if not a defined port. NUMBER 30 TRIP_END_LONG_MIN NUMBER 22 No No 2 0 Active Longitude of disembarkation in minutes if not a defined port. NUMBER 31 TRIP_END_LONG_SEC NUMBER 22 No No 2 0 Active Longitude of disembarkation in seconds if not a defined port. NUMBER 32 TRIP_END_LONG_EW VARCHAR2 1 No No Active East (Western Hemisphere) West (Eastern Hemisphere) Longitude of disembarkation. VARCHAR2 33 NON_FISHING_DATE DATE 7 No No Active Date where no fishing activity occured, This value is denormalized down from the cruise vessel/cruise plant level. DATE 34 NO_FISH_LAT_DEG NUMBER 22 No No 2 0 Active Vessel position at noon of the day where no fishing occurred' NUMBER 35 NO_FISH_LAT_MIN NUMBER 22 No No 2 0 Active Vessel position at noon of the day where no fishing occurred' NUMBER 36 NO_FISH_LAT_SEC NUMBER 22 No No 2 0 Active Vessel position at noon of the day where no fishing occurred. NUMBER 37 NO_FISH_LONG_DEG NUMBER 22 No No 3 0 Active Vessel position at noon of the day where no fishing occurred. NUMBER 38 NO_FISH_LONG_MIN NUMBER 22 No No 2 0 Active Vessel position at noon of the day where no fishing occurred. NUMBER 39 NO_FISH_LONG_SEC NUMBER 22 No No 2 0 Active Vessel position at noon of the day where no fishing occurred. NUMBER 40 NO_FISH_LONG_EW VARCHAR2 1 No No Active Vessel position at noon of the day where no fishing occurred. VARCHAR2 41 FISHING_HOURS_LOST NUMBER 22 No No 3 0 Active Fishing time lost is a child value of a fma_trip, and may result in duplicate trip records. NUMBER 42 TIME_LOST_REASON VARCHAR2 50 No No Active The reason identified for lost fishing time. This value is prescribed and not editable. VARCHAR2 22441 DEBRIEFED_OFFLOAD Published / External In Work This entity represents the offload of a vessel which is observed by the observer assigned to the processing plant. The data comes from ATL_Offload, and does not include offloads recorded by vessel observers. Data Table debriefed_haul obsint This entity represents the offload of a vessel which is observed by the observer assigned to the processing plant. The data comes from ATL_Offload, and does not include offloads recorded by vessel observers. 1 T_TABLE varchar2 20 Yes No Active Identifier of Source Table 2 OFFLOAD_JOIN number 20 Yes No Active Surrogate FK to offload if salmon record is so derived Composed of concatenation of cruise, permit and offloadl_seq. 3 DELIVERY_VESSEL_ADFG varchar2 6 No No Active ADFG number which may be entered by the plant observer without validation, this value is not internally validated at the time of entry. 4 CDQ_CODE varchar2 3 No No Active Unique AlphaNumeric code representing a CDQ or research group 5 PGM_CODE varchar2 8 No No Active Unique Identifier of a valid catcher vessel landing management program. 6 LANDING_REPORT_ID number 10 No No Active The region uses the landing report id off the electronic fish ticket as a join column for the catch accounting system. The value is printed on the lower quadrant of every ER fish ticket. Landing_Report_ID is unique to an offload. 7 OFFLOAD_SEQ number 9 No No Active Sequence generated unique identifier for an offload record 8 CRUISE number 9 No No Active Sequence generated by Norpac and supplied to the observer as an unique identifier for a processing plant observer cruise record 9 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 10 OFFLOAD_NUMBER NUMBER 9 No No Active Unique offload for an observer cruise entered by the observer. The number must be unique within a cruise/permit combination. 11 PLANT_SEQ NUMBER 9 No No Active Sequence generated unique identifier for a processing plant. 12 PLANT_CODE VARCHAR2 4 No No Active VessPlnt code from old NORPAC system plus new plants recorded in ATL_LOV_Plant. This code may ultimately be retired, but is essential to the transitional ETL from Atlas to Inseason and Domestic. 13 PLANT_NAME VARCHAR2 50 No No Active 14 GEAR_TYPE_CODE NUMBER 3 No No Active Numeric value from Norpac Domestic Gear that combined with the Form defines the unique identifier for a gear record 15 NMFS_AREA VARCHAR2 3 No No Active NMFS Reporting Area 16 DELIVERED_WEIGHT_IN_KG NUMBER 10 No No 10 3 Active Identifies the total weight of all species delivered recorded in kilograms or lbs. 17 TOTAL_POLLOCK_WEIGHT_IN_KG NUMBER 10 No No 10 3 Active Identifies the total weight of pollock delivered recorded in kilograms or lbs. 18 DELIVERY_END_DATE DATE 6 No No Active Date the delivery was complete. 19 LAST_MODIFIED_DATE DATE 6 No No Active Everytime an offload record from the production schema is processed the the obsint.load_DEBRIEFED_offload the processing datetime is recorded here. This does not necessarily mean the DEBRIEFED offload record was modified as the program processes every offload within a cruise permit when initiated. 20 FISHING_START_DATE DATE 6 No No Active Fishing start date is defined as the first haul deployment of a trip. If the deployment date is null due to unverifiable observer data then the trip start date is used; if null the default is a mandatory value haul retrieval date. 21 OFFLOAD_HASH VARCHAR2 32 No No Active The offload hash is utilized by AKRO to identify changes to an offload record. The hash is created every time that a record is created or updated. Only critical data columns are referenced and change is denoted by a change in the hash value. 22 SALMON_HASH VARCHAR2 32 No No Active The salmon hash is utilized by AKRO to identify changes to a salmon retention record. The hash is created every time that a record is created or updated. Only critical data columns are referenced and change is denoted by a change in the hash value. 53917 DEBRIEFED_AGE_SQUASH_CONCAT Published / External 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 53918 DEBRIEFED_AGE_SQUASH_SP_TYPE Published / External Completed snapshot table for snapshot OBSINT.DEBRIEFED_AGE_SQUASH_SP_TYPE Data View Yes OBSINT snapshot table for snapshot OBSINT.DEBRIEFED_AGE_SQUASH_SP_TYPE Debriefed_age_sp_type is a materialized view created from the data in the debriefed_age table in a summary format presenting all specimen_types and specimen_type_descriptions in their own columns, with each row representing a distinct individual animal. Each specimen_type taken is denoted by a "Y" in its own column. The column is null for all specimen types not taken. 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. Does not include the salmon snout barcode, used only by hake fishery observers; see separate salmon_snout_barcode column for this data. NUMBER 4 SALMON_SNOUT_BARCODE NUMBER 22 No No Active Salmon snout barcode. Barcode for salmon snout only used by Hake fishery observers. 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 TYPE_1_OTOLITH CHAR 1 No No Active Specimen type 1 for otolith is denoted by a "Y" if taken; null if not taken. CHAR 33 TYPE_2_SCALE CHAR 1 No No Active Specimen type 2 for scale is denoted by a "Y" if taken; null if not taken. CHAR 34 TYPE_3_SEX_LENGTH_WEIGHT CHAR 1 No No Active Specimen type 3 for sex_length_weight is denoted by a "Y" if taken; null if not taken. CHAR 35 TYPE_4_FIN_CLIPS CHAR 1 No No Active Specimen type 4 for fin_clips is denoted by a "Y" if taken; null if not taken. CHAR 36 TYPE_5_VERTEBRAE CHAR 1 No No Active Specimen type 5 for vertebrae is denoted by a "Y" if taken; null if not taken. CHAR 37 TYPE_6_SPINES CHAR 1 No No Active Specimen type 6 for spines is denoted by a "Y" if taken; null if not taken. CHAR 38 TYPE_7_MATURITY_SCAN CHAR 1 No No Active Specimen type 7 for maturity scan is denoted by a "Y" if taken; null if not taken. CHAR 39 TYPE_8_MATURITY CHAR 1 No No Active Specimen type 8 for maturity is denoted by a "Y" if taken; null if not taken. CHAR 40 TYPE_9_STOMACHS CHAR 1 No No Active Specimen type 9 for stomachs is denoted by a "Y" if stomach samples were taken; null if not taken. CHAR 41 TYPE_10_ISOTOPES CHAR 1 No No Active Specimen type 10 for isotopes is denoted by a "Y" if taken; null if not taken. CHAR 42 TYPE_11_OTHER_TISSUE CHAR 1 No No Active Specimen type 11 for other tissue is denoted by a "Y" if taken; null if not taken. CHAR 43 TYPE_12_SNOUT CHAR 1 No No Active Specimen type 12 for snout is denoted by a "Y" if taken; null if not taken. CHAR 44 TYPE_13_ADIPOSE_PRESENT CHAR 1 No No Active Specimen type 13 for adipose present is denoted by a "Y" if taken; null if not taken. CHAR 45 T_TABLE VARCHAR2 50 No No Active Identifier of Source Table. VARCHAR2 46 VESSEL_CODE VARCHAR2 7 No No Active Alpha Numeric code from ATL_Lov_Vessel table, which identifies the vessel. VARCHAR2 47 VESSEL_SEQ NUMBER 22 No No 9 0 Active Sequence generated unique identifier for a vessel. NUMBER 48 VIABILITY VARCHAR2 1 No No Active Halibut viability code. VARCHAR2 49 WEIGHT NUMBER 22 No No Active Weight in kg of the specimen. NUMBER 50 MATURITY_WEIGHT NUMBER 22 No No Active Weight of the animal with sex organs removed. No longer used. NUMBER 51 YEAR NUMBER 22 No No Active Year extracted from haul retrieval date or offload deleivery end date. NUMBER Data Steward 2025 Person Thompson, Lisa lisa.thompson@noaa.gov 7600 Sand Point Way NE Seattle WA 98115-6349 USA 206-526-4229 Distributor 2008 Person Campbell, Glenn glenn.campbell@noaa.gov Email Metadata Contact 2008-01-01 Person Campbell, Glenn glenn.campbell@noaa.gov Point of Contact 2008 Person Campbell, Glenn glenn.campbell@noaa.gov Email Publisher 2009 Person Campbell, Glenn glenn.campbell@noaa.gov Publication Date -180 -125 65 35 Observer data in this dataset includes all groundfish in Federally Managed Alaskan EEZ waters as well as Hake activity delivered to motherships off Washington, Oregon, and California. Continuing 1986 Promoted to Production Winter 2010 Confidential All unagregated observer data is confidental to the vessel and or plant from which the fishery activities were observed. Aggredated data is provided to the public by AKFIN and PACFIN. Access to confidential data is provided to researchers who have an approved confidentiality agreement on file with FMA divsion. http://www.akfin.org/ http://pacfin.psmfc.org/ All unagregated observer data is confidental to the vessel and or plant from which the fishery activities were observed. Aggredated data is provided to the public by AKFIN and PACFIN. These data are intended for use by status of stocks authors and other researchers who require a longitudinal view of observer data. Records derived from the production database after 2007 have been modified to afford a presentation layer that spans the entire domestic observer program. None None https://www.afsc.noaa.gov/FMA/downloads/effort.zip effort Aggregated effort data download. zip Zip https://www.afsc.noaa.gov/FMA/downloads/flatfish.zip flatfish Aggregated catch and effort data download for flatfish. zip Zip https://www.afsc.noaa.gov/FMA/downloads/invertebrates.zip invertebrates Aggregated catch data download for invertebrates. https://www.afsc.noaa.gov/FMA/downloads/mostfish.zip mostfish Aggregated catch data download for fish species other than rockfish and flatfish. zip Zip https://www.afsc.noaa.gov/FMA/downloads/rockfish.zip rockfish Aggregated catch and effort data download for rockfish. http://www.afsc.noaa.gov/FMA/downloads/effort.zip zip Zip http://pacfin.psmfc.org/ Public source for West Coast of the United States groundfish statistics. http://www.akfin.org/ Public source for Alaska Regional groundfish statistics. https://www.afsc.noaa.gov/FMA/downloads/rockfish.zip Online Resource Other data download available at the following urls: http://www.afsc.noaa.gov/FMA/downloads/mostfish.zip http://www.afsc.noaa.gov/FMA/downloads/invertebrates.zip http://www.afsc.noaa.gov/FMA/downloads/flatfish.zip http://www.afsc.noaa.gov/FMA/downloads/effort.zip Data resides at the Alaska Fisheries Science Center OFIS division server farm on an Instance of an Oracle relational database. These data are merged data sets reporting observer data from both prior to the observer redevelopment project and after the new model went live in December of 2007. Because the granularity of the data changed at the development boundary, these data may have lost some of the richness of the newer data model. Some denormalization of post 2007 data has occurred. Any bias is inherited from the source observer data. These data are recomputed whenever the underlying data is changed. The error and debriefing QA/QC process for source data applies. Yes Unknown Yes Yes N/A N/A No Archiving Intended N/a RAID 5 Architecture, Tape back up and off site storage. Raw observer data is denormalized and flattened for analytical users. NORPAC Organization Fisheries Monitoring and Analysis, FMA 2015-10-15 Continuing 2008 22441 Entity 10658 Entity 10659 Entity 10660 Entity 10661 Entity 10662 Entity 10663 Entity 53917 Entity 53918 Entity gov.noaa.nmfs.inport:10657 Doug Turnbull 2010-11-09T10:41:02 Lisa Peterson 2025-09-23T14:04:29 2016-05-18 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 No 2016-05-18 1 Year 2017-05-18