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

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

Summary

Entity Information

Data Attribute / Type Description
ID
INT
TRIPID
INT
GEARINVENTORY
VARCHAR
PLACEMENTCHECKLIST
VARCHAR
ECONOMICDATA
VARCHAR
WCPFC
VARCHAR
TRIPSPECIFICATIONS
VARCHAR
SETANDHAUL
VARCHAR
SEABIRDMITIGATION
VARCHAR
GEARCONFIGURATION
VARCHAR
PSEVENTLOG
VARCHAR
CATCHEVENTLOG
VARCHAR
SEATURTLEFORM
VARCHAR
MMAMMALFORM
VARCHAR
SEABIRDFORM
VARCHAR
PHOTOLOG
VARCHAR
SPECIMENLOG
VARCHAR
TAGEVENT
VARCHAR
SKETCH
VARCHAR
DQSHEET
VARCHAR
GENERALCOMMENTS
VARCHAR
FULLREADBACKYN
CHAR
FINALIZEDYN
CHAR
LASTUPDATE
DATETIME
LASTUPDATEBY
INT

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: RedPencil
Short Name: RedPencil
Status: In Work

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
67
 Primary Key ID INT
67
 TRIPID INT
67
 GEARINVENTORY VARCHAR
67
 PLACEMENTCHECKLIST VARCHAR
67
 ECONOMICDATA VARCHAR
67
 WCPFC VARCHAR
67
 TRIPSPECIFICATIONS VARCHAR
67
 SETANDHAUL VARCHAR
67
 SEABIRDMITIGATION VARCHAR
67
 GEARCONFIGURATION VARCHAR
67
 PSEVENTLOG VARCHAR
67
 CATCHEVENTLOG VARCHAR
67
 SEATURTLEFORM VARCHAR
67
 MMAMMALFORM VARCHAR
67
 SEABIRDFORM VARCHAR
67
 PHOTOLOG VARCHAR
67
 SPECIMENLOG VARCHAR
67
 TAGEVENT VARCHAR
67
 SKETCH VARCHAR
67
 DQSHEET VARCHAR
67
 GENERALCOMMENTS VARCHAR
67
 FULLREADBACKYN CHAR
67
 FINALIZEDYN CHAR
67
 LASTUPDATE DATETIME
67
 LASTUPDATEBY INT

Attribute Details

ID

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

TRIPID

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

GEARINVENTORY

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

PLACEMENTCHECKLIST

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

ECONOMICDATA

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

WCPFC

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

TRIPSPECIFICATIONS

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

SETANDHAUL

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

SEABIRDMITIGATION

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

GEARCONFIGURATION

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

PSEVENTLOG

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

CATCHEVENTLOG

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

SEATURTLEFORM

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

MMAMMALFORM

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

SEABIRDFORM

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

PHOTOLOG

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

SPECIMENLOG

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

TAGEVENT

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

SKETCH

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

DQSHEET

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

GENERALCOMMENTS

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

FULLREADBACKYN

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

FINALIZEDYN

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

LASTUPDATE

CC ID: 178879
Seq. Order: 24
Data Storage Type: DATETIME
Max Length: 8
Required: No
Primary Key: No
Status: Active

LASTUPDATEBY

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

Catalog Details

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