DPAS SCR: 01810

• SCR Number
  01810
• Title
  DBO Table Deprecation
• DPAS Module
  Enterprise
• Reporting Organization
  Leidos
• State
  In Progress
• History
  Submitted 09/20/2022
• Description
  Description:

  Currently DPAS duplicates catalog information across two separate database schemas which are kept in sync through the use of triggers. The planned improvement is to replace the triggers with views of the source tables to support catalog data within the PA / MU environments.

  
  

  Recommended:

  The catalog tables within the dbo schema will be removed and replaced with a synonym and view to allow the data to be accessed directly from the catalog schema within DPAS. This will ensure no data needs to be synced to the tables referenced by the PA/MU processes and they can function as they do today.

   

  Mission Critical:

  Mission Critical. DPAS should not be duplicating data in the system. Proposed changes will increase catalog process performance and ensure consistency of catalog data system wide.

   

  Benefits:

  DPAS will improve accuracy and accountability by ensuring consistency of data within the catalog

   

  Users:

  This change will impact/benefit all catalogers within DPAS

   

  Partially Completed - Release 2022.3 - 04 November 2022