Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
GARFO Metadata Library > _Sustainable Fisheries Division (SFD) Metadata... > Research Document System > RDD Databases >

Table: EFP_FORM_DATA

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

Summary

Abstract

Form data, main table for RDS

Description

Form data, main table for RDS

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
ID_NUMBER
NUMBER 		Form data primary key
DOCUMENT_NUMBER
VARCHAR2 		Document Number for this form entry
APPLICANT_KEY
NUMBER 		Main applicant
PROJECT_TITLE
VARCHAR2 		Project Title
FUNDING_SOURCE
VARCHAR2 		Funding Source
HARD_COPY_LOCATION
VARCHAR2 		Location of hard copy
DATE_RECEIVED
DATE 		Date application received
DATE_APP_COMPLETED
DATE 		Date application completed
DATE_PERMIT_ISSUED
DATE 		Date permit issued
FINAL_REPORT_SUBMITTED
DATE 		Date final report submitted
START_DATE
DATE 		Permit Start date
END_DATE
DATE 		Permit end date
NEPA
VARCHAR2 		Date NEPA signed
DAS
NUMBER 		Days-at-Sea
FISHING_YEAR
NUMBER 		Fishing year
GEAR
VARCHAR2 		Fishing gear
COMMENTS
VARCHAR2 		General Comments
EXTENSION_DOC_NUMBER
VARCHAR2 		Document number for permit period extention
EXTENSION_REQUEST_RECEIVED
DATE 		Date permit period extension request received
EXTENSION_EFFECTIVE_START
DATE 		Permit period extention start date
APPLICATION_ABANDONED
CHAR 		Date application abandonded
DOCUMENT_TYPE
VARCHAR2 		Document Type (EFP, RSA, LOA, etc)
PI_KEY
NUMBER 		Primary Investigator, foreign key to applicant table
REVIEW_OFFICIAL
VARCHAR2 		Review Official
EFH_LEVEL
VARCHAR2 		EFH level
EFH_COMPLETE
DATE 		Date EFH complete
ESA_INIT
DATE 		Date ESA initialized
ESA_COMPLETE
DATE 		Date ESA complete
CE_FONSI_SIGNED
DATE 		Date FONSI signed
CONSULT_NOTES
VARCHAR2 		Consultation Notes
ESA_LEVEL
VARCHAR2 		ESA Level
RSA_PROGRAM
VARCHAR2 		RSA Program type
INTENDS_TO_FISH
VARCHAR2 		Intends to fish (boolean)
LOA_DEALER_CODE
VARCHAR2 		LOA dealer code
EXTENSION_END_DATE
DATE 		Permit period extention end date

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

Form data, main table for RDS
Notes:

Loaded by batch 3835, 12-12-2012 17:48

Physical Location

Organization: Greater Atlantic Regional Fisheries Office
City: Gloucester
State/Province: MA
Country: USA
Location Description:

Sustainable Fisheries Division

55 Great Republic Drive

Entity Information

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

Form data, main table for RDS

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key ID_NUMBER NUMBER Form data primary key
100
 DOCUMENT_NUMBER VARCHAR2 Document Number for this form entry
100
 APPLICANT_KEY NUMBER Main applicant
100
 PROJECT_TITLE VARCHAR2 Project Title
100
 FUNDING_SOURCE VARCHAR2 Funding Source
100
 HARD_COPY_LOCATION VARCHAR2 Location of hard copy
100
 DATE_RECEIVED DATE Date application received
100
 DATE_APP_COMPLETED DATE Date application completed
100
 DATE_PERMIT_ISSUED DATE Date permit issued
100
 FINAL_REPORT_SUBMITTED DATE Date final report submitted
100
 START_DATE DATE Permit Start date
100
 END_DATE DATE Permit end date
100
 NEPA VARCHAR2 Date NEPA signed
100
 DAS NUMBER Days-at-Sea
100
 FISHING_YEAR NUMBER Fishing year
100
 GEAR VARCHAR2 Fishing gear
100
 COMMENTS VARCHAR2 General Comments
100
 EXTENSION_DOC_NUMBER VARCHAR2 Document number for permit period extention
100
 EXTENSION_REQUEST_RECEIVED DATE Date permit period extension request received
100
 EXTENSION_EFFECTIVE_START DATE Permit period extention start date
100
 APPLICATION_ABANDONED CHAR Date application abandonded
100
 DOCUMENT_TYPE VARCHAR2 Document Type (EFP, RSA, LOA, etc)
100
 PI_KEY NUMBER Primary Investigator, foreign key to applicant table
100
 REVIEW_OFFICIAL VARCHAR2 Review Official
100
 EFH_LEVEL VARCHAR2 EFH level
100
 EFH_COMPLETE DATE Date EFH complete
100
 ESA_INIT DATE Date ESA initialized
100
 ESA_COMPLETE DATE Date ESA complete
