12658 ATL_LOV_VESSEL_CONTACT Entity Published / External 7284 AFSC/FMA/North Pacific Groundfish and Halibut Observer Program, Post 2008 Fishery Statistics. Data Set In Work The lov_vessel_contact table is populated from the core contact from v_demographic view from akr1(AKR database). Provides the list of possible (identified) vessel owners or managers from which the contact may be determined for vessel selection within the restructure program, Added by Martin Park to support Observer Restructure Project Data Table Yes NORPAC The lov_vessel_contact table is populated from the core contact from v_demographic view from akr1(AKR database). ALTERNATE_PHONE VARCHAR2 No No Active Alternate phone number for the contact. 1 VESSEL_CONTACT_SEQ NUMBER 22 No No Active Sequence Generated unique identifier of a vessel contact. 2 PERSON_ID NUMBER 6 No No 6 0 Active Unique identifier generated in AKR database. Used in foreign key relationship with atl_lov_vessel. 3 COMPANY_NAME VARCHAR2 80 No No Active Primary/core contact company for the vessel. At least one of Company_name or Last_name must be populated. 4 LAST_NAME VARCHAR2 20 No No Active Primary/core contact person's last name for the vessel. At least one of Company_name or Last_name must be populated. 5 FIRST_NAME VARCHAR2 20 No No Active Primary/core contact person's first name for the vessel. 6 MI VARCHAR2 1 No No Active Primary/core contact person's middle initial for the vessel. 7 SUFFIX VARCHAR2 5 No No Active Primary/core contact person's suffix for the vessel. 8 ADDRESS_1 VARCHAR2 45 No No Active Main address line for number, street, etc. 9 ADDRESS_2 VARCHAR2 40 No No Active Additional address line usually for suite, etc. 10 CITY VARCHAR2 40 No No Active Address city. 11 STATE VARCHAR2 5 No No Active State or Province of address 12 COUNTRY VARCHAR2 10 No No Active Address Country 13 ZIP VARCHAR2 10 No No Active Postal code. 14 PHONE VARCHAR2 16 No No Active Phone number for the contact. 15 CELL VARCHAR2 16 No No Active Mobile phone number for the contact. 16 FAX VARCHAR2 16 No No Active Primary fax number for the contact. 20 EMAIL VARCHAR2 60 No No Active Primary email addres for the contact 21 RMD_CHANGED_BY VARCHAR2 100 No No Active The user who changed the record lastly. 22 RMD_TS_CHANGED TIMESTAMP 10 No No Active The date on which the record was changed lastly. 23 RMD_ACTION VARCHAR2 2 No No Active last action performed on the record. "I" for Inserting, "U" for Updating, "Rv" for Reverting to a previous record state, "Rc" for recovered from a deletion and "D" for Deleting. "D" only recorded on history record. 24 RMD_CHANGE_COMMENT VARCHAR2 4000 No No Active Comment on changing(updating) record. gov.noaa.nmfs.inport:12658 Doug Turnbull 2012-07-18T14:03:40 SysAdmin InPortAdmin 2022-08-09T17:11:04 2018-10-05 Alaska Fisheries Science Center AFSC 7600 Sand Point Way N.E., Building 4 Seattle WA 98115 USA https://www.afsc.noaa.gov 0700-1700 Pacific Time 1001 Public No 2018-10-05 1 Year 2019-10-05