Original DATA LAKE (SMLP)

Tables (19)

AIS EVENT HISTORY (VPP_AIS_HIS)

  • AIS Event ID (AIS_EVNT_ID) — VARCHAR(20) — Primary key — NOT NULL
  • Vessel ID (VSL_ID) — VARCHAR(20) — Foreign key → AIS MASTER.Vessel ID — NOT NULL
  • Vessel IMO Code (VSL_IMO_CD) — VARCHAR(10)
  • Vessel latitude (VSL_LAT) — DECIMAL(10,7) — Decimal degrees (DD) express latitude geographic coordinates as decimal fractions of a degree, the value is bounded by…
  • Vessel longitude (VSL_LON) — DECIMAL(11,8) — Decimal degrees (DD) express longitude geographic coordinates as decimal fractions of a degree, the value is bounded by…
  • Vessel Speed (VSL_SPD) — DECIMAL(5,2) — The vessel speed over ground in knots
  • Vessel Heading (VSL_HD) — DECIMAL(5) — The heading of the vessel in degrees
  • Vessel Course (VSL_COG) — DECIMAL(5) — The vessel course over ground in degrees
  • Vessel Position Date (VSL_PSN_DT) — TIMESTAMP — The time of this position
  • Create Date (CRE_DT) — TIMESTAMP

AIS HISTORY (DLZ_AIS_HIS)

  • AIS ID (AIS_ID) — VARCAHR2(50) — Primary key — NOT NULL
  • Vessel IMO Code (VSL_IMO_CD) — VARCHAR2(10) — Foreign key → VESSEL MASTER.Vessel IMO Code — NOT NULL
  • Vessel latitude (VSL_LAT) — NUBMER(10,7) — Decimal degrees (DD) express latitude geographic coordinates as decimal fractions of a degree, the value is bounded by…
  • Vessel longitude (VSL_LON) — NUMBER(11,8) — Decimal degrees (DD) express longitude geographic coordinates as decimal fractions of a degree, the value is bounded by…
  • Vessel Speed (VSL_SPD) — NUMBER(5,2) — The vessel speed over ground in knots
  • Vessel Heading (VSL_HD) — NUMBER(5) — The heading of the vessel in degrees
  • Vessel Course (VSL_COG) — NUMBER(5) — The vessel course over ground in degrees
  • POL Code (POL_CD) — VARCHAR2(5) — The UN location code of the port of loading
  • POL Name (POL_NM) — VARCHAR2(100) — The name of the port of loading
  • POL Arrival Date (POL_ARR_DT) — DATE — Port of Loading - Scheduled or actual arrival time. If not set, the system will calculate this value based on current v…
  • POD Code (POD_CD) — VARCHAR2(5) — The UN location code of the port of destination
  • POD Name (POD_NM) — VARCHAR2(100) — The name of the port of destination
  • POD Arrival Date (POD_ARR_DT) — DATE — Port of Loading - Scheduled or actual arrival time. If not set, the system will calculate this value based on current v…
  • Vessel Status Description (VSL_STS_DESC) — VARCHAR2(100) — The navigational status of the vessel
  • Vessel Position Date (VSL_PSN_DT) — DATE — The time of this position

AIS MASTER (VPP_AIS_MST)

  • Vessel ID (VSL_ID) — VARCHAR(20) — Primary key — NOT NULL
  • Vessel Name (VSL_NM) — VARCHAR(50) — The name of the Vessel given by the Vessel Operator and registered with IMO.
  • Vessel Voyage No (VSL_VOY_NO) — VARCHAR(20)
  • Vessel IMO Code (VSL_IMO_CD) — VARCHAR(10)
  • Vessel Flag (VSL_FLG) — VARCHAR(2) — The flag of the nation whose laws the vessel is registered under. This is the ISO 3166 two-letter country code
  • Vessel Call Sign Number (VSL_CALL_SGN_NO) — VARCHAR(10) — The carrier who is in charge of the vessel operation based on either the SMDG or SCAC code lists
  • Vesel Operate Code (VSL_OPR_CD) — VARCHAR(5)
  • Delete Flag (DELT_FLAG) — VARCHAR(1)
  • Create Date (CRE_DT) — TIMESTAMP — NOT NULL

