|
||
The Astra Schedule database user must have access to the following Jenzabar tables and views.
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… |
ACAD_STANDING_DEF |
ACAD_STANDING_DEF |
|
Lookups |
AD_ASTRA_INTERFACE |
|
AD_ASTRA_INTERFACE (read and write access) |
Section export |
ADV_TREE_TABLE |
|
|
Pgm Rules |
ADVISING_REQ_CODES |
|
|
Pgm Rules |
ATTRIBUTE_DEF |
ATTRIBUTE_DEF |
|
Lookups |
BUILDING_MASTER |
|
|
CampusBuildingRoom |
CANDIDACY |
CANDIDACY |
|
Lookups, Students |
CANDIDACY_TYPE_DEF |
CANDIDACY_TYPE_DEF |
|
Lookups |
CATALOG_MASTER |
CATALOG_MASTER |
|
Courses, Lookups |
CATALOG_MASTER_V |
CATALOG_MASTER_V |
|
Courses, Lookups |
CERTIFICATION_DEF |
CERTIFICATION_DEF |
|
Lookups |
CLASS_DEFINITION |
CLASS_DEFINITION |
|
Lookups |
CONCENTRATION_DEF |
CONCENTRATION_DEF |
|
Lookups |
COREQ_TABLE_V |
COREQ_TABLE_V |
|
Courses |
CREDIT_TYPE_DEF |
|
|
Students |
DEGREE_AIM_XREF |
|
|
Pgm Rules |
DEGREE_DEFINITION |
DEGREE_DEFINITION |
|
Lookups |
DEPARTMENT |
DEPARTMENT |
|
Lookups, Courses, Students |
DIVISION_DEF |
DIVISION_DEF |
|
Lookups |
LOCATION_MASTER |
|
|
CampusBuildingRoom |
MAJOR_MINOR_DEF |
MAJOR_MINOR_DEF |
|
Lookups, Pgm Rules |
NAME_MASTER |
NAME_MASTER |
NAME_MASTER |
Sections, Students |
PREREQ_TABLE_V |
PREREQ_TABLE_V |
|
Courses |
PROGRAM_DEF |
PROGRAM_DEF |
|
Lookups, Pgm Rules |
ROOM_MASTER |
|
|
CampusBuildingRoom |
SECTION_MASTER |
SECTION_MASTER |
SECTIONS_MASTER |
Courses, Sections |
SECTION_MASTER_V |
SECTION_MASTER_V |
SECTION_MASTER_V |
Courses, Sections |
SECTION_SCHEDULES |
SECTION_SCHEDULES |
SECTIONS_SCHEDULES |
Lookups, Sections |
SECTION_SCHEDULES_V |
SECTION_SCHEDULES_V |
SECTION_SCHEDULES_V |
Sections |
STUD_ADV_ALTER |
|
|
Student Pgm Rules |
STUD_AIMS |
|
|
Students |
STUDENT_CRS_HIST_V |
|
|
Students |
STUDENT_TERM_SUM |
|
|
Students |
STUDENT_VIEW |
|
|
Students |
TERM_DEF |
TERM_DEF |
|
Courses, Students, Terms |
TEST_SCORES |
TEST_SCORES |
|
Lookups, Students |
YEAR_TERM_TABLE |
YEAR_TERM_TABLE |
|
Courses, Pgm Rules, Students, Terms |