Slide Menu
Search Help Show/Hide Menu

Item Identification

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

Interview Data Table

Notes:

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

Entity Information

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

Interview Data Table

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key ID NUMBER Unique key
100
INTERVIEW_DATE DATE Date of interview
100
AGENT_USERNAME_ID VARCHAR2 First letter of agent's first name and first 7 letters of agent's last name.
100
IS_DISABLED NUMBER Flag to show if the record has been disabled / deleted
100
TRIP_END_DATE DATE Date the trip ended
100
IS_HISTORICAL NUMBER Flag set if the record is from the legacy system
100
IS_EFFORT_DATA_COLLECTED NUMBER Was effort data collected? If yes the user moves on to section II effort
100
TRIP_START_DATE DATE Date the trip started
100
LANDING_TYPE_ID NUMBER Key to Landing_Type telling complete or incomplete landings, etc.
100
AGENCY_ID NUMBER Unique ID reference Agency collecting this data
100
INTERVIEW_TYPE_ID NUMBER Unique id for Interview_Type (I.E.fisherman sample, dealer sample, etc)
100
LANDING_AREA_PLACE_CODE VARCHAR2 Place Code
100
LANDING_AREA_STATE_CODE VARCHAR2 FIPS state code for state where catch first crosses land
100
LANDING_AREA_COUNTY_CODE VARCHAR2 FIPS county code for county where catch first crosses land
100
SAMPLE_AREA_PLACE_CODE VARCHAR2 Place Code
100
SAMPLE_AREA_STATE_CODE VARCHAR2 Fips Code for State
100
SAMPLE_AREA_COUNTY_CODE VARCHAR2 FIPS county code for county where catch was sampled and measured
100
NUMBER_OF_VESSELS NUMBER Number of vessels in the interview
100
CREATED_BY_USER_ID VARCHAR2 User creating Record
100
CREATED_DATE DATE Date/Time stamp of record creation
100
VESSEL_NAME VARCHAR2 The vessel's name
100
VESSEL_ID VARCHAR2 The unique state or coast guard identification number for the vessel
100
VESSEL_TYPE_ID NUMBER A field that is not used
100
VESSEL_LENGTH NUMBER The length of the vessel in feet
100
TRIP_NUMBER NUMBER Number indentifying a trip when vessel makes multiple trips per da
100
TRIP_DAYS_OUT NUMBER Number of days out
100
TRIP_DAYS_FISHED NUMBER Number of days fished
100
FISHING_MODE_ID NUMBER Key to fishing mode (COMMERCIAL, TOURNAMENT, etc.)
100
BEGIN_TIME_MINUTE NUMBER begin minute of interview
100
BEGIN_TIME_HOUR NUMBER Begin hour of interview
100
END_TIME_MINUTE NUMBER End minute of interview
100
END_TIME_HOUR NUMBER End hour of interview
100
TRIP_TICKET_NUMBER VARCHAR2 Trip ticket number from the trip ticket
100
TRIP_TICKET_LICENSE_AGENCY_ID NUMBER Key to Agency table used to select a state specified trip ticket license table
100
INDIVIDUAL_LICENSE_AGENCY_ID NUMBER Key to agency table for an individual license number table
100
INDIVIDUAL_LICENSE_NUMBER VARCHAR2 licence id from the licence table
100
DELETE_REASON_ID NUMBER Key to Delete Reason table for why record was releted
100
SAMPLE_AREA_ZIP NUMBER historical data only
100
BIAS_TYPE_ID NUMBER Key to Bias_Type (NO KNOWN BIAS, SIZE BIAS, etc)
100
CREW_SIZE NUMBER Count of captain and crew
100
TERMINATION_TYPE_ID NUMBER Key to Termination_Type (NORMAL, EQUIPMENT FAILURE, etc)
100
INFORMATION_SOURCE_ID NUMBER Key to Information Source (SITE_SAMPLE, LOGBOOK, etc)
100
DEALER_ID VARCHAR2 Key to dealer information buying the fish
100
TARGET_FISHERY_ID NUMBER Key to classes of species fished for (REEF FISH, INVERTIBRATES, etc)
100
TRIP_TYPE_ID NUMBER Key to trip_type (TROLL AND HAND LINE, TRAWL, etc.)
100
COMMENTS VARCHAR2 Field for comments related to the entire trip. Each master table has its own comment field.
100
MODIFIED_BY_USER_ID VARCHAR2 User modifying record
100
MODIFIED_DATE DATE Date/Time stamp of when record was modifed
100
STATUS_ID NUMBER Key to Status (VALID, INVALID, PENDING)
100
OLD_SEQUENCE_NUMBER VARCHAR2 KEY TO historical record preserved in SEFSC.TIP_TIP11
100
REPORTING_AREA_ZIP VARCHAR2 historical data only
100
ORIG_LOAD_DATE DATE The date the record was originally loaded
100
SOURCE_FILE VARCHAR2 Source file for historical data
100
SITE_LOCATION VARCHAR2 Historical field giving more specific site sampling location
100
START_DATE_ENTERED VARCHAR2 Date the fishing trip started; entered in historical system, which sometimes had invalid dates
100
END_DATE_ENTERED VARCHAR2 Date when trip ended; entered in historical system, which sometimes had invalid dates

Attribute Details

ID

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

Unique key

General Data Type: NUMBER

INTERVIEW_DATE

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

Date of interview

General Data Type: DATE

AGENT_USERNAME_ID

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

First letter of agent's first name and first 7 letters of agent's last name.

General Data Type: VARCHAR2

IS_DISABLED

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

Flag to show if the record has been disabled / deleted

General Data Type: NUMBER

