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