Slide Menu
Search Help Show/Hide Menu

Item Identification

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

Used For Resolution Of Dealers

Notes:

Loaded by batch 2005, 12-03-2007 10:12

Entity Information

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

Used For Resolution Of Dealers

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key SEQUENCE_NUMBER VARCHAR2 Sequence Number/Interview Number
100
INTERVIEW_DATE DATE Interview date
100
STATE_LANDED VARCHAR2 State Landed
100
AREA_COUNTY VARCHAR2 Area County Code
100
AREA_ZIP VARCHAR2 Area Zip Code
100
SITE_STATE VARCHAR2 SIte State
100
SITE_COUNTY VARCHAR2 Site County Code
100
SITE_ZIP VARCHAR2 SIte ZIp Code
100
SITE_LOCATION VARCHAR2 Site Location Code/Number
100
VESSEL_ID_NUMBER VARCHAR2 State Or Fedral Vessel Number
100
AGENT VARCHAR2 Two letter edition For Port Agent
100
START_DATE DATE Date Fishing was started
100
END_DATE DATE Date Fishing had stopped.
100
FISHING_MODE VARCHAR2 Fishing Mode Code
100
DEALER VARCHAR2 Dealer Number
100
BUS_NAME VARCHAR2 Dealer (Business) Name
100
BUS_STATE VARCHAR2 Business State
100
BUS_LOCATION VARCHAR2 Business Location
100
SITE_STATE_FIPS VARCHAR2 Site State FIPS Code
100
SITE_COUNTY_FIPS VARCHAR2 Site FIPS County Code

Attribute Details

SEQUENCE_NUMBER

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

Sequence Number/Interview Number

General Data Type: VARCHAR2

INTERVIEW_DATE

CC ID: 22766
Seq. Order: 2
Data Storage Type: DATE
Max Length: 7
Required: Yes
Primary Key: No
Status: Active
Description:

Interview date

General Data Type: DATE

STATE_LANDED

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

State Landed

General Data Type: VARCHAR2

AREA_COUNTY

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

Area County Code

General Data Type: VARCHAR2

AREA_ZIP

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

Area Zip Code

General Data Type: VARCHAR2

SITE_STATE

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

SIte State

General Data Type: VARCHAR2

SITE_COUNTY

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

Site County Code

General Data Type: VARCHAR2

SITE_ZIP

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

SIte ZIp Code

General Data Type: VARCHAR2

SITE_LOCATION

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

Site Location Code/Number

General Data Type: VARCHAR2

VESSEL_ID_NUMBER

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

State Or Fedral Vessel Number

General Data Type: VARCHAR2

AGENT

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

Two letter edition For Port Agent

General Data Type: VARCHAR2

START_DATE

CC ID: 22776
Seq. Order: 12
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date Fishing was started

General Data Type: DATE

END_DATE

CC ID: 22777
Seq. Order: 13
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date Fishing had stopped.

General Data Type: DATE

FISHING_MODE

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

Fishing Mode Code

General Data Type: VARCHAR2

DEALER

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

Dealer Number

General Data Type: VARCHAR2

BUS_NAME

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

Dealer (Business) Name

General Data Type: VARCHAR2

BUS_STATE

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

Business State

General Data Type: VARCHAR2

BUS_LOCATION

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

Business Location

General Data Type: VARCHAR2

SITE_STATE_FIPS

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

Site State FIPS Code

General Data Type: VARCHAR2

SITE_COUNTY_FIPS

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

Site FIPS County Code

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 6603
GUID: gov.noaa.nmfs.inport:6603
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2007-12-03 10:12+0000
Metadata Record Last Modified By: Lee M Weinberger
Metadata Record Last Modified: 2021-11-04 13:14+0000
Metadata Record Published: 2021-11-04
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2022-11-05