Jenzabar EX & Jenzabar One Database Access

Preparation

Data exports from Astra Schedule to Jenzabar EX & Jenzabar One are written to a temp table in the Jenzabar database called AD_ASTRA_INTERFACE.  This table has triggers configured to update the appropriate Jenzabar tables.

AD_ASTRA_INTERFACE is automatically included in newer versions of the Jenzabar database schema.  If this table is not included in your database, please contact Jenzabar for assistance.

The AD_ASTRA_SEQ_NUM column in the AD_ASTRA_INTERFACE table must be configured manually within MSSQL to auto increment.

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 Monitor Align & Predict HESI Use
AD_ASTRA_INTERFACE read and write access       Section export
ATTRIBUTE_DEF       X Lookups
BUILDING_MASTER   X X   View section details
CATALOG_MASTER       X Courses, Lookups
CATALOG_MASTER_V   X X X Courses, Lookups
CLASS_DEFINITION       X Lookups
COREQ_TABLE_V       X Courses
CRS_COMP_1   X X    
DEPARTMENT       X Lookups, Courses, Students
DIVISION_DEF   X X X Lookups
INSTIT_DIVISN_DEF   X X    
LOCATION_MASTER   X X   View section details
NAME_MASTER X X X X Sections, Students
PREREQ_TABLE_V       X Courses
ROOM_MASTER   X   CampusBuildingRoom
SECTION_MASTER X     X Courses, Sections
SECTION_MASTER_V X X X X Courses, Sections
SECTION_SCHEDULES X X X X Lookups, Sections
SECTION_SCHEDULES_V X  X X X Sections
TERM_DEF   X X X Courses, Students, Terms
TEST_SCORES       X Lookups, Students
YEAR_TERM_TABLE   X X X Courses, Pgm Rules, Students, Terms
YR_TRM_SBTRM_TABLE   X X   View section details

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

Comments

0 comments

Please sign in to leave a comment.