Data Access

The Astra Schedule database user must have access to the following Colleague tables:

 

•COURSES (read access)

•COURSE_SECTIONS (read access)

•COURSE_SEC_MEETING (read and write access)

•SEC_STATUSES (read access)

•STC_STATUSES (read access)

•STUDENT_COURSE_SEC (read access)

•COURSE_SEC_FACULTY (read access)

•PEOPLE_EMAIL (read access)

•PERSON (read access)

 

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.

 

 

NOTE:  If you are using Oracle for your database, synonyms must be created for each table as the Astra Schedule user to facilitate direct queries against the database.

 

Use the commands displayed below to create the proper synonyms via SQL Developer, Toad, or other database administration tool. Log in to the Colleague database as the Astra Schedule user that was created for use in the import/export process before running these commands.

 

Note that <COLLEAGUE_SCHEMA> should be replaced with the name of your schema. (Example:  COLL_PRODUCTION.COURSE_SECTIONS)

 

Run the following commands:

 

•CREATE SYNONYM COURSE_SECTIONS FOR <COLLEAGUE_SCHEMA>.COURSE_SECTIONS;

•CREATE SYNONYM COURSE_SEC_MEETING FOR <COLLEAGUE_SCHEMA>.COURSE_SEC_MEETING;

•CREATE SYNONYM SEC_STATUSES FOR <COLLEAGUE_SCHEMA>.SEC_STATUSES;

•CREATE SYNONYM STC_STATUSES FOR <COLLEAGUE_SCHEMA>.STC_STATUSES;

•CREATE SYNONYM STUDENT_COURSE_SEC FOR <COLLEAGUE_SCHEMA>.STUDENT_COURSE_SEC;

•CREATE SYNONYM COURSE_SEC_FACULTY FOR <COLLEAGUE_SCHEMA>.COURSE_SEC_FACULTY;

•CREATE SYNONYM PEOPLE_EMAIL FOR <COLLEAGUE_SCHEMA>.PEOPLE_EMAIL;

•CREATE SYNONYM PERSON FOR <COLLEAGUE_SCHEMA>.PERSON;