Slide Menu
Search Help Show/Hide Menu

Item Identification

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

Master Materialized View Containging All Columns To Be Output. This was created by joining all of the other materialized views. It includes decodes.

Notes:

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

Entity Information

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

Master Materialized View Containging All Columns To Be Output. This was created by joining all of the other materialized views. It includes 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 Name/Code corresponding to Agent who provided/isresponsible for 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 Name of Dealer That purchased the catch
N/A
DEALER_CODE VARCHAR2 Code of Dealer that purchased The Catch
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 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
N/A
LAND_INTERVIEW_ID NUMBER Foreign Key to Interview Table
N/A
LAND_ID NUMBER Key to Landings Table
N/A
LAND_GEAR_CODE VARCHAR2 Key to agency specific gear table on the landings record
N/A
LAND_GEAR_NAME VARCHAR2 Gear Name associated with agency specific gear code on the lnadings record
N/A
LAND_AREA NUMBER Key to agency specific area table telling the primary area where fishing occurred on the landings record
N/A
LAND_AREA_NAME VARCHAR2 Area Name associated with agency specific area table telling the primary area where fishing occurred on the landings record
N/A
LAND_SCIENTIFIC_NAME VARCHAR2 Scientific Name On Landings Record
N/A
LAND_SPECIES_CODE VARCHAR2 Species Code On Landings Record
N/A
LAND_AGENCY_SPC_NAME VARCHAR2 Agency Specific Name On Landings Record
N/A
LAND_SPECIES_SIZE VARCHAR2 Key to size (MIXED/UNSIZED, JUMBO, etc) on Landings Record
N/A
LAND_GRADE VARCHAR2 Grade on the Landings Record
N/A
LAND_SAMPLE_COUNT NUMBER Number Of Sample Records Associated ed with landings record
N/A
LAND_WEIGHT NUMBER Total weight on the Landings Record
N/A
LAND_WEIGHT_UNIT_CODE VARCHAR2 Weight unit code on the Landings Record
N/A
LAND_WEIGHT_UNIT VARCHAR2 Decode of Weight unit code on the Landings Record
N/A
LAND_WEIGHT_KG NUMBER Total weight in kilograms on the Landings Record
N/A
LAND_CONDITION VARCHAR2 Condition Of fish landed on the Landings Record
N/A
LAND_MARKET_CNT_MIN NUMBER Minimun number of individuals per unit for this category on the landings record
N/A
LAND_MARKET_CNT_MAX NUMBER Maximun number of individuals per unit for this category on the landings record
N/A
LAND_REGION VARCHAR2 Region (GULF, ATLANTIC, etc) on the Landings Record
N/A
LAND_REPLICATE NUMBER Part of key ON landings record to relate the data back to the historical data.
N/A
LANDING_COMMENT VARCHAR2 Comment on this landing record
N/A
SAMPLE_INTERVIEW_ID NUMBER Link Between Sample and Interview Table
N/A
SAMPLE_LAND_ID NUMBER Link from sampe To Landings Table
N/A
SAMPLE_ID NUMBER Sample Id Number (Primary Key on Sa,ple Table)
N/A
SAMPLE_SPECIES_CODE VARCHAR2 Sample Local Species Code
N/A
SAMPLE_AGENCY_SPC_NAME VARCHAR2 Sample Local Species Name
N/A
SAMPLE_SCIENTIFIC_NAME VARCHAR2 Sample Scientific Name
N/A
SAMPLE_SIZE_CODE VARCHAR2 Sample Size Code
N/A
SAMPLE_SPECIES_SIZE VARCHAR2 Decode Sample Species Size Code
N/A
SAMPLE_GRADE VARCHAR2 Sample Grade Description
N/A
S_SAMPLE_COUNT NUMBER Number of sub-sample records associated with sample record
N/A
SAMPLE_WEIGHT NUMBER Sample Weight
N/A
SAMPLE_WEIGHT_UNIT_ID VARCHAR2 Sample Weight Code
N/A
SAMPLE_WEIGHT_UNIT VARCHAR2 Sample Weight Unit Decoded
N/A
SAMPLE_WEIGHT_KG NUMBER Sample Weight in kilograms
N/A
SAMPLE_CONDITION VARCHAR2 Sample Condition Description
N/A
FULL_CATCH VARCHAR2 Indicates If Sample was the full catch of the boat
N/A
SAMPLE_METHOD_TYPE_CODE VARCHAR2 Sampling Method Type Code
N/A
SAMPLE_METHOD_TYPE VARCHAR2 Sample Method Type
N/A
SAMPLE_RANDOM VARCHAR2 Indicates If this is (statistically) a random sample
N/A
SUB_SAMPLE_COUNT NUMBER Number of weights/records in the sub-sample
N/A
SUB_SAMPLE_WEIGHT_UNIT_CODE VARCHAR2 Sub Sample Weight Units Code
N/A
SUB_SAMPLE_WEIGHT_UNIT VARCHAR2 Sub Sample Weight Units
N/A
SUB_SAMPLE_WEIGHT NUMBER Sub Sample Weight associated with weight units
N/A
SUB_SAMPLE_WEIGHT_KG NUMBER Sub Sample Weight in Kilograms
N/A
SUB_SAMPLE_CONDITION VARCHAR2 Sub Sample Condition Code
N/A
SUB_SAMPLE_RANDOM VARCHAR2 Indicates If this is (statistically) a random sub-sample
N/A
SAMPLE_REPLICATE NUMBER Historical Replicate Number
N/A
SAMPLE_SAMPLE_NUMBER_OLD NUMBER Historical Sample Number
N/A
OBS_ID NUMBER Key to Observation Table
N/A
OBS_SAMPLE_ID NUMBER Key to Observation Sample Table
N/A
OBS_INTERVIEW_ID NUMBER Link To Interview Table
N/A
OBS_SPECIES_CODE VARCHAR2 Species Code On Observation Record
N/A
OBS_AGENCY_SPC_NAME VARCHAR2 Agency Specific Species Name On Observation Record
N/A
OBS_SCIENTIFIC_NAME VARCHAR2 Scientific Name Corresponding to Agency Specific Species Name On Observation Record
N/A
OBS_SPECIES_SIZE_CODE VARCHAR2 Species Size Code On Observation Record
N/A
OBS_SPECIES_SIZE VARCHAR2 Species SIze description On Observation Record
N/A
OBS_GRADE VARCHAR2 Grade description On Observation Record
N/A
SEX VARCHAR2 Sex Recorded On Observation Record
N/A
QUANTITY NUMBER Quantity of fish taken On Observation Record
N/A
OBS_WEIGHT NUMBER Magnitude Of Weight On The Observation Record
N/A
OBS_WEIGHT_UNIT_ID VARCHAR2 Code to indicate units of weight on the observation record
N/A
OBS_WEIGHT_UNIT VARCHAR2 The actual weight unit on the observation record
N/A
OBS_WEIGHT_KG NUMBER The observation Weight in kilograms.
N/A
CONDITION_TYPE VARCHAR2 Code to indicate condition of animal at landing
N/A
LENGTH1 NUMBER The magnitude Of The first length measurement
N/A
LENGTH_TYPE_CODE1 VARCHAR2 Code to indicate type of the first length measurement taken
N/A
LENGTH_TYPE1 VARCHAR2 Indcates The kind of the first length measurement Taken
N/A
LENGTH_UNIT_CODE1 VARCHAR2 Code To Indicate Length Unit of first measurment Taken
N/A
LENGTH_UNIT1 VARCHAR2 Length Unit of first measurment Taken
N/A
LENGTH1_MM NUMBER The first length Measurment in Milimeters
N/A
LENGTH2 NUMBER The magnitude Of The second length measurement
N/A
LENGTH_TYPE_CODE2 VARCHAR2 Code to indicate type of the second length measurement taken
N/A
LENGTH_TYPE2 VARCHAR2 Indcates The kind of the second length measurement Taken
N/A
LENGTH_UNIT_CODE2 VARCHAR2 Length Unit of second measurment Taken
N/A
LENGTH_UNIT2 VARCHAR2 Length Unit of first measurment Taken
N/A
LENGTH2_MM NUMBER The second length Measurment in Milimeters
N/A
LENGTH3 NUMBER The magnitude Of The third length measurement
N/A
LENGTH_TYPE_CODE3 VARCHAR2 Code to indicate type of the third length measurement taken
N/A
LENGTH_TYPE3 VARCHAR2 Indcates The kind of the third length measurement Taken
N/A
LENGTH_UNIT_CODE3 VARCHAR2 Code to indicate Length Unit of thrid measurment Taken
N/A
LENGTH_UNIT3 VARCHAR2 Length Unit of third measurment Taken
N/A
LENGTH3_MM NUMBER The thrid length Measurment in Milimeters
N/A
SAMPLE_METHOD VARCHAR2 Sample Method
N/A
MATURITY_STAGE VARCHAR2 Maturity Stage
N/A
OBS_REPLICATE NUMBER Replicate Number In The Observation Table
N/A
OBS_OLD_SAMPLE_ID NUMBER Old Sample Id in the Observation Table
N/A
LINE_NUMBER NUMBER Line Number On Sample Record
N/A
START_LENGTH NUMBER Starting Length
N/A
END_LENGTH NUMBER End Length
N/A
EXACT_LENGTH VARCHAR2 Exact Length
N/A
LENGTH_INCREMENT NUMBER Incremental Increase for sampling between start and end length
N/A
UNUSUAL_LENGTH VARCHAR2 Indicates If Record is marked as having an unsually short or long length
N/A
OBS_COMMENT VARCHAR2 The comment on the observation record
N/A
OBSERVATION_ID NUMBER Link To Observation Table
N/A
TAG1 NUMBER First Tag Number on Record
N/A
SAMPLE_TYPE_1 VARCHAR2 Sample Type Associated With First Tag
N/A
TAG2 NUMBER Second Tag Number On Record
N/A
SAMPLE_TYPE_2 VARCHAR2 Sample Type Associated With Second Tag
N/A
TAG3 NUMBER Third Tag Number on Record
N/A
SAMPLE_TYPE3 VARCHAR2 Sample Type Associated With Third Tag
N/A
EFFORT_INTERVIEW_ID NUMBER Link Between Effort Table and Interview Table
N/A
NUMBER_OF_EFFORT_RECORDS NUMBER Number Of Effort Records Per Interview
N/A
GEAR_1 VARCHAR2 Local Gear Code For first Effort Record per Interview Id
N/A
GEARNAME_1 VARCHAR2 Local Gear Name For first Effort Record per Interview Id
N/A
STANDARDGEAR_1 VARCHAR2 Standard Gear Code For first Effort Record per Interview Id
N/A
STANDARDGEARNAME_1 VARCHAR2 Standard Gear Name For first Effort Record per Interview Id
N/A
GEAR_FREQUENCY_1 NUMBER frequency of gear use For the first first Record per Interview Id
N/A
GEAR_QTY_1 NUMBER quantity of gear used For first Effort Record per Interview Id
N/A
LINE_LENGTH_1 NUMBER line length of gear use For first Effort Record per Interview Id
N/A
SOAK_TIME_1 NUMBER hours the gear for first Effort Record was in the water
N/A
NUMBER_OF_GEAR_1 NUMBER The number of units of gear used to produce the landings for the first effort record.
N/A
AREA_1 NUMBER Local Area Code For first Effort Record per Interview Id
N/A
AREANAME_1 VARCHAR2 Local Area Name For first Effort Record per Interview Id
N/A
STANDARDAREA_1 NUMBER Standard Area Code For second first Record per Interview Id
N/A
STANDARDAREANAME_1 VARCHAR2 Standard Area Name For first Effort Record per Interview Id
N/A
MIN_DEPTH_1 NUMBER Minimum depth fished For First Effort Record per Interview Id
N/A
MAX_DEPTH_1 NUMBER Maximum depth fished For Third Effort Record per Interview Id
N/A
GEAR_2 VARCHAR2 Local Gear Code For second Effort Record per Interview Id
N/A
GEARNAME_2 VARCHAR2 Local Gear Name For second Effort Record per Interview Id
N/A
STANDARDGEAR_2 VARCHAR2 Standard Gear Code For second Effort Record per Interview Id
N/A
STANDARDGEARNAME_2 VARCHAR2 Standard Gear Name For the second Effort Record per Interview Id
N/A
GEAR_FREQUENCY_2 NUMBER frequency of gear use For the second Effort Record per Interview Id
N/A
GEAR_QTY_2 NUMBER quantity of gear used For second Effort Record per Interview Id
N/A
LINE_LENGTH_2 NUMBER line length of gear use For second Effort Record per Interview Id
N/A
SOAK_TIME_2 NUMBER hours the gear for second Effort Record was in the water
N/A
NUMBER_OF_GEAR_2 NUMBER The number of units of gear used to produce the landings for the second effort record.
N/A
AREA_2 NUMBER Local Area Code For second Effort Record per Interview Id
N/A
AREANAME_2 VARCHAR2 Local Area Name For second Effort Record per Interview Id
N/A
STANDARDAREA_2 NUMBER Standard Area Code For second Effort Record per Interview Id
N/A
STANDARDAREANAME_2 VARCHAR2 Standard Area Name For second Effort Record per Interview Id
N/A
MIN_DEPTH_2 NUMBER minimum depth fished For Second Effort Record per Interview Id
N/A
MAX_DEPTH_2 NUMBER maximum depth fished For Second Effort Record per Interview Id
N/A
GEAR_3 VARCHAR2 Local Gear Code For third Effort Record per Interview Id
N/A
GEARNAME_3 VARCHAR2 Local Gear Name For third Effort Record per Interview Id
N/A
STANDARDGEAR_3 VARCHAR2 Standard Gear Code For third Effort Record per Interview Id
N/A
STANDARDGEARNAME_3 VARCHAR2 Standard Gear Name For third Effort Record per Interview Id
N/A
GEAR_FREQUENCY_3 NUMBER frequency of gear use For the third Effort Record per Interview Id
N/A
GEAR_QTY_3 NUMBER quantity of gear used For third Effort Record per Interview Id
N/A
LINE_LENGTH_3 NUMBER line length of gear use For third Effort Record per Interview Id
N/A
SOAK_TIME_3 NUMBER hours the gear for third Effort Record was in the water
N/A
NUMBER_OF_GEAR_3 NUMBER The number of units of gear used to produce the landings for the third effort record.
N/A
AREA_3 NUMBER Local Area Code For third Effort Record per Interview Id
N/A
AREANAME_3 VARCHAR2 Local Area Name For third Effort Record per Interview Id
N/A
STANDARDAREA_3 NUMBER Standard Area Code For third Effort Record per Interview Id
N/A
STANDARDAREANAME_3 VARCHAR2 Standard Area Name For third Effort Record per Interview Id
N/A
MIN_DEPTH_3 NUMBER Minimum depth fished For Third Effort Record per Interview Id
N/A
MAX_DEPTH_3 NUMBER Maximum depth fished For Third Effort Record per Interview Id
N/A
GEAR_4 VARCHAR2 Local Gear Code For fourth Effort Record per Interview Id
N/A
GEARNAME_4 VARCHAR2 Local Gear Name For fourth Effort Record per Interview Id
N/A
STANDARDGEAR_4 VARCHAR2 Standard Gear Code For fourth Effort Record per Interview Id
N/A
STANDARDGEARNAME_4 VARCHAR2 Standard Gear Name For fourth Effort Record per Interview Id
N/A
GEAR_FREQUENCY_4 NUMBER frequency of gear use For the fourth Effort Record per Interview Id
N/A
GEAR_QTY_4 NUMBER quantity of gear used For fourth Effort Record per Interview Id
N/A
LINE_LENGTH_4 NUMBER line length of gear use For fourth Effort Record per Interview Id
N/A
SOAK_TIME_4 NUMBER hours the gear for fourth Effort Record was in the water
N/A
NUMBER_OF_GEAR_4 NUMBER The number of units of gear used to produce the landings for the fourth effort record.
N/A
AREA_4 NUMBER Local Area Code For fourth Effort Record per Interview Id
N/A
AREANAME_4 VARCHAR2 Local Area Name For fourth Effort Record per Interview
N/A
STANDARDAREA_4 NUMBER Standard Area Code For fourth Effort Record per Interview Id
N/A
STANDARDAREANAME_4 VARCHAR2 Standard Area Name For fourth Effort Record per Interview Id
N/A
MIN_DEPTH_4 NUMBER Minimum depth fished For Fourth Effort Record per Interview Id
N/A
MAX_DEPTH_4 NUMBER Maximum depth fished For Fifth fourth Record per Interview Id
N/A
GEAR_5 VARCHAR2 Local Gear Code For fifth Effort Record per Interview Id
N/A
GEARNAME_5 VARCHAR2 Local Gear Name For fifth Effort Record per Interview Id
N/A
STANDARDGEAR_5 VARCHAR2 Standard Gear Code For fifth Effort Record per Interview Id
N/A
STANDARDGEARNAME_5 VARCHAR2 Standard Gear Name For fifth Effort Record per Interview Id
N/A
GEAR_FREQUENCY_5 NUMBER frequency of gear use For the fifth Effort Record per Interview Id
N/A
GEAR_QTY_5 NUMBER quantity of gear used For fifth Effort Record per Interview Id
N/A
LINE_LENGTH_5 NUMBER line length of gear use For fifth Effort Record per Interview Id
N/A
SOAK_TIME_5 NUMBER hours the gear for fifth Effort Record was in the water
N/A
NUMBER_OF_GEAR_5 NUMBER The number of units of gear used to produce the landings for the fifth effort record.
N/A
AREA_5 NUMBER Local Area Code For fifth Effort Record per Interview Id
N/A
AREANAME_5 VARCHAR2 Local Area Code For fifth Effort Record per Interview Id
N/A
STANDARDAREA_5 NUMBER Standard Area Code For fifth Effort Record per Interview Id
N/A
STANDARDAREANAME_5 VARCHAR2 Standard Area Name For fifth Effort Record per Interview Id
N/A
MIN_DEPTH_5 NUMBER Minimum depth fished For Fifth Effort Record per Interview Id
N/A
MAX_DEPTH_5 NUMBER Maximum depth fished For Fifth Effort Record per Interview Id
N/A
INTERVIEW_UNIQUE NUMBER Interview Unique
N/A
EFFORT_UNIQUE NUMBER Indicates If There is only one effort record per interview record
N/A
LANDING_UNIQUE NUMBER Indicates If There is only one landing record per effort record
N/A
SAMPLE_UNIQUE NUMBER Indicates If There is only one sample record per landing record
N/A
OBSERVATION_UNIQUE NUMBER Indicates If There is only one observation record per effort sample
N/A
OBSERVATION_SAMPLE_UNIQUE NUMBER Indicates If There is one observation record per sample record

