Search Help Show/Hide Menu
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