Converting SSN to GCID in Compass

Problem Description : 

Convert SSN's in Compass to GCID where applicants did placement test without using GCID. Run prior to LS Exit tests starting.

 Resolution : 

Applicants may have entered their SSN into Compass when taking the Compass test for placement. These need to be converted to GCID prior to start of LS Exit Testing.

1) Make sure no one is in the Compass system

2) Map F:\ drive to the \\hawk\d share (or directory above the compassesl folder if testing)

3) In MS Access 2007, open the database n:\csd\compass\Compass_SSN_GCID_Conversion.accdb.

4) Run the gcid_update and sessions_update Queries to update all demographic and test session records that have matching SSN on SPAPERS in Banner to the student's GCID

5) Close Access and open the CompassESL application, logging in as Director

6) Run the Tools|Database|Rebuild Database... option to rebuild indexes

7) Close CompassESL and all should be ready to go.

Queries in this database are:

gcid_select - selects demographics records in Compass that need to be updated to GCID

sessions_select - selects test session records in Compass that need to be updated to GCID

gcid_update - updates the demographics records in Compass that need to be updated to GCID

sessions_update - updates the test session records in Compass that need to be updated to GCID

 Revision Date : 4/28/2009