<?xml version="1.0" encoding="UTF-8"?>
<inport-metadata xmlns:xs="http://www.w3.org/2001/XMLSchema"
                 version="1.11"
                 source="https://www.fisheries.noaa.gov">
   <item-identification>
      <catalog-item-id>9583</catalog-item-id>
      <title>Table: FOREIGN_PRODUCT</title>
      <short-name>FOREIGN_PRODUCT</short-name>
      <catalog-item-type>Entity</catalog-item-type>
      <metadata-workflow-state ccs-id="9">Published / External</metadata-workflow-state>
      <parent-catalog-item-id>9556</parent-catalog-item-id>
      <parent-title>AFSC/FMA/North Pacific Observer Foreign Fishing</parent-title>
      <parent-catalog-item-type>Data Set</parent-catalog-item-type>
      <status>Completed</status>
      <abstract>This table provides product information for a wide range of species and products, 1980-1990.  Some information was provided by ship's personnel.  Other information was collected by observers' monitoring and weighing the products as they were being processed.  The product codes can be found in the Observer Program's collection of Manuals for Biologists Aboard Foreign Groundfish Vessels.</abstract>
      <notes>Loaded by batch 2364, 06-29-2009 18:15</notes>
   </item-identification>
   <entity-information>
      <entity-type>Data Table</entity-type>
      <active-version>Yes</active-version>
      <schema>NORPAC</schema>
      <description>This table provides product information for a wide range of species and products, 1980-1990.  Some information was provided by ship's personnel.  Other information was collected by observers' monitoring and weighing the products as they were being processed.  The product codes can be found in the Observer Program's collection of Manuals for Biologists Aboard Foreign Groundfish Vessels.</description>
   </entity-information>
   <data-attributes>
      <data-attribute cc-id="37365">
         <seq-order>1</seq-order>
         <name>CRUISE</name>
         <data-storage-type>NUMBER</data-storage-type>
         <max-length>22</max-length>
         <required>Yes</required>
         <primary-key>No</primary-key>
         <precision>4</precision>
         <scale>0</scale>
         <status>Active</status>
         <description>A unique four-digit number assigned to the observer for the length of their contract period. This number alone identifies and groups a set of observer information.</description>
         <general-data-type>NUMBER</general-data-type>
         <foreign-key-relations>NORPAC.FOREIGN_FISHING_OPERATI</foreign-key-relations>
      </data-attribute>
      <data-attribute cc-id="37375">
         <seq-order>2</seq-order>
         <name>VESSEL</name>
         <data-storage-type>VARCHAR2</data-storage-type>
         <max-length>4</max-length>
         <required>Yes</required>
         <primary-key>No</primary-key>
         <status>Active</status>
         <description>A unique, four-digit, alpha-numeric code identifying each vessel that contracts for observer coverage.  All vessel codes begin with the alpha code B, followed by a three-digit number.</description>
         <general-data-type>VARCHAR2</general-data-type>
         <foreign-key-relations>Refers to more than one entity</foreign-key-relations>
      </data-attribute>
      <data-attribute cc-id="37369">
         <seq-order>3</seq-order>
         <name>MONTH</name>
         <data-storage-type>NUMBER</data-storage-type>
         <max-length>22</max-length>
         <required>Yes</required>
         <primary-key>No</primary-key>
         <precision>2</precision>
         <scale>0</scale>
         <status>Active</status>
         <description>A two-digit number representing the month in which the haul or set gear retrieval began.  Month is part of the day's date, which is recorded on all forms and used along with haul as a cross reference between data forms to link related sets of information.</description>
         <general-data-type>NUMBER</general-data-type>
      </data-attribute>
      <data-attribute cc-id="37378">
         <seq-order>4</seq-order>
         <name>YEAR</name>
         <data-storage-type>NUMBER</data-storage-type>
         <max-length>22</max-length>
         <required>Yes</required>
         <primary-key>No</primary-key>
         <precision>4</precision>
         <scale>0</scale>
         <status>Active</status>
         <description>A four-digit number identifying the year in which the gear retrieval of the haul began.</description>
         <general-data-type>NUMBER</general-data-type>
      </data-attribute>
      <data-attribute cc-id="37368">
         <seq-order>5</seq-order>
         <name>INPFC_REGION</name>
         <data-storage-type>NUMBER</data-storage-type>
         <max-length>22</max-length>
         <required>Yes</required>
         <primary-key>No</primary-key>
         <precision>2</precision>
         <scale>0</scale>
         <status>Active</status>
         <description>A two-digit numeric code representing the International North Pacific Fisheries Commission (INPFC) area or region in which the data were collected:   50 - Bering Sea/Aleutian Islands Region;   51 - Eastern Bering Sea Area;   52 - Central Bering Sea Area;   53 - Western Bering Sea Area;   54 - Aleutian Islands Area;   55 - Donut Hole Area; 60 - Gulf of Alaska Region;   61 - Shumagin Area;   62 - Chirikof Area;   63 - Kodiak Area; 64 - Yakutat/SE Alaska Area;  67 - Vancouver Area;   70 - Washington-Oregon-California Region;   71 - Columbia Area;   72 - Eureka Area;   73 - Monterey Area.</description>
         <general-data-type>NUMBER</general-data-type>
      </data-attribute>
      <data-attribute cc-id="37374">
         <seq-order>6</seq-order>
         <name>SPECIES</name>
         <data-storage-type>NUMBER</data-storage-type>
         <max-length>22</max-length>
         <required>Yes</required>
         <primary-key>No</primary-key>
         <precision>3</precision>
         <scale>0</scale>
         <status>Active</status>
         <description>A three-digit numeric code representing a marine species.</description>
         <general-data-type>NUMBER</general-data-type>
         <foreign-key-relations>NORPAC.DOMESTIC_SPECIES</foreign-key-relations>
      </data-attribute>
      <data-attribute cc-id="37373">
         <seq-order>7</seq-order>
         <name>PRODUCT_CODE</name>
         <data-storage-type>NUMBER</data-storage-type>
         <max-length>22</max-length>
         <required>Yes</required>
         <primary-key>No</primary-key>
         <precision>2</precision>
         <scale>0</scale>
         <status>Active</status>
         <description>A two-digit numeric code identifying the type of product associated with the recovery rate.  NORPAC.FOREIGN_PRODUCT_CODE provides a description of the codes.</description>
         <general-data-type>NUMBER</general-data-type>
         <foreign-key-relations>NORPAC.FOREIGN_PRODUCT_CODE</foreign-key-relations>
      </data-attribute>
      <data-attribute cc-id="37367">
         <seq-order>8</seq-order>
         <name>H_M</name>
         <data-storage-type>VARCHAR2</data-storage-type>
         <max-length>7</max-length>
         <required>No</required>
         <primary-key>No</primary-key>
         <status>Active</status>
         <description>A one-digit alpha code to identify whether the product was obtained by processing the fish by hand (H) or by machine (M).</description>
         <general-data-type>VARCHAR2</general-data-type>
      </data-attribute>
      <data-attribute cc-id="37376">
         <seq-order>9</seq-order>
         <name>VESSEL_PERCT_RECOVERY</name>
         <data-storage-type>NUMBER</data-storage-type>
         <max-length>22</max-length>
         <required>No</required>
         <primary-key>No</primary-key>
         <precision>3</precision>
         <scale>0</scale>
         <status>Active</status>
         <description>The product recovery percentage used by vessel personnel to back-calculate to total weight.</description>
         <general-data-type>NUMBER</general-data-type>
      </data-attribute>
      <data-attribute cc-id="37377">
         <seq-order>10</seq-order>
         <name>VESSEL_UNIT_WEIGHT</name>
         <data-storage-type>NUMBER</data-storage-type>
         <max-length>22</max-length>
         <required>No</required>
         <primary-key>No</primary-key>
         <precision>6</precision>
         <scale>2</scale>
         <status>Active</status>
         <description>The weight (in kg) of the standard sized packaging of the product as reported by the vessel (before freezing or addition of water).</description>
         <general-data-type>NUMBER</general-data-type>
      </data-attribute>
      <data-attribute cc-id="37370">
         <seq-order>11</seq-order>
         <name>OBSERVER_PERCT_RECOVERY</name>
         <data-storage-type>NUMBER</data-storage-type>
         <max-length>22</max-length>
         <required>No</required>
         <primary-key>No</primary-key>
         <precision>3</precision>
         <scale>0</scale>
         <status>Active</status>
         <description>The product recovery percentage obtained by the observer by first weighing the fish before processing and then weighing the resultant product.  If two product recovery percentages exist for the same vessel, date, area, species, and product, they represent a range of percentages for the product.</description>
         <general-data-type>NUMBER</general-data-type>
      </data-attribute>
      <data-attribute cc-id="37371">
         <seq-order>12</seq-order>
         <name>OBSERVER_UNIT_WEIGHT</name>
         <data-storage-type>NUMBER</data-storage-type>
         <max-length>22</max-length>
         <required>No</required>
         <primary-key>No</primary-key>
         <precision>6</precision>
         <scale>2</scale>
         <status>Active</status>
         <description>The weight (in kg) of the standard sized packaging of the product as weighed by the observer (before freezing or addition of water).</description>
         <general-data-type>NUMBER</general-data-type>
      </data-attribute>
      <data-attribute cc-id="37366">
         <seq-order>13</seq-order>
         <name>FILENAME</name>
         <data-storage-type>VARCHAR2</data-storage-type>
         <max-length>8</max-length>
         <required>No</required>
         <primary-key>No</primary-key>
         <status>Active</status>
         <description>The original filename on the Burroughs computer system from which this data record came.</description>
         <general-data-type>VARCHAR2</general-data-type>
      </data-attribute>
      <data-attribute cc-id="37372">
         <seq-order>14</seq-order>
         <name>PK_FPRD</name>
         <data-storage-type>NUMBER</data-storage-type>
         <max-length>22</max-length>
         <required>Yes</required>
         <primary-key>Yes</primary-key>
         <precision>6</precision>
         <scale>0</scale>
         <status>Active</status>
         <description>For internal use only.</description>
         <general-data-type>NUMBER</general-data-type>
      </data-attribute>
   </data-attributes>
   <catalog-details>
      <guid>gov.noaa.nmfs.inport:9583</guid>
      <metadata-record-created-by pers-id="1162">Doug Turnbull</metadata-record-created-by>
      <metadata-record-created>2009-06-29T18:15:09</metadata-record-created>
      <metadata-record-last-modified-by pers-id="0">SysAdmin InPortAdmin</metadata-record-last-modified-by>
      <metadata-record-last-modified>2022-08-09T17:11:03</metadata-record-last-modified>
      <record-published>2016-05-18</record-published>
      <owner-organization>Alaska Fisheries Science Center</owner-organization>
      <owner-organization-acronym>AFSC</owner-organization-acronym>
      <owner-organization-address>7600 Sand Point Way N.E., Building 4</owner-organization-address>
      <owner-organization-address-city>Seattle</owner-organization-address-city>
      <owner-organization-address-state>WA</owner-organization-address-state>
      <owner-organization-address-zip>98115</owner-organization-address-zip>
      <owner-organization-address-country>USA</owner-organization-address-country>
      <owner-organization-phone/>
      <owner-organization-url>https://www.afsc.noaa.gov</owner-organization-url>
      <owner-organization-business-hours>0700-1700 Pacific Time</owner-organization-business-hours>
      <owner-organization-group-id>1001</owner-organization-group-id>
      <publication-status>Public</publication-status>
      <is-do-not-publish>No</is-do-not-publish>
      <metadata-last-review-date>2016-05-18</metadata-last-review-date>
      <metadata-review-frequency>1 Year</metadata-review-frequency>
      <metadata-next-review-date>2017-05-18</metadata-next-review-date>
   </catalog-details>
</inport-metadata>
