Slide Menu
Search Help Show/Hide Menu

Item Identification

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

Data table contining sighting information

Notes:

Loaded by batch 2223, 08-11-2008 14:27

Entity Information

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

Data table contining sighting information

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key ID NUMBER Sequential key
100
SURVEY_ID NUMBER Key to survey table
100
SIGHTING_NUMBER NUMBER Number Of Dolphins Sighted
100
TRANSECT_NUMBER NUMBER Number Of Record Associated With The Survey Id
100
START_TIME VARCHAR2 Start Time Of SIghting
100
END_TIME VARCHAR2 End Time Of SIghting
100
BEGIN_LATITUDE NUMBER Begin Latitude Of Sighting
100
END_LATITUDE NUMBER End Latitude Of Sighting
100
BEGIN_LONGITUDE NUMBER Begin Longitude Of Sighting
100
END_LONGITUDE NUMBER End Longitude Of Sighting
100
WEATHER_CODE NUMBER Code to indicate weather
100
BEAUFORT_STATE_CODE NUMBER Beaufort State Code
100
TIDE_CODE NUMBER Code to indicate tide
100
WATER_DEPTH NUMBER In Fathoms
100
WATER_TEMPERATURE NUMBER Water Temperature In degrees Farenhite
100
INITIAL_HEADING_CODE NUMBER Code to indicate initial heading of Boat
100
BOATS_IN_AREA NUMBER Number Of Boats In Area Of Dolphin
100
DISTANCE_TO_BOAT NUMBER Distance Of Dolphins To Boat
100
ADULT_HIGH_ESTIMATE NUMBER High Estimate of the Number Of Adult Dolphins Seen
100
ADULT_LOW_ESTIMATE NUMBER Low Estimate of the Number Of Adult Dolphins Seen
100
ADULT_BEST_ESTIMATE NUMBER Best Estimate of the Number Of Adult Dolphins Seen
100
CALF_HIGH_ESTIMATE NUMBER High Estimate of the Number Of Dolphin Calfs Seen
100
CALF_LOW_ESTIMATE NUMBER Low Estimate of the Number Of Dolphin Calfs Seen
100
CALF_BEST_ESTIMATE NUMBER Best Estimate of the Number Of Dolphin Calfs Seen
100
YOY_HIGH_ESTIMATE NUMBER High Estimate YOY
100
YOY_LOW_ESTIMATE NUMBER Low Estimate YOY
100
YOY_BEST_ESTIMATE NUMBER Best Estimate YOY
100
TOTAL_HIGH_ESTIMATE NUMBER Sum Total High Estimate
100
TOTAL_LOW_ESTIMATE NUMBER Sum Total Low Estimate
100
TOTAL_BEST_ESTIMATE NUMBER Sum Total Best Estimate
100
TOTAL_IDED_FINS NUMBER Total Number Of Indentified Fins
100
TOTAL_IDED_SLIDES NUMBER Total Number Of Indemtified Slides
100
TOTAL_UNIDENTIFIED NUMBER Totsl unidentified slides
100
TOTAL_NON_DESCRIPT_FINS NUMBER Total Of Fins not described
100
TOTAL_NON_DESCRIPT_SLIDES NUMBER Total Of Slides not described
100
ADULTS_CAPTURED NUMBER Number Of Adults captured
100
FISHERY_CODE NUMBER Fishery Code
100
COMMENTS VARCHAR2 Any special comments On This record
100
CREATED_BY_USER_ID NUMBER Oracle User Code Of Person Who Created This Record
100
CREATED_DATE DATE Control Column Indicating When This Record Was Created
100
MODIFIED_BY_USER_ID NUMBER Oracle User Code Of Person Who Last Modified This Record
100
MODIFIED_DATE DATE Control column indicating Date of last record modification

Attribute Details

ID

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

Sequential key

General Data Type: NUMBER

SURVEY_ID

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

Key to survey table

General Data Type: NUMBER

SIGHTING_NUMBER

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

Number Of Dolphins Sighted

General Data Type: NUMBER

TRANSECT_NUMBER

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

Number Of Record Associated With The Survey Id

General Data Type: NUMBER

START_TIME

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

Start Time Of SIghting

General Data Type: VARCHAR2

END_TIME

CC ID: 30955
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