Attribute Details

AGENT_USERNAME_ID

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

Name/Code corresponding to Agent who provided/isresponsible for data

General Data Type: VARCHAR2

ID

CC ID: 33390
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: 33391
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: 33392
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: 33393
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: 33394
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: 33395
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: 33396
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: 33397
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: 33398
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: 33399
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: 33400
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: 33401
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: 33402
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: 33403
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: 33404
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: 33405
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: 33406
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: 33407
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: 33408
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: 33409
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: 33410
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: 33411
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: 33412
Seq. Order: 24
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Name of Dealer That purchased the catch

General Data Type: VARCHAR2

DEALER_CODE

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

Code of Dealer that purchased The Catch

General Data Type: VARCHAR2

NBR_VESSELS

CC ID: 33414
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: 33415
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: 33416
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: 33417
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: 33418
Seq. Order: 30
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Type Of Landing

General Data Type: VARCHAR2

BIAS_TYPE

CC ID: 33419
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: 33420
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: 33421
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: 33422
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: 33423
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: 33424
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: 33425
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: 33426
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: 33427
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: 33428
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: 33429
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: 33430
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: 33431
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: 33432
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: 33433
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: 33434
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: 33435
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: 33436
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: 33437
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: 33438
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

LAND_INTERVIEW_ID

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

