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

Entity (ENT)  |  Pacific Islands Regional Office (PIRO)
GUID: gov.noaa.nmfs.inport:21892  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Data Attributes
Catalog Details

Summary

Entity Information

Data Attribute / Type Description
POSTCRUISEID
INT
TRIPID
INT
VESSELINFO
VARCHAR
COLLECTSPECIMENSYN
CHAR
COLLECTSPECIMENS_WHYNO
VARCHAR
GEARPROBLEMSYN
CHAR
GEARPROBLEMS_WHYYES
VARCHAR
OTHERPERFORMDUTIESYN
CHAR
OTHERPERFORMDUTIES_WHYYES
VARCHAR
SEEHOOKSYN
CHAR
SEEHOOKS_WHYNO
VARCHAR
HOWOBTAINHOOKCOUNTID
INT
HOWOBTAINHOOKCOUNT_WHYOTHER
VARCHAR
DATAGIVENTOCAPTAINYN
CHAR
DATAGIVENTOCAPTAIN_WHYYES
VARCHAR
DATAFROMCAPTAINYN
CHAR
DATAFROMCAPTAIN_WHYYES
VARCHAR
TURTLEINTERACTIONYN
CHAR
TURTLEINTERACTION_WHYYES
VARCHAR
ADEQUATEMEALSYN
CHAR
ADEQUATEMEALS_WHYNO
VARCHAR
DEHOOKBYCATCHYN
CHAR
DEHOOKBYCATCH_WHYYES
VARCHAR
ANYTIMENOTONDECKYN
CHAR
ANYTIMENOTONDECK_WHYYES
VARCHAR
WEARPFDYN
CHAR
WEARPFD_WHYNO
VARCHAR
TRYONSURVIVALSUITYN
CHAR
TRYONSURVIVALSUIT_WHYNO
VARCHAR
CHECKTURTLEPOLEYN
CHAR
CHECKTURTLEPOLE_WHYNO
VARCHAR
CHECKGEARYN
CHAR
CHECKGEAR_WHYNO
VARCHAR
SEABIRDINTERACTIONYN
CHAR
CREWPREVENTIDYN
CHAR
ENCOURAGEDTOSLEEPYN
CHAR
NOWHEELWATCHESYN
CHAR
SAFETYCOMPROMISEDYN
CHAR
PHYSICALINJURIESYN
CHAR
FLOATLINESLESSTHAN20YN
CHAR
BASKETSLESSTHAN15YN
CHAR
MARINECASUALTYYN
CHAR
SAFETYDRILLSYN
CHAR
MINIMMERSIONSUITSYN
CHAR
SEABIRDMITIGATIONYN
CHAR
SAFETYEQUIPMOVEDYN
CHAR
VESSELACCESSYN
CHAR
PAPERCAPTAINYN
CHAR
HARRASSMENTYN
CHAR
MARPOLYN
CHAR
TRANSFERCREWYN
CHAR
BEDBUGSYN
CHAR
SHARKFINSREMOVEDYN
CHAR
TUNAMEASUREID
INT
SHARKMEASUREID
INT
SHARKSTUNASMEASUREID
INT
FISHTRANSFERYN
CHAR
RINSECAMERAYN
CHAR
TESTEPIRBYN
CHAR
CHECKSATPHONEYN
CHAR
SIGHTMARINEMAMMALSYN
CHAR
LOBSTERPHYLLOSOMA
INT
IMPORTANTLESSON
VARCHAR
FIRSTTRIP_1
INT
FIRSTTRIP_1TEXT
VARCHAR
FIRSTTRIP_11
INT
FIRSTTRIP_1TEXT1
VARCHAR
FIRSTTRIP_2
CHAR
FIRSTTRIP_2TEXT
VARCHAR
FIRSTTRIP_3
INT
FIRSTTRIP_3TEXT
VARCHAR
FIRSTTRIP_4
CHAR
FIRSTTRIP_4TEXT
VARCHAR
FIRSTTRIP_5
INT
FIRSTTRIP_5TEXT
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: PostCruise
Short Name: PostCruise
Status: In Work

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
67
 Primary Key POSTCRUISEID INT
67
 TRIPID INT
67
 VESSELINFO VARCHAR
67
 COLLECTSPECIMENSYN CHAR
67
 COLLECTSPECIMENS_WHYNO VARCHAR
67
 GEARPROBLEMSYN CHAR
67
 GEARPROBLEMS_WHYYES VARCHAR
67
 OTHERPERFORMDUTIESYN CHAR
67
 OTHERPERFORMDUTIES_WHYYES VARCHAR
67
 SEEHOOKSYN CHAR
67
 SEEHOOKS_WHYNO VARCHAR
67
 HOWOBTAINHOOKCOUNTID INT
67
 HOWOBTAINHOOKCOUNT_WHYOTHER VARCHAR
