Item Identification

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

Each Seal Annual is significant as data collected about a monk seal at an atoll in a given year. Mothers & pups sighted for that year at an island are recorded here.

Notes:

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

Keywords

Theme Keywords

Thesaurus Keyword
None hawaiian monk seal
None hmsrp
None individual seal
None master id
None molt
None pifsc
None population assessment
None protected species
None psd
None reproduction

Temporal Keywords

Thesaurus Keyword
None annual records

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 Annual is significant as data collected about a monk seal at an atoll in a given year. Mothers & pups sighted for that year at an island are recorded here.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
SEEN_IN_GEO_AREA TEXT Geographic area (atoll, island, sector, or beach) of this seal sighting
100
Atoll_Year TEXT Atoll and Year for this annual record
100
SEAL_ID TEXT Seal that is the subject of this record.
100
OBS_YEAR DATE Year of this ANNUAL record
100
SEAL_SIZE VARCHAR2 MASTER - Size of this seal this year. Will be a summary value determined by camp leader at end of season, so this MASTER column is NOT updateable.
100
MOLT_BEGIN_DATE DATE Date molting began this year for this seal.
100
MOLT_END_DATE DATE Date molting ended this year for this seal.
100
PUP_DATE_BEGIN DATE ONLY APPLIES TO ADULT FEMALES. First date pup of this year could have been born. Logic attaches to this column.
100
PUP_DATE_END DATE ONLY APPLIES TO ADULT FEMALES. Last date pup of this year could have been born. Logic attaches to this column.
100
NURSE_ID_B_OR_N VARCHAR2 For Newborns: Was the above the real mom or possibly a nurse only?
100
PUP_SWITCH VARCHAR2 Was the pup switched
100
WEAN_DATE_BEGIN DATE ONLY APPLIES TO ADULT FEMALES. First date pup of this year could have been weaned. Logic attaches to this column.
100
WEAN_DATE_END DATE ONLY APPLIES TO ADULT FEMALES. Last date pup of this year could have been weaned. Logic attaches to this column.
100
INC_IN_POP_TOTAL VARCHAR2 used for analysis programs - should this seal be included in the total for this sub-population?
100
NEW_ID NUMBER Is this a new seal id? This flag indicates whether a new seal id should be inserted into seal table. Not needed anymore
100
UNIQUE_ANIMAL NUMBER Is this an unique animal or possibly the same seal as another row?
100
CONF_LEVEL NUMBER How much confidence do we have in the accuracy of this row?
100
CHECKING_LEVEL NUMBER What level of checking and editing has been completed successfully?
100
MEMO_TEXT VARCHAR2 Free-form text entry for a memo relating to this seal for this year.
100
CREATED_BY VARCHAR2 Username that created the record
100
CREATE_DTM DATE System date/time of record creation
100
LAST_MOD_BY VARCHAR2 Username that last modified the record
100
LAST_MOD_DTM DATE System date/time of last modification of the record

Attribute Details

SEEN_IN_GEO_AREA

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

Geographic area (atoll, island, sector, or beach) of this seal sighting

Atoll_Year

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

Atoll and Year for this annual record

SEAL_ID

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

Seal that is the subject of this record.

OBS_YEAR

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

Year of this ANNUAL record

General Data Type: DATE

SEAL_SIZE

CC ID: 96230
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

MASTER - Size of this seal this year. Will be a summary value determined by camp leader at end of season, so this MASTER column is NOT updateable.

General Data Type: VARCHAR2

MOLT_BEGIN_DATE

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

Date molting began this year for this seal.

General Data Type: DATE

MOLT_END_DATE

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

Date molting ended this year for this seal.

General Data Type: DATE

PUP_DATE_BEGIN

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

ONLY APPLIES TO ADULT FEMALES. First date pup of this year could have been born. Logic attaches to this column.

General Data Type: DATE

PUP_DATE_END

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

ONLY APPLIES TO ADULT FEMALES. Last date pup of this year could have been born. Logic attaches to this column.

General Data Type: DATE

NURSE_ID_B_OR_N

CC ID: 96235
Seq. Order: 12
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

For Newborns: Was the above the real mom or possibly a nurse only?

General Data Type: VARCHAR2

PUP_SWITCH

CC ID: 96236
Seq. Order: 13
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Was the pup switched

General Data Type: VARCHAR2

WEAN_DATE_BEGIN

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

ONLY APPLIES TO ADULT FEMALES. First date pup of this year could have been weaned. Logic attaches to this column.

General Data Type: DATE

WEAN_DATE_END

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

ONLY APPLIES TO ADULT FEMALES. Last date pup of this year could have been weaned. Logic attaches to this column.

General Data Type: DATE

INC_IN_POP_TOTAL

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

used for analysis programs - should this seal be included in the total for this sub-population?

General Data Type: VARCHAR2

NEW_ID

CC ID: 96240
Seq. Order: 17
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 1
Scale: 0
Status: Active
Description:

Is this a new seal id? This flag indicates whether a new seal id should be inserted into seal table. Not needed anymore

General Data Type: NUMBER

UNIQUE_ANIMAL

CC ID: 96241
Seq. Order: 18
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 1
Scale: 0
Status: Active
Description:

Is this an unique animal or possibly the same seal as another row?

General Data Type: NUMBER

CONF_LEVEL

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

How much confidence do we have in the accuracy of this row?

General Data Type: NUMBER

CHECKING_LEVEL

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

What level of checking and editing has been completed successfully?

General Data Type: NUMBER

MEMO_TEXT

CC ID: 96244
Seq. Order: 21
Data Storage Type: VARCHAR2
Max Length: 2000
Required: No
Primary Key: No
Status: Active
Description:

Free-form text entry for a memo relating to this seal for this year.

General Data Type: VARCHAR2

CREATED_BY

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

Username that created the record

General Data Type: VARCHAR2

CREATE_DTM

CC ID: 96246
Seq. Order: 23
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: 96247
Seq. Order: 24
Data Storage Type: VARCHAR2
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: 96248
Seq. Order: 25
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: 102718
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: 102719
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: 102717
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: 102720
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: 18296
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