Metadata Rubric

50%

3 / 6

PIRO Metadata Library > Pacific Islands Regional Office Observer Progra... > Pacific Islands Region Observer Program System >

Table: GreenPencil

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

Summary

Item Identification

Data Attributes

Catalog Details

Data Attribute / Type	Description
ID INT
TRIPID INT
GEARINVENTORY VARCHAR
GEARINVENTORY2 VARCHAR
PLACEMENTCHECKLIST VARCHAR
PLACEMENTCHECKLIST2 VARCHAR
ECONOMICDATA VARCHAR
ECONOMICDATA2 VARCHAR
WCPFC VARCHAR
WCPFC2 VARCHAR
TRIPSPECIFICATIONS VARCHAR
TRIPSPECIFICATIONS2 VARCHAR
SETANDHAUL VARCHAR
SETANDHAUL2 VARCHAR
SEABIRDMITIGATION VARCHAR
SEABIRDMITIGATION2 VARCHAR
GEARCONFIGURATION VARCHAR
GEARCONFIGURATION2 VARCHAR
PSEVENTLOG VARCHAR
PSEVENTLOG2 VARCHAR
CATCHEVENTLOG VARCHAR
CATCHEVENTLOG2 VARCHAR
SEATURTLEFORM VARCHAR
SEATURTLEFORM2 VARCHAR
MMAMMALFORM VARCHAR
MMAMMALFORM2 VARCHAR
SEABIRDFORM VARCHAR
SEABIRDFORM2 VARCHAR
PHOTOLOG VARCHAR
PHOTOLOG2 VARCHAR
SPECIMENLOG VARCHAR
SPECIMENLOG2 VARCHAR
TAGEVENT VARCHAR
TAGEVENT2 VARCHAR
SKETCH VARCHAR
SKETCH2 VARCHAR
DQSHEET VARCHAR
DQSHEET2 VARCHAR
REPORTSFILED VARCHAR
REPORTSFILED2 VARCHAR
PSPAPERWORK VARCHAR
PSPAPERWORK2 VARCHAR
GENERALCOMMENTS VARCHAR
GENERALCOMMENTS2 VARCHAR
FINALIZEDYN CHAR
OBSERVERSIGNATUREYN CHAR
NOTES VARCHAR
OBSLASTUPDATE DATETIME
OBSLASTUPDATEBY INT
LASTUPDATE DATETIME
LASTUPDATEBY INT

Data Attribute / Type

Description

ID
INT

TRIPID
INT

GEARINVENTORY
VARCHAR

GEARINVENTORY2
VARCHAR

PLACEMENTCHECKLIST
VARCHAR

PLACEMENTCHECKLIST2
VARCHAR

ECONOMICDATA
VARCHAR

ECONOMICDATA2
VARCHAR

WCPFC
VARCHAR

WCPFC2
VARCHAR

TRIPSPECIFICATIONS
VARCHAR

TRIPSPECIFICATIONS2
VARCHAR

SETANDHAUL
VARCHAR

SETANDHAUL2
VARCHAR

SEABIRDMITIGATION
VARCHAR

SEABIRDMITIGATION2
VARCHAR

GEARCONFIGURATION
VARCHAR

GEARCONFIGURATION2
VARCHAR

PSEVENTLOG
VARCHAR

PSEVENTLOG2
VARCHAR

CATCHEVENTLOG
VARCHAR

CATCHEVENTLOG2
VARCHAR

SEATURTLEFORM
VARCHAR

SEATURTLEFORM2
VARCHAR

MMAMMALFORM
VARCHAR

MMAMMALFORM2
VARCHAR

SEABIRDFORM
VARCHAR

SEABIRDFORM2
VARCHAR

PHOTOLOG
VARCHAR

PHOTOLOG2
VARCHAR

SPECIMENLOG
VARCHAR

SPECIMENLOG2
VARCHAR

TAGEVENT
VARCHAR

TAGEVENT2
VARCHAR

SKETCH
VARCHAR

SKETCH2
VARCHAR

DQSHEET
VARCHAR

