Item Identification

Title: Table: SEALS
Short Name: SEALS
Status: Completed
Abstract:

Each Seal is significant as a Hawaiian monk seal which may be tracked for population studies. If an individual seal loses all of its tags, it may be retagged and re-recorded as another Seal. Pups are also recorded here.

Notes:

Loaded by batch 4358, 02-12-2013 15:39

Keywords

Theme Keywords

Thesaurus Keyword
None hawaiian monk seal
None hmsrp
None pifsc
None population assessment
None protected species
None psd
None seal record

Spatial Keywords

Thesaurus Keyword
None hawaiian archipelago
None pacific region

Physical Location

Organization: Pacific Islands Fisheries Science Center
City: Honolulu
State/Province: HI
Country: USA
Location Description:

1601 Kapiolani Blvd

Honolulu, HI

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: MSEAL
Description:

Each Seal is significant as a Hawaiian monk seal which may be tracked for population studies. If an individual seal loses all of its tags, it may be retagged and re-recorded as another Seal. Pups are also recorded here.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Atoll_Year TEXT Atoll Year where seal was first observed
100
WEAN_GEO_ID TEXT Geographic area (atoll, island, sector, or beach) in which the seal was weaned
100
WEANED_BY_SEAL TEXT Seal's weanmom
100
MOTHER_SEAL TEXT Seal's mother
100
NEW_GEO_ID TEXT Geographic area (atoll, island, sector, or beach) at which the seal was first assigned its primary id.
100
MOTHER_GEO_ID TEXT Geographic area for seal's mother
100
BIRTHPLACE_GEO_ID TEXT Birthplace (atoll, island, sector, or beach) of the seal
100
PRIMARY_ID TEXT The Permanent or Pseudo-Permanent ID of the seal (a unique 8-character name assigned by PSD staff)
100
PRIOR_ID TEXT The Permanent or Pseudo-Permanent ID of the seal
100
NEWID_YEAR TEXT The Year (YYYY) in which this seal was first identified.
100
MOTHER_YEAR TEXT The YEAR (YYYY) when this seal was born.
100
BIRTHDATE_1 DATE First possible birthdate of this seal. Logic attaches to this column.
100
BIRTHDATE_2 DATE Last possible birthdate of this seal. Logic attaches to this column.
100
SEX TEXT Sex (code) of this seal. LOV
100
WEANDATE_1 DATE First possible wean date of this seal. Logic attaches to this column.
100
WEANDATE_2 DATE Last possible wean date of this seal. Logic attaches to this column.
100
NURSE_B_OR_N TEXT This is "B" if the mother who nursed this seal was observed to have given birth to this seal, "N" if only nursing could be determined.
100
PUP_SWITCH TEXT Did the mom(s) definitely switch or not? Y,N,U (LOV)
100
SURV_STATUS TEXT Last known status regarding survival of this seal LOV.
100
GONE_DATE DATE If Status is dead, gone or disappeared, this is day after last date it was seen.
100
NAME_1 TEXT If seal has been named, it is recorded here. 2 potential.
100
NAME_2 TEXT If seal has been named, it is recorded here. 2 potential.
100
COHORT_TAGGED TEXT Was this seal tagged as a cohort member?
100
MEMO_TEXT TEXT Free-form text entry field for recording information about this seal which applies mainly to it's entire life.
100
CREATED_BY TEXT Username that created the record
100
CREATE_DTM DATE System date/time of record creation
100
LAST_MOD_BY TEXT Username that last modified the record
100
LAST_MOD_DTM DATE System date/time of last modification of the record

Attribute Details

Atoll_Year

CC ID: 844788
Seq. Order: 1
Data Storage Type: TEXT
Required: Yes
Primary Key: No
Status: Active
Description:

Atoll Year where seal was first observed

WEAN_GEO_ID

CC ID: 96165
Seq. Order: 2
Data Storage Type: TEXT
Max Length: 16
Required: No
Primary Key: No
Status: Active
Description:

Geographic area (atoll, island, sector, or beach) in which the seal was weaned

