Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Other: INTERVIEW_MV
Short Name: INTERVIEW_MV
Status: Completed
Abstract:

Materialized View Of Interview Records Containing Decodes

Notes:

Loaded by batch 2243, 12-05-2008 10:11

Entity Information

Entity Type: Other
Active Version?: Yes
Schema Name: TIPONLINE
Description:

Materialized View Of Interview Records Containing Decodes

Data Attributes

Note: Metadata requirements do not apply to attributes for non-tabular entities.

Attribute Summary

Rubric Score Primary Key? Name Type Description
N/A
AGENT_USERNAME_ID VARCHAR2 Code of The Agent who entered this data
N/A
ID NUMBER Key to Interview Table
N/A
AGENCY_ID NUMBER Unique ID reference Agency collecting this data
N/A
AGENCY_NAME VARCHAR2 Name Associated WIth Agency_ID
N/A
AGENCY_SHORT_NAME VARCHAR2 Shorter mnemonic agency name up to 5 letters.
N/A
YEAR VARCHAR2 Year Of The Interview
N/A
INTERVIEW_DATE DATE Date Of The Interview
N/A
IS_DISABLED VARCHAR2 Is The Interview Disable
N/A
FISHING_MODE VARCHAR2 Description Of Mode Of Fiahing
N/A
INFORMATION_SOURCE VARCHAR2 Code Indicating Source Of Information
N/A
INT_TYPE VARCHAR2 Type Of Interview
N/A
LANDING_AREA_STATE_CODE VARCHAR2 FIPS state code for state where catch first crosses land
N/A
STATE_LANDED VARCHAR2 Coded Item for Name Of State Where Fish Was Landed
N/A
LANDING_AREA_COUNTY_CODE VARCHAR2 FIPS county code for county where catch first crosses land
N/A
COUNTY_LANDED VARCHAR2 Name Of Landing Area County
N/A
LANDING_AREA_PLACE_CODE VARCHAR2 Place Code
N/A
PLACE_LANDED VARCHAR2 Landing Area Place Name
N/A
SAMPLE_AREA_STATE_CODE VARCHAR2 Fips Code for State
N/A
STATE_SAMPLED VARCHAR2 Sample Area State
N/A
SAMPLE_AREA_COUNTY_CODE VARCHAR2 FIPS county code for county where catch was sampled and measured
N/A
COUNTY_SAMPLED VARCHAR2 Sample County Name
N/A
SAMPLE_AREA_PLACE_CODE VARCHAR2 Sample Area Place Code
N/A
PLACE_SAMPLED VARCHAR2 Sample Area Place Name
N/A
DEALER VARCHAR2 Dealer Name
N/A
DEALER_CODE VARCHAR2 Dealer Code
N/A
NBR_VESSELS NUMBER Number Of Vessels
N/A
TRIP_NUMBER NUMBER Number indentifying a trip when vessel makes multiple trips per da
N/A
CREW_SIZE NUMBER Count of captain and crew
N/A
HAS_EFFORT VARCHAR2 Indicates if There are effort records associated with the interview
N/A
LANDING_TYPE VARCHAR2 Code to indicate type of Landing
N/A
BIAS_TYPE VARCHAR2 Code to Indicate Bias In The sampling
N/A
TERMINATION VARCHAR2 Code to Indicate How Fishing Trip Terminated
N/A
BEGIN_TIME VARCHAR2 Begin Time Of Fisher In Military Time
N/A
END_TIME VARCHAR2 End Time Of Fisher In Military Time
N/A
START_DATE DATE Date Fisher Started
N/A
END_DATE DATE Date Fisher Ended
N/A
TRIP_DAYS_OUT NUMBER Number of days out
N/A
TRIP_DAYS_FISHED NUMBER Number of days fished
N/A
LIC_AGENCY VARCHAR2 Afency that granted license
N/A
LICENSE VARCHAR2 License Number Of Fisher
N/A
VESSEL_ID VARCHAR2 The unique state or coast guard identification number for the vessel
N/A
VESSEL_NAME VARCHAR2 The vessel's name
N/A
TICKET_AGENCY VARCHAR2 The agency That issued the Trip Ticket On The Catch
N/A
TICKET VARCHAR2 Tripticket Number assigned
N/A
STATUS VARCHAR2 Status
N/A
SAMPLE_AREA_ZIP NUMBER historical data only
N/A
REPORTING_AREA_ZIP VARCHAR2 Reporting Area Zip Code
N/A
OLD_SEQUENCE_NUMBER VARCHAR2 Historical Sequence Number
N/A
SITE_LOCATION VARCHAR2 Site Location Code (Historical)
N/A
INTERVIEW_COMMENT VARCHAR2 Any Comments On The Interview Record

Attribute Details

AGENT_USERNAME_ID

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

Code of The Agent who entered this data

General Data Type: VARCHAR2

ID

CC ID: 33238
Seq. Order: 2
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 38
Status: Active
Description:

Key to Interview Table

General Data Type: NUMBER

AGENCY_ID

CC ID: 33239
Seq. Order: 3
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 38
Status: Active
Description:

Unique ID reference Agency collecting this data

General Data Type: NUMBER

AGENCY_NAME

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

Name Associated WIth Agency_ID

General Data Type: VARCHAR2

AGENCY_SHORT_NAME

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

Shorter mnemonic agency name up to 5 letters.

General Data Type: VARCHAR2

YEAR

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

Year Of The Interview

General Data Type: VARCHAR2

INTERVIEW_DATE

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

