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 Use
aa_rec X Sections
crs_rec X Courses, Pgm Rules, Pgm Students, Sections, Lookups
id_rec X Lookups, Pgm Students, Sections
im_table X Lookups, Section import, Export
mtg_rec read and write access Courses, Section import, Export
sec_rec X Courses, Section import, Export
secmtg_rec X Courses, Section import, Export

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



Please sign in to leave a comment.