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