GetTimetable/Scyllabus

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

Setup

Description

Name of the setting.

SQL Server

DNS or IP address of the Microsoft SQL server where the Synergetic database is stored.

Database

Scyllabus database name.

Username

SQL Username to access database.

Password

SQL Password to access database.