The Pennsylvania State University - Administrative Information Services, a unit of Information Technology Services

Student DB--Field Changes

Posted: Wednesday, May 14, 2008

Data Warehouse Student Database Users,

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.

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)

Content Questions: Data Warehouse