View: SAS_SA_SHRIMP_NC_V
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:5496 | Updated: August 9, 2022 | Published / External
Item Identification
Title: | View: SAS_SA_SHRIMP_NC_V |
---|---|
Short Name: | SAS_SA_SHRIMP_NC_V |
Status: | Completed |
Abstract: |
The view of North Carolina data table 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 | North 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 North Carolina 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
|
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
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 |
DATA_GRADING
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
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_FI
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
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
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 |
Access Information
Security Class: | Confidential |
---|
Catalog Details
Catalog Item ID: | 5496 |
---|---|
GUID: | gov.noaa.nmfs.inport:5496 |
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 |