Slide Menu
Jump to Section...
Search Help Show/Hide Menu
Metadata Rubric
83%
5 / 6
View Report
SEFSC Metadata Library > Marine Mammal and Turtle Division > SEFSC Marine Turtle > Miami Turtles Projects > Sea Turtle Stranding and Salvage Network > Marine turtle stranding data - Sea Turtle Stran... >

View: SEA_TURTLES_LIST_V

Entity (ENT)  |  Southeast Fisheries Science Center (SEFSC)
GUID: gov.noaa.nmfs.inport:28379  |  Updated: August 9, 2022  |  Published / External 

Item Identification

Title: View: SEA_TURTLES_LIST_V
Short Name: SEA_TURTLES_LIST_V
Status: Completed
Notes:

Loaded by batch 7464, 10-29-2015 15:36

Entity Information

Entity Type: Data View
Active Version?: Yes
Schema Name: STSSN

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 ID NUMBER no-comment
100
 OBSERVER_INITIALS VARCHAR2 no-comment
100
 SPECIES_CODE VARCHAR2 no-comment
100
 SPECIES_NAME VARCHAR2 no-comment
100
 STATE_CODE VARCHAR2 no-comment
100
 STATE_NAME VARCHAR2 no-comment
100
 COUNTY_CODE VARCHAR2 no-comment
100
 COUNTY_NAME VARCHAR2 no-comment
100
 ZONE VARCHAR2 no-comment
100
 ZONE_ID VARCHAR2 no-comment
100
 REGION_CODE VARCHAR2 no-comment
100
 REGION_NAME VARCHAR2 no-comment
100
 WEEK_NUMBER NUMBER no-comment
100
 STRANDING_YEAR VARCHAR2 no-comment
100
 TURTLENUMBERBYDAY NUMBER no-comment
100
 STRANDING_DATE VARCHAR2 no-comment
100
 STATETURTLE_ID VARCHAR2 no-comment
100
 LOCATION_DESCRIPTION VARCHAR2 no-comment
100
 BRIEF_NARRATIVE VARCHAR2 no-comment
100
 RECORD_LOCKED VARCHAR2 no-comment
100
 PHOTO_TOT NUMBER no-comment
100
 DOCUMENT_TOT NUMBER no-comment

Attribute Details

ID

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

no-comment
General Data Type: NUMBER

OBSERVER_INITIALS

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

no-comment
General Data Type: VARCHAR2

SPECIES_CODE

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

no-comment
General Data Type: VARCHAR2

SPECIES_NAME

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

no-comment
General Data Type: VARCHAR2

STATE_CODE

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

no-comment
General Data Type: VARCHAR2

STATE_NAME

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

no-comment
General Data Type: VARCHAR2

COUNTY_CODE

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

no-comment
General Data Type: VARCHAR2

COUNTY_NAME

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

no-comment
General Data Type: VARCHAR2

ZONE

CC ID: 240296
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

no-comment
General Data Type: VARCHAR2

ZONE_ID

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

no-comment
General Data Type: VARCHAR2

REGION_CODE

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

no-comment
General Data Type: VARCHAR2

REGION_NAME

CC ID: 240278
Seq. Order: 12
Data Storage Type: VARCHAR2
Max Length: 100
Required: No
Primary Key: No
Status: Active
Description:

no-comment
General Data Type: VARCHAR2

WEEK_NUMBER

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

no-comment
General Data Type: NUMBER

STRANDING_YEAR

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

no-comment
General Data Type: VARCHAR2

TURTLENUMBERBYDAY

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

no-comment
General Data Type: NUMBER

STRANDING_DATE

CC ID: 240282
Seq. Order: 16
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

no-comment
General Data Type: VARCHAR2

STATETURTLE_ID

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

no-comment
General Data Type: VARCHAR2

LOCATION_DESCRIPTION

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

no-comment
General Data Type: VARCHAR2

BRIEF_NARRATIVE

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

no-comment
General Data Type: VARCHAR2

RECORD_LOCKED

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

no-comment
General Data Type: VARCHAR2

PHOTO_TOT

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

no-comment
General Data Type: NUMBER

DOCUMENT_TOT

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

no-comment
General Data Type: NUMBER

Catalog Details

Catalog Item ID: 28379
GUID: gov.noaa.nmfs.inport:28379
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2015-10-29 15:36+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