Table: MS_SEAL_ANNUALS

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
UNCONTROLLED
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

Thesaurus

Keyword

UNCONTROLLED

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
UNCONTROLLED
None	annual records

Thesaurus

Keyword

UNCONTROLLED

None

annual records

Spatial Keywords

Thesaurus	Keyword
UNCONTROLLED
None	hawaiian archipelago
None	pacific region

Thesaurus

Keyword

UNCONTROLLED

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

	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

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
Email Address:	pifsc.info@noaa.gov
Phone:	808-725-5360
URL:	https://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
GUID:	gov.noaa.nmfs.inport: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:	2022-10-20 02:17+0000
Metadata Record Published:	2019-05-30
Owner Org:	PIFSC
Metadata Publication Status:	Published Externally
Do Not Publish?:	N
Metadata Last Review Date:	2019-05-30
Metadata Review Frequency:	1 Year
Metadata Next Review Date:	2020-05-30