<DBXML> <TABLE name="MCANDIDATERE" status="center" central="true" out="inquiry" > <FIELD>APPLICANTID</FIELD> <FIELD>REQUESTID</FIELD> <FIELD>COMPANYID</FIELD> <FIELD>CANDIDATESTATUS</FIELD> <FIELD>JOINDATE</FIELD> <FIELD>STOPDATE</FIELD> <FIELD>RESULT</FIELD> <FIELD>SCORE</FIELD> <ORDER> <FIELD>COMPANYID</FIELD> <FIELD>APPLICANTID</FIELD> <FIELD>REQUESTID</FIELD> </ORDER> </TABLE> <TABLE name="MAPPLICANT" status="center" central="false" out="inquiry"> <FIELD>APPLICANTID</FIELD> <FIELD>COMPANYID</FIELD> <FIELD>EMPLOYEEID</FIELD> <FIELD>PREFIX</FIELD> <FIELD>FNAME</FIELD> <FIELD>LNAME</FIELD> <FIELD>EFNAME</FIELD> <FIELD>ELNAME</FIELD> <FIELD>EMAIL</FIELD> <FIELD>TEL_NO</FIELD> <FIELD>MOBILE</FIELD> <FIELD>EXP_STARTDATE</FIELD> <FIELD>APPLICANTSTATUS</FIELD> <FIELD>REFEREE1POSITIONID</FIELD> <FIELD>REFEREE2POSITIONID</FIELD> <FIELD>FREETEXTJOB</FIELD> <FIELD>INSTITUTEID1</FIELD> <FIELD>INSTITUTEID2</FIELD> <FIELD>INSTITUTEID3</FIELD> <FIELD>INSTITUTEID4</FIELD> <FIELD>INSTITUTEID5</FIELD> <!-- EDU_STARTYEAR --> <FIELD>EDU_STARTYEAR1</FIELD> <FIELD>EDU_STARTYEAR2</FIELD> <FIELD>EDU_STARTYEAR3</FIELD> <FIELD>EDU_STARTYEAR4</FIELD> <FIELD>EDU_STARTYEAR5</FIELD> <!-- EDU_ENDYEAR --> <FIELD>EDU_ENDYEAR1</FIELD> <FIELD>EDU_ENDYEAR2</FIELD> <FIELD>EDU_ENDYEAR3</FIELD> <FIELD>EDU_ENDYEAR4</FIELD> <FIELD>EDU_ENDYEAR5</FIELD> <!-- FACULTYID --> <FIELD>FACULTYID1</FIELD> <FIELD>FACULTYID2</FIELD> <FIELD>FACULTYID3</FIELD> <FIELD>FACULTYID4</FIELD> <FIELD>FACULTYID5</FIELD> <!-- BACKGROUNDID --> <FIELD>BACKGROUNDID1</FIELD> <FIELD>BACKGROUNDID2</FIELD> <FIELD>BACKGROUNDID3</FIELD> <FIELD>BACKGROUNDID4</FIELD> <FIELD>BACKGROUNDID5</FIELD> <!-- MAJORID --> <FIELD>MAJORID1</FIELD> <FIELD>MAJORID2</FIELD> <FIELD>MAJORID3</FIELD> <FIELD>MAJORID4</FIELD> <FIELD>MAJORID5</FIELD> <!-- GPA --> <FIELD>GPA1</FIELD> <FIELD>GPA2</FIELD> <FIELD>GPA3</FIELD> <FIELD>GPA4</FIELD> <FIELD>GPA5</FIELD> <!-- DEGREEID --> <FIELD>DEGREEID1</FIELD> <FIELD>DEGREEID2</FIELD> <FIELD>DEGREEID3</FIELD> <FIELD>DEGREEID4</FIELD> <FIELD>DEGREEID5</FIELD> <ORDER> <FIELD>APPLICANTID</FIELD> </ORDER> </TABLE> <TABLE name="V1MJOBCODE" status="center" central="MAPPLICANT" out="inquiry"> <FIELD>JOBCODEID</FIELD> <FIELD>TDESC</FIELD> <FIELD>EDESC</FIELD> <FIELD>COMPANYID</FIELD> <ORDER> <FIELD>COMPANYID</FIELD> <FIELD>JOBCODEID</FIELD> </ORDER> </TABLE> <TABLE name="MPREFIX" status="" central="MAPPLICANT" out="inquiry"> <FIELD>PREFIXID</FIELD> <FIELD>TDESC</FIELD> <FIELD>EDESC</FIELD> <ORDER> <FIELD>PREFIXID</FIELD> </ORDER> </TABLE> <TABLE name="MDEGREE" status="center" central="MAPPLICANT" out="inquiry"> <FIELD>DEGREEID</FIELD> <FIELD>TDESC</FIELD> <FIELD>EDESC</FIELD> <ORDER> <FIELD>DEGREEID</FIELD> </ORDER> </TABLE> <TABLE name="MMAJOR" status="center" central="MAPPLICANT" out="inquiry"> <FIELD>MAJORID</FIELD> <FIELD>TDESC</FIELD> <FIELD>EDESC</FIELD> <ORDER> <FIELD>MAJORID</FIELD> </ORDER> </TABLE> <TABLE name="MAPPOINTMENT" status="center" central="false" out="inquiry" > <FIELD>APPLICANTID</FIELD> <FIELD>REQUESTID</FIELD> <FIELD>COMPANYID</FIELD> <FIELD>INTERVIEWDATE</FIELD> <FIELD>INTERVIEWTIME</FIELD> <FIELD>INTERVIEWROOM</FIELD> <FIELD>INTERVIEWPLACE</FIELD> <FIELD>COMMENTS</FIELD> <FIELD>INTERVIEWSTATUS</FIELD> <ORDER> <FIELD>APPLICANTID</FIELD> <FIELD>REQUESTID</FIELD> </ORDER> </TABLE> <TABLE name="MREQUEST" status="center" central="false" out="inquiry"> <FIELD>REQUESTID</FIELD> <FIELD>COMPANYID</FIELD> <FIELD>POSITIONID</FIELD> <FIELD>JOBID</FIELD> <ORDER> <FIELD>REQUESTID</FIELD> </ORDER> </TABLE> <TABLE name="MJOBCODE" status="center" central="MREQUEST" out="inquiry"> <FIELD>JOBCODEID</FIELD> <FIELD>TDESC</FIELD> <FIELD>EDESC</FIELD> <FIELD>COMPANYID</FIELD> <ORDER> <FIELD>COMPANYID</FIELD> <FIELD>JOBCODEID</FIELD> </ORDER> </TABLE> <TABLE name="MPOSITION" status="" central="MREQUEST" out="inquiry"> <FIELD>POSITIONID</FIELD> <FIELD>COMPANYID</FIELD> <FIELD>TDESC</FIELD> <FIELD>EDESC</FIELD> <ORDER> <FIELD>POSITIONID</FIELD> </ORDER> </TABLE> </DBXML>