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

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

Item Identification

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

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
67
 Primary Key TRIPID INT
67
 TRIPNUM NVARCHAR
67
 VESSELNAME VARCHAR
67
 PERMITNUM VARCHAR
67
 OPERATOR VARCHAR
67
 OPERATORID INT
67
 SATPHONENUM VARCHAR
67
 DEPARTUREDATE DATE
67
 DEPARTUREPORTID INT
67
 ARRIVALDATE DATE
67
 ARRIVALPORTID INT
67
 TRIPTYPE CHAR
67
 EXPERIMENTALTRIP CHAR
67
 EXPERIMENTALTRIPTYPEID INT
67
 TRIPSTATUSID INT
67
 INITIALDEBRIEFERID INT
67
 OKTODELETEPHOTOSYN CHAR
67
 VESSELARRIVALEMAILSENT DATETIME
67
 VESSELARRIVALEMAILSENTBY INT
67
 NOTES VARCHAR
67
 LASTUPDATE DATETIME
67
 LASTUPDATEBY INT

Attribute Details

TRIPID

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

TRIPNUM

CC ID: 178958
Seq. Order: 2
Data Storage Type: NVARCHAR
Max Length: 7
Required: No
Primary Key: No
Status: Active

VESSELNAME

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

PERMITNUM

CC ID: 178960
Seq. Order: 4
Data Storage Type: VARCHAR
Max Length: 20
Required: No
Primary Key: No
Status: Active

OPERATOR

CC ID: 178961
Seq. Order: 5
Data Storage Type: VARCHAR
Max Length: 50
Required: No
Primary Key: No
Status: Active

OPERATORID

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

SATPHONENUM

CC ID: 178963
Seq. Order: 7
Data Storage Type: VARCHAR
Max Length: 15
Required: No
Primary Key: No
Status: Active

DEPARTUREDATE

CC ID: 178964
Seq. Order: 8
Data Storage Type: DATE
Max Length: 3
Required: No
Primary Key: No
Status: Active

DEPARTUREPORTID

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

ARRIVALDATE

CC ID: 178966
Seq. Order: 10
Data Storage Type: DATE
Max Length: 3
Required: No
Primary Key: No
Status: Active

ARRIVALPORTID

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

TRIPTYPE

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

EXPERIMENTALTRIP

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

EXPERIMENTALTRIPTYPEID

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

TRIPSTATUSID

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

INITIALDEBRIEFERID

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

OKTODELETEPHOTOSYN

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

VESSELARRIVALEMAILSENT

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

VESSELARRIVALEMAILSENTBY

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

NOTES

CC ID: 178976
Seq. Order: 20
Data Storage Type: VARCHAR
Max Length: 2500
Required: No
Primary Key: No
Status: Active

LASTUPDATE

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

LASTUPDATEBY

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

Catalog Details

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