Table: SAS_MAIN_DATA
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:5490 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
The master data table for the SAS System
DescriptionThe master data table for the SAS System
Entity Information
Entity Type
Data Table
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_FISHED
NUMBER |
Number Of Days Vessel has fished |
TENTHS_OF_DAYS_FISHED
NUMBER |
The number of tenths of days that fishing took palce |
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
Extents
1978-01-01 - 2005-12-31
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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: | 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 |