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 2004, 12-03-2007 09:39

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: 22139
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: 22140
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: 22141
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: 22142
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: 22143
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: 22144
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: 22145
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: 22146
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: 22147
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: 22148
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: 22149
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: 22150
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: 22151
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: 22152
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: 22153
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: 22154
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: 22155
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: 22156
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: 22157
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: 22158
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: 22159
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: 22160
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: 22161
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: 22162
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: 22163
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: 22164
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: 22165
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: 22166
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: 22167
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: 22168
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: 22169
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: 22170
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: 22171
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: 22172
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: 22173
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: 22174
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: 22175
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: 22176
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: 22177
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: 22178
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: 22179
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: 22180
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: 22181
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: 22182
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: 22183
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: 22184
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: 22185
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: 22186
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: 22187
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: 22188
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: 22189
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: 22190
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: 22191
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: 22192
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: 22193
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: 22194
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

Support Roles

Point of Contact

CC ID: 173732
Date Effective From: 2003-01-01
Date Effective To:
Contact (Person): Gloeckner, David
Address: 75 Virginia Beach Drive
Miami, FL 33139
Email Address: David.Gloeckner@noaa.gov
Phone: 305-361-4257
Fax: 305-361-4460
View Historical Support Roles

Activity Log

Activity Log 1

CC ID: 104265
Activity Date/Time: 2013-04-23
Activity Type: Update of trip_ticket and trip_ticket_agency_id
Responsible Party: Joshua Bennett
Description:

194 Puerto Rico records for 2009 were updated with the appropriate code from the ALS data (ALS.als_landings_puerto_rico).

Related Items

Item Type Relationship Type Title
Entity (ENT) Cross Reference Table: AGENCY

Table Of Valid Agencies

Entity (ENT) Cross Reference Table: FISHING_MODE

Link To Fishing Mode Table

Entity (ENT) Cross Reference Table: INTERVIEW_TYPE

Interview_type Validation Table

Entity (ENT) Cross Reference Table: LANDING_TYPE

Validation on Landings_type

Entity (ENT) Cross Reference Table: STANDARD_SPECIES

Table Of Valid Species Codes

Entity (ENT) Cross Reference Table: VESSEL_TYPE

Vessel_Type validation Table

Catalog Details

Catalog Item ID: 6566
GUID: gov.noaa.nmfs.inport:6566
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2007-12-03 09:39+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