Penn Computing

University of Pennsylvania
Penn Computing << go backback

SRS UNDERGRAD_ADMISSIONS Table . Tables and Data Elements . Student Records Data Home . Data Warehouse Home

SRS UNDERGRAD ADMISSIONS Table - Data Element Index

Data element mapping back to SRS Definition
Academic_Index

AM5A7 ACADEMIC INDEX

NATURALALIAS: UG-ACAD-IDX-AM

appears on SRS screen 312

 

A score that summarizes the academic performance of applicants to undergraduate degree programs, Academic Index combines numeric values based on a student's SAT I and SAT II scores plus his/her high school class rank or GPA. At Penn, the AI is a scale of 1 to 9, with 9 being the highest.
Academic_Rating_1
AM590 ACADEMIC RATING 1 - does not appear in online SRS Academic rating assigned by the first reader of the student's application. '1' is lowest; '9' is highest.

Values:


NULL - Not reported

1 - 9


Academic_Rating_2 AM596 ACADEMIC RATING 2 - does not appear in online SRS Academic rating assigned by the second reader of the student's application. '1' is lowest; '9' is highest.

Values:


NULL - Not reported

1 - 9


Ach_Test_1

AM566 HIGHEST ACH TEST

NATURAL ALIAS: ACHTST-1-AM

appears on SRS screen 312

A student may choose to take any number of several achievement tests to prove efficiency in specific subjects. The achievement test is which the student received his best score. If this field is null, no achievement test was reported.

Values:


NULL - None reported

AH - American History

BY - Biology

CH - Chemistry

CL - Chinese Listening

EN - English Comp

ES - English Comp w/Essay

EL - English Language Proficiency

EH - European History

FR - French

FL - French Listening

GM - German

GL - German Listening

HB - Hebrew

MH - Modern Hebrew

IT - Italian

JL - Japanese Listening

LT - Latin

LR - Literature

M1 - Math Level 1

M2 - Math Level 2

1C - Math Level 1C

2C - Math Calculator

PH - Physics

RN - Russian

SP - Spanish

SL - Spanish Listening

WH - World History

WR - Writing

Ach_Test_1_Score
 

AM568 HIGHEST ACH SCORE

NATURAL ALIAS: ATST1-SC-AM

appears on SRS screen 312

The student's best achievement test score as-of the time of their application to Penn. If the score is NULL, there is no reported best achievement test score. Note that the achievement test scores also appear in this table in the column associated with the specific test, for example: Biology_Test, Chemistry_Test, etc.

 

Ach_Test_2

AM570 2ND HI ACH TEST

NATURAL ALIAS: ACHTST-2-AM

appears on SRS screen 312

A student may choose to take any number of several achievement tests to prove efficiency in specific subjects. The achievement test is which the student received his second best score. If this field is null, no second achievement test was reported.

Values:

See Ach_Test_1

Ach_Test_2_Score

AM572 2ND HI ACH SCORE

NATURAL ALIAS: ATST2-SC-AM

appears on SRS screen 312

The student's second best achievement test score as-of the time of their application to Penn. If the score is NULL, there is no reported second achievement test score.

 

Ach_Test_3

AM574 3RD HI ACH TEST

NATURAL ALIAS: ACHTST-3-AM

appears on SRS screen 312

A student may choose to take any number of several achievement tests to prove efficiency in specific subjects. The achievement test is which the student received his third best score. If this field is null, no third achievement test was reported.

Values:

See Ach_Test_1

Ach_Test_3_Score

AM576 3RD HI ACH SCORE

NATURAL ALIAS: ATST3-SC-AM

appears on SRS screen 312

The student's third best achievement test score as-of the time of their application to Penn. If the score is NULL, there is no reported third achievement test score.

 

ACT_Composite_Score

AM5A1 A.C.T. COMPOSITE

NATURAL ALIAS: UG-ACT-COMP-AM

appears on SRS screen 312

The ACT Composite test score as-of the time of the student's application to Penn. The ACT is a widely used standardized college admissions test, comprised of four subject area parts. The ACT Composite score is the total score on the whole ACT, calculated by averaging the four Subject Test scores.

