Astra Schedule Help (8.0)

Jenzabar CX Database Access

Hide Navigation Pane

Jenzabar CX Database Access

Previous topic Next topic  

Jenzabar CX Database Access

Previous topic Next topic JavaScript is required for the print function  

Data Access

Database User Access

 

The Astra Schedule database user must have access to the following Jenzabar CX tables.

 

Details related to the queries used, including specific SIS fields involved, will be provided upon request.  Additionally, the queries can be found in the XML import and/or export spoke files in your installation.  For example, in a standard installation these files would be located in C:\Ad Astra\%YourInstance%\Files\ATEConfiguration\Spokes\SIS.

 

*All tables require select access unless specified

 

Platinum

HESI

Astra Schedule

Used for…

aa_rec

aa_rec

aa_rec

Sections

acad_cal_rec

acad_cal_rec

 

Courses,

Pgm Students,

Terms

acad_stat_table

acad_stat_table

 

Lookups,

Student Pgm Rules

audcrit_rec

 

 

Pgm Rules

audreq_rec

 

 

Pgm Rules

audseq_rec

 

 

Pgm Rules

cat_table

cat_table

 

Courses

cl_table

cl_table

 

Lookups

conc_table

conc_table

 

Lookups

crs_rec

crs_rec

crs_rec

Courses,

Pgm Rules,

Pgm Students,

Sections,

Lookups

crsarea_rec

crsarea_rec

 

Courses,

Lookups

crsreq_rec

crsreq_rec

 

Courses

crsreqgrp_rec

crsreqgrp_rec

 

Courses

currenr_table

 

 

Pgm Students

cw_rec

 

 

Pgm Students,

Student Pgm Rules

cwsubst_rec

 

 

Student Pgm Rules

deg_table

deg_table

 

Lookups

dept_table

dept_table

 

Lookups

div_table

div_table

 

Lookups

exam_rec

 

 

Pgm Students

exam_table

exam_table

 

Lookups,

Pgm Students

facil_table

 

 

CampusBuildingRoom

histeq_rec

histeq_rec

 

Courses

id_rec

id_rec

id_rec

Lookups,

Pgm Students,

Sections

im_table

im_table

im_table

Lookups,

Section import and export

major_table

major_table

 

Lookups

minor_table

minor_table

 

Lookups

mtg_rec

mtg_rec

mtg_rec

Courses,

Section import and export

prog_enr_rec

 

 

Pgm Rules,

Pgm Students,

Student Pgm Rules

prog_table

prog_table

 

Lookups

res_table

res_table

 

Lookups

roomtype_table

 

 

CampusBuildingRoom

sareq_rec

 

 

Pgm Rules

sareq_table

 

 

Pgm Rules

sareqfld_table

 

 

Pgm Rules

sch_rec

sch_rec

 

Lookups

sec_rec

sec_rec

sec_rec

Courses,

Section import and export

secmtg_rec

secmtg_rec

secmtg_rec

Courses,

Section import and export

sess_table

sess_table

 

Pgm Students,

Terms

subaud_table

 

 

Pgm Rules

subcrit_rec

 

 

Pgm Rules

systables

 

 

CampusBuildingRoom