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 Platinum HESI Use
ACAD_STANDING_DEF     X   Lookups
AD_ASTRA_INTERFACE read and write access       Section export
ADVISING_REQ_CODES     X   Pgm Rules
ATTRIBUTE_DEF     X X Lookups
BUILDING_MASTER   X     View section details
CANDIDACY     X   Lookups, Students
CANDIDACY_TYPE_DEF     X   Lookups
CATALOG_MASTER     X X Courses, Lookups
CATALOG_MASTER_V   X X X Courses, Lookups
CERTIFICATION_DEF     X   Lookups
CLASS_DEFINITION     X X Lookups
CONCENTRATION_DEF     X   Lookups
COREQ_TABLE_V     X X Courses
CREDIT_TYPE_DEF     X   Students
CRS_COMP_1   X      
DEGREE_DEFINITION     X   Lookups
DEPARTMENT     X X Lookups, Courses, Students
DIVISION_DEF   X X X Lookups
INSTIT_DIVISN_DEF   X      
LOCATION_MASTER   X     View section details
MAJOR_MINOR_DEF     X   Lookups, Pgm Rules
NAME_MASTER X X X X Sections, Students
PREREQ_TABLE_V     X X Courses
PROGRAM_DEF     X   Lookups, Pgm Rules
ROOM_MASTER   X   CampusBuildingRoom
SECTION_MASTER X   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
STUD_AIMS     X   Students
STUDENT_CRS_HIST_V     X   Students
STUDENT_TERM_SUM     X   Students
STUDENT_VIEW     X   Students
TERM_DEF   X X X Courses, Students, Terms
TEST_SCORES     X X Lookups, Students
YEAR_TERM_TABLE   X X X Courses, Pgm Rules, Students, Terms
YR_TRM_SBTRM_TABLE   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.