Jenzabar (CX - Informix) Views Data Model

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

EMS Software has created a set of views for Jenzabar (CX) to enable the integration between EMS and Jenzabar (CX). 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 (CX).

Fields highlighted in BLUE are required to be unique.

Buildings

EMS View – EMS_vwBuildings

View Permissions –  Read Only

Jenzabar (CX) Tables –  bldg_table

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 (CX) Field

SISID

bldg

BuildingCode

bldg

BuildingDescription

txt

Room Types

EMS View –  EMS_vwRoomTypes

View Permissions –  Read Only

Jenzabar (CX) Tables –  facil_table (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 (CX) Field

SISID

ctgry

RoomTypeDescription

ctgry

Rooms

EMS View – EMS_vwRooms

View Permissions –  Read Only

Jenzabar (CX) Tables – facil_table

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 (CX) Field

SISID

bldg + room

SISBuildingID

bldg

SISRoomTypeID

ctgry

RoomCode

room

RoomDescription

descr

Capacity

max_occ

Instructors

EMS View –  EMS_vwInstructors

View Permissions –  Read Only

Jenzabar (CX) Tables –  id_rec, sec_rec (Distinct values)

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

EMS Field

Jenzabar (CX) Field

SISID

sec_rec.fac_id

InstructorDescription

fullname

Terms

EMS View –  EMS_vwTerms

View Permissions –  Read Only

Jenzabar (CX) Tables – acad_cal_rec, sess_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 (CX) Field

SISID

yr + sess + subsess

TermCode

yr + sess + subsess

TermDescription

yr + txt

StartDate

beg_date

EndDate

end_date

Subjects

EMS View –  EMS_vwSubjects

View Permissions –  Read Only

Jenzabar (CX) Tables –  crs_rec (Distinct values)

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 (CX) Field

SISID

crs_no (parsed)

SubjectCode

crs_no (parsed)

SubjectDescription

crs_no (parsed)

CampusCode

‘’

DivisionCode

‘’

DepartmentCode

‘’

LevelCode

‘’

CustomCode1

‘’

CustomCode2

‘’

Course Types

EMS View – EMS_vwCourseTypes

View Permissions –  Read Only

Jenzabar (CX) Tables –  im_table

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 (CX) Field

SISID

im

Description

descr

Courses

EMS View – EMS_vwCourses

View Permissions –  Read Only

Jenzabar (CX) Tables –  sec_rec, crs_rec, secmtg_rec

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

EMS Field

Jenzabar (CX) Field

SISID

crs_no + cat + yr + sess + sec_no

SISTermID

yr + sess

SISSubjectID

dept

CampusCode

‘’

DepartmentCode

‘’

LevelCode

‘’

CustomCode1

‘’

CustomCode2

‘’

CRN

crs_no

Course

crs_no (parsed)

Section

sec_no

CourseTitle

title1*

SISInstructorID

fac_id

EstimatedEnrollment

max_reg

CrosslistParentID

crs_no + cat + yr + sess + sec_no*

ActualEnrollment

reg_num

CreditHours

hrs

*First record from crs_rec based on crs_no
**’0’ if not crosslisted, otherwise matches on secmtg_rec.mtg_no

Course Dates

EMS View – EMS_vwCourseDates

View Permissions –  Read Only

Jenzabar (CX) Tables –  mtg_rec, secmtg_rec, sec_rec

Jenzabar (CX) Table Permissions –  Update on mtg_rec table if allowing EMS to update room locations in Jenzabar (CX)

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

EMS Field

Jenzabar (CX) Field

SISID

mtg_no

SISTermID

sec_rec.yr + sec_rec.sess + sec_rec.subsess

SISCourseID

secmtg_rec.crs_no + secmtg_rec.cat + secmtg_rec.yr + secmtg_rec.sess + secmtg_rec.sec_no

StartDate

beg_date

EndDate

end_date

StartTime

beg_tm

EndTime

end_tm

SISBuildingID

bldg*

SISRoomID

bldg + room

RoomID

room*

Sunday

days (parsed)

Monday

days (parsed)

Tuesday

days (parsed)

Wednesday

days (parsed)

Thursday

days (parsed)

Friday

days (parsed)

Saturday

days (parsed)

SISCourseTypeID

im

*Field used for updating room assignment

 

(missing or bad snippet)