Student Course Enrolments STUDENT STUDENT COURSE JOIN STUDENT COURSE COURSES, PROGRAMMES ENROLMENT and ROUTES SITS uses one basic record to Once registered at YSJ, a hold all of a student's student can join a course. When Having joined a course, a Courses, programmes and personal details. This unique a student joins a a Student student must enrol on each routes hold various Student (STU) record will Course Join (SCJ) record is course block/occurrence that combinations of course-related remain with them for the created. A student can join more s/he wishes to take. Students information. For example, whole of their studies at YSJ, than one course at a time or cannot enrol on a course Course: BAJJJFT BA (Hons) from initial application, consecutively. block/occurrence unless they Joint FT, Route: ARENJ Art and enrolment and alumni. have joined the course. English Literature INS_STU SRS_SCJ SRS_SCE SRS_CRS stu_code: Student Code scj_code: Student SCJ Code sce_scjc: Student SCJ Code crs_code: Course Code stu_surn: Surname scj_stuc: Student Code sce_ayrc: Academic Year crs_name: Course Name stu_fnm1: Forename scj_begd: Begin Date sce_crsc: Course Code … stu_dob: Date of Birth scj_endd: Actual End Date sce_blok: Block scj_eend: Estimated End Date sce_occl: Occurrence … sce_stac: Enrolment Status INS_PRG … sce_prgc: Programme Code prg_code: Programme Code sce_rouc: Code prg_name: Programme Name … … INS_ROU rou_code: Route Code rou_name: Route Name …
Student Course Enrolments STUDENT SITS uses one basic record to hold all of a student's personal details. This unique Student (STU) record will remain with them for the whole of their studies at YSJ, from initial application, enrolment and alumni. STUDENT COURSE JOIN Once registered at YSJ, a student can join a course. When a student joins a a Student Course Join (SCJ) record is created. A student can join more than one course at a time or consecutively. STUDENT COURSE ENROLMENT Having joined a course, a student must enrol on each course block/occurrence that s/he wishes to take. Students cannot enrol on a course block/occurrence unless they have joined the course. COURSES, PROGRAMMES and ROUTES Courses, programmes and routes hold various combinations of course-related information. For example, Course: BAJJJFT BA (Hons) Joint FT, Route: ARENJ Art and English Literature INS_STU SRS_SCJ SRS_SCE SRS_CRS stu_code: Student Code scj_code: Student SCJ Code sce_scjc: Student SCJ Code crs_code: Course Code stu_surn: Surname scj_stuc: Student Code sce_ayrc: Academic Year crs_name: Course Name stu_fnm1: Forename scj_begd: Begin Date sce_crsc: Course Code … stu_dob: Date of Birth scj_endd: Actual End Date sce_blok: Block … scj_eend: Estimated End Date sce_occl: Occurrence … sce_stac: Enrolment Status INS_PRG sce_prgc: Programme Code prg_code: Programme Code sce_rouc: Code prg_name: Programme Name … … INS_ROU rou_code: Route Code rou_name: Route Name …
SITS-Data-Table-Links.docx