67
 DATAGIVENTOCAPTAINYN CHAR
67
 DATAGIVENTOCAPTAIN_WHYYES VARCHAR
67
 DATAFROMCAPTAINYN CHAR
67
 DATAFROMCAPTAIN_WHYYES VARCHAR
67
 TURTLEINTERACTIONYN CHAR
67
 TURTLEINTERACTION_WHYYES VARCHAR
67
 ADEQUATEMEALSYN CHAR
67
 ADEQUATEMEALS_WHYNO VARCHAR
67
 DEHOOKBYCATCHYN CHAR
67
 DEHOOKBYCATCH_WHYYES VARCHAR
67
 ANYTIMENOTONDECKYN CHAR
67
 ANYTIMENOTONDECK_WHYYES VARCHAR
67
 WEARPFDYN CHAR
67
 WEARPFD_WHYNO VARCHAR
67
 TRYONSURVIVALSUITYN CHAR
67
 TRYONSURVIVALSUIT_WHYNO VARCHAR
67
 CHECKTURTLEPOLEYN CHAR
67
 CHECKTURTLEPOLE_WHYNO VARCHAR
67
 CHECKGEARYN CHAR
67
 CHECKGEAR_WHYNO VARCHAR
67
 SEABIRDINTERACTIONYN CHAR
67
 CREWPREVENTIDYN CHAR
67
 ENCOURAGEDTOSLEEPYN CHAR
67
 NOWHEELWATCHESYN CHAR
67
 SAFETYCOMPROMISEDYN CHAR
67
 PHYSICALINJURIESYN CHAR
67
 FLOATLINESLESSTHAN20YN CHAR
67
 BASKETSLESSTHAN15YN CHAR
67
 MARINECASUALTYYN CHAR
67
 SAFETYDRILLSYN CHAR
67
 MINIMMERSIONSUITSYN CHAR
67
 SEABIRDMITIGATIONYN CHAR
67
 SAFETYEQUIPMOVEDYN CHAR
67
 VESSELACCESSYN CHAR
67
 PAPERCAPTAINYN CHAR
67
 HARRASSMENTYN CHAR
67
 MARPOLYN CHAR
67
 TRANSFERCREWYN CHAR
67
 BEDBUGSYN CHAR
67
 SHARKFINSREMOVEDYN CHAR
67
 TUNAMEASUREID INT
67
 SHARKMEASUREID INT
67
 SHARKSTUNASMEASUREID INT
67
 FISHTRANSFERYN CHAR
67
 RINSECAMERAYN CHAR
67
 TESTEPIRBYN CHAR
67
 CHECKSATPHONEYN CHAR
67
 SIGHTMARINEMAMMALSYN CHAR
67
 LOBSTERPHYLLOSOMA INT
67
 IMPORTANTLESSON VARCHAR
67
 FIRSTTRIP_1 INT
67
 FIRSTTRIP_1TEXT VARCHAR
67
 FIRSTTRIP_11 INT
67
 FIRSTTRIP_1TEXT1 VARCHAR
67
 FIRSTTRIP_2 CHAR
67
 FIRSTTRIP_2TEXT VARCHAR
67
 FIRSTTRIP_3 INT
67
 FIRSTTRIP_3TEXT VARCHAR
67
 FIRSTTRIP_4 CHAR
67
 FIRSTTRIP_4TEXT VARCHAR
67
 FIRSTTRIP_5 INT
67
 FIRSTTRIP_5TEXT VARCHAR
67
 LASTUPDATE DATETIME
67
 LASTUPDATEBY INT

Attribute Details

POSTCRUISEID

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

TRIPID

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

VESSELINFO

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

COLLECTSPECIMENSYN

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

COLLECTSPECIMENS_WHYNO

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

GEARPROBLEMSYN

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

GEARPROBLEMS_WHYYES

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

OTHERPERFORMDUTIESYN

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

OTHERPERFORMDUTIES_WHYYES

CC ID: 178787
Seq. Order: 9
Data Storage Type: VARCHAR
Max Length: 500
Required: No
Primary Key: No
Status: Active

SEEHOOKSYN

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

SEEHOOKS_WHYNO

CC ID: 178789
Seq. Order: 11
Data Storage Type: VARCHAR
Max Length: 500
Required: No
Primary Key: No
Status: Active

HOWOBTAINHOOKCOUNTID

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

HOWOBTAINHOOKCOUNT_WHYOTHER

CC ID: 178791
Seq. Order: 13
Data Storage Type: VARCHAR
Max Length: 500
Required: No
Primary Key: No
Status: Active

DATAGIVENTOCAPTAINYN

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

DATAGIVENTOCAPTAIN_WHYYES

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

DATAFROMCAPTAINYN

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

DATAFROMCAPTAIN_WHYYES

CC ID: 178795
Seq. Order: 17
Data Storage Type: VARCHAR
Max Length: 500
Required: No
Primary Key: No
Status: Active

