NDC Banner

NDC Home
Data
Back

U.S. Waterway Data Title
U.S. Coast Guard Vessel Identification File
Data Dictionary

File Name: \uscg\data\vidt.txt or \uscg\dbf\vidt.xls



                                  U.S. COAST GUARD VESSEL FILE

                               (VESSEL IDENTIFICATION TABLE (VIDT))



                                  RECORD LAYOUT/DATA DICTIONARY 



  Column No       Type       Column_name                Size        

 ----------       -----      -----------                ----        

   1             char        gk_d_vessel                  28        

   2             char        vissel_id                    15        

   3             varchar     vessel_name                  50        

   4             char        managing_owner_id            28        

   5             varchar     managing_owner              120        

   6             varchar     gross_tons                    8        

   7             varchar     net_ton                       8        

   8             varchar     length                        7        

   9             varchar     breadth                       7        

  10             varchar     depth                         7        

  11             varchar    itc_breadth                    7        

  12             varchar    itc_depth                      7        

  13             varchar    itc_gross_ton                  8        

  14             varchar    itc_length                     7        

  15             varchar    ict_net_ton                    8        

  16             varchar    draft_design                   8        

  17             char       draft_design_units             2        

  18             char       dead_weight_ton                8        

  19             char       deadweighttonnage_units        2        

  20             char       flag_abbr                      2        

  21             varchar    hailing_port                  50        

  22             varchar    hailing_port_state             2        

  23             varchar    hailing_port_province         50        

  24             varchar    route_type                    50        

  25             varchar    classification_society        80        

  26             varchar    cargo_authorization_type      30        

  27             char       documented_ind                 1        

  28             varchar    documented_status_type        30        

  29             char       inspected_ind                  1        

  30             varchar    inspected_desc                30        

  31             char       state_vessel_ind               1        

  32             varchar    state_vessel_desc             30        

  33             char       lloyds_ind                     1        

  34             varchar    lloyds_desc                   30        

  35             char       solas_ind                      1        

  36             varchar    solas_desc                    30        

  37             varchar    insp_subchapter_type         255        

  38             varchar    vessel_class                  50        

  39             varchar    vessel_type                   50        

  40             varchar    vessel_subtype                50        

  41             varchar    vessel_service                30        

  42             varchar    max_passengers_allowed         6        

  43             varchar    max_crew                       6        

  44             varchar    self_propelled_ind             1        

  45             varchar    propulsion_type               30        

  46             varchar    hull_material                 30        

  47             varchar    hull_design_type              30        

  48             varchar    hull_double_bottom_type       30        

  49             varchar    hull_double_side_type         30        

  50             varchar    call_sign                      8        

  51             varchar    official_number               10 
  
  52*            varchar    primary_vin                   30         

  53             varchar    hull_number                   30        

  54             varchar    rbs_hull_number               30        

  55             varchar    imo_number                    30        

  56             varchar    vessel_age                     4        

  57             varchar    build_shipyard                50        

  58             char       build_year                     4        

  59             varchar    hull_build_party_name         80        

  60             varchar    completed_by_party_name       80        

  61             varchar    horsepower_ahead               5        

  62             varchar    horsepower_astern             5         

  63             varchar    forebody_type_desc            30        

  63             varchar    hull_configuration            30        

  65             varchar    hull_shapee                   30        

  66             char       filler                         1 
  
  *new field added October 2007       


Top

Contact for Additional Information:
Commandant (CG-5453)
U.S. Coast Guard
2100 Second Street, S.W.
Washington, DC 20593-7581
Point of Contact: POC 202-372-1282