TRIP_END_DATE

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

Date the trip ended

General Data Type: DATE

IS_HISTORICAL

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

Flag set if the record is from the legacy system

General Data Type: NUMBER

IS_EFFORT_DATA_COLLECTED

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

Was effort data collected? If yes the user moves on to section II effort

General Data Type: NUMBER

TRIP_START_DATE

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

Date the trip started

General Data Type: DATE

LANDING_TYPE_ID

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

Key to Landing_Type telling complete or incomplete landings, etc.

General Data Type: NUMBER

AGENCY_ID

CC ID: 22581
Seq. Order: 10
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

INTERVIEW_TYPE_ID

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

Unique id for Interview_Type (I.E.fisherman sample, dealer sample, etc)

General Data Type: NUMBER

LANDING_AREA_PLACE_CODE

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

Place Code

General Data Type: VARCHAR2

LANDING_AREA_STATE_CODE

CC ID: 22584
Seq. Order: 13
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

LANDING_AREA_COUNTY_CODE

CC ID: 22585
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

SAMPLE_AREA_PLACE_CODE

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

Place Code

General Data Type: VARCHAR2

SAMPLE_AREA_STATE_CODE

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

Fips Code for State

General Data Type: VARCHAR2

SAMPLE_AREA_COUNTY_CODE

CC ID: 22588
Seq. Order: 17
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

NUMBER_OF_VESSELS

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

Number of vessels in the interview

General Data Type: NUMBER

CREATED_BY_USER_ID

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

User creating Record

General Data Type: VARCHAR2

CREATED_DATE

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

Date/Time stamp of record creation

General Data Type: DATE

VESSEL_NAME

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

The vessel's name

General Data Type: VARCHAR2

VESSEL_ID

CC ID: 22593
Seq. Order: 22
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_TYPE_ID

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

A field that is not used

General Data Type: NUMBER

VESSEL_LENGTH

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

The length of the vessel in feet

General Data Type: NUMBER

TRIP_NUMBER

CC ID: 22596
Seq. Order: 25
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

TRIP_DAYS_OUT

CC ID: 22597
Seq. Order: 26
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: 22598
Seq. Order: 27
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

FISHING_MODE_ID

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

Key to fishing mode (COMMERCIAL, TOURNAMENT, etc.)

General Data Type: NUMBER

BEGIN_TIME_MINUTE

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

begin minute of interview

General Data Type: NUMBER

BEGIN_TIME_HOUR

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

Begin hour of interview

General Data Type: NUMBER

END_TIME_MINUTE

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

End minute of interview

General Data Type: NUMBER

END_TIME_HOUR

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

End hour of interview

General Data Type: NUMBER

TRIP_TICKET_NUMBER

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

Trip ticket number from the trip ticket

General Data Type: VARCHAR2

TRIP_TICKET_LICENSE_AGENCY_ID

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

Key to Agency table used to select a state specified trip ticket license table

General Data Type: NUMBER

INDIVIDUAL_LICENSE_AGENCY_ID

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

Key to agency table for an individual license number table

General Data Type: NUMBER

INDIVIDUAL_LICENSE_NUMBER

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

licence id from the licence table

General Data Type: VARCHAR2

DELETE_REASON_ID

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

Key to Delete Reason table for why record was releted

General Data Type: NUMBER

SAMPLE_AREA_ZIP

CC ID: 22609
Seq. Order: 38
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

BIAS_TYPE_ID

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

Key to Bias_Type (NO KNOWN BIAS, SIZE BIAS, etc)

General Data Type: NUMBER

CREW_SIZE

CC ID: 22611
Seq. Order: 40
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

TERMINATION_TYPE_ID

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

Key to Termination_Type (NORMAL, EQUIPMENT FAILURE, etc)

General Data Type: NUMBER

INFORMATION_SOURCE_ID

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

Key to Information Source (SITE_SAMPLE, LOGBOOK, etc)

General Data Type: NUMBER

DEALER_ID

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

Key to dealer information buying the fish

General Data Type: VARCHAR2

TARGET_FISHERY_ID

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

Key to classes of species fished for (REEF FISH, INVERTIBRATES, etc)

General Data Type: NUMBER

TRIP_TYPE_ID

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

Key to trip_type (TROLL AND HAND LINE, TRAWL, etc.)

General Data Type: NUMBER

COMMENTS

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

Field for comments related to the entire trip. Each master table has its own comment field.

General Data Type: VARCHAR2

MODIFIED_BY_USER_ID

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

User modifying record

General Data Type: VARCHAR2

MODIFIED_DATE

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

Date/Time stamp of when record was modifed

General Data Type: DATE

STATUS_ID

CC ID: 22620
Seq. Order: 49
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 15
Scale: 0
Status: Active
Description:

Key to Status (VALID, INVALID, PENDING)

General Data Type: NUMBER

OLD_SEQUENCE_NUMBER

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

KEY TO historical record preserved in SEFSC.TIP_TIP11

General Data Type: VARCHAR2

REPORTING_AREA_ZIP

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

historical data only

General Data Type: VARCHAR2

ORIG_LOAD_DATE

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

The date the record was originally loaded

General Data Type: DATE

SOURCE_FILE

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

Source file for historical data

General Data Type: VARCHAR2

SITE_LOCATION

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

Historical field giving more specific site sampling location

General Data Type: VARCHAR2

START_DATE_ENTERED

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

Date the fishing trip started; entered in historical system, which sometimes had invalid dates

General Data Type: VARCHAR2

END_DATE_ENTERED

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

Date when trip ended; entered in historical system, which sometimes had invalid dates

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 6587
GUID: gov.noaa.nmfs.inport:6587
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