Penn Computing

University of Pennsylvania
Penn Computing << go backback

GA_APPLICATION Table . Tables and Data Elements . Graduate Admissions Data Home . Data Warehouse Home

GA_APPLICATION Table - Data Element Index

 

Data element Definition

Applicant_ID

Applicant_Id is a number assigned to the application.

To ensure uniqueness, the Record Source field was added to the primary key in this table, together with the program_key and application_term.

see also the Is_Current column in the APPLICATION table.

Academic_Integrity This field contains the applicant's response to the academic integrity question.
Accept_Decision

Accept Decision contains the applicant's response to the school's offer of admission.
Note that some historical records have data that do not conform to the set of valid values. Values found in this field for older records can include some free-form un-validated text

Valid values (also can be null):
Y - yes, student accepted admission
N - no, student did not accept admission
W - student withdrew their application

Admit_Decision

Admit Decision contains the school's decision regarding whether to admit the applicant to the gradaute program. Values are derived from the school source data using a decision mapping table (gradadm.ay_decision.)

Valid values (also can be null):
Admit
Deny
Deferred
No Action
Submatric
Waitlist
Withdraw

Appfee_Pay_Type AppFee Pay Type is the method of payment of the application fee
Appfee_Payment AppFee Payment is the dollar amount of the paid application fee. Stored as a number. Can be null.
Application_Term

The term in which the appplicant intends to start at Penn. The 5-character application term is in SRS format (YYYYT) where T is the term code: A = Spring, B = Summer, C = Fall.

Note that there can be more than one row in the GA_APPLICATION table for an applicant. To query only the most recent information sent from AY, use Is_Current = 'Y.' See also Is_Current.

When counting people who applied to a specific Application Term, subtract the people who deferred out (people who originally applied in a different term). When counting people who are matriculating in a specific Application Term, add in the people who deferred in. See also Deferred_From.

AY_School

The code for the Apply Yourself (AY) school or division to which the applicant is applying. Note that these are not the same as the school or division codes in the Student Records System (SRS).

Valid values:
BGS - Biomedical Graduate Studies
CGS - Liberal and Professional Studies
DES - School of Design
EMBA - Wharton Executive MBA program
EMTM - Engineering Executive Masters in Technology program
GAS - Graduate Arts and Sciences
GSE - Graduate School of Education
MBA - Wharton MBA program
NURS - School of Nursing
SEAS - School of Engineering
SPP - School of Social Policy and Practice
WHP - Wharton PhD program

Complete_Application Complete Application is a Y/N field and is populated only if the school provided sufficient information on the completeness of an application. For most schools, an application is considered complete when the application fee is paid, the baccalaureate transcript is received, official test scores are received, recommendations are received, and required documents are received.
Complete_Date Complete Date is the date the application was considered by the Admitting School
Concentration Concentration contains optional further information on the focus of the application within the designatied graduate group. Example: for a degree= AM and program = ENGL, the Concentration might be "British Literature." This column's format is free-form, un-validated text.
Creation_Date Creation Date is the date the applicant began their application. This field contains data only for Apply Yourself applications.
Decision_Date The date the applicant submitted a decision in response to the offer of admission, or a decision was entered on their behalf by the school. May be null.
Deferred From

The SRS term, in YYYYT format, to which the applicant originally applied. If the Deferred From term is the same as the Application Term, the applicant is considered as "Deferred Out" from that term, in other words, they are counted as an applicant in the Deferred From term, but not as a matric in that term. If the Deferred From term is less than the Application Term, the applicant is considered as "Deferred In" to that term, in other words, they are counted as an applicant in the Deferred From Term, and as a Matric in the Application Term.

For example, a person whose "current" row in GA_APPLICATION has 2014C in Deferred_From and 2014C in Application Term should be counted as an applicant in 2014C, but not as a matric in 2014C. A person whose "current" row in GA_APPLICATION has 2014C in Deferred_From and 2015C in Application_Term should be counted as an applicant in 2014C, and a matric in 2015C.

See also Application_Term

Note that there can be more than one row in the GA_APPLICATION table for an applicant. To query only the most recent information sent from AY, use Is_Current = 'Y.' See also Is_Current.

