Penn Computing

University of Pennsylvania
Penn Computing << go backback

PHD_COMMITTEE Table . Tables and Data Elements . Student Data Home . Data Warehouse Home

PHD_COMMITTEE - Data Element Index

Data element mapping back to SRS Definition
Committee_Member_Name

AA52B DISS COMMITTEE ID (an array)
or
AA46Y COMMITTEE NAME1
or
AA46Z COMMITTEE NAME2

NATURAL ALIAS: DISS-COMMITTEE-ID-AA
or
COMMITTE-NM1-AA
or
COMMITTE-NM2-AA

appears on SRS screen 144

The name of the PhDCommittee member. There can be 7 members on a PhD Committee. If the committee member is a University of Pennsylvania faculty or staff, the name will be decoded from the employee record. For non-Penn committee members, the name appears as it was entered in SRS, and there is no associated Penn ID.

Committee_Member_Penn_ID n/a The Penn ID of the PhD Committee member. There can be 7 members on a PhD Committee. For non-Penn committee members, there will be no Penn ID, but there will be a name in Committee Member Name.
Committee_Member_Title

derived from AA52C DISS MEMBER TYPE

appears on SRS screen 144

The decode value of the Committee Member Type, for example: committee chair, dissertation supervisor, reader.

Member_Type

AA52C DISS MEMBER TYPE

NATURAL ALIAS: DISS-MEM-TYPE-AA

appears on SRS screen 144

Describes the role or function of the committee member:

Values:

C = committee chair, 
S = dissertation supervisor, 
R = Reader
Member Approval

AA52D DISS MEMBER APPROVAL

NATURAL ALIAS: DISS-APPROVAL-AA

appears on SRS screen 144

Indicates whether the dissertation has been approved by the committee member.

Values:

  = none
Y = committee member has 
    approved dissertation

Penn_ID
 
appears on SRS screen 103

The 8-digit identification number assigned to the student when their record was created in the PennCommunity database. No two persons have the same Penn_ID. Only persons affiliated with the University will be assigned a Penn_ID.

Penn_ID is not stored in SRS, but can be used on screen 103 to look up a student. It is populated in the Data Warehouse from a extract from PennCommunity.

Note that because the SSN is still the record key in SRS, it is possible for two records to accidentally get created in SRS with different SSNs, for the same person. When this happens, there will be two different records in the Data Warehouse with the same PennID. Please report all PennID duplicates to either Data Administration, or the Office of the University Registrar.

SSN

AA005 STUDENT ID

NATURAL_ALIAS: SID-AA

the record key for all student data in SRS; appears in the context line of all student-related screens

For students who are United States citizens or permanent residents, the Student ID number in SRS is generally the Social Security number of this student. A Social Security number is a unique number assigned to an individual by the federal Social Security Administration.

For foreign students and a few other exceptions, the value in this column may be a Penn-assigned ssn.

Note: Never release a student's Social Security number to anyone without the student's permission. Whenever possible, do not include SSN in your query results, and if you must do so, you do so with the full knowlege that you will be held responsibile for the careful maintenance of any datafiles, reports or other stored data containing SSNs.

Please see http://www.upenn.edu/privacy/ for more about the University's policies and general cautions regarding the use of SSNs.


PHD_COMMITTEE Table . 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