Foreign Key to Interview Table

General Data Type: NUMBER

LAND_ID

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

Key to Landings Table

General Data Type: NUMBER

LAND_GEAR_CODE

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

Key to agency specific gear table on the landings record

General Data Type: VARCHAR2

LAND_GEAR_NAME

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

Gear Name associated with agency specific gear code on the lnadings record

General Data Type: VARCHAR2

LAND_AREA

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

Key to agency specific area table telling the primary area where fishing occurred on the landings record

General Data Type: NUMBER

LAND_AREA_NAME

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

Area Name associated with agency specific area table telling the primary area where fishing occurred on the landings record

General Data Type: VARCHAR2

LAND_SCIENTIFIC_NAME

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

Scientific Name On Landings Record

General Data Type: VARCHAR2

LAND_SPECIES_CODE

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

Species Code On Landings Record

General Data Type: VARCHAR2

LAND_AGENCY_SPC_NAME

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

Agency Specific Name On Landings Record

General Data Type: VARCHAR2

LAND_SPECIES_SIZE

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

Key to size (MIXED/UNSIZED, JUMBO, etc) on Landings Record

General Data Type: VARCHAR2

LAND_GRADE

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

Grade on the Landings Record

General Data Type: VARCHAR2

LAND_SAMPLE_COUNT

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

