Search Help Show/Hide Menu
Summary
Item Identification
Physical Location
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

LOA Catch Records

Description

LOA Catch Records

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
ID
NUMBER
LOA catch ID, primary key
SPECIES_ID
NUMBER
Unused
EFP_FORM_ID
NUMBER
Form index number for this LOA catch
LBS_KEPT
NUMBER
Kept pounds
LBS_DISCARDED
NUMBER
Discarded pounds
YEAR
NUMBER
Catch Year
LOA_STOCKS_ID
NUMBER
Catch LOA stock id
LOA_SPECIES_ID
NUMBER
Catch species ID

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

LOA Catch Records

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:

LOA Catch Records

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key ID NUMBER LOA catch ID, primary key
100
SPECIES_ID NUMBER Unused
100
EFP_FORM_ID NUMBER Form index number for this LOA catch
100
LBS_KEPT NUMBER Kept pounds
100
LBS_DISCARDED NUMBER Discarded pounds
100
YEAR NUMBER Catch Year
100
LOA_STOCKS_ID NUMBER Catch LOA stock id
100
LOA_SPECIES_ID NUMBER Catch species ID

Attribute Details

ID

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

LOA catch ID, primary key

General Data Type: NUMBER

SPECIES_ID

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

Unused

General Data Type: NUMBER

EFP_FORM_ID

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

Form index number for this LOA catch

General Data Type: NUMBER

LBS_KEPT

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

Kept pounds

General Data Type: NUMBER

LBS_DISCARDED

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

Discarded pounds

General Data Type: NUMBER

YEAR

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

Catch Year

General Data Type: NUMBER

LOA_STOCKS_ID

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

Catch LOA stock id

General Data Type: NUMBER

LOA_SPECIES_ID

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

Catch species ID

General Data Type: NUMBER

Catalog Details

Catalog Item ID: 17202
GUID: gov.noaa.nmfs.inport:17202
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