Difference between revisions of "Data Structures"

From CrossRoad
Jump to: navigation, search
 
(3 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
This page lists the various datatables used in CrossRoad with links to pages of their structures. The tables should be accessed only by those who have been authorized to do so by Keeler Services.
 
This page lists the various datatables used in CrossRoad with links to pages of their structures. The tables should be accessed only by those who have been authorized to do so by Keeler Services.
  
[[ACADSTAT Structure]]
+
== Structures ==
 +
<table>
 +
<tr><td>[[ACADSTAT Structure]]</td><td>[[ACADWARN Structure]]</td><td>[[AD Structure]]</td></tr>
 +
<tr><td>[[ADMTEST Structure]]</td><td>[[ADVCRED Structure]]</td><td>[[ADVISORS Structure]]</td></tr>
 +
<tr><td>[[ALUMPW Structure]]</td><td>[[APP Structure]]</td><td>[[APPCOUNT Structure]]</td></tr>
 +
<tr><td>[[APPHIST Structure]]</td><td>[[APPLICS Structure]]</td><td>[[ARCCOMM Structure]]</td></tr>
 +
<tr><td>[[ARCCRED Structure]]</td><td>[[ARCCRS Structure]]</td><td>[[ARCHSAD Structure]]</td></tr>
 +
<tr><td>[[ARCMAST Structure]]</td><td>[[ARCPPS Structure]]</td><td>[[ARCSPDT Structure]]</td></tr>
 +
<tr><td>[[ARCSTUD Structure]]</td><td>[[ARCTEST Structure]]</td><td>[[ARCTX Structure]]</td></tr>
 +
<tr><td>[[ARCXTRA Structure]]</td><td>[[ATTEND Structure]]</td><td>[[AUTHHIST Structure]]</td></tr>
 +
<tr><td>[[AUTO Structure]]</td><td>[[BAND Structure]]</td><td>[[BARCODES Structure]]</td></tr>
 +
<tr><td>[[BG Structure]]</td><td>[[CCINVAL Structure]]</td><td>[[CHAPEL Structure]]</td></tr>
 +
<tr><td>[[CHKINBAL Structure]]</td><td>[[CHURCHES Structure]]</td><td>[[CODETABL Structure]]</td></tr>
 +
<tr><td>[[COMMENTS Structure]]</td><td>[[COMMLOG Structure]]</td><td>[[CONC Structure]]</td></tr>
 +
<tr><td>[[COUNTRY Structure]]</td><td>[[COURSEDE Structure]]</td><td>[[COURSES Structure]]</td></tr>
 +
<tr><td>[[CRDITLIM Structure]]</td><td>[[CRITERIA Structure]]</td><td>[[CROSLIST Structure]]</td></tr>
 +
<tr><td>[[CRSCHG Structure]]</td><td>[[CRSTIME Structure]]</td><td>[[CRSTRANS Structure]]</td></tr>
 +
<tr><td>[[DEADFILE Structure]]</td><td>[[DENOM Structure]]</td><td>[[DISBURS Structure]]</td></tr>
 +
<tr><td>[[DOCANNO Structure]]</td><td>[[DOCLIST Structure]]</td><td>[[DOCTYPES Structure]]</td></tr>
 +
<tr><td>[[EM Structure]]</td><td>[[EMPL Structure]]</td><td>[[EXCEPT Structure]]</td></tr>
 +
<tr><td>[[FAPPCOST Structure]]</td><td>[[FAPPITEM Structure]]</td><td>[[FAPPLICS Structure]]</td></tr>
 +
<tr><td>[[FAPPNOTE Structure]]</td><td>[[FINAID Structure]]</td><td>[[FINAPPS Structure]]</td></tr>
 +
<tr><td>[[FINWIN Structure]]</td><td>[[FORMERCR Structure]]</td><td>[[GENSTATS Structure]]</td></tr>
 +
<tr><td>[[GOVTREP Structure]]</td><td>[[GROUPS Structure]]</td><td>[[HONORS Structure]]</td></tr>
 +
<tr><td>[[HS Structure]]</td><td>[[HSADMIS Structure]]</td><td>[[HSCHOOL Structure]]</td></tr>
 +
<tr><td>[[HTMLFILE Structure]]</td><td>[[IAPPLICS Structure]]</td><td>[[INITCRED Structure]]</td></tr>
 +
<tr><td>[[INVLOG Structure]]</td><td>[[JOBAPPS Structure]]</td><td>[[JOBRESUM Structure]]</td></tr>
 +
<tr><td>[[JOBS Structure]]</td><td>[[KUC Structure]]</td><td>[[L30 Structure]]</td></tr>
 +
<tr><td>[[LABUSER Structure]]</td><td>[[LDEXT Structure]]</td><td>[[LIAISON Structure]]</td></tr>
 +
<tr><td>[[LOANS Structure]]</td><td>[[LOCKOUT Structure]]</td><td>[[MARKSYS Structure]]</td></tr>
 +
<tr><td>[[MASTER Structure]]</td><td>[[MEDICAL Structure]]</td><td>[[MINORS Structure]]</td></tr>
 +
<tr><td>[[NM Structure]]</td><td>[[PAYMENTS Structure]]</td><td>[[PERIODS Structure]]</td></tr>
 +
<tr><td>[[PREVPS Structure]]</td><td>[[PROGRAMS Structure]]</td><td>[[PRSPHIST Structure]]</td></tr>
 +
<tr><td>[[PS Structure]]</td><td>[[PSECOND Structure]]</td><td>[[PW Structure]]</td></tr>
 +
<tr><td>[[QIDATES Structure]]</td><td>[[QIFEES Structure]]</td><td>[[QIRULES Structure]]</td></tr>
 +
<tr><td>[[REGISTER Structure]]</td><td>[[REGPROG Structure]]</td><td>[[RELFILE Structure]]</td></tr>
 +
<tr><td>[[RESPONSE Structure]]</td><td>[[RESTRICT Structure]]</td><td>[[REZ Structure]]</td></tr>
 +
<tr><td>[[REZAPP Structure]]</td><td>[[ROOMS Structure]]</td><td>[[RPTPARAM Structure]]</td></tr>
 +
<tr><td>[[SCHOLARS Structure]]</td><td>[[SDACONF Structure]]</td><td>[[SESSIONS Structure]]</td></tr>
 +
<tr><td>[[SISMM Structure]]</td><td>[[SISSYS Structure]]</td><td>[[SLI Structure]]</td></tr>
 +
<tr><td>[[STUDENTS Structure]]</td><td>[[STUPRGDT Structure]]</td><td>[[STUSERV Structure]]</td></tr>
 +
<tr><td>[[SYLLABU2 Structure]]</td><td>[[SYLLABUS Structure]]</td><td>[[T2202A Structure]]</td></tr>
 +
<tr><td>[[TRANSFER Structure]]</td><td>[[TRANTABL Structure]]</td><td>[[TRUBLST Structure]]</td></tr>
 +
<tr><td>[[USERS Structure]]</td><td>[[VERSION Structure]]</td><td>[[WAITLIST Structure]]</td></tr>
 +
<tr><td>[[WEBAID Structure]]</td><td>[[WEBDATES Structure]]</td><td>[[WEBINI2 Structure]]</td></tr>
 +
<tr><td>[[WINACCES Structure]]</td><td>[[WITHHELD Structure]]</td><td>[[WORKFLOW Structure]]</td></tr>
 +
<tr><td>[[XTRA Structure]]</td></tr>
 +
</table>
  
[[ACADWARN Structure]]
+
== Indexes ==
 +
<table>
 +
<tr><td>[[Current File Indexes]]</td><td>[[Archive File Indexes]]</td><td>[[Root File Indexes]]</td></tr>
 +
</table>
  
[[AD Structure]]
+
== ERD Diagrams ==
  
[[ADMTEST Structure]]
+
Below are links to some partial ERD diagrams. At certain points in CrossRoad, the number and complexity of tables does not lend itself to simple diagramming. To simplify these, a number of support table and code table entities have been omitted.
  
[[ADVCRED Structure]]
+
<table>
 
+
<tr><td>[[Advisors-Instructors ERD]]</td><td>[[Course Offerings ERD]]</td><td>[[Course Templates ERD]]</td></tr>
[[ADVISORS Structure]]
+
<tr><td>[[Current Students ERD]]</td><td>[[Prospective Students ERD]]</td></tr>
 
+
</table>
[[ALUMPW Structure]]
 
 
 
[[APP Structure]]
 
 
 
[[APPCOUNT Structure]]
 
 
 
[[APPHIST Structure]]
 
 
 
[[APPLICS Structure]]
 
 
 
[[ARCCOMM Structure]]
 
 
 
[[ARCCRED Structure]]
 
 
 
[[ARCCRS Structure]]
 
 
 
[[ARCHSAD Structure]]
 
 
 
[[ARCMAST Structure]]
 
 
 
[[ARCPPS Structure]]
 
 
 
[[ARCSPDT Structure]]
 
 
 
[[ARCSTUD Structure]]
 
 
 
[[ARCTEST Structure]]
 
 
 
[[ARCTX Structure]]
 
 
 
[[ARCXTRA Structure]]
 
 
 
[[ATTEND Structure]]
 
 
 
[[AUTHHIST Structure]]
 
 
 
[[AUTO Structure]]
 
 
 
[[BAND Structure]]
 
 
 
[[BARCODES Structure]]
 
 
 
[[BG Structure]]
 
 
 
[[CCINVAL Structure]]
 
 
 
[[CHAPEL Structure]]
 
 
 
[[CHKINBAL Structure]]
 
 
 
[[CHURCHES Structure]]
 
 
 
[[CODETABL Structure]]
 
 
 
[[COMMENTS Structure]]
 
 
 
[[COMMLOG Structure]]
 
 
 
[[CONC Structure]]
 
 
 
[[COUNTRY Structure]]
 
 
 
[[COURSEDE Structure]]
 
 
 
[[COURSES Structure]]
 
 
 
[[CRDITLIM Structure]]
 
 
 
[[CRITERIA Structure]]
 
 
 
[[CROSLIST Structure]]
 
 
 
[[CRSCHG Structure]]
 
 
 
[[CRSTIME Structure]]
 
 
 
[[CRSTRANS Structure]]
 
 
 
[[DEADFILE Structure]]
 
 
 
[[DENOM Structure]]
 
 
 
[[DISBURS Structure]]
 
 
 
[[DOCANNO Structure]]
 
 
 
[[DOCLIST Structure]]
 
 
 
[[DOCTYPES Structure]]
 
 
 
[[EM Structure]]
 
 
 
[[EMPL Structure]]
 
 
 
[[EXCEPT Structure]]
 
 
 
[[FAPPCOST Structure]]
 
 
 
[[FAPPITEM Structure]]
 
 
 
[[FAPPLICS Structure]]
 
 
 
[[FAPPNOTE Structure]]
 
 
 
[[FINAID Structure]]
 
 
 
[[FINAPPS Structure]]
 
 
 
[[FINWIN Structure]]
 
 
 
[[FORMERCR Structure]]
 
 
 
[[GENSTATS Structure]]
 
 
 
[[GOVTREP Structure]]
 
 
 
[[GROUPS Structure]]
 
 
 
[[HONORS Structure]]
 
 
 
[[HS Structure]]
 
 
 
[[HSADMIS Structure]]
 
 
 
[[HSCHOOL Structure]]
 
 
 
[[HTMLFILE Structure]]
 
 
 
[[IAPPLICS Structure]]
 
 
 
[[INITCRED Structure]]
 
 
 
[[INVLOG Structure]]
 
 
 
[[JOBAPPS Structure]]
 
 
 
[[JOBRESUM Structure]]
 
 
 
[[JOBS Structure]]
 
 
 
[[KUC Structure]]
 
 
 
[[L30 Structure]]
 
 
 
[[LABUSER Structure]]
 
 
 
[[LDEXT Structure]]
 
 
 
[[LIAISON Structure]]
 
 
 
[[LOANS Structure]]
 
 
 
[[LOCKOUT Structure]]
 
 
 
[[MARKSYS Structure]]
 
 
 
[[MASTER Structure]]
 
 
 
[[MEDICAL Structure]]
 
 
 
[[MINORS Structure]]
 
 
 
[[NM Structure]]
 
 
 
[[PAYMENTS Structure]]
 
 
 
[[PERIODS Structure]]
 
 
 
[[PREVPS Structure]]
 
 
 
[[PROGRAMS Structure]]
 
 
 
[[PRSPHIST Structure]]
 
 
 
[[PS Structure]]
 
 
 
[[PSECOND Structure]]
 
 
 
[[PW Structure]]
 
 
 
[[QIDATES Structure]]
 
 
 
[[QIFEES Structure]]
 
 
 
[[QIRULES Structure]]
 
 
 
[[REGISTER Structure]]
 
 
 
[[REGPROG Structure]]
 
 
 
[[RELFILE Structure]]
 
 
 
[[RESPONSE Structure]]
 
 
 
[[RESTRICT Structure]]
 
 
 
[[REZ Structure]]
 
 
 
[[REZAPP Structure]]
 
 
 
[[ROOMS Structure]]
 
 
 
[[RPTPARAM Structure]]
 
 
 
[[SCHOLARS Structure]]
 
 
 
[[SDACONF Structure]]
 
 
 
[[SESSIONS Structure]]
 
 
 
[[SISMM Structure]]
 
 
 
[[SISSYS Structure]]
 
 
 
[[SLI Structure]]
 
 
 
[[STUDENTS Structure]]
 
 
 
[[STUPRGDT Structure]]
 
 
 
[[STUSERV Structure]]
 
 
 
[[SYLLABU2 Structure]]
 
 
 
[[SYLLABUS Structure]]
 
 
 
[[T2202A Structure]]
 
 
 
[[TRANSFER Structure]]
 
 
 
[[TRANTABL Structure]]
 
 
 
[[TRUBLST Structure]]
 
 
 
[[USERS Structure]]
 
 
 
[[VERSION Structure]]
 
 
 
[[WAITLIST Structure]]
 
 
 
[[WEBAID Structure]]
 
 
 
[[WEBDATES Structure]]
 
 
 
[[WEBINI2 Structure]]
 
 
 
[[WINACCES Structure]]
 
 
 
[[WITHHELD Structure]]
 
 
 
[[WORKFLOW Structure]]
 
 
 
[[XTRA Structure]]
 

Latest revision as of 22:26, 20 March 2011

This page lists the various datatables used in CrossRoad with links to pages of their structures. The tables should be accessed only by those who have been authorized to do so by Keeler Services.

Structures

ACADSTAT StructureACADWARN StructureAD Structure
ADMTEST StructureADVCRED StructureADVISORS Structure
ALUMPW StructureAPP StructureAPPCOUNT Structure
APPHIST StructureAPPLICS StructureARCCOMM Structure
ARCCRED StructureARCCRS StructureARCHSAD Structure
ARCMAST StructureARCPPS StructureARCSPDT Structure
ARCSTUD StructureARCTEST StructureARCTX Structure
ARCXTRA StructureATTEND StructureAUTHHIST Structure
AUTO StructureBAND StructureBARCODES Structure
BG StructureCCINVAL StructureCHAPEL Structure
CHKINBAL StructureCHURCHES StructureCODETABL Structure
COMMENTS StructureCOMMLOG StructureCONC Structure
COUNTRY StructureCOURSEDE StructureCOURSES Structure
CRDITLIM StructureCRITERIA StructureCROSLIST Structure
CRSCHG StructureCRSTIME StructureCRSTRANS Structure
DEADFILE StructureDENOM StructureDISBURS Structure
DOCANNO StructureDOCLIST StructureDOCTYPES Structure
EM StructureEMPL StructureEXCEPT Structure
FAPPCOST StructureFAPPITEM StructureFAPPLICS Structure
FAPPNOTE StructureFINAID StructureFINAPPS Structure
FINWIN StructureFORMERCR StructureGENSTATS Structure
GOVTREP StructureGROUPS StructureHONORS Structure
HS StructureHSADMIS StructureHSCHOOL Structure
HTMLFILE StructureIAPPLICS StructureINITCRED Structure
INVLOG StructureJOBAPPS StructureJOBRESUM Structure
JOBS StructureKUC StructureL30 Structure
LABUSER StructureLDEXT StructureLIAISON Structure
LOANS StructureLOCKOUT StructureMARKSYS Structure
MASTER StructureMEDICAL StructureMINORS Structure
NM StructurePAYMENTS StructurePERIODS Structure
PREVPS StructurePROGRAMS StructurePRSPHIST Structure
PS StructurePSECOND StructurePW Structure
QIDATES StructureQIFEES StructureQIRULES Structure
REGISTER StructureREGPROG StructureRELFILE Structure
RESPONSE StructureRESTRICT StructureREZ Structure
REZAPP StructureROOMS StructureRPTPARAM Structure
SCHOLARS StructureSDACONF StructureSESSIONS Structure
SISMM StructureSISSYS StructureSLI Structure
STUDENTS StructureSTUPRGDT StructureSTUSERV Structure
SYLLABU2 StructureSYLLABUS StructureT2202A Structure
TRANSFER StructureTRANTABL StructureTRUBLST Structure
USERS StructureVERSION StructureWAITLIST Structure
WEBAID StructureWEBDATES StructureWEBINI2 Structure
WINACCES StructureWITHHELD StructureWORKFLOW Structure
XTRA Structure

Indexes

Current File IndexesArchive File IndexesRoot File Indexes

ERD Diagrams

Below are links to some partial ERD diagrams. At certain points in CrossRoad, the number and complexity of tables does not lend itself to simple diagramming. To simplify these, a number of support table and code table entities have been omitted.

Advisors-Instructors ERDCourse Offerings ERDCourse Templates ERD
Current Students ERDProspective Students ERD