<?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>5282</catalog-item-id>
      <title>Economic Data Collection for Gulf of Mexico South Atlantic Shrimp Fisheries</title>
      <short-name>Economic Survey Data of Southeast Federal Shrimp Fisheries</short-name>
      <catalog-item-type>Data Set</catalog-item-type>
      <metadata-workflow-state ccs-id="9">Published / External</metadata-workflow-state>
      <parent-catalog-item-id>4682</parent-catalog-item-id>
      <parent-title>Economic Data Collections for Gulf of Mexico &amp; South Atlantic Shrimp Fisheries</parent-title>
      <parent-catalog-item-type>Project</parent-catalog-item-type>
      <status>In Work</status>
      <creation-date>2005</creation-date>
      <abstract>The Annual Economic Survey of Federal Gulf and Atlantic Shrimp Permit Holders collects data about operating expenses and costs of owning and maintaining shrimp vessels. Each spring, surveys are sent by mail to a random sample of 33 of all vessels with federal permits for the harvest of Gulf of Mexico penaeid shrimp or South Atlantic penaeid or rock shrimp. This information is used to assess trends in the financial and economic state of the fisheries, and to determine the economic and social effects of regulations and other factors affecting the Southeast shrimp fisheries. The individual information is confidential and only summary statistics are released to the public.</abstract>
      <purpose>Provide economics research to support fisheries management.</purpose>
      <notes>This includes raw and processed data. The processed data is cleaned and processed cost data merged with external revenue and other data which underlies the various tech memos and reports produced.</notes>
   </item-identification>
   <keywords>
      <keyword controlled="No">
         <keyword-type>Theme</keyword-type>
         <thesaurus>PARR Exclusion</thesaurus>
         <keyword>Non-Environmental Data</keyword>
      </keyword>
      <keyword controlled="No">
         <keyword-type>Theme</keyword-type>
         <keyword>annual costs</keyword>
      </keyword>
      <keyword controlled="No">
         <keyword-type>Theme</keyword-type>
         <keyword>annual profits</keyword>
      </keyword>
      <keyword controlled="No">
         <keyword-type>Theme</keyword-type>
         <keyword>annual revenue</keyword>
      </keyword>
      <keyword controlled="No">
         <keyword-type>Theme</keyword-type>
         <keyword>cultural data</keyword>
      </keyword>
      <keyword controlled="No">
         <keyword-type>Theme</keyword-type>
         <keyword>economic data</keyword>
      </keyword>
      <keyword controlled="No">
         <keyword-type>Theme</keyword-type>
         <keyword>fishery-dependent</keyword>
      </keyword>
      <keyword controlled="No">
         <keyword-type>Theme</keyword-type>
         <keyword>permits</keyword>
      </keyword>
      <keyword controlled="No">
         <keyword-type>Theme</keyword-type>
         <keyword>shrimp</keyword>
      </keyword>
      <keyword controlled="No">
         <keyword-type>Temporal</keyword-type>
         <keyword>2005-PRESENT</keyword>
      </keyword>
      <keyword controlled="No">
         <keyword-type>Spatial</keyword-type>
         <keyword>ALABAMA</keyword>
      </keyword>
      <keyword controlled="No">
         <keyword-type>Spatial</keyword-type>
         <keyword>FLORIDA</keyword>
      </keyword>
      <keyword controlled="No">
         <keyword-type>Spatial</keyword-type>
         <keyword>Gulf Of Mexico</keyword>
      </keyword>
      <keyword controlled="No">
         <keyword-type>Spatial</keyword-type>
         <keyword>LOUISIANA</keyword>
      </keyword>
      <keyword controlled="No">
         <keyword-type>Spatial</keyword-type>
         <keyword>MISSISSIPPI</keyword>
      </keyword>
      <keyword controlled="No">
         <keyword-type>Spatial</keyword-type>
         <keyword>TEXAS</keyword>
      </keyword>
      <keyword controlled="No">
         <keyword-type>Stratum</keyword-type>
         <keyword>equipment expense</keyword>
      </keyword>
      <keyword controlled="No">
         <keyword-type>Stratum</keyword-type>
         <keyword>fuel cost</keyword>
      </keyword>
      <keyword controlled="No">
         <keyword-type>Stratum</keyword-type>
         <keyword>fuel expense</keyword>
      </keyword>
      <keyword controlled="No">
         <keyword-type>Stratum</keyword-type>
         <keyword>hurricane repair expense</keyword>
      </keyword>
      <keyword controlled="No">
         <keyword-type>Stratum</keyword-type>
         <keyword>ice expense</keyword>
      </keyword>
      <keyword controlled="No">
         <keyword-type>Stratum</keyword-type>
         <keyword>insurance expense</keyword>
      </keyword>
      <keyword controlled="No">
         <keyword-type>Stratum</keyword-type>
         <keyword>permit</keyword>
      </keyword>
      <keyword controlled="No">
         <keyword-type>Stratum</keyword-type>
         <keyword>vessel</keyword>
      </keyword>
   </keywords>
   <physical-location>
      <organization>Southeast Fisheries Science Center</organization>
      <city>Miami</city>
      <state-province>FL</state-province>
      <country>USA</country>
      <location-description>Location Of The Main Office Of The South East Fisheries Science Center</location-description>
   </physical-location>
   <data-set-information>
      <data-set-scope-code>Data Set</data-set-scope-code>
      <data-set-type>Database</data-set-type>
      <maintenance-frequency>As Needed</maintenance-frequency>
      <data-presentation-form>Table (digital)</data-presentation-form>
      <instrument>N/A</instrument>
      <platform>N/A</platform>
      <physical-collection-fishing-gear>N/A</physical-collection-fishing-gear>
   </data-set-information>
   <entity-attribute-information partial-listing="No" total-count="8">
      <entity>
         <item-identification>
            <catalog-item-id>5283</catalog-item-id>
            <title>Table: ANNUAL_ECONOMIC_SURVEY</title>
            <short-name>ANNUAL_ECONOMIC_SURVEY</short-name>
            <metadata-workflow-state ccs-id="9">Published / External</metadata-workflow-state>
            <status>Completed</status>
            <abstract>The main data table with financial details on the permit holders total annual fishing expenses</abstract>
            <notes>Loaded by batch 1643, 10-10-2007 10:43</notes>
         </item-identification>
         <entity-information>
            <entity-type>Data Table</entity-type>
            <active-version>Yes</active-version>
            <schema>EC_SRV_GS</schema>
            <description>The main data table with financial details on the permit holders total annual fishing expenses</description>
         </entity-information>
         <data-attributes partial-listing="No" total-count="59">
            <data-attribute cc-id="15328">
               <seq-order>1</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>38</precision>
               <status>Active</status>
               <description>The fishing year for the reported expenses.</description>
               <general-data-type>NUMBER</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15327">
               <seq-order>2</seq-order>
               <name>ID</name>
               <data-storage-type>NUMBER</data-storage-type>
               <max-length>22</max-length>
               <required>Yes</required>
               <primary-key>Yes</primary-key>
               <precision>38</precision>
               <status>Active</status>
               <description>An artificial key to identify an individual record.</description>
               <general-data-type>NUMBER</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15326">
               <seq-order>3</seq-order>
               <name>PERMIT_OWNER_NAME</name>
               <data-storage-type>VARCHAR2</data-storage-type>
               <max-length>80</max-length>
               <required>Yes</required>
               <primary-key>No</primary-key>
               <status>Active</status>
               <description>The name of the permit owner.</description>
               <general-data-type>VARCHAR2</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15325">
               <seq-order>4</seq-order>
               <name>PERMIT_NUMBER</name>
               <data-storage-type>VARCHAR2</data-storage-type>
               <max-length>20</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <status>Active</status>
               <description>The permit number includes the prefix SPGM-</description>
               <general-data-type>VARCHAR2</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15324">
               <seq-order>5</seq-order>
               <name>VESSEL_NAME</name>
               <data-storage-type>VARCHAR2</data-storage-type>
               <max-length>50</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <status>Active</status>
               <description>The name of the vessel.</description>
               <general-data-type>VARCHAR2</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15323">
               <seq-order>6</seq-order>
               <name>VESSEL_ID</name>
               <data-storage-type>VARCHAR2</data-storage-type>
               <max-length>20</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <status>Active</status>
               <description>The code used to identify the vessel.</description>
               <general-data-type>VARCHAR2</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15322">
               <seq-order>7</seq-order>
               <name>PAID_TO_CREW</name>
               <data-storage-type>NUMBER</data-storage-type>
               <max-length>22</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <precision>38</precision>
               <status>Active</status>
               <description>Total amount paid to crew for the year.</description>
               <general-data-type>NUMBER</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15321">
               <seq-order>8</seq-order>
               <name>OWNER_IS_CAPTAIN</name>
               <data-storage-type>NUMBER</data-storage-type>
               <max-length>22</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <precision>1</precision>
               <scale>0</scale>
               <status>Active</status>
               <description>1 = The owner is also the captain of this vessel, otherwise 0.</description>
               <general-data-type>NUMBER</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15320">
               <seq-order>9</seq-order>
               <name>OWNER_IS_PAID_CAPTAIN_SHARE</name>
               <data-storage-type>NUMBER</data-storage-type>
               <max-length>22</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <precision>1</precision>
               <scale>0</scale>
               <status>Active</status>
               <description>1 = the owner paid a captain's share?</description>
               <general-data-type>NUMBER</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15319">
               <seq-order>10</seq-order>
               <name>CAPTAIN_SHARE</name>
               <data-storage-type>NUMBER</data-storage-type>
               <max-length>22</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <precision>38</precision>
               <status>Active</status>
               <description>The total annual captain's payment when the captain is paid a captain's share.</description>
               <general-data-type>NUMBER</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15318">
               <seq-order>11</seq-order>
               <name>COMBINED_CREW_EXPENSE</name>
               <data-storage-type>NUMBER</data-storage-type>
               <max-length>22</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <precision>38</precision>
               <status>Active</status>
               <description>The combined expense for captain and crew for the year when the owner is not the captain.</description>
               <general-data-type>NUMBER</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15317">
               <seq-order>12</seq-order>
               <name>FUEL_EXPENSE</name>
               <data-storage-type>NUMBER</data-storage-type>
               <max-length>22</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <precision>38</precision>
               <status>Active</status>
               <description>Total amount paid for fuel (including amounts paid by crew and captain) for the year</description>
               <general-data-type>NUMBER</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15316">
               <seq-order>13</seq-order>
               <name>AVG_PRICE_FUEL_PER_GAL</name>
               <data-storage-type>NUMBER</data-storage-type>
               <max-length>22</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <precision>38</precision>
               <status>Active</status>
               <description>Average price of fuel for the year</description>
               <general-data-type>NUMBER</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15315">
               <seq-order>14</seq-order>
               <name>GALLONS_OF_FUEL_PURCHASED</name>
               <data-storage-type>NUMBER</data-storage-type>
               <max-length>22</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <precision>38</precision>
               <status>Active</status>
               <description>Total amount of fuel purchased for the year</description>
               <general-data-type>NUMBER</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15314">
               <seq-order>15</seq-order>
               <name>ICE_EXPENSE</name>
               <data-storage-type>NUMBER</data-storage-type>
               <max-length>22</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <precision>38</precision>
               <status>Active</status>
               <description>Total amount paid for purchased ice (including amounts paid by crew and captain) for the year</description>
               <general-data-type>NUMBER</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15313">
               <seq-order>16</seq-order>
               <name>OTHER_TRIP_EXPENSES</name>
               <data-storage-type>NUMBER</data-storage-type>
               <max-length>22</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <precision>38</precision>
               <status>Active</status>
               <description>Total annual amount paid for all other trip related supplies or expenses      (excluding salaries, fuel and ice; including amounts paid by crew and captain)</description>
               <general-data-type>NUMBER</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15312">
               <seq-order>17</seq-order>
               <name>EQUIPMENT_EXPENSES</name>
               <data-storage-type>NUMBER</data-storage-type>
               <max-length>22</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <precision>38</precision>
               <status>Active</status>
               <description>Total annual amount paid for any vessel, engine, gear or other equipment (including      electronics ) maintenance, repair, replacement, upgrade or new purchase</description>
               <general-data-type>NUMBER</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15311">
               <seq-order>18</seq-order>
               <name>HAD_NO_MAJOR_EXPENSES</name>
               <data-storage-type>NUMBER</data-storage-type>
               <max-length>22</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <precision>1</precision>
               <scale>0</scale>
               <status>Active</status>
               <description>1 = Fisher had no major, infrequent or irregular expenses</description>
               <general-data-type>NUMBER</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15310">
               <seq-order>19</seq-order>
               <name>HAD_HAUL_OUT_OR_DRY_DOCK</name>
               <data-storage-type>NUMBER</data-storage-type>
               <max-length>22</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <precision>1</precision>
               <scale>0</scale>
               <status>Active</status>
               <description>Fisher had haul out or dry dock expense during the year.</description>
               <general-data-type>NUMBER</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15309">
               <seq-order>20</seq-order>
               <name>HAD_NEW_PURCHASE_OR_UPGRADE</name>
               <data-storage-type>NUMBER</data-storage-type>
               <max-length>22</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <precision>1</precision>
               <scale>0</scale>
               <status>Active</status>
               <description>Fisher had a new purchase or upgrade expense during the year.</description>
               <general-data-type>NUMBER</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15308">
               <seq-order>21</seq-order>
               <name>HAD_HURRICANE_REPAIR</name>
               <data-storage-type>NUMBER</data-storage-type>
               <max-length>22</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <precision>1</precision>
               <scale>0</scale>
               <status>Active</status>
               <description>Fisher had hurricane repairs during the year.</description>
               <general-data-type>NUMBER</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15307">
               <seq-order>22</seq-order>
               <name>HAD_OTHER_REPAIR</name>
               <data-storage-type>NUMBER</data-storage-type>
               <max-length>22</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <precision>1</precision>
               <scale>0</scale>
               <status>Active</status>
               <description>Fisher had other repair or replacement expenses during the year</description>
               <general-data-type>NUMBER</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15306">
               <seq-order>23</seq-order>
               <name>HAD_OTHER_MAJOR_EXPENSE</name>
               <data-storage-type>NUMBER</data-storage-type>
               <max-length>22</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <precision>1</precision>
               <scale>0</scale>
               <status>Active</status>
               <description>Fisher had other major, infrequent or irregular expenses during the year.</description>
               <general-data-type>NUMBER</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15305">
               <seq-order>24</seq-order>
               <name>OVERHEAD_FOR_VESSEL</name>
               <data-storage-type>NUMBER</data-storage-type>
               <max-length>22</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <precision>38</precision>
               <status>Active</status>
               <description>Annual overhead applicable to this vessel (including loan payments and vessel insurance; excluding depreciation, income taxes)</description>
               <general-data-type>NUMBER</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15304">
               <seq-order>25</seq-order>
               <name>TOTAL_ANNUAL_EXPENSE</name>
               <data-storage-type>NUMBER</data-storage-type>
               <max-length>22</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <precision>38</precision>
               <status>Active</status>
               <description>The sum of the other itemized annual expenses.</description>
               <general-data-type>NUMBER</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15303">
               <seq-order>26</seq-order>
               <name>HAS_INSURANCE</name>
               <data-storage-type>NUMBER</data-storage-type>
               <max-length>22</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <precision>1</precision>
               <scale>0</scale>
               <status>Active</status>
               <description>1 = Fisher had some insurance on the vessel during the year</description>
               <general-data-type>NUMBER</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15302">
               <seq-order>27</seq-order>
               <name>HAS_INSURANCE_ON_HULL</name>
               <data-storage-type>NUMBER</data-storage-type>
               <max-length>22</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <precision>1</precision>
               <scale>0</scale>
               <status>Active</status>
               <description>1 = Fisher had some insurance on the hull during the year</description>
               <general-data-type>NUMBER</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15301">
               <seq-order>28</seq-order>
               <name>HAS_P_AND_I_INSURANCE</name>
               <data-storage-type>NUMBER</data-storage-type>
               <max-length>22</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <precision>1</precision>
               <scale>0</scale>
               <status>Active</status>
               <description>1 = Fisher has P and I insurance. Protection and indemnity insurance covering the vessel owners against their liability for damage to cargo in their care and custody; death or injury to passengers, crew, cargo loaders, and others; damage caused to piers, docks, underwater cables, and bridges; and, more recently, damage caused by pollution.</description>
               <general-data-type>NUMBER</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15300">
               <seq-order>29</seq-order>
               <name>HAS_OTHER_VESSEL_INSURANCE</name>
               <data-storage-type>NUMBER</data-storage-type>
               <max-length>22</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <precision>1</precision>
               <scale>0</scale>
               <status>Active</status>
               <description>1 = Fisher has other vessel insurance</description>
               <general-data-type>NUMBER</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15299">
               <seq-order>30</seq-order>
               <name>TOTAL_VESSEL_COVERAGE</name>
               <data-storage-type>NUMBER</data-storage-type>
               <max-length>22</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <precision>38</precision>
               <status>Active</status>
               <description>Total amount vessel is insured for</description>
               <general-data-type>NUMBER</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15298">
               <seq-order>31</seq-order>
               <name>MARKET_VALUE_OF_VESSEL</name>
               <data-storage-type>NUMBER</data-storage-type>
               <max-length>22</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <precision>38</precision>
               <status>Active</status>
               <description>Market value of vessel (anytime in the year):</description>
               <general-data-type>NUMBER</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15297">
               <seq-order>32</seq-order>
               <name>REPLACEMENT_VALUE_OF_VESSEL</name>
               <data-storage-type>NUMBER</data-storage-type>
               <max-length>22</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <precision>38</precision>
               <status>Active</status>
               <description>Cost to replace the vessel</description>
               <general-data-type>NUMBER</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15296">
               <seq-order>33</seq-order>
               <name>ORIGINAL_PURCHASE_PRICE</name>
               <data-storage-type>NUMBER</data-storage-type>
               <max-length>22</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <precision>38</precision>
               <status>Active</status>
               <description>The original purchase price of the vessel</description>
               <general-data-type>NUMBER</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15295">
               <seq-order>34</seq-order>
               <name>HAD_LOAN_DURING_YEAR</name>
               <data-storage-type>NUMBER</data-storage-type>
               <max-length>22</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <precision>1</precision>
               <scale>0</scale>
               <status>Active</status>
               <description>1 = Had a loan anytime during the year</description>
               <general-data-type>NUMBER</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15294">
               <seq-order>35</seq-order>
               <name>PRINCIPAL_REMAINING</name>
               <data-storage-type>NUMBER</data-storage-type>
               <max-length>22</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <precision>38</precision>
               <status>Active</status>
               <description>The principal remaining at the end of the year</description>
               <general-data-type>NUMBER</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15293">
               <seq-order>36</seq-order>
               <name>TOTAL_LOAN_PAYMENTS</name>
               <data-storage-type>NUMBER</data-storage-type>
               <max-length>22</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <precision>38</precision>
               <status>Active</status>
               <description>Total loan payments during the year</description>
               <general-data-type>NUMBER</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15292">
               <seq-order>37</seq-order>
               <name>INTEREST_PAID</name>
               <data-storage-type>NUMBER</data-storage-type>
               <max-length>22</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <precision>38</precision>
               <status>Active</status>
               <description>Total interest paid during the year</description>
               <general-data-type>NUMBER</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15291">
               <seq-order>38</seq-order>
               <name>PRINCIPAL_PAID</name>
               <data-storage-type>NUMBER</data-storage-type>
               <max-length>22</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <precision>38</precision>
               <status>Active</status>
               <description>Total principal paid during the year</description>
               <general-data-type>NUMBER</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15290">
               <seq-order>39</seq-order>
               <name>DEPRECIATION_VESSEL_MACHINERY</name>
               <data-storage-type>NUMBER</data-storage-type>
               <max-length>22</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <precision>38</precision>
               <status>Active</status>
               <description>Depreciation of vessel and machinery as claimed for tax purposes for the year</description>
               <general-data-type>NUMBER</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15289">
               <seq-order>40</seq-order>
               <name>FISHING_DAYS_LOST</name>
               <data-storage-type>NUMBER</data-storage-type>
               <max-length>22</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <precision>38</precision>
               <status>Active</status>
               <description>Total days of fishing lost by this vessel due to a lack of crew</description>
               <general-data-type>NUMBER</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15288">
               <seq-order>41</seq-order>
               <name>GROSS_REVENUE_NON_SHRIMP</name>
               <data-storage-type>NUMBER</data-storage-type>
               <max-length>22</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <precision>38</precision>
               <status>Active</status>
               <description>Total gross revenue generated by this vessel in commercial     fisheries other than shrimp during the year</description>
               <general-data-type>NUMBER</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15287">
               <seq-order>42</seq-order>
               <name>GOVERNMENT_PAYMENTS</name>
               <data-storage-type>NUMBER</data-storage-type>
               <max-length>22</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <precision>38</precision>
               <status>Active</status>
               <description>Government payments received due to imports and low shrimp prices (tariff money; trade assistance adjustment payments, etc) and disaster relief (hurricanes) for the year</description>
               <general-data-type>NUMBER</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15286">
               <seq-order>43</seq-order>
               <name>USE_ANOTHER_LANGUAGE</name>
               <data-storage-type>NUMBER</data-storage-type>
               <max-length>22</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <precision>1</precision>
               <scale>0</scale>
               <status>Active</status>
               <description>1 = Use another language beside English for the survey; 0 = Use English</description>
               <general-data-type>NUMBER</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15285">
               <seq-order>44</seq-order>
               <name>USE_SPANISH_LANGUAGE</name>
               <data-storage-type>NUMBER</data-storage-type>
               <max-length>22</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <precision>1</precision>
               <scale>0</scale>
               <status>Active</status>
               <description>1 = Fisher requested a survey in Spanish</description>
               <general-data-type>NUMBER</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15284">
               <seq-order>45</seq-order>
               <name>USE_VIETNAMESE_LANGUAGE</name>
               <data-storage-type>NUMBER</data-storage-type>
               <max-length>22</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <precision>1</precision>
               <scale>0</scale>
               <status>Active</status>
               <description>1 = Fisher requested a survey in Vietnamese</description>
               <general-data-type>NUMBER</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15283">
               <seq-order>46</seq-order>
               <name>PRINTED_NAME_OF_SIGNER</name>
               <data-storage-type>VARCHAR2</data-storage-type>
               <max-length>80</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <status>Active</status>
               <description>The printed name of the person submitting the survey</description>
               <general-data-type>VARCHAR2</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15282">
               <seq-order>47</seq-order>
               <name>PHONE_NUMBER_OF_SIGNER</name>
               <data-storage-type>VARCHAR2</data-storage-type>
               <max-length>30</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <status>Active</status>
               <description>The primary contact phone number</description>
               <general-data-type>VARCHAR2</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15281">
               <seq-order>48</seq-order>
               <name>HAS_PERMIT_OWNER_COMMENTS</name>
               <data-storage-type>NUMBER</data-storage-type>
               <max-length>22</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <precision>1</precision>
               <scale>0</scale>
               <status>Active</status>
               <description>1 = Permit owner has provided comments</description>
               <general-data-type>NUMBER</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15280">
               <seq-order>49</seq-order>
               <name>DATA_ENTRY_COMMENTS</name>
               <data-storage-type>VARCHAR2</data-storage-type>
               <max-length>2000</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <status>Active</status>
               <description>Comments by the data entry person</description>
               <general-data-type>VARCHAR2</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15279">
               <seq-order>50</seq-order>
               <name>QUALITY_OF_ENTRY</name>
               <data-storage-type>NUMBER</data-storage-type>
               <max-length>22</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <precision>1</precision>
               <scale>0</scale>
               <status>Active</status>
               <description>Data entry person's judgement of data quality: 1 = Good, 2 = Fair,  3 = Poor</description>
               <general-data-type>NUMBER</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15278">
               <seq-order>51</seq-order>
               <name>WAS_EDITED</name>
               <data-storage-type>NUMBER</data-storage-type>
               <max-length>22</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <precision>1</precision>
               <scale>0</scale>
               <status>Active</status>
               <description>1 = Data manager edited the record in a non-trivial way</description>
               <general-data-type>NUMBER</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15277">
               <seq-order>52</seq-order>
               <name>WAS_SHRIMPING</name>
               <data-storage-type>NUMBER</data-storage-type>
               <max-length>22</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <precision>1</precision>
               <scale>0</scale>
               <status>Active</status>
               <description>1 = Fisher reported shrimping during the year</description>
               <general-data-type>NUMBER</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15276">
               <seq-order>53</seq-order>
               <name>IS_COMPLETE</name>
               <data-storage-type>NUMBER</data-storage-type>
               <max-length>22</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <precision>1</precision>
               <scale>0</scale>
               <status>Active</status>
               <description>1 if all required information was provided, otherwise 0</description>
               <general-data-type>NUMBER</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15275">
               <seq-order>54</seq-order>
               <name>CREATED_BY_USER_ID</name>
               <data-storage-type>VARCHAR2</data-storage-type>
               <max-length>20</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <status>Active</status>
               <description>An application controlled field showing the userid of the person inserting a record</description>
               <general-data-type>VARCHAR2</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15274">
               <seq-order>55</seq-order>
               <name>CREATED_DATE</name>
               <data-storage-type>DATE</data-storage-type>
               <max-length>7</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <status>Active</status>
               <description>An application controlled field showing the date and time the record was inserted into the Oracle table</description>
               <general-data-type>DATE</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15273">
               <seq-order>56</seq-order>
               <name>MODIFIED_BY_USER_ID</name>
               <data-storage-type>VARCHAR2</data-storage-type>
               <max-length>20</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <status>Active</status>
               <description>The userid of the last person to edit the data</description>
               <general-data-type>VARCHAR2</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15272">
               <seq-order>57</seq-order>
               <name>MODIFIED_DATE</name>
               <data-storage-type>DATE</data-storage-type>
               <max-length>7</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <status>Active</status>
               <description>The date of the last update to the record</description>
               <general-data-type>DATE</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15271">
               <seq-order>58</seq-order>
               <name>PERMIT_OWNER_COMMENTS</name>
               <data-storage-type>VARCHAR2</data-storage-type>
               <max-length>2000</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <status>Active</status>
               <description>The analyst's summary of the fisher's comments</description>
               <general-data-type>VARCHAR2</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15270">
               <seq-order>59</seq-order>
               <name>ALTERNATE_PHONE_NUMBER</name>
               <data-storage-type>VARCHAR2</data-storage-type>
               <max-length>30</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <status>Active</status>
               <description>A second phone number fo the fisher</description>
               <general-data-type>VARCHAR2</general-data-type>
            </data-attribute>
         </data-attributes>
      </entity>
      <entity>
         <item-identification>
            <catalog-item-id>5284</catalog-item-id>
            <title>Table: CODES_SEARCH</title>
            <short-name>CODES_SEARCH</short-name>
            <metadata-workflow-state ccs-id="9">Published / External</metadata-workflow-state>
            <status>Completed</status>
            <abstract>A control table for storing the last search query for a user.</abstract>
            <notes>Loaded by batch 1643, 10-10-2007 10:43</notes>
         </item-identification>
         <entity-information>
            <entity-type>Data Table</entity-type>
            <active-version>Yes</active-version>
            <schema>EC_SRV_GS</schema>
            <description>A control table for storing the last search query for a user.</description>
         </entity-information>
         <data-attributes partial-listing="No" total-count="15">
            <data-attribute cc-id="15343">
               <seq-order>1</seq-order>
               <name>USERNAME</name>
               <data-storage-type>VARCHAR2</data-storage-type>
               <max-length>30</max-length>
               <required>Yes</required>
               <primary-key>No</primary-key>
               <status>Active</status>
               <description>The user making the query.</description>
               <general-data-type>VARCHAR2</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15342">
               <seq-order>2</seq-order>
               <name>TABLE_NAME</name>
               <data-storage-type>VARCHAR2</data-storage-type>
               <max-length>100</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <status>Active</status>
               <description>The name of the table being queried</description>
               <general-data-type>VARCHAR2</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15341">
               <seq-order>3</seq-order>
               <name>COLUMN_NAME1</name>
               <data-storage-type>VARCHAR2</data-storage-type>
               <max-length>100</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <status>Active</status>
               <description>The name of the first column used to filter the results.</description>
               <general-data-type>VARCHAR2</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15340">
               <seq-order>4</seq-order>
               <name>DATA_TYPE1</name>
               <data-storage-type>VARCHAR2</data-storage-type>
               <max-length>100</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <status>Active</status>
               <description>The data type of the first column used to filter the results.</description>
               <general-data-type>VARCHAR2</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15339">
               <seq-order>5</seq-order>
               <name>OPERATOR1</name>
               <data-storage-type>VARCHAR2</data-storage-type>
               <max-length>20</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <status>Active</status>
               <description>The operator applied to the first column used to filter the results.</description>
               <general-data-type>VARCHAR2</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15338">
               <seq-order>6</seq-order>
               <name>COLUMN_VALUE1</name>
               <data-storage-type>VARCHAR2</data-storage-type>
               <max-length>200</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <status>Active</status>
               <description>The search value for the first column used to filter the results.</description>
               <general-data-type>VARCHAR2</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15337">
               <seq-order>7</seq-order>
               <name>LOGICAL_OPERATOR</name>
               <data-storage-type>VARCHAR2</data-storage-type>
               <max-length>20</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <status>Active</status>
               <description>The logical operator (AND | OR) used when query includes 2 query clauses.</description>
               <general-data-type>VARCHAR2</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15336">
               <seq-order>8</seq-order>
               <name>COLUMN_NAME2</name>
               <data-storage-type>VARCHAR2</data-storage-type>
               <max-length>100</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <status>Active</status>
               <description>The name of the second column used to filter the results.</description>
               <general-data-type>VARCHAR2</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15335">
               <seq-order>9</seq-order>
               <name>DATA_TYPE2</name>
               <data-storage-type>VARCHAR2</data-storage-type>
               <max-length>100</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <status>Active</status>
               <description>The data type of the second column used to filter the results.</description>
               <general-data-type>VARCHAR2</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15334">
               <seq-order>10</seq-order>
               <name>OPERATOR2</name>
               <data-storage-type>VARCHAR2</data-storage-type>
               <max-length>20</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <status>Active</status>
               <description>The operator applied to the second column used to filter the results.</description>
               <general-data-type>VARCHAR2</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15333">
               <seq-order>11</seq-order>
               <name>COLUMN_VALUE2</name>
               <data-storage-type>VARCHAR2</data-storage-type>
               <max-length>200</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <status>Active</status>
               <description>The operator applied to the second column used to filter the results.</description>
               <general-data-type>VARCHAR2</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15332">
               <seq-order>12</seq-order>
               <name>SORT1</name>
               <data-storage-type>VARCHAR2</data-storage-type>
               <max-length>100</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <status>Active</status>
               <description>The first column used to sort results by.</description>
               <general-data-type>VARCHAR2</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15331">
               <seq-order>13</seq-order>
               <name>ASCDESC1</name>
               <data-storage-type>VARCHAR2</data-storage-type>
               <max-length>5</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <status>Active</status>
               <description>Whether the first sort field is in ASCENDING (ASC) or DESCENDING (DESC) order.</description>
               <general-data-type>VARCHAR2</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15330">
               <seq-order>14</seq-order>
               <name>SORT2</name>
               <data-storage-type>VARCHAR2</data-storage-type>
               <max-length>100</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <status>Active</status>
               <description>The second column used to sort results by.</description>
               <general-data-type>VARCHAR2</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15329">
               <seq-order>15</seq-order>
               <name>ASCDESC2</name>
               <data-storage-type>VARCHAR2</data-storage-type>
               <max-length>5</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <status>Active</status>
               <description>Whether the second sort field is in ASCENDING (ASC) or DESCENDING (DESC) order.</description>
               <general-data-type>VARCHAR2</general-data-type>
            </data-attribute>
         </data-attributes>
      </entity>
      <entity>
         <item-identification>
            <catalog-item-id>5285</catalog-item-id>
            <title>Table: CODE_COLUMNS</title>
            <short-name>CODE_COLUMNS</short-name>
            <metadata-workflow-state ccs-id="9">Published / External</metadata-workflow-state>
            <status>Completed</status>
            <abstract>A control table that shows for each table what columns are editable in the code maintenance modules.</abstract>
            <notes>Loaded by batch 1643, 10-10-2007 10:43</notes>
         </item-identification>
         <entity-information>
            <entity-type>Data Table</entity-type>
            <active-version>Yes</active-version>
            <schema>EC_SRV_GS</schema>
            <description>A control table that shows for each table what columns are editable in the code maintenance modules.</description>
         </entity-information>
         <data-attributes partial-listing="No" total-count="6">
            <data-attribute cc-id="15349">
               <seq-order>1</seq-order>
               <name>TABLE_NAME</name>
               <data-storage-type>VARCHAR2</data-storage-type>
               <max-length>30</max-length>
               <required>Yes</required>
               <primary-key>No</primary-key>
               <status>Active</status>
               <description>The name of the table user can edit in the code maintenance module.</description>
               <general-data-type>VARCHAR2</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15348">
               <seq-order>2</seq-order>
               <name>COLUMN_NAME</name>
               <data-storage-type>VARCHAR2</data-storage-type>
               <max-length>30</max-length>
               <required>Yes</required>
               <primary-key>No</primary-key>
               <status>Active</status>
               <description>The name of the column in the table that user can edit in the code maintenance module.</description>
               <general-data-type>VARCHAR2</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15347">
               <seq-order>3</seq-order>
               <name>DATA_TYPE</name>
               <data-storage-type>VARCHAR2</data-storage-type>
               <max-length>106</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <status>Active</status>
               <description>The data type (i.e. number, date, varchar2, ...) of the column in the table that user can edit in the code maintenance module.</description>
               <general-data-type>VARCHAR2</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15346">
               <seq-order>4</seq-order>
               <name>DATA_LENGTH</name>
               <data-storage-type>NUMBER</data-storage-type>
               <max-length>22</max-length>
               <required>Yes</required>
               <primary-key>No</primary-key>
               <precision>38</precision>
               <status>Active</status>
               <description>The data length of the column in the table that user can edit in the code maintenance module.</description>
               <general-data-type>NUMBER</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15345">
               <seq-order>5</seq-order>
               <name>NULLABLE</name>
               <data-storage-type>VARCHAR2</data-storage-type>
               <max-length>1</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <status>Active</status>
               <description>Nullable (Y=yes, N=No) for whether null values are allowed in the column in the table that user can edit in the code maintenance module.</description>
               <general-data-type>VARCHAR2</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15344">
               <seq-order>6</seq-order>
               <name>COL_SCREEN_ORDER</name>
               <data-storage-type>NUMBER</data-storage-type>
               <max-length>22</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <precision>38</precision>
               <status>Active</status>
               <description>The order in which the column will appear on screen in the code maintenance module.</description>
               <general-data-type>NUMBER</general-data-type>
            </data-attribute>
         </data-attributes>
      </entity>
      <entity>
         <item-identification>
            <catalog-item-id>5286</catalog-item-id>
            <title>Table: CODE_TABLE_LIST</title>
            <short-name>CODE_TABLE_LIST</short-name>
            <metadata-workflow-state ccs-id="9">Published / External</metadata-workflow-state>
            <status>Completed</status>
            <abstract>A control table that controls what tables are viewable and editable from the code maintenance module.</abstract>
            <notes>Loaded by batch 1643, 10-10-2007 10:43</notes>
         </item-identification>
         <entity-information>
            <entity-type>Data Table</entity-type>
            <active-version>Yes</active-version>
            <schema>EC_SRV_GS</schema>
            <description>A control table that controls what tables are viewable and editable from the code maintenance module.</description>
         </entity-information>
         <data-attributes partial-listing="No" total-count="9">
            <data-attribute cc-id="15358">
               <seq-order>1</seq-order>
               <name>TABLE_NAME</name>
               <data-storage-type>VARCHAR2</data-storage-type>
               <max-length>30</max-length>
               <required>Yes</required>
               <primary-key>No</primary-key>
               <status>Active</status>
               <description>The name of the table viewable or editable by the code maintenance module.</description>
               <general-data-type>VARCHAR2</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15357">
               <seq-order>2</seq-order>
               <name>DATA_MANAGER</name>
               <data-storage-type>VARCHAR2</data-storage-type>
               <max-length>1</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <status>Active</status>
               <description>The highest access given to the role of data manager for this table: N=none,V=view only,E=Editable</description>
               <general-data-type>VARCHAR2</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15356">
               <seq-order>3</seq-order>
               <name>DATA_ENTRY</name>
               <data-storage-type>VARCHAR2</data-storage-type>
               <max-length>1</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <status>Active</status>
               <description>The highest access given to the role of data entry for this table: N=none,V=view only,E=Editable</description>
               <general-data-type>VARCHAR2</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15355">
               <seq-order>4</seq-order>
               <name>ADMINISTRATOR</name>
               <data-storage-type>VARCHAR2</data-storage-type>
               <max-length>1</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <status>Active</status>
               <description>The highest access given to the role of administrator for this table: N=none,V=view only,E=Editable</description>
               <general-data-type>VARCHAR2</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15354">
               <seq-order>5</seq-order>
               <name>IS_PUBLIC</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>Whether this table is public, YES or NO</description>
               <general-data-type>VARCHAR2</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15353">
               <seq-order>6</seq-order>
               <name>CREATED_BY_USER_ID</name>
               <data-storage-type>VARCHAR2</data-storage-type>
               <max-length>20</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <status>Active</status>
               <description>A control field listing the user_id of the record creator.</description>
               <general-data-type>VARCHAR2</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15352">
               <seq-order>7</seq-order>
               <name>CREATED_DATE</name>
               <data-storage-type>DATE</data-storage-type>
               <max-length>7</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <status>Active</status>
               <description>A control field listing the system time when the record was created.</description>
               <general-data-type>DATE</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15351">
               <seq-order>8</seq-order>
               <name>MODIFIED_BY_USER_ID</name>
               <data-storage-type>VARCHAR2</data-storage-type>
               <max-length>20</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <status>Active</status>
               <description>A control field listing the user_id of the person modifying the record.</description>
               <general-data-type>VARCHAR2</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15350">
               <seq-order>9</seq-order>
               <name>MODIFIED_DATE</name>
               <data-storage-type>DATE</data-storage-type>
               <max-length>7</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <status>Active</status>
               <description>A control field listing the system time when the record was last modfied.</description>
               <general-data-type>DATE</general-data-type>
            </data-attribute>
         </data-attributes>
      </entity>
      <entity>
         <item-identification>
            <catalog-item-id>5287</catalog-item-id>
            <title>Table: CONTROL_PARAMETERS</title>
            <short-name>CONTROL_PARAMETERS</short-name>
            <metadata-workflow-state ccs-id="9">Published / External</metadata-workflow-state>
            <status>Completed</status>
            <abstract>A control table that provides a set of application wide parameters, such as the year to process and additional parameters that determine whether values are flagged as warnings or errors.</abstract>
            <notes>Loaded by batch 1643, 10-10-2007 10:43</notes>
         </item-identification>
         <entity-information>
            <entity-type>Data Table</entity-type>
            <active-version>Yes</active-version>
            <schema>EC_SRV_GS</schema>
            <description>A control table that provides a set of application wide parameters, such as the year to process and additional parameters that determine whether values are flagged as warnings or errors.</description>
         </entity-information>
         <data-attributes partial-listing="No" total-count="13">
            <data-attribute cc-id="15371">
               <seq-order>1</seq-order>
               <name>CURRENT_PROCESSING_YEAR</name>
               <data-storage-type>NUMBER</data-storage-type>
               <max-length>22</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <precision>4</precision>
               <scale>0</scale>
               <status>Active</status>
               <description>This sets the ACTIVE_YEAR of this survey, allowing all annual surveys to reside in the same Oracle table. It also controls the year displayed on data entry screens.</description>
               <general-data-type>NUMBER</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15370">
               <seq-order>2</seq-order>
               <name>CREATED_BY_USER_ID</name>
               <data-storage-type>VARCHAR2</data-storage-type>
               <max-length>20</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <status>Active</status>
               <description>A control field listing the user_id of the record creator.</description>
               <general-data-type>VARCHAR2</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15369">
               <seq-order>3</seq-order>
               <name>CREATED_DATE</name>
               <data-storage-type>DATE</data-storage-type>
               <max-length>7</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <status>Active</status>
               <description>A control field listing the system time when the record was created.</description>
               <general-data-type>DATE</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15368">
               <seq-order>4</seq-order>
               <name>MODIFIED_BY_USER_ID</name>
               <data-storage-type>VARCHAR2</data-storage-type>
               <max-length>20</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <status>Active</status>
               <description>A control field listing the user_id of the person modifying the record.</description>
               <general-data-type>VARCHAR2</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15367">
               <seq-order>5</seq-order>
               <name>MODIFIED_DATE</name>
               <data-storage-type>DATE</data-storage-type>
               <max-length>7</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <status>Active</status>
               <description>A control field listing the system time when the record was last modfied.</description>
               <general-data-type>DATE</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15366">
               <seq-order>6</seq-order>
               <name>SMALLEST_FUEL_WARNING_PERCENT</name>
               <data-storage-type>NUMBER</data-storage-type>
               <max-length>22</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <precision>38</precision>
               <status>Active</status>
               <description>The intial setting of 5 indicates that fuel_expenses will be accepted as valid when the fuel expense is within 95% and 105% of (average price per gallons * number of gallons purchased).</description>
               <general-data-type>NUMBER</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15365">
               <seq-order>7</seq-order>
               <name>LARGEST_FUEL_WARNING_PERCENT</name>
               <data-storage-type>NUMBER</data-storage-type>
               <max-length>22</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <precision>38</precision>
               <status>Active</status>
               <description>The intial setting of 20 indicates that fuel_expenses will be flagged as a probable error when the fuel_expense is less than 80% of (average price per gallons * number of gallons purchased) or the fuel_expense is more than 120% of (average price per gallons * number of gallons purchased).</description>
               <general-data-type>NUMBER</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15364">
               <seq-order>8</seq-order>
               <name>OVERHEAD_COEFF_PERCENT</name>
               <data-storage-type>NUMBER</data-storage-type>
               <max-length>22</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <precision>38</precision>
               <status>Active</status>
               <description>The intial setting of 2 indicates that overhead will be flagged as a probable error when: overhead is less than loan payments times average of market value of the vessel and purchase price of the vessel times the overhead_coefficient_percentage for vessels with hull insurance.</description>
               <general-data-type>NUMBER</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15363">
               <seq-order>9</seq-order>
               <name>SMALLEST_INSUR_WARNING_PERCENT</name>
               <data-storage-type>NUMBER</data-storage-type>
               <max-length>22</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <precision>38</precision>
               <status>Active</status>
               <description>25 indicates that total amount vessel is insured for will be valid when the fuel expense is within 75% and 125% of vessel's average (market value, original purchase price).</description>
               <general-data-type>NUMBER</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15362">
               <seq-order>10</seq-order>
               <name>LARGEST_INSUR_WARNING_PERCENT</name>
               <data-storage-type>NUMBER</data-storage-type>
               <max-length>22</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <precision>38</precision>
               <status>Active</status>
               <description>The intial setting of 50 indicates that total amount vessel is insured for will be flagged as a probable error when it is less than 50% of vessel's average (market value, original purchase price) or greater than 150% of vessel's average (market value, original purchase price).</description>
               <general-data-type>NUMBER</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15361">
               <seq-order>11</seq-order>
               <name>SMALLEST_NONSHRMP_WARN_PERCENT</name>
               <data-storage-type>NUMBER</data-storage-type>
               <max-length>22</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <precision>38</precision>
               <status>Active</status>
               <description>The intial setting of 50 indicates that non-shrimp total gross revenue will be marked as questionable when it exceeds 50% of the total annual expenses.</description>
               <general-data-type>NUMBER</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15360">
               <seq-order>12</seq-order>
               <name>SMALLEST_TOT_EXP_WARN_PERCENT</name>
               <data-storage-type>NUMBER</data-storage-type>
               <max-length>22</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <precision>38</precision>
               <status>Active</status>
               <description>0 indicates that any deviation in total annual expense from the sum of the above entries is flagged as a warning.</description>
               <general-data-type>NUMBER</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15359">
               <seq-order>13</seq-order>
               <name>LARGEST_TOT_EXP_WARN_PERCENT</name>
               <data-storage-type>NUMBER</data-storage-type>
               <max-length>22</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <precision>38</precision>
               <status>Active</status>
               <description>2.5 indicates that a deviation in total annual expense from the sum of the above entries is flagged as an error.</description>
               <general-data-type>NUMBER</general-data-type>
            </data-attribute>
         </data-attributes>
      </entity>
      <entity>
         <item-identification>
            <catalog-item-id>5288</catalog-item-id>
            <title>Table: SAMPLE_PERMIT_OWNER</title>
            <short-name>SAMPLE_PERMIT_OWNER</short-name>
            <metadata-workflow-state ccs-id="9">Published / External</metadata-workflow-state>
            <status>Completed</status>
            <abstract>A lookup table of permit owner names and their vessels.</abstract>
            <notes>Loaded by batch 1643, 10-10-2007 10:43</notes>
         </item-identification>
         <entity-information>
            <entity-type>Data Table</entity-type>
            <active-version>Yes</active-version>
            <schema>EC_SRV_GS</schema>
            <description>A lookup table of permit owner names and their vessels.</description>
         </entity-information>
         <data-attributes partial-listing="No" total-count="26">
            <data-attribute cc-id="15397">
               <seq-order>1</seq-order>
               <name>STATE</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>2 letter abbreviation for the state issuing the permit.</description>
               <general-data-type>VARCHAR2</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15396">
               <seq-order>2</seq-order>
               <name>PERMIT_NUMBER_SUFFIX</name>
               <data-storage-type>VARCHAR2</data-storage-type>
               <max-length>10</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <status>Active</status>
               <description>The numeric part of the suffix. Prefix for all is SPGM-</description>
               <general-data-type>VARCHAR2</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15395">
               <seq-order>3</seq-order>
               <name>VESSEL_ID</name>
               <data-storage-type>VARCHAR2</data-storage-type>
               <max-length>20</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <status>Active</status>
               <description>Vessel identification number</description>
               <general-data-type>VARCHAR2</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15394">
               <seq-order>4</seq-order>
               <name>GSHRLBS</name>
               <data-storage-type>VARCHAR2</data-storage-type>
               <max-length>10</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <status>Active</status>
               <description>Total pounds of Gulf Shrimp harvested by vessel.</description>
               <general-data-type>VARCHAR2</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15393">
               <seq-order>5</seq-order>
               <name>GSHRREV</name>
               <data-storage-type>VARCHAR2</data-storage-type>
               <max-length>10</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <status>Active</status>
               <description>Dollar value of Gulf Shrimp harvested by vessel.</description>
               <general-data-type>VARCHAR2</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15392">
               <seq-order>6</seq-order>
               <name>SPANISH</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>1 = Desire survey forms in Spanish language.</description>
               <general-data-type>VARCHAR2</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15391">
               <seq-order>7</seq-order>
               <name>VIETNAMESE</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>1 = Desire survey forms in Vietnamese language.</description>
               <general-data-type>VARCHAR2</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15390">
               <seq-order>8</seq-order>
               <name>VESSEL_NAME</name>
               <data-storage-type>VARCHAR2</data-storage-type>
               <max-length>40</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <status>Active</status>
               <description>The name of the vessel</description>
               <general-data-type>VARCHAR2</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15389">
               <seq-order>9</seq-order>
               <name>PERMIT_NUMBER</name>
               <data-storage-type>VARCHAR2</data-storage-type>
               <max-length>9</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <status>Active</status>
               <description>The permit number authorizing vessel to catch and sell shrimp.</description>
               <general-data-type>VARCHAR2</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15388">
               <seq-order>10</seq-order>
               <name>PRIMARY_MAILING_RECIPIENT</name>
               <data-storage-type>VARCHAR2</data-storage-type>
               <max-length>50</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <status>Active</status>
               <description>The name of the primary permit holder. It can be an individual or a company.</description>
               <general-data-type>VARCHAR2</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15387">
               <seq-order>11</seq-order>
               <name>STREET_ADDRESS</name>
               <data-storage-type>VARCHAR2</data-storage-type>
               <max-length>40</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <status>Active</status>
               <description>The street address of the primary mailing recipient.</description>
               <general-data-type>VARCHAR2</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15386">
               <seq-order>12</seq-order>
               <name>CITY</name>
               <data-storage-type>VARCHAR2</data-storage-type>
               <max-length>30</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <status>Active</status>
               <description>The city where the primary mailing recipient receives mail.</description>
               <general-data-type>VARCHAR2</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15385">
               <seq-order>13</seq-order>
               <name>MAILING_STATE</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>The state where the primary mailing recipient receives mail.</description>
               <general-data-type>VARCHAR2</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15384">
               <seq-order>14</seq-order>
               <name>ZIP_CODE</name>
               <data-storage-type>VARCHAR2</data-storage-type>
               <max-length>9</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <status>Active</status>
               <description>The zip code of  the primary mailing recipient.</description>
               <general-data-type>VARCHAR2</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15383">
               <seq-order>15</seq-order>
               <name>PHONE_NUMBER</name>
               <data-storage-type>VARCHAR2</data-storage-type>
               <max-length>20</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <status>Active</status>
               <description>The phone number of the primary mailing recipient.</description>
               <general-data-type>VARCHAR2</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15382">
               <seq-order>16</seq-order>
               <name>BUSINESS_RELATIONSHIP</name>
               <data-storage-type>VARCHAR2</data-storage-type>
               <max-length>30</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <status>Active</status>
               <description>When multiple people share a permit, their position is listed here, Examples are PRESIDENT, SECRETARY, TREASURER, etc.</description>
               <general-data-type>VARCHAR2</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15381">
               <seq-order>17</seq-order>
               <name>BUSINESS_ASSOCIATE_LNAME</name>
               <data-storage-type>VARCHAR2</data-storage-type>
               <max-length>40</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <status>Active</status>
               <description>Business associates last name.</description>
               <general-data-type>VARCHAR2</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15380">
               <seq-order>18</seq-order>
               <name>BUSINESS_ASSOCIATE_FNAME</name>
               <data-storage-type>VARCHAR2</data-storage-type>
               <max-length>25</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <status>Active</status>
               <description>Business associates first name.</description>
               <general-data-type>VARCHAR2</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15379">
               <seq-order>19</seq-order>
               <name>BUSINESS_ASSOCIATE_PHONE</name>
               <data-storage-type>VARCHAR2</data-storage-type>
               <max-length>20</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <status>Active</status>
               <description>Business associates phone number.</description>
               <general-data-type>VARCHAR2</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15378">
               <seq-order>20</seq-order>
               <name>HOMEPORT_CITY</name>
               <data-storage-type>VARCHAR2</data-storage-type>
               <max-length>30</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <status>Active</status>
               <description>The home port city of the permit holder.</description>
               <general-data-type>VARCHAR2</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15377">
               <seq-order>21</seq-order>
               <name>HOMEPORT_STATE</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>The home port state of the permit holder.</description>
               <general-data-type>VARCHAR2</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15376">
               <seq-order>22</seq-order>
               <name>ACTIVE_YEAR</name>
               <data-storage-type>NUMBER</data-storage-type>
               <max-length>22</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <precision>4</precision>
               <scale>0</scale>
               <status>Active</status>
               <description>The survey year this entry will be used for.</description>
               <general-data-type>NUMBER</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15375">
               <seq-order>23</seq-order>
               <name>CREATED_BY_USER_ID</name>
               <data-storage-type>VARCHAR2</data-storage-type>
               <max-length>20</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <status>Active</status>
               <description>An application controlled field showing the userid of the person inserting a record</description>
               <general-data-type>VARCHAR2</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15374">
               <seq-order>24</seq-order>
               <name>CREATED_DATE</name>
               <data-storage-type>DATE</data-storage-type>
               <max-length>7</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <status>Active</status>
               <description>An application controlled field showing the date and time the record was inserted into the Oracle table</description>
               <general-data-type>DATE</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15373">
               <seq-order>25</seq-order>
               <name>MODIFIED_BY_USER_ID</name>
               <data-storage-type>VARCHAR2</data-storage-type>
               <max-length>20</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <status>Active</status>
               <description>The userid of the last person to edit the data</description>
               <general-data-type>VARCHAR2</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15372">
               <seq-order>26</seq-order>
               <name>MODIFIED_DATE</name>
               <data-storage-type>DATE</data-storage-type>
               <max-length>7</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <status>Active</status>
               <description>The date of the last update to the record</description>
               <general-data-type>DATE</general-data-type>
            </data-attribute>
         </data-attributes>
      </entity>
      <entity>
         <item-identification>
            <catalog-item-id>5289</catalog-item-id>
            <title>Table: USER_PRIVILEGE</title>
            <short-name>USER_PRIVILEGE</short-name>
            <metadata-workflow-state ccs-id="9">Published / External</metadata-workflow-state>
            <status>Completed</status>
            <abstract>A control table showing what roles have been assigned to what users.</abstract>
            <notes>Loaded by batch 1643, 10-10-2007 10:43</notes>
         </item-identification>
         <entity-information>
            <entity-type>Data Table</entity-type>
            <active-version>Yes</active-version>
            <schema>EC_SRV_GS</schema>
            <description>A control table showing what roles have been assigned to what users.</description>
         </entity-information>
         <data-attributes partial-listing="No" total-count="8">
            <data-attribute cc-id="15405">
               <seq-order>1</seq-order>
               <name>USERNAME</name>
               <data-storage-type>VARCHAR2</data-storage-type>
               <max-length>20</max-length>
               <required>Yes</required>
               <primary-key>No</primary-key>
               <status>Active</status>
               <description>The oracle id of the system user</description>
               <general-data-type>VARCHAR2</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15404">
               <seq-order>2</seq-order>
               <name>PASSWORD</name>
               <data-storage-type>VARCHAR2</data-storage-type>
               <max-length>20</max-length>
               <required>Yes</required>
               <primary-key>No</primary-key>
               <status>Active</status>
               <description>The password of the user.</description>
               <general-data-type>VARCHAR2</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15403">
               <seq-order>3</seq-order>
               <name>GROUP_NAME</name>
               <data-storage-type>VARCHAR2</data-storage-type>
               <max-length>256</max-length>
               <required>Yes</required>
               <primary-key>No</primary-key>
               <status>Active</status>
               <description>The group the user belong to, which controls their level of access.</description>
               <general-data-type>VARCHAR2</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15402">
               <seq-order>4</seq-order>
               <name>PRIVILEGE</name>
               <data-storage-type>VARCHAR2</data-storage-type>
               <max-length>30</max-length>
               <required>Yes</required>
               <primary-key>No</primary-key>
               <status>Active</status>
               <description>Privilege assigned, ie ADMINISTATOR, DATA_MANAGER.</description>
               <general-data-type>VARCHAR2</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15401">
               <seq-order>5</seq-order>
               <name>CREATED_BY_USER_ID</name>
               <data-storage-type>VARCHAR2</data-storage-type>
               <max-length>20</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <status>Active</status>
               <description>An application controlled field showing the userid of the person inserting a record</description>
               <general-data-type>VARCHAR2</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15400">
               <seq-order>6</seq-order>
               <name>CREATED_DATE</name>
               <data-storage-type>DATE</data-storage-type>
               <max-length>7</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <status>Active</status>
               <description>An application controlled field showing the date and time the record was inserted into the Oracle table</description>
               <general-data-type>DATE</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15399">
               <seq-order>7</seq-order>
               <name>MODIFIED_BY_USER_ID</name>
               <data-storage-type>VARCHAR2</data-storage-type>
               <max-length>20</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <status>Active</status>
               <description>The userid of the last person to edit the data</description>
               <general-data-type>VARCHAR2</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15398">
               <seq-order>8</seq-order>
               <name>MODIFIED_DATE</name>
               <data-storage-type>DATE</data-storage-type>
               <max-length>7</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <status>Active</status>
               <description>The date of the last update to the record</description>
               <general-data-type>DATE</general-data-type>
            </data-attribute>
         </data-attributes>
      </entity>
      <entity>
         <item-identification>
            <catalog-item-id>5290</catalog-item-id>
            <title>Table: USER_PROFILE</title>
            <short-name>USER_PROFILE</short-name>
            <metadata-workflow-state ccs-id="9">Published / External</metadata-workflow-state>
            <status>Completed</status>
            <abstract>The control table used to identify users to the system and record their passwords.</abstract>
            <notes>Loaded by batch 1643, 10-10-2007 10:43</notes>
         </item-identification>
         <entity-information>
            <entity-type>Data Table</entity-type>
            <active-version>Yes</active-version>
            <schema>EC_SRV_GS</schema>
            <description>The control table used to identify users to the system and record their passwords.</description>
         </entity-information>
         <data-attributes partial-listing="No" total-count="6">
            <data-attribute cc-id="15411">
               <seq-order>1</seq-order>
               <name>USERNAME</name>
               <data-storage-type>VARCHAR2</data-storage-type>
               <max-length>20</max-length>
               <required>Yes</required>
               <primary-key>Yes</primary-key>
               <status>Active</status>
               <description>The oracle id of the system user</description>
               <general-data-type>VARCHAR2</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15410">
               <seq-order>2</seq-order>
               <name>PASSWORD</name>
               <data-storage-type>VARCHAR2</data-storage-type>
               <max-length>20</max-length>
               <required>Yes</required>
               <primary-key>No</primary-key>
               <status>Active</status>
               <description>The password of the user.</description>
               <general-data-type>VARCHAR2</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15409">
               <seq-order>3</seq-order>
               <name>CREATED_BY_USER_ID</name>
               <data-storage-type>VARCHAR2</data-storage-type>
               <max-length>20</max-length>
               <required>Yes</required>
               <primary-key>No</primary-key>
               <status>Active</status>
               <description>An application controlled field showing the userid of the person inserting a record</description>
               <general-data-type>VARCHAR2</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15408">
               <seq-order>4</seq-order>
               <name>CREATED_DATE</name>
               <data-storage-type>DATE</data-storage-type>
               <max-length>7</max-length>
               <required>Yes</required>
               <primary-key>No</primary-key>
               <status>Active</status>
               <description>An application controlled field showing the date and time the record was inserted into the Oracle table</description>
               <general-data-type>DATE</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15407">
               <seq-order>5</seq-order>
               <name>MODIFIED_BY_USER_ID</name>
               <data-storage-type>VARCHAR2</data-storage-type>
               <max-length>20</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <status>Active</status>
               <description>The userid of the last person to edit the data</description>
               <general-data-type>VARCHAR2</general-data-type>
            </data-attribute>
            <data-attribute cc-id="15406">
               <seq-order>6</seq-order>
               <name>MODIFIED_DATE</name>
               <data-storage-type>DATE</data-storage-type>
               <max-length>7</max-length>
               <required>No</required>
               <primary-key>No</primary-key>
               <status>Active</status>
               <description>The date of the last update to the record</description>
               <general-data-type>DATE</general-data-type>
            </data-attribute>
         </data-attributes>
      </entity>
   </entity-attribute-information>
   <support-roles>
      <support-role cc-id="1453153" in-effect="Yes">
         <support-role-type>Data Steward</support-role-type>
         <from-date>2025-11-03</from-date>
         <contact-type>Person</contact-type>
         <contact-name>Liese, Christopher</contact-name>
         <contact-email>Christopher.Liese@noaa.gov</contact-email>
         <contact-address>75 Virginia Beach Dr</contact-address>
         <contact-address-city>Miami</contact-address-city>
         <contact-address-state>FL</contact-address-state>
         <contact-address-zip>33139</contact-address-zip>
         <contact-address-country>United States</contact-address-country>
         <contact-phone-number>305-365-1109</contact-phone-number>
         <contact-fax-number>305-365-4102</contact-fax-number>
         <contact-business-hours>8:00 AM - 4:30 PM EST/EDT</contact-business-hours>
      </support-role>
      <support-role cc-id="279145" in-effect="Yes">
         <support-role-type>Distributor</support-role-type>
         <from-date>2006</from-date>
         <contact-type>Organization</contact-type>
         <contact-name>Southeast Fisheries Science Center</contact-name>
         <contact-noaa-acronym>SEFSC</contact-noaa-acronym>
         <contact-ror>https://ror.org/0396y0w87</contact-ror>
         <contact-address>75 Virginia Beach Drive</contact-address>
         <contact-address-city>Miami</contact-address-city>
         <contact-address-state>FL</contact-address-state>
         <contact-address-zip>33149</contact-address-zip>
         <contact-address-country>USA</contact-address-country>
         <contact-phone-number>(305)361-5761</contact-phone-number>
         <contact-url>https://www.fisheries.noaa.gov/about/southeast-fisheries-science-center</contact-url>
         <contact-url-description>About SEFSC</contact-url-description>
         <contact-url-function>Online Resource</contact-url-function>
         <contact-business-hours>8:00 a.m. - 4:30 p.m. EST</contact-business-hours>
      </support-role>
      <support-role cc-id="1453155" in-effect="Yes">
         <support-role-type>Metadata Contact</support-role-type>
         <from-date>2025-11-03</from-date>
         <contact-type>Person</contact-type>
         <contact-name>Liese, Christopher</contact-name>
         <contact-email>Christopher.Liese@noaa.gov</contact-email>
         <contact-address>75 Virginia Beach Dr</contact-address>
         <contact-address-city>Miami</contact-address-city>
         <contact-address-state>FL</contact-address-state>
         <contact-address-zip>33139</contact-address-zip>
         <contact-address-country>United States</contact-address-country>
         <contact-phone-number>305-365-1109</contact-phone-number>
         <contact-fax-number>305-365-4102</contact-fax-number>
         <contact-business-hours>8:00 AM - 4:30 PM EST/EDT</contact-business-hours>
      </support-role>
      <support-role cc-id="1453154" in-effect="Yes">
         <support-role-type>Point of Contact</support-role-type>
         <from-date>2025-11-03</from-date>
         <contact-type>Person</contact-type>
         <contact-name>Liese, Christopher</contact-name>
         <contact-email>Christopher.Liese@noaa.gov</contact-email>
         <contact-address>75 Virginia Beach Dr</contact-address>
         <contact-address-city>Miami</contact-address-city>
         <contact-address-state>FL</contact-address-state>
         <contact-address-zip>33139</contact-address-zip>
         <contact-address-country>United States</contact-address-country>
         <contact-phone-number>305-365-1109</contact-phone-number>
         <contact-fax-number>305-365-4102</contact-fax-number>
         <contact-business-hours>8:00 AM - 4:30 PM EST/EDT</contact-business-hours>
      </support-role>
   </support-roles>
   <extents>
      <currentness-reference>Ground Condition</currentness-reference>
      <extent cc-id="243190">
         <geographic-areas>
            <geographic-area cc-id="42802">
               <description>Waters off of the South East Atlantic States and the Gulf States</description>
            </geographic-area>
         </geographic-areas>
         <time-frames>
            <time-frame cc-id="41133">
               <time-frame-type>Continuing</time-frame-type>
               <start-date-time>2006</start-date-time>
            </time-frame>
         </time-frames>
      </extent>
   </extents>
   <access-information>
      <security-class>Sensitive</security-class>
      <data-access-procedure>n/a</data-access-procedure>
      <data-access-constraints>Waiver Needed</data-access-constraints>
   </access-information>
   <urls>
      <url cc-id="784956">
         <url>https://www.fisheries.noaa.gov/southeast/socioeconomics/economic-data-collections-southeast</url>
         <name>Home Of Economic Data Collection for Gulf of Mexico &amp; South Atlantic Shrimp Fisheries</name>
         <url-type>Online Resource</url-type>
         <file-resource-format>html</file-resource-format>
         <description>To download non-confidential reports and forms</description>
      </url>
   </urls>
   <activity-logs>
      <activity-log cc-id="42782">
         <activity-date-time>2010-05-01</activity-date-time>
         <activity-type>Development of system in JDeveloper 10.1.2</activity-type>
         <responsible-party>Muccio, Lloyd </responsible-party>
         <description>Software development in conjunction with Christopher Liese based upon 2009 survey. Data incorporated into system from Microsoft Access database.</description>
      </activity-log>
   </activity-logs>
   <technical-environment>
      <description>Oracle database houses the data from the Economic Survey of Gulf Shrimp.</description>
   </technical-environment>
   <data-quality>
      <representativeness>Random selection of several hundred permit holders each year done to achieve representativeness of all permit holders.</representativeness>
      <accuracy>Several attempts were made to recontact the permit holder to confirm or correct unusual values reported on the survey forms. Values were presented as reported when confirmation was desired but not received.</accuracy>
      <analytical-accuracy>The analytical accuracy depends on the accuracy of the self reporting of costs.  Follow up analysis guages the consistency of reported costs and revenues across the entire set of permit holders.</analytical-accuracy>
      <quantitation-limits>The survey requests a yearly summary of income and expenses rather than a transaction by transaction record.</quantitation-limits>
      <bias>No known biases.</bias>
      <quality-control-procedures>Standard Dillman method.</quality-control-procedures>
   </data-quality>
   <data-management>
      <resources-identified>No</resources-identified>
      <resources-budget-percentage>0</resources-budget-percentage>
      <data-access-directive-compliant>Yes</data-access-directive-compliant>
      <data-access-directive-waiver>Yes</data-access-directive-waiver>
      <hosting-service-needed>No</hosting-service-needed>
      <delay-collection-dissemination>0</delay-collection-dissemination>
      <delay-collection-dissemination-explanation>This data is currently wavered under the current NOAA guidelines for relational databases.</delay-collection-dissemination-explanation>
      <archive-location>Other</archive-location>
      <delay-collection-archive>0</delay-collection-archive>
      <data-protection-plan>Wavered Data</data-protection-plan>
   </data-management>
   <lineage>
      <lineage-process-steps>
         <lineage-process-step cc-id="284723">
            <sequence-number>1</sequence-number>
            <description>Exel/SAS/R processing.</description>
            <process-contact>
               <contact-type>Person</contact-type>
               <contact-name>Liese, Christopher</contact-name>
               <contact-email>Christopher.Liese@noaa.gov</contact-email>
               <contact-address>75 Virginia Beach Dr</contact-address>
               <contact-address-city>Miami</contact-address-city>
               <contact-address-state>FL</contact-address-state>
               <contact-address-zip>33139</contact-address-zip>
               <contact-address-country>United States</contact-address-country>
               <contact-phone-number>305-365-1109</contact-phone-number>
               <contact-fax-number>305-365-4102</contact-fax-number>
               <contact-business-hours>8:00 AM - 4:30 PM EST/EDT</contact-business-hours>
            </process-contact>
         </lineage-process-step>
      </lineage-process-steps>
   </lineage>
   <child-items>
      <child-item>
         <catalog-item-id>5283</catalog-item-id>
         <catalog-item-type>Entity</catalog-item-type>
         <title>Table: ANNUAL_ECONOMIC_SURVEY</title>
      </child-item>
      <child-item>
         <catalog-item-id>5284</catalog-item-id>
         <catalog-item-type>Entity</catalog-item-type>
         <title>Table: CODES_SEARCH</title>
      </child-item>
      <child-item>
         <catalog-item-id>5285</catalog-item-id>
         <catalog-item-type>Entity</catalog-item-type>
         <title>Table: CODE_COLUMNS</title>
      </child-item>
      <child-item>
         <catalog-item-id>5286</catalog-item-id>
         <catalog-item-type>Entity</catalog-item-type>
         <title>Table: CODE_TABLE_LIST</title>
      </child-item>
      <child-item>
         <catalog-item-id>5287</catalog-item-id>
         <catalog-item-type>Entity</catalog-item-type>
         <title>Table: CONTROL_PARAMETERS</title>
      </child-item>
      <child-item>
         <catalog-item-id>5288</catalog-item-id>
         <catalog-item-type>Entity</catalog-item-type>
         <title>Table: SAMPLE_PERMIT_OWNER</title>
      </child-item>
      <child-item>
         <catalog-item-id>5289</catalog-item-id>
         <catalog-item-type>Entity</catalog-item-type>
         <title>Table: USER_PRIVILEGE</title>
      </child-item>
      <child-item>
         <catalog-item-id>5290</catalog-item-id>
         <catalog-item-type>Entity</catalog-item-type>
         <title>Table: USER_PROFILE</title>
      </child-item>
   </child-items>
   <catalog-details>
      <guid>gov.noaa.nmfs.inport:5282</guid>
      <metadata-record-created-by pers-id="1279">Lee Weinberger</metadata-record-created-by>
      <metadata-record-created>2007-10-10T10:40:37</metadata-record-created>
      <metadata-record-last-modified-by pers-id="0">SysAdmin InPortAdmin</metadata-record-last-modified-by>
      <metadata-record-last-modified>2026-03-04T19:17:18</metadata-record-last-modified>
      <record-published>2021-05-07</record-published>
      <owner-organization>Southeast Fisheries Science Center</owner-organization>
      <owner-organization-acronym>SEFSC</owner-organization-acronym>
      <owner-organization-address>75 Virginia Beach Drive</owner-organization-address>
      <owner-organization-address-city>Miami</owner-organization-address-city>
      <owner-organization-address-state>FL</owner-organization-address-state>
      <owner-organization-address-zip>33149</owner-organization-address-zip>
      <owner-organization-address-country>USA</owner-organization-address-country>
      <owner-organization-phone>(305)361-5761</owner-organization-phone>
      <owner-organization-url>www.sefsc.noaa.gov</owner-organization-url>
      <owner-organization-business-hours>8:00 a.m. - 4:30 p.m. EST</owner-organization-business-hours>
      <owner-organization-group-id>1001</owner-organization-group-id>
      <publication-status>Public</publication-status>
      <limited-metadata-available>No</limited-metadata-available>
      <is-do-not-publish>No</is-do-not-publish>
      <metadata-last-review-date>2021-05-07</metadata-last-review-date>
      <metadata-review-frequency>1 Year</metadata-review-frequency>
      <metadata-next-review-date>2022-05-07</metadata-next-review-date>
   </catalog-details>
</inport-metadata>
