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 >

DEAL_QUOTAS

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

Summary

Abstract

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

Description

Data management table to track dealer 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
YEAR
NUMBER 		4-digit quota year
STATE_ABB
VARCHAR2 		State name
NESPP3
VARCHAR2 		3-digit number assigned to the NE species that 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
PERIOD
VARCHAR2 		Type of quota period (i.e. "Period I"), naming conventions will be standardized through an interface
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: DEAL_QUOTAS
Short Name: DEAL_QUOTAS
Status: Completed
Abstract:

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

Entity Information

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

Data management table to track dealer 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
100
 YEAR NUMBER 4-digit quota year
100
 STATE_ABB VARCHAR2 State name
100
 NESPP3 VARCHAR2 3-digit number assigned to the NE species that 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
 PERIOD VARCHAR2 Type of quota period (i.e. "Period I"), naming conventions will be standardized through an interface
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: 841471
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

YEAR

CC ID: 841473
Seq. Order: 2
Data Storage Type: NUMBER
Max Length: 4
Required: Yes
Primary Key: No
Status: Active
Description:

4-digit quota year

STATE_ABB

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

State name

NESPP3

CC ID: 841538
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

QUOTA_LBS

CC ID: 841539
Seq. Order: 5
Data Storage Type: NUMBER
Max Length: 9
Required: No
Primary Key: No
Status: Active
Description:

Set pounds quota limit

STATUS

CC ID: 841541
Seq. Order: 6
Data Storage Type: NUMBER
Max Length: 1
Required: Yes
Primary Key: No
Status: Active
Description:

Current status of quota: 0 = open [Default]; 1 = closed

OPEN_DATE

CC ID: 841542
Seq. Order: 7
Data Storage Type: DATE
Required: No
Primary Key: No
Status: Active
Description:

Date the quota period opened

CLOSE_DATE

CC ID: 841543
Seq. Order: 8
Data Storage Type: DATE
Required: No
Primary Key: No
Status: Active
Description:

Date the quota period closed

PERIOD

CC ID: 841544
Seq. Order: 9
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

UE

CC ID: 841545
Seq. Order: 10
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Oracle user used to create record

DE

CC ID: 841546
Seq. Order: 11
Data Storage Type: DATE
Required: No
Primary Key: No
Status: Active
Description:

Date the record was entered/created

UC

CC ID: 841547
Seq. Order: 12
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Oracle user that most recently altered record

DC

CC ID: 841548
Seq. Order: 13
Data Storage Type: DATE
Required: No
Primary Key: No
Status: Active
Description:

Date the record was altered

COMMENTS

CC ID: 841549
Seq. Order: 14
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Special comments on quota

Catalog Details

Catalog Item ID: 56397
GUID: gov.noaa.nmfs.inport:56397
Metadata Record Created By: Sandeep Thumma
Metadata Record Created: 2019-05-23 11:29+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2019-05-23
Owner Org: GARFO
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2019-05-23
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2020-05-23