eApplicant Data Map

v. 1.0 - 12/14/2007

Web Page / Data Element(s) / Temp Tbl / Batch Tbl / Replicated Tbl
Account Creation / Name / PROSP_PERSON / ST_APP_BATCH / PERSON
E-Mail Address / PROSP_INTERNET_ADDR / ST_APP_INTERNET_ADDR / PERSON or INTERNET_ADDR
Username/Password
Hint Q and A
SSN / PROSP_PERSON / ST_APP_BATCH / PERSON
Birth Date / PROSP_PERSON / ST_APP_BATCH / PERSONAL
Address Street1, Street2, City, State, Zip, Zip Suff, County / PROSP_ADDR / ST_APP_ADDR / ADDRESS
Address Street3, Street4, Street5 / PROSP_ADDR_STREETS / ST_APP_ADDR_ADDITIONAL
Permanent Phone / PROSP_PHONE / ST_APP_PHONE / ADDRESS
Cell Phone / PROSP_PHONE / ST_APP_PHONE
Are you US Citizen? / ST_APP_BTCH_OTHER_TMP / None / None
If not, what are you? / ST_APP_BTCH_OTHER_TMP / ST_APP_BTCH_OTHER / PS_CITIZEN
Resident Years / ST_APP_BTCH_OTHER_TMP / ST_APP_BTCH_OTHER / PS_CITIZEN
Resident Months / ST_APP_BTCH_OTHER_TMP / ST_APP_BTCH_OTHER / PS_CITIZEN
Application Status / Submitted applications / ST_APP_INST_DATA_TMP / ST_APP_BATCH / ST_CAMPUS_APP
App Status – In Progress / ST_APP_BATCH – these are apps that have gotten stuck here and cannot go on unless a user intervenes.
App Status – other than In Progress / ST_CAMPUS_APP
Application Type / ST_APP_INST_DATA_TMP / ST_APP_BATCH / ST_CAMPUS_APP
Starting Semester / ST_APP_INST_DATA_TMP / ST_APP_BATCH / ST_CAMPUS_APP
Needed Items / V_ST_APP_RESULT_OVRD
Select App Type/Term / App Type / ST_APP_INST_DATA_TMP / ST_APP_BATCH / ST_CAMPUS_APP
Val table - PSEO Link
Val table – Admissions Office link
Val Table – Select Term
Select Term / ST_APP_INST_DATA_TMP / ST_APP_BATCH / ST_CAMPUS_APP
Personal Info / Name, Address, Phone / See account creation / See account creation / See account creation
Name History / PROSP_NAME_HIST / ST_APP_NAME_HIST
State of Res, Res Years, Res Months / See account creation / See account creation / See account creation
Are you a US Citz? / See account creation / See account creation / See account creation
If not, what are you? / See account creation / See account creation / See account creation
Have Visa? / ST_APP_BTCH_OHER_TMP / None / None
Admissions Information / Major / ST_APP_MAJORS_TMP / ST_APP_MAJORS / ST_MAJOR and ST_MAJOR_APP
Val Table – Location / V_ONLINE_APP_MAJORS
VAL Table – Type of Major / V_ONLINE_APP_MAJORS
Val table – Area of Study / V_ONLINE_APP_MAJORS
Val Table – Degree/Award / V_ONLINE_APP_MAJORS
Educational Intent / ST_APP_INST_DATA_TMP / ST_APP_BTCH_OTHER / ST_CAMPUS_APP
Full Time/Part Time / ST_APP_INST_DATA_TMP / ST_APP_BTCH_OTHER / ST_CAMPUS_APP
Activities / ST_APP_ACTV_TMP / ST_APP_ACTV / PERSON_ACTV_INT
Institution defined questions / ST_APP_INST_USER_FLD_TMP / ST_APP_INST_USER_FLD / PERSON_USER_FLD
Education History / Are you currently in High School? / ST_APP_BTCH_OTHER_TMP / ST_APP_BTCH_OTHER / ST_CAMPUS_APP
Do you have a high school diploma? / ST_APP_BTCH_OTHER_TMP / ST_APP_BTCH_OTHER / ST_CAMPUS_APP
Do you have a GED? / ST_APP_BTCH_OTHER_TMP / ST_APP_BTCH_OTHER / ST_CAMPUS_APP
High School State / Not stored / Not stored / Not stored
High School / PROSP_HS / ST_APP_HS / PERSON_HIGH_SCHOOL
High School Name / PROSP_HS / ST_APP_HS / PERSON_HIGH_SCHOOL
Grad/GED Date / PROSP_HS / ST_APP_HS / PERSON_HIGH_SCHOOL
Have you attended this school before? / ST_APP_INST_DATA_TMP / ST_APP_BTCH_OTHER / ST_CAMPUS_APP
Have you attended any other higher ed institutions before? / Not stored / Not stored / Not stored
Transfer Inst State / Not stored / Not stored / Not stored
Institution name / PROSP_TRSF / ST_APP_TRSF / PERSON_TRSF_UNIV
Begin Attend Date / PROSP_TRSF / ST_APP_TRSF / PERSON_TRSF_UNIV
End Attend Date / PROSP_TRSF / ST_APP_TRSF / PERSON_TRSF_UNIV
Degree Earned / PROSP_TRSF / ST_APP_TRSF / PERSON_TRSF_UNIV
Prep Standards / All values for all categories / ST_APP_PREP_STANDARD_TMP / ST_APP_PREP_STANDARD / ST_PREP_STD
Demo Info / Gender / PROSP_PERSON / ST_APP_BATCH / PERSON
Hispanic or Latino / PROSP_ETHNIC / ST_APP_ETHNIC / PERSON
Ethnicity / PROSP_ETHNIC / ST_APP_ETHNIC / PERSON
Parent Education / PROSP_PARENT / ST_APP_PARENT / PS_PARENT_EDUC