Metadata Rubric

100%

6 / 6

PIFSC Metadata Library > PIFSC Coral Reef Ecosystem Program (CREP) Metad... > National Coral Reef Monitoring Program > Pacific Remote Island Areas > National Coral Reef Monitoring Program: Calcifi... >

Calcification Accretion Unit Entity

Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:36078 | Updated: August 9, 2022 | Published / External

Item Identification

Title:	Calcification Accretion Unit Entity
Short Name:	CAU Entity
Status:	Completed
Abstract:	Calculates the calcification rate by unit (by grouping the upper and lower plates together), and is reported in the V_NCEI_OCC_CAU Dataview.
Notes:	Loaded by batch 9612, 12-20-2016 21:17

Entity Information

Entity Type:	Data View
Active Version?:	Yes
Schema Name:	GISDAT
Description:	Calcification Accretion Unit Entity. Calculates the calcification rate by unit (by grouping the upper and lower plates together)
Change Summary:	As of 2018 these are the active / relevant fields: REGION, REGION_NAME, LOCATION, REA_SITEID, OCC_SITEID, DATASTATUSID, SERIALNUMBER, CAU_UNIT, CALCIFICATION_RATE_BY_UNIT, LATITUDE, LONGITUDE, DAYS_IN_WATER, YEARS_IN_WATER, DEPLOYMENT_MISSION, DEPLOYMENT_DATE, DEPLOYMENT_YEAR, RECOVERY_MISSION, RECOVERY_DATE, RECOVERY_YEAR

Data Attributes

Attribute Summary

	Name	Type	Description
100	REGION	TEXT	Code for REGION
100	REGION_NAME	TEXT	The name of the region where the CAUs were deployed and recovered in the Pacific Islands region: American Samoa, Pacific Remote Island Areas, Mariana Archipelago, main Hawaiian Islands, Northwestern Hawaiian Islands.
100	LOCATION	TEXT	Name of island or atoll where the CAUs were deployed and recovered in the Pacific Islands region (REGION).
100	REA_SITEID	TEXT	An identifier for the ecological site at the island or atoll (LOCATION) associated with the CAU deployment and recovery. Combines a 3-letter island code (derived from LOCATION) with a 2-4 digit site number.
100	OCC_SITEID	TEXT	An identifier for the fixed climate site where CAU units were deployed and recovered. An OCC_SITEID is a 3-dimensional identifier that describes a location (LATITUDE and LONGITUDE) and depth of a fixed NCRMP climate site and includes "OCC" prefix, a 3-letter location code (derived from LOCATION), and a 3-digit site number.
100	DATASTATUSID	NUMBER	Data quality control flag for calcification rate data generated during the laboratory analysis procedure. 0=good data, 1=best estimate values inserted due to blank entries, 2=plate or filters were only weighed once, 3=difference between filter or plate weights were not <0.1g difference, 4=missing filter paper or paper tray start weights, 5=difference between filter or plate weights were between -0.15 and 0.15, 6=difference between filter or plate weights were between -0.2 and 0.2, 7=data is only available for one of the two plates (upper or lower)
100	SERIALNUMBER	NUMBER	CAU Serial Number. A negative is assigned to a serial number in the unusual event that the serial number for a CAU is repeated.
100	CAU_UNIT	TEXT	An identifier for the CAU unit at the island or atolls specific site of deployment and recovery (LOCATION). Includes site identifier (REA_SITEID) and the serial number (SERIALNUMBER).
100	CALCIFICATION_RATE_BY_UNIT	NUMBER	Calcification Rate (measured in grams per centimeter per year).
100	LATITUDE	NUMBER	Latitude in decimal degrees, WGS84, for the CAU deployment and recovery site.
100	LONGITUDE	NUMBER	Longitude in decimal degrees, WGS84, for the CAU deployment and recovery site.
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	TEXT	Deployment Mission Identifier
100	DEPLOYMENT_DATE	DATE	Date (local) the CAU unit was deployed (m/dd/yyyy)
100	DEPLOYMENT_YEAR	NUMBER	Deployment Year (yyyy)
100	RECOVERY_MISSION	TEXT	Recovery Mission Identifier
100	RECOVERY_DATE	DATE	Date (local) the CAU unit was recovered (m/dd/yyyy)
100	RECOVERY_YEAR	NUMBER	Recovery Year (yyyy)

