Table: GreenPencil
Entity (ENT) | Pacific Islands Regional Office (PIRO)GUID: gov.noaa.nmfs.inport:21858 | Updated: August 9, 2022 | Published / External
Item Identification
| Title: | Table: GreenPencil |
|---|---|
| Short Name: | GreenPencil |
| Status: | In Work |
Data Attributes
Attribute Summary
|
|
Name | Type | Description |
|---|---|---|---|---|
|
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 |
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 Details
| 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 |