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 
Summary
Item Identification
Data Attributes
Catalog Details

Summary

Entity Information

Data Attribute / Type Description
TRIPID
INT
TRIPNUM
NVARCHAR
VESSELNAME
VARCHAR
PERMITNUM
VARCHAR
OPERATOR
VARCHAR
OPERATORID
INT
SATPHONENUM
VARCHAR
DEPARTUREDATE
DATE
DEPARTUREPORTID
INT
ARRIVALDATE
DATE
ARRIVALPORTID
INT
TRIPTYPE
CHAR
EXPERIMENTALTRIP
CHAR
EXPERIMENTALTRIPTYPEID
INT
TRIPSTATUSID
INT
INITIALDEBRIEFERID
INT
OKTODELETEPHOTOSYN
CHAR
VESSELARRIVALEMAILSENT
DATETIME
VESSELARRIVALEMAILSENTBY
INT
NOTES
VARCHAR
LASTUPDATE
DATETIME
LASTUPDATEBY
INT

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (PIRO) for inquiries on this record.

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