Penn State mark   AIS Header AIS Home Page link ITS Home Page link
in:
Student Sem/Bio ETM fields to be removed

Data Warehouse Student Database Users:
 
The following fields will be removed from the STUDENT_SEM_FUTURE, STUDENT_SEM_CURR,  STUDENT_SEM and HIST_STUDENT_SEM tables in the STUDENT database sometime around May 20th, 2006:

CODE-STUD-CERT-APPR1            
CODE-STUD-CERT-APPR2            
CODE-STUD-CERT-APPR3            
CODE-STUD-CERT-MAJR1            
CODE-STUD-CERT-MAJR2            
CODE-STUD-CERT-MAJR3            
CODE-STUD-CERT-OPT1             
CODE-STUD-CERT-OPT2             
CODE-STUD-CERT-OPT3             
CODE-STUD-MAJR-APPL-OPT1        
CODE-STUD-MAJR-APPL-OPT2        
CODE-STUD-MAJR-APPL-OPT3        
CODE-STUD-MAJR-APPL1            
CODE-STUD-MAJR-APPL2            
CODE-STUD-MAJR-APPL3            
CODE-STUD-MAJR-APPROVAL-APPL1   
CODE-STUD-MAJR-APPROVAL-APPL2   
CODE-STUD-MAJR-APPROVAL-APPL3

All of the above fields can be found on the entrance_to_major table.  The fields are being removed to avoid confusion and duplication. If you are using any of these fields, your queries will need to be changed to point to the entrance_to_major table.

A warning note will be sent before the fields are removed.  At that time, the student_sem tables should be relinked.

If you are using MS Access, you can relink the tables as follows:
Select Tools
Select Database Utilities
Select Linked Table Manager
Click on the box before each table that is affected (I suggest you don't relink tables that are not affected by the change)
Select OK

Thank You

Carol Findley



Questions: Data Warehouse
Printer friendly view



The Pennsylvania State University © 2008 | Copyright | Privacy and Legal Statements | Alternative Media - Nondiscrimination Statement
This site is maintained by Administrative Information Services, a unit of Information Technology Services.
Provide site feedback to AIS-webmaster@psu.edu. Can't find it? Ask AIS
Last revised: Thursday, May 18, 2006 13:19