Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
Alaska Fisheries Science Center Metadata Librar... > Fisheries Management and Analysis Division > Custom User Authentication > AFSC/FMA/CAMS Data Objects >

Table: ATL_LOV_VESSEL_CONTACT

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