Data Mapping
- James Elder (Unlicensed)
- Carrie Felton
Questions
How many records/tables is this information stored in Peoplesoft?
“Stacks” of data? How many of these fields are part of these stacks, effective dates, etc.
Refresh process? Need to identify the external id…
Are fields below identified to be in AY actually stored in PS somewhere?
Requested Fields
Field | Location | Reasons For Including It | Questions |
| |
|---|---|---|---|---|---|
| 1 | EMPLID | Peoplesoft | External ID |
| primary |
| 2 | Residency Status | Peoplesoft |
|
| primary important for discussions with perspective students. |
| 3 | Admit Term | Peoplesoft |
| Does this field change over time? “multiple rows”
| primary if tied to admit type |
| 4 | Admit Type | Peoplesoft |
|
| primary |
| 5 | Campus | Peoplesoft |
| Location? I thought we were just interested in ONLN? | primary this will be the criteria used to pull students |
| 6 | Application Date | Peoplesoft |
|
| primary |
| 7 | Program Status and Action Date | Peoplesoft (Admissions Summary) |
| APPL, ADMT, ? (need flow to understand)
| Flow will determine primary or Secondary |
| 8 | Student Program Plan
| Peoplesoft (Program Plan) |
| Need to see complete structure/architecture and evaluate future state - multiple layers of data Not sure when this gets set up | primary dependent on structure |
| 9 | Program Action - Effective Dates | Peoplesoft |
| Active or Discontinuation | Secondary |
| 10 | Academic History | Peoplesoft |
| List of course work, including transfer work | Not in SF Live in PS, stick with the summary |
| 11 | Enrollment Summary | Peoplesoft |
| Class Information? | primary |
| 12 | Academic Load | Peoplesoft | Not useful | Full time/part time Does this change for grad students? | primary if useful |
| 13 | Credit Hours Taken | Peoplesoft |
|
| primary |
| 14 |
|
|
|
|
|
| 15 | Service Indicators | Peoplesoft |
| Negative vs Positive What communication is being sent already? Registrar? | primary |
| 16 | Tuition amount due | Peoplesoft |
| What does this matter? Calc issues/difficult to associate tuition with specific classes | primary |
| 17 | Enrollment Appointment | Peoplesoft |
| Date to start registering for term? Are we looking for students who have not enrolled after their enrollment appointment? | primary |
| 18 | FAFSA on file | Peoplesoft | Changes every year - need current academic year | How often is it updated? Yearly | primary |
| 19 | New App/Prev App |
|
|
|
|
| 20 | What was the last term you attended the U |
|
|
|
|
| 21 | Have you attended any other institution since last attending the U? |
|
|
|
|
| 22 | Campus |
|
| Criteria (ONLN) |
|
| 23 | Intended Graduate program and degree |
|
|
|
|
| 24 | Semester you plan to begin |
|
|
|
|
| 25 | Are you applying for a combined BS/MS program? |
|
|
|
|
| 26 | Will you be applying for a dual degree program? |
|
|
|
|
| 27 | Please select your 1st area of interest (this is the first place where students indicate if they want to complete the program online) |
|
|
|
|
| 28 | All bio demo, except social security number Full name, address, all phone numbers, email |
|
|
|
|
| 29 | Do you meet two or more of the criteria listed below, taken from the NIH’s Definition of Socio-Economic Disadvantage? |
|
|
|
|
| 30 | Are you a first generation college student? |
|
|
|
|
| 31 | Undergraduate major |
|
|
|
|
| 32 | · GPA self reported |
|
|
|
|
| 33 | · Last 60 hours credit hours GPA |
|
|
|
|
| 34 | · Languages o What is your first language? |
|
|
|
|
| 35 | · Have you ever attended the University of Utah? o If yes, please list your dates of attendance |
|
|
|
|
| 36 | · Have you previously enrolled and attended classes in the specific program for which you are applying at the University of Utah? |
|
|
|
|
| 37 | · List your U of U student ID number |
|
|
|
|
| 38 | · If you were previously enrolled in a graduate program that you did not complete, please explain the reasons for non-completion. (this is an open-ended response) |
|
|
|
|
| 39 | · External Education history |
|
|
|
|
| 40 | · Residency for Tuition Purposes o Country of legal residence o If selected US, please indicate your state of legal residence in the US o Do you claim to be a legal resident of Utah for in-state tuition purposes? o Have you ever served in the US military? o Are you the spouse or dependent child of a US military veteran who received a general or honorable discharge within the last 5 years? o Are you a member of the US Armed Forces currently assigned to Utah on active duty? o Are you the spouse or dependent child of an US Armed Forces service member currently assigned to active duty in the state of Utah? |
|
|
|
|
| 41 | · Financial Support o Do you intend to complete your degree as a full time or part time student? o Are you interested in receiving financial support? § If yes, what type? o Have you already secured financial support? § If yes, please explain o Admission Fee waivers § Are you a McNair Scholar? |
|
|
|
|
| 42 | · How did you hear about the department or program to which you are applying? |
|
|
|
|
| 43 | Slate ID (unique identifier) |
| Multiple submissions by the same student. |
|
|