Metadata Rubric

83%

5 / 6

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_ALLSTATUSLIST_V

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

Item Identification

Title:	View: SEA_TURTLES_ALLSTATUSLIST_V
Short Name:	SEA_TURTLES_ALLSTATUSLIST_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

	Name	Type	Description
100	ID	NUMBER	no-comment
100	OLD_ID	NUMBER	no-comment
100	STRANDING_YEAR	NUMBER	no-comment
100	STRANDING_DATE	DATE	no-comment
100	WEEK_NUMBER	NUMBER	no-comment
100	STATE_CODE	VARCHAR2	no-comment
100	STATE_NAME	VARCHAR2	no-comment
100	ZONE	NUMBER	no-comment
100	ZONE_ID	VARCHAR2	no-comment
100	REGION_CODE	VARCHAR2	no-comment
100	REGION_NAME	VARCHAR2	no-comment
100	COUNTY_CODE	VARCHAR2	no-comment
100	COUNTY_NAME	VARCHAR2	no-comment
100	OBSERVER_INITIALS	VARCHAR2	no-comment
100	CONDITION_CODE	NUMBER	no-comment
100	CONDITION	VARCHAR2	no-comment
100	INOFFSHORE	VARCHAR2	no-comment
100	SHORE	VARCHAR2	no-comment
100	SPECIES_CODE	VARCHAR2	no-comment
100	SPECIES_NAME	VARCHAR2	no-comment
100	HEAD_WIDTH	NUMBER	no-comment
100	WEIGHT	NUMBER	no-comment
100	STRAIGHT_CARAPACE_LENGTH	NUMBER	no-comment
100	STRAIGHT_CARAPACE_WIDTH	NUMBER	no-comment
100	LOCATION_DESCRIPTION	VARCHAR2	no-comment
100	BRIEF_NARRATIVE	VARCHAR2	no-comment
100	COMMENTS	VARCHAR2	no-comment
100	PHOTO_TOT	NUMBER	no-comment
100	DOCUMENT_TOT	NUMBER	no-comment
100	REPORTYPE_CODE	VARCHAR2	no-comment
100	REPORTYPE_NAME	VARCHAR2	no-comment
100	ADULT_SPECIES	VARCHAR2	no-comment
100	EXEMPT	NUMBER	no-comment

Name

Type

Description

100

NUMBER

no-comment

100

OLD_ID

NUMBER

no-comment

100

STRANDING_YEAR

NUMBER

no-comment

100

STRANDING_DATE

DATE

no-comment

100

WEEK_NUMBER

NUMBER

no-comment

100

STATE_CODE

VARCHAR2

no-comment

100

STATE_NAME

VARCHAR2

no-comment

100

ZONE

NUMBER

no-comment

100

ZONE_ID

VARCHAR2

no-comment

100

REGION_CODE

VARCHAR2

no-comment

100

REGION_NAME

VARCHAR2

no-comment

100

COUNTY_CODE

VARCHAR2

no-comment

100

COUNTY_NAME

VARCHAR2

no-comment

100

OBSERVER_INITIALS

VARCHAR2

no-comment

100

CONDITION_CODE

NUMBER

no-comment

100

CONDITION

VARCHAR2

no-comment

100

INOFFSHORE

VARCHAR2

no-comment

100

SHORE

VARCHAR2

no-comment

100

SPECIES_CODE

VARCHAR2

no-comment

100

SPECIES_NAME

VARCHAR2

no-comment

100

HEAD_WIDTH

NUMBER

no-comment

100

WEIGHT

NUMBER

no-comment

100

STRAIGHT_CARAPACE_LENGTH

NUMBER

no-comment

100

STRAIGHT_CARAPACE_WIDTH

NUMBER

no-comment

100

LOCATION_DESCRIPTION

VARCHAR2

no-comment

100

BRIEF_NARRATIVE

VARCHAR2

no-comment

100

COMMENTS

VARCHAR2

no-comment

100

PHOTO_TOT

NUMBER

no-comment

100

DOCUMENT_TOT

NUMBER

no-comment

100

REPORTYPE_CODE

VARCHAR2

no-comment

100

REPORTYPE_NAME

VARCHAR2

no-comment

100

ADULT_SPECIES

VARCHAR2

no-comment

100

EXEMPT

NUMBER

no-comment

Attribute Details

ID

CC ID: 240231

Seq. Order:	1
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Status:	Active
Description:	no-comment
General Data Type:	NUMBER

OLD_ID

CC ID: 240242

Seq. Order:	2
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	no-comment
General Data Type:	NUMBER

STRANDING_YEAR

CC ID: 240253

Seq. Order:	3
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: 240258

Seq. Order:	4
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	no-comment
General Data Type:	DATE

WEEK_NUMBER

