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

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

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