General Data Type: RAW
Foreign Key Relations:

MSEAL.MS_GEO_AREAS

WEANED_BY_SEAL

CC ID: 844692
Seq. Order: 3
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

Seal's weanmom

MOTHER_SEAL

CC ID: 844693
Seq. Order: 4
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

Seal's mother

NEW_GEO_ID

CC ID: 96166
Seq. Order: 5
Data Storage Type: TEXT
Max Length: 16
Required: Yes
Primary Key: No
Status: Active
Description:

Geographic area (atoll, island, sector, or beach) at which the seal was first assigned its primary id.

General Data Type: RAW
Foreign Key Relations:

MSEAL.MS_GEO_AREAS

MOTHER_GEO_ID

CC ID: 96167
Seq. Order: 6
Data Storage Type: TEXT
Max Length: 16
Required: No
Primary Key: No
Status: Active
Description:

Geographic area for seal's mother

General Data Type: RAW
Foreign Key Relations:

MSEAL.MS_GEO_AREAS

BIRTHPLACE_GEO_ID

CC ID: 96168
Seq. Order: 8
Data Storage Type: TEXT
Max Length: 16
Required: No
Primary Key: No
Status: Active
Description:

Birthplace (atoll, island, sector, or beach) of the seal

General Data Type: RAW
Foreign Key Relations:

MSEAL.MS_GEO_AREAS

PRIMARY_ID

CC ID: 96141
Seq. Order: 10
Data Storage Type: TEXT
Max Length: 8
Required: Yes
Primary Key: No
Status: Active
Description:

The Permanent or Pseudo-Permanent ID of the seal (a unique 8-character name assigned by PSD staff)

General Data Type: VARCHAR2

PRIOR_ID

CC ID: 96142
Seq. Order: 11
Data Storage Type: TEXT
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

The Permanent or Pseudo-Permanent ID of the seal

General Data Type: VARCHAR2

NEWID_YEAR

CC ID: 96143
Seq. Order: 12
Data Storage Type: TEXT
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

The Year (YYYY) in which this seal was first identified.

General Data Type: VARCHAR2

MOTHER_YEAR

CC ID: 96144
Seq. Order: 13
Data Storage Type: TEXT
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

The YEAR (YYYY) when this seal was born.

General Data Type: VARCHAR2

BIRTHDATE_1

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

First possible birthdate of this seal. Logic attaches to this column.

General Data Type: DATE

BIRTHDATE_2

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

Last possible birthdate of this seal. Logic attaches to this column.

General Data Type: DATE

SEX

CC ID: 96147
Seq. Order: 16
Data Storage Type: TEXT
Max Length: 1
Required: Yes
Primary Key: No
Status: Active
Description:

Sex (code) of this seal. LOV

General Data Type: VARCHAR2

WEANDATE_1

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

First possible wean date of this seal. Logic attaches to this column.

General Data Type: DATE

WEANDATE_2

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

Last possible wean date of this seal. Logic attaches to this column.

General Data Type: DATE

NURSE_B_OR_N

CC ID: 96150
Seq. Order: 19
Data Storage Type: TEXT
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

This is "B" if the mother who nursed this seal was observed to have given birth to this seal, "N" if only nursing could be determined.

General Data Type: VARCHAR2

PUP_SWITCH

CC ID: 96151
Seq. Order: 20
Data Storage Type: TEXT
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Did the mom(s) definitely switch or not? Y,N,U (LOV)

General Data Type: VARCHAR2

SURV_STATUS

CC ID: 96152
Seq. Order: 21
Data Storage Type: TEXT
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Last known status regarding survival of this seal LOV.

General Data Type: VARCHAR2

GONE_DATE

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

If Status is dead, gone or disappeared, this is day after last date it was seen.

General Data Type: DATE

NAME_1

CC ID: 96154
Seq. Order: 23
Data Storage Type: TEXT
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

If seal has been named, it is recorded here. 2 potential.

General Data Type: VARCHAR2

NAME_2

