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: 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