Name

Type

Description

100

REGION

TEXT

Code for REGION

100

REGION_NAME

TEXT

The name of the region where the CAUs were deployed and recovered in the Pacific Islands region: American Samoa, Pacific Remote Island Areas, Mariana Archipelago, main Hawaiian Islands, Northwestern Hawaiian Islands.

100

LOCATION

TEXT

Name of island or atoll where the CAUs were deployed and recovered in the Pacific Islands region (REGION).

100

REA_SITEID

TEXT

An identifier for the ecological site at the island or atoll (LOCATION) associated with the CAU deployment and recovery. Combines a 3-letter island code (derived from LOCATION) with a 2-4 digit site number.

100

OCC_SITEID

TEXT

An identifier for the fixed climate site where CAU units were deployed and recovered. An OCC_SITEID is a 3-dimensional identifier that describes a location (LATITUDE and LONGITUDE) and depth of a fixed NCRMP climate site and includes "OCC" prefix, a 3-letter location code (derived from LOCATION), and a 3-digit site number.

100

DATASTATUSID

NUMBER

Data quality control flag for calcification rate data generated during the laboratory analysis procedure. 0=good data, 1=best estimate values inserted due to blank entries, 2=plate or filters were only weighed once, 3=difference between filter or plate weights were not <0.1g difference, 4=missing filter paper or paper tray start weights, 5=difference between filter or plate weights were between -0.15 and 0.15, 6=difference between filter or plate weights were between -0.2 and 0.2, 7=data is only available for one of the two plates (upper or lower)

100

SERIALNUMBER

NUMBER

CAU Serial Number. A negative is assigned to a serial number in the unusual event that the serial number for a CAU is repeated.

100

CAU_UNIT

TEXT

An identifier for the CAU unit at the island or atolls specific site of deployment and recovery (LOCATION). Includes site identifier (REA_SITEID) and the serial number (SERIALNUMBER).

100

CALCIFICATION_RATE_BY_UNIT

NUMBER

Calcification Rate (measured in grams per centimeter per year).

100

LATITUDE

NUMBER

Latitude in decimal degrees, WGS84, for the CAU deployment and recovery site.

100

LONGITUDE

NUMBER

Longitude in decimal degrees, WGS84, for the CAU deployment and recovery site.

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

TEXT

Deployment Mission Identifier

100

DEPLOYMENT_DATE

DATE

Date (local) the CAU unit was deployed (m/dd/yyyy)

100

DEPLOYMENT_YEAR

NUMBER

Deployment Year (yyyy)

100

RECOVERY_MISSION

TEXT

Recovery Mission Identifier

100

RECOVERY_DATE

DATE

Date (local) the CAU unit was recovered (m/dd/yyyy)

100

RECOVERY_YEAR

NUMBER

Recovery Year (yyyy)

Attribute Details

REGION

CC ID: 1056863

Seq. Order:	1
Data Storage Type:	TEXT
Required:	No
Primary Key:	No
Status:	Active
Description:	Code for REGION

REGION_NAME

CC ID: 367318

Seq. Order:	2
Data Storage Type:	TEXT
Max Length:	30
Required:	No
Primary Key:	No
Status:	Active
Description:	The name of the region where the CAUs were deployed and recovered in the Pacific Islands region: American Samoa, Pacific Remote Island Areas, Mariana Archipelago, main Hawaiian Islands, Northwestern Hawaiian Islands.

LOCATION

CC ID: 1056865

Seq. Order:	3
Data Storage Type:	TEXT
Required:	No
Primary Key:	No
Status:	Active
Description:	Name of island or atoll where the CAUs were deployed and recovered in the Pacific Islands region (REGION).

REA_SITEID

CC ID: 1056866

Seq. Order:	4
Data Storage Type:	TEXT
Required:	No
Primary Key:	No
Status:	Active
Description:	An identifier for the ecological site at the island or atoll (LOCATION) associated with the CAU deployment and recovery. Combines a 3-letter island code (derived from LOCATION) with a 2-4 digit site number.

