Populate advisor/advisee data stored in PubAdmin

[paulalbert1]

Go to PubAdmin and run this query...

(select distinct `Student FName` as StudentFirstName, `Student LName` as StudentLastName, `Student CWID` as StudentCWID, `Advisor CWID` as MentorCWID,`Advisor FirstName` as MentorFirstName,`Advisor LastName` as MentorLastName 
from students 
where ADVISOR_NUM = 6 and ADVISOR_TYPE not in ('GRPCD','ASSOC','PCOOR','ADEAN','PCHAI','NULL'))
UNION
(select distinct StudentFirstName, StudentLastName, StudentCWID, MentorCWID, MentorFirstName, MentorLastName 
from students_AOC)

Populate the "knownRelationships" node in the Identity table with name information.

For students who are considered in scope, populate the last and first name of any advisors. Add type "mentor."

nameMap{3}
	firstInitialString: L
	firstNameString: Lorraine
	lastNameString: Gudas
	typeString: mentor
	uidString: ljgudas

For mentors who are considered in scope, populate the last and first name of any students. Add type "mentee."

nameMap{3}
	firstInitialString: M
	firstNameString: Matt
	lastNameString: Matthews
	typeString: mentee
	uidString: mzm2122