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 > Pacific Reef Assessment and Monitoring Program:... >

View: V_CALCIFICATION_RATE_BY_UNIT

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

Summary

Abstract

calculates the calcification rate by unit (by grouping the upper and lower plates together)

Description

calculates the calcification rate by unit (by grouping the upper and lower plates together)

Entity Information

Entity Type
Data View

Data Attribute / Type Description
REGION_NAME
VARCHAR2 		One of the five Pacific Island regions CRED surveys
ISLAND
NVARCHAR2 		Island or Atoll surveyed
SITE
NVARCHAR2 		The 5- to 6-character code for the site surveyed. Combines a 3-letter island code with a site number
SERIALNUMBER
NUMBER 		CAU Serial Number. A negative is assigned to a serial number in the unusual event that the serial number for a recovered CAU already exists.
CAU_UNIT
NVARCHAR2 		CAU Unit Identifier
CALCIFICATION_RATE_BY_UNIT
NUMBER 		Calcification Rate (measured in grams per centimeter per year)
LATITUDE
NUMBER 		Site latitude
LONGITUDE
NUMBER 		Site longitude
DAYS_IN_WATER
NUMBER 		Number of days in the water
YEARS_IN_WATER
NUMBER 		Number of years in the water
DEPLOYMENT_MISSION
VARCHAR2 		Deployment Mission Identifier
DEPLOYMENT_DATE
DATE 		Deployment Date
DEPLOYMENT_YEAR
NUMBER 		Deployment Year
RECOVERY_MISSION
VARCHAR2 		Recovery Mission Identifier
RECOVERY_DATE
DATE 		Recovery Date
RECOVERY_YEAR
NUMBER 		Recovery Year

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: V_CALCIFICATION_RATE_BY_UNIT
Short Name: V_CALCIFICATION_RATE_BY_UNIT
Status: Completed
Abstract:

calculates the calcification rate by unit (by grouping the upper and lower plates together)
Notes:

Loaded by batch 9612, 12-20-2016 21:17

Entity Information

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

calculates the calcification rate by unit (by grouping the upper and lower plates together)

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 REGION_NAME VARCHAR2 One of the five Pacific Island regions CRED surveys
100
 ISLAND NVARCHAR2 Island or Atoll surveyed
100
 SITE NVARCHAR2 The 5- to 6-character code for the site surveyed. Combines a 3-letter island code with a site number
100
 SERIALNUMBER NUMBER CAU Serial Number. A negative is assigned to a serial number in the unusual event that the serial number for a recovered CAU already exists.
100
 CAU_UNIT NVARCHAR2 CAU Unit Identifier
100
 CALCIFICATION_RATE_BY_UNIT NUMBER Calcification Rate (measured in grams per centimeter per year)
100
 LATITUDE NUMBER Site latitude
100
 LONGITUDE NUMBER Site longitude
100
 DAYS_IN_WATER NUMBER Number of days in the water
100
 YEARS_IN_WATER NUMBER Number of years in the water
100
 DEPLOYMENT_MISSION VARCHAR2 Deployment Mission Identifier
100
 DEPLOYMENT_DATE DATE Deployment Date
100
 DEPLOYMENT_YEAR NUMBER Deployment Year
100
 RECOVERY_MISSION VARCHAR2 Recovery Mission Identifier
100
 RECOVERY_DATE DATE Recovery Date
100
 RECOVERY_YEAR NUMBER Recovery Year

Attribute Details

REGION_NAME

CC ID: 367242
Seq. Order: 1
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: 367243
Seq. Order: 2
Data Storage Type: NVARCHAR2
Max Length: 150
Required: No
Primary Key: No
Status: Active
Description:

Island or Atoll surveyed
General Data Type: NVARCHAR2

SITE

CC ID: 367244
Seq. Order: 3
Data Storage Type: NVARCHAR2
Max Length: 150
Required: No
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

SERIALNUMBER

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

CAU Serial Number. A negative is assigned to a serial number in the unusual event that the serial number for a recovered CAU already exists.
General Data Type: NUMBER

CAU_UNIT

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

CAU Unit Identifier
General Data Type: NVARCHAR2

CALCIFICATION_RATE_BY_UNIT

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

Calcification Rate (measured in grams per centimeter per year)
General Data Type: NUMBER

LATITUDE

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

Site latitude
General Data Type: NUMBER

LONGITUDE

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

Site longitude
General Data Type: NUMBER

DAYS_IN_WATER

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

Number of days in the water
General Data Type: NUMBER

YEARS_IN_WATER

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

Number of years in the water
General Data Type: NUMBER

DEPLOYMENT_MISSION

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

Deployment Mission Identifier
General Data Type: VARCHAR2

DEPLOYMENT_DATE

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

Deployment Date
General Data Type: DATE

DEPLOYMENT_YEAR

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

Deployment Year
General Data Type: NUMBER

RECOVERY_MISSION

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

Recovery Mission Identifier
General Data Type: VARCHAR2

RECOVERY_DATE

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

Recovery Date
General Data Type: DATE

RECOVERY_YEAR

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

Recovery Year
General Data Type: NUMBER

Catalog Details

Catalog Item ID: 36074
GUID: gov.noaa.nmfs.inport:36074
Metadata Record Created By: Annette M DesRochers
Metadata Record Created: 2016-12-20 21:17+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2017-03-23
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2017-03-23
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2018-03-23