Table: DEALER_CODE_ALS
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:36817 | Updated: August 9, 2022 | Published / External
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
|
|
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 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 |