Archive File Indexes

From CrossRoad
Revision as of 01:00, 5 October 2009 by WikiSysop (talk | contribs) (New page: <table> <tr><th>Table</th><th>Index</th><th>Key</th></tr> <tr><td>ARCCRED</td><td>ARCCRED.NTX</td><td>STR(IDCENT,2,0)+STR(STUDID,6,0)+INST</td></tr> <tr><td>ARCCRS</td><td>ARCCID.NTX</td><...)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search
TableIndexKey
ARCCREDARCCRED.NTXSTR(IDCENT,2,0)+STR(STUDID,6,0)+INST
ARCCRSARCCID.NTXIDCENT*1000000+STUDID
ARCCRSARCCSTD.NTXYEAR+SESSION+STR(IDCENT,2,0)+STR(STUDID,6,0)
ARCCRSARCCRS.NTXYEAR+SESSION+CRSCODE+STR(IDCENT,2,0)+STR(STUDID,6,0)
ARCSTUDARCSTUD.NTXIDCENT*1000000+STUDID
ARCSTUDARCSTRA.NTXSTR(IDCENT,2,0)+STR(STUDID,6,0)+YEAR+SESSION
ARCMASTARCMID.NTXIDCENT*1000000+STUDID
ARCMASTARCMNAME.NTXUPPER(PADR(ALLTRIM(SURNAME),20)+[ ]+PADR(ALLTRIM(FNAME),15)+[ ]+INITIAL)
ARCMASTARCMENT.NTXENTCODE
ARCPPSARCPPS.NTXSTR(ENTCODE,5,0)+YRS+INST
ARCHSADARCHSAD.NTXSTR(ENTCODE,5,0)+COURSE
ARCCOMMARCCOMM.NTXSTR(ENTCODE,5,0)+DTOS(DATE)+TIME
ARCXTRAARCXTRA.NTXENTCODE
ARCSPDTARCSP001str(idcent,2,0)+str(studid,6,0)+year+session+dtos(startdate)
ARCSPDTARCSP002year+session+dtos(startdate)+str(idcent,2,0)+str(studid,6,0)
ARCTESTARCTESTentcode
ALUMPWALUMPW1IDCENT*1000000+STUDID
ALUMPWALUMPW2email
Retrieved from "https://registry.kingsu.ca/mediawiki/index.php?title=Archive_File_Indexes&oldid=455"