Slide Menu
Search Help Show/Hide Menu

Item Identification

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

Audit Table For 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:

udit Table For Interview data table

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
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
100
CHANGE_DATE DATE Date/Time stamp of when record was modifed

Attribute Details

ID

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

Unique key

General Data Type: NUMBER

INTERVIEW_DATE

CC ID: 22371
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: 22372
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: 22373
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: 22374
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: 22375
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: 22376
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: 22377
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: 22378
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: 22379
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: 22380
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: 22381
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: 22382
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: 22383
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: 22384
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: 22385
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: 22386
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: 22387
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: 22388
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: 22389
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: 22390
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: 22391
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: 22392
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: 22393
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: 22394
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: 22395
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: 22396
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: 22397
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: 22398
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: 22399
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: 22400
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: 22401
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: 22402
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: 22403
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: 22404
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: 22405
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: 22406
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: 22407
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: 22408
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: 22409
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: 22410
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: 22411
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: 22412
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: 22413
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: 22414
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: 22415
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: 22416
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: 22417
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: 22418
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: 22419
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: 22420
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: 22421
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: 22422
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: 22423
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: 22424
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: 22425
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

CHANGE_DATE

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

Date/Time stamp of when record was modifed

General Data Type: DATE

Catalog Details

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