Note that the ACT score was not included in the undergraduate admissions application until 2006. Years prior to 2006 will have all '0's in the ACT score columns.

ACT_Converted_Composite

AM5A2 A.C.T. CONVRTD COMP

NATURAL ALIAS: UG-ACT-CNVRTD-AM

appears on SRS screen 312

A converted score, used by colleges and the NCAA in comparing scores for the ACT and SAT exams.

Note that the ACT score was not included in the undergraduate admissions application until 2006. Years prior to 2006 will have all '0's in the ACT score columns.

Admissions_Major

AM526 ADMISSIONS MAJOR

NATURAL ALIAS: INT-MAJ-AM

appears on SRS screen 312

The student's intended major as reported to undergraduate admissions.

Refer to the MAJOR_MINOR table for valid values.

Admissions_SSN n/a The social security number in the format 999-99-9999 as reported from the undergraduate admissions file. May be null. SSN is a protected field, and most users of the Data Warehouse will not see any data in this column.
Alumni_Affiliation

AM554 ALUMNI AFFILIATION

NATURAL ALIAS: ALM-AFF-AM

appears on SRS screen 312

Indicates the type of alumnus, if any, to whom the student is related.

Values:


NULL - None

1 - Graduate/Professional

2 - Undergraduate

3 - Both


American_History_Test

AM59M AM HISTORY ACH TEST

appears on screen 312 if it is one of the top three scores

The student's American History achievement test score. If the score equals zero, the student did not take this test.

 

Applicant_Type

AM512 APPLICANT TYPE

This field does not explicitly display in SRS, but the "Transfer" and "Early Decision" tags on SRS screen 312 are derived from the value in this field

 
The category through which the student applied.

Values:


NULL - Not reported

1 - Regular Freshman

2 - EDP Freshman

3 - Transfer

4 - Transfer to Degree Standing

Athletic_Rating

AM544 ATHLETIC RATING

NATURAL ALIAS: ATH-RAT-AM

appears on SRS screen 312

The student's athletic rating established by intercollegiate athletics and undergraduate admissions. Non-athletes will have a rating of NULL. A rating greater than '2' indicates that the students is considered a recruited athlete.

Values:


NULL; 1-6
Ben_Franklin_Scholar

AM534 BEN FRANKLIN SCHLR

does not appear online in SRS

Indicates whether the student will participate in the Benjamin Franklin Scholar program.

Values:


NULL - No

1 - Yes


Biology_Test

AM59J BIOLOGY ACH TEST

appears on screen 312 if it is one of the top three scores

The student's Biology achievement test score. If the score equals NULL, the student did not take the test.

 

Chemistry_Test

AM59K CHEMISTRY ACH TEST

appears on screen 312 if it is one of the top three scores

The student's Chemistry achievement test score. If the score equals NULL, the student did not take the test.

 

Chinese_Listening_Test

 AM59Y CHINESE LSTNING ACH

appears on screen 312 if it is one of the top three scores

The student's Chinese Listening achievement test score. If the score equals NULL, the student did not take the test.

 

Class_Component

AM528 CLASS COMPONENT

does not appear in online SRS

A code that specifies an attribute that may be a contributing factor in the decision to admit the student to Penn.

Values:


NULL - Not reported

1 - Top Quarter

2 - 60 percent

3 - High Personal

4 - Special Interest

5 - Athlete

6 - Socio/Economic

7 - Alumni
8 - Faculty/Staff
Cohort_Date

AM516 COHORT DATE

does not appear in online SRS

The year and month of the beginning of the student's planned matriculation. Recorded in the format: YYMM. Where 'YY' is the last two characters of the four-digit year and 'MM' is the numeric equivalent for the month. NOTE! This is not 21st-century compliant.
Converted_Rank

AM584 CONVERTED RANK

NATURAL ALIAS:

appears on SRS screen 312

The student's converted class rank in their high school class adjusted to allow comparison between classes of different sizes. A calculation is made that takes into account both class rank and class size. If the high school ranks students in percentiles (e.g. top 25 percent) rather than an individual ranking, the value in this field is derived not from a calculation, but from a table lookup. Values for converted rank range from 200 to 800.
Cycle_Year

AM510 CYCLE YEAR