CARRIER INFO (VPP_CRR_INFO)

  • Carrier ID (CRR_ID) — VARCHAR(20) — Primary key — NOT NULL
  • Carrier Code (CRR_CD) — VARCHAR(5) — NOT NULL
  • Carrier Name (CRR_NM) — VARCHAR(10) — NOT NULL
  • Service Target Code (SVC_TGT_CD) — VARCHAR(5) — NOT NULL
  • Use Flag (USE_FLG) — VARCHAR(1) — NOT NULL
  • Create Date (CRE_DT) — TIMESTAMP — NOT NULL
  • Create User (CRE_USR) — VARCHAR(50)
  • Update Date (UPD_DT) — TIMESTAMP — NOT NULL
  • Update User (UPD_USR) — VARCHAR(50)

CODE CONVERSION (DLO_COM_CD_CONV_LIST)

  • Code Group (CD_GRP) — VARCHAR2(3) — NOT NULL
  • Source Code (SRC_CD) — VARCHAR2(10) — NOT NULL
  • Target Code (TRG_CD) — VARCHAR2(10)
  • Code Desrcription (CD_DESC) — VARCHAR2(100)

DATALAKE TRAKING MASTER (DLZ_TRAK_MST)

  • Message Unique No (MSG_UQ_NO) — VARCHAR2(20) — Primary key — NOT NULL
  • Source Type Code (SRC_TP_CD) — VARCHAR2(10)
  • Create Date (CRE_DT) — DATE

LOCATION MASTER (DLO_LOC_MST)

  • Location Code (LOC_CD) — VARCHAR2(5) — Primary key — NOT NULL
  • Location Name (LOC_NM) — VARCHAR2(100) — The name of the location.
  • Location latitude (LOC_LAT) — NUBMER(10,7) — Geographic coordinate that specifies the north–south position of a point on the Earth's surface.
  • Location longitude (LOC_LON) — NUMBER(11,8) — Geographic coordinate that specifies the east–west position of a point on the Earth's surface.

SHIPMENT SUBSCRIPTION (VPP_SHP_SUBSC)

  • Shipment Subscription ID (SHP_SUBSC_ID) — VARCAHR(20) — Primary key — NOT NULL
  • Container No (CNTR_NO) — VARCHAR(17)
  • Master B/L (MBL_NO) — VARCHAR(20)
  • House B/L No (HBL_NO) — VARCAHR(20)
  • Booking No (BKG_NO) — VARCAHR(20)
  • Carrier Code (CRR_CD) — VARCAHR(5)
  • Current Status Code (CRNT_STS_CD) — VARCAHR(5)
  • Customer ID (CUST_ID) — VARCAHR(50)
  • CRE_USER (CRE_USR) — VARCAHR(50) — NOT NULL
  • Create Date (CRE_DT) — TIMESTAMP
  • Update User (UPD_USR) — VARCAHR(50)
  • Update Date (UPD_DT) — TIMESTAMP
  • Tracking ID (TRK_ID) — VARCAHR(50) — Foreign key → TRACKING_MASTER.Tracking ID — NOT NULL

SHIPMENT SUBSCRIPTION PARTNER (VPP_SHP_SUBSC_PRNR)

  • Shipment Partner ID (SHP_PRNR_ID) — VARCHAR(50) — Primary key — NOT NULL
  • Shipment Subscription ID (SHP_SUBSC_ID) — VARCHAR(20) — Foreign key → SHIPMENT SUBSCRIPTION.Shipment Subscription ID — NOT NULL

