Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
SEFSC Metadata Library > Fisheries Statistics Division > FISHERIES MONITORING > Commercial Catch and Effort > Dock Interviews and Samples > South Atlantic Shrimp System > South Atlantic Shrimp System >

View: SAS_SA_SHRIMP_FL_V

Entity (ENT)  |  Southeast Fisheries Science Center (SEFSC)
GUID: gov.noaa.nmfs.inport:5494  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Keywords
Physical Location
Entity Info
Data Attributes
Support Roles
Access Info
Catalog Details

Summary

Abstract

The view of Florida data for the SAS System

Description

The view of Florida data for the SAS System

Entity Information

Entity Type
Data View

Data Attribute / Type Description
STATE_LANDED
NUMBER 		NMFS State Code
COUNTY_LANDED
NUMBER 		SAS County Landed Code -- Validate Against SAS_COUNTY_CODE
AREA_FISHED
VARCHAR2 		Area Fished -- Validated against SAS_AREA_CODE
SUBAREA_FISHED
VARCHAR2 		Sub Area Fished -- Validate Against SAS_AREA_CODE
DEALER_NUMBER
NUMBER 		Dealer (Code) Number
DATE_LANDED
VARCHAR2 		Date Landed as a Character Value
DATE_LANDED_CONV
DATE 		Date Landed COnverted to a Date Value whenever this is possible
SCHEDULE_NUMBER
NUMBER 		Schedule Number
GRADING
NUMBER 		Grading Code -- Validate Against SAS_GRADING_CODE
GEAR_CODE
VARCHAR2 		SAS Gear Code -- Validated against SAS_GEAR_CODE
VESSEL_TRIPS
NUMBER 		Number Of Vessel Trips
BOAT_TRIPS
NUMBER 		Number Of Boat Trips
CALENDAR_DAYS_FI
NUMBER 		Number Of Days Fished (whole number)
TENTHS_OF_DAYS_F
NUMBER 		Tenth Of Days Fished
VESSEL_ID_NUMBER
VARCHAR2 		Vessel Indentification Number Of Vessel Landings The Shrimp
SPECIES_CODE
VARCHAR2 		SAS Species Code
SHRIMP_SIZE
NUMBER 		Shrimp Size Code -- Validate Against SAS_SIZE_CODE
POUNDS_CAUGHT
NUMBER 		Number Of Pounds Of Shrimp Caught
UNIT_COST
NUMBER 		Average Price Per Pound Reported For Pounds Landed
FILLER
NUMBER 		Filler

Child Items

No Child Items for this record.

Contact Information

Point of Contact
David Gloeckner
David.Gloeckner@noaa.gov
305-361-4257

Item Identification

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

The view of Florida data for the SAS System
Notes:

Loaded by batch 1743, 10-17-2007 04:25

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None Shrimp Data
None View

Spatial Keywords

Thesaurus Keyword
UNCONTROLLED
None Florida

Stratum Keywords

Thesaurus Keyword
UNCONTROLLED
None Area
None County
None Gear
None Species

Physical Location

Organization: Southeast Fisheries Science Center
City: Miami
State/Province: FL
Country: USA
Location Description:

Disk

Entity Information

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

The view of Florida data for the SAS System

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 STATE_LANDED NUMBER NMFS State Code
100
 COUNTY_LANDED NUMBER SAS County Landed Code -- Validate Against SAS_COUNTY_CODE
100
 AREA_FISHED VARCHAR2 Area Fished -- Validated against SAS_AREA_CODE
100
 SUBAREA_FISHED VARCHAR2 Sub Area Fished -- Validate Against SAS_AREA_CODE
100
 DEALER_NUMBER NUMBER Dealer (Code) Number
100
 DATE_LANDED VARCHAR2 Date Landed as a Character Value
100
 DATE_LANDED_CONV DATE Date Landed COnverted to a Date Value whenever this is possible
100
 SCHEDULE_NUMBER NUMBER Schedule Number