does not appear in online SRS

The calendar year in which the student will matriculate, in the format YYYY indicating the four-digit year.
Disability

AM552 DISABILITY FLAG

NATURAL ALIAS: HANDICAP-AM

appears on SRS screen 312

Indicates whether the student had a self-identified disability when they applied to Penn. NOTE: this may be different from the information on file with the Office of Student Disabilities, and should not be used for disability reporting.

Values:


NULL - No

1 - Yes
Division

AC641 PROGRAM DIVISION

part of the record key; appears in the SRS context line

The code indicating the admitting academic division to which this admissions record pertains.

See the DIVISION table for valid values.

English_Composition

AM59B ENGLISH COMP ACH

appears on screen 312 if it is one of the top three scores

The student's English Composition achievement test score. If the score is NULL, the student did not take this test.

 

English_Essay

AM578 ENGLISH ESSAY

appears on screen 312 if it is one of the top three scores

The student's English Essay achievement test score. If the score is NULL, the student did not take this test.

 

English_Lang_Prof

AM59Z ENG LANG PRFCNCY ACH

appears on screen 312 if it is one of the top three scores

The student's English Language Proficiency achievement test score. If the score is NULL, the student did not take this test.

 

European_History_Test

AM59N EUROPEAN HIST ACH

appears on screen 312 if it is one of the top three scores

The student's European History achievement test score. If the score is NULL, the student did not take this test.

 

Faculty_Staff

AM530 EMPLOYEE CHILD

NATURAL ALIAS: FAC-STAF-AM

appears on SRS screen 312

Indicates whether the student is the dependent child of a faculty or staff member.

Values:


NULL/0 - No/Not reported

1 - Yes


Financial_Aid_Application

AM548 FINANCIAL AID APPL

NATURAL ALIAS: FA-APPL-AM

appears on SRS screen 312

Indicates whether the student intends to apply for financial aid. NOTE: this fields does not indicate whether the student actually did apply for financial aid, nor does it indicate any financial aid was awarded.

Values:


NULL/0 - No

1 - Yes


Financial_Aid_Package

AM550 FINANCIAL AID PKGE

does not appear in online SRS

Specifies the self-help threshold in the student's financial aid package. The self-help portion is usually a long-term student loan or part-time employment.

NULL - Student not participating

French_Listening_Test

AM59V FRENCH LSTNING ACH T

appears on screen 312 if it is one of the top three scores

The student's French Listening achievement test score. If the score is NULL, the student did not take this test.

 

French_Test

AM59C FRENCH ACH TEST

appears on screen 312 if it is one of the top three scores

The student's French achievement test score. If the score is NULL, the student did not take this test.

 

German_Listening_Test

AM58A GERMAN LSTNING ACH T

appears on screen 312 if it is one of the top three scores

The student's German Listening achievement test score. If the score is NULL, the student did not take this test.

 

German_Test

AM59D GERMAN ACH TEST

appears on screen 312 if it is one of the top three scores

The student's German achievement test score. If the score is NULL, the student did not take this test.

 

Hebrew_Test

AM59G HEBREW ACH TEST

appears on screen 312 if it is one of the top three scores

The student's Hebrew achievement test score. If the score is NULL, the student did not take this test.

 

Home_State

AM595 HOME STATE

does not appear in online SRS

The student's state of residence at the time of admission. Taken from home address on the student's application. NOTE: this is not the student's "state of residence"; see State_of_Residency in the PERSON table.

Values:

NULL - Not reported (may be non-US residency)

See list of states in the ADDRESS table.

 
HS_Calculus

AM58J CALCULUS in HIGH SCH

does not appear in online SRS

Indicates whether the student had calculus in high school.

Values:


NULL - No

1 - Yes
HS_Class_Size

AM582 HS CLASS SIZE

NATURAL ALIAS: CLS-SIZE-AM

appears on SRS screen 312

The size of the student's high school class.

NULL - not reported

HS_Rank

 AM580 HS RANK IN CLASS

NATURAL ALIAS: HS-RANK-AM

appears on SRS screen 312

The student's rank in high school. This number should be evaluated in conjunction with the HS_CLASS_SIZE.

NULL - Not reported

Italian_Test

