Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Table: SAS_MAIN_DATA
Short Name: SAS_MAIN_DATA
Status: Completed
Abstract:

The master data table for the SAS System

Notes:

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

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None Shrimp

Temporal Keywords

Thesaurus Keyword
UNCONTROLLED
None 1978-2005

Spatial Keywords

Thesaurus Keyword
UNCONTROLLED
None Florida
None Georgia
None North Carolina
None South Atlantic
None South Carolina

Stratum Keywords

Thesaurus Keyword
UNCONTROLLED
None county
None gear
None grade
None market category
None stae
None year

Physical Location

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

Disk

Entity Information

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

The master data table 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_FISHED NUMBER Number Of Days Vessel has fished
100
TENTHS_OF_DAYS_FISHED NUMBER The number of tenths of days that fishing took palce
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: 17472
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: 17471
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: 17470
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: 17469
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: 17468
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: 17467
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: 17466
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: 17465
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: 17464
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: 17463
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: 17462
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: 17461
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_FISHED

CC ID: 17460
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 Vessel has fished

General Data Type: NUMBER

TENTHS_OF_DAYS_FISHED

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

The number of tenths of days that fishing took palce

General Data Type: NUMBER

VESSEL_ID_NUMBER

CC ID: 17458
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: 17457
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: 17456
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: 17455
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: 17454
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: 17453
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: 182688
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

Extents

Extent Group 1

Extent Group 1 / Time Frame 1

CC ID: 43760
Time Frame Type: Range
Start: 1978-01-01
End: 2005-12-31

Access Information

Security Class: Confidential

Catalog Details

Catalog Item ID: 5490
GUID: gov.noaa.nmfs.inport:5490
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2007-10-17 04:25+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