TRACKIGN VESSEL1 (DLO_TRAK_VSL)

  • Message Sequence (MSG_SEQ) — NUMBER(2,0) — Foreign key → TRACKING EVENT HISTORY.Message Sequence — NOT NULL
  • Message Unique No (MSG_UQ_NO2) — VARCHAR2(20) — Foreign key → TRACKING EVENT HISTORY.Message Unique No — NOT NULL
  • Event ID (EVNT_ID) — VARCAHR2(50)
  • Vessel IMO Code (VSL_IMO_CD) — VARCHAR2(10) — The unique reference for a registered Vessel. The reference is the International Maritime Organisation (IMO) number, al…
  • Vessel Name (VSL_NM) — VARCHAR2(50) — The name of the Vessel given by the Vessel Operator and registered with IMO.
  • Vessel Flag (VSL_FLG) — VARCHAR2(2) — The flag of the nation whose laws the vessel is registered under. This is the ISO 3166 two-letter country code
  • Vessel Call Sign Number (VSL_CALL_SGN_NO) — VARCHAR2(10) — The carrier who is in charge of the vessel operation based on either the SMDG or SCAC code lists
  • Vessel Operator Code (VSL_OPR_CD) — VARCHAR2(5)
  • Vessel Operator Carrier Code (VSL_OPR_CRR_CD) — VARCHAR2(10) — The carrier who is in charge of the vessel operation based on either the SMDG or SCAC code lists
  • Vessel Operator Carrier Code List Provider Code (VSL_OPR_LST_CD) — VARCHAR(5) — Identifies the code list provider used for the operator and partner carriercodes. Enum: [ SMDG, NMFTA ]

TRACKING EQUIPMENT (DLZ_TRAK_EQ)

  • Message Sequence (MSG_SEQ) — NUMBER(2,0) — Foreign key → TRACKING EVENT HISTORY.Message Sequence — NOT NULL
  • Message Unique No (MSG_UQ_NO) — VARCHAR2(20) — Foreign key → TRACKING EVENT HISTORY.Message Unique No — NOT NULL
  • Event ID (EVNT_ID) — VARCAHR2(50)
  • Equipment Number (EQ_NO) — VARCHAR2(15) — The unique identifier for the equipment, which should follow the BIC ISO Container Identification Number where possible…
  • Equipment ISO Code (EQ_ISO_CD) — VARCHAR2(4) — Unique code for the different equipment size/type used for transporting commodities. The code is a concatenation of ISO…
  • Empty Indicatior Code (EQ_MTY_IND_CD) — VARCHAR2(5) — Code to denote whether the equipment is empty or laden. Enum: [ EMPTY, LADEN ]

TRACKING EVENT HISTORY (DLO_TRAK_EVNT_HIS)

  • Message Sequence (MSG_SEQ) — NUMBER(2,0) — Primary key — NOT NULL
  • Message Unique No (MSG_UQ_NO2) — VARCHAR2(20) — Foreign key → DATALAKE TRAKING MASTER.Message Unique No — NOT NULL
  • Event ID (EVNT_ID) — VARCAHR2(50)
  • Master B/L Number (MBL_NO) — VARCHAR2(50)
  • Booking Number (BKG_NO) — VARCHAR2(50)
  • Event Type (EVNT_TP_CD) — VARCAHR2(10) — The Event Type of the object - to be used as a discriminator. NB: This field should be considered Metadata
  • Event Code (EVNT_CD) — VARCHAR2(4) — Identifier for type of Transport event ARRI (Arrived) DEPA (Departed) LOAD (Loaded) DISC (Discharged) GTIN (Gated in) G…
  • Event Description (EVNT_DESC) — VARCHAR2(150) — Vessel Arrival
  • Event Class Code (EVNT_CLSS_CD) — VARCHAR2(3) — Code for the event classifier can be ACT (Actual) PLN (Planned) EST (Estimated)
  • Event Date (EVNT_DT) — DATE — The local date and time, where the event took place or when the event will take place, in ISO 8601 format.
  • Event Created Date (EVNT_CRE_DT) — DATE — he timestamp of when the event was created. NB: This field should be considered Metadata
  • Transport Call ID (TRSP_CALL_ID) — VARCAHR2(100) — The unique identifier for a transport call
  • Transport Service Code (TRSP_SVC_CD) — VARCHAR2(5) — The code of the service for which the schedule details are published.
  • Transport Voyage Number (TRSP_VOY_NO) — VARCHAR2(50) — The vessel operator-specific identifier of the export Voyage.
  • Transport Mode Code (TRSP_MOD_CD) — VARCHAR2(10) — The mode of transport as defined by DCSA. Enum: [ VESSEL, RAIL, TRUCK, BARGE ]
  • Equipment Number (EQ_NO) — VARCHAR2(15) — The unique identifier for the equipment, which should follow the BIC ISO Container Identification Number where possible…
  • Equipment ISO Code (EQ_ISO_CD) — VARCHAR2(4) — Unique code for the different equipment size/type used for transporting commodities. The code is a concatenation of ISO…
  • Empty Indicatior Code (EQ_MTY_IND_CD) — VARCHAR2(5) — Code to denote whether the equipment is empty or laden. Enum: [ EMPTY, LADEN ]

