Table name: Vessdoc (Registered vessel documentation) Updated Oct 2009 Column Type Name NICAR Length 1. char Vessel ID vessel_id 10 2. char Vessel database key vessel 10 3. char name of vessel vname 33 4. char call sign call_sign 8 5. char official number officialno 10 6. char IMO number imo_num 30 7. char Hull number hull_num 30 8. char Hull Identification Number hull_id 30 9. char Vessel service type servtype 30 10. char flag vflag 2 11. char self propelled indicator selfprop 1 12. char registered gross tons grosstons 7 13. char registered net tons net_tons 7 14. char registered length length 7 15. char registered breadth breadth 6 16. char registered depth depth 6 17. char ITC gross tons itc_gton 7 18. char ITC net tons itc_nton 7 19. char Dead Weight tons dw_ton 7 20. char Dead weight ton measure unit dw_tmu 40 21. char ITC length itc_length 7 22. char ITC breadth itc_bredth 6 23. char ITC depth itc_depth 6 24. char Measuring org. name meas_org 50 25. char hailing port hailport 50 26. char hailing port state port_state 2 27. char hailing port province port_prov 50 28. char trade indicator - coastwise unrestricted coastwise 1 29. char trade indicator - limited coastwise bowaters only t_bow 1 30. char trade indicator - limited coastwise restricted rest_cw 1 31. char trade indicator - limited coastwise oil spill response only t_oilspill 1 32. char trade indicator - limited coastwise under charter to to citizen t_citizen 1 33. char trade indicator - limited coastwise trade fish products only t_fishprod 1 34. char trade indicator - fishery fishery 1 35. char trade indicator - limited fishery t_fish 1 36. char trade indicator - recreation recreation 1 37. char trade indicator - limited recreation Great Lakes use only t_gl 1 38. char trade indicator - registry registry 1 39. char trade indicator - limited registry cross border financing t_finance 1 40. char trade indicator - limited registry no foreign voyage by sea t_foreign 1 41. char trade indicator - limited registry trade with Canada only t_ca 1 42. char trade indicator - Great Lakes greatlakes 1 43. char Vessel complete build city vbld_ct 50 44. char vessel complete build state vbld_st 2 45. char vessel complete build province vbld_prov 50 46. char vessel complete build country vbld_cnty 64 47. char vessel build year vbld_yr 4 48. char vessel hull build city hbld_ct 50 49. char vessel hull build state hbld_st 2 50. char vessel hull build province hbld_prov 50 51. char vessel hull build country hbld_cnty 64 52. char party identification number party_id 10 53. char organization/company name company 80 54. char organization type Com_type 30 55. char person first name firstname 30 56. char person last name lastname 30 57. char person name suffix suffix 10 58. char street address line 1 address1 254 59. char street address line 2 address2 254 60. char street address line 3 address3 254 61. char street address line 4 address4 254 62. char city city 30 63. char state state 2 64. char province prov 30 65. char country cnty 64 66. char postal code zip 30 67. char main HP ahead hp_head 7 68. char main HP astern hp_astern 7 69. char propulsion type prop 30 70. char hull material hullmat 30 71. char ship yard yard 50 72. char ship builder builder 80 73. char hull configuration hull_cfg 30 74. char hull shape hull_shape 30 75. char COD status cod_stat 30 76. char COD issue date cod_issue 10 77. date NICAR-created COD issue date cod_issdt 8 78. char COD expire date cod_expr 10 79. date NICAR-created COD expire date cod_expdt 8 80. char filler filler 1