CC ID: 96155
Seq. Order: 24
Data Storage Type: TEXT
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

If seal has been named, it is recorded here. 2 potential.

General Data Type: VARCHAR2

COHORT_TAGGED

CC ID: 96156
Seq. Order: 25
Data Storage Type: TEXT
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Was this seal tagged as a cohort member?

General Data Type: VARCHAR2

MEMO_TEXT

CC ID: 96159
Seq. Order: 28
Data Storage Type: TEXT
Max Length: 2000
Required: No
Primary Key: No
Status: Active
Description:

Free-form text entry field for recording information about this seal which applies mainly to it's entire life.

General Data Type: VARCHAR2

CREATED_BY

CC ID: 96160
Seq. Order: 29
Data Storage Type: TEXT
Max Length: 30
Required: Yes
Primary Key: No
Status: Active
Description:

Username that created the record

General Data Type: VARCHAR2

CREATE_DTM

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

System date/time of record creation

General Data Type: DATE

LAST_MOD_BY

CC ID: 96162
Seq. Order: 31
Data Storage Type: TEXT
Max Length: 30
Required: Yes
Primary Key: No
Status: Active
Description:

Username that last modified the record

General Data Type: VARCHAR2

LAST_MOD_DTM

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

System date/time of last modification of the record

General Data Type: DATE

Support Roles

Data Steward

CC ID: 102751
Date Effective From: 2007-06-13
Date Effective To:
Contact (Person): Johanos, Thea C
Address: 1845 Wasp Blvd.
Honolulu, HI 96818
USA
Email Address: thea.johanos-kam@noaa.gov
Phone: (808)725-5709

Originator

CC ID: 102752
Date Effective From: 2007-06-13
Date Effective To:
Contact (Organization): Pacific Islands Fisheries Science Center (PIFSC)
Address: 1845 Wasp Blvd.
Honolulu, HI 96818
USA
Phone: 808-725-5300
URL: http://www.pifsc.noaa.gov
Business Hours: 8:00 a.m. - 4:30 p.m.

Point of Contact

CC ID: 102750
Date Effective From: 2007-06-13
Date Effective To:
Contact (Person): Johanos, Thea C
Address: 1845 Wasp Blvd.
Honolulu, HI 96818
USA
Email Address: thea.johanos-kam@noaa.gov
Phone: (808)725-5709

Extents

Currentness Reference: Ground Condition

Extent Group 1

Extent Group 1 / Time Frame 1

CC ID: 102753
Time Frame Type: Continuing
Start: 1962-12-31

Access Information

Security Class: Restricted
Data Access Policy:

NMFS/PIFSC, Protected Species Division, Hawaiian Monk Seal Research Program Data Access, Sharing, and Dissemination Guidelines

Data Access Procedure:

Requestor will be asked to submit a request to Thea Johanos (thea.johanos-kam@noaa.gov)

Data Access Constraints:

NMFS/PIFSC, Protected Species Division, Hawaiian Monk Seal Research Program Data Access, Sharing, and Dissemination Guidelines

Data Use Constraints:

Use of the data set must be cleared with NMFS/PIFSC, Protected Species Division. These data are PRELIMINARY and have not be completely screened for accuracy. NOAA can not be held liable for use of these data in a manner other than for perusal of preliminary data. The developers of these data are concerned with assuring its proper use. Before data are used to draw specific scientific conclusions, potential users are requested to contact NMFS/PIFSC, Protected Species Division for background on the data. Acknowledgement of the data should be cited. Different versions of the dataset may exist. The user must be sure to use the appropriate data set for the time period of interest. While efforts have been made to ensure that these data are accurate and reliable, NOAA cannot assume liablility for any damages or misrepresentation caused by any inaccuracies in the data or as a result of changes to the data caused by system transfers.

Catalog Details

Catalog Item ID: 18293
Metadata Record Created By: Vikram Khurana
Metadata Record Created: 2013-02-12 15:39+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2019-06-04 13:14+0000
Metadata Record Published: 2019-05-30
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2020-05-30