AM59U ITALIAN ACH TEST

appears on screen 312 if it is one of the top three scores

The student's Italian achievement test score. If the score is NULL, the student did not take this test.

 

January_Year

AM518 JANUARY YEAR

does not appear in online SRS
The last two digits of the year of matriculation for transfer students admitted in January. This value will be '00' for transfer students matriculating in September, and null for non transfer students.
Japanese_Listening_Test

AM59W JAPAN LSTNING ACH TE

appears on screen 312 if it is one of the top three scores

The student's Japanese Listening achievement test score. If the score is NULL, the student did not take this test.

 

Junior_Transfer

AM522 JUNIOR TRANSFER

NATURAL ALIAS: UGRAD-ADS-JUNIOR-TFR-FLAG

appears on SRS screen 312

Indicates whether the student is transferring in with junior standing.

Values:


NULL/0 - No/Not applicable

1 - Yes
Language_Proficiency

 AM58K LANGUAGE OF PROFICIE

 

does not appear in online SRS
Indicates whether a student has a proficiency in one of a set of specified foreign languages.

Values:


NULL -  not reported

1 - Arabic

2 - Chinese

3 - French

4 - German

5 - Italian

6 - Japanese

7 - Russian

8 - Spanish
Last_Extract_Date  n/a The last date information for this student was extracted from SRS to the Data Warehouse.
Latin_Test

AM59E LATIN ACH TEST

appears on screen 312 if it is one of the top three scores
The student's Latin achievement test score. If the score is NULL, the student did not take this test.

 

Literature_Test

AM59R LITERATURE ACH TEST

appears on screen 312 if it is one of the top three scores
The student's Literature achievement test score. If the score is NULL, the student did not take this test.

 

Math_1C_Test

AM58E MATH1C ACH TEST

appears on screen 312 if it is one of the top three scores
The student's Math Level 1C achievement test score. If the score is NULL, the student did not take this test.

 

Math_1_Test

AM59P MATH LEVEL 1 ACH

appears on screen 312 if it is one of the top three scores
The student's Math Level 1 achievement test score. If the score is NULL, the student did not take this test.

 

Math_2_Test

AM59Q MATH LEVEL 2 ACH

appears on screen 312 if it is one of the top three scores
The student's Math Level 2 achievement test score. If the score is NULL, the student did not take this test.

 

Math_2_Calc_Test

AM59X MATH LEVEL 2 CALC AC

appears on screen 312 if it is one of the top three scores
The student's Math Calculator achievement test score. If the score is NULL, the student did not take this test.

 

Modern_Hebrew_Test

AM59T MODERN HEBREW ACH TE

appears on screen 312 if it is one of the top three scores

The student's Hebrew achievement test score. If the score is NULL, the student did not take this test.

 

Non_Academic_Rating_1

AM592 NON-ACADEMIC RTG 1

does not appear in online SRS

The non-academic rating assigned by the first reader of the student's application. '1' is lowest; '9' is highest.

Values:


NULL - Not reported

1-9


Non_Academic_Rating_2

AM598 NON-ACADEMIC RTG 2

does not appear in online SRS

The non-academic rating assigned by the second reader of the student's application. '1' is lowest; '9' is highest.

Values:


NULL - Not reported

1-9
Physics_Test

AM59L PHYSICS ACH TEST

appears on screen 312 if it is one of the top three scores
The student's Physics achievement test score. If the score is NULL, the student did not take this test.

 

Predictive_Index

AM586 PREDICTIVE INDEX

NATURAL ALIAS: PRED-IND-AM

appears on SRS screen 312

A predictive indicator of the student's GPA at the end of the freshman year. Formula takes into account SAT scores, achievement test scores and converted class rank.

Values:


NULL - Not enough data available to calculate

0.09 - 4.00
Race_Code

AM540 RACE

does not appear in online SRS

The student's ethnic background as reported to the undergraduate admissions office at the time of the individual's application to Penn, which may differ from the student's reported ethnic background found in the PERSON and IPEDS tables.

NOTE: This field should NOT be used to report on the student's race once they have matriculated in the University.

Values:


NULL - Not reported

1 - Black

2 - White

3 - American Indian

