Attachment_1_-_VIS_Data_Dictionary.pdf

A C D E F G H I

Table_Name Field_Name Screen Display Name DataType Length Null or

Allows Null Description Xtype Core Reg_ID Not Displayed int 4 Not Null System Generated ID Primary key 56 Core Reg_State Registration Authority???? char 2 Not Null State of Registration (postal Code) 175 Core Reg_Num Not Displayed varchar 15 Not Null Registration Number as supplied by the state 167 Core Reg_Standard Registration Number varchar 15 Allows Null Standardized Registration Number 167 Core Hull_ID Hull ID Number varchar 20 Allows Null Standardized Hull ID having removed country codes & extraneous characters 167 Core Make Vessel Manufacturer / Make varchar 25 Allows Null Clean & Standardized make/brand of the boat 167 Core Model_Year Model Year / Year Built int 4 Allows Null Boat Model Year 56 Core Length_IN Length in Ft. / In int 4 Allows Null Boat Length in total Inches 56 Core Drive_Type Engine Drive Type varchar 20 Allows Null Drive Type (Prop/Motor/Sail) 167 Core Hull_Type Hull Material char 1 Allows Null Boat's Hull Material (See codes) 175 Core Fuel_Type Fuel Type varchar 1 Allows Null Fuel Type as recorded by the State 167 Core Sboat_Type Vessel Type varchar 20 Allows Null Boat Type as recorded by the State (e.g. Cabin, Pontoon, Runabout) 167 Core Use_Type Primary Use varchar 1 Allows Null Registered Use 167 Core Boat_Name Results for Vessel varchar 20 Allows Null Name of Vessel 167 Core Reg_Date Registration Certificate Effective Date datetime 8 Allows Null Latest Registration Date 61 Core Title_Date Effective Title Date datetime 8 Allows Null Latest Title Date 61 Core Title_Num Title Number varchar 20 Allows Null Title Number 167 Core Expired Registration Status bit 1 Allows Null Flag indicating whether registration is current of expired 104 Core CG_Num Coast Guard Documentation Number varchar 15 Allows Null Coast Guard Documentation Number 167 Core Last_Updated Bottom Of Results Screen datetime 8 Allows Null Date record was last updated by Info Link 61 Core Orig_Hull_ID Not Displayed varchar 15 Allows Null Hull Identification number as recorded by the State 167 Core Orig_Make Not Displayed varchar 25 Allows Null Original Make provided by state before Info Link cleanup 167 Core Orig_Model Not Displayed varchar 25 Allows Null Original Model provided by state before Info Link cleanup 167 Core Orig_Year Not Displayed smallint 2 Allows Null Original Year provided by state before Info Link cleanup 52 Core Orig_Prop Not Displayed varchar 20 Allows Null Original Prop provided by state before Info Link cleanup 167 Core Orig_Hull_Type Not Displayed char 20 Allows Null Original Hull Type provided by state before Info Link cleanup 175 Core Stol_Date Date Reported Stolen datetime 8 Allows Null Date reported Stolen 61 Core Recov_Date Date Recovered datetime 8 Allows Null Date Recovered 61 Core Lien_Holder Lien Holder varchar 75 Allows Null Name of First Lien Holder 167 Core Lien_Date Effective Lien Date datetime 8 Allows Null Date of Lien 61 Core Full_Name Primary Owner Name varchar 50 Allows Null Registrants Full Name 167 Core First_Name Not Displayed varchar 25 Allows Null Registrant's First Name Used to display Full Name 167 Core Last_Name Not Displayed varchar 35 Allows Null Registrant's Last Name Used to Make Full Name 167 Core Address Owner Address varchar 35 Allows Null Registrant's Street Address 167 Core City City varchar 30 Allows Null Registrant's City 167 Core State State char 2 Allows Null Registrant's State 175 Core Zip ZipCode char 5 Allows Null Registrant's Zip code 175 Core Zip4 ZipCode char 4 Allows Null Registrant's Zip+4 175 Core County County varchar 50 Allows Null Registrant's County or residence 167 Core Reg_County Titling Issuing Organization/State varchar 50 Allows Null County the Vessel is Registered In 167 Core Phone Not Displayed varchar 15 Allows Null Registrant's Telephone Number 167 Core DOB Date Of Birth: datetime 8 Allows Null Registrant's Date of Birth 61 Core Orig_Name Not Displayed varchar 75 Allows Null Registrant name as recorded by the States 167 Core Orig_Address Not Displayed varchar 50 Allows Null Registrant's Address as recorded by the States 167 Core Reg_Name2 Second Party Owner Name varchar 75 Allows Null Name of Second Registrant 167 Core Reg_Name3 Third Party Owner Name varchar 75 Allows Null Name of Third Registrant 167 Core Engine_Mak Engine Make varchar 20 Allows Null Engine Make 167 Core Engine_Ser Engine Serial Number varchar 20 Allows Null Engine Serial Number 167 Core Engine_Yea Engine Year int 4 Allows Null Year of Manufacture for the Engine 56 Core HP Horsepower int 4 Allows Null Horsepower of the Engine 56 Core SSN SSN varbinary 128 Allows Null Social Security Number of the Registrant 165 Core DL_NUM Drivers License Number varchar 15 Allows Null Driver License Number of the Registrant 167 Core PIN State ID Number varchar 10 Allows Null Personal Identification Number of the Registrant 167 Core Party_Type Party Type char 1 Allows Null Designates whether owner is a Person or Business 175 Core SecondaryAddress Address varchar 35 Allows Null Secondary Address 167 Core SecondaryCity City varchar 30 Allows Null Secondary City 167 Core SecondaryState State char 2 Allows Null Secondary State 175 Core Secondaryzip ZipCode char 5 Allows Null Secondary Zip 175 Core Secondaryzip4 ZipCode char 4 Allows Null Secondary Zip+4 175 Core Prop_Type Propulsion Type varchar 20 Allows Null Boat's Propulsion (e.g Outboard, Inboard, Jet) 167 Core Last_Mod_Individual Not Displayed varchar 50 Allows Null 167 Core Last_Mod_DtTm Not Displayed datetime 8 Allows Null 61

VIS Data Dictionary