Attachment 2-TABLES-COLUMNS.pdf

318 KB Posted

Attached to
AMVER Consolidated Vessel Data
Solicitation number
70Z0G326QAMVER001
Issued by

About this file

Written by GovTribe AI ·

This is a technical data schema document for the Automated Mutual Vessel Rescue (AMVER) System, outlining database column definitions and structure for maritime vessel information. The document serves as a reference guide for understanding the data architecture rather than a solicitation or contract requirement document.

The schema defines multiple interconnected data tables including: COUNTRY (flag state information with country codes and names), SHIP (comprehensive vessel details such as IMO number, ship name, call sign, tonnage, dimensions, propulsion type, and ownership/management entity codes), OWNER/COMPANY (vessel owner and operator contact information, addresses, and corporate details), PORT (port registry information with geographic coordinates), PROPULSION (vessel propulsion type codes and descriptions), SCRAPPED_VESSELS (historical data for decommissioned vessels), SHIPTYPE (vessel classification with multiple hierarchical type descriptors and cargo classifications), SPECIAL_FEATURES (vessel-specific features and capabilities), and STATUS_TYPE (vessel operational status codes). Each table definition specifies column names, data types (primarily VARCHAR2 and NUMBER formats), nullable status, and descriptive comments. The data structure accommodates comprehensive maritime vessel tracking, including physical specifications (length, breadth, draft, tonnage), operational characteristics (speed, propulsion), identification elements (call sign, MMSI, Inmarsat numbers), and organizational relationships (owners, managers, operators, technical managers). This schema appears designed to support maritime safety and vessel tracking operations within a federal maritime context.

View the file

Other files

File Type Posted
RFQ 70Z0G326QAMVER001 - AMEND 1 KO.pdf PDF
Attachment 4 - AMVER Price Matrix.xlsx XLSX spreadsheet
Attachment 1 - AMVER Data Services SOW.pdf PDF
RFQ Letter_70Z0G326QAMVER0001 SAM.gov.pdf PDF
Attachment 3-DHS_form_11000-6.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
Try for free Login

Text version

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

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 .