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 |
|---|---|
| AdAttribute | |
| AdBuilding | X |
| AdClassAttend | X |
| AdClassSched | X |
| AdClassSchedInstructor | X |
| AdClassSchedPeriod | X |
| AdClassSchedTerm | X |
| AdCourse | X |
| AdCourseAttribute | |
| AdCourseCrossRef | |
| AdCourseEquiv | |
| AdCourseLevel | |
| AdCoursePreReq | |
| AdCourseType | X |
| AdCrossListGroup | X |
| AdCrossListSection | X |
| AdDeliveryMethod | X |
| AdPeriod | X |
| AdRoom | X |
| AdTerm | X |
| SyCampus | X |
| SyCampusGrp | X |
| SyCampusList | X |
| SyStaff | X |
| SyStaffByGroup | X |
| SyStaffGroup | X |
| AdClassAttend | select and update |
| AdClassSchedDay | select and update |
Comments
Please sign in to leave a comment.