Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Master Survey Data Table

Description

Master Survey Data Table

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
ID
NUMBER
Sequential Key
PARTNER_CODE
VARCHAR2
Link to Partner Table
ZONE_CODE
VARCHAR2
Lnk To Zone Table
SURVEY_DATE
DATE
Date of Survey
IS_COMPLETE
VARCHAR2
Is The Survey Complete
START_TIME
VARCHAR2
Local Time Of Day That The Survey Started
END_TIME
VARCHAR2
Local Time Of Day That The Survey Ended
TOTAL_TIME
VARCHAR2
Total Time In Survey Where Hundred and Yhousands Place Indicates Hours and Ten and Ones place indicates minutes
TOTAL_HOUR
NUMBER
Total Number Of Hours In Survey
TOTAL_MINUTES
NUMBER
Total Number Of mInutes In The Survey. THis is a number between 0 and 59
WEATHER_CODE
NUMBER
Code Indicating Weather Coditions At Time Of Survey
BEAUFORT_STATE_CODE
NUMBER
Beaufort State Code
MOON_PHASE_CODE
NUMBER
Code To Indicate Phase Of The Moon
WATER_TEMPERATURE
NUMBER
Code To Indicate Water Temperature
START_TIDE_CODE
NUMBER
Code Indicating Tide Code At Start Of The Survey
END_TIDE_CODE
NUMBER
Code Indicating Tide Code At Endt Of The Survey
COMMENTS
VARCHAR2
Any Other Pertinent Comments ABout This Record
CREATED_BY_USER_ID
NUMBER
Oracle User Code Of Person Who Created This Record
CREATED_DATE
DATE
Control Column Indicating When This Record Was Created
MODIFIED_BY_USER_ID
NUMBER
Oracle User Code Of Person Who Last Modified This Record
MODIFIED_DATE
DATE
Control Column Indicating When This Record Was Last Modified

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (SEFSC) for inquiries on this record.

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: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2021-04-29
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2021-04-29
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2022-04-29