TRACKING EVENT HISTORY (DLZ_TRAK_EVNT_HIS)

  • Message Sequence (MSG_SEQ) — NUMBER(2,0) — Primary key — NOT NULL
  • Message Unique No (MSG_UQ_NO) — VARCHAR2(20) — Foreign key → DATALAKE TRAKING MASTER.Message Unique No — NOT NULL
  • Event ID (EVNT_ID) — VARCAHR2(50)
  • Master B/L Number (MBL_NO) — VARCHAR2(50)
  • Booking Number (BKG_NO) — VARCHAR2(50)
  • Event Type (EVNT_TP_CD) — VARCAHR2(10) — The Event Type of the object - to be used as a discriminator. NB: This field should be considered Metadata
  • Event Code (EVNT_CD) — VARCHAR2(4) — Identifier for type of Transport event ARRI (Arrived) DEPA (Departed) LOAD (Loaded) DISC (Discharged) GTIN (Gated in) G…
  • Event Description (EVNT_DESC) — VARCHAR2(150) — Vessel Arrival
  • Event Class Code (EVNT_CLSS_CD) — VARCHAR2(3) — Code for the event classifier can be ACT (Actual) PLN (Planned) EST (Estimated)
  • Event Date (EVNT_DT) — DATE — The local date and time, where the event took place or when the event will take place, in ISO 8601 format.
  • Event Created Date (EVNT_CRE_DT) — DATE — he timestamp of when the event was created. NB: This field should be considered Metadata
  • Transport Call ID (TRSP_CALL_ID) — VARCAHR2(100) — The unique identifier for a transport call
  • Transport Service Code (TRSP_SVC_CD) — VARCHAR2(5) — The code of the service for which the schedule details are published.
  • Transport Voyage Number (TRSP_VOY_NO) — VARCHAR2(50) — The vessel operator-specific identifier of the export Voyage.
  • Transport Import Voyage Number (TRSP_IMP_VOY_NO) — VARCHAR2(50)
  • Transport Export Voyage Number (TRSP_EXP_VOY_NO) — VARCHAR2(10)
  • Transport Mode Code (TRSP_MOD_CD) — VARCHAR2(10) — The mode of transport as defined by DCSA. Enum: [ VESSEL, RAIL, TRUCK, BARGE ]
  • Delay Reason Code (DLAY_RSN_CD) — VARCHAR2(3) — Reason code for the delay. The SMDG-Delay-Reason-Codes are used for this attribute. The code list can be found at http:…
  • Source Type Code (SRC_TP_CD) — VARCHAR2(10)

