Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

The lov_vessel_contact table is populated from the core contact from v_demographic view from akr1(AKR database).

Description

The lov_vessel_contact table is populated from the core contact from v_demographic view from akr1(AKR database).

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
VESSEL_CONTACT_SEQ
NUMBER
Sequence Generated unique identifier of a vessel contact.
PERSON_ID
NUMBER
Unique identifier generated in AKR database. Used in foreign key relationship with atl_lov_vessel.
COMPANY_NAME
VARCHAR2
Primary/core contact company for the vessel. At least one of Company_name or Last_name must be populated.
LAST_NAME
VARCHAR2
Primary/core contact person's last name for the vessel. At least one of Company_name or Last_name must be populated.
FIRST_NAME
VARCHAR2
Primary/core contact person's first name for the vessel.
MI
VARCHAR2
Primary/core contact person's middle initial for the vessel.
SUFFIX
VARCHAR2
Primary/core contact person's suffix for the vessel.
ADDRESS_1
VARCHAR2
Main address line for number, street, etc.
ADDRESS_2
VARCHAR2
Additional address line usually for suite, etc.
CITY
VARCHAR2
Address city.
STATE
VARCHAR2
State or Province of address
COUNTRY
VARCHAR2
Address Country
ZIP
VARCHAR2
Postal code.
PHONE
VARCHAR2
Phone number for the contact.
CELL
VARCHAR2
Mobile phone number for the contact.
FAX
VARCHAR2
Primary fax number for the contact.
EMAIL
VARCHAR2
Primary email addres for the contact
RMD_CHANGED_BY
VARCHAR2
The user who changed the record lastly.
RMD_TS_CHANGED
TIMESTAMP
The date on which the record was changed lastly.
RMD_ACTION
VARCHAR2
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.
RMD_CHANGE_COMMENT
VARCHAR2
Comment on changing(updating) record.
ALTERNATE_PHONE
VARCHAR2
Alternate phone number for the contact.

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (AFSC) for inquiries on this record.

Item Identification

Title: ATL_LOV_VESSEL_CONTACT
Short Name: ATL_LOV_VESSEL_CONTACT
Status: In Work
Abstract:

The lov_vessel_contact table is populated from the core contact from v_demographic view from akr1(AKR database).

Purpose:

Provides the list of possible (identified) vessel owners or managers from which the contact may be determined for vessel selection within the restructure program,

Notes:

Added by Martin Park to support Observer Restructure Project

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: NORPAC
Description:

The lov_vessel_contact table is populated from the core contact from v_demographic view from akr1(AKR database).

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
VESSEL_CONTACT_SEQ NUMBER Sequence Generated unique identifier of a vessel contact.
100
PERSON_ID NUMBER Unique identifier generated in AKR database. Used in foreign key relationship with atl_lov_vessel.
100
COMPANY_NAME VARCHAR2 Primary/core contact company for the vessel. At least one of Company_name or Last_name must be populated.
100
LAST_NAME VARCHAR2 Primary/core contact person's last name for the vessel. At least one of Company_name or Last_name must be populated.
100
FIRST_NAME VARCHAR2 Primary/core contact person's first name for the vessel.
100
MI VARCHAR2 Primary/core contact person's middle initial for the vessel.
100
SUFFIX VARCHAR2 Primary/core contact person's suffix for the vessel.
100
ADDRESS_1 VARCHAR2 Main address line for number, street, etc.
100
ADDRESS_2 VARCHAR2 Additional address line usually for suite, etc.
100
CITY VARCHAR2 Address city.
100
STATE VARCHAR2 State or Province of address
100
COUNTRY VARCHAR2 Address Country
100
ZIP VARCHAR2 Postal code.
100
PHONE VARCHAR2 Phone number for the contact.
100
CELL VARCHAR2 Mobile phone number for the contact.
100
FAX VARCHAR2 Primary fax number for the contact.
100
EMAIL VARCHAR2 Primary email addres for the contact
100
RMD_CHANGED_BY VARCHAR2 The user who changed the record lastly.
100
RMD_TS_CHANGED TIMESTAMP The date on which the record was changed lastly.
100
RMD_ACTION VARCHAR2 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.
100
RMD_CHANGE_COMMENT VARCHAR2 Comment on changing(updating) record.
100
ALTERNATE_PHONE VARCHAR2 Alternate phone number for the contact.

