Difference between revisions of "Data Structures"
From CrossRoad
| (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> | ||
| − | [[ | + | == Indexes == |
| + | <table> | ||
| + | <tr><td>[[Current File Indexes]]</td><td>[[Archive File Indexes]]</td><td>[[Root File Indexes]]</td></tr> | ||
| + | </table> | ||
| − | + | == 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. | |
| − | + | <table> | |
| − | + | <tr><td>[[Advisors-Instructors ERD]]</td><td>[[Course Offerings ERD]]</td><td>[[Course Templates ERD]]</td></tr> | |
| − | + | <tr><td>[[Current Students ERD]]</td><td>[[Prospective Students ERD]]</td></tr> | |
| − | + | </table> | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | [[ | ||
| − | |||
| − | [[ | ||
| − | |||
| − | [[ | ||
| − | |||
| − | [[ | ||
| − | |||
| − | [[ | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
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
Indexes
| Current File Indexes | Archive File Indexes | Root 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 ERD | Course Offerings ERD | Course Templates ERD |
| Current Students ERD | Prospective Students ERD |
