Slide Menu
Search Help Show/Hide Menu

Item Identification

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

Master Survey Data Table

Notes:

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

Entity Information

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

Master Survey Data Table

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key ID NUMBER Sequential Key
100
PARTNER_CODE VARCHAR2 Link to Partner Table
100
ZONE_CODE VARCHAR2 Lnk To Zone Table
100
SURVEY_DATE DATE Date of Survey
100
IS_COMPLETE VARCHAR2 Is The Survey Complete
100
START_TIME VARCHAR2 Local Time Of Day That The Survey Started
100
END_TIME VARCHAR2 Local Time Of Day That The Survey Ended
100
TOTAL_TIME VARCHAR2 Total Time In Survey Where Hundred and Yhousands Place Indicates Hours and Ten and Ones place indicates minutes
100
TOTAL_HOUR NUMBER Total Number Of Hours In Survey
100
TOTAL_MINUTES NUMBER Total Number Of mInutes In The Survey. THis is a number between 0 and 59
100
WEATHER_CODE NUMBER Code Indicating Weather Coditions At Time Of Survey
100
BEAUFORT_STATE_CODE NUMBER Beaufort State Code
100
MOON_PHASE_CODE NUMBER Code To Indicate Phase Of The Moon
100
WATER_TEMPERATURE NUMBER Code To Indicate Water Temperature
100
START_TIDE_CODE NUMBER Code Indicating Tide Code At Start Of The Survey
100
END_TIDE_CODE NUMBER Code Indicating Tide Code At Endt Of The Survey
100
COMMENTS VARCHAR2 Any Other Pertinent Comments ABout 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 When This Record Was Last Modified

Attribute Details

ID

CC ID: 30981
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

PARTNER_CODE

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

Link to Partner Table

General Data Type: VARCHAR2

ZONE_CODE

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

Lnk To Zone Table

General Data Type: VARCHAR2

SURVEY_DATE

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

Date of Survey

General Data Type: DATE

IS_COMPLETE

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

Is The Survey Complete

General Data Type: VARCHAR2

START_TIME

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

Local Time Of Day That The Survey Started

General Data Type: VARCHAR2

END_TIME

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

Local Time Of Day That The Survey Ended

General Data Type: VARCHAR2

TOTAL_TIME

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

Total Time In Survey Where Hundred and Yhousands Place Indicates Hours and Ten and Ones place indicates minutes

General Data Type: VARCHAR2

TOTAL_HOUR

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

Total Number Of Hours In Survey

General Data Type: NUMBER

TOTAL_MINUTES

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

Total Number Of mInutes In The Survey. THis is a number between 0 and 59

General Data Type: NUMBER

WEATHER_CODE

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

Code Indicating Weather Coditions At Time Of Survey

General Data Type: NUMBER

BEAUFORT_STATE_CODE

CC ID: 30970
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

MOON_PHASE_CODE

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

Code To Indicate Phase Of The Moon

General Data Type: NUMBER

WATER_TEMPERATURE

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

Code To Indicate Water Temperature

General Data Type: NUMBER

START_TIDE_CODE

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

Code Indicating Tide Code At Start Of The Survey

General Data Type: NUMBER

END_TIDE_CODE

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

Code Indicating Tide Code At Endt Of The Survey

General Data Type: NUMBER

COMMENTS

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

Any Other Pertinent Comments ABout This Record

General Data Type: VARCHAR2

CREATED_BY_USER_ID

CC ID: 30964
Seq. Order: 18
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: 30963
Seq. Order: 19
Data Storage Type: DATE
Max Length: 7
Required: Yes
Primary Key: No
Status: Active
Description:

Control Column Indicating When This Record Was Created

General Data Type: DATE

MODIFIED_BY_USER_ID

CC ID: 30962
Seq. Order: 20
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: 30961
Seq. Order: 21
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Control Column Indicating When This Record Was Last Modified

General Data Type: DATE

Catalog Details

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