Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
SEFSC Metadata Library > Marine Mammal and Turtle Division > SEFSC Marine Mammal Projects > Marine Mammals Miami > Biscayne Bay Dolphin Photo ID System > Biscayne Bay Dolphin Photo ID System >

Table: SURVEY

Entity (ENT)  |  Southeast Fisheries Science Center (SEFSC)
GUID: gov.noaa.nmfs.inport:7819  |  Updated: August 9, 2022  |  Published / External 
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