Slide Menu
Jump to Section...
Maintenance Notice: Tuesday May 21 @ 12pm-1:30pm Eastern. InPort and its associated services will be under maintenance and unavailable for the deployment of InPort Release 5.3.6. Downtime Schedule Tuesday, May 21, 2024 12:00pm - 1:30pm Eastern / 9:00am - 10:30am Pacific / 6:00am - 8:30am Hawaii Impacted Areas - InPort Website: https://www.fisheries.noaa.gov/inport - InPort WAF: h...
View All
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 

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