<?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>33323</catalog-item-id>
      <title>View: OBTRQ</title>
      <short-name>OBTRQ</short-name>
      <catalog-item-type>Entity</catalog-item-type>
      <metadata-workflow-state ccs-id="9">Published / External</metadata-workflow-state>
      <parent-catalog-item-id>24111</parent-catalog-item-id>
      <parent-title>Observer and At Sea Monitor Database (OBDBS)</parent-title>
      <parent-catalog-item-type>Data Set</parent-catalog-item-type>
      <status>Completed</status>
      <abstract>Observer Trip-Equipment Data  from standard observer trips</abstract>
      <notes>Loaded by batch 8949, 07-06-2016 08:23</notes>
   </item-identification>
   <entity-information>
      <entity-type>Data View</entity-type>
      <active-version>Yes</active-version>
      <schema>OBDBS</schema>
      <description>Observer Trip-Equipment Data  from standard observer trips</description>
   </entity-information>
   <data-attributes>
      <data-attribute cc-id="330776">
         <seq-order>1</seq-order>
         <name>PROGRAM</name>
         <data-storage-type>VARCHAR2</data-storage-type>
         <max-length>3</max-length>
         <required>No</required>
         <primary-key>No</primary-key>
         <status>Active</status>
         <description>First three digits of links.  Code that identifies program, see OBPROGRAM table. Collected for ASM where applicable.</description>
         <general-data-type>VARCHAR2</general-data-type>
      </data-attribute>
      <data-attribute cc-id="330777">
         <seq-order>2</seq-order>
         <name>YEAR</name>
         <data-storage-type>VARCHAR2</data-storage-type>
         <max-length>4</max-length>
         <required>No</required>
         <primary-key>No</primary-key>
         <status>Active</status>
         <description>Year Landed; characters 4 - 7 of link1 - link6. Collected for ASM where applicable.</description>
         <general-data-type>VARCHAR2</general-data-type>
      </data-attribute>
      <data-attribute cc-id="330778">
         <seq-order>3</seq-order>
         <name>MONTH</name>
         <data-storage-type>VARCHAR2</data-storage-type>
         <max-length>2</max-length>
         <required>No</required>
         <primary-key>No</primary-key>
         <status>Active</status>
         <description>Month landed, the 8 - 9 characters in all link fields. Collected for ASM where applicable.</description>
         <general-data-type>VARCHAR2</general-data-type>
      </data-attribute>
      <data-attribute cc-id="330779">
         <seq-order>4</seq-order>
         <name>TRIPID</name>
         <data-storage-type>VARCHAR2</data-storage-type>
         <max-length>6</max-length>
         <required>No</required>
         <primary-key>No</primary-key>
         <status>Active</status>
         <description>May 1994 - current: 6 - character trip id;  first three characters are the observer id number (obsid) and the second are the ordinal number of trips the observer has taken for the current year. Collected for ASM where applicable.</description>
         <general-data-type>VARCHAR2</general-data-type>
      </data-attribute>
      <data-attribute cc-id="330780">
         <seq-order>5</seq-order>
         <name>LINK1</name>
         <data-storage-type>VARCHAR2</data-storage-type>
         <max-length>15</max-length>
         <required>Yes</required>
         <primary-key>No</primary-key>
         <status>Active</status>
         <description>15-character Key field linking tables at the trip level; made up of:  program + year + month + tripid. Appears as first 15 characters in all 'LINK ' fields. Collected for ASM where applicable.</description>
         <general-data-type>VARCHAR2</general-data-type>
      </data-attribute>
      <data-attribute cc-id="330781">
         <seq-order>6</seq-order>
         <name>EQUIPCOD</name>
         <data-storage-type>VARCHAR2</data-storage-type>
         <max-length>3</max-length>
         <required>Yes</required>
         <primary-key>No</primary-key>
         <status>Active</status>
         <description>Code  for type of equipment.  See OBEQUIP table.</description>
         <general-data-type>VARCHAR2</general-data-type>
      </data-attribute>
      <data-attribute cc-id="330782">
         <seq-order>7</seq-order>
         <name>EQUIPCNT</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>Number of units for equipment of equipcod category item on vessel.</description>
         <general-data-type>NUMBER</general-data-type>
      </data-attribute>
      <data-attribute cc-id="330783">
         <seq-order>8</seq-order>
         <name>TRQCOMMENTS</name>
         <data-storage-type>VARCHAR2</data-storage-type>
         <max-length>250</max-length>
         <required>No</required>
         <primary-key>No</primary-key>
         <status>Active</status>
         <description>Additional information regarding trip equipment. Prior to 2001 only true or false.</description>
         <general-data-type>VARCHAR2</general-data-type>
      </data-attribute>
   </data-attributes>
   <catalog-details>
      <guid>gov.noaa.nmfs.inport:33323</guid>
      <metadata-record-created-by pers-id="13445">Patricia Jones</metadata-record-created-by>
      <metadata-record-created>2016-07-06T08:23:45</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:12</metadata-record-last-modified>
      <record-published>2016-07-28</record-published>
      <owner-organization>Northeast Fisheries Science Center</owner-organization>
      <owner-organization-acronym>NEFSC</owner-organization-acronym>
      <owner-organization-address>166 Water Street</owner-organization-address>
      <owner-organization-address-city>Woods Hole</owner-organization-address-city>
      <owner-organization-address-state>MA</owner-organization-address-state>
      <owner-organization-address-zip>02543-1026</owner-organization-address-zip>
      <owner-organization-address-country>USA</owner-organization-address-country>
      <owner-organization-phone>(508)495-2000</owner-organization-phone>
      <owner-organization-url>https://www.nefsc.noaa.gov</owner-organization-url>
      <owner-organization-business-hours>8:00 a.m. to 4:30 p.m. Monday - Friday</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-07-28</metadata-last-review-date>
      <metadata-review-frequency>1 Year</metadata-review-frequency>
      <metadata-next-review-date>2017-07-28</metadata-next-review-date>
   </catalog-details>
</inport-metadata>