Number Of Sample Records Associated ed with landings record

General Data Type: NUMBER

LAND_WEIGHT

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

Total weight on the Landings Record

General Data Type: NUMBER

LAND_WEIGHT_UNIT_CODE

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

Weight unit code on the Landings Record

General Data Type: VARCHAR2

LAND_WEIGHT_UNIT

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

Decode of Weight unit code on the Landings Record

General Data Type: VARCHAR2

LAND_WEIGHT_KG

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

Total weight in kilograms on the Landings Record

General Data Type: NUMBER

LAND_CONDITION

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

Condition Of fish landed on the Landings Record

General Data Type: VARCHAR2

LAND_MARKET_CNT_MIN

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

Minimun number of individuals per unit for this category on the landings record

General Data Type: NUMBER

LAND_MARKET_CNT_MAX

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

Maximun number of individuals per unit for this category on the landings record

General Data Type: NUMBER

LAND_REGION

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

Region (GULF, ATLANTIC, etc) on the Landings Record

General Data Type: VARCHAR2

LAND_REPLICATE

CC ID: 33459
Seq. Order: 71
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Part of key ON landings record to relate the data back to the historical data.

General Data Type: NUMBER

LANDING_COMMENT

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

Comment on this landing record

General Data Type: VARCHAR2

SAMPLE_INTERVIEW_ID

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