Attribute Details

VESSEL_CONTACT_SEQ

CC ID: 67542
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Sequence Generated unique identifier of a vessel contact.

PERSON_ID

CC ID: 67543
Seq. Order: 2
Data Storage Type: NUMBER
Max Length: 6
Required: No
Primary Key: No
Precision: 6
Scale: 0
Status: Active
Description:

Unique identifier generated in AKR database. Used in foreign key relationship with atl_lov_vessel.

COMPANY_NAME

CC ID: 67544
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 80
Required: No
Primary Key: No
Status: Active
Description:

Primary/core contact company for the vessel. At least one of Company_name or Last_name must be populated.

LAST_NAME

CC ID: 67545
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Primary/core contact person's last name for the vessel. At least one of Company_name or Last_name must be populated.

FIRST_NAME

CC ID: 67546
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Primary/core contact person's first name for the vessel.

MI

CC ID: 67547
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Primary/core contact person's middle initial for the vessel.

SUFFIX

CC ID: 67548
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

Primary/core contact person's suffix for the vessel.

ADDRESS_1

CC ID: 67549
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 45
Required: No
Primary Key: No
Status: Active
Description:

Main address line for number, street, etc.

ADDRESS_2

CC ID: 67550
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Additional address line usually for suite, etc.

CITY

CC ID: 67551
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Address city.

STATE

CC ID: 67552
Seq. Order: 11
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

State or Province of address

COUNTRY

CC ID: 67553
Seq. Order: 12
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Address Country

ZIP

CC ID: 67554
Seq. Order: 13
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Postal code.

PHONE

CC ID: 67555
Seq. Order: 14
Data Storage Type: VARCHAR2
Max Length: 16
Required: No
Primary Key: No
Status: Active
Description:

Phone number for the contact.

CELL

CC ID: 67561
Seq. Order: 15
Data Storage Type: VARCHAR2
Max Length: 16
Required: No
Primary Key: No
Status: Active
Description:

Mobile phone number for the contact.

FAX

CC ID: 67562
Seq. Order: 16
Data Storage Type: VARCHAR2
Max Length: 16
Required: No
Primary Key: No
Status: Active
Description:

Primary fax number for the contact.

EMAIL

CC ID: 67556
Seq. Order: 20
Data Storage Type: VARCHAR2
Max Length: 60
Required: No
Primary Key: No
Status: Active
Description:

Primary email addres for the contact

RMD_CHANGED_BY

CC ID: 67557
Seq. Order: 21
Data Storage Type: VARCHAR2
Max Length: 100
Required: No
Primary Key: No
Status: Active
Description:

The user who changed the record lastly.

RMD_TS_CHANGED

CC ID: 67558
Seq. Order: 22
Data Storage Type: TIMESTAMP
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

The date on which the record was changed lastly.

RMD_ACTION

CC ID: 67559
Seq. Order: 23
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

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.

RMD_CHANGE_COMMENT

CC ID: 67560
Seq. Order: 24
Data Storage Type: VARCHAR2
Max Length: 4000
Required: No
Primary Key: No
Status: Active
Description:

Comment on changing(updating) record.

ALTERNATE_PHONE

CC ID: 786496
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Alternate phone number for the contact.

Catalog Details

Catalog Item ID: 12658
GUID: gov.noaa.nmfs.inport:12658
Metadata Record Created By: Doug Turnbull
Metadata Record Created: 2012-07-18 14:03+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2018-10-05
Owner Org: AFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2018-10-05
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2019-10-05