Search Help Show/Hide Menu
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