Vessel Registry relationship with other systems

Owned by Kajal Chaudhari
Last updated: Nov 04, 2020
2 min read

Current state

 

Mindmap Link

MSDTS is searching vessel against different databases based on the Service Request type and sub-type.

SR Type

SR Subtype

Databases

Domestic Vessel Certification

  • First Inspection

  • Re-Inspection

  • Periodic

  • Intermediate

  • Delegated Statutory Inspection Program (DSIP)

  • Plan Approval

SIRSSCRS (MSCAII)SCVRS (SCVLS)

Off-Ship Inspection

Construction, Manufacture, Tests of Materials

None

Compliance Inspection

  • TC Inspected Vessel (non-delegated)

  • SVCP enrolled vessel

  • Small vessel (non- SVCP)

  • Concentrated Inspection Campaign

  • DSIP Enrolled Vessel (delegated)

SIRSSCRS (MSCAII)SCVRS (SCVLS)

  • Small Vessel Manufacturers Monitoring

  • Monitoring of Service Stations

None

 

Coasting Trade and Authorization for Clearance

  • Coasting Trade - Convention - First Inspection - 7 days or less

  • Coasting Trade - Convention - First Inspection - more than 7 days

  • Coasting Trade - Non-Convention - First Inspection

  • Coasting Trade - Convention - Periodic Inspection - 7 days or less

  • Coasting Trade - Convention - Periodic Inspection - more than 7 days

  • Coasting Trade - Non-Convention - Periodic Inspection

SIRSSCRS (MSCAII)
*See Note1

  • Mobile Offshore Drilling Unit

  • Authorization for Clearance - Safety Certificate

  • Authorization for Clearance - Load Line Certificate

CPSCS

 

Cargo and Shipping

  • Grain

  • Timber

  • Concentrates

  • Bulk Cargo (Division 2)

  • Packaged Dangerous Goods (Division 5)

SIRSSCRS (MSCAII)SCVRS (SCVLS)CPSCS

Enforcement

  • Domestic Vessel

SIRSSCRS (MSCAII)SCVRS (SCVLS)

  • Transportation Appeal Tribunal of Canada (TATC)

SIRSSCRS (MSCAII)SCVRS (SCVLS)CPSCS

 

  • The old code in inc_NTARS_Pop_SearchSRNewVessels, was searching against the SRCS system only using mv007_vrqs but that was replaced with the new code which searches against the SIRS database using the view SIRS.VW001_SIRS_SRCS_VESSEL. The query is attached as VW001_SIRS_SRCS_VESSEL.sql for more detail. This view first searches for the vessels in the SRCS database which official number exists in the SIRS database and then searches vessels in the SIRS database whose official number doesn't exist in SRCS.

  • According to Terry, the response was slow while accessing SIRS and SRCS separately and the view VW001_SIRS_SRCS_VESSEL already exists in the SIRS so they had used that view instead of going to the SRCS database directly.

Note 1 : For the coasting trade SIRS file number must be required.