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 ESD 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 (-1115 to 6074). 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 (.007 to 0.103)
100
LATITUDE NUMBER Site latitude
100
LONGITUDE NUMBER Site longitude=
100
DAYS_IN_WATER NUMBER Number of days in the water (1022 to 1439)
100
YEARS_IN_WATER NUMBER Number of years in the water (2.8 to 3.94)
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: 367286
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 ESD surveys

ISLAND

CC ID: 367280
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: 367288
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: 367287
Seq. Order: 4
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

CAU Serial Number (-1115 to 6074). 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: 367275
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: 367274
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 (.007 to 0.103)

LATITUDE

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

Site latitude

LONGITUDE

CC ID: 367282
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: 367276
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 (1022 to 1439)

YEARS_IN_WATER

CC ID: 367289
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 (2.8 to 3.94)

DEPLOYMENT_MISSION

CC ID: 367278
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: 367277
Seq. Order: 12
Data Storage Type: DATE
Max Length: 7
Required: Yes
Primary Key: No
Status: Active
Description:

Deployment Date

DEPLOYMENT_YEAR

CC ID: 367279
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: 367284
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: 367283
Seq. Order: 15
Data Storage Type: DATE
Max Length: 7
Required: Yes
Primary Key: No
Status: Active
Description:

Recovery Date

RECOVERY_YEAR

CC ID: 367285
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: 36076
Metadata Record Created By: Troy T Kanemura
Metadata Record Created: 2016-12-20 21:18+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2019-06-04 13:14+0000
Metadata Record Published: 2017-01-19
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2018-01-20