ATL_LOV_VESSEL_CONTACT
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:12658 | Updated: August 9, 2022 | Published / External
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 |