Astra Schedule Help (8.0)

Jenzabar EX Database Access

Hide Navigation Pane

Jenzabar EX Database Access

Previous topic Next topic  

Jenzabar EX Database Access

Previous topic Next topic JavaScript is required for the print function  

Data Access

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