View: SEA_TURTLES_ALLSTATUSLIST_V
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:28376 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Entity Information
Entity Type
Data View
Data Attribute / Type | Description |
---|---|
ID
NUMBER |
no-comment |
OLD_ID
NUMBER |
no-comment |
STRANDING_YEAR
NUMBER |
no-comment |
STRANDING_DATE
DATE |
no-comment |
WEEK_NUMBER
NUMBER |
no-comment |
STATE_CODE
VARCHAR2 |
no-comment |
STATE_NAME
VARCHAR2 |
no-comment |
ZONE
NUMBER |
no-comment |
ZONE_ID
VARCHAR2 |
no-comment |
REGION_CODE
VARCHAR2 |
no-comment |
REGION_NAME
VARCHAR2 |
no-comment |
COUNTY_CODE
VARCHAR2 |
no-comment |
COUNTY_NAME
VARCHAR2 |
no-comment |
OBSERVER_INITIALS
VARCHAR2 |
no-comment |
CONDITION_CODE
NUMBER |
no-comment |
CONDITION
VARCHAR2 |
no-comment |
INOFFSHORE
VARCHAR2 |
no-comment |
SHORE
VARCHAR2 |
no-comment |
SPECIES_CODE
VARCHAR2 |
no-comment |
SPECIES_NAME
VARCHAR2 |
no-comment |
HEAD_WIDTH
NUMBER |
no-comment |
WEIGHT
NUMBER |
no-comment |
STRAIGHT_CARAPACE_LENGTH
NUMBER |
no-comment |
STRAIGHT_CARAPACE_WIDTH
NUMBER |
no-comment |
LOCATION_DESCRIPTION
VARCHAR2 |
no-comment |
BRIEF_NARRATIVE
VARCHAR2 |
no-comment |
COMMENTS
VARCHAR2 |
no-comment |
PHOTO_TOT
NUMBER |
no-comment |
DOCUMENT_TOT
NUMBER |
no-comment |
REPORTYPE_CODE
VARCHAR2 |
no-comment |
REPORTYPE_NAME
VARCHAR2 |
no-comment |
ADULT_SPECIES
VARCHAR2 |
no-comment |
EXEMPT
NUMBER |
no-comment |
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: | 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 |
Attribute Details
ID
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 |