Report SpecificationUG001 – Applications Received
EUCLID:
EdinburghUniversity Complete Lifecycle Integrated Development
Report Specification:
UG003 – Applicants with Open Days or Interviews
1DOCument Management
1.1Version Control
Date / Version / Author / Section / Amendment10/3/2008 / V1 / Craig Middlemass / All / Initial Version
T:\euclid\restricted\FunctionalTeam\Reporting\Admissions\CR001_ApplicationsRecieved\CR001_ReportSpecification.doc
1 of 29
UG003 – Applicants with Open Days or Interviews – Report Specification
2OVERVIEW
This document details the business requirements and technical specification for a report from SITS:Vision. Its purpose is to:
- enable the report developer to create the report;
- give the testing team details of how the report should look and function;
- provide the training team with the information required to develop training materials; and
- facilitate support of users of the report by the package support team post-implementation.
This specification conforms to the EUCLID operational reporting and management information frameworks unless otherwise indicated. Explanations of variations are given where appropriate.
3Report information
Description / Details of applicants, who have had an interview, audition or portfolio appointment booked but have not yet attended.Operational/MI? / Operational
Database / SITS: Vision
Technology / Business Objects XI (BOXI)
Categories / Corporate Report
Location / Corporate folders (BOXI)
Output / This report may be printed or extracted to Excel (or PDF) for use in preparing for interviews.
Other information / None
4data specification
4.1Data source and display information
Data source(s) / “Admissions”Business Objects UniverseReport style / Table of applicant contact details subdivided into IOI Code
Fixed selection criteria / Sequence Number is not null (i.e. Interview or Open Day has been created)
Variable selection criteria / Interview Open Day Code = User Prompt To Select Interview Code
Conditionality / Sequence Number is not null and
Interview Open Day Code
Therefore all conditions must be met to be returned in the report.
Scope of analysis/drill down / N/A
Chart(s) / N/A
Other information / N/A
4.2Database fields
Ref / Name / Universe/table / Info/Values / SITS Field / Notes11 / Interview Date / Student Details\ioi (STU Interview/Open day Inv)\Interview Date / DD/mmm/YYYY / IOI_IODD
2 / Interview Start Time / Student Details\ioi (STU Interview/Open day Inv)\Interview Time / 00:00 (24hour clock) / IOI_BEGT
3 / No of Guests / Student Details\ioi (STU Interview/Open day Inv)\Number of guests / Numeric / IOI_GEST
4 / Interviewer 1 / Student Details\ioi (STU Interview/Open day Inv)\First interviewer / Personnel Name / IOI_PRS1 linked to PRS_CODE
5 / Interviewer 2 / Student Details\ioi (STU Interview/Open day Inv)\Second interviewer / Personnel Name / IOI_PRS2 linked to PRS_CODE
6 / Accepted Interview / Student Details\ioi (STU Interview/Open day Inv)\Coming to interview / Y or blank / IOI_CMYN
7 / Attended Interview / Student Details\ioi (STU Interview/Open day Inv)\Attended? / Y or blank / IOI_ATYN
8 / Course / Student Details\ioi (STU Interview/Open day Inv)\MAS Course code / Alphanumeric / IOI_MCRC
9 / Student Code / Student Details\stu (Student)\Student code / S99999999 / IOI_STUC or STU_CODE
10 / Interview Sequence Number / Student Details\ioi (STU Interview/Open day Inv)\Sequence number / Numeric / IOI_SEQ2 / Reference number to separate out multiple interviews for a single course application.
11 / Application Form Sequence Number / Student Details\ioi (STU Interview/Open day Inv)\APF sequence number / Numeric / IOI_APFS / Reference number to separate out multiple applications for a single applicant.
12 / Course Application Sequence Number / Student Details\ioi (STU Interview/Open day Inv)\CAP sequence number / Numeric / IOI_CAPS / Reference number to separate out multiple course applications per application form.
13 / Interview Code / Student Details\ioi (STU Interview/Open day Inv)\Interview Open Day code / Alphanumeric / IOI_IODC / A unique code to identify the interview/open day record.
14 / Interview Method / Student Details\ioi (STU Interview/Open day Inv)\Interview Method / No action
In person on site
By Telephone
Other / IOI_MTHD
15 / Applicant Status / Applications\cap (Course Application)\sta (CAP Status)\Status code / Validated by STA table / CAP_STAC. CAP. SRS
16 / College / Course Structure\mcr (MAS Course)\Faculty Code / College Name / MCR_FACC. MCR. SRS / Faculty on SITS relates to UoECollege
17 / School / Course Structure\mcr (MAS Course)\Department code / Department Name / MCR_DPTC. MCR. SRS – Level 4 Parent under UDF3 of the DPT table / Department on SITS relates to UoESchool (and sub departments)
18 / Course Group / Course Structure\mcr (MAS Course)\Course Grp code / Free Format / MCR_CGPC.MCR.SRS / Validated by CGP table
19 / Admission Entry System / Applications\apf (Application Form)\Admissions Entry System / UCAS, Direct, Etc / APF_AESC. APF. SRS
20 / Academic Year / Applications\cap (Course Application)\ayr (CAP Academic Year)\Academic Year code / 2007/8, etc / CAP_AYRC. CAP. SRS / This denotes the year in which the applicant intends to start.
21 / Applicant Address / Student Details\stu (Student)\STU Addresses\ / Correspondence address 1 to 5 / STU_CAD1 to 5
22 / Postcode / Student Details\stu (Student)\STU Addresses\ / Contact address postcode / CAPC
23 / Telephone / Student Details\stu (Student)\STU Addresses\ / Contact Telephone No 1 / CTEL
24 / Mobile / Student Details\stu (Student)\STU Addresses\ / Contact Telephone No 2/3 / CAT2/3
25 / Student Name / Student Details\stu (Student)\ / Full / Official Name / STU_NAME
26 / Student Preferred Forename / Student Details\stu (Student)\ / Forename Used / STU_FUSD
4.3 Reference Tables
Ref / Name / Table / Values Required / Notes1 / Personnel / PRS / Personnel Full Name (PRS_NAME) / IOI_PRS1 and 2 are linked to PRS_CODE
4.4Derived fields
Ref / Name / Description / Notes1 / None
4.5Sorting and grouping
Sort level / Field / Group / Subtotal / Page break / Notes1 / IOI Code / Y / Y / Tables will be split by Interview Code
4.6Drillable Items
Drill Item / Aggregates / Values on Table / SourceNo drill allowed
Page 1 of 7