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

Platinum (Planner/Pathway Only)

AdAttribute   X X
AdAttStat   X  
AdBuilding X X X
AdCatalogYear   X  
AdClassAttend X X X
AdClassSched X X X
AdClassSchedInstructor X X X
AdClassSchedPeriod X X X
AdClassSchedTerm X X X
AdConcentration   X  
AdConcentrationByEnrollment   X  
AdCourse X X X
AdCourseAttribute   X X
AdCourseCrossRef   X X
AdCourseEquiv   X X
AdCourseLevel   X X
AdCoursePreReq   X X
AdCourseType X X X
AdCrossListGroup X X X
AdCrossListSection X X X
AdDegree   X  
AdDeliveryMethod X X X
AdEnroll   X  
AdEnrollSched   X  
AdPeriod X X X
AdProgram   X  
AdProgramVersion   X  
AdRoom X X X
AdShift   X  
AdTerm X X X
SimplifiedAdEnroll   X  
SyCampus X X X
SyCampusGrp X X X
SyCampusList X X X
SySchoolStatus   X  
SyStaff X X X
SyStaffByGroup X X X
SyStaffGroup X X X
syStudent   X  
syUserDict   X  
SyUserValues   X  
 AdClassAttend  select and update    
 AdClassSchedDay select and update    


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



Please sign in to leave a comment.