Create Student
Insert Student
Create StudentApplication
Insert StudentApplication	Linked to Student
Insert PersonAddress		Linked to Person
Insert PersonTelephone		Linked to Person. Notes = Nok information
Insert Qualification		Linked to Person
Insert ModuleApplication	Linked to Application
Update StudentApplication - Address Telephone

Stu = 95000012757813
App = 95000012757832
Ref = T0079427

SELECT TOP 100 * FROM mis_capd_Person WHERE p_id = 95000012757813
SELECT TOP 100 * FROM mis_capd_PersonalDetails WHERE pd_id = 95000012757813
SELECT TOP 100 * FROM mis_capd_Student WHERE s_id = 95000012757813
SELECT TOP 100 * FROM mis_capd_StudentApplication WHERE sa_student = 95000012757813
SELECT TOP 100 * FROM mis_capd_PersonAddress WHERE pa_addressperson = 95000012757813
SELECT TOP 100 * FROM mis_capd_PersonTelephone WHERE pt_telephoneperson = 95000012757813
SELECT TOP 100 * FROM mis_capd_Qualification WHERE q_qualificationperson = 95000012757813
SELECT TOP 100 * FROM mis_capd_ModuleApplication WHERE ma_studentapplication = 95000012757832

SELECT TOP 100 * FROM mis_capd_Telephone WHERE t_id = 95000012757818
SELECT TOP 100 * FROM mis_capd_Address WHERE a_id = 95000012757814 -- Address
SELECT TOP 100 * FROM mis_capd_Address WHERE a_id = 95000012757815 -- Email
