Slide Menu
System Maintenance Notice, Monday, December 5, 2022 @ 1pm-5pm Eastern. The Operations Team will be performing system maintenance. During this scheduled downtime, InPort will not be available.
View All
Search Help Show/Hide Menu

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