OCC_SITEID

CC ID: 1056867

Seq. Order:	5
Data Storage Type:	TEXT
Required:	No
Primary Key:	No
Status:	Active
Description:	An identifier for the fixed climate site where CAU units were deployed and recovered. An OCC_SITEID is a 3-dimensional identifier that describes a location (LATITUDE and LONGITUDE) and depth of a fixed NCRMP climate site and includes "OCC" prefix, a 3-letter location code (derived from LOCATION), and a 3-digit site number.

DATASTATUSID

CC ID: 1056897

Seq. Order:	6
Data Storage Type:	NUMBER
Required:	No
Primary Key:	No
Status:	Active
Description:	Data quality control flag for calcification rate data generated during the laboratory analysis procedure. 0=good data, 1=best estimate values inserted due to blank entries, 2=plate or filters were only weighed once, 3=difference between filter or plate weights were not <0.1g difference, 4=missing filter paper or paper tray start weights, 5=difference between filter or plate weights were between -0.15 and 0.15, 6=difference between filter or plate weights were between -0.2 and 0.2, 7=data is only available for one of the two plates (upper or lower)

SERIALNUMBER

CC ID: 367319

Seq. Order:	7
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 CAU is repeated.

CAU_UNIT

CC ID: 367307

Seq. Order:	8
Data Storage Type:	TEXT
Max Length:	273
Required:	No
Primary Key:	No
Status:	Active
Description:	An identifier for the CAU unit at the island or atolls specific site of deployment and recovery (LOCATION). Includes site identifier (REA_SITEID) and the serial number (SERIALNUMBER).

CALCIFICATION_RATE_BY_UNIT

CC ID: 367306

Seq. Order:	9
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).

LATITUDE

CC ID: 367313

Seq. Order:	10
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Status:	Active
Description:	Latitude in decimal degrees, WGS84, for the CAU deployment and recovery site.

LONGITUDE

CC ID: 367314

Seq. Order:	11
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	Longitude in decimal degrees, WGS84, for the CAU deployment and recovery site.

DAYS_IN_WATER

CC ID: 367308

Seq. Order:	12
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Scale:	0
Status:	Active
Description:	Number of days in the water

YEARS_IN_WATER

CC ID: 367321

Seq. Order:	13
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	Number of years in the water

DEPLOYMENT_MISSION

CC ID: 367310

Seq. Order:	14
Data Storage Type:	TEXT
Max Length:	30
Required:	No
Primary Key:	No
Status:	Active
Description:	Deployment Mission Identifier

DEPLOYMENT_DATE

CC ID: 367309

Seq. Order:	15
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	Date (local) the CAU unit was deployed (m/dd/yyyy)

DEPLOYMENT_YEAR

CC ID: 367311

Seq. Order:	16
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	28
Scale:	0
Status:	Active
Description:	Deployment Year (yyyy)

RECOVERY_MISSION

CC ID: 367316

Seq. Order:	17
Data Storage Type:	TEXT
Required:	No
Primary Key:	No
Status:	Active
Description:	Recovery Mission Identifier

RECOVERY_DATE

CC ID: 367315

Seq. Order:	18
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	Date (local) the CAU unit was recovered (m/dd/yyyy)

RECOVERY_YEAR

CC ID: 367317

Seq. Order:	19
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	28
Scale:	0
Status:	Active
Description:	Recovery Year (yyyy)

Catalog Details

Catalog Item ID:	36078
GUID:	gov.noaa.nmfs.inport:36078
Metadata Record Created By:	Troy T Kanemura
Metadata Record Created:	2016-12-20 21:19+0000
Metadata Record Last Modified By:	SysAdmin InPortAdmin
Metadata Record Last Modified:	2022-08-09 17:11+0000
Metadata Record Published:	2022-08-03
Owner Org:	PIFSC
Metadata Publication Status:	Published Externally
Do Not Publish?:	N
Metadata Last Review Date:	2022-08-03
Metadata Review Frequency:	1 Year
Metadata Next Review Date:	2023-08-03