Slide Menu
InPort and its associated services will be under maintenance and unavailable for the deployment of InPort Release 5.2.3. Downtime Schedule Tuesday, November 29, 2022 12:00pm - 1:30pm Eastern / 10:00am - 11:30pm Pacific / 7:00am - 8:30pm Hawaii Impacted Areas - InPort Website: https://www.fisheries.noaa.gov/inport - InPort WAF: https://www.fisheries.noaa.gov/inportserve/waf What's...
View All
Search Help Show/Hide Menu

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