Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
PIFSC Metadata Library > PIFSC Coral Reef Ecosystem Program (CREP) Metad... > Ecosystem Monitoring and Assessment > Benthic Missions > Determining Watershed Management Efficacy in We... >

View: V0_CORAL_OBS_E

Entity (ENT)  |  Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:27438  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Coral belt observations (adult)

Description

Coral belt observations (adult)

Entity Information

Entity Type
Data View

Data Attribute / Type Description
REGION
VARCHAR2 		Region Code for the LIST_OF_REGIONS record, this is used by other tables to join on the LIST_OF_REGIONS table
REGION_NAME
VARCHAR2 		One of the five Pacific Island regions CRED surveys
ISLAND
NVARCHAR2 		Island or Atoll surveyed
ISLANDCODE
NVARCHAR2 		3-letter island code
SECTOR
VARCHAR2 		This field is used by the fish team to represent a different stratification scheme based on fishing pressure and wave exposure around an island (Added Jan. 2012)
SITE
NVARCHAR2 		The 5- to 6-character code for the site surveyed. Combines a 3-letter island code with a site number
LATITUDE
NUMBER 		Latitude in decimal degrees, WGS84, for the given site
LONGITUDE
NUMBER 		Longitude in decimal degrees, WGS84 for the given site
REEF_ZONE_CODE
VARCHAR2 		3-letter reef zone code
REEF_ZONE
NVARCHAR2 		The reef zone for the given site (Forereef, Backreef or Lagoon)
DEPTH_BIN
NVARCHAR2 		Classification of depth (shallow, mid, deep) based on midpoint between minimum and maximum depths of replicates at this site
DEPTH_CODE
VARCHAR2 		Depth zone code
EXCLUDE_FLAG
NUMBER 		Flag to indicate whether site should be excluded from analysis
SITEVISITID
NUMBER 		Unique Identifier for SITE_VISIT record
DATE_
DATE 		Date the survey was conducted
OBS_DAY
NUMBER 		Observation Day
OBS_MONTH
NUMBER 		Observation Month
OBS_YEAR
NUMBER 		Observation Year
HABITAT_CODE
VARCHAR2 		Habitat code
HABITAT_TYPE
VARCHAR2 		Habitat type
COMMENTS
NVARCHAR2 		General observation comments
DIVER
NVARCHAR2 		Initials of diver conducting survey
BELTTRANSECTRUN
NUMBER 		Primary key for CORAL_BELT_TRANSECTRUN
METHODNAME
NVARCHAR2 		References the coral belt survey method
TRANSECT
NUMBER 		Transect Number
SEGMENT
NVARCHAR2 		Segment Number
TRANWIDTH
NUMBER 		Transect Length (m)
TRANLENGTH
NUMBER 		Transect Width (m)
MINDEPTH
NUMBER 		Minimum Depth of the transect (in meters)
MAXDEPTH
NUMBER 		Maximum Depth of the transect (in meters)
CLADIELLA_YN
NUMBER 		Flag to indicate presence of cladiella on transect (Added Sept. 2014)
DENDRONEPHTHYA_YN
NUMBER 		Flag to indicate presence of dendronephthya on transect (Added Sept. 2014)
LOBOPHYTUM_YN
NUMBER 		Flag to indicate presence of lobophytum on transect (Added Sept. 2014)
PACHYCLAVULARIA_YN
NUMBER 		Flag to indicate presence of pachyclavularia on transect (Added Sept. 2014)
SARCOPHYTON_YN
NUMBER 		Flag to indicate presence of sarcophyton on transect (Added Sept. 2014)
SINULARIA_YN
NUMBER 		Flag to indicate presence of sinularia on transect (Added Sept. 2014)
STEREONEPHTHYA_YN
NUMBER 		Flag to indicate presence of stereonephthya on transect (Added Sept. 2014)
WIRECORAL_YN
NUMBER 		Flag to indicate presence of wire coral on transect (Added Sept. 2014)
PALYTHOA_YN
NUMBER 		Flag to indicate presence of palythoa on transect (Added Sept. 2014)
PROTOPALYTHOA_YN
NUMBER 		Flag to indicate presence of protopalythoa on transect (Added Sept. 2014)
ZOANTHUS_YN
NUMBER 		Flag to indicate presence of zoanthus on transect (Added Sept. 2014)
NO_SURVEY_YN
NUMBER 		Flag to indicate transect was not surveyed (Added Sept. 2014)
COLONYID
NUMBER 		Colony Identifier
SPECIES
NVARCHAR2 		Species observed
MORPH_CODE
VARCHAR2 		4-letter morphology code
MORPHOLOGY
VARCHAR2 		Definition of morphology code
COLONYLENGTH
NUMBER 		Colony Length (cm)
OLDDEAD
NUMBER 		Percentage of old dead coral
RECENTDEAD
NUMBER 		Percentage of recently dead coral
RECENT_GENERAL_CAUSE_CODE
VARCHAR2 		General cause code of recently dead coral captured in RECENTDEAD field
RECENT_SPECIFIC_CAUSE_CODE
VARCHAR2 		Specific cause code of recently dead coral captured in RECENTDEAD field
RECENTDEAD_2
NUMBER 		Percentage of recently dead coral
RECENT_GENERAL_CAUSE_CODE_2
VARCHAR2 		General cause code of recently dead coral captured in RECENTDEAD_2 field
RECENT_SPECIFIC_CAUSE_CODE_2
VARCHAR2 		Specific cause code of recently dead coral captured in RECENTDEAD_2 field
DZCODE
NVARCHAR2 		Coral disease code of the observed coral colony
DZCLASS
NVARCHAR2 		Coral Disease
MAP_CODE
NVARCHAR2 		The map code for the coral disease
EXTENT
NUMBER 		Disease Extent (1-100)
SEVERITY
NUMBER 		Disease Severity (1-5)
TAXONNAME
NVARCHAR2 		Taxonomic Name
PHYLUM
VARCHAR2 		Phylum Taxonomic Rank
CLASS
NVARCHAR2 		Class Taxonomic Rank
S_ORDER
VARCHAR2 		Order Taxonomic Rank
FAMILY
VARCHAR2 		Family Taxonomic Rank
GENUS_CODE
NVARCHAR2 		4-letter genus code
GENUS
NVARCHAR2 		Genus Taxonomic Rank
SCIENTIFIC_NAME
VARCHAR2 		Scientific Name Taxonomic Rank
RANK
VARCHAR2 		Rank from WoRMS
APHIAID
VARCHAR2 		Aphia ID from WoRMS
CORAL_CORISID
NUMBER 		CoRIS ID for coral metadata record (Added June 2011)

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (PIFSC) for inquiries on this record.

