Metadata Rubric

100%

6 / 6

GARFO Metadata Library > _Information Resources Management (IRM) Divisio... > Vessel Permit System > Vessel Permit System Data Set >

Table: VPS_OWNER

Entity (ENT) | Greater Atlantic Regional Fisheries Office (GARFO)
GUID: gov.noaa.nmfs.inport:4016 | Updated: August 9, 2022 | Published / External

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

Holds data for owners whose vessels are permitted by the National Marine Fisheries Service (NMFS), Northeast Region

Description

Holds data for owners whose vessels are permitted by the National Marine Fisheries Service (NMFS), Northeast Region

Entity Type
Data Table

Data Attribute / Type	Description
AP_YEAR NUMBER	Application year (aka permit year) that is being issued
AP_NUM NUMBER	Application number - connects owner record to a unique vessel application
VP_NUM NUMBER	Vessel permit number - note that this is not utilized - it is a holdover from the old VAX system
DE DATE	Date of entry - Date an owner record is entered
UE VARCHAR2	User of change - User that changed the owner record
DC DATE	Date of change - Date an owner record is changed
UC VARCHAR2	User Changed
RANK NUMBER	Determines an owner's ranking - rank 1 is the primary owner, rank 2 is the secondary owner, etc.
NAME_FIRST VARCHAR2	First name of the vessel owner
NAME_MIDDLE VARCHAR2	MIddle name or initial of the vessel owner
NAME_LAST VARCHAR2	Last name of the vessel owner
NAME_SUFFIX VARCHAR2	Suffix (Esq, Sr., etc) of the vessel owner
CORP_NAME VARCHAR2	Corporation name - a vessel may be owned by a corporation

Data Attribute / Type

Description

AP_YEAR
NUMBER

Application year (aka permit year) that is being issued

AP_NUM
NUMBER

Application number - connects owner record to a unique vessel application

VP_NUM
NUMBER

Vessel permit number - note that this is not utilized - it is a holdover from the old VAX system

DE
DATE

Date of entry - Date an owner record is entered

UE
VARCHAR2

User of change - User that changed the owner record

DC
DATE

Date of change - Date an owner record is changed

UC
VARCHAR2

User Changed

RANK
NUMBER

Determines an owner's ranking - rank 1 is the primary owner, rank 2 is the secondary owner, etc.

NAME_FIRST
VARCHAR2

First name of the vessel owner

NAME_MIDDLE
VARCHAR2

MIddle name or initial of the vessel owner

NAME_LAST
VARCHAR2

Last name of the vessel owner

NAME_SUFFIX
VARCHAR2

Suffix (Esq, Sr., etc) of the vessel owner

CORP_NAME
VARCHAR2

Corporation name - a vessel may be owned by a corporation

No Child Items for this record.

No contact information is available for this record.

Please contact the owner organization (GARFO) for inquiries on this record.

Title:	Table: VPS_OWNER
Short Name:	VPS_OWNER
Status:	Completed
Abstract:	Holds data for owners whose vessels are permitted by the National Marine Fisheries Service (NMFS), Northeast Region
Notes:	Loaded by batch 1412, 04-20-2007 11:55

Entity Type:	Data Table
Active Version?:	Yes
Schema Name:	PERMIT
Description:	Holds data for owners whose vessels are permitted by the National Marine Fisheries Service (NMFS), Northeast Region

Attribute Summary

	Name	Type	Description
100	AP_YEAR	NUMBER	Application year (aka permit year) that is being issued
100	AP_NUM	NUMBER	Application number - connects owner record to a unique vessel application
100	VP_NUM	NUMBER	Vessel permit number - note that this is not utilized - it is a holdover from the old VAX system
100	DE	DATE	Date of entry - Date an owner record is entered
100	UE	VARCHAR2	User of change - User that changed the owner record
100	DC	DATE	Date of change - Date an owner record is changed
100	UC	VARCHAR2	User Changed
100	RANK	NUMBER	Determines an owner's ranking - rank 1 is the primary owner, rank 2 is the secondary owner, etc.
100	NAME_FIRST	VARCHAR2	First name of the vessel owner
100	NAME_MIDDLE	VARCHAR2	MIddle name or initial of the vessel owner
100	NAME_LAST	VARCHAR2	Last name of the vessel owner
100	NAME_SUFFIX	VARCHAR2	Suffix (Esq, Sr., etc) of the vessel owner
100	CORP_NAME	VARCHAR2	Corporation name - a vessel may be owned by a corporation

Name

Type

Description

100

AP_YEAR

NUMBER

Application year (aka permit year) that is being issued

100

AP_NUM

NUMBER

Application number - connects owner record to a unique vessel application

100

VP_NUM