DQSHEET2
VARCHAR

REPORTSFILED
VARCHAR

REPORTSFILED2
VARCHAR

PSPAPERWORK
VARCHAR

PSPAPERWORK2
VARCHAR

GENERALCOMMENTS
VARCHAR

GENERALCOMMENTS2
VARCHAR

FINALIZEDYN
CHAR

OBSERVERSIGNATUREYN
CHAR

NOTES
VARCHAR

OBSLASTUPDATE
DATETIME

OBSLASTUPDATEBY
INT

LASTUPDATE
DATETIME

LASTUPDATEBY
INT

No Child Items for this record.

No contact information is available for this record.

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

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

Attribute Summary

	Name	Type
67	ID	INT
67	TRIPID	INT
67	GEARINVENTORY	VARCHAR
67	GEARINVENTORY2	VARCHAR
67	PLACEMENTCHECKLIST	VARCHAR
67	PLACEMENTCHECKLIST2	VARCHAR
67	ECONOMICDATA	VARCHAR
67	ECONOMICDATA2	VARCHAR
67	WCPFC	VARCHAR
67	WCPFC2	VARCHAR
67	TRIPSPECIFICATIONS	VARCHAR
67	TRIPSPECIFICATIONS2	VARCHAR
67	SETANDHAUL	VARCHAR
67	SETANDHAUL2	VARCHAR
67	SEABIRDMITIGATION	VARCHAR
67	SEABIRDMITIGATION2	VARCHAR
67	GEARCONFIGURATION	VARCHAR
67	GEARCONFIGURATION2	VARCHAR
67	PSEVENTLOG	VARCHAR
67	PSEVENTLOG2	VARCHAR
67	CATCHEVENTLOG	VARCHAR
67	CATCHEVENTLOG2	VARCHAR
67	SEATURTLEFORM	VARCHAR
67	SEATURTLEFORM2	VARCHAR
67	MMAMMALFORM	VARCHAR
67	MMAMMALFORM2	VARCHAR
67	SEABIRDFORM	VARCHAR
67	SEABIRDFORM2	VARCHAR
67	PHOTOLOG	VARCHAR
67	PHOTOLOG2	VARCHAR
67	SPECIMENLOG	VARCHAR
67	SPECIMENLOG2	VARCHAR
67	TAGEVENT	VARCHAR
67	TAGEVENT2	VARCHAR
67	SKETCH	VARCHAR
67	SKETCH2	VARCHAR
67	DQSHEET	VARCHAR
67	DQSHEET2	VARCHAR
67	REPORTSFILED	VARCHAR
67	REPORTSFILED2	VARCHAR
67	PSPAPERWORK	VARCHAR
67	PSPAPERWORK2	VARCHAR
67	GENERALCOMMENTS	VARCHAR
67	GENERALCOMMENTS2	VARCHAR
67	FINALIZEDYN	CHAR
67	OBSERVERSIGNATUREYN	CHAR
67	NOTES	VARCHAR
67	OBSLASTUPDATE	DATETIME
67	OBSLASTUPDATEBY	INT
67	LASTUPDATE	DATETIME
67	LASTUPDATEBY	INT

Name

Type

Description

INT

TRIPID

INT

GEARINVENTORY

VARCHAR

GEARINVENTORY2

VARCHAR

PLACEMENTCHECKLIST

VARCHAR

PLACEMENTCHECKLIST2

VARCHAR

ECONOMICDATA

VARCHAR

ECONOMICDATA2

VARCHAR

WCPFC

VARCHAR

WCPFC2

VARCHAR

TRIPSPECIFICATIONS

VARCHAR

TRIPSPECIFICATIONS2

VARCHAR

SETANDHAUL

VARCHAR

SETANDHAUL2

VARCHAR

SEABIRDMITIGATION

VARCHAR

SEABIRDMITIGATION2

VARCHAR

GEARCONFIGURATION

VARCHAR

GEARCONFIGURATION2

VARCHAR

PSEVENTLOG

VARCHAR

PSEVENTLOG2

VARCHAR

CATCHEVENTLOG

VARCHAR