4 - Mexican American/Chicano

5 - Asian/Asian American

6 - Latino

7 - Other

8 - Puerto Rican
Reader_Action_1

 AM588 REC ACTION 1

does not appear in online SRS
The admissions action recommended by the first reader of the student's application.

Values:


NULL - Not reported/No rating

1 - Admit

2 - Unclear

3 - Reject
Reader_Action_2

 AM594 REC ACTION 2

does not appear in online SRS

The admissions action recommended by the second reader of the student's application.

Values:


NULL - Not reported/No rating

1 - Admit

2 - Unclear

3 - Reject
Russian_Test

 AM59H RUSSIAN ACH TEST

appears on screen 312 if it is one of the top three scores
The student's Russian achievement test score. If the score is NULL, the student did not take this test.

 

SAT_Critical_Reading

AM5A3 SAT CRITICAL READING

NATURAL ALIAS: UG-SAT-RDNG-AM

appears on SRS screen 312

 

The highest SAT Critical Reading score reported for the applicant as-of the time of their application to Penn. If the score is NULL, the student did not take or report this test.
SAT_Math

AM564 HIGHEST SAT MATH

NATURAL ALIAS: UG-SAT-M-AM

appears on SRS screen 312

The highest SAT math score reported for the applicant as-of the time of their application to Penn. If the score is NULL, the student did not take or report this test.

 

SAT_Verbal

AM562 HIGHEST SAT VERBAL

NATURAL ALIAS: UG-SAT-V-AM

appears on SRS screen 312

The highest SAT verbal score reported for the applicant as-of the time of their application to Penn. If the score is NULL, the student did not take or report this test.

 

SAT_Verbal_Component

 AM5A8 HI SAT VERB CMPONENT

STANDARD NAME: UGRAD-ADS-HI-SA
NATURAL ALIAS: UG-SAT-VCOMP-AM

appears on SRS screen 312

The highest SAT Verbal Component score reported for the applicant as-of the time of their application to Penn. If the score is NULL, the student did not take or report this test.
SAT_Writing_Essay

 AM5A5 HI SAT WRITING ESSAY

NATURAL ALIAS: UG-SAT-ESS-AM

appears on SRS screen 312

The highest SAT Writing Essay score reported for the applicant as-of the time of their application to Penn. If the score is NULL, the student did not take or report this test.
SAT_Writing_MC_Subscore

 AM5A6 HI SAT WRITING MC

NATURAL ALIAS: UG-SAT-WRMC-AM

appears on SRS screen 312

The highest SAT Writing MC subscore reported for the applicant as-of the time of their application to Penn. If the score is NULL, the student did not take or report this test.
SAT_Writing_Score

 AM5A4 HI SAT WRITING SCORE

NATURAL ALIAS: UG-SAT-WRTG-AM

The highest SAT Writing score reported for the applicant as-of the time of their application to Penn. If the score is NULL, the student did not take or report this test.
School_State

 AM556 SCHOOL STATE

does not appear in online SRS, except as part of the School From Which Admitted address at the top of screen 312
The state where the student's high school is located.

 

School_Type

 AM560 SCHOOL TYPE

NATURAL ALIAS: SCH-TYP-AM

appears on SRS screen 312
The type of high school the student attended.

Values:


NULL - Not reported/Not known

1 - Public

2 - Private

3 - Parochial
Small_Communities

 AM536 SMALL COMMUNITIES

NATURAL ALIAS: SML-COMM-AM

appears on SRS screen 312

Indicates whether a candidate has applied from a secondary school in Pennsylvania that is part of the small communities program.

Values:


NULL - No

1 - Yes
Socio_Economic

 AM538 SOCIO-ECONOMIC

does not appear in online SRS
Indicates whether the applicant was considered as potentially coming from an economically disadvantaged background. NOTE: this does not reflect the Socio-Economic Status as determined by Student Financial Aid at Penn, and should not be used for SES reporting.

Values:


NULL - No

1 - Yes
Socio Economic Status

AM5E5 SOCIOECONOMIC STATUS

appears on SRS screen 312

Socio-economic status, as used by SFS.

Values:

HN - HIGH NEED
Y - HIGH NEED
null - NOT HIGH NEED

