CISOA 3CBG Conference 2014 Overview Importing and Loading ASSIST Data into Banner Two Technologies Banner Setup and Processes XML XSL Translation Data Source eTranscriptCA ID: 805861
Download The PPT/PDF document "Importing XML Transcripts into Banner" is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
Slide1
Importing XML Transcripts into Banner
CISOA / 3CBG Conference • 2014
Slide2Overview . . .
Slide3Importing and Loading ASSIST Data into Banner
Two Technologies:Banner Setup and Processes XML – XSL TranslationData Source: eTranscriptCA
California Transcript Exchange
-------------------------
Overview:
Slide4Loading ASSIST
DATA
Slide5Loading ASSIST Catalog Data into Banner*
Files :UC Transferable to Community CollegesCSU Transferable to Community CollegesIGETC Applicable Community Colleges
CSU-GE Breadth CertificationCSU and UC (UC all)
* Not articulation data
Slide6Oracle Database Functionality
Processes:Create local table:SZRARTCLoad tables using SQLLOADERScripts to modify each fileLoad attributes - use SQLLOADER20+ SQL scripts run to load data
Slide7Problems With ASSIST Data
Tables loaded: SHBTATC, SHRTCATGotcha’sMany, many duplicate rowsGaps in data attributes deactivated for
one or more termsTranslate incoming term codesNo Begin-End term codes Only begin term codes
Slide8SHTATC Transfer Institution Catalog
The result:
Course catalog data from ASSIST is loaded into Banner
Slide9For a given incoming institution:
Close-up Look at the Data
Term: 20005
Level: 01
Subject: ACCTG
Course: 20
Status: active
Title: Financial Accounting
Equivalent Exists:
Low: 4.00
High: 4.00
Course Attributes:
UC
CSU
IGETC
CSU-GE
CSU and UC
Slide10ASSIST Catalog Records Loaded: 388,897
Colleges loaded: 107Stats on ASSIST Dataload:ASSIST Attribute Code Records Loaded: 610,801
Slide11Receiving Electronic Transcripts
What it took for us to load incoming electronic transcripts into Banner
Slide12Load data into Banner using baseline program:
Sweeps target directory for XML transcripts and loads data into series of Banner tables.SHRPESI
Slide13Loading data into Banner
SHAEDIS
Slide14Courses Ready for Articulation
SHATAEQ
Slide15Cross Reference Rules
Cross-reference data from incoming transcripts into Banner data SOAXREF
Slide16Semester/ Quarter Crosswalk between electronic value on incoming transcript and Banner value
STVTRMT - SOAXREF
Slide17College Setup
SOAXREF
STVSBGI
Slide18Crosswalk – Incoming begin end term dates with Banner term code
Use default Institution if possibleSHADRTM
Slide19Using
eTranscriptCA Control CenterDownloading XML Transcripts
Slide20Student originated
or requested by receiving institutionTranscript Requests
Slide21XML Transcript Example
Incoming Institution Data
Organization NameContact info
Destination Name
FICE
Slide22XML Coursework Sample
Course Data
SessionTranslates to term code
Course level
Term type
Semester
Quarter
FICE
Translates in SOAXREF
Slide23Out-of-the-box SHRPESI didn’t work
XSLT is a language to transform incoming XML document into an XHTML documentor another XML document.XSLT - Modify the incoming data
Slide24XSLT in Action
Incoming etranscriptCA
XMLXSLT
template
XML
Ready for Banner
Slide25