CATCHEVENTLOG2

VARCHAR

SEATURTLEFORM

VARCHAR

SEATURTLEFORM2

VARCHAR

MMAMMALFORM

VARCHAR

MMAMMALFORM2

VARCHAR

SEABIRDFORM

VARCHAR

SEABIRDFORM2

VARCHAR

PHOTOLOG

VARCHAR

PHOTOLOG2

VARCHAR

SPECIMENLOG

VARCHAR

SPECIMENLOG2

VARCHAR

TAGEVENT

VARCHAR

TAGEVENT2

VARCHAR

SKETCH

VARCHAR

SKETCH2

VARCHAR

DQSHEET

VARCHAR

DQSHEET2

VARCHAR

REPORTSFILED

VARCHAR

REPORTSFILED2

VARCHAR

PSPAPERWORK

VARCHAR

PSPAPERWORK2

VARCHAR

GENERALCOMMENTS

VARCHAR

GENERALCOMMENTS2

VARCHAR

FINALIZEDYN

CHAR

OBSERVERSIGNATUREYN

CHAR

NOTES

VARCHAR

OBSLASTUPDATE

DATETIME

OBSLASTUPDATEBY

INT

LASTUPDATE

DATETIME

LASTUPDATEBY

INT

Attribute Details

ID

CC ID: 178587

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

TRIPID

CC ID: 178588

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

GEARINVENTORY

CC ID: 178565

Seq. Order:	3
Data Storage Type:	VARCHAR
Max Length:	-1
Required:	No
Primary Key:	No
Status:	Active

GEARINVENTORY2

CC ID: 178589

Seq. Order:	4
Data Storage Type:	VARCHAR
Max Length:	-1
Required:	No
Primary Key:	No
Status:	Active

PLACEMENTCHECKLIST

CC ID: 178590

Seq. Order:	5
Data Storage Type:	VARCHAR
Max Length:	-1
Required:	No
Primary Key:	No
Status:	Active

PLACEMENTCHECKLIST2

CC ID: 178591

Seq. Order:	6
Data Storage Type:	VARCHAR
Max Length:	-1
Required:	No
Primary Key:	No
Status:	Active

ECONOMICDATA

CC ID: 178592

Seq. Order:	7
Data Storage Type:	VARCHAR
Max Length:	-1
Required:	No
Primary Key:	No
Status:	Active

ECONOMICDATA2

CC ID: 178593

Seq. Order:	8
Data Storage Type:	VARCHAR
Max Length:	-1
Required:	No
Primary Key:	No
Status:	Active

WCPFC

CC ID: 178594

Seq. Order:	9
Data Storage Type:	VARCHAR
Max Length:	-1
Required:	No
Primary Key:	No
Status:	Active

WCPFC2

CC ID: 178595

Seq. Order:	10
Data Storage Type:	VARCHAR
Max Length:	-1
Required:	No
Primary Key:	No
Status:	Active

TRIPSPECIFICATIONS

CC ID: 178596

Seq. Order:	11
Data Storage Type:	VARCHAR
Max Length:	-1
Required:	No
Primary Key:	No
Status:	Active

TRIPSPECIFICATIONS2

CC ID: 178597

Seq. Order:	12
Data Storage Type:	VARCHAR
Max Length:	-1
Required:	No
Primary Key:	No
Status:	Active

SETANDHAUL

CC ID: 178598

Seq. Order:	13
Data Storage Type:	VARCHAR
Max Length:	-1
Required:	No
Primary Key:	No
Status:	Active

SETANDHAUL2

CC ID: 178599

Seq. Order:	14
Data Storage Type:	VARCHAR
Max Length:	-1
Required:	No
Primary Key:	No
Status:	Active

SEABIRDMITIGATION

CC ID: 178600

Seq. Order:	15
Data Storage Type:	VARCHAR
Max Length:	-1
Required:	No
Primary Key:	No
Status:	Active

SEABIRDMITIGATION2

CC ID: 178601

Seq. Order:	16
Data Storage Type:	VARCHAR
Max Length:	-1
Required:	No
Primary Key:	No
Status:	Active

