Table: NIMM_PERSONS
Entity (ENT) | NMFS Office Of Protected Resources (OPR)GUID: gov.noaa.nmfs.inport:27003 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
individuals specifically identified as holders or their representatives, facility representatives, or other facility people of note
Descriptionindividuals 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
Name | Type | Description | ||
---|---|---|---|---|
100
|
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Seq. Order: | 14 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 20 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
General Data Type: | VARCHAR2 |
PR_EMAIL
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
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
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
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
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
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
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
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
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 |