Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: View: FLS_ORIGINAL_CATCHES_V
Short Name: FLS_ORIGINAL_CATCHES_V
Status: Completed
Abstract:

To recreate the catch table as it appears in the legacy logbook system from the SEFIN8 data.04/01/2002

Notes:

Loaded by batch 2103, 02-28-2008 14:10

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None catch
None legacy view

Entity Information

Entity Type: Data View
Active Version?: Yes
Schema Name: FLS
Description:

To recreate the catch table as it appears in the legacy logbook system from the SEFIN8 data.04/01/2002

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
SCHEDULE VARCHAR2 Schedule Number
100
SPECIES VARCHAR2 NMFS Soecues Code
100
GUTTED NUMBER Gutted Weight
100
WHOLE NUMBER Wholle Weight
100
GEAR VARCHAR2 Gear Used To Land Fish
100
AREA NUMBER Area/waterbody Code where fish was landed
100
DISCARDS NUMBER Number Of Discards
100
TOTLBS NUMBER Total Pounds Landed
100
PRICE VARCHAR2 Average Price er Pound

Attribute Details

SCHEDULE

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

Schedule Number

General Data Type: VARCHAR2

SPECIES

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

NMFS Soecues Code

General Data Type: VARCHAR2

GUTTED

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

Gutted Weight

General Data Type: NUMBER

WHOLE

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

Wholle Weight

General Data Type: NUMBER

GEAR

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

Gear Used To Land Fish

General Data Type: VARCHAR2

AREA

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

Area/waterbody Code where fish was landed

General Data Type: NUMBER

DISCARDS

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

Number Of Discards

General Data Type: NUMBER

TOTLBS

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

Total Pounds Landed

General Data Type: NUMBER

PRICE

CC ID: 27274
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Average Price er Pound

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 7161
GUID: gov.noaa.nmfs.inport:7161
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2008-02-28 14:10+0000
Metadata Record Last Modified By: Lee M Weinberger
Metadata Record Last Modified: 2021-05-06 22:24+0000
Metadata Record Published: 2021-05-06
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2022-05-07