Attachment_2_-_CG.fmt

6 KB Posted

Attached to
Vessel Identification System Database
Solicitation number
HSCGG3-17-R-PWO009
Issued by

About this file

File Format

Text of this file

8.0 1 SQLCHAR 2 2 "" 1 REG_STATE SQL_Latin1_General_CP1_CI_AS 2 SQLCHAR 2 15 "" 2 REG_NUM SQL_Latin1_General_CP1_CI_AS 3 SQLCHAR 2 15 "" 3 REG_STANDARD SQL_Latin1_General_CP1_CI_AS 4 SQLCHAR 2 20 "" 4 HULL_ID SQL_Latin1_General_CP1_CI_AS 5 SQLCHAR 2 25 "" 5 MAKE SQL_Latin1_General_CP1_CI_AS

6 SQLINT 1 4 "" 6 MODEL_YEAR ""

7 SQLINT 1 4 "" 7 LENGTH_IN ""

8 SQLCHAR 2 20 "" 8 DRIV_TYPE SQL_Latin1_General_CP1_CI_AS 9 SQLCHAR 2 1 "" 9 HULL_TYPE SQL_Latin1_General_CP1_CI_AS 10 SQLCHAR 2 1 "" 10 FUEL_TYPE SQL_Latin1_General_CP1_CI_AS 11 SQLCHAR 2 20 "" 11 SBOAT_TYPE SQL_Latin1_General_CP1_CI_AS 12 SQLCHAR 2 1 "" 12 USE_TYPE SQL_Latin1_General_CP1_CI_AS 13 SQLCHAR 2 20 "" 13 BOAT_NAME SQL_Latin1_General_CP1_CI_AS

14 SQLDATETIME 1 8 "" 14 REG_DATE ""

15 SQLDATETIME 1 8 "" 15 TITLE_DATE ""

16 SQLCHAR 2 20 "" 16 TITLE_NUM SQL_Latin1_General_CP1_CI_AS 17 SQLBIT 1 1 "" 17 Expired "" 18 SQLCHAR 2 15 "" 18 CG_NUM SQL_Latin1_General_CP1_CI_AS

19 SQLDATETIME 1 8 "" 19 LAST_UPDATED ""

20 SQLCHAR 2 15 "" 20 ORIG_HULL_ID SQL_Latin1_General_CP1_CI_AS 21 SQLCHAR 2 25 "" 21 ORIG_MAKE SQL_Latin1_General_CP1_CI_AS 22 SQLCHAR 2 25 "" 22 ORIG_MODEL SQL_Latin1_General_CP1_CI_AS

23 SQLSMALLINT 1 2 "" 23 ORIG_YEAR ""

24 SQLCHAR 2 20 "" 24 ORIG_PROP SQL_Latin1_General_CP1_CI_AS 25 SQLCHAR 2 20 "" 25 ORIG_HULL_TYPE SQL_Latin1_General_CP1_CI_AS

26 SQLDATETIME 1 8 "" 26 STOL_DATE ""

27 SQLDATETIME 1 8 "" 27 RECOV_DATE ""

28 SQLCHAR 2 75 "" 28 LIENHOLDER SQL_Latin1_General_CP1_CI_AS

29 SQLDATETIME 1 8 "" 29 LIENDATE ""

30 SQLCHAR 2 50 "" 30 FULL_NAME SQL_Latin1_General_CP1_CI_AS 31 SQLCHAR 2 25 "" 31 FIRST_NAME SQL_Latin1_General_CP1_CI_AS 32 SQLCHAR 2 35 "" 32 LAST_NAME SQL_Latin1_General_CP1_CI_AS 33 SQLCHAR 2 35 "" 33 ADDRESS SQL_Latin1_General_CP1_CI_AS 34 SQLCHAR 2 30 "" 34 CITY SQL_Latin1_General_CP1_CI_AS 35 SQLCHAR 2 2 "" 35 STATE SQL_Latin1_General_CP1_CI_AS 36 SQLCHAR 2 5 "" 36 ZIP SQL_Latin1_General_CP1_CI_AS 37 SQLCHAR 2 4 "" 37 ZIP4 SQL_Latin1_General_CP1_CI_AS 38 SQLCHAR 2 50 "" 38 COUNTY SQL_Latin1_General_CP1_CI_AS 39 SQLCHAR 2 50 "" 39 REGCOUNTY SQL_Latin1_General_CP1_CI_AS 40 SQLCHAR 2 15 "" 40 PHONE SQL_Latin1_General_CP1_CI_AS

41 SQLDATETIME 1 8 "" 41 DOB ""

42 SQLCHAR 2 75 "" 42 ORIG_NAME SQL_Latin1_General_CP1_CI_AS 43 SQLCHAR 2 50 "" 43 ORIG_ADDRESS SQL_Latin1_General_CP1_CI_AS 44 SQLCHAR 2 75 "" 44 REG_NAME2 SQL_Latin1_General_CP1_CI_AS 45 SQLCHAR 2 75 "" 45 REG_NAME3 SQL_Latin1_General_CP1_CI_AS 46 SQLCHAR 2 20 "" 46 ENGINE_MAK SQL_Latin1_General_CP1_CI_AS 47 SQLCHAR 2 20 "" 47 ENGINE_SER SQL_Latin1_General_CP1_CI_AS

48 SQLSMALLINT 1 2 "" 48 ENGINE_YEA ""

49 SQLSMALLINT 1 2 "" 49 HP ""

50 SQLCHAR 2 11 "" 50 SSN SQL_Latin1_General_CP1_CI_AS 51 SQLCHAR 2 50 "" 51 DL_NUM SQL_Latin1_General_CP1_CI_AS 52 SQLCHAR 2 50 "" 52 PIN SQL_Latin1_General_CP1_CI_AS 53 SQLCHAR 2 1 "" 53 PARTY_TYPE SQL_Latin1_General_CP1_CI_AS 54 SQLCHAR 2 35 "" 54 SECONDARYADDRESS SQL_Latin1_General_CP1_CI_AS 55 SQLCHAR 2 30 "" 55 SECONDARYCITY SQL_Latin1_General_CP1_CI_AS 56 SQLCHAR 2 2 "" 56 SECONDARYSTATE SQL_Latin1_General_CP1_CI_AS 57 SQLCHAR 2 5 "" 57 SECONDARYZIP SQL_Latin1_General_CP1_CI_AS

58 SQLCHAR 2 4 "" 58 SECONDARYZIP4SQL_Latin1_General_CP1_CI_AS
59 SQLCHAR 2 20 "" 59 PROP_TYPESQL_Latin1_General_CP1_CI_AS
60 SQLCHAR 2 30 "" 60 CODStatusSQL_Latin1_General_CP1_CI_AS
61 SQLDATETIME 1 8 "" 61 CODExpire""

62 SQLCHAR 2 20 "" 62 FILENAME SQL_Latin1_General_CP1_CI_AS

Other files

File Type Posted
Amendment_1_RFQ_PWO009.docx DOCX document
Attachment_4_-_AoA_-_Requirements.pdf PDF
Attachment_1_-_VIS_Data_Dictionary.pdf PDF
RFQ_PWO009.doc.docx DOCX document
Attachment_3-_State_MOA_Status.pdf PDF

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

File details come from the government source that posted it. Updated .