Data Structures

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 Structure	ACADWARN Structure	AD Structure
ADMTEST Structure	ADVCRED Structure	ADVISORS Structure
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

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