Metadata Rubric

100%

6 / 6

SEFSC Metadata Library > Fisheries Statistics Division > FISHERIES MONITORING > Commercial Catch and Effort > Commercial Landings Project > Accumulative Landings System (ALS) > Accumulative Landings System Code Tables >

Table: DEALER_CODE_ALS

Entity (ENT) | Southeast Fisheries Science Center (SEFSC)
GUID: gov.noaa.nmfs.inport:36817 | Updated: August 9, 2022 | Published / External

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

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.

Description

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

Entity Type
Data Table

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

Data Attribute / Type

Description

ALSSTATE
VARCHAR2

The ALS State Code

ALSCTYIN
VARCHAR2

The ALS County Code

NMFSCOUNTY
VARCHAR2

The two digit NMFS Count y Code.

DEALER
VARCHAR2

The Dealer Number.

DEALERNAME
VARCHAR2

The Name of the Dealer.

ADDRESS
VARCHAR2

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

CITY
VARCHAR2

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

STATEABBREV
VARCHAR2

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

ZIPCODE
VARCHAR2

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

PHONE
VARCHAR2

The dealer phone number

FIPS_STATE_LAND
VARCHAR2

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

FIPS_STATE_LOCATION
VARCHAR2

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

FIPS_COUNTY_LOCATION
VARCHAR2

The FIPS code for dealer county of location.

ISSUED_TO
VARCHAR2

The dealer alias if one exists.

BUS_MAIL
VARCHAR2

The dealer mailing address.

BUS_LOCATION
VARCHAR2

The dealer location address

CONTACT
VARCHAR2

Person to contact (if provided).

OWNER
VARCHAR2

The business owner (if provided)

NMFS_SITE_STATE
VARCHAR2

The NMFS code for state of dealer location.

BEGIN_YYYYMM
VARCHAR2

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

END_YYYYMM
VARCHAR2

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

WHICHONE
VARCHAR2

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

YEARLAND
VARCHAR2

Year catch were landed

NMFS_SITE_COUNTY
VARCHAR2

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

FIPS_COUNTY_LAND
VARCHAR2

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

NMFS_COUNTY_LOCATION
VARCHAR2

NMFS code for dealer location county

No Child Items for this record.

No contact information is available for this record.

Please contact the owner organization (SEFSC) for inquiries on this record.

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 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.

Attribute Summary

	Name	Type	Description
100	ALSSTATE	VARCHAR2	The ALS State Code
100	ALSCTYIN	VARCHAR2	The ALS County Code
100	NMFSCOUNTY	VARCHAR2	The two digit NMFS Count y Code.
100	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	WHICHONE	VARCHAR2	Indicates data source. GS = Gulf Shrimp System, SA = South Atlantic Shrimp System, MN = Menhaden Survey, Alpha state codes = agency state
100	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

Name

Type

Description

100

ALSSTATE

VARCHAR2

The ALS State Code

100

ALSCTYIN

VARCHAR2

The ALS County Code

100

NMFSCOUNTY

VARCHAR2

The two digit NMFS Count y Code.

100

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

WHICHONE

VARCHAR2

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

100

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 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

Table: DEALER_CODE_ALS

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

ALSSTATE

ALSCTYIN

NMFSCOUNTY

DEALER

DEALERNAME

ADDRESS

CITY

STATEABBREV

ZIPCODE

PHONE

FIPS_STATE_LAND

FIPS_STATE_LOCATION

FIPS_COUNTY_LOCATION

ISSUED_TO

BUS_MAIL

BUS_LOCATION

CONTACT

OWNER

NMFS_SITE_STATE

BEGIN_YYYYMM

END_YYYYMM

WHICHONE

YEARLAND

NMFS_SITE_COUNTY

FIPS_COUNTY_LAND

NMFS_COUNTY_LOCATION

Catalog Details