Databases affected by LionPath

With the LionPath deployment and retirement of ISIS, the extractions of data from the mainframe to the data warehouse have stopped for all ISIS related tables.  The data is current as of Summer 2016.

Below is a list of the databases that are affected.

Database Tentative Last Update
bursar Updates have stopped.  Information in this table is thru Summer 2016.
certificates Updates have stopped as of August 2016 (8/31/2016). Fall 2016 data (201617FA) will only be available in LionPath.   Information in these tables will be current thru Summer 2016 (201516SU).
degreeaud Updates have stopped as of August 2016 (8/31/2016).
dus

Updates have stopped.  Fall 2016 data (201617FA) will only be available in LionPath.   Information in these tables will be current thru Summer 2016 (201516SU).

EPS Table -- Stopped updating 3/12/2016
Interview Table -- Will continue until May 2016.

enrollment

Updates have stopped.  Fall 2016 data (201617FA) will only be available in LionPath.   Information in these tables will be current thru Summer 2016 (201516SU).

  • enrl_cycl_fa last semester in this table will be 201516FA.  Updates have stopped.
  • enrl_cycl_sp last semester in this table will be 201516SP.  Updates have stopped.
  • enrl_cycl_su last semester in this table will be 201516SU.  Updates have stopped.
facility Updates have stopped as of August 2016 (8/31/2016). 
general

Updates have stopped for the following tables as of August 2016 (8/31/2016):

  • ug_registration_credits
  • university_calendar
  • university_holidays
  • gr_registration_credits
  • law_registration_credits
gradappl

Starting on 8/18/2015, information on graduate students applying for semesters FA16 and forward will not be available on ISIS and, consequently, on the Data Warehouse as well.   Beginning 8/18/2015 any existing graduate application for FA16 forward on the data warehouse will be converted to LionPath.  Until this conversion process is complete there will not be one source to get FA16 and forward applications.  It is anticipated this conversion process will only take a few days, but could be longer.    If you have any questions please contact the Graduate School (gradschoolhelp@psu.edu).

The gradappl tables will only be updated with semester 201516SU and prior semesters.   Fall 2016 will only be available with LionPath.

All updates to the gradappl database have stopped.

isiscodesets Updates have stopped as of August 2016 (8/31/2016).
noncredit Updates have stopped as of August 2016 (8/31/2016).
official The ofcl_grad_advising and uf_ofcl_grad_advising have stopped updating as of August 2016 (8/31/2016).
retention Fall 2016 data (201617FA) will only be available in LionPath.  Information in these tables will be current thru Summer 2016(201516SU).  The last update to this database will be in September 2016 with Summer (201516SU) data.
scholars

Updates have stopped as of August 2016 (8/31/2016).  Fall 2016 data (201617FA) will only be available in LionPath.  Information in these tables will be current thru Summer 2016 (201516SU).

All tables in the scholars database will stop updating at the end of August 2016.

student

Course related information will be available on the data warehouse thru Summer 2016 for semesters up to and including Summer 2016.  Fall 2016 course related data will only be available on LionPath.   Registration for Fall 2016 courses starts March 2016.  If you have any questions contact the Registrar's office (esmail@psu.edu).

Starting February 2016 information on registered students (biographical and semester) for FA2016 will only be available in LionPath.  Student information for SU2016 will be available on the data warehouse.

The below student database tables that contain future semester information will not have any records (will be empty) at the start of summer semester (5/9/2016).  These tables contain no data, updates have stopped.

  • student_bio_future 
  • student_sem_future
  • dir_student_bio_future
  • dir_student_sem_future
  • gen_student_bio_future 
  • gen_student_sem_future
  • uf_student_bio_future
  • uf_student_sem_future

The below student and scholars database tables that contain current semester information will not have any records (will be empty) at the start of Fall semester (8/15/2016):

  • dir_student_bio_curr
  • dir_student_sem_curr
  • gen_student_bio_curr
  • gen_student_sem_curr
  • student_sem_curr
  • uf_curr_choa
  • uf_student_bio_curr
  • uf_student_sem_curr
  • curr_choa
  • student_bio_curr
  • student_sem_curr
  • curr_scholars (in the scholars database)

All other tables in the student databases will stop updating at the end of August 2016.

Updates have stopped as of August 2016 (8/31/2016).

Housing_assignments which will continue to update.

ugapplic

Prospect Related Tables have been removed from the data warehouse.
Fall 2015 applicant data the last update will be October 2015
Remaining Ugapplic tables will only be updated with Spring 2016 data until February 2016. If you have any questions contact Vince Timbers vlt@psu.edu.

All Updates to the ugapplic database have stopped.

ulrc

Fall 2016 data (201617FA) will only be available in LionPath.  Semester information prior to Fall 2016 will be available in these tables.

Updates have stopped as of August 2016 (8/31/2016).

Please contact the BI Team (BITeam@psu.edu) with any questions or concerns regarding the Data Warehouse changes.

If you have any questions about Project LionPATH either Email ProjectLionPATH@psu.edu, visit http://projectlionpath.psu.edu/reporting, or call at 814-867-4366.

Was this helpful?: 

No