NUMBER

Vessel permit number - note that this is not utilized - it is a holdover from the old VAX system

100

DATE

Date of entry - Date an owner record is entered

100

VARCHAR2

User of change - User that changed the owner record

100

DATE

Date of change - Date an owner record is changed

100

VARCHAR2

User Changed

100

RANK

NUMBER

Determines an owner's ranking - rank 1 is the primary owner, rank 2 is the secondary owner, etc.

100

NAME_FIRST

VARCHAR2

First name of the vessel owner

100

NAME_MIDDLE

VARCHAR2

MIddle name or initial of the vessel owner

100

NAME_LAST

VARCHAR2

Last name of the vessel owner

100

NAME_SUFFIX

VARCHAR2

Suffix (Esq, Sr., etc) of the vessel owner

100

CORP_NAME

VARCHAR2

Corporation name - a vessel may be owned by a corporation

Attribute Details

AP_YEAR

CC ID: 7926

Seq. Order:	1
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	Application year (aka permit year) that is being issued
General Data Type:	NUMBER

AP_NUM

CC ID: 7925

Seq. Order:	2
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	Yes
Precision:	7
Scale:	0
Status:	Active
Description:	Application number - connects owner record to a unique vessel application
General Data Type:	NUMBER

VP_NUM

CC ID: 7937

Seq. Order:	3
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	6
Scale:	0
Status:	Active
Description:	Vessel permit number - note that this is not utilized - it is a holdover from the old VAX system
General Data Type:	NUMBER

DE

CC ID: 7929

Seq. Order:	4
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	Date of entry - Date an owner record is entered
General Data Type:	DATE

UE

CC ID: 7936

Seq. Order:	5
Data Storage Type:	VARCHAR2
Max Length:	12
Required:	No
Primary Key:	No
Status:	Active
Description:	User of change - User that changed the owner record
General Data Type:	VARCHAR2

DC

CC ID: 7928

Seq. Order:	6
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	Date of change - Date an owner record is changed
General Data Type:	DATE

UC

CC ID: 7935

Seq. Order:	7
Data Storage Type:	VARCHAR2
Max Length:	12
Required:	No
Primary Key:	No
Status:	Active
Description:	User Changed
General Data Type:	VARCHAR2

RANK

CC ID: 7934

Seq. Order:	8
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	Yes
Precision:	2
Scale:	0
Status:	Active
Description:	Determines an owner's ranking - rank 1 is the primary owner, rank 2 is the secondary owner, etc.
General Data Type:	NUMBER

NAME_FIRST

CC ID: 7930

Seq. Order:	9
Data Storage Type:	VARCHAR2
Max Length:	20
Required:	No
Primary Key:	No
Status:	Active
Description:	First name of the vessel owner
General Data Type:	VARCHAR2

NAME_MIDDLE

CC ID: 7932

Seq. Order:	10
Data Storage Type:	VARCHAR2
Max Length:	20
Required:	No
Primary Key:	No
Status:	Active
Description:	MIddle name or initial of the vessel owner
General Data Type:	VARCHAR2

NAME_LAST

CC ID: 7931

Seq. Order:	11
Data Storage Type:	VARCHAR2
Max Length:	20
Required:	No
Primary Key:	No
Status:	Active
Description:	Last name of the vessel owner
General Data Type:	VARCHAR2

NAME_SUFFIX

CC ID: 7933

Seq. Order:	12
Data Storage Type:	VARCHAR2
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	Suffix (Esq, Sr., etc) of the vessel owner
General Data Type:	VARCHAR2

CORP_NAME

CC ID: 7927

Seq. Order:	13
Data Storage Type:	VARCHAR2
Max Length:	40
Required:	No
Primary Key:	No
Status:	Active
Description:	Corporation name - a vessel may be owned by a corporation
General Data Type:	VARCHAR2

Catalog Item ID:	4016
GUID:	gov.noaa.nmfs.inport:4016
Metadata Record Created By:	Dave Gouveia
Metadata Record Created:	2007-04-20 11:55+0000
Metadata Record Last Modified By:	SysAdmin InPortAdmin
Metadata Record Last Modified:	2022-08-09 17:10+0000
Metadata Record Published:	2016-02-29
Owner Org:	GARFO
Metadata Publication Status:	Published Externally
Do Not Publish?:	N
Metadata Last Review Date:	2016-02-29
Metadata Review Frequency:	1 Year
Metadata Next Review Date:	2017-02-28

Table: VPS_OWNER

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

AP_YEAR

AP_NUM

VP_NUM

DE

UE

DC

UC

RANK

NAME_FIRST

NAME_MIDDLE

NAME_LAST

NAME_SUFFIX

CORP_NAME

Catalog Details