TURTLEINTERACTIONYN

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

TURTLEINTERACTION_WHYYES

CC ID: 178797
Seq. Order: 19
Data Storage Type: VARCHAR
Max Length: 500
Required: No
Primary Key: No
Status: Active

ADEQUATEMEALSYN

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

ADEQUATEMEALS_WHYNO

CC ID: 178799
Seq. Order: 21
Data Storage Type: VARCHAR
Max Length: 500
Required: No
Primary Key: No
Status: Active

DEHOOKBYCATCHYN

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

DEHOOKBYCATCH_WHYYES

CC ID: 178801
Seq. Order: 23
Data Storage Type: VARCHAR
Max Length: 500
Required: No
Primary Key: No
Status: Active

ANYTIMENOTONDECKYN

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

ANYTIMENOTONDECK_WHYYES

CC ID: 178803
Seq. Order: 25
Data Storage Type: VARCHAR
Max Length: 500
Required: No
Primary Key: No
Status: Active

WEARPFDYN

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

WEARPFD_WHYNO

CC ID: 178805
Seq. Order: 27
Data Storage Type: VARCHAR
Max Length: 500
Required: No
Primary Key: No
Status: Active

TRYONSURVIVALSUITYN

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

TRYONSURVIVALSUIT_WHYNO

CC ID: 178807
Seq. Order: 29
Data Storage Type: VARCHAR
Max Length: 500
Required: No
Primary Key: No
Status: Active

CHECKTURTLEPOLEYN

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

CHECKTURTLEPOLE_WHYNO

CC ID: 178809
Seq. Order: 31
Data Storage Type: VARCHAR
Max Length: 500
Required: No
Primary Key: No
Status: Active

CHECKGEARYN

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

CHECKGEAR_WHYNO

CC ID: 178811
Seq. Order: 33
Data Storage Type: VARCHAR
Max Length: 500
Required: No
Primary Key: No
Status: Active

SEABIRDINTERACTIONYN

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

CREWPREVENTIDYN

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

ENCOURAGEDTOSLEEPYN

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

NOWHEELWATCHESYN

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

SAFETYCOMPROMISEDYN

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

PHYSICALINJURIESYN

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

FLOATLINESLESSTHAN20YN

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

BASKETSLESSTHAN15YN

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

MARINECASUALTYYN

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

SAFETYDRILLSYN

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

MINIMMERSIONSUITSYN

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

SEABIRDMITIGATIONYN

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

SAFETYEQUIPMOVEDYN

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

VESSELACCESSYN

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

PAPERCAPTAINYN

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

HARRASSMENTYN

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

MARPOLYN

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

TRANSFERCREWYN

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

BEDBUGSYN

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

SHARKFINSREMOVEDYN

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

TUNAMEASUREID

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

SHARKMEASUREID

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

SHARKSTUNASMEASUREID

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

FISHTRANSFERYN

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

RINSECAMERAYN

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

TESTEPIRBYN

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

CHECKSATPHONEYN

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

SIGHTMARINEMAMMALSYN

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

LOBSTERPHYLLOSOMA

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

IMPORTANTLESSON

CC ID: 178841
Seq. Order: 63
Data Storage Type: VARCHAR
Max Length: 1500
Required: No
Primary Key: No
Status: Active

FIRSTTRIP_1

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

FIRSTTRIP_1TEXT

CC ID: 178843
Seq. Order: 65
Data Storage Type: VARCHAR
Max Length: 1500
Required: No
Primary Key: No
Status: Active

FIRSTTRIP_11

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

FIRSTTRIP_1TEXT1

CC ID: 178845
Seq. Order: 67
Data Storage Type: VARCHAR
Max Length: 1500
Required: No
Primary Key: No
Status: Active

FIRSTTRIP_2

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

FIRSTTRIP_2TEXT

CC ID: 178847
Seq. Order: 69
Data Storage Type: VARCHAR
Max Length: 1500
Required: No
Primary Key: No
Status: Active

FIRSTTRIP_3

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

FIRSTTRIP_3TEXT

CC ID: 178849
Seq. Order: 71
Data Storage Type: VARCHAR
Max Length: 1500
Required: No
Primary Key: No
Status: Active

FIRSTTRIP_4

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

FIRSTTRIP_4TEXT

CC ID: 178851
Seq. Order: 73
Data Storage Type: VARCHAR
Max Length: 1500
Required: No
Primary Key: No
Status: Active

FIRSTTRIP_5

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

FIRSTTRIP_5TEXT

CC ID: 178853
Seq. Order: 75
Data Storage Type: VARCHAR
Max Length: 1500
Required: No
Primary Key: No
Status: Active

LASTUPDATE

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

LASTUPDATEBY

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

Catalog Details

Catalog Item ID: 21892
GUID: gov.noaa.nmfs.inport:21892
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