Table: MS_TAGS

Item Identification

Title:	Table: MS_TAGS
Short Name:	MS_TAGS
Status:	Completed
Abstract:	Each tag is significant as a label attached to a flipper on a seal. A tag requires the following information to be unique: Tag Number+Tag Color+ Tag Position [+ Tag Web]
Notes:	Loaded by batch 4358, 02-12-2013 15:39

Keywords

Theme Keywords

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

Thesaurus

Keyword

UNCONTROLLED

None

hawaiian monk seal

None

hmsrp

None

pifsc

None

population assessment

None

protected species

None

psd

None

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

Entity Information

Entity Type:	Data Table
Active Version?:	Yes
Schema Name:	MSEAL
Description:	Each tag is significant as a label attached to a flipper on a seal. A tag requires the following information to be unique: Tag Number+Tag Color+ Tag Position [+ Tag Web]

Data Attributes

Attribute Summary

	Name	Type	Description
100	Atoll_Year	VARCHAR2	Atoll and Year the tag was added to seal
100	SEAL_ID	VARCHAR2	Seal carrying the Tag
100	TAG_NUM	VARCHAR2	The alphanumeric number inscribed or encoded on this tag to identify it. (UK1A)
100	Position	VARCHAR2	Whether this tag was applied to left or right flipper of seal. (UK1B)
100	COLOR	VARCHAR2	The color of this tag. (UK1C)
100	WEB	VARCHAR2	The intra-digital web of the flipper in which the tag is located. (UK1D)
100	TAG_TYPE	VARCHAR2	The type of tag represented by this row.
100	REVERSED	VARCHAR2	Was this tag applied in a reversed manner respective of Dorsal/Ventral sides?
100	SUCC_APP	VARCHAR2	Was the application of this tag successful?
100	DATE_DROPPED	DATE	Date this tag was dropped from the seal's records.
100	DATE_UNREADABLE	DATE	Date (YYYYMMDD) this tag was deemed unreadable.
100	DROP_REASON	VARCHAR2	Reason this tag was dropped from seal's records.
100	UNREADABLE_REASON	VARCHAR2	Reason this tag is unreadable.
100	DORSAL_BROKEN	VARCHAR2	Is the Dorsal side of this tag broken?
100	DORSAL_BROKEN_DATE	DATE	Earliest date (YYYYMMDD) the Dorsal side was observed as broken.
100	VENTRAL_BROKEN	VARCHAR2	Is the Ventral side of this tag broken?
100	VENTRAL_BROKEN_DATE	DATE	Earliest date the Ventral side of this tag was observed as broken.
100	CONF_LEVEL	NUMBER	How much confidence do we have in the accuracy of this data row?
100	CHECKING_LEVEL	NUMBER	NEW. How much of the checking "cleanup" process haas been completed at this time snapshot. This would be updated by trigger when data row has passed a particular checking program successfully.
100	MEMO_TEXT	VARCHAR2	Free-form text entry for notes regarding this Tag.
100	CREATE_DTM	DATE	System date/time of record creation
100	LAST_MOD_DTM	DATE	System date/time of last modification of the record
100	FINAL_TAG_CONDITION_VENTRAL	VARCHAR2	Tag Condition for Ventral Tag
100	FINAL_TAG_CONDITION_DORSAL	VARCHAR2	Tag Condition for Dorsal Tag

Name

Type

Description

100

Atoll_Year

VARCHAR2

Atoll and Year the tag was added to seal

100

SEAL_ID

VARCHAR2

Seal carrying the Tag

100

TAG_NUM

VARCHAR2

The alphanumeric number inscribed or encoded on this tag to identify it. (UK1A)

100

Position

VARCHAR2

Whether this tag was applied to left or right flipper of seal. (UK1B)

100

COLOR

VARCHAR2

The color of this tag. (UK1C)

100

WEB

VARCHAR2

The intra-digital web of the flipper in which the tag is located. (UK1D)

100

TAG_TYPE

VARCHAR2

The type of tag represented by this row.

100

REVERSED

VARCHAR2

Was this tag applied in a reversed manner respective of Dorsal/Ventral sides?

100

SUCC_APP

VARCHAR2

Was the application of this tag successful?

100

DATE_DROPPED

DATE

Date this tag was dropped from the seal's records.

100

DATE_UNREADABLE

DATE

Date (YYYYMMDD) this tag was deemed unreadable.

100

DROP_REASON

VARCHAR2

Reason this tag was dropped from seal's records.

100

UNREADABLE_REASON

VARCHAR2

Reason this tag is unreadable.

100

DORSAL_BROKEN

VARCHAR2

Is the Dorsal side of this tag broken?

100

DORSAL_BROKEN_DATE

DATE

Earliest date (YYYYMMDD) the Dorsal side was observed as broken.

100

VENTRAL_BROKEN

VARCHAR2

Is the Ventral side of this tag broken?

100

VENTRAL_BROKEN_DATE

DATE

Earliest date the Ventral side of this tag was observed as broken.

100

CONF_LEVEL

NUMBER

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

100

CHECKING_LEVEL

NUMBER

NEW. How much of the checking "cleanup" process haas been completed at this time snapshot. This would be updated by trigger when data row has passed a particular checking program successfully.

100

MEMO_TEXT

VARCHAR2

Free-form text entry for notes regarding this Tag.

100

CREATE_DTM

DATE

System date/time of record creation

100

LAST_MOD_DTM

DATE

System date/time of last modification of the record

100

FINAL_TAG_CONDITION_VENTRAL

