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