GEARCONFIGURATION

CC ID: 178602

Seq. Order:	17
Data Storage Type:	VARCHAR
Max Length:	-1
Required:	No
Primary Key:	No
Status:	Active

GEARCONFIGURATION2

CC ID: 178603

Seq. Order:	18
Data Storage Type:	VARCHAR
Max Length:	-1
Required:	No
Primary Key:	No
Status:	Active

PSEVENTLOG

CC ID: 178604

Seq. Order:	19
Data Storage Type:	VARCHAR
Max Length:	-1
Required:	No
Primary Key:	No
Status:	Active

PSEVENTLOG2

CC ID: 178605

Seq. Order:	20
Data Storage Type:	VARCHAR
Max Length:	-1
Required:	No
Primary Key:	No
Status:	Active

CATCHEVENTLOG

CC ID: 178606

Seq. Order:	21
Data Storage Type:	VARCHAR
Max Length:	-1
Required:	No
Primary Key:	No
Status:	Active

CATCHEVENTLOG2

CC ID: 178607

Seq. Order:	22
Data Storage Type:	VARCHAR
Max Length:	-1
Required:	No
Primary Key:	No
Status:	Active

SEATURTLEFORM

CC ID: 178608

Seq. Order:	23
Data Storage Type:	VARCHAR
Max Length:	-1
Required:	No
Primary Key:	No
Status:	Active

SEATURTLEFORM2

CC ID: 178609

Seq. Order:	24
Data Storage Type:	VARCHAR
Max Length:	-1
Required:	No
Primary Key:	No
Status:	Active

MMAMMALFORM

CC ID: 178610

Seq. Order:	25
Data Storage Type:	VARCHAR
Max Length:	-1
Required:	No
Primary Key:	No
Status:	Active

MMAMMALFORM2

CC ID: 178611

Seq. Order:	26
Data Storage Type:	VARCHAR
Max Length:	-1
Required:	No
Primary Key:	No
Status:	Active

SEABIRDFORM

CC ID: 178612

Seq. Order:	27
Data Storage Type:	VARCHAR
Max Length:	-1
Required:	No
Primary Key:	No
Status:	Active

SEABIRDFORM2

CC ID: 178613

Seq. Order:	28
Data Storage Type:	VARCHAR
Max Length:	-1
Required:	No
Primary Key:	No
Status:	Active

PHOTOLOG

CC ID: 178614

Seq. Order:	29
Data Storage Type:	VARCHAR
Max Length:	-1
Required:	No
Primary Key:	No
Status:	Active

PHOTOLOG2

CC ID: 178615

Seq. Order:	30
Data Storage Type:	VARCHAR
Max Length:	-1
Required:	No
Primary Key:	No
Status:	Active

SPECIMENLOG

CC ID: 178616

Seq. Order:	31
Data Storage Type:	VARCHAR
Max Length:	-1
Required:	No
Primary Key:	No
Status:	Active

SPECIMENLOG2

CC ID: 178617

Seq. Order:	32
Data Storage Type:	VARCHAR
Max Length:	-1
Required:	No
Primary Key:	No
Status:	Active

TAGEVENT

CC ID: 178618

Seq. Order:	33
Data Storage Type:	VARCHAR
Max Length:	-1
Required:	No
Primary Key:	No
Status:	Active

TAGEVENT2

CC ID: 178619

Seq. Order:	34
Data Storage Type:	VARCHAR
Max Length:	-1
Required:	No
Primary Key:	No
Status:	Active

SKETCH

CC ID: 178620

Seq. Order:	35
Data Storage Type:	VARCHAR
Max Length:	-1
Required:	No
Primary Key:	No
Status:	Active

SKETCH2

CC ID: 178621

Seq. Order:	36
Data Storage Type:	VARCHAR
Max Length:	-1
Required:	No
Primary Key:	No
Status:	Active

DQSHEET

CC ID: 178622

Seq. Order:	37
Data Storage Type:	VARCHAR
Max Length:	-1
Required:	No
Primary Key:	No
Status:	Active

