Slide Menu
InPort and its associated services will be under maintenance and unavailable for the deployment of InPort Release 5.2.3. Downtime Schedule Tuesday, November 29, 2022 12:00pm - 1:30pm Eastern / 10:00am - 11:30pm Pacific / 7:00am - 8:30pm Hawaii Impacted Areas - InPort Website: https://www.fisheries.noaa.gov/inport - InPort WAF: https://www.fisheries.noaa.gov/inportserve/waf What's...
View All
Search Help Show/Hide Menu

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