Attachment 2 Tables and Columns_Solicitation 70Z0G322Q009923.pdf

PDF 117 KB Posted Feb 18, 2022

Attached to: AMVER Consolidated Vessel Data
Solicitation number: 70Z0G322Q009923
Issued by: Department of Homeland Security US Coast Guard

About this file

Written by GovTribe AI · Dec 28, 2023

This document contains an attachment to a solicitation for the Automated Mutual Vessel Rescue (AMVER) Consolidated Vessel Data. The solicitation is seeking to collect vessel data to populate various tables and columns in a database with information such as ship details including name, flag, owner and manager; company details including address and nationality; port details including location; propulsion types; and ship types. The solicitation also defines the data types and attributes for each column in the various tables to be populated. The Department of Homeland Security US Coast Guard is the contracting agency issuing this solicitation. The solicitation number is 70Z0G322Q009923 and is titled "AMVER Consolidated Vessel Data."

View the file

Other files

File	Type	Posted
Amendment 1_Questions_Answers_AMVER.pdf	PDF	Mar 7, 2022
Attachment 3 Invoice Instructions and Clauses.pdf	PDF	Feb 18, 2022
Combination Synopsis_Solicitation 70Z0G322Q009923_FINAL.pdf	PDF	Feb 18, 2022
Attachment 1 Statement of Work_Solicitation 70Z0G322Q009923.pdf	PDF	Feb 18, 2022

On GovTribe

Work with this file

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

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

COMBINED SYNOPSIS/SOLICITATION # 70Z0G322Q009923

Attachment 2

AUTOMATED MUTUAL VESSEL RESCUE (AMVER) SYSTEM

Column definitions

Column_Name, Data_type, Nullable, Data_default, Column_ID, Comments

COUNTRY - (N02050_Flag.txt)

CNTCDE VARCHAR2(3 BYTE) No 1 The contraction of the country name into an alphabetic string of length three.

CNAME VARCHAR2(40 BYTE) Yes 2 Name of the country whose vessel is receiving an award.

SHIP – (N02050_ShipDetails.txt)

NO NUMBER(7,0) No 1 IMO number.

STATDATE NUMBER(8,0) Yes 2 Ship status effective date.

STATUS VARCHAR2(1 BYTE) Yes 3 Ship status.

NAMDATE NUMBER(8,0) Yes 4 Current ship name - effective date.

NAME VARCHAR2(50 BYTE) Yes 5 Current ship name.

EXDATE NUMBER(8,0) Yes 6 Former ship names effective dates.

EXNAME VARCHAR2(50 BYTE) Yes 7 Former ship names.

CALLSIGN VARCHAR2(13 BYTE) Yes 8 Call sign.

OFFICIALNO VARCHAR2(20 BYTE) Yes 9 Official number.

SATNO VARCHAR2(10 BYTE) Yes 10 Inmarsat no.

ANSBCK VARCHAR2(6 BYTE) Yes 11 Inmarsat answerback.

MMSI NUMBER(9,0) Yes 12 Maritime mobile service id (mmsi no.).

FLAG VARCHAR2(3 BYTE) Yes 13 Flag.

PORT_CODE VARCHAR2(4 BYTE) Yes 14 Port of registry.

GROSS NUMBER(7,0) Yes 15 Gross tonnage.

DWT NUMBER(7,0) Yes 16 Deadweight.

DOB NUMBER(6,0) Yes 17 Date of build.

LENGTH NUMBER(10,3) Yes 18 Length (oa,bp or registered).

LENIND VARCHAR2(1 BYTE) Yes 19 Length indicator.

BREADTH NUMBER(10,3) Yes 20 Breadth (extreme or molded).

BRDIND VARCHAR2(1 BYTE) Yes 21 Breadth indicator.

DRAFT NUMBER(10,3) Yes 22 Draught maximum.

HEIGHT NUMBER(10,3) Yes 23 Height, keel to mast.

SHIPTYPENO NUMBER(5,0) Yes 24 STATCODE 5 Designator CARGONO NUMBER(3,0) Yes 25 Ship Type full description PROP_CODE VARCHAR2(4 BYTE) Yes 26 Propulsion type code.

SCREWS NUMBER(2,0) Yes 27 Number screws.

SPEC_FEAT VARCHAR2(60 BYTE) Yes 28 Special features.

SPEED NUMBER(10,3) Yes 29 Speed.

SPDIND VARCHAR2(1 BYTE) Yes 30 Speed ind (service speed/max/design/unspecified).

