Table: PostCruise
Entity (ENT) | Pacific Islands Regional Office (PIRO)GUID: gov.noaa.nmfs.inport:21892 | Updated: August 9, 2022 | Published / External
Item Identification
Title: | Table: PostCruise |
---|---|
Short Name: | PostCruise |
Status: | In Work |
Data Attributes
Attribute Summary
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 |