GRANTS DATA MIGRATION PLAN:    Last updated: 3-30-04              
Data Conv. Datasets Priority Format-Source Who     preparing Preparation Status & Steps Date Due Actual Given Who Converting Date Due Actual Completed Conver. Status Notes
 Keywords L Excel  Depts/ Chris ü Ready     Jay/John     DONE  
 
Professional Data H Excel  HR/Depts/Chris Round 1 Data Load: In Progress              
Status: 3-31 John has partially run in data-               
ü Provide Round 1  Data Set 26-Mar            
  Run App Engine with Round 1 Data  29-Mar   John/Lyn 5-Apr     some clean up required; John and Chris working on this; should be finished by 4/1/04 to be ready for a final load by 5-Apr.
  Validate Round 1 Data Run 5-Apr   Chris & Susan/Anna 6-Apr      
Round 2 Data Load:   5-Apr            
Status:              
  Provide Round 2 Data Set 5-Apr   Chris        
  Run App Engine with Round 2 Data  10-Apr   John/Lyn        
  Validate Round 2 Data Run 15-Apr   Chris & Susan/Anna        
Round 3 Data Load:               
Status:              
  Provide Round 3  Data Set 25-Apr            
  Run App Engine with Round 3 Data  28-Apr   John/Lyn        
  Validate Round 3 Data Run 1-May   Chris & ?        
HR IT load Prior Work Experience, Memberships, Certifications              
Status:              
  Provide  Data Set 15-Apr           WE is round 1, Memberships is Round 2, Certifications is round 3--total data set provided by 15-April, but per the dates above, each will be provided sequentially.
  Run SQR?  with  Data      John/Mary 26-Apr      
  Validate  Data Run     Chris & Anna 30-Apr      
Integration Broker              
Status: (3-30) Discovered issue with the PERS_DATA_EFFDT table (mismatch of data elements) between HR and FIN. John is researching.              John Adcock working toward a resolution.
                 
                 
 
Billing History H   Billing Team   Met to plan. ?????   Jim & Rick ?????      
 
HR Dept. Locatns. H   Gerri  and Process Subteam   In process - 75% complete (3-30), FIDEV 15-Apr    none        
  Move to FITST              
  Move to FIPRD              
 
Sponsors H Excel  Data Migra. Team Status - (4-2) Gerri is waiting (asked Rick) for the correct format- she doesn't know what that is.   (4-1) The files were received on 4/1 but would not load successfully because cust_id.txt was not in the correct format.           (3-18)Test Sponsors loaded.  Identified problem with Vendor SetID.  John corrected program.  Second test data to be given to John on 3/31.             37 loaded 3-18-04 505 Sponsors identified,  gathering addresses-        have 120. 
Initial Test Load: FIDEV              
Status: 3-31 Gerri will get 2nd data set to John              
ü Provide Test Sponsor Data Set 18-Mar           37 records
ü Run SQR with Test Data      John  18-Mar      
ü Validate Test Sponsor Data Run              
ü Provide Second Test Sponsor Data Set  31-Mar 1-Apr         518 Sponsor Records
  Run SQR with Second Test Data      John  31-Mar      
  Validate Second Test Sponsor Data Run 1-Apr            
Full Test Load: FITST?             Depends on avail. of FITST- must have SP1 and ALL Fix packs 1 & 2 loaded. 
Status:               
  Provide Final Test Sponsor Data Set 7-Jun           500+ records
  Run SQR with Final Test Data      John  7-Jun      
  Validate Final Test Sponsor Data Run 10-Jun            
Reload all Data on FIPRD: ???????             Depends on avail. of FITST- must have SP1 and ALL Fix packs 1 & 2 loaded. 
Status:               
  Provide Final Sponsor Data Set 23-Jun            
  Run SQR with Final  Sponsor Data      John  23-Jun      
  Validate Final Sponsor Data Load 24-Jun            
 
