Table and Data Details

   Previous topic Next topic JavaScript is required for the print function Mail us feedback on this topic! Mail us feedback on this topic!  

Jenzabar CX Table and Data Detail

 

The interface selects data from various Jenzabar CX tables to make academic sections, meetings, cross-list information, instructors, subjects, courses, and activity statuses available within Astra Schedule. The following tables detail the Jenzabar CX fields being used and their corresponding Astra Schedule values.

NoteNOTE: The following Jenzabar table information assumes that the intermediate table is NOT being used and Astra Schedule will be getting the values directly from the CX database. If the intermediate table is being used, the values are all imported from adastra_rec.

Academic Sections

 

SIS Database Value

Astra Schedule Value

trim(trim(sec_rec.crs_no)||

trim(sec_rec.sec_no)||trim(sec_rec.sess)||to_char(sec_rec.yr))

SisKey

trim(trim(sec_rec.sess)||

to_char(sec_rec.yr))

Term

sec_rec.yr

YearCode

trim(to_char(sec_rec.crs_no))

CourseNumber

trim(to_char(sec_rec.sec_no))

SectionNumber

disc

Subject

substring(crs_rec.crs_no from 1 for 10)

Course

mtg_rec.campus

Campus

crs_rec.title1

Title

sec_rec.max_reg

MaxEnrollment

sec_rec.reg_num

Enrollment

CASE mtg_rec.stat WHEN 'X' then 'C' ELSE

'N' END

StatusCode

Academic Section Meetings

 

SIS Database Value

Astra Schedule Value

trim(trim(sec_rec.crs_no)||'_'||

trim(sec_rec.sec_no)||'_'||trim(sec_rec.sess)||to_char(sec_rec.yr)||'_'||secmtg_rec.mtg_no)

SisKey

trim(to_char(secmtg_rec.mtg_no))

MeetingNumber

CASE WHEN crref_rec.crs_no is not null

THEN trim(to_char(mtg_rec.mtg_no)) ELSE '' END

Cross_List_Number

to_char(mtg_rec.beg_date)

StartDate

to_char(mtg_rec.end_date)

EndDate

lpad(trim(to_char(mtg_rec.beg_tm)),4,0)

StartTime

lpad(trim(to_char(mtg_rec.end_tm)),4,0)

EndTime

substring(im_table.desc from 1 for 10)

MeetingType

replace(mtg_rec.days,'-','')

DaysMet

trim(mtg_rec.bldg)

Building

trim(mtg_rec.room)

Room

Section Meeting Instructors

 

SIS Database Value

Astra Schedule Value

trim(to_char(sec_rec.fac_id))

SisKey

fac_table.abbr_name

FullName

sec_rec.fac_id

Instructor_Id

Page url: ?jenzabarcxsisinterfaceaddendum_3.htm