100
 CE_FONSI_SIGNED DATE Date FONSI signed
100
 CONSULT_NOTES VARCHAR2 Consultation Notes
100
 ESA_LEVEL VARCHAR2 ESA Level
100
 RSA_PROGRAM VARCHAR2 RSA Program type
100
 INTENDS_TO_FISH VARCHAR2 Intends to fish (boolean)
100
 LOA_DEALER_CODE VARCHAR2 LOA dealer code
100
 EXTENSION_END_DATE DATE Permit period extention end date

Attribute Details

ID_NUMBER

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

Form data primary key
General Data Type: NUMBER

DOCUMENT_NUMBER

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

Document Number for this form entry
General Data Type: VARCHAR2

APPLICANT_KEY

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

Main applicant
General Data Type: NUMBER

PROJECT_TITLE

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

Project Title
General Data Type: VARCHAR2

FUNDING_SOURCE

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

Funding Source
General Data Type: VARCHAR2

HARD_COPY_LOCATION

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

Location of hard copy
General Data Type: VARCHAR2

DATE_RECEIVED

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

Date application received
General Data Type: DATE

DATE_APP_COMPLETED

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

Date application completed
General Data Type: DATE

DATE_PERMIT_ISSUED

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

Date permit issued
General Data Type: DATE

FINAL_REPORT_SUBMITTED

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

Date final report submitted
General Data Type: DATE

START_DATE

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

Permit Start date
General Data Type: DATE

END_DATE

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

Permit end date
General Data Type: DATE

NEPA

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

Date NEPA signed
General Data Type: VARCHAR2

DAS

CC ID: 80868
Seq. Order: 14
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Days-at-Sea
General Data Type: NUMBER

FISHING_YEAR

CC ID: 80854
Seq. Order: 15
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Fishing year
General Data Type: NUMBER

GEAR

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

Fishing gear
General Data Type: VARCHAR2

COMMENTS

CC ID: 80863
Seq. Order: 17
Data Storage Type: VARCHAR2
Max Length: 3000
Required: No
Primary Key: No
Status: Active
Description:

General Comments
General Data Type: VARCHAR2

EXTENSION_DOC_NUMBER

CC ID: 80850
Seq. Order: 18
Data Storage Type: VARCHAR2
Max Length: 200
Required: No
Primary Key: No
Status: Active
Description:

Document number for permit period extention
General Data Type: VARCHAR2

EXTENSION_REQUEST_RECEIVED

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

Date permit period extension request received
General Data Type: DATE

EXTENSION_EFFECTIVE_START

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

Permit period extention start date
General Data Type: DATE

APPLICATION_ABANDONED

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

Date application abandonded
General Data Type: CHAR

DOCUMENT_TYPE

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

Document Type (EFP, RSA, LOA, etc)
General Data Type: VARCHAR2

PI_KEY

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

Primary Investigator, foreign key to applicant table
General Data Type: NUMBER

REVIEW_OFFICIAL

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

Review Official
General Data Type: VARCHAR2

EFH_LEVEL

CC ID: 80852
Seq. Order: 25
Data Storage Type: VARCHAR2
Max Length: 4000
Required: No
Primary Key: No
Status: Active
Description:

EFH level
General Data Type: VARCHAR2

EFH_COMPLETE

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

Date EFH complete
General Data Type: DATE

ESA_INIT

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

Date ESA initialized
General Data Type: DATE

ESA_COMPLETE

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

Date ESA complete
General Data Type: DATE

CE_FONSI_SIGNED

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

Date FONSI signed
General Data Type: DATE

CONSULT_NOTES

CC ID: 80853
Seq. Order: 30
Data Storage Type: VARCHAR2
Max Length: 4000
Required: No
Primary Key: No
Status: Active
Description:

Consultation Notes
General Data Type: VARCHAR2

ESA_LEVEL

CC ID: 80846
Seq. Order: 31
Data Storage Type: VARCHAR2
Max Length: 4000
Required: No
Primary Key: No
Status: Active
Description:

ESA Level
General Data Type: VARCHAR2

RSA_PROGRAM

CC ID: 80839
Seq. Order: 32
Data Storage Type: VARCHAR2
Max Length: 4000
Required: No
Primary Key: No
Status: Active
Description:

RSA Program type
General Data Type: VARCHAR2

INTENDS_TO_FISH

CC ID: 80844
Seq. Order: 33
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Intends to fish (boolean)
General Data Type: VARCHAR2

LOA_DEALER_CODE

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

LOA dealer code
General Data Type: VARCHAR2

EXTENSION_END_DATE

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

Permit period extention end date
General Data Type: DATE

Catalog Details

Catalog Item ID: 17198
GUID: gov.noaa.nmfs.inport:17198
Metadata Record Created By: Denise A Washick
Metadata Record Created: 2012-12-12 17:48+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-02-25
Owner Org: GARFO
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-02-25
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-02-25