Proposals (SQR) H Semi-colon Delimited Data Migra. Team Initial Test Load: on FIDEV              
Status(3-30) - Test Proposal loaded.  Identified problem with leading zeros and Department Contact.  John will revise the program and load second proposal.              
ü Provide Test Award Data Set 24-Mar            
ü Run SQR with Test Data      John 25-Mar      
ü Validate Test Award Data Run 29-Mar            
  Provide Second Test Award Data Set 31-Mar            
  Run SQR with Second Test Data      John 31-Mar      
  Validate Second Test Award Data Run 31-Mar            
ü Provide Test Award Budget Data Set 31-Mar 1-Apr          
  Run SQR with Test Budget Data      John 1-Apr      
  Validate Test Award Budget Data Run 2-Apr            
Full Test Load: on FIDEV???              
Status: (4-1) Jay  provided a preliminary extract- Gerri needs to discuss further with Jay on Monday., not usable at this point.              
ü IT provide Legacy extract Award data     Jay 1-Apr      
  Tic and Tye Data Stream to Legacy 14-Apr            
  Provide Full Award (Proposal) Data 15-Apr            
  Run SQR with Award (Proposal) Data     John 16-Apr      
  Validate Award (Proposal) Data 7-May            
  IT provide Legacy extract Award Budget data     Jay 7-May      
  Tic and Tye Data Stream to Legacy & PS 19-May            
  Provide Full Award Budget(Proposal) Data 20-May            
  Run SQR with Awd. Budget Prop. Data     John 21-May      
  Validate Award Budget Proposal Data 7-Jun            
Reload Award Data on FITST             Depends on avail. of FITST- must have SP1 and ALL Fix packs loaded. 
Status:               
  Provide Full Award & Budget(Proposal) Data 9-Jun            
  Run SQR with Awd. &  Budget Prop. Data     John 9-Jun      
  Validate Award Proposal Data 14-Jun            
Load Proposal Data on FITST              
Status:               
  Provide Proposal and Budget Data  15-Jun            
  Run SQR with Prop. Data      John 15-Jun      
  Validate Proposal Data  21-Jun            
Final load of all Data on FIPRD             Depends on avail. of FIPRD- must have SP1 and ALL Fix packs loaded. 
Status:               
  Provide Award and Budget Data  22-Jun            
  Run SQR with Award and Budget Data      John 22-Jun      
  Validate Award and Budget Data 23-Jun            
  In Grants P.S.- Create Awards 24-Jun            
  Run SQL select to update Project Data     John 28-Jun      
  Run SQl select to update Contracts  Data     John 28-Jun      
  Provide Proposal and Budget Data  28-Jun            
  Run SQR with Prop. Data      John 28-Jun      
  Validate Proposal Data  29-Jun            
  Provide Ag 30's  Data  29-Jun            
  Run SQR with AG 30's Data      John 29-Jun      
  Validate AG 30's Data  30-Jun            
 
Cang_Budg records (Ledger Budg)to Ledger_Proj H     Status: 3-31- Tamara will discuss with John              
  Move budget records from 1 table to another June   John        
  Tic and Tye 2 tables              
  Change Balance Load SQR to go to Ledger_proj     John        
                         
Ledger Transactions to Proj_Resource H     Status:               
  Run Delivered Process to move Ledger Trans. To Proj_Resource June   John        
  Tic and Tye Proj_Resource to Ledger              
 
Update to Project Tables H   Data Migr. Team Status:               
  Rules Identified by Tamara, Rachel and Vanessa 8-Apr           Vaness on Sick Leave
  Test Update Tables by SQl select statements     John 30-Jun      
 
Update to Contract Tables H   Data Migr. Team Status:               
  Rules Identified by Tamara, Rachel and Vanessa 8-Apr           Vaness on Sick Leave
  Test Update Tables by SQl select statements     John 30-Jun      
 
DA- AG 30s M   Julie Status: 3-31 Julie will create new conversion spreadsheet, ulie needs to talk with Tamara               
  IT provide Legacy extract data 7-May   Jay        
  Julie provide data      Jay        
  IT populate PS     Tim