OWNDATE NUMBER(8,0) Yes 31 Registered owner effective date.

OWNERNO NUMBER(7,0) Yes 32 Registered owner.

SHMGRDATE NUMBER(8,0) Yes 33 Ship manager effective date.

SHMGRNO NUMBER(7,0) Yes 34 Ship manager.

FLMGRDATE NUMBER(8,0) Yes 35 Fleet manager (operator) effective date.

FLMGRNO NUMBER(7,0) Yes 36 Fleet manager (operator).

COMPDATE NUMBER(8,0) Yes 37 Parent company effective date.

COMPANY_CODE NUMBER(7,0) Yes 38 Parent company code.

EXOWNDATE NUMBER(8,0) Yes 39 Former registered owner effective date.

EXOWNNO NUMBER(7,0) Yes 40 Former registered owner(s).

EXMGRDATE NUMBER(8,0) Yes 41 Former manager effective date.

EXMGRNO NUMBER(7,0) Yes 42 Former registered owner(s).

EXCOMPDATE NUMBER(8,0) Yes 43 Former parent effective date.

EXCOMPANY_CODE NUMBER(7,0) Yes 44 Former parent.

DOCCOMP NUMBER(7,0) Yes 45 Document of compliance (doc) company.

DOCCOMPDATE NUMBER(8,0) Yes 46 Document of compliance - effective date.

BENOWNER NUMBER(7,0) Yes 47 Group beneficial owner.

BENOWNDATE NUMBER(8,0) Yes 48 Group beneficial owner effective date.

TECHMGR NUMBER(7,0) Yes 49 Technical manager.

TECHMGRDATE NUMBER(8,0) Yes 50 technical manager effective date.

OWNER – (N02050_Company.txt)

COMPANY_CODE NUMBER(7,0) No 1 Seven digit owner company code.

SHORT_NAME VARCHAR2(50 BYTE) Yes 2 Company shortsyle decode.

FULL_NAME VARCHAR2(220 BYTE) Yes 3 Company full style decode.

PHONE VARCHAR2(30 BYTE) Yes 4 The telephone number of the owner company.

FAX VARCHAR2(30 BYTE) Yes 5 The facsimile number of the owner company.

TELEX VARCHAR2(30 BYTE) Yes 6 The telex number of the owner company.

EMAIL_ADDRESS VARCHAR2(50 BYTE) Yes 7 The email address of the owner company.

WEB_ADDRESS VARCHAR2(50 BYTE) Yes 8 The web address of the owner company.

FOUNDED_DATE NUMBER(4,0) Yes 9 Date owner company was founded.

COC VARCHAR2(40 BYTE) Yes 10 The 'care of' name for owner company REGNAT VARCHAR2(35 BYTE) Yes 11 The registered nationality of a company.

TRUENAT VARCHAR2(35 BYTE) Yes 12 The true nationality of the owner company.

RESCNTRY VARCHAR2(35 BYTE) Yes 13 Country of the address for the owner.

CNTCDE VARCHAR2(3 BYTE) Yes 14 Company nationality (true nationality) BUILDING VARCHAR2(120 BYTE) Yes 15 Owner company building name (if applicable).

STREET VARCHAR2(120 BYTE) Yes 16 Street address of owner company.

TOWN VARCHAR2(40 BYTE) Yes 17 Owner company city/town.

POSTAL_CODE VARCHAR2(20 BYTE) Yes 18 Owner company postal code.

ADDRESS_1 VARCHAR2(50 BYTE) Yes 19 Owner address - line 1.

ADDRESS_2 VARCHAR2(50 BYTE) Yes 20 Owner address - line 2.

ADDRESS_3 VARCHAR2(50 BYTE) Yes 21 Owner address - line 3.

ADDRESS_4 VARCHAR2(50 BYTE) Yes 22 Owner address - line 4.

ADDRESS_5 VARCHAR2(50 BYTE) Yes 23 Owner address - line 5.

ADDRESS_6 VARCHAR2(50 BYTE) Yes 24 Owner address - line 6.

ADDRESS_7 VARCHAR2(50 BYTE) Yes 25 Owner address - line 7.

ADDRESS_8 VARCHAR2(50 BYTE) Yes 26 Owner address - line 8.

PORT – (N02050_Port.txt)

PORT_CODE NUMBER(4,0) No 1 Port code.

CNTCDE VARCHAR2(3 BYTE) No 2 The contraction of the country name into an alphabetic string of length three.

PNAME VARCHAR2(40 BYTE) Yes 3 The name of the port.

