Jenzabar (EX) Views Data Model

EMS Software will code a set of views specific to your organization’s use of Jenzabar (EX) to allow for integration between EMS and Jenzabar (EX). Outlined are the baseline tables/columns accessed in the views.

EMS Software has created a set of views for Jenzabar (EX) to enable the integration between EMS and Jenzabar (EX). Outlined below are the baseline tables and columns accessed by the views.

Your Implementation Consultant can further assist you with the use of information in EMS supporting the Academic Scheduling process.

Optionally, and on a custom basis, up to 10 User Defined Fields can be added to the set of views for each organization to support desired workflow. Detailed business requirements are needed to provide a quote for customization of the views for this purpose.

Modification of views by the customer is unsupported and voids the Annual Service Agreement for the integration with Jenzabar (EX).

Fields highlighted in BLUE are required to be unique.

Buildings

EMS View – EMS_vwBuildings

View Permissions – Read Only

Jenzabar (EX) Tables – building_master

Purpose –  Used to define buildings list in EMS. Required for buildings that host academic courses; additional buildings can be added manually to EMS if used only for non-academic purposes.

EMS Field

Jenzabar (EX) Field

SISID

bldg_cde

BuildingCode

bldg_cde

BuildingDescription

building_desc

Room Types

EMS View – EMS_vwRoomTypes

View Permissions – Read Only

Jenzabar (EX) Tables – room_master (Distinct values)

Purpose – Used to define room type list in EMS. Room Types classify each room and allows for searching, sorting, and reporting by classification. Additional room types can be added to EMS manually.

EMS Field

Jenzabar (EX) Field

SISID

room_type

RoomTypeDescription

room_type

Rooms

EMS View: EMS_vwRooms

View Permissions – Read Only

Jenzabar (EX) Tables – room_master

Purpose – Used to define list of rooms and their capacities for academic purposes in EMS; related to Buildings and Room Types. Required for rooms that host academic courses; additional rooms can be added manually to EMS if used only for non-academic purposes.

EMS Field

Jenzabar (EX) Field

SISID

bldg_cde + room_cde

SISBuildingID

bldg_cde

SISRoomTypeID

room_type

RoomCode

room_cde

RoomDescription

room_desc

Capacity

max_capacity

Instructors

EMS View –  EMS_vwInstructors

View Permissions – Read Only

Jenzabar (EX) Tables – name_master, faculty_master

Purpose – Used to define list of instructors in EMS; related to Courses.

EMS Field

Jenzabar (EX) Field

SISID

id_num

InstructorDescription

last_name + first_name

Terms

EMS View –  EMS_vwTerms

View Permissions –  Read Only

Jenzabar (EX) Tables: year_term_table

Purpose –  Used to define list of terms in EMS; related to Courses.  In conjunction with Domains, terms separate courses into distinct lists that will go through the academic planning process (synching, optimizing, publishing, reporting) as a unit.

EMS Field

Jenzabar (EX) Field

SISID

yr_cde + trm_cde

TermCode

yr_cde + trm_cde

TermDescription

yr_trm_desc

StartDate

trm_begin_dte

EndDate

trm_end_dte

Subjects

EMS View –  EMS_vwSubjects

View Permissions – Read Only

Jenzabar (EX) Tables – crs_comp_1

Purpose – Used to define list of subjects in EMS. Within EMS, subjects are divided into Domains to create distinct lists of courses per term that will go through the academic planning process (synching, optimizing, publishing, reporting) as a unit, managed by the academic central scheduler.

EMS Field

Jenzabar (EX) Field

SISID

crs_comp_1 (parsed)

SubjectCode

crs_comp_1

SubjectDescription

crs_comp_desc

CampusCode

NULL

DivisionCode

NULL

DepartmentCode

NULL

LevelCode

NULL

CustomCode1

NULL

CustomCode2

NULL

Course Types

EMS View – EMS_vwCourseTypes

View Permissions – Read Only

Jenzabar (EX) Tables – n/a – view returns hard coded value of zero and (none).

Purpose –  Used to define the course type list in EMS; related to coursedates. Course Types are used to classify coursedates for purposes of searching, sorting, optimizing, and reporting.

EMS Field

Jenzabar (EX) Field

SISID

n/a

Description

n/a

Courses

EMS View – EMS_vwCourses

View Permissions – Read Only

Jenzabar (EX) Tables – section_master

Purpose – Used to define the list of courses per term; related to subjects, instructors, terms.

EMS Field

Jenzabar (EX) Field

SISID

yr_cde + trm_cde + crs_cde

SISTermID

yr_cde + trm_cde

SISSubjectID

crs_cde (parsed)

CampusCode

NULL

DepartmentCode

NULL

LevelCode

NULL

CustomCode1

NULL

CustomCode2

NULL

CRN

crs_cde

Course

crs_cde (parsed)

Section

crs_cde (parsed)

CourseTitle

crs_title

SISInstructorID

lead_instructor_id

EstimatedEnrollment

crs_capacity

CrosslistParentID

yr_cde + trm_cde + x_listed_parnt_crs*

ActualEnrollment

crs_enrollment

CreditHours

credit_hrs

*’0’ if not crosslisted

Course Dates

EMS View – EMS_vwCourseDates

View Permissions – Update if allowing EMS to update room locations in Jenzabar (EX)

Jenzabar (EX) Tables – secion_schedule

Purpose – Used to define the list of meeting patterns per course; related to courses, coursetypes, buildings, rooms.

EMS Field

Jenzabar (EX) Field

SISID

yr_cde + trm_cde + crs_cde + row number

SISTermID

yr_cde + trm_cde

SISCourseID

yr_cde + trm_cde + crs_cde

StartDate

begin_dte

EndDate

end_dte

StartTime

begin_tim

EndTime

end_tim

SISBuildingID

bldg_cde*

SISRoomID

bldg_cde + room_cde

RoomID

room_cde*

Sunday

sunday_cde

Monday

monday_cde

Tuesday

tuesday_cde

Wednesday

wednesday_cde

Thursday

thursday_cde

Friday

friday_cde

Saturday

saturday_cde

SISCourseTypeID

0 – hard coded

*Field used for updating room assignments

 

(missing or bad snippet)