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
![]() |
![]() |
Name | Type | Description |
---|---|---|---|---|
67
|
TRIPID | AUTONUMBER | ||
67
|
OBSERVERNUM | TEXT | ||
67
|
VESSELNAME | TEXT | ||
67
|
VESSELDOCNUM | TEXT | ||
67
|
![]() |
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 |