ATL_LOV_VESSEL_CONTACT
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:12658 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
The lov_vessel_contact table is populated from the core contact from v_demographic view from akr1(AKR database).
DescriptionThe 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
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
|
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
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
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
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
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
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
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
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
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
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
Seq. Order: | 10 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 40 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Address city. |
STATE
Seq. Order: | 11 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 5 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
State or Province of address |
COUNTRY
Seq. Order: | 12 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 10 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Address Country |
ZIP
Seq. Order: | 13 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 10 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Postal code. |
PHONE
Seq. Order: | 14 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 16 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Phone number for the contact. |
CELL
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
Seq. Order: | 16 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 16 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Primary fax number for the contact. |
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
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
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
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
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
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 |