Metadata Rubric

100%

6 / 6

SEFSC Metadata Library > Fisheries Statistics Division > FISHERIES MONITORING > Commercial Catch and Effort > Commercial Log Book Data Sets > Logbook System Fisheries > Golden crab logbook system > Golden Crab Logbook Survey (Vessels) >

View: FLS_GOLDEN_CRAB_DEALER_CODES_V

Entity (ENT) | Southeast Fisheries Science Center (SEFSC)
GUID: gov.noaa.nmfs.inport:6879 | Updated: May 6, 2021 | Published / External

Item Identification

Title:	View: FLS_GOLDEN_CRAB_DEALER_CODES_V
Short Name:	FLS_GOLDEN_CRAB_DEALER_CODES_V
Status:	Completed
Abstract:	View Of Valid Dealers Who Purchase Golden crabs
Notes:	Loaded by batch 2045, 12-20-2007 10:28

Keywords

Theme Keywords

Thesaurus	Keyword
UNCONTROLLED
None	dealer
None	gloden crab

Thesaurus

Keyword

UNCONTROLLED

None

dealer

None

gloden crab

Entity Information

Entity Type:	Data View
Active Version?:	Yes
Schema Name:	FLS
Description:	View Of Valid Dealers Who Purchase Golden crabs

Data Attributes

Attribute Summary

	Name	Type	Description
100	DEALER_CODE	VARCHAR2	Dealer code number. These codes are unique to this system and do not conform to any pre-existingcodes tables.
100	DEALER_CODE_OLD	NUMBER	Old dealer code used by SEFSC
100	LOGBOOK_TYPE	VARCHAR2	Identifies for which logbook the dealer is valid
100	STATE_WHERE_VALID	VARCHAR2	State that assigned the dealer code.
100	COUNTY_WHERE_VALID	VARCHAR2	County that assigned the dealer code.
100	DEALER_CODE_ALS	VARCHAR2	Equivalent dealer code in the Accumulated Landings System
100	DEALERSHIP_NAME	VARCHAR2	The name of the dealership
100	DEALERSHIP_ALIAS	VARCHAR2	Other names by which the dealership may be known (e.g., changes in spelling, etc.)
100	DEALERSHIP_OWNER	VARCHAR2	Name of the owner of the dealership
100	ADDRESS_1	VARCHAR2	First line of the address
100	ADDRESS_2	VARCHAR2	Second line of the address
100	CITY	VARCHAR2	City where dealership is located
100	STATE_CODE	VARCHAR2	NMFS state code where the dealership is located
100	ZIP_CODE	VARCHAR2	Zip code
100	COUNTRY_CODE_FIPS	VARCHAR2	Country
100	TELEPHONE	VARCHAR2	Dealership telephone
100	SENT_TO_CONTRACTOR	VARCHAR2	Has this code been sent to the data entry contractor?
100	NOTES	VARCHAR2	Special information about the dealer
100	IS_SURROGATE	VARCHAR2	Is This a surrogate Dealer
100	IS_GOLDEN_CRAB	VARCHAR2	Allowed to fish golden crab?

Name

Type

Description

100

DEALER_CODE

VARCHAR2

Dealer code number. These codes are unique to this system and do not conform to any pre-existingcodes tables.

100

DEALER_CODE_OLD

NUMBER

Old dealer code used by SEFSC

100

LOGBOOK_TYPE

VARCHAR2

Identifies for which logbook the dealer is valid

100

STATE_WHERE_VALID

VARCHAR2

State that assigned the dealer code.

100

COUNTY_WHERE_VALID

VARCHAR2

County that assigned the dealer code.

100

DEALER_CODE_ALS

VARCHAR2

Equivalent dealer code in the Accumulated Landings System

100

DEALERSHIP_NAME

VARCHAR2

The name of the dealership

100

DEALERSHIP_ALIAS

VARCHAR2

Other names by which the dealership may be known (e.g., changes in spelling, etc.)

100

DEALERSHIP_OWNER

VARCHAR2

Name of the owner of the dealership

100

ADDRESS_1

VARCHAR2

First line of the address

100

ADDRESS_2

VARCHAR2

Second line of the address

100

CITY

VARCHAR2

City where dealership is located

100

STATE_CODE

VARCHAR2

NMFS state code where the dealership is located

100

ZIP_CODE

VARCHAR2

Zip code

100

COUNTRY_CODE_FIPS

VARCHAR2

Country

100

TELEPHONE

VARCHAR2

Dealership telephone

100

SENT_TO_CONTRACTOR

VARCHAR2

Has this code been sent to the data entry contractor?

100

NOTES

VARCHAR2

Special information about the dealer

100

IS_SURROGATE

VARCHAR2

Is This a surrogate Dealer

100

IS_GOLDEN_CRAB

VARCHAR2

Allowed to fish golden crab?

Attribute Details

DEALER_CODE

CC ID: 25128

