Slide Menu
Search Help Show/Hide Menu

Item Identification

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

Gives One Long Effort Record Per Interview containing all of the gear/area combinations and decodes of all codes

Notes:

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

Entity Information

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

Gives One Long Effort Record Per Interview containing all of the gear/area combinations and decodes of all codes

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
EFFORT_INTERVIEW_ID NUMBER Key to Interview Table
N/A
NUMBER_OF_EFFORT_RECORDS NUMBER Number Of Effort Records per Interview Id
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 first Effort 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 first Effort 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 First 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 second Effort Record per Interview Id
N/A
GEAR_FREQUENCY_2 NUMBER frequency of gear use For 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 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 maximum depth fished For Third Effort Record per Interview Id
N/A
MAX_DEPTH_3 NUMBER minimum 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 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 Id
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 fourth Effort 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 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 Name 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

Attribute Details

EFFORT_INTERVIEW_ID

CC ID: 33170
Seq. Order: 1
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

NUMBER_OF_EFFORT_RECORDS

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

Number Of Effort Records per Interview Id

General Data Type: NUMBER

GEAR_1

CC ID: 33172
Seq. Order: 3
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: 33173
Seq. Order: 4
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: 33174
Seq. Order: 5
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: 33175
Seq. Order: 6
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: 33176
Seq. Order: 7
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

frequency of gear use For first Effort Record per Interview Id

General Data Type: NUMBER

GEAR_QTY_1

CC ID: 33177
Seq. Order: 8
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: 33178
Seq. Order: 9
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: 33179
Seq. Order: 10
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: 33180
Seq. Order: 11
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: 33181
Seq. Order: 12
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: 33182
Seq. Order: 13
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: 33183
Seq. Order: 14
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Standard Area Code For first Effort Record per Interview Id

General Data Type: NUMBER

STANDARDAREANAME_1

CC ID: 33184
Seq. Order: 15
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: 33185
Seq. Order: 16
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: 33186
Seq. Order: 17
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

maximum depth fished For First Effort Record per Interview Id

General Data Type: NUMBER

GEAR_2

CC ID: 33187
Seq. Order: 18
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: 33188
Seq. Order: 19
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: 33189
Seq. Order: 20
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: 33190
Seq. Order: 21
Data Storage Type: VARCHAR2
Max Length: 4000
Required: No
Primary Key: No
Status: Active
Description:

Standard Gear Name For second Effort Record per Interview Id

General Data Type: VARCHAR2

GEAR_FREQUENCY_2

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

frequency of gear use For second Effort Record per Interview Id

General Data Type: NUMBER

GEAR_QTY_2

CC ID: 33192
Seq. Order: 23
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: 33193
Seq. Order: 24
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: 33194
Seq. Order: 25
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: 33195
Seq. Order: 26
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: 33196
Seq. Order: 27
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: 33197
Seq. Order: 28
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: 33198
Seq. Order: 29
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: 33199
Seq. Order: 30
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: 33200
Seq. Order: 31
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: 33201
Seq. Order: 32
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: 33202
Seq. Order: 33
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: 33203
Seq. Order: 34
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: 33204
Seq. Order: 35
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: 33205
Seq. Order: 36
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: 33206
Seq. Order: 37
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

frequency of gear use For third Effort Record per Interview Id

General Data Type: NUMBER

GEAR_QTY_3

CC ID: 33207
Seq. Order: 38
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: 33208
Seq. Order: 39
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: 33209
Seq. Order: 40
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: 33210
Seq. Order: 41
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: 33211
Seq. Order: 42
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: 33212
Seq. Order: 43
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: 33213
Seq. Order: 44
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: 33214
Seq. Order: 45
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: 33215
Seq. Order: 46
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

MAX_DEPTH_3

CC ID: 33216
Seq. Order: 47
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

GEAR_4

CC ID: 33217
Seq. Order: 48
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: 33218
Seq. Order: 49
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: 33219
Seq. Order: 50
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: 33220
Seq. Order: 51
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: 33221
Seq. Order: 52
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

frequency of gear use For fourth Effort Record per Interview Id

General Data Type: NUMBER

GEAR_QTY_4

CC ID: 33222
Seq. Order: 53
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: 33223
Seq. Order: 54
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: 33224
Seq. Order: 55
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: 33225
Seq. Order: 56
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: 33226
Seq. Order: 57
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: 33227
Seq. Order: 58
Data Storage Type: VARCHAR2
Max Length: 4000
Required: No
Primary Key: No
Status: Active
Description:

Local Area Name For fourth Effort Record per Interview Id

General Data Type: VARCHAR2

STANDARDAREA_4

CC ID: 33228
Seq. Order: 59
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: 33229
Seq. Order: 60
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: 33230
Seq. Order: 61
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: 33231
Seq. Order: 62
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

maximum depth fished For fourth Effort Record per Interview Id

General Data Type: NUMBER

GEAR_5

CC ID: 33232
Seq. Order: 63
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: 33233
Seq. Order: 64
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: 33234
Seq. Order: 65
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: 33235
Seq. Order: 66
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: 33236
Seq. Order: 67
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

frequency of gear use For fifth Effort Record per Interview Id

General Data Type: NUMBER

GEAR_QTY_5

CC ID: 33160
Seq. Order: 68
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: 33161
Seq. Order: 69
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: 33162
Seq. Order: 70
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: 33163
Seq. Order: 71
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: 33164
Seq. Order: 72
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: 33165
Seq. Order: 73
Data Storage Type: VARCHAR2
Max Length: 4000
Required: No
Primary Key: No
Status: Active
Description:

Local Area Name For fifth Effort Record per Interview Id

General Data Type: VARCHAR2

STANDARDAREA_5

CC ID: 33166
Seq. Order: 74
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: 33167
Seq. Order: 75
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: 33168
Seq. Order: 76
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: 33169
Seq. Order: 77
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

Catalog Details

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