Search Help Show/Hide Menu
Metadata Rubric
50%
3 / 6
View Report
PIRO Metadata Library > Pacific Islands Regional Office Observer Progra... > Pacific Islands Region Observer Program System >

Table: Persons

Entity (ENT)  |  Pacific Islands Regional Office (PIRO)
GUID: gov.noaa.nmfs.inport:21890  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Data Attributes
Catalog Details

Summary

Entity Information

Data Attribute / Type Description
PERSONID
INT
LASTNAME
VARCHAR
FIRSTNAME
VARCHAR
EMAIL
VARCHAR
PHONE
CHAR
EMPLOYER
VARCHAR
ACTIVE
CHAR
ROLE
VARCHAR
USERNAME
VARCHAR
ISADMINYN
CHAR
NEWOBSERVER
CHAR

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

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

Item Identification

Title: Table: Persons
Short Name: Persons
Status: In Work

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
67
 Primary Key PERSONID INT
67
 LASTNAME VARCHAR
67
 FIRSTNAME VARCHAR
67
 EMAIL VARCHAR
67
 PHONE CHAR
67
 EMPLOYER VARCHAR
67
 ACTIVE CHAR
67
 ROLE VARCHAR
67
 USERNAME VARCHAR
67
 ISADMINYN CHAR
67
 NEWOBSERVER CHAR

Attribute Details

PERSONID

CC ID: 178768
Seq. Order: 1
Data Storage Type: INT
Max Length: 4
Required: Yes
Primary Key: Yes
Precision: 10
Status: Active

LASTNAME

CC ID: 178769
Seq. Order: 2
Data Storage Type: VARCHAR
Max Length: 50
Required: No
Primary Key: No
Status: Active

FIRSTNAME

CC ID: 178770
Seq. Order: 3
Data Storage Type: VARCHAR
Max Length: 50
Required: No
Primary Key: No
Status: Active

EMAIL

CC ID: 178771
Seq. Order: 4
Data Storage Type: VARCHAR
Max Length: 70
Required: No
Primary Key: No
Status: Active

PHONE

CC ID: 178772
Seq. Order: 5
Data Storage Type: CHAR
Max Length: 12
Required: No
Primary Key: No
Status: Active

EMPLOYER

CC ID: 178773
Seq. Order: 6
Data Storage Type: VARCHAR
Max Length: 50
Required: No
Primary Key: No
Status: Active

ACTIVE

CC ID: 178774
Seq. Order: 7
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active

ROLE

CC ID: 178775
Seq. Order: 8
Data Storage Type: VARCHAR
Max Length: 2
Required: No
Primary Key: No
Status: Active

USERNAME

CC ID: 178776
Seq. Order: 9
Data Storage Type: VARCHAR
Max Length: 50
Required: No
Primary Key: No
Status: Active

ISADMINYN

CC ID: 178777
Seq. Order: 10
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active

NEWOBSERVER

CC ID: 178778
Seq. Order: 11
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active

Catalog Details

Catalog Item ID: 21890
GUID: gov.noaa.nmfs.inport:21890
Metadata Record Created By: Eric Forney
Metadata Record Created: 2014-07-11 17:57+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2015-12-03
Owner Org: PIRO
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2015-12-03
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2016-12-03