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
acad_cal_rec   Courses, Pgm Students, Terms
cat_table   Courses
cl_table   Lookups
crs_rec X Courses, Pgm Rules, Pgm Students, Sections, Lookups
crsarea_rec   Courses, Lookups
crsreq_rec   Courses
crsreqgrp_rec   Courses
dept_table   Lookups
div_table   Lookups
exam_table   Lookups, Pgm Students
histeq_rec   Courses
id_rec X Lookups, Pgm Students, Sections
im_table X Lookups, Section import, Export
mtg_rec read and write access Courses, Section import, Export
prog_table   Lookups
sch_rec   Lookups
sec_rec X Courses, Section import, Export
secmtg_rec X Courses, Section import, Export
sess_table   Pgm Students, Terms

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



Please sign in to leave a comment.