Item Identification

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

Each Handle is significant as one or more physical interaction with a seal at a given time.

Notes:

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

Keywords

Theme Keywords

Thesaurus Keyword
None handling cards
None handlings
None hawaiian monk seal
None pifsc
None population assessment
None protected species
None psd

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 Handle is significant as one or more physical interaction with a seal at a given time.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Atoll_Year TEXT Atoll and Year for the handling
100
GEO_AREA TEXT Geographic are where handling occured
100
SEAL_ID TEXT Seal that was handled
100
HANDLING_NUM NUMBER An auto generated number specific to the atoll and year
100
HANDLE_DATE DATE Date of handling
100
SEAL_SIZE VARCHAR2 The coded size (as observed) of the seal being handled.
100
WEANED_LE_2WKS VARCHAR2 If handled seal is a weaned pup, did the weaning occur within 2 weeks prior to the handling event?
100
RESTRAINT_MIN NUMBER How many minutes was the seal restrained (Can be greater than 60!)
100
RESTRAINT_SEC NUMBER How many seconds was the seal restrained? (CANNOT be greater than 59!)
100
DRUG_ADMIN VARCHAR2 Whether drugs were administered to the seal at this event.
100
DRUG_METHOD VARCHAR2 How were the drugs administered? - a coded entry validated with LOV.
100
DRUG_AMT NUMBER The amount of drug administered.
100
DRUG_TYPE VARCHAR2 The drug name.
100
NOTES VARCHAR2 A code to indicate the presence of notes on the hand-written card which are not recorded here. vk- is this still needed given that people can enter notes?
100
CONF_LEVEL NUMBER Level of confidence in the accuracy of this data.
100
CHECKING_LEVEL NUMBER Level to which this data has been successfully checked/ cleaned up.
100
MEMO_TEXT VARCHAR2 A free-form text entry field allowing for notes.
100
CREATED_BY VARCHAR2 Oracle username that created the record
100
CREATE_DTM DATE System date/time of record creation
100
LAST_MOD_BY VARCHAR2 Oracle username that last modified the record
100
LAST_MOD_DTM DATE System date/time of last modification of the record
100
AXIL_GIRTH NUMBER Numeric measurement (decimal) of the axillary girth of this seal.
100
DORSAL_LENGTH NUMBER Numeric (decimal) measurement of the dorsal length of this seal.
100
VENTRAL_LENGTH NUMBER Numeric (decimal) measurement of the ventral length of this seal.
100
NET_WT NUMBER Numeric (decimal) weight of this seal NET of equipment used for weighing.
100
WT_UNIT TEXT Whether Metric or English units were used for these measurements and weights.
100
SCALE_NUM NUMBER The number assigned to the scale which was used for this weighing.
100
HANDLING_TYPE TEXT Defined code for type of handling.

Attribute Details

Atoll_Year

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

Atoll and Year for the handling

GEO_AREA

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

Geographic are where handling occured

SEAL_ID

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

Seal that was handled

HANDLING_NUM

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

An auto generated number specific to the atoll and year

General Data Type: NUMBER

HANDLE_DATE

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

Date of handling

General Data Type: DATE

SEAL_SIZE

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

The coded size (as observed) of the seal being handled.

General Data Type: VARCHAR2

WEANED_LE_2WKS

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

If handled seal is a weaned pup, did the weaning occur within 2 weeks prior to the handling event?

General Data Type: VARCHAR2

RESTRAINT_MIN

CC ID: 95426
Seq. Order: 8
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

How many minutes was the seal restrained (Can be greater than 60!)

General Data Type: NUMBER

RESTRAINT_SEC

CC ID: 95427
Seq. Order: 9
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

How many seconds was the seal restrained? (CANNOT be greater than 59!)

General Data Type: NUMBER

DRUG_ADMIN

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

Whether drugs were administered to the seal at this event.

General Data Type: VARCHAR2

DRUG_METHOD

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

How were the drugs administered? - a coded entry validated with LOV.

General Data Type: VARCHAR2

DRUG_AMT

CC ID: 95430
Seq. Order: 12
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 1
Status: Active
Description:

The amount of drug administered.

General Data Type: NUMBER

DRUG_TYPE

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

The drug name.

General Data Type: VARCHAR2

NOTES

CC ID: 95432
Seq. Order: 14
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

A code to indicate the presence of notes on the hand-written card which are not recorded here. vk- is this still needed given that people can enter notes?

General Data Type: VARCHAR2

CONF_LEVEL

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

Level of confidence in the accuracy of this data.

General Data Type: NUMBER

CHECKING_LEVEL

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

Level to which this data has been successfully checked/ cleaned up.

General Data Type: NUMBER

MEMO_TEXT

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

A free-form text entry field allowing for notes.

General Data Type: VARCHAR2

CREATED_BY

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

Oracle username that created the record

General Data Type: VARCHAR2

CREATE_DTM

CC ID: 95437
Seq. Order: 19
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_BY

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

Oracle username that last modified the record

General Data Type: VARCHAR2

LAST_MOD_DTM

CC ID: 95439
Seq. Order: 21
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

AXIL_GIRTH

CC ID: 845928
Seq. Order: 22
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Numeric measurement (decimal) of the axillary girth of this seal.

DORSAL_LENGTH

CC ID: 845929
Seq. Order: 23
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Numeric (decimal) measurement of the dorsal length of this seal.

VENTRAL_LENGTH

CC ID: 845930
Seq. Order: 24
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Numeric (decimal) measurement of the ventral length of this seal.

NET_WT

CC ID: 845931
Seq. Order: 25
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Numeric (decimal) weight of this seal NET of equipment used for weighing.

WT_UNIT

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

Whether Metric or English units were used for these measurements and weights.

SCALE_NUM

CC ID: 845967
Seq. Order: 27
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

The number assigned to the scale which was used for this weighing.

HANDLING_TYPE

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

Defined code for type of handling.

Support Roles

Data Steward

CC ID: 102211
Date Effective From: 2007-06-12
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: 102212
Date Effective From: 2007-06-12
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: 102210
Date Effective From: 2007-06-12
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: 102213
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: 18275
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