Link Between Sample and Interview Table

General Data Type: NUMBER

SAMPLE_LAND_ID

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

Link from sampe To Landings Table

General Data Type: NUMBER

SAMPLE_ID

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

Sample Id Number (Primary Key on Sa,ple Table)

General Data Type: NUMBER

SAMPLE_SPECIES_CODE

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

Sample Local Species Code

General Data Type: VARCHAR2

SAMPLE_AGENCY_SPC_NAME

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

Sample Local Species Name

General Data Type: VARCHAR2

SAMPLE_SCIENTIFIC_NAME

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

Sample Scientific Name

General Data Type: VARCHAR2

SAMPLE_SIZE_CODE

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

Sample Size Code

General Data Type: VARCHAR2

SAMPLE_SPECIES_SIZE

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

Decode Sample Species Size Code

General Data Type: VARCHAR2

SAMPLE_GRADE

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

Sample Grade Description

General Data Type: VARCHAR2

S_SAMPLE_COUNT

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

Number of sub-sample records associated with sample record

General Data Type: NUMBER

SAMPLE_WEIGHT

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

Sample Weight

General Data Type: NUMBER

SAMPLE_WEIGHT_UNIT_ID

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

Sample Weight Code

General Data Type: VARCHAR2

SAMPLE_WEIGHT_UNIT

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

Sample Weight Unit Decoded

General Data Type: VARCHAR2

SAMPLE_WEIGHT_KG

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

Sample Weight in kilograms

General Data Type: NUMBER

SAMPLE_CONDITION

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

Sample Condition Description

General Data Type: VARCHAR2

FULL_CATCH

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

Indicates If Sample was the full catch of the boat

General Data Type: VARCHAR2

SAMPLE_METHOD_TYPE_CODE

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

Sampling Method Type Code

General Data Type: VARCHAR2

SAMPLE_METHOD_TYPE

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

Sample Method Type

General Data Type: VARCHAR2

SAMPLE_RANDOM

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

Indicates If this is (statistically) a random sample

General Data Type: VARCHAR2

SUB_SAMPLE_COUNT

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

Number of weights/records in the sub-sample

General Data Type: NUMBER

SUB_SAMPLE_WEIGHT_UNIT_CODE

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

Sub Sample Weight Units Code

General Data Type: VARCHAR2

SUB_SAMPLE_WEIGHT_UNIT

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

Sub Sample Weight Units

General Data Type: VARCHAR2

SUB_SAMPLE_WEIGHT

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

Sub Sample Weight associated with weight units

General Data Type: NUMBER

SUB_SAMPLE_WEIGHT_KG

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

Sub Sample Weight in Kilograms

General Data Type: NUMBER

SUB_SAMPLE_CONDITION

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

Sub Sample Condition Code

General Data Type: VARCHAR2

SUB_SAMPLE_RANDOM

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

Indicates If this is (statistically) a random sub-sample

General Data Type: VARCHAR2

SAMPLE_REPLICATE