Degree

The code for the degree to which the applicant is applying. Note that some historical records have different values other than the set of valid values. Values found in this field might include some free-form un-validated text.

See the Degree table (dwadmin.degree) for valid values.

Enrolled Originally intended to contain data on the admitted student who accepted the offer and enrolled in classes, this column is not being populated, and is not included in the Business Objects Graduate Admissions Reporting universe.
Enrollment_Status A free-form un-validated text column that provides information about the applicant's anticipated time status, if they are admitted and accept the offer. Examples include: FT, PT, Full-time, Part Time, Half-time (Saturdays only), f, P
Enrollment_Submitted_Date Enrollment Submitted Date is the date the student responded to Penn. This date will only be populated in records with a source of Apply Yourself (AY).
Is_Current

A flag that identifies which row, for any given applicant_id, is the most recent or "current" row.

The APPLICATION table maintains the history of all changes to an application; if an individual applies to a program then changes the term in which they plan to attend, a new row is inserted into APPLICATION for that same applicant_id. Similarly, if an individual applies to a program then changes to a different concentration or field of study for that same application, a new row is inserted in APPLICATION for that same applicant_is.

The Is_Current column provides a way to identify which row in APPLICATION is the one that corresponds to the person's current record in the source system. Every applicant_id will have only one row where Is_Current = 'Y'.

Values:

Y - this is the current row for the applicant_id
N - this is not the current row for the applicant_id

 

Load_Type This column is not being populated, and is not included in the Business Objects Graduate Admissions Reporting universe.
Matric_Decision Originally indented to be an indicator of whether the admitted student who accepted the offer has actually arrived at Penn. Matric Decision is very sparsely populated, and is not included in the Business Objects Graduate Admissions Reporting universe.
Matriculation_Cohort The entering academic year. Academic terms are grouped Summer/Fall/Spring into one year. For example, Matriculation terms 2011B, 2011C, and 2012A are part of the Matriculation Cohort 2011.
Matriculation_Term The academic term in which the applicant is expected to begin. May be different from the Application Term. Stored in SRS format: YYYYT, wheren YYYY is the fully qualified year, and T is the SRS term (A = Spring, B = Summer, C = Fall).
Nonmatric_Will_Go A free-form un-validated text column that provides optional information about the college or university that that the applicant decided to go to instead of accepting Penn's offer.
Program A free-form un-validated text column with the description of the program to which the applicant applied. Can be used for additional optional information about the program. When querying the database to find specific programs, or to join to other tables that use program data, do not use this column. Instead, use the Program_Key.
Program_Key A unique identifier of an academic program. Use this key to lookup entries in the gradadm.ga_programs table. In the Business Objects Graduate Admissions reporting universe, Program_Key is used to lookup the record in the ga_programs table, in order to provide the associated SRS codes for things like Division, Degree, Major, Special Program, etc.
Record_Source

Indicates the original source of the data found in a particular graduate admissions row. Some schools do not use the Apply Yourself (AY)application, and their data are sent in separate batch feeds. Some AY schools origianlly did not use AY, so their older historical records will have a different Record Source.

Record Source, along with Applicant_ID, uniquely identifies a row in this table.

Valid values:
AY - Apply Yourself
ASP - Annenberg School
BMP - Biomedical studies program
CGS - Liberal and Professional Studies
DEN - Dental School
EDC - ?
ENG - School of Engineering
GAS - Graduate Arts and Sciences
GFA - School of Design
GSE - School of Education
LAW - Law School
LLM - Law School
LWT - Law School
MDM - ?
MED - School of Medicine
NU - School of Nursing
SPP - School of Social and Public Policy
VM - School of Veterinary Medicine
WH - Wharton School of Business

 

School_Admit_Decision A free-form un-validated text column that stores the original text of the school's admit decision. This is mapped to the valid values using the gradadm.ay_decision table. Example of values found in this column: Admit-MS-No BA, MidCareerWaitlist, Dual Degree Accept Conditional, Special Studnet Admit, Deny Interv-Reapp Sent, etc.
Submitted_Date The date the completed application was submitted for processing by the school. May be null

GA_APPLICATION Table . Tables and Data Elements . Graduate Admissions 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