End Time Of SIghting

General Data Type: VARCHAR2

BEGIN_LATITUDE

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

Begin Latitude Of Sighting

General Data Type: NUMBER

END_LATITUDE

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

End Latitude Of Sighting

General Data Type: NUMBER

BEGIN_LONGITUDE

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

Begin Longitude Of Sighting

General Data Type: NUMBER

END_LONGITUDE

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

End Longitude Of Sighting

General Data Type: NUMBER

WEATHER_CODE

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

Code to indicate weather

General Data Type: NUMBER

BEAUFORT_STATE_CODE

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

Beaufort State Code

General Data Type: NUMBER

TIDE_CODE

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

Code to indicate tide

General Data Type: NUMBER

WATER_DEPTH

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

In Fathoms

General Data Type: NUMBER

WATER_TEMPERATURE

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

Water Temperature In degrees Farenhite

General Data Type: NUMBER

INITIAL_HEADING_CODE

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

Code to indicate initial heading of Boat

General Data Type: NUMBER

BOATS_IN_AREA

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

Number Of Boats In Area Of Dolphin

General Data Type: NUMBER

DISTANCE_TO_BOAT

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

Distance Of Dolphins To Boat

General Data Type: NUMBER

ADULT_HIGH_ESTIMATE

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

High Estimate of the Number Of Adult Dolphins Seen

General Data Type: NUMBER

ADULT_LOW_ESTIMATE

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

Low Estimate of the Number Of Adult Dolphins Seen

General Data Type: NUMBER

ADULT_BEST_ESTIMATE

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

Best Estimate of the Number Of Adult Dolphins Seen

General Data Type: NUMBER

CALF_HIGH_ESTIMATE

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

High Estimate of the Number Of Dolphin Calfs Seen

General Data Type: NUMBER

CALF_LOW_ESTIMATE

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

Low Estimate of the Number Of Dolphin Calfs Seen

General Data Type: NUMBER

CALF_BEST_ESTIMATE

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

Best Estimate of the Number Of Dolphin Calfs Seen

General Data Type: NUMBER

YOY_HIGH_ESTIMATE

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

High Estimate YOY

General Data Type: NUMBER

YOY_LOW_ESTIMATE

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

Low Estimate YOY

General Data Type: NUMBER

YOY_BEST_ESTIMATE

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

Best Estimate YOY

General Data Type: NUMBER

TOTAL_HIGH_ESTIMATE

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

Sum Total High Estimate

General Data Type: NUMBER

TOTAL_LOW_ESTIMATE

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

Sum Total Low Estimate

General Data Type: NUMBER

TOTAL_BEST_ESTIMATE

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

Sum Total Best Estimate

General Data Type: NUMBER

TOTAL_IDED_FINS

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

Total Number Of Indentified Fins

General Data Type: NUMBER

TOTAL_IDED_SLIDES

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

Total Number Of Indemtified Slides

General Data Type: NUMBER

TOTAL_UNIDENTIFIED

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

Totsl unidentified slides

General Data Type: NUMBER

TOTAL_NON_DESCRIPT_FINS

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

Total Of Fins not described

General Data Type: NUMBER

TOTAL_NON_DESCRIPT_SLIDES

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

Total Of Slides not described

General Data Type: NUMBER

ADULTS_CAPTURED

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

Number Of Adults captured

General Data Type: NUMBER

FISHERY_CODE

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

Fishery Code

General Data Type: NUMBER

COMMENTS

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

Any special comments On This record

General Data Type: VARCHAR2

CREATED_BY_USER_ID

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

Oracle User Code Of Person Who Created This Record

General Data Type: NUMBER

CREATED_DATE

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

Control Column Indicating When This Record Was Created

General Data Type: DATE

MODIFIED_BY_USER_ID

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

Oracle User Code Of Person Who Last Modified This Record

General Data Type: NUMBER

MODIFIED_DATE

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

Control column indicating Date of last record modification

General Data Type: DATE

Catalog Details

Catalog Item ID: 7818
GUID: gov.noaa.nmfs.inport:7818
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2008-08-11 14:27+0000
Metadata Record Last Modified By: Lee M Weinberger
Metadata Record Last Modified: 2021-04-29 15:30+0000
Metadata Record Published: 2021-04-29
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2022-04-30