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: 367302
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

ISLAND

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

Island or Atoll surveyed

SITE

CC ID: 367304
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

SERIALNUMBER

CC ID: 367303
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.

CAU_UNIT

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

CAU Unit Identifier

CALCIFICATION_RATE_BY_UNIT

CC ID: 367290
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)

LATITUDE

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

Site latitude

LONGITUDE

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

Site longitude

DAYS_IN_WATER

CC ID: 367292
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

YEARS_IN_WATER

CC ID: 367305
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

DEPLOYMENT_MISSION

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

Deployment Mission Identifier

DEPLOYMENT_DATE

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

Deployment Date

DEPLOYMENT_YEAR

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

Deployment Year

RECOVERY_MISSION

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

Recovery Mission Identifier

RECOVERY_DATE

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

Recovery Date

RECOVERY_YEAR

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

Recovery Year

Catalog Details

Catalog Item ID: 36077
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: 2019-06-04 13:14+0000
Metadata Record Published: 2017-01-23
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2018-01-24