GetTimetable/Scyllabus: Difference between revisions

From UmsWiki
Jump to navigation Jump to search
Kia (talk | contribs)
Created page with "none|thumb|783x783px"
 
Kia (talk | contribs)
No edit summary
 
(6 intermediate revisions by the same user not shown)
Line 1: Line 1:
[[File:GetTimeTable Scyllabus.jpg|none|thumb|783x783px]]
==Prerequisites==
There must be views created in Scyllabus for UMS to extract data.
 
These views are:
 
*rdowner.UMS_ACTTIMETABLE
**InternalID
**parentinternalid
**activityhostkey
**scheduledstart
**scheduledend
*rdowner.UMS_ACTSTAFF
**InternalID
**parentinternalid
**activityhostkey
**staffhostkey
**staffname
*rdowner.UMS_ACTLOCATION
**InternalID
**parentinternalid
**activityhostkey
**locationhostkey
**locationdescription
**locationname
*rdowner.UMS_ACTSTUDENTSET
**InternalID
**parentinternalid
**activityhostkey
**studentsethostkey
**studentsetname
**studentsetdescription
*rdowner.UMS_ACTMODULE
**InternalID
**parentinternalid
**activityhostkey
**modulehostkey
**modulename
**moduledescription
 
The students will be attached to timetable blocks based on information extracted from the GetStudents job. This is done by looking at the activityhostkey from Scyllabus and the activity in the Students table. The students will be attached if they match.
 
==Setup==
[[File:GetTimetable Scyllabus.jpg|none|thumb|689x689px]]
 
===[[GetTimetable/Format and content|Format and content]]===
 
===Description===
Name of the setting.
 
===[[GetTimetable/Absence_settings|Absence settings]]===
 
===[[GetTimetable/Export_settings|Export settings]]===
 
==FAQ==

Latest revision as of 09:49, 14 February 2020

Prerequisites

There must be views created in Scyllabus for UMS to extract data.

These views are:

  • rdowner.UMS_ACTTIMETABLE
    • InternalID
    • parentinternalid
    • activityhostkey
    • scheduledstart
    • scheduledend
  • rdowner.UMS_ACTSTAFF
    • InternalID
    • parentinternalid
    • activityhostkey
    • staffhostkey
    • staffname
  • rdowner.UMS_ACTLOCATION
    • InternalID
    • parentinternalid
    • activityhostkey
    • locationhostkey
    • locationdescription
    • locationname
  • rdowner.UMS_ACTSTUDENTSET
    • InternalID
    • parentinternalid
    • activityhostkey
    • studentsethostkey
    • studentsetname
    • studentsetdescription
  • rdowner.UMS_ACTMODULE
    • InternalID
    • parentinternalid
    • activityhostkey
    • modulehostkey
    • modulename
    • moduledescription

The students will be attached to timetable blocks based on information extracted from the GetStudents job. This is done by looking at the activityhostkey from Scyllabus and the activity in the Students table. The students will be attached if they match.

Setup

Format and content

Description

Name of the setting.

Absence settings

Export settings

FAQ