TRACKING LOCATION1 (DLO_TRAK_LOC)

  • Message Sequence (MSG_SEQ) — NUMBER(2,0) — Foreign key → TRACKING EVENT HISTORY.Message Sequence — NOT NULL
  • Message Unique No (MSG_UQ_NO2) — VARCHAR2(20) — Foreign key → TRACKING EVENT HISTORY.Message Unique No — NOT NULL
  • Event ID (EVNT_ID) — VARCAHR2(50)
  • Location Type Code (LOC_TP_CD) — VARCHAR2(5) — POL, POR, TS...
  • Location Name (LOC_NM) — VARCHAR2(100) — The name of the location.
  • Location Code (LOC_CD) — VARCHAR2(5) — The UN Location code specifying where the place is located.
  • Location Facility Code (LOC_FCTY_CD) — VARCHAR2(8) — The code used for identifying the specific facility. This code does not include the UN Location Code.
  • Location Fcility Type Code (LOC_FCTY_TP_CD) — VARCHAR2(4) — A specialized version of the facilityCode to be used in TransportCalls. The code to identify the specific type of facil…
  • Location latitude (LOC_LAT) — NUBMER(10,7) — Geographic coordinate that specifies the north–south position of a point on the Earth's surface.
  • Location longitude (LOC_LON) — NUMBER(11,8) — Geographic coordinate that specifies the east–west position of a point on the Earth's surface.
  • Location Address Name (LOC_ADDR_NM) — VARCHAR2(100) — Name of the address
  • Location Address Street Name (LOC_ADDR_ST_NM) — VARCHAR2(100) — The name of the street of the party’s address.
  • Location Address Street Number (LOC_ADDR_ST_NO) — VARCHAR2(50) — The number of the street of the party’s address.
  • Location Address City Name (LOC_ADDR_CTY_NM) — VARCHAR2(100) — The city name of the party’s address. maxLength: 65
  • Location Address Post Code (LOC_ADDR_PST_CD) — VARCHAR2(10) — The post code of the party’s address.

TRACKING VESSEL (DLZ_TRAK_VSL)

  • Message Sequence (MSG_SEQ) — NUMBER(2,0) — Foreign key → TRACKING EVENT HISTORY.Message Sequence — NOT NULL
  • Message Unique No (MSG_UQ_NO) — VARCHAR2(20) — Foreign key → TRACKING EVENT HISTORY.Message Unique No — NOT NULL
  • Event ID (EVNT_ID) — VARCAHR2(50)
  • Vessel IMO Code (VSL_IMO_CD) — VARCHAR2(10) — The unique reference for a registered Vessel. The reference is the International Maritime Organisation (IMO) number, al…
  • Vessel Name (VSL_NM) — VARCHAR2(50) — The name of the Vessel given by the Vessel Operator and registered with IMO.
  • Vessel Flag (VSL_FLG) — VARCHAR2(2) — The flag of the nation whose laws the vessel is registered under. This is the ISO 3166 two-letter country code
  • Vessel Call Sign Number (VSL_CALL_SGN_NO) — VARCHAR2(10) — The carrier who is in charge of the vessel operation based on either the SMDG or SCAC code lists
  • Vessel Operator Code (VSL_OPR_CD) — VARCHAR2(5)
  • Vessel Operator Carrier Code (VSL_OPR_CRR_CD) — VARCHAR2(10) — The carrier who is in charge of the vessel operation based on either the SMDG or SCAC code lists
  • Vessel Operator Carrier Code List Provider Code (VSL_OPR_LST_CD) — VARCHAR(5) — Identifies the code list provider used for the operator and partner carriercodes. Enum: [ SMDG, NMFTA ]

