Slide Menu
Jump to Section...
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: NotesOnObservers

Entity (ENT)  |  Pacific Islands Regional Office (PIRO)
GUID: gov.noaa.nmfs.inport:21888  |  Updated: August 9, 2022  |  Published / External 

Item Identification

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

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
67
 Primary Key ID INT
67
 OBSERVERID INT
67
 NOTES VARCHAR
67
 STATUS CHAR
67
 LASTUPDATE DATETIME
67
 LASTUPDATEBY INT

Attribute Details

ID

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

OBSERVERID

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

NOTES

CC ID: 178757
Seq. Order: 3
Data Storage Type: VARCHAR
Max Length: 2500
Required: Yes
Primary Key: No
Status: Active

STATUS

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

LASTUPDATE

CC ID: 178759
Seq. Order: 5
Data Storage Type: DATETIME
Max Length: 8
Required: Yes
Primary Key: No
Status: Active

LASTUPDATEBY

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

Catalog Details

Catalog Item ID: 21888
GUID: gov.noaa.nmfs.inport:21888
Metadata Record Created By: Eric Forney
Metadata Record Created: 2014-07-11 17:55+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