KIS Database (Oracle) SITS

KIS Database

(Oracle)

SITS

Could be other
relational database
provider

Views of

Course
Data

KIS XML
Document

Institution
level data

ASP.Net Web
Application

Institution level
data manually
entered via web
application

HESA Validator

XML File
Created

Internal Validation
against HESA schema
XSD

Accommodation
/provider ref data

ADO.Net

Manual upload
of file to HESA

SQL
Queries

<?xml version="1.0" encoding="utf
-
8" ?>

-

<Institution>



<RECID>
12061
</RECID>



<UKPRN>
10008640
</UKPRN>



<INSTUPPER>
4830
</INSTUPPER>



<INSTLOWER>
3000
</INSTLOWER>



<INSTBEDS>
1439
</INSTBEDS>



<PRIVATEUPPER>
3261
</PRIVATEUPPER>



<PRIVATELOWER>
2625
</PRIVATELOWER>



<ACCOMURL>
http://www.falmouth.ac.uk
</ACCOMURL>



<NSP>
1
</NSP>

-

<
KISCourse
>



<KISCOURSEID>
BAADVTFF
</KISCOURSEID>



<KISTYPE>
1
</KISTYPE>



<UCASCOURSEID>
N561
</UCASCOURSEID>



<TITLE>
BA(HONS) ADVERTISING (FT)
</TITLE>



<UKPRNAPPLY>
10008640
</UKPRNAPPLY>



<CRSEURL>
http://www.falmouth.ac.uk
</CRSEURL>



<JACS>
P420
</JACS>



<TTCID>
0
</TTCID>



<PTONLY>
0
</PTONLY>



<LEVEL>
F
</LEVEL>



<DISTANCE>
0
</DISTANCE>



<ENGFEE>
9000
</ENGFEE>



<NIFEE>
9000
</NIFEE>



<SCOTFEE>
9000
</SCOTFEE>



<WAFEE>
9000
</WAFEE>



<VARFEE>
20
</VARFEE>



<FEETBC>
0
</FEETBC>



<SUPPORTURL>
http://www.falmouth.ac.uk
</SUPPORTURL>



<EMPLOYURL>
http://www.falmouth.ac.uk
</EMPLOYURL>



<NONCREDITASSESS>
0
</NONCREDITASSESS>



<LTURL>
http://www.falmouth.ac.uk
</LTURL>



<ASSURL>
http://www.falmouth.ac.uk
</ASSURL>

-

<
HESACourse
>



<HESACOURSEID>
BAADVTFF/BAADVTFF
</HESACOURSEID>



<HESAYEAR>
2010
</HESAYEAR>



</
HESACourse
>

-

<
CourseStage
>



<WRITTEN>
20
</WRITTEN>



<PRACTICAL>
60
</PRACTICAL>



<COURSEWORK>
20
</COURSEWORK>



<ASSACT>
A
</ASSACT>



<SCHEDULED>
20
</SCHEDULED>



<INDEPENDENT>
50
</INDEPENDENT>



<PLACEMENT>
30
</PLACEMENT>



<LTACT>
A
</LTACT>



<STAGE>
1
</STAGE>



</
CourseStage
>

-

<
CourseStage
>



<WRITTEN>
20
</WRITTEN>



<PRACTICAL>
60
</PRACTICAL>



<COURSEWORK>
20
</COURSEWORK>



<ASSACT>
A
</ASSACT>



<SCHEDULED>
20
</SCHEDULED>



<INDEPENDENT>
50
</INDEPENDENT>



<PLACEMENT>
30
</PLACEMENT>



<LTACT>
A
</LTACT>



<STAGE>
2
</STAGE>



</
CourseStage
>



</
KISCourse
>



</Institution>

Further info…

•
Please contact

•
Damian O’Brien

–
Damian.Obrien@falmouth.ac.uk


–
Or check out the blog…

–
http://ucfxcricap.jiscinvolve.org/wp/2012/05/11/s
its
-
kis
/