Maintenance Notice: Tuesday May 21 @ 12pm-1:30pm Eastern. InPort and its associated services will be under maintenance and unavailable for the deployment of InPort Release 5.3.6. Downtime Schedule Tuesday, May 21, 2024 12:00pm - 1:30pm Eastern / 9:00am - 10:30am Pacific / 6:00am - 8:30am Hawaii Impacted Areas - InPort Website: https://www.fisheries.noaa.gov/inport - InPort WAF: h...
View All
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
no-comment
PERSON_ID
NUMBER
no-comment
COMPANY_NAME
VARCHAR2
no-comment
LAST_NAME
VARCHAR2
no-comment
FIRST_NAME
VARCHAR2
no-comment
MI
VARCHAR2
no-comment
SUFFIX
VARCHAR2
no-comment
ADDRESS_1
VARCHAR2
no-comment
ADDRESS_2
VARCHAR2
no-comment
CITY
VARCHAR2
no-comment
STATE
VARCHAR2
no-comment
COUNTRY
VARCHAR2
no-comment
ZIP
VARCHAR2
no-comment
PHONE
VARCHAR2
no-comment
CELL
VARCHAR2
no-comment
FAX
VARCHAR2
no-comment
EMAIL
VARCHAR2
no-comment
RMD_CHANGED_BY
VARCHAR2
no-comment
RMD_TS_CHANGED
TIMESTAMP(6)
no-comment
RMD_ACTION
VARCHAR2
no-comment
RMD_CHANGE_COMMENT
VARCHAR2
no-comment
SOURCE
VARCHAR2
no-comment
CFEC_ID
NUMBER
no-comment

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: Table: ATL_LOV_VESSEL_CONTACT
Short Name: ATL_LOV_VESSEL_CONTACT
Status: Completed
Abstract:

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

Notes:

Loaded by batch 3994, 01-03-2013 16:38

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
Primary Key VESSEL_CONTACT_SEQ NUMBER no-comment
100
PERSON_ID NUMBER no-comment
100
COMPANY_NAME VARCHAR2 no-comment
100
LAST_NAME VARCHAR2 no-comment
100
FIRST_NAME VARCHAR2 no-comment
100
MI VARCHAR2 no-comment
100
SUFFIX VARCHAR2 no-comment
100
ADDRESS_1 VARCHAR2 no-comment
100
ADDRESS_2 VARCHAR2 no-comment
100
CITY VARCHAR2 no-comment
100
STATE VARCHAR2 no-comment
100
COUNTRY VARCHAR2 no-comment
100
ZIP VARCHAR2 no-comment
100
PHONE VARCHAR2 no-comment
100
CELL VARCHAR2 no-comment
100
FAX VARCHAR2 no-comment
100
EMAIL VARCHAR2 no-comment
100
RMD_CHANGED_BY VARCHAR2 no-comment
100
RMD_TS_CHANGED TIMESTAMP(6) no-comment
100
RMD_ACTION VARCHAR2 no-comment
100
RMD_CHANGE_COMMENT VARCHAR2 no-comment
100
SOURCE VARCHAR2 no-comment
100
CFEC_ID NUMBER no-comment

Attribute Details

VESSEL_CONTACT_SEQ

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

no-comment

General Data Type: NUMBER

PERSON_ID

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

no-comment

General Data Type: NUMBER

COMPANY_NAME

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

no-comment

General Data Type: VARCHAR2

LAST_NAME

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

no-comment

General Data Type: VARCHAR2

FIRST_NAME

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

no-comment

General Data Type: VARCHAR2

MI

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

no-comment

General Data Type: VARCHAR2

SUFFIX

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

no-comment

General Data Type: VARCHAR2

ADDRESS_1

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

no-comment

General Data Type: VARCHAR2

ADDRESS_2

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

no-comment

General Data Type: VARCHAR2

CITY

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

no-comment

General Data Type: VARCHAR2

STATE

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

no-comment

General Data Type: VARCHAR2

COUNTRY

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

no-comment

General Data Type: VARCHAR2

ZIP

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

no-comment

General Data Type: VARCHAR2

PHONE

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

no-comment

General Data Type: VARCHAR2

CELL

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

no-comment

General Data Type: VARCHAR2

FAX

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

no-comment

General Data Type: VARCHAR2

EMAIL

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

no-comment

General Data Type: VARCHAR2

RMD_CHANGED_BY

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

no-comment

General Data Type: VARCHAR2

RMD_TS_CHANGED

CC ID: 84519
Seq. Order: 19
Data Storage Type: TIMESTAMP(6)
Max Length: 11
Required: No
Primary Key: No
Scale: 6
Status: Active
Description:

no-comment

General Data Type: TIMESTAMP(6)

RMD_ACTION

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

no-comment

General Data Type: VARCHAR2

RMD_CHANGE_COMMENT

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

no-comment

General Data Type: VARCHAR2

SOURCE

CC ID: 84522
Seq. Order: 22
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

no-comment

General Data Type: VARCHAR2

CFEC_ID

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

no-comment

General Data Type: NUMBER

Catalog Details

Catalog Item ID: 17397
GUID: gov.noaa.nmfs.inport:17397
Metadata Record Created By: Doug Turnbull
Metadata Record Created: 2013-01-03 16:38+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-05-18
Owner Org: AFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-05-18
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-05-18