Seq. Order:	1
Data Storage Type:	VARCHAR2
Max Length:	10
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Dealer code number. These codes are unique to this system and do not conform to any pre-existingcodes tables.
General Data Type:	VARCHAR2

DEALER_CODE_OLD

CC ID: 25136

Seq. Order:	2
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	Old dealer code used by SEFSC
General Data Type:	NUMBER

LOGBOOK_TYPE

CC ID: 25134

Seq. Order:	3
Data Storage Type:	VARCHAR2
Max Length:	5
Required:	No
Primary Key:	No
Status:	Active
Description:	Identifies for which logbook the dealer is valid
General Data Type:	VARCHAR2

STATE_WHERE_VALID

CC ID: 25138

Seq. Order:	4
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	Yes
Primary Key:	No
Status:	Active
Description:	State that assigned the dealer code.
General Data Type:	VARCHAR2

COUNTY_WHERE_VALID

CC ID: 25142

Seq. Order:	5
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	Yes
Primary Key:	No
Status:	Active
Description:	County that assigned the dealer code.
General Data Type:	VARCHAR2

DEALER_CODE_ALS

CC ID: 25140

Seq. Order:	6
Data Storage Type:	VARCHAR2
Max Length:	9
Required:	No
Primary Key:	No
Status:	Active
Description:	Equivalent dealer code in the Accumulated Landings System
General Data Type:	VARCHAR2

DEALERSHIP_NAME

CC ID: 25124

Seq. Order:	7
Data Storage Type:	VARCHAR2
Max Length:	50
Required:	No
Primary Key:	No
Status:	Active
Description:	The name of the dealership
General Data Type:	VARCHAR2

DEALERSHIP_ALIAS

CC ID: 25130

Seq. Order:	8
Data Storage Type:	VARCHAR2
Max Length:	50
Required:	No
Primary Key:	No
Status:	Active
Description:	Other names by which the dealership may be known (e.g., changes in spelling, etc.)
General Data Type:	VARCHAR2

DEALERSHIP_OWNER

CC ID: 25133

Seq. Order:	9
Data Storage Type:	VARCHAR2
Max Length:	50
Required:	No
Primary Key:	No
Status:	Active
Description:	Name of the owner of the dealership
General Data Type:	VARCHAR2

ADDRESS_1

CC ID: 25137

Seq. Order:	10
Data Storage Type:	VARCHAR2
Max Length:	30
Required:	No
Primary Key:	No
Status:	Active
Description:	First line of the address
General Data Type:	VARCHAR2

ADDRESS_2

CC ID: 25126

Seq. Order:	11
Data Storage Type:	VARCHAR2
Max Length:	30
Required:	No
Primary Key:	No
Status:	Active
Description:	Second line of the address
General Data Type:	VARCHAR2

CITY

CC ID: 25141

Seq. Order:	12
Data Storage Type:	VARCHAR2
Max Length:	40
Required:	No
Primary Key:	No
Status:	Active
Description:	City where dealership is located
General Data Type:	VARCHAR2

STATE_CODE

CC ID: 25129

Seq. Order:	13
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	NMFS state code where the dealership is located
General Data Type:	VARCHAR2

ZIP_CODE

CC ID: 25139

Seq. Order:	14
Data Storage Type:	VARCHAR2
Max Length:	10
Required:	No
Primary Key:	No
Status:	Active
Description:	Zip code
General Data Type:	VARCHAR2

COUNTRY_CODE_FIPS

CC ID: 25135

Seq. Order:	15
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Country
General Data Type:	VARCHAR2

TELEPHONE

CC ID: 25125

Seq. Order:	16
Data Storage Type:	VARCHAR2
Max Length:	12
Required:	No
Primary Key:	No
Status:	Active
Description:	Dealership telephone
General Data Type:	VARCHAR2

SENT_TO_CONTRACTOR

CC ID: 25132

Seq. Order:	17
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Has this code been sent to the data entry contractor?
General Data Type:	VARCHAR2

NOTES

CC ID: 25143

Seq. Order:	18
Data Storage Type:	VARCHAR2
Max Length:	200
Required:	No
Primary Key:	No
Status:	Active
Description:	Special information about the dealer
General Data Type:	VARCHAR2

IS_SURROGATE

CC ID: 25127

Seq. Order:	19
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Is This a surrogate Dealer
General Data Type:	VARCHAR2

IS_GOLDEN_CRAB

CC ID: 25131

Seq. Order:	20
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Allowed to fish golden crab?
General Data Type:	VARCHAR2

Catalog Details

Catalog Item ID:	6879
GUID:	gov.noaa.nmfs.inport:6879
Metadata Record Created By:	Lee M Weinberger
Metadata Record Created:	2007-12-20 10:28+0000
Metadata Record Last Modified By:	Lee M Weinberger
Metadata Record Last Modified:	2021-05-06 22:24+0000
Metadata Record Published:	2021-05-06
Owner Org:	SEFSC
Metadata Publication Status:	Published Externally
Do Not Publish?:	N
Metadata Review Frequency:	1 Year