Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
SEFSC Metadata Library > Fisheries Statistics Division > FISHERIES MONITORING > Commercial Catch and Effort > Dock Interviews and Samples > South Atlantic Shrimp System > South Atlantic Shrimp System >

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 
Summary
Item Identification
Keywords
Physical Location
Entity Info
Data Attributes
Support Roles
Access Info
Catalog Details

Summary

Abstract

The view of North Carolina data table for the SAS System

Description

The view of North Carolina data table 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
DATA_GRADING
NUMBER 		Grade 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_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

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
 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: 17550
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: 17532
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: 17544
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: 17533
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: 17546
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: 17537
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: 17540
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: 17536
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: 17549
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: 17539
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: 17548
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: 17543
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: 17541
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: 17547
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: 17534
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: 17542
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: 17551
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: 17535
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: 17545
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: 17538
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: 182696
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