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)

HESI
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

Comments

0 comments

Please sign in to leave a comment.