Jenzabar CX 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 HESI Use
aa_rec X X X Sections
acad_cal_rec   X X Courses, Pgm Students, Terms
cat_table   X X Courses
cl_table   X X Lookups
conc_table   X   Lookups
crs_rec X X X Courses, Pgm Rules, Pgm Students, Sections, Lookups
crsarea_rec   X X Courses, Lookups
crsreq_rec   X X Courses
crsreqgrp_rec   X X Courses
currenr_table   X   Pgm Students
cw_rec   X   Pgm Students, Student Pgm Rules
deg_table   X   Lookups
dept_table   X X Lookups
div_table   X X Lookups
exam_rec   X   Pgm Students
exam_table   X X Lookups, Pgm Students
histeq_rec   X X Courses
id_rec X X X Lookups, Pgm Students, Sections
im_table X X X Lookups, Section import, Export
major_table   X   Lookups
minor_table   X   Lookups
mtg_rec read and write access X X Courses, Section import, Export
prog_enr_rec   X   Pgm Rules, Pgm Students, Student Pgm Rules
prog_table   X X Lookups
res_table   X   Lookups
sch_rec   X X Lookups
sec_rec X X X Courses, Section import, Export
secmtg_rec X X X Courses, Section import, Export
sess_table   X X Pgm Students, Terms
systables   X   CampusBuildingRoom

 


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

Comments

0 comments

Please sign in to leave a comment.