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... > Hawaii Bottomfish Observer Program > Bottomfish Observer Database - Legacy >

Table: tblTripLog

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

Item Identification

Title: Table: tblTripLog
Short Name: Trip Log
Status: In Work

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
67
 TRIPID AUTONUMBER
67
 OBSERVERNUM TEXT
67
 VESSELNAME TEXT
67
 VESSELDOCNUM TEXT
67
 Primary Key TRIPNUM TEXT
67
 DEPARTDATE DATE/TIME
67
 DEPARTTIME DATE/TIME
67
 PORTDEPART TEXT
67
 PORTSTOP1DATE DATE/TIME
67
 PORTSTOP1TIME DATE/TIME
67
 CRUISERES1DATE DATE/TIME
67
 CRUISERES1TIME DATE/TIME
67
 PORTSTOP2DATE DATE/TIME
67
 PORTSTOP2TIME DATE/TIME
67
 CRUISE2DATE DATE/TIME
67
 CRUISERES2TIME DATE/TIME
67
 ARRIVALDATE DATE/TIME
67
 ARRIVALTIME DATE/TIME
67
 PORTARRIVAL TEXT
67
 OPERATORNAME TEXT

Attribute Details

TRIPID

CC ID: 179316
Seq. Order: 1
Data Storage Type: AUTONUMBER
Max Length: 4
Required: No
Primary Key: No
Status: Active

OBSERVERNUM

CC ID: 179317
Seq. Order: 2
Data Storage Type: TEXT
Max Length: 4
Required: No
Primary Key: No
Status: Active

VESSELNAME

CC ID: 179318
Seq. Order: 3
Data Storage Type: TEXT
Max Length: 50
Required: No
Primary Key: No
Status: Active

VESSELDOCNUM

CC ID: 179319
Seq. Order: 4
Data Storage Type: TEXT
Max Length: 15
Required: No
Primary Key: No
Status: Active

TRIPNUM

CC ID: 179320
Seq. Order: 5
Data Storage Type: TEXT
Max Length: 6
Required: Yes
Primary Key: Yes
Status: Active

DEPARTDATE

CC ID: 179321
Seq. Order: 6
Data Storage Type: DATE/TIME
Max Length: 8
Required: No
Primary Key: No
Status: Active

DEPARTTIME

CC ID: 179322
Seq. Order: 7
Data Storage Type: DATE/TIME
Max Length: 8
Required: No
Primary Key: No
Status: Active

PORTDEPART

CC ID: 179323
Seq. Order: 8
Data Storage Type: TEXT
Max Length: 50
Required: No
Primary Key: No
Status: Active

PORTSTOP1DATE

CC ID: 179324
Seq. Order: 9
Data Storage Type: DATE/TIME
Max Length: 8
Required: No
Primary Key: No
Status: Active

PORTSTOP1TIME

CC ID: 179325
Seq. Order: 10
Data Storage Type: DATE/TIME
Max Length: 8
Required: No
Primary Key: No
Status: Active

CRUISERES1DATE

CC ID: 179326
Seq. Order: 11
Data Storage Type: DATE/TIME
Max Length: 8
Required: No
Primary Key: No
Status: Active

CRUISERES1TIME

CC ID: 179327
Seq. Order: 12
Data Storage Type: DATE/TIME
Max Length: 8
Required: No
Primary Key: No
Status: Active

PORTSTOP2DATE

CC ID: 179328
Seq. Order: 13
Data Storage Type: DATE/TIME
Max Length: 8
Required: No
Primary Key: No
Status: Active

PORTSTOP2TIME

CC ID: 179329
Seq. Order: 14
Data Storage Type: DATE/TIME
Max Length: 8
Required: No
Primary Key: No
Status: Active

CRUISE2DATE

CC ID: 179330
Seq. Order: 15
Data Storage Type: DATE/TIME
Max Length: 8
Required: No
Primary Key: No
Status: Active

CRUISERES2TIME

CC ID: 179331
Seq. Order: 16
Data Storage Type: DATE/TIME
Max Length: 8
Required: No
Primary Key: No
Status: Active

ARRIVALDATE

CC ID: 179332
Seq. Order: 17
Data Storage Type: DATE/TIME
Max Length: 8
Required: No
Primary Key: No
Status: Active

ARRIVALTIME

CC ID: 179333
Seq. Order: 18
Data Storage Type: DATE/TIME
Max Length: 8
Required: No
Primary Key: No
Status: Active

PORTARRIVAL

CC ID: 179334
Seq. Order: 19
Data Storage Type: TEXT
Max Length: 50
Required: No
Primary Key: No
Status: Active

OPERATORNAME

CC ID: 179335
Seq. Order: 20
Data Storage Type: TEXT
Max Length: 50
Required: No
Primary Key: No
Status: Active

Catalog Details

Catalog Item ID: 21942
GUID: gov.noaa.nmfs.inport:21942
Metadata Record Created By: Eric Forney
Metadata Record Created: 2014-07-14 20:15+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