Welcome to the
 Department of
   Technology Services

Change Control Report 05-23-05

                             
 
  DoTS/DPS Scheduled Changes  
   
 
  Report run on:   May 23, 2005 1:35 PM  
     
 
  Scheduled   Change Name   User Impact  
       
  25-MAY-05   DTWH - Replace ODS_ADMIN with EDM_ADMIN
  As more functionality is added to the data warehouse environment, the reporting schema ODS_ADMIN that had served only ODS load reporting, now needs to serve the reporting needs for other parts of the environment (data vault loading, for example). This change will genericize the load reporting to serve the whole of the DW environment.
 
       
     
   
   
   
   
   
   
   
   
  20-MAY-05   DTWH - Promote Data Vault Infrastructure   The core structures for the production Data Vault have been created and tested in development and QA. As soon as the hardware infrastructure has been built out, this core piece of the EDI infrastructure may be productionalized.
 
       
   
   
   
   
   
   
 
  27-MAY-05   EMPA - EMPAC - Run fix_quantity script in INDPROD
  Run the fix_quantity script in INDPROD to fix the erroneous error message "on requisition, on order and on reserve must be positive" which occurs infrequently when ordering stock items.
 
       
     
   
   
   
 
  27-MAY-05   LAWS - Data clean-up in preparation for the 8.1 upgrade.
  Need to run: 1 a script to place end-dates on open pension deduct records and 2. a script to end open GL transaction on the Paymaster and & PrDibrib tables.
 
       
     
   
   
 
  Page 1