Item Identification

Title: View: V0_CORAL_OBS_E
Short Name: V0_CORAL_OBS_E
Status: Completed
Abstract:

Coral belt observations (adult)
Notes:

Loaded by batch 7116, 09-23-2015 23:05

Entity Information

Entity Type: Data View
Active Version?: Yes
Schema Name: GISDAT
Description:

Coral belt observations (adult)

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 REGION VARCHAR2 Region Code for the LIST_OF_REGIONS record, this is used by other tables to join on the LIST_OF_REGIONS table
100
 REGION_NAME VARCHAR2 One of the five Pacific Island regions CRED surveys
100
 ISLAND NVARCHAR2 Island or Atoll surveyed
100
 ISLANDCODE NVARCHAR2 3-letter island code
100
 SECTOR VARCHAR2 This field is used by the fish team to represent a different stratification scheme based on fishing pressure and wave exposure around an island (Added Jan. 2012)
100
 SITE NVARCHAR2 The 5- to 6-character code for the site surveyed. Combines a 3-letter island code with a site number
100
 LATITUDE NUMBER Latitude in decimal degrees, WGS84, for the given site
100
 LONGITUDE NUMBER Longitude in decimal degrees, WGS84 for the given site
100
 REEF_ZONE_CODE VARCHAR2 3-letter reef zone code
100
 REEF_ZONE NVARCHAR2 The reef zone for the given site (Forereef, Backreef or Lagoon)
100
 DEPTH_BIN NVARCHAR2 Classification of depth (shallow, mid, deep) based on midpoint between minimum and maximum depths of replicates at this site
100
 DEPTH_CODE VARCHAR2 Depth zone code