CC ID: 240259

Seq. Order:	5
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Status:	Active
Description:	no-comment
General Data Type:	NUMBER

STATE_CODE

CC ID: 240260

Seq. Order:	6
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: 240261

Seq. Order:	7
Data Storage Type:	VARCHAR2
Max Length:	50
Required:	No
Primary Key:	No
Status:	Active
Description:	no-comment
General Data Type:	VARCHAR2

ZONE

CC ID: 240262

Seq. Order:	8
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	no-comment
General Data Type:	NUMBER

ZONE_ID

CC ID: 240263

Seq. Order:	9
Data Storage Type:	VARCHAR2
Max Length:	5
Required:	No
Primary Key:	No
Status:	Active
Description:	no-comment
General Data Type:	VARCHAR2

REGION_CODE

CC ID: 240232

Seq. Order:	10
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	no-comment
General Data Type:	VARCHAR2

REGION_NAME

CC ID: 240233

Seq. Order:	11
Data Storage Type:	VARCHAR2
Max Length:	100
Required:	No
Primary Key:	No
Status:	Active
Description:	no-comment
General Data Type:	VARCHAR2

COUNTY_CODE

CC ID: 240234

Seq. Order:	12
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: 240235

Seq. Order:	13
Data Storage Type:	VARCHAR2
Max Length:	200
Required:	No
Primary Key:	No
Status:	Active
Description:	no-comment
General Data Type:	VARCHAR2

OBSERVER_INITIALS

CC ID: 240236

Seq. Order:	14
Data Storage Type:	VARCHAR2
Max Length:	10
Required:	No
Primary Key:	No
Status:	Active
Description:	no-comment
General Data Type:	VARCHAR2

CONDITION_CODE

CC ID: 240237

Seq. Order:	15
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Status:	Active
Description:	no-comment
General Data Type:	NUMBER

CONDITION

CC ID: 240238

Seq. Order:	16
Data Storage Type:	VARCHAR2
Max Length:	100
Required:	No
Primary Key:	No
Status:	Active
Description:	no-comment
General Data Type:	VARCHAR2

INOFFSHORE

CC ID: 240239

Seq. Order:	17
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	no-comment
General Data Type:	VARCHAR2

SHORE

CC ID: 240240

Seq. Order:	18
Data Storage Type:	VARCHAR2
Max Length:	50
Required:	No
Primary Key:	No
Status:	Active
Description:	no-comment
General Data Type:	VARCHAR2

SPECIES_CODE

CC ID: 240241

Seq. Order:	19
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: 240243

Seq. Order:	20
Data Storage Type:	VARCHAR2
Max Length:	100
Required:	No
Primary Key:	No
Status:	Active
Description:	no-comment
General Data Type:	VARCHAR2

HEAD_WIDTH

CC ID: 240244

Seq. Order:	21
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Status:	Active
Description:	no-comment
General Data Type:	NUMBER

WEIGHT

CC ID: 240245

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

STRAIGHT_CARAPACE_LENGTH

CC ID: 240246

Seq. Order:	23
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Status:	Active
Description:	no-comment
General Data Type:	NUMBER

STRAIGHT_CARAPACE_WIDTH

CC ID: 240247

Seq. Order:	24
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	no-comment
General Data Type:	NUMBER

LOCATION_DESCRIPTION

CC ID: 240248

Seq. Order:	25
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: 240249

Seq. Order:	26
Data Storage Type:	VARCHAR2
Max Length:	4000
Required:	No
Primary Key:	No
Status:	Active
Description:	no-comment
General Data Type:	VARCHAR2

COMMENTS

CC ID: 240250

Seq. Order:	27
Data Storage Type:	VARCHAR2
Max Length:	4000
Required:	No
Primary Key:	No
Status:	Active
Description:	no-comment
General Data Type:	VARCHAR2

PHOTO_TOT

CC ID: 240251

Seq. Order:	28
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	no-comment
General Data Type:	NUMBER

DOCUMENT_TOT

CC ID: 240252

Seq. Order:	29
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Status:	Active
Description:	no-comment
General Data Type:	NUMBER

REPORTYPE_CODE

CC ID: 240254

Seq. Order:	30
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	no-comment
General Data Type:	VARCHAR2

REPORTYPE_NAME

CC ID: 240255

Seq. Order:	31
Data Storage Type:	VARCHAR2
Max Length:	100
Required:	No
Primary Key:	No
Status:	Active
Description:	no-comment
General Data Type:	VARCHAR2

ADULT_SPECIES

CC ID: 240256

Seq. Order:	32
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	no-comment
General Data Type:	VARCHAR2

EXEMPT

CC ID: 240257

Seq. Order:	33
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Status:	Active
Description:	no-comment
General Data Type:	NUMBER

Catalog Details

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