VARCHAR2

Tag Condition for Ventral Tag

100

FINAL_TAG_CONDITION_DORSAL

VARCHAR2

Tag Condition for Dorsal Tag

Attribute Details

Atoll_Year

CC ID: 842320

Seq. Order:	1
Data Storage Type:	VARCHAR2
Required:	No
Primary Key:	No
Status:	Active
Description:	Atoll and Year the tag was added to seal

SEAL_ID

CC ID: 842321

Seq. Order:	2
Data Storage Type:	VARCHAR2
Required:	No
Primary Key:	No
Status:	Active
Description:	Seal carrying the Tag

TAG_NUM

CC ID: 96489

Seq. Order:	7
Data Storage Type:	VARCHAR2
Max Length:	10
Required:	No
Primary Key:	No
Status:	Active
Description:	The alphanumeric number inscribed or encoded on this tag to identify it. (UK1A)
General Data Type:	VARCHAR2

Position

CC ID: 96490

Seq. Order:	8
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Whether this tag was applied to left or right flipper of seal. (UK1B)
General Data Type:	VARCHAR2

COLOR

CC ID: 96491

Seq. Order:	9
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	The color of this tag. (UK1C)
General Data Type:	VARCHAR2

WEB

CC ID: 96492

Seq. Order:	10
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	The intra-digital web of the flipper in which the tag is located. (UK1D)
General Data Type:	VARCHAR2

TAG_TYPE

CC ID: 96493

Seq. Order:	11
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	The type of tag represented by this row.
General Data Type:	VARCHAR2

REVERSED

CC ID: 96494

Seq. Order:	12
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Was this tag applied in a reversed manner respective of Dorsal/Ventral sides?
General Data Type:	VARCHAR2

SUCC_APP

CC ID: 96495

Seq. Order:	13
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Was the application of this tag successful?
General Data Type:	VARCHAR2

DATE_DROPPED

CC ID: 96496

Seq. Order:	14
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	Date this tag was dropped from the seal's records.
General Data Type:	DATE

DATE_UNREADABLE

CC ID: 96497

Seq. Order:	15
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	Date (YYYYMMDD) this tag was deemed unreadable.
General Data Type:	DATE

DROP_REASON

CC ID: 96498

Seq. Order:	16
Data Storage Type:	VARCHAR2
Max Length:	25
Required:	No
Primary Key:	No
Status:	Active
Description:	Reason this tag was dropped from seal's records.
General Data Type:	VARCHAR2

UNREADABLE_REASON

CC ID: 96499

Seq. Order:	17
Data Storage Type:	VARCHAR2
Max Length:	20
Required:	No
Primary Key:	No
Status:	Active
Description:	Reason this tag is unreadable.
General Data Type:	VARCHAR2

DORSAL_BROKEN

CC ID: 96500

Seq. Order:	18
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Is the Dorsal side of this tag broken?
General Data Type:	VARCHAR2

DORSAL_BROKEN_DATE

CC ID: 96501

Seq. Order:	19
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	Earliest date (YYYYMMDD) the Dorsal side was observed as broken.
General Data Type:	DATE

VENTRAL_BROKEN

CC ID: 96502

Seq. Order:	20
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Is the Ventral side of this tag broken?
General Data Type:	VARCHAR2

VENTRAL_BROKEN_DATE

CC ID: 96503

Seq. Order:	21
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	Earliest date the Ventral side of this tag was observed as broken.
General Data Type:	DATE

CONF_LEVEL

CC ID: 96504

Seq. Order:	22
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 data row?
General Data Type:	NUMBER

CHECKING_LEVEL

CC ID: 96505

Seq. Order:	23
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	NEW. How much of the checking "cleanup" process haas been completed at this time snapshot. This would be updated by trigger when data row has passed a particular checking program successfully.
General Data Type:	NUMBER

MEMO_TEXT

CC ID: 96506

Seq. Order:	24
Data Storage Type:	VARCHAR2
Max Length:	2000
Required:	No
Primary Key:	No
Status:	Active
Description:	Free-form text entry for notes regarding this Tag.
General Data Type:	VARCHAR2

CREATE_DTM

CC ID: 96508

Seq. Order:	26
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	System date/time of record creation
General Data Type:	DATE

LAST_MOD_DTM

CC ID: 96510

Seq. Order:	28
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	System date/time of last modification of the record
General Data Type:	DATE

FINAL_TAG_CONDITION_VENTRAL

CC ID: 96512

Seq. Order:	30
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Tag Condition for Ventral Tag
General Data Type:	VARCHAR2

FINAL_TAG_CONDITION_DORSAL

CC ID: 96513

Seq. Order:	31
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Tag Condition for Dorsal Tag
General Data Type:	VARCHAR2

Support Roles

Data Steward

CC ID: 101631

Date Effective From:	2006-08-16
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: 101630

Date Effective From:	2006-08-16
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: 101632

Date Effective From:	2006-08-16
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
Contact Instructions:	Email thea.johanos-kam@noaa.gov

Extents

Currentness Reference:	Ground Condition

Extent Group 1

Extent Group 1 / Time Frame 1

CC ID: 101629

Time Frame Type:	Continuing
Start:	1967-03-12

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:	18304
GUID:	gov.noaa.nmfs.inport:18304
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-29
Owner Org:	PIFSC
Metadata Publication Status:	Published Externally
Do Not Publish?:	N
Metadata Last Review Date:	2019-05-29
Metadata Review Frequency:	1 Year
Metadata Next Review Date:	2020-05-29