Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
GARFO Metadata Library > _Information Resources Management (IRM) Divisio... > Vessel Permit System > Vessel Permit System Data Set >

Table: VPS_GEAR

Entity (ENT)  |  Greater Atlantic Regional Fisheries Office (GARFO)
GUID: gov.noaa.nmfs.inport:4018  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Holds data for fishing gear used for a vessel's permitted fisheries

Description

Holds data for fishing gear used for a vessel's permitted fisheries

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
AP_YEAR
NUMBER 		Application year (aka permit year) of a permitted gear
AP_NUM
NUMBER 		Application number - connects gear record to a unique vessel application
VP_NUM
NUMBER 		Vessel permit number
RANK
NUMBER 		Rank of a gear - determines order of display
PLAN
VARCHAR2 		Fishery management plan
CAT
VARCHAR2 		Category of a fishery management plan
TOG
NUMBER 		Type of gear used for a fishery management plan by a vessel
DE
DATE 		Date entered
UE
VARCHAR2 		User of entry
DC
DATE 		Date Changed
UC
VARCHAR2 		User Changed

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

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

Item Identification

Title: Table: VPS_GEAR
Short Name: VPS_GEAR
Status: Completed
Abstract:

Holds data for fishing gear used for a vessel's permitted fisheries
Notes:

Loaded by batch 1413, 04-20-2007 12:05

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: PERMIT
Description:

Holds data for fishing gear used for a vessel's permitted fisheries

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 AP_YEAR NUMBER Application year (aka permit year) of a permitted gear
100
 AP_NUM NUMBER Application number - connects gear record to a unique vessel application
100
 VP_NUM NUMBER Vessel permit number
100
 RANK NUMBER Rank of a gear - determines order of display
100
 PLAN VARCHAR2 Fishery management plan
100
 CAT VARCHAR2 Category of a fishery management plan
100
 TOG NUMBER Type of gear used for a fishery management plan by a vessel
100
 DE DATE Date entered
100
 UE VARCHAR2 User of entry
100
 DC DATE Date Changed
100
 UC VARCHAR2 User Changed

Attribute Details

AP_YEAR

CC ID: 7956
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) of a permitted gear
General Data Type: NUMBER

AP_NUM

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

Application number - connects gear record to a unique vessel application
General Data Type: NUMBER

VP_NUM

CC ID: 7965
Seq. Order: 3
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 6
Scale: 0
Status: Active
Description:

Vessel permit number
General Data Type: NUMBER

RANK

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

Rank of a gear - determines order of display
General Data Type: NUMBER

PLAN

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

Fishery management plan
General Data Type: VARCHAR2

CAT

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

Category of a fishery management plan
General Data Type: VARCHAR2

TOG

CC ID: 7962
Seq. Order: 7
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

Type of gear used for a fishery management plan by a vessel
General Data Type: NUMBER

DE

CC ID: 7959
Seq. Order: 8
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date entered
General Data Type: DATE

UE

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

User of entry
General Data Type: VARCHAR2

DC

CC ID: 7958
Seq. Order: 10
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date Changed
General Data Type: DATE

UC

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

User Changed
General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 4018
GUID: gov.noaa.nmfs.inport:4018
Metadata Record Created By: Dave Gouveia
Metadata Record Created: 2007-04-20 12:05+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