Father_High_Educ

AM5E7 FATHER EDUC LEVEL

appears on SRS screen 312

The student's father's highest level of education, as reporting by the student to Undergraduate Admissions.

Values:

C - COLLEGE
E - ELEMENTARY SCHOOL
H - HIGH SCHOOL
M - MIDDLE SCHOOL
N - UNKNOWN

 

Mother_High_Educ

AM5E6 MOTHER EDUC LEVEL

appears on SRS screen 312

The student's mother's highest level of education, as reporting by the student to Undergraduate Admissions.

Values:

C - COLLEGE
E - ELEMENTARY SCHOOL
H - HIGH SCHOOL
M - MIDDLE SCHOOL
N - UNKNOWN

 

First_Generation

AM5E3 FIRST GENERATION

appears on SRS screen 312

An flag from the admissions application, indicating whether the student was considered to be in the first generation of their family to go to college.

Values

1 - FIRST GENERATION
0 - NOT FIRST GENERATION

can also be null

 

Recruitment_Program

AM5E4 RECRUIT PROGRAM

appears on SRS screen 312

A code from the admissions application, indicating whether the student was recruited by a specific admissions program.

Values

P - POSSE
Q - QUESTBRIDGE
null - not in either special recruitment program

Sophomore_Transfer

 AM520 SOPHOMORE TRANSFER

NATURAL ALIAS: SOPH-TR-AM

appears on SRS screen 312

Indicates whether the student is transferring in with sophomore standing.

Values:


NULL - No

1 - Yes


Spanish_Listening_Test

 AM58B SPANISH LSTNING ACH

appears on screen 312 if it is one of the top three scores
The student's Spanish Listening achievement test score. If the score is NULL, the student did not take this test.

 

Spanish_Test

 AM59F SPANISH ACH TEST

appears on screen 312 if it is one of the top three scores
The student's Spanish achievement test score. If the score is NULL, the student did not take this test.

 

Special_Interest   No longer used by Undergraduate Admissions

Values: Currently all 'N'

Special_Program   No longer used by Undergraduate Admissions

Values:

Currently all N
Sport_Code

 AM542 SPORT CODE

NATURAL ALIAS: SPORT-CD-AM

appears on SRS screen 312

The sport for which the student was recruited.

Values: (NOTE that the admissions list of values for sports differs from the Penn Athletics' list of values. See the ATHLETIC_SPORT table.)


NULL - None

01 - Football

02 - Basketball

03 - Soccer

04 - Tennis

05 - Squash

06 - Baseball

07 - Swimming

08 - Hockey

09 - Crew

10 - Fencing

11 - Wrestling

12 - Lacrosse

13 - Track

14 - Golf

15 - Gymnastics

16 - Badminton

17 - Volleyball

18 - Lightweight Crew

19 - Lightweight Football
SSN n/a The Social Security number of the student. If the student does not yet have a Social Security number, a Penn-assigned number will be associated with their SRS record. SSN is a protected field, and most users of the Data Warehouse will not see any data in this column.
Test_Counter n/a The number of achievement test scores recorded for this student. This is a calculated field in SRS, and does not appear online.
Undergrad_School

AA643 PREVIOUS SCHOOL

appears on SRS screen 110

The school code (this will be an undergraduate program at a college or university code for transfer students only).

Values:


NULL - Not reported/None

A four digit code, from 0000 to 9999


See also the INSTITUTION table for school names.
World_History_Test

 AM58C WORLD HISTORY ACH TE

appears on screen 312 if it is one of the top three scores
The student's World History achievement test score. If the score is NULL, the student did not take this test.

 

Writing_Test

 AM58D WRITING ACH TEST

appears on screen 312 if it is one of the top three scores
The student's Writing achievement test score. If the score is NULL, the student did not take this test.

 

Email

AM5E1 UGADM EMAIL ADDRESS

appears on SRS screen 312

This is the student's email address as reported by Undergraduate Admissions at the time of matriculation; it should be used only in the period prior to the student getting a Penn email address.

See also Email_Address in PERSON_ALL_V

 

SRS UNDERGRAD_ADMISSIONS Table . Tables and Data Elements . Student Records 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