Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
GARFO Metadata Library > _Analysis and Program Support Division (APSD) M... > Catch and Effort Monitoring > Quota Monitoring > Quota Monitoring Data Set >

Table: VESS_QUOTAS

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

Summary

Abstract

Data management table to track vessel quota values. Used as a reference for reports.

Description

Data management table to track vessel quota values. Used as a reference for reports.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
QUOTA_ID
VARCHAR2 		Unique number for a vessel quota record based on the sequence: vessquotaid_seq
YEAR
NUMBER 		4-digit quota year
PERIOD
VARCHAR2 		Type of quota period (i.e. "Period I"), naming conventions will be standardized through an interface
NESPP3
VARCHAR2 		3-digit number assigned to the NE species that the quota applies to
PERMIT_TYPE
VARCHAR2 		3-letter code for the permit type that the quota applies to; from permit.dlfsh (sp)
CATEGORY
VARCHAR2 		Category/class of the permit that the quota applies to; from permit.dlfsh (cat)
AREA_NAME
VARCHAR2 		The fishing area the quota applies to
QUOTA_LBS
NUMBER 		Set pounds quota limit
STATUS
NUMBER 		Current status of quota: 0 = open [Default]; 1 = closed
OPEN_DATE
DATE 		Date the quota period opened
CLOSE_DATE
DATE 		Date the quota period closed
UE
VARCHAR2 		Oracle user used to create record
DE
DATE 		Date the record was entered/created
UC
VARCHAR2 		Oracle user that most recently altered record
DC
DATE 		Date the record was altered
COMMENTS
VARCHAR2 		Special comments on quota

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

Data management table to track vessel quota values. Used as a reference for reports.
Notes:

Loaded by batch 1575, 09-04-2007 12:15

Entity Information

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

Data management table to track vessel quota values. Used as a reference for reports.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key QUOTA_ID VARCHAR2 Unique number for a vessel quota record based on the sequence: vessquotaid_seq
100
 YEAR NUMBER 4-digit quota year
100
 PERIOD VARCHAR2 Type of quota period (i.e. "Period I"), naming conventions will be standardized through an interface
100
 NESPP3 VARCHAR2 3-digit number assigned to the NE species that the quota applies to
100
 PERMIT_TYPE VARCHAR2 3-letter code for the permit type that the quota applies to; from permit.dlfsh (sp)
100
 CATEGORY VARCHAR2 Category/class of the permit that the quota applies to; from permit.dlfsh (cat)
100
 AREA_NAME VARCHAR2 The fishing area the quota applies to
100
 QUOTA_LBS NUMBER Set pounds quota limit
100
 STATUS NUMBER Current status of quota: 0 = open [Default]; 1 = closed
100
 OPEN_DATE DATE Date the quota period opened
100
 CLOSE_DATE DATE Date the quota period closed
100
 UE VARCHAR2 Oracle user used to create record
100
 DE DATE Date the record was entered/created
100
 UC VARCHAR2 Oracle user that most recently altered record
100
 DC DATE Date the record was altered
100
 COMMENTS VARCHAR2 Special comments on quota

Attribute Details

QUOTA_ID

CC ID: 13711
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 10
Required: Yes
Primary Key: Yes
Status: Active
Description:

Unique number for a vessel quota record based on the sequence: vessquotaid_seq
General Data Type: VARCHAR2

YEAR

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

4-digit quota year
General Data Type: NUMBER

PERIOD

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

Type of quota period (i.e. "Period I"), naming conventions will be standardized through an interface
General Data Type: VARCHAR2

NESPP3

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

3-digit number assigned to the NE species that the quota applies to
General Data Type: VARCHAR2

PERMIT_TYPE

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

3-letter code for the permit type that the quota applies to; from permit.dlfsh (sp)
General Data Type: VARCHAR2

CATEGORY

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

Category/class of the permit that the quota applies to; from permit.dlfsh (cat)
General Data Type: VARCHAR2

AREA_NAME

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

The fishing area the quota applies to
General Data Type: VARCHAR2

QUOTA_LBS

CC ID: 13712
Seq. Order: 8
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 9
Scale: 0
Status: Active
Description:

Set pounds quota limit
General Data Type: NUMBER

STATUS

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

Current status of quota: 0 = open [Default]; 1 = closed
General Data Type: NUMBER

OPEN_DATE

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

Date the quota period opened
General Data Type: DATE

CLOSE_DATE

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

Date the quota period closed
General Data Type: DATE

UE

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

Oracle user used to create record
General Data Type: VARCHAR2

DE

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

Date the record was entered/created
General Data Type: DATE

UC

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

Oracle user that most recently altered record
General Data Type: VARCHAR2

DC

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

Date the record was altered
General Data Type: DATE

COMMENTS

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

Special comments on quota
General Data Type: VARCHAR2

Catalog Details

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