Item Identification

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

Each MS Person is significant as someone who views or updates MSRS data. Includes field personnel, key punchers, observers, data administrators.

Notes:

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

Keywords

Theme Keywords

Thesaurus Keyword
None hawaiian monk seal
None hmsrp
None observers
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 MS Person is significant as someone who views or updates MSRS data. Includes field personnel, key punchers, observers, data administrators.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key PERS_KEY RAW System-generated primary key for Persons
100
LAST_NAME VARCHAR2 Family name of Observer.
100
FIRST_NAME_AND_MI VARCHAR2 Given name and middle initial of observer.
100
IS_USER VARCHAR2 Is this person a user of the MSRS? Y or NULL
100
IS_OBSERVER VARCHAR2 Is this person an Observer? Y or NULL
100
INITIALS VARCHAR2 Observer's initials. 3 Characters. Middle character is left blank if no middle initial.
100
ADDRESS VARCHAR2 Street or mailing address of observer's home.
100
PHONE VARCHAR2 Home or contact phone number for observer.
100
VOLUNTEER VARCHAR2 Was this observer a volunteer?
100
AFFILIATION VARCHAR2 Other organization (if any) with which this observer is affiliated.
100
USERNAME VARCHAR2 Oracle username
100
PASSWORD VARCHAR2 Password from field system
67
RIGHTS VARCHAR2
100
ACTIVE_USER_YN VARCHAR2 Is this person an active user, Y or N?
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

Attribute Details

PERS_KEY

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

System-generated primary key for Persons

General Data Type: RAW

LAST_NAME

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

Family name of Observer.

General Data Type: VARCHAR2

FIRST_NAME_AND_MI

CC ID: 96124
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 15
Required: No
Primary Key: No
Status: Active
Description:

Given name and middle initial of observer.

General Data Type: VARCHAR2

IS_USER

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

Is this person a user of the MSRS? Y or NULL

General Data Type: VARCHAR2

IS_OBSERVER

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

Is this person an Observer? Y or NULL

General Data Type: VARCHAR2

INITIALS

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

Observer's initials. 3 Characters. Middle character is left blank if no middle initial.

General Data Type: VARCHAR2

ADDRESS

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

Street or mailing address of observer's home.

General Data Type: VARCHAR2

PHONE

CC ID: 96129
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 15
Required: No
Primary Key: No
Status: Active
Description:

Home or contact phone number for observer.

General Data Type: VARCHAR2

VOLUNTEER

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

Was this observer a volunteer?

General Data Type: VARCHAR2

AFFILIATION

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

Other organization (if any) with which this observer is affiliated.

General Data Type: VARCHAR2

USERNAME

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

Oracle username

General Data Type: VARCHAR2

PASSWORD

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

Password from field system

General Data Type: VARCHAR2

RIGHTS

CC ID: 96134
Seq. Order: 13
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

ACTIVE_USER_YN

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

Is this person an active user, Y or N?

General Data Type: VARCHAR2

CREATED_BY

CC ID: 96136
Seq. Order: 15
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: 96137
Seq. Order: 16
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: 96138
Seq. Order: 17
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: 96139
Seq. Order: 18
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

Support Roles

Data Steward

CC ID: 102766
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: 102767
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: 102765
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: 102768
Time Frame Type: Continuing
Start: 1982-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 Divisionand, adhere to all policies regarding release of personal information. 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: 18292
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: 2017-09-29
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2018-09-30