Item Identification

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

Object Comments:. Fish REA foundational view

Entity Information

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

Object Comments:. Fish REA foundational view

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
OBJECTID NUMBER Unique identifier for fish REA observations
100
ROUNDID NUMBER Unique Identifier for ROUND record
100
MISSIONID VARCHAR2 Mission Identifier
100
REGION_NAME VARCHAR2 The Pacific Island region surveyed: American Samoa, Pacific Remote Island Areas, Mariana Archipelago, main Hawaiian Islands, Northwestern Hawaiian Islands.
100
ISLAND NVARCHAR2 Island or Atoll surveyed in the Pacific Island region (REGION_NAME).
100
SITE NVARCHAR2 The code for the site surveyed at the island or atoll (ISLAND). Combines a 3-letter island code with a 2-4 digit site number.
100
LATITUDE NUMBER Site latitude as recorded by divers on the datasheets in decimal degrees
100
LONGITUDE NUMBER Site longitude as recorded by divers on the datasheets in decimal degrees
100
REEF_ZONE NVARCHAR2 The reef zone for the given site (Forereef, Backreef, Protected Slope, 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. Shallow: >0-6 m, Mid: >6-18 m, Deep: >18-30 m.
100
SITEVISITID NUMBER Unique Identifier for SITE_VISIT record
100
DATE_ DATE Local date the survey was conducted
100
OBS_YEAR NUMBER Year the survey was conducted
100
DIVER NVARCHAR2 Initials of diver conducting survey
100
REPLICATEID NUMBER Unique identifier for the replicate sample within a Fish REA survey
100
REP NVARCHAR2 Letter associated to replicate (A, B, C, or D)
100
METHOD NVARCHAR2 Fish method employed: stationary point count (nSPC)
100
PHOTOGRAPHER NUMBER Flag to indicate photographer of benthic photos. Two divers simultaneously conduct a survey at a site (indicated by the initials of the observer in the DIVER field), only one of which captures the benthic photos. Value -1 indicates the photographer.
100
TRAINING_YN NUMBER Flag to signify whether replicate was for training purposes. Value -1 indicates the replicate was for training.
100
DEPTH NUMBER Depth of survey area in meters. Depths usually within 0-30 m.
100
SURVEY_RADIUS_M NUMBER Radius of survey area in meters, usually 7.5 m (15-m SPC survey 'cylinder')
100
HARD_CORAL NUMBER Hard coral cover (%)
100
SOFT_CORAL NUMBER Soft coral cover (%)
100
MA NUMBER Macroalgae cover (%)
100
CCA NUMBER Crustose coralline algae (CCA) cover (%)
100
TA NUMBER Turf algae cover (%). No longer collected as of 2016 surveys; pooled into OTHER.
100
SAND NUMBER Sand cover (%). No longer collected as of 2016 surveys; pooled into OTHER.
100
TUNICATE NUMBER Tunicate cover (%). No longer collected as of 2016 surveys; pooled into OTHER.
100
ZOANTHID NUMBER Zoanthid cover (%). No longer collected as of 2016 surveys; pooled into OTHER.
100
CORALLIMORPH NUMBER Corallimorph cover (%). No longer collected as of 2016 surveys; pooled into OTHER.
100
CLAM NUMBER Clam cover (%). No longer collected as of 2016 surveys; pooled into OTHER.
100
CYANO NUMBER Cyanobacteria cover (%). No longer collected as of 2016 surveys; pooled into OTHER.
100
SPONGE NUMBER Sponge cover (%). No longer collected as of 2016 surveys; pooled into OTHER.
100
OTHER NUMBER Other benthic composition cover (%). Turf algae, sand, tunicates, zoanthids, corallimorphs, clams, cyanobacteria, and sponges are pooled into this category as of 2016 surveys.
100
OTHER_TYPE VARCHAR2 Other benthic composition cover type. No longer collected as of 2016 surveys.
100
HABITAT_CODE VARCHAR2 Habitat code (see HABITAT_TYPE for description of code).
100
HABITAT_TYPE VARCHAR2 HABITAT_CODE description
100
CURRENT_STRENGTH VARCHAR2 Current Strength (None, Slight, Moderate, High)
100
VISIBILITY NUMBER Visibility measured in meters
100
MIN_DEPTH NUMBER Minimum depth of the diver’s survey cylinder in meters
100
MAX_DEPTH NUMBER Maximum depth of the diver’s survey cylinder in meters
100
SUBSTRATE_HEIGHT_0 NUMBER Proportion of survey area between 0 cm and 20 cm elevation
100
SUBSTRATE_HEIGHT_20 NUMBER Proportion of survey area between 20 cm and 50 cm elevation
100
SUBSTRATE_HEIGHT_50 NUMBER Proportion of survey area between 50 cm and 100 cm elevation
100
SUBSTRATE_HEIGHT_100 NUMBER Proportion of survey area between 100 cm and 150 cm elevation
100
SUBSTRATE_HEIGHT_150 NUMBER Proportion of survey area over 150 cm elevation
100
MAX_HEIGHT NUMBER Highest elevation point in SPC cylinder measured in meters
100
URCHIN_DACOR VARCHAR2 Free urchin abundance, estimated by DACOR, an abundance code based on visual estimation (Dominant, Abundant, Common, Occasional, and Rare)
100
BORING_URCHIN_DACOR VARCHAR2 Boring urchin abundance, estimated by DACOR, an abundance code based on visual estimation (Dominant, Abundant, Common, Occasional, and Rare)
100
SPECIES NVARCHAR2 4-letter species code
100
TAXONNAME NVARCHAR2 Scientific name of observed organism to the lowest level identified in the taxonomic hierarchy, which is usually species (see RANK).
100
COMMONNAME NVARCHAR2 Common name (from FishBase)
100
COMMONFAMILYALL NVARCHAR2 Common name of all families
100
FAMILY NVARCHAR2 Taxonomic family classification
100
SCIENTIFIC_NAME VARCHAR2 Holds the true scientific name (genus and species name). If blank, organism identified to genus or higher RANK in taxonomic hierarchy (not identified to species). See RANK.
100
RANK VARCHAR2 Lowest defined rank in taxonomic hierarchy
100
TROPHIC NVARCHAR2 Trophic level: APEX (apex predator), Cor (corallivore), H (herbivore), MI (mobile invertivore), Om (Omnivore), Par (parasite), Pisc (piscivore), Pk (planktivore), SI (sessile invertivore), X (if unidentified fish), Z (zooplantivore)
100
TROPHIC_MONREP NVARCHAR2 Trophic level scheme used (Primary Consumer, Secondary Consumer, Planktivore, Piscivore)
100
LW_A NUMBER Parameter "a" used in length-weight calculations
100
LW_B NUMBER Parameter "b" used in length-weight calculations
100
LMAX NUMBER Maximum length of the fish published in literature in centimeters
100
LENGTH_CONVERSION_FACTOR NUMBER Factor to convert length as TOTAL LENGTH to get it to right form (standard [SL], fork [FL], or total length [TL]) for available length weight A and B parameters for this species
100
COUNT NUMBER Number of fish observed during survey
100
SIZE_ NUMBER Total length of fish, measured from the tip of the snout to the tip of the longer lobe of the caudal fin, reported in centimeters. Total length for rays (Myliobatidae) is measured from pectoral fin tip to pectoral fin tip.
100
OBS_TYPE VARCHAR2 A single letter representation of the observation type (see OBS_DESC for description)
100
OBS_DESC VARCHAR2 The definition of the observation type (OBS_TYPE)

Attribute Details

OBJECTID

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

Unique identifier for fish REA observations

ROUNDID

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

Unique Identifier for ROUND record

MISSIONID

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

Mission Identifier

REGION_NAME

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

The Pacific Island region surveyed: American Samoa, Pacific Remote Island Areas, Mariana Archipelago, main Hawaiian Islands, Northwestern Hawaiian Islands.

ISLAND

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

Island or Atoll surveyed in the Pacific Island region (REGION_NAME).

SITE

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

The code for the site surveyed at the island or atoll (ISLAND). Combines a 3-letter island code with a 2-4 digit site number.

LATITUDE

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

Site latitude as recorded by divers on the datasheets in decimal degrees

LONGITUDE

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

Site longitude as recorded by divers on the datasheets in decimal degrees

REEF_ZONE

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

The reef zone for the given site (Forereef, Backreef, Protected Slope, or Lagoon)

DEPTH_BIN

CC ID: 365136
Seq. Order: 10
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. Shallow: >0-6 m, Mid: >6-18 m, Deep: >18-30 m.

SITEVISITID

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

Unique Identifier for SITE_VISIT record

DATE_

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

Local date the survey was conducted

OBS_YEAR

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

Year the survey was conducted

DIVER

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

Initials of diver conducting survey

REPLICATEID

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

Unique identifier for the replicate sample within a Fish REA survey

REP

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

Letter associated to replicate (A, B, C, or D)

METHOD

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

Fish method employed: stationary point count (nSPC)

PHOTOGRAPHER

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

Flag to indicate photographer of benthic photos. Two divers simultaneously conduct a survey at a site (indicated by the initials of the observer in the DIVER field), only one of which captures the benthic photos. Value -1 indicates the photographer.

TRAINING_YN

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

Flag to signify whether replicate was for training purposes. Value -1 indicates the replicate was for training.

DEPTH

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

Depth of survey area in meters. Depths usually within 0-30 m.

SURVEY_RADIUS_M

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

Radius of survey area in meters, usually 7.5 m (15-m SPC survey 'cylinder')

HARD_CORAL

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

Hard coral cover (%)

SOFT_CORAL

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

Soft coral cover (%)

MA

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

Macroalgae cover (%)

CCA

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

Crustose coralline algae (CCA) cover (%)

TA

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

Turf algae cover (%). No longer collected as of 2016 surveys; pooled into OTHER.

SAND

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

Sand cover (%). No longer collected as of 2016 surveys; pooled into OTHER.

TUNICATE

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

Tunicate cover (%). No longer collected as of 2016 surveys; pooled into OTHER.

ZOANTHID

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

Zoanthid cover (%). No longer collected as of 2016 surveys; pooled into OTHER.

CORALLIMORPH

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

Corallimorph cover (%). No longer collected as of 2016 surveys; pooled into OTHER.

CLAM

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

Clam cover (%). No longer collected as of 2016 surveys; pooled into OTHER.

CYANO

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

Cyanobacteria cover (%). No longer collected as of 2016 surveys; pooled into OTHER.

SPONGE

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

Sponge cover (%). No longer collected as of 2016 surveys; pooled into OTHER.

OTHER

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

Other benthic composition cover (%). Turf algae, sand, tunicates, zoanthids, corallimorphs, clams, cyanobacteria, and sponges are pooled into this category as of 2016 surveys.

OTHER_TYPE

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

Other benthic composition cover type. No longer collected as of 2016 surveys.

HABITAT_CODE

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

Habitat code (see HABITAT_TYPE for description of code).

HABITAT_TYPE

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

HABITAT_CODE description

CURRENT_STRENGTH

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

Current Strength (None, Slight, Moderate, High)

VISIBILITY

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

Visibility measured in meters

MIN_DEPTH

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

Minimum depth of the diver’s survey cylinder in meters

MAX_DEPTH

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

Maximum depth of the diver’s survey cylinder in meters

SUBSTRATE_HEIGHT_0

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

Proportion of survey area between 0 cm and 20 cm elevation

SUBSTRATE_HEIGHT_20

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

Proportion of survey area between 20 cm and 50 cm elevation

SUBSTRATE_HEIGHT_50

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

Proportion of survey area between 50 cm and 100 cm elevation

SUBSTRATE_HEIGHT_100

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

Proportion of survey area between 100 cm and 150 cm elevation

SUBSTRATE_HEIGHT_150

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

Proportion of survey area over 150 cm elevation

MAX_HEIGHT

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

Highest elevation point in SPC cylinder measured in meters

URCHIN_DACOR

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

Free urchin abundance, estimated by DACOR, an abundance code based on visual estimation (Dominant, Abundant, Common, Occasional, and Rare)

BORING_URCHIN_DACOR

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

Boring urchin abundance, estimated by DACOR, an abundance code based on visual estimation (Dominant, Abundant, Common, Occasional, and Rare)

SPECIES

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

4-letter species code

TAXONNAME

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

Scientific name of observed organism to the lowest level identified in the taxonomic hierarchy, which is usually species (see RANK).

COMMONNAME

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

Common name (from FishBase)

COMMONFAMILYALL

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

Common name of all families

FAMILY

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

Taxonomic family classification

SCIENTIFIC_NAME

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

Holds the true scientific name (genus and species name). If blank, organism identified to genus or higher RANK in taxonomic hierarchy (not identified to species). See RANK.

RANK

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

Lowest defined rank in taxonomic hierarchy

TROPHIC

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

Trophic level: APEX (apex predator), Cor (corallivore), H (herbivore), MI (mobile invertivore), Om (Omnivore), Par (parasite), Pisc (piscivore), Pk (planktivore), SI (sessile invertivore), X (if unidentified fish), Z (zooplantivore)

TROPHIC_MONREP

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

Trophic level scheme used (Primary Consumer, Secondary Consumer, Planktivore, Piscivore)

LW_A

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

Parameter "a" used in length-weight calculations

LW_B

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

Parameter "b" used in length-weight calculations

LMAX

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

Maximum length of the fish published in literature in centimeters

LENGTH_CONVERSION_FACTOR

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

Factor to convert length as TOTAL LENGTH to get it to right form (standard [SL], fork [FL], or total length [TL]) for available length weight A and B parameters for this species

COUNT

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

Number of fish observed during survey

SIZE_

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

Total length of fish, measured from the tip of the snout to the tip of the longer lobe of the caudal fin, reported in centimeters. Total length for rays (Myliobatidae) is measured from pectoral fin tip to pectoral fin tip.

OBS_TYPE

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

A single letter representation of the observation type (see OBS_DESC for description)

OBS_DESC

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

The definition of the observation type (OBS_TYPE)

Catalog Details

Catalog Item ID: 35996
Metadata Record Created By: Troy T Kanemura
Metadata Record Created: 2016-12-14 20:25+0000
Metadata Record Last Modified By: Brooke Olenski
Metadata Record Last Modified: 2020-03-17 21:43+0000
Metadata Record Published: 2020-03-17
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2021-03-18