Database User Access

The Astra Schedule database user must have access to the following Jenzabar tables and views:

Tables

•SECTIONS_SCHEDULE (read access)

•SECTIONS_MASTER (read access)

•FACULTY_MASTER (read access)

•NAME_MASTER (read access)

•AD_ASTRA_INTERFACE (read and write access)

Views

•SECTION_MASTER_V

•SECTION_SCHEDULES_V

 

 

Details related to the queries used, including specific SIS fields involved, will be provided upon request.  Additionally, the queries can be found in the XML import and/or export spoke files in your installation.  For example, in a standard installation these files would be located in C:\Ad Astra\%YourInstance%\Files\ATEConfiguration\Spokes\SIS.