Search Help Show/Hide Menu
Metadata Rubric
99%
5.91 / 6
View Report
OPR Meta Data Library > Permits and Conservation Division (F/PR1) > Public Display of Marine Mammals > National Inventory of Marine Mammals (NIMM) >

Table: NIMM_PERSONS

Entity (ENT)  |  NMFS Office Of Protected Resources (OPR)
GUID: gov.noaa.nmfs.inport:27003  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

individuals specifically identified as holders or their representatives, facility representatives, or other facility people of note

Description

individuals specifically identified as holders or their representatives, facility representatives, or other facility people of note

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
PERSON_ID
NUMBER 		the unique identifier of a person
PR_PERSON_TYPE
VARCHAR2 		the type of person, ie, foreign or US
PR_PERSON_TITLE
VARCHAR2 		the title of the person, such as "Miss"
PR_PERSON_FIRST_NAME
VARCHAR2 		the given name or first name of the person
PR_PERSON_MIDDLE_NAME
VARCHAR2 		the person's middle name(s)
PR_PERSON_LAST_NAME
VARCHAR2 		the family name or last name of the person
PR_PERSON_FAMILIAL_SUFFIX
VARCHAR2 		the person's familial suffix, such as "Jr." or "IV"
PR_PERSON_PROFESSIONAL_SUFFIX
VARCHAR2 		the person's academic or professional suffix, such as "D.V.M." or "Ph.D."
PR_ADDRESS1
VARCHAR2 		the "main" street address of the person
PR_ADDRESS2
VARCHAR2 		the secondary street address of the person
PR_CITY
VARCHAR2 		the city in which the person resides
PR_STATE_ABRV
VARCHAR2
PR_ZIP_POSTAL_CODE
VARCHAR2 		the zip or postal code in which the person resides
PR_COUNTRY_NAME
VARCHAR2
PR_EMAIL
VARCHAR2 		the person's email address
PR_PHONE
VARCHAR2 		the person's phone number
PR_FAX
VARCHAR2 		the person's fax number
PR_PERSON_COMMENT
VARCHAR2 		comments pertaining to the person
DELETED_FLAG
VARCHAR2 		indicates whether or not this record has been logically deleted
DATE_CREATED
DATE 		the date this record was inserted
CREATED_BY
VARCHAR2 		the user who inserted this record
DATE_MODIFIED
DATE 		the date of the most recent modification to this record
MODIFIED_BY
VARCHAR2 		the last user who modified this record

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (OPR) for inquiries on this record.

Item Identification

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

individuals specifically identified as holders or their representatives, facility representatives, or other facility people of note
Notes:

Loaded by batch 7077, 09-17-2015 08:15

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: NIMM_APPS
Description:

individuals specifically identified as holders or their representatives, facility representatives, or other facility people of note

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key PERSON_ID NUMBER the unique identifier of a person
100
 PR_PERSON_TYPE VARCHAR2 the type of person, ie, foreign or US
100
 PR_PERSON_TITLE VARCHAR2 the title of the person, such as "Miss"
100
 PR_PERSON_FIRST_NAME VARCHAR2 the given name or first name of the person
100
 PR_PERSON_MIDDLE_NAME VARCHAR2 the person's middle name(s)
100
 PR_PERSON_LAST_NAME VARCHAR2 the family name or last name of the person
100
 PR_PERSON_FAMILIAL_SUFFIX VARCHAR2 the person's familial suffix, such as "Jr." or "IV"
100
 PR_PERSON_PROFESSIONAL_SUFFIX VARCHAR2 the person's academic or professional suffix, such as "D.V.M." or "Ph.D."
100
 PR_ADDRESS1 VARCHAR2 the "main" street address of the person
100
 PR_ADDRESS2 VARCHAR2 the secondary street address of the person
100
 PR_CITY VARCHAR2 the city in which the person resides
67
 PR_STATE_ABRV VARCHAR2
100
 PR_ZIP_POSTAL_CODE VARCHAR2 the zip or postal code in which the person resides
67
 PR_COUNTRY_NAME VARCHAR2
100
 PR_EMAIL VARCHAR2 the person's email address
100
 PR_PHONE VARCHAR2 the person's phone number
100
 PR_FAX VARCHAR2 the person's fax number
100
 PR_PERSON_COMMENT VARCHAR2 comments pertaining to the person
100
 DELETED_FLAG VARCHAR2 indicates whether or not this record has been logically deleted
100
 DATE_CREATED DATE the date this record was inserted
100
 CREATED_BY VARCHAR2 the user who inserted this record
100
 DATE_MODIFIED DATE the date of the most recent modification to this record
100
 MODIFIED_BY VARCHAR2 the last user who modified this record

Attribute Details

PERSON_ID

CC ID: 219325
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 38
Scale: 0
Status: Active
Description:

the unique identifier of a person
General Data Type: NUMBER

PR_PERSON_TYPE

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

the type of person, ie, foreign or US
General Data Type: VARCHAR2

PR_PERSON_TITLE

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

the title of the person, such as "Miss"
General Data Type: VARCHAR2

PR_PERSON_FIRST_NAME

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

the given name or first name of the person
General Data Type: VARCHAR2

PR_PERSON_MIDDLE_NAME

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

the person's middle name(s)
General Data Type: VARCHAR2

PR_PERSON_LAST_NAME

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

the family name or last name of the person
General Data Type: VARCHAR2

PR_PERSON_FAMILIAL_SUFFIX

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

the person's familial suffix, such as "Jr." or "IV"
General Data Type: VARCHAR2

PR_PERSON_PROFESSIONAL_SUFFIX

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

the person's academic or professional suffix, such as "D.V.M." or "Ph.D."
General Data Type: VARCHAR2

PR_ADDRESS1

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

the "main" street address of the person
General Data Type: VARCHAR2

PR_ADDRESS2

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

the secondary street address of the person
General Data Type: VARCHAR2

PR_CITY

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

the city in which the person resides
General Data Type: VARCHAR2

PR_STATE_ABRV

CC ID: 219328
Seq. Order: 12
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

PR_ZIP_POSTAL_CODE

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

the zip or postal code in which the person resides
General Data Type: VARCHAR2

PR_COUNTRY_NAME

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

PR_EMAIL

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

the person's email address
General Data Type: VARCHAR2

PR_PHONE

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

the person's phone number
General Data Type: VARCHAR2

PR_FAX

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

the person's fax number
General Data Type: VARCHAR2

PR_PERSON_COMMENT

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

comments pertaining to the person
General Data Type: VARCHAR2

DELETED_FLAG

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

indicates whether or not this record has been logically deleted
General Data Type: VARCHAR2

DATE_CREATED

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

the date this record was inserted
General Data Type: DATE

CREATED_BY

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

the user who inserted this record
General Data Type: VARCHAR2

DATE_MODIFIED

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

the date of the most recent modification to this record
General Data Type: DATE

MODIFIED_BY

CC ID: 219340
Seq. Order: 23
Data Storage Type: VARCHAR2
Max Length: 200
Required: No
Primary Key: No
Status: Active
Description:

the last user who modified this record
General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 27003
GUID: gov.noaa.nmfs.inport:27003
Metadata Record Created By: Nathan Wilson
Metadata Record Created: 2015-09-17 08:15+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2018-05-16
Owner Org: OPR
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2018-05-16
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2019-05-16