Difference between revisions of "Current File Indexes"

From CrossRoad
Jump to: navigation, search
(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>IDCENT*1000000+STUDID</td>...)
 
(No difference)

Latest revision as of 00:56, 5 October 2009

TableIndexKey
MASTERMASTER.NTXENTCODE
MASTERMASTSTID.NTXIDCENT*1000000+STUDID
MASTERMASTNAME.NTXUPPER(PADR(ALLTRIM(SURNAME),20)+[ ]+PADR(ALLTRIM(FNAME),15)+[ ]+INITIAL)
LIAISONLIAISON.NTXENTCODE
LIAISONLIAISTID.NTXIDCENT*1000000+STUDID
LIAISONLIAINAME.NTXUPPER(SURNAME+FNAME+INITIAL)+DTOS(BIRTHDAY)
APPLICSAPPLICS.NTXENTCODE
REGISTERREGISTER.NTXIDCENT*1000000+STUDID
REGISTERREGENTCD.NTXENTCODE
REGISTERREGBARCD.NTXBARCODE
REGISTERREGMLBX.NTXMAILBOX
COURSESCOURSES.NTXCRSCODE
COURSESCRSNAME.NTXUPPER(PADR(LTRIM(TRIM(CRSDESC)),30))
COURSEDECOURSEDE.NTXCRSCODE
FORMERCRFORMERCR.NTXCRSCODE
FORMERCRFORMERC2.NTXFORMERCODE
SLISLI.NTXCRSCODE+SUBCODE
SLISLICRCD.NTXCRSCODE
CRSTRANSCRSTRANS.NTXIDCENT*1000000+STUDID
CRSTRANSCRSSTD.NTXYEAR+SESSION+UPPER(SURNAME)+STR(IDCENT,2,0)+STR(STUDID,6,0)
CRSTRANSCRSCRS.NTXYEAR+SESSION+CRSCODE+UPPER(SURNAME)+STR(IDCENT,2,0)+STR(STUDID,6,0)
ADVISORSADVISORS.NTXADVISOR
OLDADVISOLDADVIS.NTXADVISOR
ADVCREDADVCRED.NTXSTR(IDCENT,2,0)+STR(STUDID,6,0)+INST
STUDENTSSTUDENTS.NTXIDCENT*1000000+STUDID
STUDENTSSTUDTRAN.NTXSTR(IDCENT,2,0)+STR(STUDID,6,0)+YEAR+SESSION
LOANHISTLOANHIST.NTXentcode
SESSIONSSESS0001.NTXYEAR+SESSION+CRSCODE+SLI
SESSIONSSESS0002.NTXCRSCODE+SLI+YEAR+SESSION
SESSIONSSESS0003.NTXYEAR+SESSION+CRSCODE
SESSIONSSESS0004.NTXYEAR+SESSION+CRSCODE+SLI
ARCTXARCTX.NTXIDCENT*1000000+STUDID
PSECONDPSECOND.NTXUPPER(POSTSEC)
DENOMDENOM.NTXDENOM
TRANSFERTRAN0001.NTXEQUIV+STR(CREDIT,6,2)+INST+CRSCODE+YEAR
TRANSFERTRAN0002.NTXINST+CRSCODE+YEAR+EQUIV+STR(CREDIT,6,2)
PREVPSPREVPS.NTXSTR(ENTCODE,5,0)+YRS+INST
HSCHOOLHSCHOOL.NTXSCHOOL+SCHCITY
PROGRAMSPROGRAMS.NTXDEGREE+CONC
COUNTRYCOUNTRY.NTXUPPER(COUNTRY)
CODETABLCODETABL.NTXCODENAME
TRANTABLTRANTABL.NTXCODENAME
COMMENTSCOMMENTS.NTXCOMMCODE
DEADFILEDEADFILE.NTXSURNAME+FNAME
INITCREDINITCRED.NTXENTCODE
ROOMSROOMS.NTXROOMNUMBER
ROOMSROOMNAME.NTXUPPER(ROOMNAME)
ROOMSROOMCODE.NTXROOMCODE
WAITLISTWAIT0001.NTXYEAR+SESSION+CRSCODE+SLI+DTOS(ADDDATE)+ADDTIME+STR(IDCENT,2,0)+STR(STUDID,6,0)
WAITLISTWAIT0003.NTXYEAR+SESSION+STR(IDCENT,2,0)+STR(STUDID,6,0)
CONCCONC.NTXUPPER(CONC)
CRSTIMECRSTIME.NTXCRSCODE+SLI+SESSION
PERIODSPERIODS.NTXDOW+CODE
ACADSTATACADSTAT.NTXDEGREE+CONC1+CONC2+YRSTDY+STR(99-WEIGHT,2,0)
HSADMISHSADMIS.NTXSTR(ENTCODE,5,0)+COURSE
COMMLOGCOMM0001.NTXSTR(ENTCODE,5,0)+DTOS(DATE)+TIME
COMMLOGCOMM0002.NTXSTR(PROSPID,7,0)+DTOS(DATE)+TIME
XTRAXTRA.NTXENTCODE
CHURCHESCHURCHES.NTXHCHURCH+CITY+DENOM
FINAIDFINAID.NTXFINAIDID
FINAPPSFINA0001.NTXSTR(ENTCODE,5,0)+YEAR+STR(FINAIDID,5,0)
FINAPPSFINA0002.NTXSTR(ENTCODE,5,0)+STR(FINAIDID,5,0)+YEAR
FINAPPSFINA0003.NTXSTR(FINAIDID,5,0)+STR(ENTCODE,5,0)+YEAR
FINAPPSFINA0004.NTXSTR(FINAIDID,5,0)+YEAR+STR(ENTCODE,5,0)
FINAPPSFINA0005.NTXYEAR+STR(ENTCODE,5,0)+STR(FINAIDID,5,0)
FINAPPSFINA0006.NTXYEAR+STR(FINAIDID,5,0)+STR(ENTCODE,5,0)
SCHOLARSSCHOLARS.NTXENTCODE
IAPPLICSIAPPLICS.NTXENTCODE
MARKSYSMARK0001.NTXHOMEGRADE
MARKSYSMARK0002.NTXVALUEORDER
MARKSYSMARK0003.NTXVALIDSYS
WITHHELDWITHHELD.NTXREALSTUDID
LOCKOUTLOCKOUT.NTXENTCODE
INVLOGINVLOG.NTXstr(idcent,2,0)+str(studid,6,0)+yearterm+iif(exported,[A],[Z])+iif(type == [IN], [A], iif( type == [DN],[B],[C]))+dtos(invdate)+invtime
INVLOGINVLOG2.NTXSTR(ENTCODE,5,0)+YEARTERM+IIF(EXPORTED,[A],[Z])+IIF(TYPE == [IN], [A], IIF( TYPE == [DN],[B],[C]))+DTOS(INVDATE)+INVTIME
REZREZ.NTXENTCODE
REZROOMREZROOM.NTXROOM
GROUPSGROUPS.NTXUSER+NAME
ACCESSACCESS.NTXPOINT
SYLLABUSSYLLABUS.NTXYEAR+DEGREE+CONC1+CONC2+INDEXTAG+IF(STOPATLIM,[1],[9])
SYLLABU2SYLLABU2.NTXYEAR+DEGREE+CONC1+CONC2
CROSLISTCROSLIST.NTXCRSCODE
JOBSJOBS.NTXJOBID
JOBAPPSJOBA0001.NTXSTR(ENTCODE,5)+YEAR+STR(JOBID,5,0)
JOBAPPSJOBA0002.NTXSTR(JOBID,5,0)+YEAR+STR(ENTCODE,5,0)
JOBRESUMJOBRESUM.NTXENTCODE
QIFEESQIFEES.NTXFEENAME
QIDATESQIDATES.NTXDATE
QIDATFEEQIDATFEEFEENAME+dtos(DATE_ON)
ACADWARNACADWARN.NTXIDCENT*1000000+STUDID
BARCODESBARCODES.NTXIDCENT*1000000+STUDID
BARCODESBARCODE2.NTXIIF(STUDID = 0,[ZZZZZZ],[])+SURNAME+FNAME+iif(studid=0,[],[ZZZZZZ])
BARCODESBARCODE3.NTXENTCODE
EMPLEMPLENTC.NTXENTCODE
EMPLEMPLNAME.NTXUPPER(SURNAME)+UPPER(FNAME)
LABUSERLABUSER.NTXIDCENT*1000000+STUDID
LABUSERLABEMAIL.NTXEMAIL
ATTENDATTE0001.NTXyear+session+crscode+sli+str(idcent,2,0)+str(studid,6,0)+dtos(eventdate)+eventtime
ATTENDATTE0002.NTXstr(idcent,2,0)+str(studid,6,0)+year+session+crscode+sli+dtos(eventdate)+eventtime
ATTENDATTE0003.NTXYear+Session+CrsCode+SLI+dtos(Eventdate)+Eventtime
GBELEMGBELEM.NTXyear+session+crscode+sli+ELEMID
GBGRADEGBGR0001.NTXyear+session+crscode+sli+str(idcent,2,0)+str(studid,6,0)+ELEMID
GBGRADEGBGR0002.NTXstr(idcent,2,0)+str(studid,6,0)+year+session+crscode+sli+ELEMID
GBGRADEGBGR0003.NTXyear+session+crscode+sli+ELEMID+str(idcent,2,0)+str(studid,6,0)
QIRULESQIRULESyear+session+str(days,3,0)
STUPRGDTSTUP0001str(idcent,2,0)+str(studid,6,0)+year+session+dtos(startdate)
STUPRGDTSTUP0002year+session+dtos(startdate)+str(idcent,2,0)+str(studid,6,0)
VERSIONVERSIONcontrolpt
FINWINFINW0001STR(ENTCODE,5,0)+YEAR+STR(FINAIDID,5,0)
FINWINFINW0002STR(ENTCODE,5,0)+STR(FINAIDID,5,0)+YEAR
FINWINFINW0003STR(FINAIDID,5,0)+STR(ENTCODE,5,0)+YEAR
FINWINFINW0004STR(FINAIDID,5,0)+YEAR+STR(ENTCODE,5,0)
FINWINFINW0005YEAR+STR(ENTCODE,5,0)+STR(FINAIDID,5,0)
FINWINFINW0006YEAR+STR(FINAIDID,5,0)+STR(ENTCODE,5,0)
APPHISTAPPHISTRUNDATE
AUTHHISTAUTH0001.NTXLDCODE
AUTHHISTAUTH0002.NTXENTCODE
BANDBANDCODE.NTXBANDCODE
BANDBANDNAME.NTXBANDNAME
TRUBLSTTRUBLS2.NTXidcent*1000000+studid
TRUBLSTTRUBLST.NTXWEIGHT
WINACCESWINACCES.NTXPOINT
PWPW.NTXAPPL_ID
PWPWEMAIL.NTXUPPER(EMAIL)
ADAD.NTXAPPL_ID
BGBG.NTXAPPL_ID
EMEM.NTXAPPL_ID
FAPPITEMFAPPITEM.NTXAPPL_ID
FAPPLICSFAPPLICS.NTXAPPL_ID
FAPPNOTEFAPPNOTE.NTXAPPL_ID
FAPPCOSTFAPPCOST.NTXAPPL_ID
HSHS.NTXAPPL_ID
KUCKUC.NTXAPPL_ID
L30L30.NTXAPPL_ID
NMNM.NTXAPPL_ID
PSPS.NTXAPPL_ID
APPAPP.NTXAPPL_ID
REZAPPREZAPP.NTXAPPL_ID
HTMLFILEHTMLFILE.NTXUPPER(HTMLFILE)
RELFILERELFILE.NTXUPPER(RELFILE)
WEBAIDWEBAID.NTXTYPE+TYPESEQUEN
WEBAIDWEBAID2.NTXFINAIDID
HSDONEHSDONE.NTXENTCODE
HSTRANSCHSTRANSC.NTXENTCODE
KINGSCODKINGSCO2.NTXKINGSCODE
KINGSCODKINGSCOD.NTXCOURSECODE
KINGSNOTKINGSNO2.NTXKINGSCODE
KINGSNOTKINGSNOT.NTXCOURSECODE
MEALPLANMEALPLAN.NTXMEALPLAN
NONTEACHNONTEACH.NTXNONTEACH
PPCROSSPPCROSS.NTXCRSCODE
ROTATIONROTATION.NTXCRSCODE
LDDEPTLDDEPT.NTXEXTENSION
LDEXTLDEXT.NTXEXTENSION
LDEXTLDEXT2.NTXROOM
LDREPORTLDRE0001.NTXEXTENSION+DTOS(BILLDATE)+CALLTIME
LDREPORTLDRE0002.NTXDTOS(BILLDATE)+CALLTIME+EXTENSION
LDREPORTLDRE0003.NTXACCOUNT+DTOS(CALLDATE)+CALLTIME
COSTTABLCOSTTABL.NTXYEAR+DISP+LSADP
MEDICALMEDICAL.NTXentcode
AUTOAUTO.NTXentcode
STUSERVSTUSERV.NTXentcode
SDACONFSDACONF.NTXconfcode
ADMTESTADMTEST.NTXentcode
HONORSHONORS.NTXYRSTDY + STR(GPA,7,3) + SURNAME
REGPROGREGPROG.NTXentcode
WEBDATESWEBDATES.NTXdate
LOANSLOANS.NTXentcode
DISBURSDISBURS.NTXentcode
DISBHISTDISBHIST.NTXentcode
ASNCONFASNCONF.NTXentcode
PRSPHISTPRSPHIST.NTXprospid
CHAPELCHAPEL.NTXbarcode+dtos(chapeldate)
CHAPELCHAPEL2.NTXstr(idcent,2,0)+str(studid,6,0)+dtos(chapeldate)
MINORSMINORS.NTXDEGREE+MAJOR+MINOR
CCINVALCCINVAL.NTXcardnumber
SECTCOSTSECTCOS2.NTXidcent*1000000+studid
SECTCOSTSECTCOST.NTXDEGREE+CONC
RPTPARAMRPTPARAM.NTXREPORTNAME+USERNAME
CRSCHGCRSCHG.NTXcrscode
DOCANNODOCANNO.NTXstr(entcode,5,0)+str(docid,5,0)
DOCLISTDOCLIST.NTXstr(entcode,5,0)+str(docid,5,0)
DOCTYPESDOCTYPES.NTXdtcode
PAYMENTSPAYMENT1.NTXentcode
PAYMENTSPAYMENT2.NTXstr(entcode,5,0)+dtos(paydate)+paytime
CHKINBALCHKINBAL.NTXstr(entcode,5,0)+year+term
WORKFLOWWORK0001.NTXuser
WORKFLOWWORK0002.NTXsender
PSADDRPSADDR.NTXupper(postsec)
EXCEPTEXCEPT.NTXidcent*1000000+studid
T2202AT2202A.NTXidcent*1000000+studid
RESPONSERESPONSE.NTXORDER_ID
D2LCOURSD2LCOURS.NTXYEAR+TERM+CRSCODE
D2LSTDNTD2LSTDNT.NTXIDCENT*1000000+STUDID
AGEAPPAGEAPPdtos(appstartd)+appstartt
AGEAPPAGEAPP2APPL_ID
sourcessourcessource
clubsclub0001str(entcode,5,0)+club
clubsclub0002club+str(entcode,5,0)
Retrieved from "https://registry.kingsu.ca/mediawiki/index.php?title=Current_File_Indexes&oldid=454"