CampusVue/Nexus Database Access

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 HESI
AdAttribute   X
AdBuilding X X
AdClassAttend X X
AdClassSched X X
AdClassSchedInstructor X X
AdClassSchedPeriod X X
AdClassSchedTerm X X
AdCourse X X
AdCourseAttribute   X
AdCourseCrossRef   X
AdCourseEquiv   X
AdCourseLevel   X
AdCoursePreReq   X
AdCourseType X X
AdCrossListGroup X X
AdCrossListSection X X
AdDeliveryMethod X X
AdPeriod X X
AdRoom X X
AdTerm X X
SyCampus X X
SyCampusGrp X X
SyCampusList X X
SyStaff X X
SyStaffByGroup X X
SyStaffGroup X X
 AdClassAttend  select and update  
 AdClassSchedDay select and update  

 


Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.