{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","Disclaimer","Template"],"not_rendered":{"images":2,"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":77,"n_cols":2,"rows_kept":77}
["Version 1.0 Produced 2014-04-29"]
[]
[null,"Upon opening the template, ensure that you click 'Enable Content' in the above bar."]
[]
[null,"Before beginning make a master copy of the template – this will mean that you always have a template"]
[null,"to copy and paste from after you’ve made changes the template you are using to compile your"]
[null,"submission."]
[]
[null,"The template itself has 5 main columns (B-F), however you should only need to edit column D."]
[null,"Columns C and E contain the entity/field tags which are needed along with the data you input into D to"]
[null,"generate column B (the column which will be used to generate the XML file)."]
[]
[null,"1. Begin by inputting your institution information into column D, rows 5 to 10."]
[]
[null,"Note. You should only ever input into column D where there is a closed tag in column E. For example"]
[null,"the row containing <KISRecord> should not have anything input into column D, whereas the row"]
[null,"containing <RECID> and </RECID> should."]
{"$rows_empty":9}
[null,"2. Continue to input the relevant data items for your institution remembering to delete rows that"]
[null,"are not applicable e.g. where the field is not required. You can delete a row by clicking on the"]
[null,"row number and then right click the mouse and select delete."]
[]
[]
[]
[]
[null,"Note. Column F contains some (but not all) notes that will help you determine whether the field is"]
[null,"required for you, however the coding manual should be used at all time as it will be up to date and"]
[null,"provide specific details."]
[]
[null,"3. Input your data for a KIS course – again remembering to delete the rows of data for which you"]
[null,"do not need to complete (as in the SUURL example above)."]
[]
[null,"4. Within each KIS course there are sub-entities i.e. Institution, KIS Course, Accreditation,"]
[null,"Course Stage, HESA Course, ILR Aims and Location. "]
[null,"You will need to delete any of these entities that are not relevant to the course, for"]
[null,"example where the course has been returned on the ILR the HESACourse entity will need to"]
[null,"be deleted. This can be done by selecting the relevant rows, right-clicking the mouse, and"]
[null,"selecting delete."]
[]
[null,"5. Where each sub-entity needs to occur more than once, for example where the course has two"]
[null,"accreditations, you will need to select the rows for the entity, click copy, and then paste the"]
[null,"copied cells directly below the first occurrence of the entity and before the next sub-entity begins."]
[]
[]
[null,"6. Once you have completed all of the relevant data for the KIS course, deleted rows which are not"]
[null,"relevant, removed sub-entities or added additional ones in, you will need to add in new rows for"]
[null,"a new KIS course."]
[]
[null,"7. Copy from your master template all of the rows relating to the KIS course – this is denoted by the"]
[null,"red ‘repeat as necessary’ graphic within column A."]
[]
[null,"8. Paste the new rows directly beneath the end of the previous KISCourse i.e. after the row"]
[null,"containing </KISCourse>"]
[]
[null,"9. Continue to repeat process for all of your KIS courses."]
[]
[null,"10. Clicking the 'remove blank rows' button will remove any rows where data has not been entered."]
[null,"This should only be done once all data has been entered."]
[null,"Any entity tags that are no longer needed will need to be deleted manually. "]
[]
[null,"11. Once your data is inputted click on B2 and highlight all of the rows beneath it until the final row"]
[null,"which should contain </KISRecord>."]
[]
[null,"12. Open Notepad, past the selection into it (make sure that the final line is </KISRecord> and that"]
[null,"there is not a further blank line underneath it – if there is delete it so the cursor is on the"]
[null,"</KISRecord> line."]
[]
[null,"13. Save the file making sure that you change ‘file type’ to ‘All files’ and give it an extension of .xml"]
[null,"e.g. KISFILE.xml"]

{"sheet":"Disclaimer","index":1,"n_rows":6,"n_cols":2,"rows_kept":6}
[]
[null,"Please note"]
[]
[null,"This template is neither a system nor something that can be submitted directly as a KIS submission. It is a template to which an XML file can be produced where no other viable alternative exists"]
[]
[null,"The use of this template is the institutions responsibility - HESA are unable to support colleagues in the compiliation of the data or problems arising from use of the template  "]

{"sheet":"Template","index":2,"n_rows":115,"n_cols":6,"rows_kept":115,"merged":[[64,0,68,0],[69,0,70,0],[71,0,75,0]]}
[null,"Copy from A2 downwards - do not edit this column","Do not edit this column","Data input into this column","Do not edit this column","Coverage"]
[null,{"$f":"C2&\"\"","v":"<?xml version=\"1.0\" encoding=\"utf-8\"?>"},"<?xml version=\"1.0\" encoding=\"utf-8\"?>","DO NOT EDIT"]
[null,{"$f":"C3&\"\"","v":"<KISRecord>"},"<KISRecord>","DO NOT EDIT"]
[null,{"$f":"C4&\"\"","v":"<Institution>"},"<Institution>","DO NOT EDIT"]
[null,{"$f":"C5&\"\"&D5&\"\"&E5&\"\"","v":"<RECID>14061</RECID>"},"<RECID>","14061","</RECID>","All institutions"]
[null,{"$f":"C6&\"\"&D6&\"\"&E6&\"\"","v":"<SUURL></SUURL>"},"<SUURL>",null,"</SUURL>","All institutions"]
[null,"<SUURLW></SUURLW>","<SUURLW>",null,"</SUURLW>","All institutions in Wales"]
[null,"<UKPRN></UKPRN>","<UKPRN>",null,"</UKPRN>","All institutions"]
[null,"<OTHERINST></OTHERINST>","<OTHERINST>",null,"</OTHERINST>","All institutions where any provision is franchised."]
[null,{"$f":"C10&\"\"","v":"<Location>"},"<Location>","DO NOT EDIT"]
[null,{"$f":"C11&\"\"&D11&\"\"&E11&\"\"","v":"<LOCID></LOCID>"},"<LOCID>",null,"</LOCID>","All institutions where Institution.Location entity exists"]
[null,"<LOCNAME></LOCNAME>","<LOCNAME>",null,"</LOCNAME>","All institutions where Institution.Location entity exists"]
[null,"<LOCNAMEW></LOCNAMEW>","<LOCNAMEW>",null,"</LOCNAMEW>","Institutions in Wales where Institution.Location entity exists"]
[null,"<LATITUDE></LATITUDE>","<LATITUDE>",null,"</LATITUDE>","All institutions where Institution.Location entity exists"]
[null,"<LONGITUDE></LONGITUDE>","<LONGITUDE>",null,"</LONGITUDE>","All institutions where Institution.Location entity exists"]
[null,"<LOCUKPRN></LOCUKPRN>","<LOCUKPRN>",null,"</LOCUKPRN>","All institutions where Institution.Location entity exists"]
[null,"<INSTUPPER></INSTUPPER>","<INSTUPPER>",null,"</INSTUPPER>","All institutions where Location.INSTBEDS exists"]
[null,"<INSTLOWER></INSTLOWER>","<INSTLOWER>",null,"</INSTLOWER>","All institutions where Location.INSTBEDS exists"]
[null,"<INSTBEDS></INSTBEDS>","<INSTBEDS>",null,"</INSTBEDS>","If Applicable"]
[null,"<PRIVATEUPPER></PRIVATEUPPER>","<PRIVATEUPPER>",null,"</PRIVATEUPPER>","All institutions where Institution.Location exists"]
[null,"<PRIVATELOWER></PRIVATELOWER>","<PRIVATELOWER>",null,"</PRIVATELOWER>","All institutions where Institution.Location exists"]
[null,"<ACCOMURL></ACCOMURL>","<ACCOMURL>",null,"</ACCOMURL>","Institutions where not all courses are distance learning"]
[null,"<ACCOMURLW></ACCOMURLW>","<ACCOMURLW>",null,"</ACCOMURLW>","Institutions in Wales where not all courses are distance learning, where applicable"]
[null,{"$f":"C24&\"\"&D24&\"\"&E24&\"\"","v":"<SUURL></SUURL>"},"<SUURL>",null,"</SUURL>","All institutions, if applicable"]
[null,{"$f":"C25&\"\"&D25&\"\"&E25&\"\"","v":"<SUURLW></SUURLW>"},"<SUURLW>",null,"</SUURLW>","Institutions in Wales, if applicable"]
[null,{"$f":"C26&\"\"","v":"</Location>"},"</Location>","DO NOT EDIT"]
[null,{"$f":"C27&\"\"","v":"<KISCourse>"},"<KISCourse>","DO NOT EDIT"]
[null,{"$f":"C28&\"\"&D28&\"\"&E28&\"\"","v":"<KISCOURSEID></KISCOURSEID>"},"<KISCOURSEID>",null,"</KISCOURSEID>","All KISCourses"]
[null,"<TEACHUKPRN></TEACHUKPRN>","<TEACHUKPRN>",null,"</TEACHUKPRN>","All KISCourses where no HESACourse or ILRAims exist, or not all teaching institutions can be identified in HESACourse or ILRAims."]
[null,"<KISTYPE></KISTYPE>","<KISTYPE>",null,"</KISTYPE>","All KISCourses"]
[null,"<RELATEDKIS></RELATEDKIS>","<RELATEDKIS>",null,"</RELATEDKIS>","Where KISType = 2"]
[null,{"$f":"C32&\"\"&D32&\"\"&E32&\"\"","v":"<UCASPROGID></UCASPROGID>"},"<UCASPROGID>",null,"</UCASPROGID>","Where KISCourse.KISTYPE = 1 or 2 and the courses recruit through UCAS and separate KIS to be produced"]
[null,"<NHS></NHS>","<NHS>",null,"</NHS>","Where KISCourse.KISTYPE = 1 or 2 and no HESACourse or ILRAims entities exist"]
[null,"<LOCCHNGE></LOCCHNGE>","<LOCCHNGE>",null,"</LOCCHNGE>","Where KISCourse.KISTYPE = 1 or 2 and KISCourse.DISTANCE = 0"]
[null,{"$f":"C35&\"\"&D35&\"\"&E35&\"\"","v":"<KISMODE></KISMODE>"},"<KISMODE>",null,"</KISMODE>","All KISCourses"]
[null,{"$f":"C36&\"\"&D36&\"\"&E36&\"\"","v":"<KISAIM></KISAIM>"},"<KISAIM>",null,"</KISAIM>","All KISCourses where KISCourse.KISTYPE = 1 or 2."]
[null,"<HONOURS></HONOURS>","<HONOURS>",null,"</HONOURS>","All KISCourses where KISCourse.KISTYPE = 1 or 2."]
[null,{"$f":"C38&\"\"&D38&\"\"&E38&\"\"","v":"<TITLE></TITLE>"},"<TITLE>",null,"</TITLE>","All KISCourses where KISCourse.KISTYPE = 1 or 2."]
[null,{"$f":"C39&\"\"&D39&\"\"&E39&\"\"","v":"<TITLEW></TITLEW>"},"<TITLEW>",null,"</TITLEW>","All KISCourses where institution in Wales and KISCourse.KISTYPE = 1 or 2, where applicable"]
[null,"<LEVEL></LEVEL>","<LEVEL>",null,"</LEVEL>","All courses where KISCourse.KISTYPE = 3."]
[null,{"$f":"C41&\"\"&D41&\"\"&E41&\"\"","v":"<NUMSTAGE></NUMSTAGE>"},"<NUMSTAGE>",null,"</NUMSTAGE>","All KISCourses where KISCourse.KISTYPE = 2 is linked to a KISCourse.KISTYPE = 3."]
[null,{"$f":"C42&\"\"&D42&\"\"&E42&\"\"","v":"<FOUNDATION></FOUNDATION>"},"<FOUNDATION>",null,"</FOUNDATION>","All KISCourses where KISCourse.KISTYPE = 1 or 2."]
[null,{"$f":"C43&\"\"&D43&\"\"&E43&\"\"","v":"<SANDWICH></SANDWICH>"},"<SANDWICH>",null,"</SANDWICH>","All KISCourses where KISCourse.KISTYPE = 1 or 2."]
[null,{"$f":"C44&\"\"&D44&\"\"&E44&\"\"","v":"<YEARABROAD></YEARABROAD>"},"<YEARABROAD>",null,"</YEARABROAD>","All KISCourses where KISCourse.KISTYPE = 1 or 2."]
[null,{"$f":"C45&\"\"&D45&\"\"&E45&\"\"","v":"<UKPRNAPPLY></UKPRNAPPLY>"},"<UKPRNAPPLY>",null,"</UKPRNAPPLY>","Courses where students apply other than through the registering institution"]
[null,{"$f":"C46&\"\"&D46&\"\"&E46&\"\"","v":"<CRSEURL></CRSEURL>"},"<CRSEURL>",null,"</CRSEURL>","Required where KISCourse.KISTYPE = 1 or 2 and optional for KISCourse.KISTYPE = 3"]
[null,{"$f":"C47&\"\"&D47&\"\"&E47&\"\"","v":"<CRSEURLW></CRSEURLW>"},"<CRSEURLW>",null,"</CRSEURLW>","Institutions in Wales where KISCourse.KISTYPE = 1 or 2 (and optionally 3) where applicable"]
[null,{"$f":"C48&\"\"&D48&\"\"&E48&\"\"","v":"<JACS></JACS>"},"<JACS>",null,"</JACS>","Where KISCourse.KISTYPE = 1 and both HESACourse and ILRAims entities do not exist"]
[null,"<LDCS></LDCS>","<LDCS>",null,"</LDCS>","FECs where KISCourse.KISTYPE = 1 and no ILRAim entities exist"]
[null,"<JACSL2></JACSL2>","<JACSL2>",null,"</JACSL2>","Where KISCourse.KISTYPE = 3"]
[null,{"$f":"C51&\"\"&D51&\"\"&E51&\"\"","v":"<TTCID></TTCID>"},"<TTCID>",null,"</TTCID>","Where KISCourse.KISTYPE = 1 and both HESACourse and ILRAims entities do not exist"]
[null,"<DISTANCE></DISTANCE>","<DISTANCE>",null,"</DISTANCE>","All KISCourses where KISCourse.KISTYPE = 1 or 2"]
[null,{"$f":"C53&\"\"&D53&\"\"&E53&\"\"","v":"<WELSH></WELSH>"},"<WELSH>",null,"</WELSH>","Institutions in Wales where KISCourse.KISTYPE = 1, 3"]
[null,{"$f":"C54&\"\"&D54&\"\"&E54&\"\"","v":"<ENGFEE></ENGFEE>"},"<ENGFEE>",null,"</ENGFEE>","All KISCourses where KISCourse.KISTYPE = 1,2 and KISCourse.UCASCOURSEID does not exist and KISCourse.FEETBC = 1"]
[null,{"$f":"C55&\"\"&D55&\"\"&E55&\"\"","v":"<NIFEE></NIFEE>"},"<NIFEE>",null,"</NIFEE>","All KISCourses where KISCourse.KISTYPE = 1,2 and KISCourse.UCASCOURSEID does not exist and KISCourse.FEETBC = 1"]
[null,"<SCOTFEE></SCOTFEE>","<SCOTFEE>",null,"</SCOTFEE>","All KISCourses where KISCourse.KISTYPE = 1,2 and KISCourse.UCASCOURSEID does not exist and KISCourse.FEETBC = 1"]
[null,{"$f":"C57&\"\"&D57&\"\"&E57&\"\"","v":"<WAFEE></WAFEE>"},"<WAFEE>",null,"</WAFEE>","All KISCourses where KISCourse.KISTYPE = 1,2 and KISCourse.UCASCOURSEID does not exist and KISCourse.FEETBC = 1"]
[null,"<VARFEE></VARFEE>","<VARFEE>",null,"</VARFEE>","All KISCourses where KISCourse.KISTYPE = 1,2 and KISCourse.UCASCOURSEID does not exist and KISCourse.FEETBC = 1"]
[null,{"$f":"C59&\"\"&D59&\"\"&E59&\"\"","v":"<FEETBC></FEETBC>"},"<FEETBC>",null,"</FEETBC>","Where KISCourse.KISTYPE = 1 or 2 and KISCourse.UCASCOURSEID does not exist"]
[null,"<WAIVER></WAIVER>","<WAIVER>",null,"</WAIVER>","Where KISCourse.KISTYPE = 1 or 2 and KISCourse.UCASCOURSEID does not exist"]
[null,"<MEANSSUP></MEANSSUP>","<MEANSSUP>",null,"</MEANSSUP>","Where KISCourse.KISTYPE = 1 or 2 and KISCourse.UCASCOURSEID does not exist"]
[null,{"$f":"C62&\"\"&D62&\"\"&E62&\"\"","v":"<OTHSUP></OTHSUP>"},"<OTHSUP>",null,"</OTHSUP>","Where KISCourse.KISTYPE = 1 or 2 and KISCourse.UCASCOURSEID does not exist"]
[null,{"$f":"C63&\"\"&D63&\"\"&E63&\"\"","v":"<SUPPORTURL></SUPPORTURL>"},"<SUPPORTURL>",null,"</SUPPORTURL>","Where KISCourse.KISTYPE = 1 or 2 and KISCourse.UCASCOURSEID does not exist"]
[null,{"$f":"C64&\"\"&D64&\"\"&E64&\"\"","v":"<SUPPORTURLW></SUPPORTURLW>"},"<SUPPORTURLW>",null,"</SUPPORTURLW>","Institutions in Wales where KISCourse.KISTYPE = 1 or 2"]
[null,"<EMPLOYURL></EMPLOYURL>","<EMPLOYURL>",null,"</EMPLOYURL>","Where KISCourse.KISTYPE = 1, 3"]
[null,"<EMPLOYURLW></EMPLOYURLW>","<EMPLOYURLW>",null,"</EMPLOYURLW>","Institutions in Wales where KISCourse.KISTYPE = 1, 3, where applicable"]
[null,"<NONCREDITASSESS></NONCREDITASSESS>","<NONCREDITASSESS>",null,"</NONCREDITASSESS>","All KISCourses where KISCourse.KISTYPE = 1 or 2"]
[null,{"$f":"C68&\"\"&D68&\"\"&E68&\"\"","v":"<LTURL></LTURL>"},"<LTURL>",null,"</LTURL>","All KISCourses where KISCourse.KISTYPE = 1, 3"]
[null,"<LTURLW></LTURLW>","<LTURLW>",null,"</LTURLW>","Institutions in Wales where KISCourse.KISTYPE = 1 or 3, where applicable"]
[null,"<ASSURL></ASSURL>","<ASSURL>",null,"</ASSURL>","Where KISCourse.KISTYPE = 1, 3"]
[null,"<ASSURLW></ASSURLW>","<ASSURLW>",null,"</ASSURLW>","Institutions in Wales where KISCourse.KISTYPE = 1, 3, where applicable"]
[null,{"$f":"C72&\"\"","v":"<HESACourse>"},"<HESACourse>","DO NOT EDIT"]
[null,"<TEACHUKPRN></TEACHUKPRN>","<TEACHUKPRN>",null,"</TEACHUKPRN>","All institutions where all of its provision is franchised from a single provider"]
[null,"<REGUKPRN></REGUKPRN>","<REGUKPRN>",null,"</REGUKPRN>","All institutions where the course is registered."]
[null,{"$f":"C75&\"\"&D75&\"\"&E75&\"\"","v":"<HESACOURSEID></HESACOURSEID>"},"<HESACOURSEID>",null,"</HESACOURSEID>","All HESACourses"]
[null,"<HESAYEAR></HESAYEAR>","<HESAYEAR>",null,"</HESAYEAR>","All HESACourses"]
[null,{"$f":"C77&\"\"","v":"</HESACourse>"},"</HESACourse>","DO NOT EDIT"]
[null,{"$f":"C78&\"\"","v":"<ILRAims>"},"<ILRAims>","DO NOT EDIT"]
[null,{"$f":"C79&\"\"&D79&\"\"&E79&\"\"","v":"<TEACHUKPRN></TEACHUKPRN>"},"<TEACHUKPRN>",null,"</TEACHUKPRN>","All institutions where KISCourse.KISTYPE = 1 and no HESACourse or ILRAims exist"]
[null,"<REGUKPRN></REGUKPRN>","<REGUKPRN>",null,"</REGUKPRN>","All institutions where the course is registered."]
[null,"<ILRAIMID></ILRAIMID>","<ILRAIMID>",null,"</ILRAIMID>","All ILRAim entities"]
[null,"<ILRYEAR></ILRYEAR>","<ILRYEAR>",null,"</ILRYEAR>","All ILRAims"]
[null,{"$f":"C83&\"\"","v":"</ILRAims>"},"</ILRAims>","DO NOT EDIT"]
[null,{"$f":"C84&\"\"","v":"<CourseLocation>"},"<CourseLocation>","DO NOT EDIT"]
[null,"<LOCID></LOCID>","<LOCID>",null,"</LOCID>"]
[null,"<UCASCOURSEID></UCASCOURSEID>","<UCASCOURSEID>",null,"</UCASCOURSEID>"]
[null,{"$f":"C87&\"\"","v":"</CourseLocation>"},"</CourseLocation>","DO NOT EDIT"]
[null,{"$f":"C88&\"\"","v":"<CourseStage>"},"<CourseStage>","DO NOT EDIT"]
[null,"<WRITTEN></WRITTEN>","<WRITTEN>",null,"</WRITTEN>","All CourseStages"]
[null,"<PRACTICAL></PRACTICAL>","<PRACTICAL>",null,"</PRACTICAL>","All CourseStages"]
[null,"<COURSEWORK></COURSEWORK>","<COURSEWORK>",null,"</COURSEWORK>","All CourseStages"]
[null,"<ASSACT></ASSACT>","<ASSACT>",null,"</ASSACT>","All CourseStages"]
[null,"<SCHEDULED></SCHEDULED>","<SCHEDULED>",null,"</SCHEDULED>","All CourseStages"]
[null,"<INDEPENDENT></INDEPENDENT>","<INDEPENDENT>",null,"</INDEPENDENT>","All CourseStages"]
[null,"<PLACEMENT></PLACEMENT>","<PLACEMENT>",null,"</PLACEMENT>","All CourseStages"]
[null,"<LTACT></LTACT>","<LTACT>",null,"</LTACT>","All CourseStages"]
[null,"<STAGE></STAGE>","<STAGE>",null,"</STAGE>","All CourseStages"]
[null,{"$f":"C98&\"\"","v":"</CourseStage>"},"</CourseStage>","DO NOT EDIT"]
[null,{"$f":"C99&\"\"","v":"<Accreditation>"},"<Accreditation>","DO NOT EDIT"]
[null,"<ACCTYPE></ACCTYPE>","<ACCTYPE>",null,"</ACCTYPE>","Where course has professional accreditation"]
[null,"<ACCDEPEND></ACCDEPEND>","<ACCDEPEND>",null,"</ACCDEPEND>","Where course has professional accreditation"]
[null,"<ACCDEPENDURL></ACCDEPENDURL>","<ACCDEPENDURL>",null,"</ACCDEPENDURL>","Where Accreditation.ACCDEPEND = 1"]
[null,"<ACCDEPENDURLW></ACCDEPENDURLW>","<ACCDEPENDURLW>",null,"</ACCDEPENDURLW>","Institutions in Wales where Accreditation.ACCDEPEND = 1 where applicable"]
[null,{"$f":"C104&\"\"","v":"</Accreditation>"},"</Accreditation>","DO NOT EDIT"]
[null,{"$f":"C105&\"\"","v":"</KISCourse>"},"</KISCourse>","DO NOT EDIT"]
[null,"</Institution>","</Institution>","DO NOT EDIT"]
[null,{"$f":"C107&\"\"","v":"</KISRecord>"},"</KISRecord>","DO NOT EDIT"]
[]
[]
[]
[]
[]
[null,"Clicking the above button will remove any rows where data has not been entered."]
[null,"This should only be done once all data has been entered."]
[null,"Any entity tags that are no longer needed will need to be deleted manually. "]