Penn Computing

University of Pennsylvania
Penn Computing << go backback

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

ATHLETIC Table - Data Element Index

 

Data element mapping back to SRS Definition
Athletic_Eligibility

RT257 ATHL ELIG FLAG1
or
RT258 ATHL ELIG FLAG2
or
RT259 ATHL ELIG FLAG3
or
RT261 ATHL ELIG FLAG4
or
RT262 ATHL ELIG FLAG5

NATURAL_ALIAS: ATH-ELG1-RT through ATH-ELG5-RT

appears on SRS screen 119

The column no longer indicates Athletic Eligibility -- a Y or an N in this column indicates the student is on the Athletics' department roster as participating in the sport found in the Athletic_Sport column.. This comes from the "Roster" element on SRS screen 119; updated by the Athletics office, this does not reflect NCAA eligibility.

Athletic Eligibility is tracked elsewhere, and is not available in the Data Warehouse at this time.

NOTE: in Business Objects, the object associated with this column is now called Athletic Roster.

See also Restrict_Sports in the ATHLETIC Table.

Values:

[NULL] Not Applicable, or not yet entered in SRS

N - Not participating
Y - Participating

Athletic_Sport

RT271 ATHLETIC CODE 1
or
RT272 ATHLETIC CODE 2
or
RT273 ATHLETIC CODE 3
or
RT274 ATHLETIC CODE 4
or
RT275 ATHLETIC CODE 5

NATURAL ALIAS: ATH-CD1-RT through ATH-CD5-RT

appears on SRS screen 119

Indicates the intercollegiate sport in which the student may participate this term.

See also Restrict_Sports in the ATHLETIC Table.

Values:

DM - BADMINTON - MEN
DW - BADMINTON - WOMEN
BB - BASEBALL
BM - BASKETBALL - MEN
BX - BASKETBALL - MEN'S JUNIOR VARSITY
BW - BASKETBALL - WOMEN
CH - CREW - HEAVYWEIGHT FRESHMEN
CL - CREW - LIGHTWEIGHT FRESHMEN
CX - CREW - NOVICE WOMEN
EM - CREW - MEN
EW - CREW - WOMEN
HM - LIGHTWEIGHT CREW - MEN
HW - LIGHTWEIGHT CREW - WOMEN
CM - CROSS-COUNTRY - MEN
CW - CROSS-COUNTRY - WOMEN
NM - FENCING - MEN
NW - FENCING - WOMEN
XW - FIELD HOCKEY - WOMEN
FB - FOOTBALL
FK - FOOTBALL WALK-ON
XX - LIGHTWEIGHT FOOTBALL - MEN
GM - GOLF - MEN
GW - GOLF - WOMEN
YM - GYMNASTICS - MEN
YW - GYMNASTICS - WOMEN
LM - LACROSSE - MEN
LW - LACROSSE - WOMEN
MA - MANAGERS
SB - SOFTBALL
SM - SOCCER - MEN
SW - SOCCER - WOMEN
QM - SQUASH - MEN
QW - SQUASH - WOMEN
TM - TENNIS - MEN
TW - TENNIS - WOMEN
RM - TRACK - MEN
RW - TRACK - WOMEN
VM - VOLLEYBALL - MEN
VW - VOLLEYBALL - WOMEN
WM - SWIMMING - MEN
WW - SWIMMING - WOMEN
WR - WRESTLING - MEN

Last_Activity_Date n/a

The date this record was downloaded via the SRS extract process and loaded into the Warehouse. This information is stored in the Warehouse in date format.

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.

Restrict_Attend_Dates AA08L ATTEND DATE RESTRICT
NATURAL ALIAS: RS-AD-DT-BIO
appears on SRS screen 11

Indicates whether a student has notified the University to restrict this information from release to persons outside of the University.

Values:

[Null] The student has placed no restriction on this information.

Y Restricted. Do not release outside the University.

Restrict_Sports AA08U SPORTS PART RESTRICT
NATURAL ALIAS: RS-SPORT-BIO
appears on SRS screen 11

Indicates whether a student has notified the University to restrict the sports in which he or she has participated from release to persons outside of the University.

Values:

[Null]    The student has placed no restriction on this information.

Y          Restricted.  Do not release outside the University.
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

The term in which information about this student pursuing this degree 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.

 

 

ATHLETIC 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