DQSHEET2

CC ID: 178623

Seq. Order:	38
Data Storage Type:	VARCHAR
Max Length:	-1
Required:	No
Primary Key:	No
Status:	Active

REPORTSFILED

CC ID: 178624

Seq. Order:	39
Data Storage Type:	VARCHAR
Max Length:	-1
Required:	No
Primary Key:	No
Status:	Active

REPORTSFILED2

CC ID: 178625

Seq. Order:	40
Data Storage Type:	VARCHAR
Max Length:	-1
Required:	No
Primary Key:	No
Status:	Active

PSPAPERWORK

CC ID: 178626

Seq. Order:	41
Data Storage Type:	VARCHAR
Max Length:	-1
Required:	No
Primary Key:	No
Status:	Active

PSPAPERWORK2

CC ID: 178627

Seq. Order:	42
Data Storage Type:	VARCHAR
Max Length:	-1
Required:	No
Primary Key:	No
Status:	Active

GENERALCOMMENTS

CC ID: 178628

Seq. Order:	43
Data Storage Type:	VARCHAR
Max Length:	-1
Required:	No
Primary Key:	No
Status:	Active

GENERALCOMMENTS2

CC ID: 178629

Seq. Order:	44
Data Storage Type:	VARCHAR
Max Length:	-1
Required:	No
Primary Key:	No
Status:	Active

FINALIZEDYN

CC ID: 178630

Seq. Order:	45
Data Storage Type:	CHAR
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active

OBSERVERSIGNATUREYN

CC ID: 178631

Seq. Order:	46
Data Storage Type:	CHAR
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active

NOTES

CC ID: 178632

Seq. Order:	47
Data Storage Type:	VARCHAR
Max Length:	2500
Required:	No
Primary Key:	No
Status:	Active

OBSLASTUPDATE

CC ID: 178633

Seq. Order:	48
Data Storage Type:	DATETIME
Max Length:	8
Required:	No
Primary Key:	No
Status:	Active

OBSLASTUPDATEBY

CC ID: 178634

Seq. Order:	49
Data Storage Type:	INT
Max Length:	4
Required:	No
Primary Key:	No
Precision:	10
Status:	Active

LASTUPDATE

CC ID: 178635

Seq. Order:	50
Data Storage Type:	DATETIME
Max Length:	8
Required:	No
Primary Key:	No
Status:	Active

LASTUPDATEBY

CC ID: 178636

Seq. Order:	51
Data Storage Type:	INT
Max Length:	4
Required:	No
Primary Key:	No
Precision:	10
Status:	Active

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

Summary

Entity Information

Child Items

Contact Information

Item Identification

Data Attributes

Attribute Summary

Attribute Details

ID

TRIPID

GEARINVENTORY

GEARINVENTORY2

PLACEMENTCHECKLIST

PLACEMENTCHECKLIST2

ECONOMICDATA

ECONOMICDATA2

WCPFC

WCPFC2

TRIPSPECIFICATIONS

TRIPSPECIFICATIONS2

SETANDHAUL

SETANDHAUL2

SEABIRDMITIGATION

SEABIRDMITIGATION2

GEARCONFIGURATION

GEARCONFIGURATION2

PSEVENTLOG

PSEVENTLOG2

CATCHEVENTLOG

CATCHEVENTLOG2

SEATURTLEFORM

SEATURTLEFORM2

MMAMMALFORM

MMAMMALFORM2

SEABIRDFORM

SEABIRDFORM2

PHOTOLOG

PHOTOLOG2

SPECIMENLOG

SPECIMENLOG2

TAGEVENT

TAGEVENT2

SKETCH

SKETCH2

DQSHEET

DQSHEET2

REPORTSFILED

REPORTSFILED2

PSPAPERWORK

PSPAPERWORK2

GENERALCOMMENTS

GENERALCOMMENTS2

FINALIZEDYN

OBSERVERSIGNATUREYN

NOTES

OBSLASTUPDATE

OBSLASTUPDATEBY

LASTUPDATE

LASTUPDATEBY

Catalog Details