Database User Access
The Astra database user must have access to the tables listed below. Additionally, synonyms must be created for each table as the Astra user to facilitate direct queries against the database. Details related to the queries used, including specific SIS fields involved, will be provided upon request.
All tables are read-only access unless specified.
| Table | Astra Schedule | Use |
|---|---|---|
| aa_rec | X | Sections |
| crs_rec | X | Courses, Pgm Rules, Pgm Students, Sections, Lookups |
| id_rec | X | Lookups, Pgm Students, Sections |
| im_table | X | Lookups, Section import, Export |
| mtg_rec | read and write access | Courses, Section import, Export |
| sec_rec | X | Courses, Section import, Export |
| secmtg_rec | X | Courses, Section import, Export |
Comments
Please sign in to leave a comment.