Data element |
Definition |
Applicant_ID |
An identifying number, assigned by the Graduate Admissions system,
to each applicant. This column cannot be null. |
Automated_Entry_Status |
Indicates whether the record was successfully sent to SRS via the automated interface.
Values:
Success = record was sent to SRS via the interface without error
Failed = record contained an error and was not sent to SRS via the interface
Pending = The record has been sent and has yet to be confirmed loaded. |
AY_School |
A code for the Apply Yourself school from which the record originated.
Values:
CGS - Liberal and Professional Studies
SEAS - Graduate School of Engineering
NURS - Graduate School of Nursing
DES - School of Design
WHP - Wharton PhD
MBA - Wharton MBA
GSE - Graduate School of Education
SPP - Social Policy and Practice
BGS - Biomedical Graduate Studies
GAS - Graduate Arts and Sciences
EMBA - Wharton Executive Education Program
|
Birth_Date |
The applicant's date of birth, stored as character data |
Citizenship |
The 2-character code for the applicant's country of citizenship |
Concentration |
The 3-character SRS code for the applicant's major concentration, if any. May be null. |
Degree |
The 3-character SRS code for the applicant's degree. |
Division |
The 3-character SRS code for the applicant's division |
Entry_Action |
The 2-character SRS code for the entry action.
Values
AD - Regular Admit
AS - Submatriculant Admit
|
Entry_Term |
The 5-character term, that corresponds to the SRS term in which the applicant will begin graduate studies, in YYYYT format. |
Ethnic_Origin |
The one-character SRS Race code, as reported by the applicant. May be null.
Values
A - Native American
B - African American
C - White
R - Asian or Pacific Islander
S - Hispanic
X - multi-ethnic
|
Exit_Action |
The 2-character SRS code for exit action.
Values
EG - Expected Graduaion
EP - End of Program
DF - Deferred Admission
|
Exit_Term |
The 5-character term, that corresponds to the SRS term in which the applicant is expected to finish the program, in YYYYT format. |
Load_date |
The date the automated interface program attempted to send the record to SRS. This date will be populated regardless of the Automated Entry Status. |
Major |
The 4-character SRS code for the major, also known as the Graduate Group, into which the student is matriculating. |
Manually_Entered |
If the record was not sent via the automated interface, it may have been manually entered.
Values
Y = record was manually entered in SRS
N = record was not manually entered |
Marital_Status |
A one-character code for the applicant's marital status. Can be null.
Values
S - Single
M - Married
L - Legally Separated
W - Widowed
D - Divorced
|
Name |
The name of the applicant, in SRS Format:
Last,First Mi
Names are stored in this table/view in Title Case, and are converted to upper case when sent to SRS. The Name cannot contain any non-alpha characters with the exception of a '-' for hyphenated names. |
Native_Language |
A 3-digit SRS code for the applicant's native language. Stored as character data. May be null. |
Perm_City |
The full text name of the city in the applicant's permanent address. |
Perm_Country |
The 2-character SRS code for country, in the applicant's permanent address |
Perm_Phone |
The applicant's 10 digit phone number, including area code. This is not validated, and may not contain the area code, and in some cases may not contain the full phone number. |
Perm_Phone_City_Code |
If the applicant has an international phone number, this will contain the phone city code part of the phone number. |
Perm_Phone_Country |
If the applicant has an international phone number, this will contain the phone country code part of the phone number. |
Perm_State |
The 2-character SRS code for US State or Canadian province, of the applicant's permanent address. Cannot be null for US addresses, but should be null for any address not in the US or Canada. |
Perm_Street1 |
The text of the first line of the applicant's permanent address. Cannot be null. |
Perm_Street2 |
The text of the second line of the applicant's permanent address. May be null. |
Perm_Zip |
The zip or postal code of the applicant's permanent address. |
Religion |
The 2-character SRS code for the applicant's religious preference. May be null. |
Sex |
The 1-character SRS code of the applicant's sex.
Values:
F - female
M - male
|
State_Origin |
For applicants born in the US, this is the state of their birth. May be null. |
Term_Special_Program |
The 3-character SRS code for Special Program, that will become part of their term record for the first term they are at Penn. |
Title |
The 4-character SRS code for the applicant's preferred salutation, for example MR, MS, DR, REV. May be null. |
Visa |
The 2-character SRS code for visa type, as reported by the applicant. Once this value is in SRS, it may be updated there by the Office of International programs. May be null.
Values:
F1 - Student
F2 - Dependent of student
H1 - Temporary worker
I9 - Employment Eligibility
J1 - Exchange visitor - student
J2 - Spouse/child of J1
Jx - Exchange visitor - scholar
K3 - Spouse of a US citizen
OT - other
PR - Permanent Resident
TN - NAFTA Professional
US - Now a US citizen (had a different visa type previously)
V1 - Permenent resident spouse
|