CREATE OR REPLACE VIEW "C##NU_EMS_DEV"."TMS_EXAMINER_VIEW" AS
SELECT
	TSE.SCRIPT_EXA_ID AS EXAMINER_CODE,
	TSE.USERPIN AS TIMS_ID,
	TTP.FULLNAME AS EXAMINER_NAME,
	TTP.FATHERNAME AS FATHER_NAME,
	TTP.USERNAME AS USERNAME,
	TTP.USERPASS AS PASSWORD,
	TTP.EMAIL AS EMAIL,
	TTP.GENDER,
	TTP.HOME_PHONE AS PHONE,
	TTP.DOB,
	TTP.JOIN_DATE,
	TCL.COL_CODE AS COLLEGE_CODE,
	TCL.COL_NAME AS COLLEGE_NAME,
	TDG.DESIG_CODE AS DESIGNATION_CODE,
	TDG.DESIG_NAME AS DESIGNATION_NAME,
	TSE.EX_TYPE AS EXAMINER_TYPE,
	TSE.PERENT_EX_ID AS PAPER_TIMS_ID,
	TSE.NO_OF_SCRIPT AS NO_OF_SCRIPT,
	TTP.DIVISION_CODE,
	TTP.DISTRICT_CODE
FROM TMS_SCRIPT_EXAMINER TSE
JOIN TMS_TEACHER_PERSONAL TTP ON TTP.USERPIN = TSE.USERPIN
JOIN TMS_COLLEGEINFO TCL ON TTP.COL_ID = TCL.COL_ID
JOIN TMS_DESIGNATION TDG ON TDG.DESIG_ID = TTP.DESIG_CODE