CC ID: 33487
Seq. Order: 99
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Historical Replicate Number

General Data Type: NUMBER

SAMPLE_SAMPLE_NUMBER_OLD

CC ID: 33488
Seq. Order: 100
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Historical Sample Number

General Data Type: NUMBER

OBS_ID

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

Key to Observation Table

General Data Type: NUMBER

OBS_SAMPLE_ID

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

Key to Observation Sample Table

General Data Type: NUMBER

OBS_INTERVIEW_ID

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

Link To Interview Table

General Data Type: NUMBER

OBS_SPECIES_CODE

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

Species Code On Observation Record

General Data Type: VARCHAR2

OBS_AGENCY_SPC_NAME

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

Agency Specific Species Name On Observation Record

General Data Type: VARCHAR2

OBS_SCIENTIFIC_NAME

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

Scientific Name Corresponding to Agency Specific Species Name On Observation Record

General Data Type: VARCHAR2

OBS_SPECIES_SIZE_CODE

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

Species Size Code On Observation Record

General Data Type: VARCHAR2

OBS_SPECIES_SIZE

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

Species SIze description On Observation Record

General Data Type: VARCHAR2

OBS_GRADE

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

Grade description On Observation Record

General Data Type: VARCHAR2

SEX

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

Sex Recorded On Observation Record

General Data Type: VARCHAR2

QUANTITY

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

Quantity of fish taken On Observation Record

General Data Type: NUMBER

OBS_WEIGHT

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

Magnitude Of Weight On The Observation Record

General Data Type: NUMBER

OBS_WEIGHT_UNIT_ID

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

Code to indicate units of weight on the observation record

General Data Type: VARCHAR2

OBS_WEIGHT_UNIT

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

The actual weight unit on the observation record

General Data Type: VARCHAR2

OBS_WEIGHT_KG

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

The observation Weight in kilograms.

General Data Type: NUMBER

CONDITION_TYPE

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

Code to indicate condition of animal at landing

General Data Type: VARCHAR2

LENGTH1

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

The magnitude Of The first length measurement

General Data Type: NUMBER

LENGTH_TYPE_CODE1

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

Code to indicate type of the first length measurement taken

General Data Type: VARCHAR2

LENGTH_TYPE1

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

Indcates The kind of the first length measurement Taken

General Data Type: VARCHAR2

LENGTH_UNIT_CODE1

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

Code To Indicate Length Unit of first measurment Taken

General Data Type: VARCHAR2

LENGTH_UNIT1

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

Length Unit of first measurment Taken

General Data Type: VARCHAR2

LENGTH1_MM

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

The first length Measurment in Milimeters

General Data Type: NUMBER

LENGTH2

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

The magnitude Of The second length measurement

General Data Type: NUMBER

LENGTH_TYPE_CODE2

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

Code to indicate type of the second length measurement taken

General Data Type: VARCHAR2

LENGTH_TYPE2

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

Indcates The kind of the second length measurement Taken

General Data Type: VARCHAR2

LENGTH_UNIT_CODE2

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

Length Unit of second measurment Taken

General Data Type: VARCHAR2

LENGTH_UNIT2

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

Length Unit of first measurment Taken

General Data Type: VARCHAR2

LENGTH2_MM

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

The second length Measurment in Milimeters

General Data Type: NUMBER

LENGTH3

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

The magnitude Of The third length measurement

General Data Type: NUMBER

LENGTH_TYPE_CODE3

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

Code to indicate type of the third length measurement taken

General Data Type: VARCHAR2

LENGTH_TYPE3

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

Indcates The kind of the third length measurement Taken

General Data Type: VARCHAR2

LENGTH_UNIT_CODE3

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

Code to indicate Length Unit of thrid measurment Taken

General Data Type: VARCHAR2

LENGTH_UNIT3

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

Length Unit of third measurment Taken

General Data Type: VARCHAR2

LENGTH3_MM

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

The thrid length Measurment in Milimeters

General Data Type: NUMBER

SAMPLE_METHOD

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

Sample Method

General Data Type: VARCHAR2

MATURITY_STAGE

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

Maturity Stage

General Data Type: VARCHAR2

OBS_REPLICATE

CC ID: 33525
Seq. Order: 137
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Replicate Number In The Observation Table

General Data Type: NUMBER

OBS_OLD_SAMPLE_ID

CC ID: 33526
Seq. Order: 138
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Old Sample Id in the Observation Table

General Data Type: NUMBER

LINE_NUMBER

CC ID: 33527
Seq. Order: 139
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Line Number On Sample Record

General Data Type: NUMBER

START_LENGTH

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

Starting Length

General Data Type: NUMBER

END_LENGTH

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

End Length

General Data Type: NUMBER

EXACT_LENGTH

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

Exact Length

General Data Type: VARCHAR2

LENGTH_INCREMENT

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

Incremental Increase for sampling between start and end length

General Data Type: NUMBER

UNUSUAL_LENGTH

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

Indicates If Record is marked as having an unsually short or long length

General Data Type: VARCHAR2

OBS_COMMENT

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

The comment on the observation record

General Data Type: VARCHAR2

OBSERVATION_ID

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

Link To Observation Table

General Data Type: NUMBER

TAG1

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

First Tag Number on Record

