110 likes | 139 Views
Explore the comprehensive DegreeWorks technical guide detailing Banner integration, data storage, extraction, and processing for effective academic management.
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