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