General Data Type: NUMBER

SAMPLE_TYPE_1

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

Sample Type Associated With First Tag

General Data Type: VARCHAR2

TAG2

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

Second Tag Number On Record

General Data Type: NUMBER

SAMPLE_TYPE_2

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

Sample Type Associated With Second Tag

General Data Type: VARCHAR2

TAG3

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

Third Tag Number on Record

General Data Type: NUMBER

SAMPLE_TYPE3

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

Sample Type Associated With Third Tag

General Data Type: VARCHAR2

EFFORT_INTERVIEW_ID

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

Link Between Effort Table and Interview Table

General Data Type: NUMBER

NUMBER_OF_EFFORT_RECORDS

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

Number Of Effort Records Per Interview

General Data Type: NUMBER

GEAR_1

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

Local Gear Code For first Effort Record per Interview Id

General Data Type: VARCHAR2

GEARNAME_1

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

Local Gear Name For first Effort Record per Interview Id

General Data Type: VARCHAR2

STANDARDGEAR_1

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

Standard Gear Code For first Effort Record per Interview Id

General Data Type: VARCHAR2

STANDARDGEARNAME_1

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

Standard Gear Name For first Effort Record per Interview Id

General Data Type: VARCHAR2

GEAR_FREQUENCY_1

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

frequency of gear use For the first first Record per Interview Id

General Data Type: NUMBER

GEAR_QTY_1

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

quantity of gear used For first Effort Record per Interview Id

General Data Type: NUMBER

LINE_LENGTH_1

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

line length of gear use For first Effort Record per Interview Id

General Data Type: NUMBER

SOAK_TIME_1

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

hours the gear for first Effort Record was in the water

General Data Type: NUMBER

NUMBER_OF_GEAR_1

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

The number of units of gear used to produce the landings for the first effort record.

General Data Type: NUMBER

AREA_1

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

Local Area Code For first Effort Record per Interview Id

General Data Type: NUMBER

AREANAME_1

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

Local Area Name For first Effort Record per Interview Id

General Data Type: VARCHAR2

STANDARDAREA_1

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

Standard Area Code For second first Record per Interview Id

General Data Type: NUMBER

STANDARDAREANAME_1

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

Standard Area Name For first Effort Record per Interview Id

General Data Type: VARCHAR2

MIN_DEPTH_1

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

Minimum depth fished For First Effort Record per Interview Id

General Data Type: NUMBER

MAX_DEPTH_1

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

Maximum depth fished For Third Effort Record per Interview Id

General Data Type: NUMBER

GEAR_2

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

Local Gear Code For second Effort Record per Interview Id

General Data Type: VARCHAR2

GEARNAME_2

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

Local Gear Name For second Effort Record per Interview Id

General Data Type: VARCHAR2

STANDARDGEAR_2

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

Standard Gear Code For second Effort Record per Interview Id

General Data Type: VARCHAR2

STANDARDGEARNAME_2

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

Standard Gear Name For the second Effort Record per Interview Id

General Data Type: VARCHAR2

GEAR_FREQUENCY_2

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

frequency of gear use For the second Effort Record per Interview Id

General Data Type: NUMBER

GEAR_QTY_2

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

quantity of gear used For second Effort Record per Interview Id

General Data Type: NUMBER

LINE_LENGTH_2

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

line length of gear use For second Effort Record per Interview Id

General Data Type: NUMBER

SOAK_TIME_2

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

hours the gear for second Effort Record was in the water

General Data Type: NUMBER

NUMBER_OF_GEAR_2

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

The number of units of gear used to produce the landings for the second effort record.

General Data Type: NUMBER

AREA_2

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

Local Area Code For second Effort Record per Interview Id

General Data Type: NUMBER

AREANAME_2

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

Local Area Name For second Effort Record per Interview Id

General Data Type: VARCHAR2

STANDARDAREA_2

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

Standard Area Code For second Effort Record per Interview Id

General Data Type: NUMBER

STANDARDAREANAME_2

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

Standard Area Name For second Effort Record per Interview Id

General Data Type: VARCHAR2

MIN_DEPTH_2

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

minimum depth fished For Second Effort Record per Interview Id

General Data Type: NUMBER

MAX_DEPTH_2

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

maximum depth fished For Second Effort Record per Interview Id

General Data Type: NUMBER

GEAR_3

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

Local Gear Code For third Effort Record per Interview Id

General Data Type: VARCHAR2

GEARNAME_3

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

Local Gear Name For third Effort Record per Interview Id

General Data Type: VARCHAR2

STANDARDGEAR_3

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

Standard Gear Code For third Effort Record per Interview Id

General Data Type: VARCHAR2

STANDARDGEARNAME_3

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

Standard Gear Name For third Effort Record per Interview Id

General Data Type: VARCHAR2

GEAR_FREQUENCY_3

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

frequency of gear use For the third Effort Record per Interview Id

General Data Type: NUMBER

GEAR_QTY_3

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

quantity of gear used For third Effort Record per Interview Id

General Data Type: NUMBER

LINE_LENGTH_3

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

line length of gear use For third Effort Record per Interview Id

General Data Type: NUMBER

SOAK_TIME_3

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

hours the gear for third Effort Record was in the water

General Data Type: NUMBER