TRACKING_MASTER (VPP_TRK_MST)

  • Tracking ID (TRK_ID) — VARCAHR(50) — Primary key — NOT NULL
  • Container No (CNTR_NO) — VARCAHR(17) — NOT NULL
  • Master B/L (MBL_NO) — VARCAHR(20)
  • Current Event ID (CRNT_EVNT_ID) — VARCAHR(50)
  • POR Code (POR_CD) — VARCAHR(5)
  • POR Name (POR_NM) — VARCAHR(100)
  • POL Code (POL_CD) — VARCAHR(5)
  • POL Name (POL_NM) — VARCAHR(100)
  • POD Code (POD_CD) — VARCAHR(5)
  • POD Name (POD_NM) — VARCAHR(100)
  • DEL Code (DEL_CD) — VARCAHR(5)
  • DEL Name (DEL_NM) — VARCAHR(100)
  • 1ST TS Location Code (N1ST_TS_LOC_CD) — VARCAHR(5)
  • 1ST TS Location Name (N1ST_TS_LOC_NM) — VARCAHR(100)
  • 2ND TS Location Code (N2ND_TS_LOC_CD) — VARCAHR(5)
  • 2ND TS Location Name (N2NN_TS_LOC_NM) — VARCAHR(100)
  • 1ST Vessel ID (N1ST_VSL_ID) — VARCAHR(20)
  • 2ND Vessel ID (N2ND_VSL_ID) — VARCAHR(20)
  • 3RD Vessel ID (N3RD_VSL_ID) — VARCAHR(20)
  • POL Estimate Departure Date (POL_ETD_DT) — TIMESTAMP
  • POL Actual Departure Date (POL_ATD_DT) — TIMESTAMP
  • 1ST TS Actual Arrival Date (N1ST_TS_ATA_DT) — TIMESTAMP
  • 1ST TS Actual Departure Date (N1ST_TS_ATD_DT) — TIMESTAMP
  • 2ND TS Actual Arrival Date (N2ND_TS_ATA_DT) — TIMESTAMP
  • 2ND TS Actual Departure Date (N2ND_ATD_DT) — TIMESTAMP
  • POD Estimate Arrival Date (POD_ETA_DT) — TIMESTAMP
  • POD Actual Arrival Date (POD_ATA_DT) — TIMESTAMP
  • 1st Received POD ETA Date (N1ST_RCV_POD_DT) — TIMESTAMP
  • Create Date (CRE_DT) — TIMESTAMP — NOT NULL
  • Update Date (UPD_DT) — TIMESTAMP

TRAKCING LOCATION (DLZ_TRAK_LOC)

  • Message Sequence (MSG_SEQ) — NUMBER(2,0) — Foreign key → TRACKING EVENT HISTORY.Message Sequence — NOT NULL
  • Message Unique No (MSG_UQ_NO) — VARCHAR2(20) — Foreign key → TRACKING EVENT HISTORY.Message Unique No — NOT NULL
  • Event ID (EVNT_ID) — VARCAHR2(50)
  • Location Type Code (LOC_TP_CD) — VARCHAR2(5) — POL, POR, TS...
  • Location Name (LOC_NM) — VARCHAR2(100) — The name of the location.
  • Location Code (LOC_CD) — VARCHAR2(5) — The UN Location code specifying where the place is located.
  • Location Facility Code (LOC_FCTY_CD) — VARCHAR2(8) — The code used for identifying the specific facility. This code does not include the UN Location Code.
  • Location Fcility Type Code (LOC_FCTY_TP_CD) — VARCHAR2(4) — A specialized version of the facilityCode to be used in TransportCalls. The code to identify the specific type of facil…
  • Other Facility (LOC_OTR_FCTY_DESC) — VARCHAR2(50) — An alternative way to capture the facility when no standardized DCSA facility code can be found
  • Location latitude (LOC_LAT) — NUBMER(10,7) — Geographic coordinate that specifies the north–south position of a point on the Earth's surface.
  • Location longitude (LOC_LON) — NUMBER(11,8) — Geographic coordinate that specifies the east–west position of a point on the Earth's surface.
  • Location Address Name (LOC_ADDR_NM) — VARCHAR2(100) — Name of the address
  • Location Address Street Name (LOC_ADDR_ST_NM) — VARCHAR2(100) — The name of the street of the party’s address.
  • Location Address Street Number (LOC_ADDR_ST_NO) — VARCHAR2(50) — The number of the street of the party’s address.
  • Location Address City Name (LOC_ADDR_CTY_NM) — VARCHAR2(100) — The city name of the party’s address. maxLength: 65
  • Location Address Post Code (LOC_ADDR_PST_CD) — VARCHAR2(10) — The post code of the party’s address.

