Penn Computing

University of Pennsylvania
Penn Computing << go backback

PHD_COMMITTEE - Data Element Index . Tables and Data Elements . Student Data Home . Data Warehouse Home

PHD COMMITTEE Table

(dwst.phd_committee)

Explanation

Contains the information about members of the doctoral student's committee, from SRS screen 146

Common Uses

  • Finding faculty members serving on dissertation committees.
  • Finding doctoral candidates who have full dissertation approval of all committee members.

Schema Name

DWST

Primary Key Indexed Data Elements Related Tables
SSN   PHD_DISSERTATION
DEGREE_PURSUAL_ALL_V

Cautions

  • Doctoral students have up to seven committee members; five of them must be affiliated with the University of Pennsylvania. In SRS, the Penn and non-Penn faculty and advisors can be distinguished positionally. No such sequence order is maintained in the data warehouse. Non-Penn committee members will not have an SSN nor a PennID. They will, however, have data in the Committee_Member_Name column. Their name will be the text exactly as it was entered on SRS screen 146.

 

PHD_COMMITTEE - Data Element Index . Tables and Data Elements . Student Data Home . Data Warehouse Home


Questions about this page? Email us at da-staff@isc.upenn.edu

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania