Run the following query to identify those students incorrectly identified in the Organization table instead of the Person table.

SELECT sm.ID_NUM, nmStudent.LAST_NAME, nmStudent.FIRST_NAME, nmStudent.PARTY_TYPE
  FROM STUDENT_MASTER sm
  JOIN NAME_MASTER nmStudent ON sm.ID_NUM = nmStudent.ID_NUM
  JOIN Organization org ON nmStudent.APPID = org.NameMasterAppID
  JOIN Party paStudent ON org.AppID = paStudent.AppID

Update the identified students' record from 'O' to 'P' in the NAME_MASTER.PARTY_TYPE column.