| Data element |
mapping back to SRS |
Definition |
| Student_Penn_ID |
n/a |
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. It is populated in the Data Warehouse
from a extract from PennCommunity. |
| Term |
RT005 STF TERM CODE
NATURAL ALIAS: TERM-RT
part of the context line for SRS screen 1A3 |
The term in which Equity and Access information about this student
applies.
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. |
| PENNCAP_Funding_Source |
RT278 PENNCAP STATUS CODE
NATURAL ALIAS: PNCAP-ST-RT
appears on SRS screen 1A3 |
Indicates funding source for PENNCAP services.
Values:
1 - PC/ACT 101
2 - PC/SSS
3 - PC/UNIVERSITY
4 - PC/UNIV. MATCH |
| Elig_for_Tutor |
RT283 ELIGIBLE FOR TUTOR
NATURAL ALIAS: ELG-TU-FL-RT
appeas on SRS screen 1A3 |
Indicates the student's eligibility for tutoring
Values:
Y - YES
N - NO |
| Tutor_Funding_Source1 |
RT286 ELIGIBLE FOR TUTOR C
NATURAL ALIAS: ELG-TU-CD-RT
appears on SRS screen 1A3 |
Indicates the funding source for alternate services
Values:
1 - NEED-BASED AID ELIGIBLE
2 - ATHLETIC REFERRAL
3 - LEARNING RESOURCES REFERRAL
4 - PENNCAP
5 - FEE TUTORING
6 - TUTOR
7 - AFFIRMATIVE ACTION REFERRAL
8 - SPECIAL EVENT TUTORIALS
9 - OLD EXAMS FILE |
| Tutor_Funding_Source2 |
RT287 ELIGIBLE FOR TUTOR C
NATURAL ALIAS: ELG-TU2CD-RT
appeasr on SRS screen 1A3 |
Indicates a second funding source for alternate services, if applicable.
Values:
1 - NEED-BASED AID ELIGIBLE
2 - ATHLETIC REFERRAL
3 - LEARNING RESOURCES REFERRAL
4 - PENNCAP
5 - FEE TUTORING
6 - TUTOR
7 - AFFIRMATIVE ACTION REFERRAL
8 - SPECIAL EVENT TUTORIALS
9 - OLD EXAMS FILE |
| Pre_Freshman_Program |
RT279 PRE-FRESHMAN FLAG
NATURAL ALIAS: PREFRSH-RT
appears on SRS screen 1A3 |
A flag that indicates participation in the Pre-Freshman program.
Values:
Y - YES
N - NO |
| Pre_Law_Program |
RT281 PRE-LAW MENTORING
NATURAL ALIAS: PRELW-MEN-RT
appears on SRS screen 1A3 |
A flag that indicates participation in the Pre-Law Mentoring program.
Values:
Y - YES
N - NO |
| Pre_Med_Program |
RT280 PRE-MED MENTORING
NATURAL ALIAS: PREMD-MEN-RT
appears on SRS screen 1A3 |
A flag that indicates participation in the Pre-Med Mentoring program.
Values:
Y - YES
N - NO |
| Learning_Resources_Code |
RT284 LEARNING RESOURCE
NATURAL ALIAS: LRNG-RES-RT
appears on SRS screen 1A3
|
A code that indicates type of participation in the non-tutoring counseling services.
Values:
1 - LEARNING RESOURCES:AID ELIGIBLE
2 - LEARNING RESOURCES:NOT AID ELIGIBLE
3 - STUDENT DISABILITIES SERVICES:AID ELIGIBLE
4 - STUDENT DISABILITIES SERVICES:NOT AID ELIGIB LE
5 - LR & SDS: AID ELIGIBLE
6 - LR & SDS: NOT AID ELIGIBLE |
| Last_Activity_Date |
n/a |
The date this record was downloaded via the SRS extract process and loaded
into the Warehouse. |
| Student_SSN |
n/a |
Restricted field.
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. |
