Advisor_Ssn

Advisor_Penn_ID

The 8-digit identification number assigned to the employee 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. It is populated in the Data Warehouse from a extract from PennCommunity.

RT3A2 ADVISOR TYPE

NATURAL ALIAS: ADVISOR-TYPE-RT

appears on SRS screen 1A9

Describes the advisor-to-student relationship.

Values:

A - Academic Advisor
C - Department Chair
H - House Dean
J - Junior/Senior contact
M - Major Advisor
S - School Advisor

Degree_Order

The number 1 or 2 indicating the order of the degree program to which the advisor was assigned in SRS. Note that this is not programmatically tied in SRS to the Degree Programs in the student's term record, and it is entirely possible for an advisor to be assigned to the wrong Degree_Order, including a Degree_Order that doesn't exist on the student's DEGREE_TERM record. For this reason, in the Business Objects student universe, this column is not used to join tables. See "Cautions" for the ADVISOR TERM Table.

Stdt_Penn_ID

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.

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

Term

RT005 STF TERM CODE

NATURAL ALIAS: TERM-RT

Term is part of the record key for all student term data in SRS, and is found in the context line on many SRS screens

Penn divides the academic year into 3 terms or semesters: Fall, Spring, and Summer. Terms are designated by the 4-digit calendar year, followed by a term code. The Spring term code is A, the Summer term code is B, and the Fall term code is C.