Metadata Rubric

100%

6 / 6

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

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

	Name	Type	Description
100	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

Name

Type

Description

100

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

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

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