Metadata Rubric

100%

6 / 6

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

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

	Name	Type	Description
100	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

Name

Type

Description

100

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