110 likes | 135 Views
DegreeWorks Architecture. Banner. Students. Faculty. Portal. Staff. Dynamic or Batch. DegreeWorks Instance. Student/Course Data. CPA ad hoc reporting. CPA Storage. and Validation Tables. XML Trees. Requirement Blocks. Parser. Scribe. Auditor Engine. Audit Generation.
E N D
Banner Students Faculty Portal Staff Dynamic or Batch DegreeWorks Instance Student/Course Data CPA ad hoc reporting CPA Storage and Validation Tables XML Trees Requirement Blocks Parser Scribe Auditor Engine
Banner Extract Data Flow UCX Tables DegreeWorks Data Storage Banner Database Web Server CGI/Sockets DegreeWorks Server Banner Server Course Equivalency UCX Course Data Student Data Extract Real Time Batch Batch Requests Web Requests Transit/cron Users
Banner Extracts • Configurable baseline functionality • Uses Embedded SQL C subroutines • Extract can be run in batch or dynamic mode • The DegreeWorks Technical Guide Banner Considerations document lists extracted Banner tables
Banner Extract Data Sources • DegreeWorksAcademic Tables: • Personal information from SPRIDEN and GOREMAL • Student coursework from In-Progress, Historic and Transfer class tables • Advisors are identified by the SGRADVR table • Course Catalog, Class Equivalencies also loaded • DegreeWorks UCX Tables from STV* tables • See DegreeWorks Technical Guide Banner Data Mapping for BIF document