Slide Menu
Search Help Show/Hide Menu

Item Identification

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

Used to Audit the Table EFFORT

Notes:

Loaded by batch 2005, 12-03-2007 10:12

Entity Information

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

Used to Audit the Table EFFORT

Data Attributes

Attribute Summary

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

Attribute Details

ID

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

unique id

General Data Type: NUMBER

INTERVIEW_ID

CC ID: 22336
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: 22337
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: 22338
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: 22339
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: 22340
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: 22341
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: 22342
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: 22343
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: 22344
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: 22345
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: 22346
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: 22347
Seq. Order: 13
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

quantity of gear used

General Data Type: NUMBER

LAT_DEGREE

CC ID: 22348
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: 22349
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: 22350
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: 22351
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: 22352
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: 22353
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: 22354
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

General Data Type: NUMBER

MIN_DEPTH

CC ID: 22355
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: 22356
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: 22357
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: 22358
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: 22359
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: 22360
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: 22361
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: 22362
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: 22363
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: 22364
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: 22365
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: 22366
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: 22367
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: 22368
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

CHANGE_DATE

CC ID: 22369
Seq. Order: 35
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

Catalog Details

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