TRAKING_EVENT_HISTORY (VPP_TRK_EVNT_HIS)

  • Message Sequence (MSG_SEQ) — DECIMAL(2,0) — Primary key — NOT NULL
  • Tracking ID (TRK_ID) — VARCHAR(50) — Foreign key → TRACKING_MASTER.Tracking ID — NOT NULL
  • Event ID (EVNT_ID) — VARCHAR(50)
  • Event Type (EVNT_TP_CD) — VARCHAR(10) — The Event Type of the object - to be used as a discriminator. NB: This field should be considered Metadata
  • Event Code (EVNT_CD) — VARCHAR(4) — Identifier for type of Transport event ARRI (Arrived) DEPA (Departed) LOAD (Loaded) DISC (Discharged) GTIN (Gated in) G…
  • Event Description (EVNT_DESC) — VARCHAR(150) — Vessel Arrival
  • Event Class Code (EVNT_CLSS_CD) — VARCHAR(3) — Code for the event classifier can be ACT (Actual) PLN (Planned) EST (Estimated)
  • Event Date (EVNT_DT) — TIMESTAMP — The local date and time, where the event took place or when the event will take place, in ISO 8601 format.
  • Event Created Date (EVNT_CRE_DT) — TIMESTAMP — he timestamp of when the event was created. NB: This field should be considered Metadata
  • Transport Mode Code (TRSP_MOD_CD) — VARCHAR(10) — The mode of transport as defined by DCSA. Enum: [ VESSEL, RAIL, TRUCK, BARGE ]
  • Event Location Code (EVNT_LOC_CD) — VARCHAR(5)
  • Event Location Name (EVNT_LOC_NM) — VARCHAR(100)
  • Event Location Type Code (EVNT_LOC_TP_CD) — VARCHAR(3)
  • Event Location Facility Code (EVNT_LOC_FCTY_CD) — VARCHAR(8)
  • Event Location Facility Type Code (EVNT_LOC_FCTY_TP_CD) — VARCHAR(4)
  • Event Location Latitude (EVNT_LOC_LAT) — DECIMAL(10,7)
  • Event Location Longitued (EVNT_LOC_LON) — DECIMAL(11,8)
  • CREATE DATE (CRE_DT) — TIMESTAMP — NOT NULL

VESSEL MASTER (DLZ_VSL_MST)

  • Vessel IMO Code (VSL_IMO_CD) — VARCHAR2(10) — Primary key — NOT NULL
  • Vessel Name (VSL_NM) — VARCHAR2(50) — The name of the Vessel given by the Vessel Operator and registered with IMO.
  • Vessel MMSI Code (VSL_MMSI_CD) — VARCHAR2(10) — The mmsi number of the vessel
  • Vessel Call Sign Number (VSL_CALL_SGN_NO) — VARCHAR2(10) — The carrier who is in charge of the vessel operation based on either the SMDG or SCAC code lists
  • Vessel Flag (VSL_FLG) — VARCHAR2(2) — The flag of the nation whose laws the vessel is registered under. This is the ISO 3166 two-letter country code
  • Vessel Country Code (VSL_CNT_CD) — VARCHAR2(2) — The code for the country that the vessel s registered in
  • Vessel Length (VSL_LEN) — NUMBER(5) — The vessel length in meters
  • Vessel Width (VSL_WDT) — NUMBER(4) — The vessel width in meters
  • Vessel Type Code (VSL_TP_CD) — VARCHAR2(10) — The vessel type