100
 EXCLUDE_FLAG NUMBER Flag to indicate whether site should be excluded from analysis
100
 SITEVISITID NUMBER Unique Identifier for SITE_VISIT record
100
 DATE_ DATE Date the survey was conducted
100
 OBS_DAY NUMBER Observation Day
100
 OBS_MONTH NUMBER Observation Month
100
 OBS_YEAR NUMBER Observation Year
100
 HABITAT_CODE VARCHAR2 Habitat code
100
 HABITAT_TYPE VARCHAR2 Habitat type
100
 COMMENTS NVARCHAR2 General observation comments
100
 DIVER NVARCHAR2 Initials of diver conducting survey
100
 BELTTRANSECTRUN NUMBER Primary key for CORAL_BELT_TRANSECTRUN
100
 METHODNAME NVARCHAR2 References the coral belt survey method
100
 TRANSECT NUMBER Transect Number
100
 SEGMENT NVARCHAR2 Segment Number
100
 TRANWIDTH NUMBER Transect Length (m)
100
 TRANLENGTH NUMBER Transect Width (m)
100
 MINDEPTH NUMBER Minimum Depth of the transect (in meters)
100
 MAXDEPTH NUMBER Maximum Depth of the transect (in meters)
100
 CLADIELLA_YN NUMBER Flag to indicate presence of cladiella on transect (Added Sept. 2014)
100
 DENDRONEPHTHYA_YN NUMBER Flag to indicate presence of dendronephthya on transect (Added Sept. 2014)
100
 LOBOPHYTUM_YN NUMBER Flag to indicate presence of lobophytum on transect (Added Sept. 2014)
100
 PACHYCLAVULARIA_YN NUMBER Flag to indicate presence of pachyclavularia on transect (Added Sept. 2014)
100
 SARCOPHYTON_YN NUMBER Flag to indicate presence of sarcophyton on transect (Added Sept. 2014)
100
 SINULARIA_YN NUMBER Flag to indicate presence of sinularia on transect (Added Sept. 2014)
100
 STEREONEPHTHYA_YN NUMBER Flag to indicate presence of stereonephthya on transect (Added Sept. 2014)
100
 WIRECORAL_YN NUMBER Flag to indicate presence of wire coral on transect (Added Sept. 2014)
100
 PALYTHOA_YN NUMBER Flag to indicate presence of palythoa on transect (Added Sept. 2014)
100
 PROTOPALYTHOA_YN NUMBER Flag to indicate presence of protopalythoa on transect (Added Sept. 2014)
100
 ZOANTHUS_YN NUMBER Flag to indicate presence of zoanthus on transect (Added Sept. 2014)
100
 NO_SURVEY_YN NUMBER Flag to indicate transect was not surveyed (Added Sept. 2014)
100
 COLONYID NUMBER Colony Identifier
100
 SPECIES NVARCHAR2 Species observed
100
 MORPH_CODE VARCHAR2 4-letter morphology code
100
 MORPHOLOGY VARCHAR2 Definition of morphology code
100
 COLONYLENGTH NUMBER Colony Length (cm)
100
 OLDDEAD NUMBER Percentage of old dead coral
100
 RECENTDEAD NUMBER Percentage of recently dead coral
100
 RECENT_GENERAL_CAUSE_CODE VARCHAR2 General cause code of recently dead coral captured in RECENTDEAD field
100
 RECENT_SPECIFIC_CAUSE_CODE VARCHAR2 Specific cause code of recently dead coral captured in RECENTDEAD field
100
 RECENTDEAD_2 NUMBER Percentage of recently dead coral
100
 RECENT_GENERAL_CAUSE_CODE_2 VARCHAR2 General cause code of recently dead coral captured in RECENTDEAD_2 field
100
 RECENT_SPECIFIC_CAUSE_CODE_2 VARCHAR2 Specific cause code of recently dead coral captured in RECENTDEAD_2 field
100
 DZCODE NVARCHAR2 Coral disease code of the observed coral colony
100
 DZCLASS NVARCHAR2 Coral Disease
100
 MAP_CODE NVARCHAR2 The map code for the coral disease
100
 EXTENT NUMBER Disease Extent (1-100)