NUMBER_OF_GEAR_3

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

The number of units of gear used to produce the landings for the third effort record.

General Data Type: NUMBER

AREA_3

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

Local Area Code For third Effort Record per Interview Id

General Data Type: NUMBER

AREANAME_3

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

Local Area Name For third Effort Record per Interview Id

General Data Type: VARCHAR2

STANDARDAREA_3

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

Standard Area Code For third Effort Record per Interview Id

General Data Type: NUMBER

STANDARDAREANAME_3

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

Standard Area Name For third Effort Record per Interview Id

General Data Type: VARCHAR2

MIN_DEPTH_3

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

Minimum depth fished For Third Effort Record per Interview Id

General Data Type: NUMBER

MAX_DEPTH_3

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

Maximum depth fished For Third Effort Record per Interview Id

General Data Type: NUMBER

GEAR_4

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

Local Gear Code For fourth Effort Record per Interview Id

General Data Type: VARCHAR2

GEARNAME_4

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

Local Gear Name For fourth Effort Record per Interview Id

General Data Type: VARCHAR2

STANDARDGEAR_4

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

Standard Gear Code For fourth Effort Record per Interview Id

General Data Type: VARCHAR2

STANDARDGEARNAME_4

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

Standard Gear Name For fourth Effort Record per Interview Id

General Data Type: VARCHAR2

GEAR_FREQUENCY_4

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

frequency of gear use For the fourth Effort Record per Interview Id

General Data Type: NUMBER

GEAR_QTY_4

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

quantity of gear used For fourth Effort Record per Interview Id

General Data Type: NUMBER

LINE_LENGTH_4

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

line length of gear use For fourth Effort Record per Interview Id

General Data Type: NUMBER

SOAK_TIME_4

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

hours the gear for fourth Effort Record was in the water

General Data Type: NUMBER

NUMBER_OF_GEAR_4

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

The number of units of gear used to produce the landings for the fourth effort record.

General Data Type: NUMBER

AREA_4

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

Local Area Code For fourth Effort Record per Interview Id

General Data Type: NUMBER

AREANAME_4

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

Local Area Name For fourth Effort Record per Interview

General Data Type: VARCHAR2

STANDARDAREA_4

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

Standard Area Code For fourth Effort Record per Interview Id

General Data Type: NUMBER

STANDARDAREANAME_4

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

Standard Area Name For fourth Effort Record per Interview Id

General Data Type: VARCHAR2

MIN_DEPTH_4

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

Minimum depth fished For Fourth Effort Record per Interview Id

General Data Type: NUMBER

MAX_DEPTH_4

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

Maximum depth fished For Fifth fourth Record per Interview Id

General Data Type: NUMBER

GEAR_5

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

Local Gear Code For fifth Effort Record per Interview Id

General Data Type: VARCHAR2

GEARNAME_5

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

Local Gear Name For fifth Effort Record per Interview Id

General Data Type: VARCHAR2

STANDARDGEAR_5

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

Standard Gear Code For fifth Effort Record per Interview Id

General Data Type: VARCHAR2

STANDARDGEARNAME_5

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

Standard Gear Name For fifth Effort Record per Interview Id

General Data Type: VARCHAR2

GEAR_FREQUENCY_5

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

frequency of gear use For the fifth Effort Record per Interview Id

General Data Type: NUMBER

GEAR_QTY_5

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

quantity of gear used For fifth Effort Record per Interview Id

General Data Type: NUMBER

LINE_LENGTH_5

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

line length of gear use For fifth Effort Record per Interview Id

General Data Type: NUMBER

SOAK_TIME_5

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

hours the gear for fifth Effort Record was in the water

General Data Type: NUMBER

NUMBER_OF_GEAR_5

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

The number of units of gear used to produce the landings for the fifth effort record.

General Data Type: NUMBER

AREA_5

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

Local Area Code For fifth Effort Record per Interview Id

General Data Type: NUMBER

AREANAME_5

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

Local Area Code For fifth Effort Record per Interview Id

General Data Type: VARCHAR2

STANDARDAREA_5

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

Standard Area Code For fifth Effort Record per Interview Id

General Data Type: NUMBER

STANDARDAREANAME_5

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

Standard Area Name For fifth Effort Record per Interview Id

General Data Type: VARCHAR2

MIN_DEPTH_5

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

Minimum depth fished For Fifth Effort Record per Interview Id

General Data Type: NUMBER

MAX_DEPTH_5

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

Maximum depth fished For Fifth Effort Record per Interview Id

General Data Type: NUMBER

INTERVIEW_UNIQUE

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

Interview Unique

General Data Type: NUMBER

EFFORT_UNIQUE

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

Indicates If There is only one effort record per interview record

General Data Type: NUMBER

LANDING_UNIQUE

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

Indicates If There is only one landing record per effort record

General Data Type: NUMBER

SAMPLE_UNIQUE

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

Indicates If There is only one sample record per landing record

General Data Type: NUMBER

OBSERVATION_UNIQUE

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

Indicates If There is only one observation record per effort sample

General Data Type: NUMBER

OBSERVATION_SAMPLE_UNIQUE

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

Indicates If There is one observation record per sample record

General Data Type: NUMBER

Catalog Details

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