36817
Table: DEALER_CODE_ALS
DEALER_CODE_ALS
Entity
Published / External
6419
Accumulative Landings System Code Tables
Data Set
Completed
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.
Data Table
Yes
ALS
DEALER_CODE_ALS identifies dealers in ALS from 1977 to 2013 according to ALSState, NMFS county, dealer (code), year of landing, whichone.
1
ALSSTATE
VARCHAR2
2
Yes
Yes
Active
The ALS State Code
VARCHAR2
2
ALSCTYIN
VARCHAR2
3
No
No
Active
The ALS County Code
VARCHAR2
3
NMFSCOUNTY
VARCHAR2
2
Yes
Yes
Active
The two digit NMFS Count
y Code.
VARCHAR2
4
DEALER
VARCHAR2
14
Yes
Yes
Active
The Dealer Number.
VARCHAR2
5
DEALERNAME
VARCHAR2
60
No
No
Active
The Name of the Dealer.
VARCHAR2
6
ADDRESS
VARCHAR2
60
No
No
Active
The street address of dealer location and/or the mailing address of dealer
VARCHAR2
7
CITY
VARCHAR2
30
No
No
Active
The city of physical dealer location and/or the city of office address
VARCHAR2
8
STATEABBREV
VARCHAR2
2
No
No
Active
The state of dealer physical location and/or the state of office address
VARCHAR2
9
ZIPCODE
VARCHAR2
10
No
No
Active
The zipcode of dealer physical location and/or the zip for dealer office address.
VARCHAR2
10
PHONE
VARCHAR2
15
No
No
Active
The dealer phone number
VARCHAR2
11
FIPS_STATE_LAND
VARCHAR2
2
No
No
Active
The Federal Information Processing System (FIPS) code for state where catch were landed.
VARCHAR2
12
FIPS_STATE_LOCATION
VARCHAR2
2
No
No
Active
The FIPS code for the state of dealer location (may be different from state landed).
VARCHAR2
13
FIPS_COUNTY_LOCATION
VARCHAR2
3
No
No
Active
The FIPS code for dealer county of location.
VARCHAR2
14
ISSUED_TO
VARCHAR2
60
No
No
Active
The dealer alias if one exists.
VARCHAR2
15
BUS_MAIL
VARCHAR2
60
No
No
Active
The dealer mailing address.
VARCHAR2
16
BUS_LOCATION
VARCHAR2
60
No
No
Active
The dealer location address
VARCHAR2
17
CONTACT
VARCHAR2
40
No
No
Active
Person to contact (if provided).
VARCHAR2
18
OWNER
VARCHAR2
40
No
No
Active
The business owner (if provided)
VARCHAR2
19
NMFS_SITE_STATE
VARCHAR2
2
No
No
Active
The NMFS code for state of dealer location.
VARCHAR2
20
BEGIN_YYYYMM
VARCHAR2
6
No
No
Active
The year and month of dealer permit issue (defaulted to landing year and month = 01 (January)
VARCHAR2
21
END_YYYYMM
VARCHAR2
6
No
No
Active
The year and month of dealer permit expiration (defaulted to year of landing and month = 12 (December)
VARCHAR2
22
WHICHONE
VARCHAR2
2
Yes
Yes
Active
Indicates data source. GS = Gulf Shrimp System, SA = South Atlantic Shrimp System, MN = Menhaden Survey, Alpha state codes = agency state
VARCHAR2
23
YEARLAND
VARCHAR2
4
Yes
Yes
Active
Year catch were landed
VARCHAR2
24
NMFS_SITE_COUNTY
VARCHAR2
2
No
No
Active
NMFS code for county of dealer location (needs to include dealer state location)
VARCHAR2
25
FIPS_COUNTY_LAND
VARCHAR2
3
No
No
Active
FIPS code for county where catch were landed. (dependent on FIPS landing state code).
VARCHAR2
26
NMFS_COUNTY_LOCATION
VARCHAR2
2
No
No
Active
NMFS code for dealer location county
VARCHAR2
gov.noaa.nmfs.inport:36817
Joshua Bennett
2017-02-15T15:40:03
SysAdmin InPortAdmin
2022-08-09T17:10:59
2021-05-06
Southeast Fisheries Science Center
SEFSC
75 Virginia Beach Drive
Miami
FL
33149
USA
(305)361-5761
www.sefsc.noaa.gov
8:00 a.m. - 4:30 p.m. EST
1001
Public
No
2021-05-06
1 Year
2022-05-06