Jenzabar One Database Access

Preparation

Data exports from Astra Schedule to 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.

Essential Scheduling requires the Base data. 

Student Centered Scheduling and Integrated Planning require the Extended data.

All tables are read-only access unless specified. 

Table Astra  Schedule Base Extended Use
AD_ASTRA_INTERFACE read and write access     Section export
ADVISING_REQ_CODES   X X Course attributes
ATTRIBUTE_DEF     X Lookups, student attributes, test codes
ATTRIBUTE_TRANS     X Student attributes, test codes
BUILDING_MASTER   X X View section details
CATALOG_MASTER_V   X X Courses, Lookups
CRS_COMP_1   X X  
DIVISION_DEF   X X Lookups
INSTIT_DIVISN_DEF   X X  
LOCATION_MASTER   X X View section details
NAME_MASTER X X X Sections, Students
ROOM_MASTER   X CampusBuildingRoom
SECTION_MASTER X     Courses, Sections
SECTION_MASTER_V X X X Courses, Sections
SECTION_SCHEDULES X X X Lookups, Sections
SECTION_SCHEDULES_V X  X X Sections
TERM_DEF   X X Courses, Students, Terms
TEST_DEFINITION      X Student Attributes, Test Codes
TEST_ELEMENT_DEF     X Student Attributes, Test Codes
TEST_SCORES     X Lookups, Students, Student Attributes, Test Codes
TEST_SCORES_DETAIL     X Student Attributes, Test Codes
YEAR_TERM_TABLE   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.