|
||
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 |