ADJ VARCHAR2(3 BYTE) Yes 4 No definition given.

NSIND VARCHAR2(1 BYTE) Yes 5 North or south indicator.

LATDEG NUMBER(3,0) Yes 6 Port latitude to the hundredth degree.

LATMIN NUMBER(2,0) Yes 7 Minutes indicator of the port.

LATSEC NUMBER(2,0) Yes 8 Seconds indicator of the port.

EWIND VARCHAR2(1 BYTE) Yes 9 East or west indicator.

LNGDEG NUMBER(3,0) Yes 10 Longitude indicator of the port in hundredths of a degree.

LNGMIN NUMBER(2,0) Yes 11 Minutes indicator of the port.

LNGSEC NUMBER(2,0) Yes 12 Seconds indicator of the port.

PROPULSION – (N02050_Propulsion.txt)

PROP_CODE VARCHAR2(4 BYTE) No 1 Unique 4-letter code that corresponds to a particular propulsion type.

TYPE VARCHAR2(30 BYTE) Yes 2 Full description that corresponds with a particular propulsion code.

SCRAPPED_VESSELS – (N02050_ShipDetailsDeadShips.txt)

LLOYDSNO NUMBER(7,0) No 1 IMO (lloyd's register) number.

STATUS_DATE NUMBER(8,0) Yes 2 Ship status effective date.

STATUS VARCHAR2(1 BYTE) Yes 3 Ship status.

CURRENT_NAME VARCHAR2(50 BYTE) Yes 4 Current shipname.

CALLSIGN VARCHAR2(13 BYTE) Yes 5 Call sign.

FLAG VARCHAR2(3 BYTE) Yes 6 Flag.

OWNDATE NUMBER(6,0) Yes 7 Registered owner effective date.

OWNERNO NUMBER(7,0) Yes 8 Registered owner.

SHMGRDATE NUMBER(6,0) Yes 9 Ship manager effective date.

SHMGRNO NUMBER(7,0) Yes 10 Ship manager.

COMPDATE NUMBER(6,0) Yes 11 Parent company effective date.

COMPANY_CODE NUMBER(7,0) Yes 12 Parent company code.

SHIPTYPE – (N02050_ShipType.txt)

SHIPTYPENO NUMBER(7,0) No 1 STATCODE 5 number.

TYPE VARCHAR2(60 BYTE) Yes 2 Type of ship – full description.

ALT_ST_1 VARCHAR2(4 BYTE) Yes 3 Alternate Level 1 Type – descriptor ALT_TYPE_1 VARCHAR2(60 BYTE) Yes 4 Alternate Level 1 Type – full description ALT_ST_2 VARCHAR2(3 BYTE) Yes 5 Alternate Level 2 Type – descriptor ALT_TYPE_2 VARCHAR2(60 BYTE) Yes 6 Alternate Level 2 Type – full description ALT_ST_3 VARCHAR2(2 BYTE) Yes 7 Alternate Level 3 Type – descriptor ALT_TYPE_3 VARCHAR2(60 BYTE) Yes 8 Alternate Level 3 Type – full description ALT_ST_4 VARCHAR2(1 BYTE) Yes 9 Alternate Level 4 Type – descriptor ALT_TYPE_4 VARCHAR2(60 BYTE) Yes 10 Alternate Level 4 Type – full description ALT_ST_5 VARCHAR2(1 BYTE) Yes 11 Hull Type – descriptor ALT_TYPE_5 VARCHAR2(60 BYTE) Yes 12 Hull Type – full description ALT_ST_6 VARCHAR2(1 BYTE) Yes 13 Specialty Type – descriptor ALT_TYPE_6 VARCHAR2(60 BYTE) Yes 14 Specialty Type – full description ST_CARGONO VARCHAR2(2 BYTE) Yes 15 Cargo - descriptor ST_CARGOTYPE VARCHAR2(60 BYTE) Yes 16 Cargo – full description

SPECIAL_FEATURES – (N02050_SpecialFeatures.txt)

LLOYDSNO NUMBER(7,0) No 1 IMO (lloyd's register) number.

SPECFEATNO VARCHAR2(4 BYTE) No 2 Special features type code.

TYPE VARCHAR2(30 BYTE) Yes 3 Special features type.

STATUS_TYPE – (N02050_ShipStatus.txt)

STATUS VARCHAR2(1 BYTE) No 1 Ship status description.

TYPE VARCHAR2(30 BYTE) Yes 2 Condition or status of the vessel

File details come from the government source that posted it. Updated Feb 18, 2022.