Date Of The Interview

General Data Type: DATE

IS_DISABLED

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

Is The Interview Disable

General Data Type: VARCHAR2

FISHING_MODE

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

Description Of Mode Of Fiahing

General Data Type: VARCHAR2

INFORMATION_SOURCE

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

Code Indicating Source Of Information

General Data Type: VARCHAR2

INT_TYPE

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

Type Of Interview

General Data Type: VARCHAR2

LANDING_AREA_STATE_CODE

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

FIPS state code for state where catch first crosses land

General Data Type: VARCHAR2

STATE_LANDED

CC ID: 33249
Seq. Order: 13
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Coded Item for Name Of State Where Fish Was Landed

General Data Type: VARCHAR2

LANDING_AREA_COUNTY_CODE

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

FIPS county code for county where catch first crosses land

General Data Type: VARCHAR2

COUNTY_LANDED

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

Name Of Landing Area County

General Data Type: VARCHAR2

LANDING_AREA_PLACE_CODE

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

Place Code

General Data Type: VARCHAR2

PLACE_LANDED

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

Landing Area Place Name

General Data Type: VARCHAR2

SAMPLE_AREA_STATE_CODE

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

Fips Code for State

General Data Type: VARCHAR2

STATE_SAMPLED

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

Sample Area State

General Data Type: VARCHAR2

SAMPLE_AREA_COUNTY_CODE

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

FIPS county code for county where catch was sampled and measured

General Data Type: VARCHAR2

COUNTY_SAMPLED

CC ID: 33257
Seq. Order: 21
Data Storage Type: VARCHAR2
Max Length: 37
Required: No
Primary Key: No
Status: Active
Description:

Sample County Name

General Data Type: VARCHAR2

SAMPLE_AREA_PLACE_CODE

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

Sample Area Place Code

General Data Type: VARCHAR2

PLACE_SAMPLED

CC ID: 33259
Seq. Order: 23
Data Storage Type: VARCHAR2
Max Length: 52
Required: No
Primary Key: No
Status: Active
Description:

Sample Area Place Name

General Data Type: VARCHAR2

DEALER

CC ID: 33260
Seq. Order: 24
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Dealer Name

General Data Type: VARCHAR2

DEALER_CODE

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

Dealer Code

General Data Type: VARCHAR2

NBR_VESSELS

CC ID: 33262
Seq. Order: 26
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Number Of Vessels

General Data Type: NUMBER

TRIP_NUMBER

CC ID: 33263
Seq. Order: 27
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Number indentifying a trip when vessel makes multiple trips per da

General Data Type: NUMBER

CREW_SIZE

CC ID: 33264
Seq. Order: 28
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Count of captain and crew

General Data Type: NUMBER

HAS_EFFORT

CC ID: 33265
Seq. Order: 29
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Indicates if There are effort records associated with the interview

General Data Type: VARCHAR2

LANDING_TYPE

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

Code to indicate type of Landing

General Data Type: VARCHAR2

BIAS_TYPE

CC ID: 33267
Seq. Order: 31
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Code to Indicate Bias In The sampling

General Data Type: VARCHAR2

TERMINATION

CC ID: 33268
Seq. Order: 32
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Code to Indicate How Fishing Trip Terminated

General Data Type: VARCHAR2

BEGIN_TIME

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

Begin Time Of Fisher In Military Time

General Data Type: VARCHAR2

END_TIME

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

End Time Of Fisher In Military Time

General Data Type: VARCHAR2

START_DATE

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

Date Fisher Started

General Data Type: DATE

END_DATE

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

Date Fisher Ended

General Data Type: DATE

TRIP_DAYS_OUT

CC ID: 33273
Seq. Order: 37
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Number of days out

General Data Type: NUMBER

TRIP_DAYS_FISHED

CC ID: 33274
Seq. Order: 38
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Number of days fished

General Data Type: NUMBER

LIC_AGENCY

CC ID: 33275
Seq. Order: 39
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Afency that granted license

General Data Type: VARCHAR2

LICENSE

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

License Number Of Fisher

General Data Type: VARCHAR2

VESSEL_ID

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

The unique state or coast guard identification number for the vessel

General Data Type: VARCHAR2

VESSEL_NAME

CC ID: 33278
Seq. Order: 42
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

The vessel's name

General Data Type: VARCHAR2

TICKET_AGENCY

CC ID: 33279
Seq. Order: 43
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

The agency That issued the Trip Ticket On The Catch

General Data Type: VARCHAR2

TICKET

CC ID: 33280
Seq. Order: 44
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Tripticket Number assigned

General Data Type: VARCHAR2

STATUS

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

Status

General Data Type: VARCHAR2

SAMPLE_AREA_ZIP

CC ID: 33282
Seq. Order: 46
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 0
Status: Active
Description:

historical data only

General Data Type: NUMBER

REPORTING_AREA_ZIP

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

Reporting Area Zip Code

General Data Type: VARCHAR2

OLD_SEQUENCE_NUMBER

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

Historical Sequence Number

General Data Type: VARCHAR2

SITE_LOCATION

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

Site Location Code (Historical)

General Data Type: VARCHAR2

INTERVIEW_COMMENT

CC ID: 33286
Seq. Order: 50
Data Storage Type: VARCHAR2
Max Length: 4000
Required: No
Primary Key: No
Status: Active
Description:

Any Comments On The Interview Record

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 8505
GUID: gov.noaa.nmfs.inport:8505
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2008-12-05 10:11+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