Current File Indexes - Revision history

WikiSysop: New page: ...
2009-10-05T00:56:08Z
New page: <table> <tr><th>Table</th><th>Index</th><th>Key</th></tr> <tr><td>MASTER</td><td>MASTER.NTX</td><td>ENTCODE</td></tr> <tr><td>MASTER</td><td>MASTSTID.NTX</td><td>IDCENT1000000+STUDID</td>...
New page
<table>
<tr><th>Table</th><th>Index</th><th>Key</th></tr>
<tr><td>MASTER</td><td>MASTER.NTX</td><td>ENTCODE</td></tr>
<tr><td>MASTER</td><td>MASTSTID.NTX</td><td>IDCENT1000000+STUDID</td></tr>
<tr><td>MASTER</td><td>MASTNAME.NTX</td><td>UPPER(PADR(ALLTRIM(SURNAME),20)+[ ]+PADR(ALLTRIM(FNAME),15)+[ ]+INITIAL)</td></tr>
<tr><td>LIAISON</td><td>LIAISON.NTX</td><td>ENTCODE</td></tr>
<tr><td>LIAISON</td><td>LIAISTID.NTX</td><td>IDCENT1000000+STUDID</td></tr>
<tr><td>LIAISON</td><td>LIAINAME.NTX</td><td>UPPER(SURNAME+FNAME+INITIAL)+DTOS(BIRTHDAY)</td></tr>
<tr><td>APPLICS</td><td>APPLICS.NTX</td><td>ENTCODE</td></tr>
<tr><td>REGISTER</td><td>REGISTER.NTX</td><td>IDCENT1000000+STUDID</td></tr>
<tr><td>REGISTER</td><td>REGENTCD.NTX</td><td>ENTCODE</td></tr>
<tr><td>REGISTER</td><td>REGBARCD.NTX</td><td>BARCODE</td></tr>
<tr><td>REGISTER</td><td>REGMLBX.NTX</td><td>MAILBOX</td></tr>
<tr><td>COURSES</td><td>COURSES.NTX</td><td>CRSCODE</td></tr>
<tr><td>COURSES</td><td>CRSNAME.NTX</td><td>UPPER(PADR(LTRIM(TRIM(CRSDESC)),30))</td></tr>
<tr><td>COURSEDE</td><td>COURSEDE.NTX</td><td>CRSCODE</td></tr>
<tr><td>FORMERCR</td><td>FORMERCR.NTX</td><td>CRSCODE</td></tr>
<tr><td>FORMERCR</td><td>FORMERC2.NTX</td><td>FORMERCODE</td></tr>
<tr><td>SLI</td><td>SLI.NTX</td><td>CRSCODE+SUBCODE</td></tr>
<tr><td>SLI</td><td>SLICRCD.NTX</td><td>CRSCODE</td></tr>
<tr><td>CRSTRANS</td><td>CRSTRANS.NTX</td><td>IDCENT1000000+STUDID</td></tr>
<tr><td>CRSTRANS</td><td>CRSSTD.NTX</td><td>YEAR+SESSION+UPPER(SURNAME)+STR(IDCENT,2,0)+STR(STUDID,6,0)</td></tr>
<tr><td>CRSTRANS</td><td>CRSCRS.NTX</td><td>YEAR+SESSION+CRSCODE+UPPER(SURNAME)+STR(IDCENT,2,0)+STR(STUDID,6,0)</td></tr>
<tr><td>ADVISORS</td><td>ADVISORS.NTX</td><td>ADVISOR</td></tr>
<tr><td>OLDADVIS</td><td>OLDADVIS.NTX</td><td>ADVISOR</td></tr>
<tr><td>ADVCRED</td><td>ADVCRED.NTX</td><td>STR(IDCENT,2,0)+STR(STUDID,6,0)+INST</td></tr>
<tr><td>STUDENTS</td><td>STUDENTS.NTX</td><td>IDCENT1000000+STUDID</td></tr>
<tr><td>STUDENTS</td><td>STUDTRAN.NTX</td><td>STR(IDCENT,2,0)+STR(STUDID,6,0)+YEAR+SESSION</td></tr>
<tr><td>LOANHIST</td><td>LOANHIST.NTX</td><td>entcode</td></tr>
<tr><td>SESSIONS</td><td>SESS0001.NTX</td><td>YEAR+SESSION+CRSCODE+SLI</td></tr>
<tr><td>SESSIONS</td><td>SESS0002.NTX</td><td>CRSCODE+SLI+YEAR+SESSION</td></tr>
<tr><td>SESSIONS</td><td>SESS0003.NTX</td><td>YEAR+SESSION+CRSCODE</td></tr>
<tr><td>SESSIONS</td><td>SESS0004.NTX</td><td>YEAR+SESSION+CRSCODE+SLI</td></tr>
<tr><td>ARCTX</td><td>ARCTX.NTX</td><td>IDCENT1000000+STUDID</td></tr>
<tr><td>PSECOND</td><td>PSECOND.NTX</td><td>UPPER(POSTSEC)</td></tr>
<tr><td>DENOM</td><td>DENOM.NTX</td><td>DENOM</td></tr>
<tr><td>TRANSFER</td><td>TRAN0001.NTX</td><td>EQUIV+STR(CREDIT,6,2)+INST+CRSCODE+YEAR</td></tr>
<tr><td>TRANSFER</td><td>TRAN0002.NTX</td><td>INST+CRSCODE+YEAR+EQUIV+STR(CREDIT,6,2)</td></tr>
<tr><td>PREVPS</td><td>PREVPS.NTX</td><td>STR(ENTCODE,5,0)+YRS+INST</td></tr>
<tr><td>HSCHOOL</td><td>HSCHOOL.NTX</td><td>SCHOOL+SCHCITY</td></tr>
<tr><td>PROGRAMS</td><td>PROGRAMS.NTX</td><td>DEGREE+CONC</td></tr>
<tr><td>COUNTRY</td><td>COUNTRY.NTX</td><td>UPPER(COUNTRY)</td></tr>
<tr><td>CODETABL</td><td>CODETABL.NTX</td><td>CODENAME</td></tr>
<tr><td>TRANTABL</td><td>TRANTABL.NTX</td><td>CODENAME</td></tr>
<tr><td>COMMENTS</td><td>COMMENTS.NTX</td><td>COMMCODE</td></tr>
<tr><td>DEADFILE</td><td>DEADFILE.NTX</td><td>SURNAME+FNAME</td></tr>
<tr><td>INITCRED</td><td>INITCRED.NTX</td><td>ENTCODE</td></tr>
<tr><td>ROOMS</td><td>ROOMS.NTX</td><td>ROOMNUMBER</td></tr>
<tr><td>ROOMS</td><td>ROOMNAME.NTX</td><td>UPPER(ROOMNAME)</td></tr>
<tr><td>ROOMS</td><td>ROOMCODE.NTX</td><td>ROOMCODE</td></tr>
<tr><td>WAITLIST</td><td>WAIT0001.NTX</td><td>YEAR+SESSION+CRSCODE+SLI+DTOS(ADDDATE)+ADDTIME+STR(IDCENT,2,0)+STR(STUDID,6,0)</td></tr>
<tr><td>WAITLIST</td><td>WAIT0003.NTX</td><td>YEAR+SESSION+STR(IDCENT,2,0)+STR(STUDID,6,0)</td></tr>
<tr><td>CONC</td><td>CONC.NTX</td><td>UPPER(CONC)</td></tr>
<tr><td>CRSTIME</td><td>CRSTIME.NTX</td><td>CRSCODE+SLI+SESSION</td></tr>
<tr><td>PERIODS</td><td>PERIODS.NTX</td><td>DOW+CODE</td></tr>
<tr><td>ACADSTAT</td><td>ACADSTAT.NTX</td><td>DEGREE+CONC1+CONC2+YRSTDY+STR(99-WEIGHT,2,0)</td></tr>
<tr><td>HSADMIS</td><td>HSADMIS.NTX</td><td>STR(ENTCODE,5,0)+COURSE</td></tr>
<tr><td>COMMLOG</td><td>COMM0001.NTX</td><td>STR(ENTCODE,5,0)+DTOS(DATE)+TIME</td></tr>
<tr><td>COMMLOG</td><td>COMM0002.NTX</td><td>STR(PROSPID,7,0)+DTOS(DATE)+TIME</td></tr>
<tr><td>XTRA</td><td>XTRA.NTX</td><td>ENTCODE</td></tr>
<tr><td>CHURCHES</td><td>CHURCHES.NTX</td><td>HCHURCH+CITY+DENOM</td></tr>
<tr><td>FINAID</td><td>FINAID.NTX</td><td>FINAIDID</td></tr>
<tr><td>FINAPPS</td><td>FINA0001.NTX</td><td>STR(ENTCODE,5,0)+YEAR+STR(FINAIDID,5,0)</td></tr>
<tr><td>FINAPPS</td><td>FINA0002.NTX</td><td>STR(ENTCODE,5,0)+STR(FINAIDID,5,0)+YEAR</td></tr>
<tr><td>FINAPPS</td><td>FINA0003.NTX</td><td>STR(FINAIDID,5,0)+STR(ENTCODE,5,0)+YEAR</td></tr>
<tr><td>FINAPPS</td><td>FINA0004.NTX</td><td>STR(FINAIDID,5,0)+YEAR+STR(ENTCODE,5,0)</td></tr>
<tr><td>FINAPPS</td><td>FINA0005.NTX</td><td>YEAR+STR(ENTCODE,5,0)+STR(FINAIDID,5,0)</td></tr>
<tr><td>FINAPPS</td><td>FINA0006.NTX</td><td>YEAR+STR(FINAIDID,5,0)+STR(ENTCODE,5,0)</td></tr>
<tr><td>SCHOLARS</td><td>SCHOLARS.NTX</td><td>ENTCODE</td></tr>
<tr><td>IAPPLICS</td><td>IAPPLICS.NTX</td><td>ENTCODE</td></tr>
<tr><td>MARKSYS</td><td>MARK0001.NTX</td><td>HOMEGRADE</td></tr>
<tr><td>MARKSYS</td><td>MARK0002.NTX</td><td>VALUEORDER</td></tr>
<tr><td>MARKSYS</td><td>MARK0003.NTX</td><td>VALIDSYS</td></tr>
<tr><td>WITHHELD</td><td>WITHHELD.NTX</td><td>REALSTUDID</td></tr>
<tr><td>LOCKOUT</td><td>LOCKOUT.NTX</td><td>ENTCODE</td></tr>
<tr><td>INVLOG</td><td>INVLOG.NTX</td><td>str(idcent,2,0)+str(studid,6,0)+yearterm+iif(exported,[A],[Z])+iif(type == [IN], [A], iif( type == [DN],[B],[C]))+dtos(invdate)+invtime</td></tr>
<tr><td>INVLOG</td><td>INVLOG2.NTX</td><td>STR(ENTCODE,5,0)+YEARTERM+IIF(EXPORTED,[A],[Z])+IIF(TYPE == [IN], [A], IIF( TYPE == [DN],[B],[C]))+DTOS(INVDATE)+INVTIME</td></tr>
<tr><td>REZ</td><td>REZ.NTX</td><td>ENTCODE</td></tr>
<tr><td>REZROOM</td><td>REZROOM.NTX</td><td>ROOM</td></tr>
<tr><td>GROUPS</td><td>GROUPS.NTX</td><td>USER+NAME</td></tr>
<tr><td>ACCESS</td><td>ACCESS.NTX</td><td>POINT</td></tr>
<tr><td>SYLLABUS</td><td>SYLLABUS.NTX</td><td>YEAR+DEGREE+CONC1+CONC2+INDEXTAG+IF(STOPATLIM,[1],[9])</td></tr>
<tr><td>SYLLABU2</td><td>SYLLABU2.NTX</td><td>YEAR+DEGREE+CONC1+CONC2</td></tr>
<tr><td>CROSLIST</td><td>CROSLIST.NTX</td><td>CRSCODE</td></tr>
<tr><td>JOBS</td><td>JOBS.NTX</td><td>JOBID</td></tr>
<tr><td>JOBAPPS</td><td>JOBA0001.NTX</td><td>STR(ENTCODE,5)+YEAR+STR(JOBID,5,0)</td></tr>
<tr><td>JOBAPPS</td><td>JOBA0002.NTX</td><td>STR(JOBID,5,0)+YEAR+STR(ENTCODE,5,0)</td></tr>
<tr><td>JOBRESUM</td><td>JOBRESUM.NTX</td><td>ENTCODE</td></tr>
<tr><td>QIFEES</td><td>QIFEES.NTX</td><td>FEENAME</td></tr>
<tr><td>QIDATES</td><td>QIDATES.NTX</td><td>DATE</td></tr>
<tr><td>QIDATFEE</td><td>QIDATFEE</td><td>FEENAME+dtos(DATE_ON)</td></tr>
<tr><td>ACADWARN</td><td>ACADWARN.NTX</td><td>IDCENT1000000+STUDID</td></tr>
<tr><td>BARCODES</td><td>BARCODES.NTX</td><td>IDCENT1000000+STUDID</td></tr>
<tr><td>BARCODES</td><td>BARCODE2.NTX</td><td>IIF(STUDID = 0,[ZZZZZZ],[])+SURNAME+FNAME+iif(studid=0,[],[ZZZZZZ])</td></tr>
<tr><td>BARCODES</td><td>BARCODE3.NTX</td><td>ENTCODE</td></tr>
<tr><td>EMPL</td><td>EMPLENTC.NTX</td><td>ENTCODE</td></tr>
<tr><td>EMPL</td><td>EMPLNAME.NTX</td><td>UPPER(SURNAME)+UPPER(FNAME)</td></tr>
<tr><td>LABUSER</td><td>LABUSER.NTX</td><td>IDCENT1000000+STUDID</td></tr>
<tr><td>LABUSER</td><td>LABEMAIL.NTX</td><td>EMAIL</td></tr>
<tr><td>ATTEND</td><td>ATTE0001.NTX</td><td>year+session+crscode+sli+str(idcent,2,0)+str(studid,6,0)+dtos(eventdate)+eventtime</td></tr>
<tr><td>ATTEND</td><td>ATTE0002.NTX</td><td>str(idcent,2,0)+str(studid,6,0)+year+session+crscode+sli+dtos(eventdate)+eventtime</td></tr>
<tr><td>ATTEND</td><td>ATTE0003.NTX</td><td>Year+Session+CrsCode+SLI+dtos(Eventdate)+Eventtime</td></tr>
<tr><td>GBELEM</td><td>GBELEM.NTX</td><td>year+session+crscode+sli+ELEMID</td></tr>
<tr><td>GBGRADE</td><td>GBGR0001.NTX</td><td>year+session+crscode+sli+str(idcent,2,0)+str(studid,6,0)+ELEMID</td></tr>
<tr><td>GBGRADE</td><td>GBGR0002.NTX</td><td>str(idcent,2,0)+str(studid,6,0)+year+session+crscode+sli+ELEMID</td></tr>
<tr><td>GBGRADE</td><td>GBGR0003.NTX</td><td>year+session+crscode+sli+ELEMID+str(idcent,2,0)+str(studid,6,0)</td></tr>
<tr><td>QIRULES</td><td>QIRULES</td><td>year+session+str(days,3,0)</td></tr>
<tr><td>STUPRGDT</td><td>STUP0001</td><td>str(idcent,2,0)+str(studid,6,0)+year+session+dtos(startdate)</td></tr>
<tr><td>STUPRGDT</td><td>STUP0002</td><td>year+session+dtos(startdate)+str(idcent,2,0)+str(studid,6,0)</td></tr>
<tr><td>VERSION</td><td>VERSION</td><td>controlpt</td></tr>
<tr><td>FINWIN</td><td>FINW0001</td><td>STR(ENTCODE,5,0)+YEAR+STR(FINAIDID,5,0)</td></tr>
<tr><td>FINWIN</td><td>FINW0002</td><td>STR(ENTCODE,5,0)+STR(FINAIDID,5,0)+YEAR</td></tr>
<tr><td>FINWIN</td><td>FINW0003</td><td>STR(FINAIDID,5,0)+STR(ENTCODE,5,0)+YEAR</td></tr>
<tr><td>FINWIN</td><td>FINW0004</td><td>STR(FINAIDID,5,0)+YEAR+STR(ENTCODE,5,0)</td></tr>
<tr><td>FINWIN</td><td>FINW0005</td><td>YEAR+STR(ENTCODE,5,0)+STR(FINAIDID,5,0)</td></tr>
<tr><td>FINWIN</td><td>FINW0006</td><td>YEAR+STR(FINAIDID,5,0)+STR(ENTCODE,5,0)</td></tr>
<tr><td>APPHIST</td><td>APPHIST</td><td>RUNDATE</td></tr>
<tr><td>AUTHHIST</td><td>AUTH0001.NTX</td><td>LDCODE</td></tr>
<tr><td>AUTHHIST</td><td>AUTH0002.NTX</td><td>ENTCODE</td></tr>
<tr><td>BAND</td><td>BANDCODE.NTX</td><td>BANDCODE</td></tr>
<tr><td>BAND</td><td>BANDNAME.NTX</td><td>BANDNAME</td></tr>
<tr><td>TRUBLST</td><td>TRUBLS2.NTX</td><td>idcent1000000+studid</td></tr>
<tr><td>TRUBLST</td><td>TRUBLST.NTX</td><td>WEIGHT</td></tr>
<tr><td>WINACCES</td><td>WINACCES.NTX</td><td>POINT</td></tr>
<tr><td>PW</td><td>PW.NTX</td><td>APPL_ID</td></tr>
<tr><td>PW</td><td>PWEMAIL.NTX</td><td>UPPER(EMAIL)</td></tr>
<tr><td>AD</td><td>AD.NTX</td><td>APPL_ID</td></tr>
<tr><td>BG</td><td>BG.NTX</td><td>APPL_ID</td></tr>
<tr><td>EM</td><td>EM.NTX</td><td>APPL_ID</td></tr>
<tr><td>FAPPITEM</td><td>FAPPITEM.NTX</td><td>APPL_ID</td></tr>
<tr><td>FAPPLICS</td><td>FAPPLICS.NTX</td><td>APPL_ID</td></tr>
<tr><td>FAPPNOTE</td><td>FAPPNOTE.NTX</td><td>APPL_ID</td></tr>
<tr><td>FAPPCOST</td><td>FAPPCOST.NTX</td><td>APPL_ID</td></tr>
<tr><td>HS</td><td>HS.NTX</td><td>APPL_ID</td></tr>
<tr><td>KUC</td><td>KUC.NTX</td><td>APPL_ID</td></tr>
<tr><td>L30</td><td>L30.NTX</td><td>APPL_ID</td></tr>
<tr><td>NM</td><td>NM.NTX</td><td>APPL_ID</td></tr>
<tr><td>PS</td><td>PS.NTX</td><td>APPL_ID</td></tr>
<tr><td>APP</td><td>APP.NTX</td><td>APPL_ID</td></tr>
<tr><td>REZAPP</td><td>REZAPP.NTX</td><td>APPL_ID</td></tr>
<tr><td>HTMLFILE</td><td>HTMLFILE.NTX</td><td>UPPER(HTMLFILE)</td></tr>
<tr><td>RELFILE</td><td>RELFILE.NTX</td><td>UPPER(RELFILE)</td></tr>
<tr><td>WEBAID</td><td>WEBAID.NTX</td><td>TYPE+TYPESEQUEN</td></tr>
<tr><td>WEBAID</td><td>WEBAID2.NTX</td><td>FINAIDID</td></tr>
<tr><td>HSDONE</td><td>HSDONE.NTX</td><td>ENTCODE</td></tr>
<tr><td>HSTRANSC</td><td>HSTRANSC.NTX</td><td>ENTCODE</td></tr>
<tr><td>KINGSCOD</td><td>KINGSCO2.NTX</td><td>KINGSCODE</td></tr>
<tr><td>KINGSCOD</td><td>KINGSCOD.NTX</td><td>COURSECODE</td></tr>
<tr><td>KINGSNOT</td><td>KINGSNO2.NTX</td><td>KINGSCODE</td></tr>
<tr><td>KINGSNOT</td><td>KINGSNOT.NTX</td><td>COURSECODE</td></tr>
<tr><td>MEALPLAN</td><td>MEALPLAN.NTX</td><td>MEALPLAN</td></tr>
<tr><td>NONTEACH</td><td>NONTEACH.NTX</td><td>NONTEACH</td></tr>
<tr><td>PPCROSS</td><td>PPCROSS.NTX</td><td>CRSCODE</td></tr>
<tr><td>ROTATION</td><td>ROTATION.NTX</td><td>CRSCODE</td></tr>
<tr><td>LDDEPT</td><td>LDDEPT.NTX</td><td>EXTENSION</td></tr>
<tr><td>LDEXT</td><td>LDEXT.NTX</td><td>EXTENSION</td></tr>
<tr><td>LDEXT</td><td>LDEXT2.NTX</td><td>ROOM</td></tr>
<tr><td>LDREPORT</td><td>LDRE0001.NTX</td><td>EXTENSION+DTOS(BILLDATE)+CALLTIME</td></tr>
<tr><td>LDREPORT</td><td>LDRE0002.NTX</td><td>DTOS(BILLDATE)+CALLTIME+EXTENSION</td></tr>
<tr><td>LDREPORT</td><td>LDRE0003.NTX</td><td>ACCOUNT+DTOS(CALLDATE)+CALLTIME</td></tr>
<tr><td>COSTTABL</td><td>COSTTABL.NTX</td><td>YEAR+DISP+LSADP</td></tr>
<tr><td>MEDICAL</td><td>MEDICAL.NTX</td><td>entcode</td></tr>
<tr><td>AUTO</td><td>AUTO.NTX</td><td>entcode</td></tr>
<tr><td>STUSERV</td><td>STUSERV.NTX</td><td>entcode</td></tr>
<tr><td>SDACONF</td><td>SDACONF.NTX</td><td>confcode</td></tr>
<tr><td>ADMTEST</td><td>ADMTEST.NTX</td><td>entcode</td></tr>
<tr><td>HONORS</td><td>HONORS.NTX</td><td>YRSTDY + STR(GPA,7,3) + SURNAME</td></tr>
<tr><td>REGPROG</td><td>REGPROG.NTX</td><td>entcode</td></tr>
<tr><td>WEBDATES</td><td>WEBDATES.NTX</td><td>date</td></tr>
<tr><td>LOANS</td><td>LOANS.NTX</td><td>entcode</td></tr>
<tr><td>DISBURS</td><td>DISBURS.NTX</td><td>entcode</td></tr>
<tr><td>DISBHIST</td><td>DISBHIST.NTX</td><td>entcode</td></tr>
<tr><td>ASNCONF</td><td>ASNCONF.NTX</td><td>entcode</td></tr>
<tr><td>PRSPHIST</td><td>PRSPHIST.NTX</td><td>prospid</td></tr>
<tr><td>CHAPEL</td><td>CHAPEL.NTX</td><td>barcode+dtos(chapeldate)</td></tr>
<tr><td>CHAPEL</td><td>CHAPEL2.NTX</td><td>str(idcent,2,0)+str(studid,6,0)+dtos(chapeldate)</td></tr>
<tr><td>MINORS</td><td>MINORS.NTX</td><td>DEGREE+MAJOR+MINOR</td></tr>
<tr><td>CCINVAL</td><td>CCINVAL.NTX</td><td>cardnumber</td></tr>
<tr><td>SECTCOST</td><td>SECTCOS2.NTX</td><td>idcent1000000+studid</td></tr>
<tr><td>SECTCOST</td><td>SECTCOST.NTX</td><td>DEGREE+CONC</td></tr>
<tr><td>RPTPARAM</td><td>RPTPARAM.NTX</td><td>REPORTNAME+USERNAME</td></tr>
<tr><td>CRSCHG</td><td>CRSCHG.NTX</td><td>crscode</td></tr>
<tr><td>DOCANNO</td><td>DOCANNO.NTX</td><td>str(entcode,5,0)+str(docid,5,0)</td></tr>
<tr><td>DOCLIST</td><td>DOCLIST.NTX</td><td>str(entcode,5,0)+str(docid,5,0)</td></tr>
<tr><td>DOCTYPES</td><td>DOCTYPES.NTX</td><td>dtcode</td></tr>
<tr><td>PAYMENTS</td><td>PAYMENT1.NTX</td><td>entcode</td></tr>
<tr><td>PAYMENTS</td><td>PAYMENT2.NTX</td><td>str(entcode,5,0)+dtos(paydate)+paytime</td></tr>
<tr><td>CHKINBAL</td><td>CHKINBAL.NTX</td><td>str(entcode,5,0)+year+term</td></tr>
<tr><td>WORKFLOW</td><td>WORK0001.NTX</td><td>user</td></tr>
<tr><td>WORKFLOW</td><td>WORK0002.NTX</td><td>sender</td></tr>
<tr><td>PSADDR</td><td>PSADDR.NTX</td><td>upper(postsec)</td></tr>
<tr><td>EXCEPT</td><td>EXCEPT.NTX</td><td>idcent1000000+studid</td></tr>
<tr><td>T2202A</td><td>T2202A.NTX</td><td>idcent1000000+studid</td></tr>
<tr><td>RESPONSE</td><td>RESPONSE.NTX</td><td>ORDER_ID</td></tr>
<tr><td>D2LCOURS</td><td>D2LCOURS.NTX</td><td>YEAR+TERM+CRSCODE</td></tr>
<tr><td>D2LSTDNT</td><td>D2LSTDNT.NTX</td><td>IDCENT1000000+STUDID</td></tr>
<tr><td>AGEAPP</td><td>AGEAPP</td><td>dtos(appstartd)+appstartt</td></tr>
<tr><td>AGEAPP</td><td>AGEAPP2</td><td>APPL_ID</td></tr>
<tr><td>sources</td><td>sources</td><td>source</td></tr>
<tr><td>clubs</td><td>club0001</td><td>str(entcode,5,0)+club</td></tr>
<tr><td>clubs</td><td>club0002</td><td>club+str(entcode,5,0)</td></tr>
</table>

Table Index Key

MASTER MASTER.NTX ENTCODE

MASTER MASTSTID.NTX IDCENT1000000+STUDID