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: VALID_FISHERY

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

Summary

Description

List down valid fishery deails

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
FISHERY_ID
NUMBER 		FISHERY_ID
PLAN
VARCHAR2 		FMP PLAN
CAT
VARCHAR2 		Category
PERMIT_YEAR
NUMBER 		Permit Year
DESCR
VARCHAR2 		Description
MORATORIUM_FISHERY
CHAR 		MORATORIUM_FISHERY
DAS_PRINTED
CHAR 		DAS_PRINTED
MANDATORY_REPORTING
CHAR 		MANDATORY_REPORTING
PER_YR_START_DATE
DATE 		Start Date
PER_YR_END_DATE
DATE 		End Date
PRINT_ORDER
NUMBER 		PRINT ORDER
EARLY_ISSUE_DATE
DATE 		EARLY_ISSUE_DATE
EXTENSION_DATE
DATE 		EXTENSION_DATE
PRINT_GROUP_NUM
NUMBER 		PRINT_GROUP_NUM
DAS_MORATORIUM
CHAR 		DAS_MORATORIUM

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: VALID_FISHERY
Short Name: VALID_FISHERY
Status: Completed
Notes:

Loaded by batch 1579, 09-04-2007 12:20

Entity Information

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

List down valid fishery deails

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 FISHERY_ID NUMBER FISHERY_ID
100
 PLAN VARCHAR2 FMP PLAN
100
 CAT VARCHAR2 Category
100
 PERMIT_YEAR NUMBER Permit Year
100
 DESCR VARCHAR2 Description
100
 MORATORIUM_FISHERY CHAR MORATORIUM_FISHERY
100
 DAS_PRINTED CHAR DAS_PRINTED
100
 MANDATORY_REPORTING CHAR MANDATORY_REPORTING
100
 PER_YR_START_DATE DATE Start Date
100
 PER_YR_END_DATE DATE End Date
100
 PRINT_ORDER NUMBER PRINT ORDER
100
 EARLY_ISSUE_DATE DATE EARLY_ISSUE_DATE
100
 EXTENSION_DATE DATE EXTENSION_DATE
100
 PRINT_GROUP_NUM NUMBER PRINT_GROUP_NUM
100
 DAS_MORATORIUM CHAR DAS_MORATORIUM

Attribute Details

FISHERY_ID

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

FISHERY_ID
General Data Type: NUMBER

PLAN

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

FMP PLAN
General Data Type: VARCHAR2

CAT

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

Category
General Data Type: VARCHAR2

PERMIT_YEAR

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

Permit Year
General Data Type: NUMBER

DESCR

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

Description
General Data Type: VARCHAR2

MORATORIUM_FISHERY

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

MORATORIUM_FISHERY
General Data Type: CHAR

DAS_PRINTED

CC ID: 14600
Seq. Order: 7
Data Storage Type: CHAR
Max Length: 1
Required: Yes
Primary Key: No
Status: Active
Description:

DAS_PRINTED
General Data Type: CHAR

MANDATORY_REPORTING

CC ID: 14605
Seq. Order: 8
Data Storage Type: CHAR
Max Length: 1
Required: Yes
Primary Key: No
Status: Active
Description:

MANDATORY_REPORTING
General Data Type: CHAR

PER_YR_START_DATE

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

Start Date
General Data Type: DATE

PER_YR_END_DATE

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

End Date
General Data Type: DATE

PRINT_ORDER

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

PRINT ORDER
General Data Type: NUMBER

EARLY_ISSUE_DATE

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

EARLY_ISSUE_DATE
General Data Type: DATE

EXTENSION_DATE

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

EXTENSION_DATE
General Data Type: DATE

PRINT_GROUP_NUM

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

PRINT_GROUP_NUM
General Data Type: NUMBER

DAS_MORATORIUM

CC ID: 14599
Seq. Order: 15
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

DAS_MORATORIUM
General Data Type: CHAR

Catalog Details

Catalog Item ID: 5118
GUID: gov.noaa.nmfs.inport:5118
Metadata Record Created By: SysAdmin InPortAdmin
Metadata Record Created: 2007-09-04 12:20+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+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