100
 SEVERITY NUMBER Disease Severity (1-5)
100
 TAXONNAME NVARCHAR2 Taxonomic Name
100
 PHYLUM VARCHAR2 Phylum Taxonomic Rank
100
 CLASS NVARCHAR2 Class Taxonomic Rank
100
 S_ORDER VARCHAR2 Order Taxonomic Rank
100
 FAMILY VARCHAR2 Family Taxonomic Rank
100
 GENUS_CODE NVARCHAR2 4-letter genus code
100
 GENUS NVARCHAR2 Genus Taxonomic Rank
100
 SCIENTIFIC_NAME VARCHAR2 Scientific Name Taxonomic Rank
100
 RANK VARCHAR2 Rank from WoRMS
100
 APHIAID VARCHAR2 Aphia ID from WoRMS
100
 CORAL_CORISID NUMBER CoRIS ID for coral metadata record (Added June 2011)

Attribute Details

REGION

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

Region Code for the LIST_OF_REGIONS record, this is used by other tables to join on the LIST_OF_REGIONS table
General Data Type: VARCHAR2

REGION_NAME

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

One of the five Pacific Island regions CRED surveys
General Data Type: VARCHAR2

ISLAND

CC ID: 224622
Seq. Order: 3
Data Storage Type: NVARCHAR2
Max Length: 150
Required: No
Primary Key: No
Status: Active
Description:

Island or Atoll surveyed
General Data Type: NVARCHAR2

ISLANDCODE

CC ID: 224623
Seq. Order: 4
Data Storage Type: NVARCHAR2
Max Length: 15
Required: No
Primary Key: No
Status: Active
Description:

3-letter island code
General Data Type: NVARCHAR2

SECTOR

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

This field is used by the fish team to represent a different stratification scheme based on fishing pressure and wave exposure around an island (Added Jan. 2012)
General Data Type: VARCHAR2

SITE

CC ID: 224625
Seq. Order: 6
Data Storage Type: NVARCHAR2
Max Length: 150
Required: Yes
Primary Key: No
Status: Active
Description:

The 5- to 6-character code for the site surveyed. Combines a 3-letter island code with a site number
General Data Type: NVARCHAR2

LATITUDE

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

Latitude in decimal degrees, WGS84, for the given site
General Data Type: NUMBER

LONGITUDE

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

Longitude in decimal degrees, WGS84 for the given site
General Data Type: NUMBER

REEF_ZONE_CODE

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

3-letter reef zone code
General Data Type: VARCHAR2

REEF_ZONE

CC ID: 224629
Seq. Order: 10
Data Storage Type: NVARCHAR2
Max Length: 150
Required: No
Primary Key: No
Status: Active
Description:

The reef zone for the given site (Forereef, Backreef or Lagoon)
General Data Type: NVARCHAR2

DEPTH_BIN

CC ID: 224630
Seq. Order: 11
Data Storage Type: NVARCHAR2
Max Length: 60
Required: No
Primary Key: No
Status: Active
Description:

Classification of depth (shallow, mid, deep) based on midpoint between minimum and maximum depths of replicates at this site
General Data Type: NVARCHAR2

DEPTH_CODE

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

Depth zone code
General Data Type: VARCHAR2

EXCLUDE_FLAG

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

Flag to indicate whether site should be excluded from analysis
General Data Type: NUMBER

SITEVISITID

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

Unique Identifier for SITE_VISIT record
General Data Type: NUMBER

DATE_

CC ID: 224634
Seq. Order: 15
Data Storage Type: DATE
Max Length: 7
Required: Yes
Primary Key: No
Status: Active
Description:

Date the survey was conducted
General Data Type: DATE

OBS_DAY

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

Observation Day
General Data Type: NUMBER

OBS_MONTH

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

Observation Month
General Data Type: NUMBER

OBS_YEAR

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

Observation Year
General Data Type: NUMBER

HABITAT_CODE

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

Habitat code
General Data Type: VARCHAR2

HABITAT_TYPE

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

Habitat type
General Data Type: VARCHAR2

COMMENTS

CC ID: 224640
Seq. Order: 21
Data Storage Type: NVARCHAR2
Max Length: 750
Required: No
Primary Key: No
Status: Active
Description:

General observation comments
General Data Type: NVARCHAR2

DIVER

CC ID: 224641
Seq. Order: 22
Data Storage Type: NVARCHAR2
Max Length: 150
Required: Yes
Primary Key: No
Status: Active
Description:

Initials of diver conducting survey
General Data Type: NVARCHAR2

BELTTRANSECTRUN

CC ID: 224642
Seq. Order: 23
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 38
Scale: 0
Status: Active
Description:

Primary key for CORAL_BELT_TRANSECTRUN
General Data Type: NUMBER

METHODNAME

CC ID: 224643
Seq. Order: 24
Data Storage Type: NVARCHAR2
Max Length: 150
Required: Yes
Primary Key: No
Status: Active
Description:

References the coral belt survey method
General Data Type: NVARCHAR2

TRANSECT

CC ID: 224644
Seq. Order: 25
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 38
Scale: 0
Status: Active
Description:

Transect Number
General Data Type: NUMBER

SEGMENT

CC ID: 224645
Seq. Order: 26
Data Storage Type: NVARCHAR2
Max Length: 150
Required: No
Primary Key: No
Status: Active
Description:

Segment Number
General Data Type: NVARCHAR2

TRANWIDTH

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

Transect Length (m)
General Data Type: NUMBER

TRANLENGTH

CC ID: 224647
Seq. Order: 28
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 28
Scale: 8
Status: Active
Description:

Transect Width (m)
General Data Type: NUMBER

MINDEPTH

CC ID: 224648
Seq. Order: 29
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 28
Scale: 0
Status: Active
Description:

Minimum Depth of the transect (in meters)
General Data Type: NUMBER

MAXDEPTH

CC ID: 224649
Seq. Order: 30
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 28
Scale: 0
Status: Active
Description:

Maximum Depth of the transect (in meters)
General Data Type: NUMBER

CLADIELLA_YN

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

Flag to indicate presence of cladiella on transect (Added Sept. 2014)
General Data Type: NUMBER

DENDRONEPHTHYA_YN

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

Flag to indicate presence of dendronephthya on transect (Added Sept. 2014)
General Data Type: NUMBER

LOBOPHYTUM_YN

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

Flag to indicate presence of lobophytum on transect (Added Sept. 2014)
General Data Type: NUMBER

PACHYCLAVULARIA_YN

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

Flag to indicate presence of pachyclavularia on transect (Added Sept. 2014)
General Data Type: NUMBER

SARCOPHYTON_YN

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

Flag to indicate presence of sarcophyton on transect (Added Sept. 2014)
General Data Type: NUMBER

SINULARIA_YN

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

Flag to indicate presence of sinularia on transect (Added Sept. 2014)
General Data Type: NUMBER

STEREONEPHTHYA_YN

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

Flag to indicate presence of stereonephthya on transect (Added Sept. 2014)
General Data Type: NUMBER

WIRECORAL_YN

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

Flag to indicate presence of wire coral on transect (Added Sept. 2014)
General Data Type: NUMBER

PALYTHOA_YN

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

Flag to indicate presence of palythoa on transect (Added Sept. 2014)
General Data Type: NUMBER

PROTOPALYTHOA_YN

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

Flag to indicate presence of protopalythoa on transect (Added Sept. 2014)
General Data Type: NUMBER

ZOANTHUS_YN

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

Flag to indicate presence of zoanthus on transect (Added Sept. 2014)
General Data Type: NUMBER

NO_SURVEY_YN

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

Flag to indicate transect was not surveyed (Added Sept. 2014)
General Data Type: NUMBER

COLONYID

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

Colony Identifier
General Data Type: NUMBER

SPECIES

CC ID: 224663
Seq. Order: 44
Data Storage Type: NVARCHAR2
Max Length: 150
Required: No
Primary Key: No
Status: Active
Description:

Species observed
General Data Type: NVARCHAR2

MORPH_CODE

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

4-letter morphology code
General Data Type: VARCHAR2

MORPHOLOGY

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

Definition of morphology code
General Data Type: VARCHAR2

COLONYLENGTH

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

Colony Length (cm)
General Data Type: NUMBER

OLDDEAD

CC ID: 224667
Seq. Order: 48
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 0
Status: Active
Description:

Percentage of old dead coral
General Data Type: NUMBER

RECENTDEAD

CC ID: 224668
Seq. Order: 49
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 0
Status: Active
Description:

Percentage of recently dead coral
General Data Type: NUMBER

RECENT_GENERAL_CAUSE_CODE

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

General cause code of recently dead coral captured in RECENTDEAD field
General Data Type: VARCHAR2

RECENT_SPECIFIC_CAUSE_CODE

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

Specific cause code of recently dead coral captured in RECENTDEAD field
General Data Type: VARCHAR2

RECENTDEAD_2

CC ID: 224671
Seq. Order: 52
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 0
Status: Active
Description:

Percentage of recently dead coral
General Data Type: NUMBER

RECENT_GENERAL_CAUSE_CODE_2

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

General cause code of recently dead coral captured in RECENTDEAD_2 field
General Data Type: VARCHAR2

RECENT_SPECIFIC_CAUSE_CODE_2

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

Specific cause code of recently dead coral captured in RECENTDEAD_2 field
General Data Type: VARCHAR2

DZCODE

CC ID: 224674
Seq. Order: 55
Data Storage Type: NVARCHAR2
Max Length: 15
Required: No
Primary Key: No
Status: Active
Description:

Coral disease code of the observed coral colony
General Data Type: NVARCHAR2

DZCLASS

CC ID: 224675
Seq. Order: 56
Data Storage Type: NVARCHAR2
Max Length: 150
Required: No
Primary Key: No
Status: Active
Description:

Coral Disease
General Data Type: NVARCHAR2

MAP_CODE

CC ID: 224676
Seq. Order: 57
Data Storage Type: NVARCHAR2
Max Length: 150
Required: No
Primary Key: No
Status: Active
Description:

The map code for the coral disease
General Data Type: NVARCHAR2

EXTENT

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

Disease Extent (1-100)
General Data Type: NUMBER

SEVERITY

CC ID: 224678
Seq. Order: 59
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 0
Status: Active
Description:

Disease Severity (1-5)
General Data Type: NUMBER

TAXONNAME

CC ID: 224679
Seq. Order: 60
Data Storage Type: NVARCHAR2
Max Length: 765
Required: No
Primary Key: No
Status: Active
Description:

Taxonomic Name
General Data Type: NVARCHAR2

PHYLUM

CC ID: 224680
Seq. Order: 61
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Phylum Taxonomic Rank
General Data Type: VARCHAR2

CLASS

CC ID: 224681
Seq. Order: 62
Data Storage Type: NVARCHAR2
Max Length: 60
Required: No
Primary Key: No
Status: Active
Description:

Class Taxonomic Rank
General Data Type: NVARCHAR2

S_ORDER

CC ID: 224682
Seq. Order: 63
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Order Taxonomic Rank
General Data Type: VARCHAR2

FAMILY

CC ID: 224683
Seq. Order: 64
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Family Taxonomic Rank
General Data Type: VARCHAR2

GENUS_CODE

CC ID: 224684
Seq. Order: 65
Data Storage Type: NVARCHAR2
Max Length: 12
Required: No
Primary Key: No
Status: Active
Description:

4-letter genus code
General Data Type: NVARCHAR2

GENUS

CC ID: 224685
Seq. Order: 66
Data Storage Type: NVARCHAR2
Max Length: 300
Required: No
Primary Key: No
Status: Active
Description:

Genus Taxonomic Rank
General Data Type: NVARCHAR2

SCIENTIFIC_NAME

CC ID: 224686
Seq. Order: 67
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Scientific Name Taxonomic Rank
General Data Type: VARCHAR2

RANK

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

Rank from WoRMS
General Data Type: VARCHAR2

APHIAID

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

Aphia ID from WoRMS
General Data Type: VARCHAR2

CORAL_CORISID

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

CoRIS ID for coral metadata record (Added June 2011)
General Data Type: NUMBER

Catalog Details

Catalog Item ID: 27438
GUID: gov.noaa.nmfs.inport:27438
Metadata Record Created By: Annette M DesRochers
Metadata Record Created: 2015-09-23 23:05+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2020-04-03
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2020-04-03
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2021-04-03