Archive File Indexes
From CrossRoad
| Table | Index | Key |
|---|---|---|
| ARCCRED | ARCCRED.NTX | STR(IDCENT,2,0)+STR(STUDID,6,0)+INST |
| ARCCRS | ARCCID.NTX | IDCENT*1000000+STUDID |
| ARCCRS | ARCCSTD.NTX | YEAR+SESSION+STR(IDCENT,2,0)+STR(STUDID,6,0) |
| ARCCRS | ARCCRS.NTX | YEAR+SESSION+CRSCODE+STR(IDCENT,2,0)+STR(STUDID,6,0) |
| ARCSTUD | ARCSTUD.NTX | IDCENT*1000000+STUDID |
| ARCSTUD | ARCSTRA.NTX | STR(IDCENT,2,0)+STR(STUDID,6,0)+YEAR+SESSION |
| ARCMAST | ARCMID.NTX | IDCENT*1000000+STUDID |
| ARCMAST | ARCMNAME.NTX | UPPER(PADR(ALLTRIM(SURNAME),20)+[ ]+PADR(ALLTRIM(FNAME),15)+[ ]+INITIAL) |
| ARCMAST | ARCMENT.NTX | ENTCODE |
| ARCPPS | ARCPPS.NTX | STR(ENTCODE,5,0)+YRS+INST |
| ARCHSAD | ARCHSAD.NTX | STR(ENTCODE,5,0)+COURSE |
| ARCCOMM | ARCCOMM.NTX | STR(ENTCODE,5,0)+DTOS(DATE)+TIME |
| ARCXTRA | ARCXTRA.NTX | ENTCODE |
| ARCSPDT | ARCSP001 | str(idcent,2,0)+str(studid,6,0)+year+session+dtos(startdate) |
| ARCSPDT | ARCSP002 | year+session+dtos(startdate)+str(idcent,2,0)+str(studid,6,0) |
| ARCTEST | ARCTEST | entcode |
| ALUMPW | ALUMPW1 | IDCENT*1000000+STUDID |
| ALUMPW | ALUMPW2 |
