Search Help Show/Hide Menu
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