Timeline
The timeline shown below is an estimate based upon the current status of the SSN Conversion Project. Modifications will be made as needed to address specific needs or changes to the scope of the project.
Phase 1
Initiation
November 2006 – March 2007
Organize Project Team and Subcommittees
Determine which system will supply Unique ID
Develop and distribute SSN Survey
Compile and evaluate survey responses
Determine conversion date
Begin communications with the university community
Data cleanup
Submit Project Plan to USG
Phase 2
Development
March 2007 – May 2007
Develop model for new ID assignment
Migrate users into one system
Develop SQL scripts for cross-reference tables, triggers and conversion
Perform impact analysis on all changed processes
Perform conversion and proof-of-concept in a test environment
Develop new policies and procedures
Phase 3
Prototype
June 2007 – July 2007
Full beta testing of new procedure
Main communications thrust
Finalize policies and procedures
Develop training and awareness initiatives
Phase 4
Implementation
August – September 2007
Finalize implementation schedule and tasks
Final data reconciliation
Perform conversion on systems, applications and databases
New IDs created (to be determined)
Phase 5
Maintenance
Ongoing Evaluation of data
Collect, secure and maintain both ID numbers and SSNs
Continue data cleanup