100
 GRADING NUMBER Grading Code -- Validate Against SAS_GRADING_CODE
100
 GEAR_CODE VARCHAR2 SAS Gear Code -- Validated against SAS_GEAR_CODE
100
 VESSEL_TRIPS NUMBER Number Of Vessel Trips
100
 BOAT_TRIPS NUMBER Number Of Boat Trips
100
 CALENDAR_DAYS_FI NUMBER Number Of Days Fished (whole number)
100
 TENTHS_OF_DAYS_F NUMBER Tenth Of Days Fished
100
 VESSEL_ID_NUMBER VARCHAR2 Vessel Indentification Number Of Vessel Landings The Shrimp
100
 SPECIES_CODE VARCHAR2 SAS Species Code
100
 SHRIMP_SIZE NUMBER Shrimp Size Code -- Validate Against SAS_SIZE_CODE
100
 POUNDS_CAUGHT NUMBER Number Of Pounds Of Shrimp Caught
100
 UNIT_COST NUMBER Average Price Per Pound Reported For Pounds Landed
100
 FILLER NUMBER Filler

Attribute Details

STATE_LANDED

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

NMFS State Code
General Data Type: NUMBER

COUNTY_LANDED

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

SAS County Landed Code -- Validate Against SAS_COUNTY_CODE
General Data Type: NUMBER

AREA_FISHED

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

Area Fished -- Validated against SAS_AREA_CODE
General Data Type: VARCHAR2

SUBAREA_FISHED

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

Sub Area Fished -- Validate Against SAS_AREA_CODE
General Data Type: VARCHAR2

DEALER_NUMBER

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

Dealer (Code) Number
General Data Type: NUMBER

DATE_LANDED

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

Date Landed as a Character Value
General Data Type: VARCHAR2

DATE_LANDED_CONV

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

Date Landed COnverted to a Date Value whenever this is possible
General Data Type: DATE

SCHEDULE_NUMBER

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

Schedule Number
General Data Type: NUMBER

GRADING

CC ID: 17495
Seq. Order: 9
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 1
Scale: 0
Status: Active
Description:

Grading Code -- Validate Against SAS_GRADING_CODE
General Data Type: NUMBER

GEAR_CODE

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

SAS Gear Code -- Validated against SAS_GEAR_CODE
General Data Type: VARCHAR2

VESSEL_TRIPS

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

Number Of Vessel Trips
General Data Type: NUMBER

BOAT_TRIPS

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

Number Of Boat Trips
General Data Type: NUMBER

CALENDAR_DAYS_FI

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

Number Of Days Fished (whole number)
General Data Type: NUMBER

TENTHS_OF_DAYS_F

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

Tenth Of Days Fished
General Data Type: NUMBER

VESSEL_ID_NUMBER

CC ID: 17494
Seq. Order: 15
Data Storage Type: VARCHAR2
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Vessel Indentification Number Of Vessel Landings The Shrimp
General Data Type: VARCHAR2

SPECIES_CODE

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

SAS Species Code
General Data Type: VARCHAR2

SHRIMP_SIZE

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

Shrimp Size Code -- Validate Against SAS_SIZE_CODE
General Data Type: NUMBER

POUNDS_CAUGHT

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

Number Of Pounds Of Shrimp Caught
General Data Type: NUMBER

UNIT_COST

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

Average Price Per Pound Reported For Pounds Landed
General Data Type: NUMBER

FILLER

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

Filler
General Data Type: NUMBER

Support Roles

Point of Contact

CC ID: 182698
Date Effective From: 2003-01-01
Date Effective To:
Contact (Person): Gloeckner, David
Address: 75 Virginia Beach Drive
Miami, FL 33139
Email Address: David.Gloeckner@noaa.gov
Phone: 305-361-4257
Fax: 305-361-4460

Access Information

Security Class: Confidential

Catalog Details

Catalog Item ID: 5494
GUID: gov.noaa.nmfs.inport:5494
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2007-10-17 04:25+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2021-05-06
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2021-05-06
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2022-05-06