Slide Menu
Search Help Show/Hide Menu

Item Identification

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

Table Describing FIshing Effort

Notes:

Loaded by batch 2004, 12-03-2007 09:39

Entity Information

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

Table Describing FIshing Effort

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key ID NUMBER unique id
100
INTERVIEW_ID NUMBER Unique key
100
GEAR_CODE VARCHAR2 Gear Code
100
CREATED_DATE DATE Date/Time stamp of record creation
100
CREATED_BY_USER_ID VARCHAR2 User creating Record
100
MAX_DEPTH NUMBER max depth fished
100
LAT_SECOND NUMBER latitude second
100
LONG_MINUTE NUMBER longitude minute
100
AREA_QUADRANT NUMBER 1-4 range
100
GEAR_TOTAL_LINE_LENGTH NUMBER total line length of all gear used
100
LONG_HEMISPHERE VARCHAR2 longitude hemisphere
100
GEAR_NUMBER_SET NUMBER how many of this gear type did you set
100
GEAR_QTY NUMBER quantity of gear used. Note that for Hook and Line gear in Puerto Rico, this column has been used to record total number of hooks, not number of lines.
100
LAT_DEGREE NUMBER latitude degree
100
LONG_SECOND NUMBER longitude second
100
GEAR_USE_FREQ NUMBER frequency of gear use
100
LONG_DEGREE NUMBER longitude degree
100
SOAK_TIME NUMBER hours the gear was in the water
100
AREA_10_MIN NUMBER 1-36 range
100
GEAR_AVG_INFO NUMBER avg size information about gear. Please note that for Puerto Rico hook and line gear, this column has been recorded as '1' with total number of hooks entered in the gear qty column. This because Puerto Rico has in the past collected only total hook data. See note in GEAR_QTY column.
100
MIN_DEPTH NUMBER min depth fished
100
DISTANCE_TO_SHORE_MILES NUMBER how many miles to shore
100
LAT_HEMISPHERE VARCHAR2 latitude hemisphere
100
COMMENTS VARCHAR2 comments
100
GEAR_AVG_MILES_PER_SET NUMBER avg miles fished per set
100
LAT_MINUTE NUMBER latitude minute
100
REGION_ID NUMBER Key to Region (GULF, ATLANTIC, etc)
100
MODIFIED_BY_USER_ID VARCHAR2 User modifying record
100
MODIFIED_DATE DATE Date/Time stamp of when record was modifed
100
AREA_ID NUMBER Key to area, which is a smaller location than county
100
GEAR_SIZE NUMBER For Nets or Traps, enter the diagonal mesh or slot size in inches. When measuring nets stretch the mesh closed.
100
STANDARD_GEAR_ID VARCHAR2 Key to standard_gear, allowing each agency to have their own gear code, but each code must relate to a standard gear code.
100
STANDARD_AREA_ID NUMBER Key to standard_area, allowing each agency to have their own area code, but each code must relate to a standard area code.
100
RECORD_TYPE VARCHAR2 For historical data, part of compound key that identifies a unique effort record in SEFSC.TIP_TIP12

Attribute Details

ID

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

unique id

General Data Type: NUMBER

INTERVIEW_ID

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

Unique key

General Data Type: NUMBER

GEAR_CODE

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

Gear Code

General Data Type: VARCHAR2

CREATED_DATE

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

Date/Time stamp of record creation

General Data Type: DATE

CREATED_BY_USER_ID

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

User creating Record

General Data Type: VARCHAR2

MAX_DEPTH

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

max depth fished

General Data Type: NUMBER

LAT_SECOND

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

latitude second

General Data Type: NUMBER

LONG_MINUTE

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

longitude minute

General Data Type: NUMBER

AREA_QUADRANT

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

1-4 range

General Data Type: NUMBER

GEAR_TOTAL_LINE_LENGTH

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

total line length of all gear used

General Data Type: NUMBER

LONG_HEMISPHERE

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

longitude hemisphere

General Data Type: VARCHAR2

GEAR_NUMBER_SET

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

how many of this gear type did you set

General Data Type: NUMBER

GEAR_QTY

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

quantity of gear used. Note that for Hook and Line gear in Puerto Rico, this column has been used to record total number of hooks, not number of lines.

General Data Type: NUMBER

LAT_DEGREE

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

latitude degree

General Data Type: NUMBER

LONG_SECOND

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

longitude second

General Data Type: NUMBER

GEAR_USE_FREQ

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

frequency of gear use

General Data Type: NUMBER

LONG_DEGREE

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

longitude degree

General Data Type: NUMBER

SOAK_TIME

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

hours the gear was in the water

General Data Type: NUMBER

AREA_10_MIN

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

1-36 range

General Data Type: NUMBER

GEAR_AVG_INFO

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

avg size information about gear. Please note that for Puerto Rico hook and line gear, this column has been recorded as '1' with total number of hooks entered in the gear qty column. This because Puerto Rico has in the past collected only total hook data. See note in GEAR_QTY column.

General Data Type: NUMBER

MIN_DEPTH

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

min depth fished

General Data Type: NUMBER

DISTANCE_TO_SHORE_MILES

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

how many miles to shore

General Data Type: NUMBER

LAT_HEMISPHERE

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

latitude hemisphere

General Data Type: VARCHAR2

COMMENTS

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

comments

General Data Type: VARCHAR2

GEAR_AVG_MILES_PER_SET

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

avg miles fished per set

General Data Type: NUMBER

LAT_MINUTE

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

latitude minute

General Data Type: NUMBER

REGION_ID

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

Key to Region (GULF, ATLANTIC, etc)

General Data Type: NUMBER

MODIFIED_BY_USER_ID

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

User modifying record

General Data Type: VARCHAR2

MODIFIED_DATE

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

Date/Time stamp of when record was modifed

General Data Type: DATE

AREA_ID

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

Key to area, which is a smaller location than county

General Data Type: NUMBER

GEAR_SIZE

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

For Nets or Traps, enter the diagonal mesh or slot size in inches. When measuring nets stretch the mesh closed.

General Data Type: NUMBER

STANDARD_GEAR_ID

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

Key to standard_gear, allowing each agency to have their own gear code, but each code must relate to a standard gear code.

General Data Type: VARCHAR2

STANDARD_AREA_ID

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

Key to standard_area, allowing each agency to have their own area code, but each code must relate to a standard area code.

General Data Type: NUMBER

RECORD_TYPE

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

For historical data, part of compound key that identifies a unique effort record in SEFSC.TIP_TIP12

General Data Type: VARCHAR2

Related Items

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

Catalog Details

Catalog Item ID: 6565
GUID: gov.noaa.nmfs.inport:6565
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2007-12-03 09:39+0000
Metadata Record Last Modified By: Lee M Weinberger
Metadata Record Last Modified: 2021-11-04 13:14+0000
Metadata Record Published: 2021-11-04
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2022-11-05