Data Warehouse Users – Student Database –

The weekend of May 17, 2008, we will be adding some new fields, and deleting one from the below tables in the student database.   The field that will be deleted is CODE_PERS_SCOL_CHARACTERISTIC.  Individuals that we could identify that have used this field in the past have already be notified of this change. 

If anyone has any questions or concerns let me know.  An announcement will be made to the listserv after these changes have been made.

Unless you are using field  CODE_PERS_SCOL_CHARACTERISTIC, your queries will not be affected by this change.

Thanks!
Yvonne

BIO Changes

Tables:  STUDENT_BIO
             STUDENT_BIO_ALL
             STUDENT_BIO_CURR
             STUDENT_BIO_FUTURE

Fields Deleted:  CODE_PERS_SCOL_CHARACTERISTIC  (scholars_characteristic_code)

Fields Added:    INDC_PERS_SEVIS_RPT (sevis_indc)
                        DIPL_ADDR_ST1 (diploma_st1)
                        DIPL_ADDR_ST2 (diploma_st2)
                        DIPL_ADDR_CITY (diploma_city)
                        DIPL_ADDR_STATE (diploma_state)
                        DIPL_ADDR_ZIP (diploma_zip)
                        DIPL_ADDR_CTRY (diploma_country_code)
                        DIPL_ADDR_PROVINCE (diploma_province)
                        DATE_PERS_ADDR_UPD (diploma_address_updated_date)
                        INDC_CONFIDENTIAL (confidentiality_indc)
                        INDC_STUD_FOREIGN_LANG_REG (foreign_language_requirement_indc)

SEM Changes

Tables:  HIST_STUDENT_SEM
             STUDENT_SEM
             STUDENT_SEM_CURR
             STUDENT_SEM_FUTURE

Fields Deleted:  None

Fields Added:    INDC_CONFIDENTIAL (confidentiality_indc)
                       CODE_STUD_OTHER_ADVR (advisor_code_second)
                       INDC_STUD_PT_LAW_REG (law_parttime_program_indc)
                       QNTY_STUD_IL_CRDT (credits_il_semester)
                       QNTY_STUD_TC_CRDT (credits_tc_semester)
                       QNTY_STUD_CC_CRDT (credits_cc_semester)
                       QNTY_STUD_EL_CRDT (credits_el_semester)
                       ENROLL_STATUS (enrollment_status)