Slide Menu
System Maintenance Notice, Monday, December 5, 2022 @ 1pm-5pm Eastern. The Operations Team will be performing system maintenance. During this scheduled downtime, InPort will not be available.
View All
Search Help Show/Hide Menu

Item Identification

Title: Table: DEALER_CODE_ALS
Short Name: DEALER_CODE_ALS
Status: Completed
Abstract:

DEALER_CODE_ALS identifies dealers in ALS from 1977 to 2013 according to ALSState, NMFS county, dealer (code), year of landing, whichone. This table is a historical table. For information on dealers after 2013 use the Dealer Management System tables.

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: ALS
Description:

DEALER_CODE_ALS identifies dealers in ALS from 1977 to 2013 according to ALSState, NMFS county, dealer (code), year of landing, whichone.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key ALSSTATE VARCHAR2 The ALS State Code
100
ALSCTYIN VARCHAR2 The ALS County Code
100
Primary Key NMFSCOUNTY VARCHAR2 The two digit NMFS Count y Code.
100
Primary Key DEALER VARCHAR2 The Dealer Number.
100
DEALERNAME VARCHAR2 The Name of the Dealer.
100
ADDRESS VARCHAR2 The street address of dealer location and/or the mailing address of dealer
100
CITY VARCHAR2 The city of physical dealer location and/or the city of office address
100
STATEABBREV VARCHAR2 The state of dealer physical location and/or the state of office address
100
ZIPCODE VARCHAR2 The zipcode of dealer physical location and/or the zip for dealer office address.
100
PHONE VARCHAR2 The dealer phone number
100
FIPS_STATE_LAND VARCHAR2 The Federal Information Processing System (FIPS) code for state where catch were landed.
100
FIPS_STATE_LOCATION VARCHAR2 The FIPS code for the state of dealer location (may be different from state landed).
100
FIPS_COUNTY_LOCATION VARCHAR2 The FIPS code for dealer county of location.
100
ISSUED_TO VARCHAR2 The dealer alias if one exists.
100
BUS_MAIL VARCHAR2 The dealer mailing address.
100
BUS_LOCATION VARCHAR2 The dealer location address
100
CONTACT VARCHAR2 Person to contact (if provided).
100
OWNER VARCHAR2 The business owner (if provided)
100
NMFS_SITE_STATE VARCHAR2 The NMFS code for state of dealer location.
100
BEGIN_YYYYMM VARCHAR2 The year and month of dealer permit issue (defaulted to landing year and month = 01 (January)
100
END_YYYYMM VARCHAR2 The year and month of dealer permit expiration (defaulted to year of landing and month = 12 (December)
100
Primary Key WHICHONE VARCHAR2 Indicates data source. GS = Gulf Shrimp System, SA = South Atlantic Shrimp System, MN = Menhaden Survey, Alpha state codes = agency state
100
Primary Key YEARLAND VARCHAR2 Year catch were landed
100
NMFS_SITE_COUNTY VARCHAR2 NMFS code for county of dealer location (needs to include dealer state location)
100
FIPS_COUNTY_LAND VARCHAR2 FIPS code for county where catch were landed. (dependent on FIPS landing state code).
100
NMFS_COUNTY_LOCATION VARCHAR2 NMFS code for dealer location county

Attribute Details

ALSSTATE

CC ID: 381197
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 2
Required: Yes
Primary Key: Yes
Status: Active
Description:

The ALS State Code

General Data Type: VARCHAR2

ALSCTYIN

CC ID: 381198
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

The ALS County Code

General Data Type: VARCHAR2

NMFSCOUNTY

CC ID: 381199
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 2
Required: Yes
Primary Key: Yes
Status: Active
Description:

The two digit NMFS Count

y Code.

General Data Type: VARCHAR2

DEALER

CC ID: 381200
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 14
Required: Yes
Primary Key: Yes
Status: Active
Description:

The Dealer Number.

General Data Type: VARCHAR2

DEALERNAME

CC ID: 381201
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 60
Required: No
Primary Key: No
Status: Active
Description:

The Name of the Dealer.

General Data Type: VARCHAR2

ADDRESS

CC ID: 381202
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 60
Required: No
Primary Key: No
Status: Active
Description:

The street address of dealer location and/or the mailing address of dealer

General Data Type: VARCHAR2

CITY

CC ID: 381203
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

The city of physical dealer location and/or the city of office address

General Data Type: VARCHAR2

STATEABBREV

CC ID: 381204
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

The state of dealer physical location and/or the state of office address

General Data Type: VARCHAR2

ZIPCODE

CC ID: 381205
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

The zipcode of dealer physical location and/or the zip for dealer office address.

General Data Type: VARCHAR2

PHONE

CC ID: 381206
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 15
Required: No
Primary Key: No
Status: Active
Description:

The dealer phone number

General Data Type: VARCHAR2

FIPS_STATE_LAND

CC ID: 381207
Seq. Order: 11
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

The Federal Information Processing System (FIPS) code for state where catch were landed.

General Data Type: VARCHAR2

FIPS_STATE_LOCATION

CC ID: 381208
Seq. Order: 12
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

The FIPS code for the state of dealer location (may be different from state landed).

General Data Type: VARCHAR2

FIPS_COUNTY_LOCATION

CC ID: 381209
Seq. Order: 13
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

The FIPS code for dealer county of location.

General Data Type: VARCHAR2

ISSUED_TO

CC ID: 381210
Seq. Order: 14
Data Storage Type: VARCHAR2
Max Length: 60
Required: No
Primary Key: No
Status: Active
Description:

The dealer alias if one exists.

General Data Type: VARCHAR2

BUS_MAIL

CC ID: 381211
Seq. Order: 15
Data Storage Type: VARCHAR2
Max Length: 60
Required: No
Primary Key: No
Status: Active
Description:

The dealer mailing address.

General Data Type: VARCHAR2

BUS_LOCATION

CC ID: 381212
Seq. Order: 16
Data Storage Type: VARCHAR2
Max Length: 60
Required: No
Primary Key: No
Status: Active
Description:

The dealer location address

General Data Type: VARCHAR2

CONTACT

CC ID: 381213
Seq. Order: 17
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Person to contact (if provided).

General Data Type: VARCHAR2

OWNER

CC ID: 381214
Seq. Order: 18
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

The business owner (if provided)

General Data Type: VARCHAR2

NMFS_SITE_STATE

CC ID: 381215
Seq. Order: 19
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

The NMFS code for state of dealer location.

General Data Type: VARCHAR2

BEGIN_YYYYMM

CC ID: 381216
Seq. Order: 20
Data Storage Type: VARCHAR2
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

The year and month of dealer permit issue (defaulted to landing year and month = 01 (January)

General Data Type: VARCHAR2

END_YYYYMM

CC ID: 381217
Seq. Order: 21
Data Storage Type: VARCHAR2
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

The year and month of dealer permit expiration (defaulted to year of landing and month = 12 (December)

General Data Type: VARCHAR2

WHICHONE

CC ID: 381218
Seq. Order: 22
Data Storage Type: VARCHAR2
Max Length: 2
Required: Yes
Primary Key: Yes
Status: Active
Description:

Indicates data source. GS = Gulf Shrimp System, SA = South Atlantic Shrimp System, MN = Menhaden Survey, Alpha state codes = agency state

General Data Type: VARCHAR2

YEARLAND

CC ID: 381219
Seq. Order: 23
Data Storage Type: VARCHAR2
Max Length: 4
Required: Yes
Primary Key: Yes
Status: Active
Description:

Year catch were landed

General Data Type: VARCHAR2

NMFS_SITE_COUNTY

CC ID: 381220
Seq. Order: 24
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

NMFS code for county of dealer location (needs to include dealer state location)

General Data Type: VARCHAR2

FIPS_COUNTY_LAND

CC ID: 381221
Seq. Order: 25
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

FIPS code for county where catch were landed. (dependent on FIPS landing state code).

General Data Type: VARCHAR2

NMFS_COUNTY_LOCATION

CC ID: 381222
Seq. Order: 26
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

NMFS code for dealer location county

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 36817
GUID: gov.noaa.nmfs.inport:36817
Metadata Record Created By: Joshua Bennett
Metadata Record Created: 2017-02-15 15:40+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:10+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