<?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>12300</catalog-item-id>
      <title>Table: OLS_LOV_STAFF</title>
      <short-name>OLS_LOV_STAFF</short-name>
      <catalog-item-type>Entity</catalog-item-type>
      <metadata-workflow-state ccs-id="9">Published / External</metadata-workflow-state>
      <parent-catalog-item-id>12269</parent-catalog-item-id>
      <parent-title>AFSC/FMA/Observer Logistics System (OLS)</parent-title>
      <parent-catalog-item-type>Data Set</parent-catalog-item-type>
      <status>Completed</status>
      <abstract>List of FMA debriefing, and training personnel. This table was renamed from the old norpac STAFF</abstract>
      <notes>Loaded by batch 3083, 04-19-2012 13:25</notes>
   </item-identification>
   <entity-information>
      <entity-type>Data Table</entity-type>
      <active-version>Yes</active-version>
      <schema>NORPAC</schema>
      <description>List of FMA debriefing, and training personnel. This table was renamed from the old norpac STAFF</description>
   </entity-information>
   <data-attributes>
      <data-attribute cc-id="65204">
         <seq-order>1</seq-order>
         <name>STAFF_ID</name>
         <data-storage-type>NUMBER</data-storage-type>
         <max-length>22</max-length>
         <required>Yes</required>
         <primary-key>Yes</primary-key>
         <precision>9</precision>
         <scale>0</scale>
         <status>Active</status>
         <description>Sequence derived unique identifier of an employee.</description>
         <general-data-type>NUMBER</general-data-type>
      </data-attribute>
      <data-attribute cc-id="65205">
         <seq-order>2</seq-order>
         <name>STAFF_CODE</name>
         <data-storage-type>VARCHAR2</data-storage-type>
         <max-length>3</max-length>
         <required>Yes</required>
         <primary-key>No</primary-key>
         <status>Active</status>
         <description>Three Letter acroynym uniquely identifying an employee.</description>
         <general-data-type>VARCHAR2</general-data-type>
      </data-attribute>
      <data-attribute cc-id="65206">
         <seq-order>3</seq-order>
         <name>NAME</name>
         <data-storage-type>VARCHAR2</data-storage-type>
         <max-length>60</max-length>
         <required>Yes</required>
         <primary-key>No</primary-key>
         <status>Active</status>
         <description>Full Name of Employee</description>
         <general-data-type>VARCHAR2</general-data-type>
      </data-attribute>
      <data-attribute cc-id="65207">
         <seq-order>4</seq-order>
         <name>ACTIVE_FLAG</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>Boolean indicator of employee status. Active(T) Inactive(F)</description>
         <general-data-type>VARCHAR2</general-data-type>
      </data-attribute>
      <data-attribute cc-id="65208">
         <seq-order>5</seq-order>
         <name>ORACLE_USERID</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>OFIS assigned Oracle user name</description>
         <general-data-type>VARCHAR2</general-data-type>
      </data-attribute>
      <data-attribute cc-id="65209">
         <seq-order>6</seq-order>
         <name>EMAIL_ADDRESS</name>
         <data-storage-type>VARCHAR2</data-storage-type>
         <max-length>60</max-length>
         <required>No</required>
         <primary-key>No</primary-key>
         <status>Active</status>
         <description>Email address of the debriefer-inseason advisor.</description>
         <general-data-type>VARCHAR2</general-data-type>
      </data-attribute>
   </data-attributes>
   <catalog-details>
      <guid>gov.noaa.nmfs.inport:12300</guid>
      <metadata-record-created-by pers-id="1162">Doug Turnbull</metadata-record-created-by>
      <metadata-record-created>2012-04-19T13:25:58</metadata-record-created>
      <metadata-record-last-modified-by pers-id="0">SysAdmin InPortAdmin</metadata-record-last-modified-by>
      <metadata-record-last-modified>2022-08-09T17:11:04</metadata-record-last-modified>
      <record-published>2018-09-26</record-published>
      <owner-organization>Alaska Fisheries Science Center</owner-organization>
      <owner-organization-acronym>AFSC</owner-organization-acronym>
      <owner-organization-address>7600 Sand Point Way N.E., Building 4</owner-organization-address>
      <owner-organization-address-city>Seattle</owner-organization-address-city>
      <owner-organization-address-state>WA</owner-organization-address-state>
      <owner-organization-address-zip>98115</owner-organization-address-zip>
      <owner-organization-address-country>USA</owner-organization-address-country>
      <owner-organization-phone/>
      <owner-organization-url>https://www.afsc.noaa.gov</owner-organization-url>
      <owner-organization-business-hours>0700-1700 Pacific Time</owner-organization-business-hours>
      <owner-organization-group-id>1001</owner-organization-group-id>
      <publication-status>Public</publication-status>
      <is-do-not-publish>No</is-do-not-publish>
      <metadata-last-review-date>2018-09-26</metadata-last-review-date>
      <metadata-review-frequency>1 Year</metadata-review-frequency>
      <metadata-next-review-date>2019-09-26</metadata-next-review-date>
   </catalog-details>
</inport-metadata>
