View: SAS_SA_SHRIMP_SC_V
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:5497 | Updated: August 9, 2022 | Published / External
Item Identification
| Title: | View: SAS_SA_SHRIMP_SC_V |
|---|---|
| Short Name: | SAS_SA_SHRIMP_SC_V |
| Status: | Completed |
| Abstract: |
The view of South Carolina 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 | South Carolina |
Stratum Keywords
| Thesaurus | Keyword |
|---|---|
| UNCONTROLLED | |
| None | Area |
| None | County |
| 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 South Carolina data 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
|
DATA_GRADING | NUMBER | Grade 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: 17565
| 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: 17560
| 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: 17563
| 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: 17566
| 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: 17570
| 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: 17556
| 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: 17571
| 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: 17553
| 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 |
DATA_GRADING
CC ID: 17567
| Seq. Order: | 9 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 1 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Grade Code |
| General Data Type: | NUMBER |
GEAR_CODE
CC ID: 17562
| 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: 17557
| 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: 17564
| 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: 17568
| 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: 17552
| 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: 17559
| 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: 17554
| 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: 17555
| 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: 17558
| 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: 17569
| 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: 17561
| 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: 182695
| 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: | 5497 |
|---|---|
| GUID: | gov.noaa.nmfs.inport:5497 |
| 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 |