FileMaker Questions
Current Fields (FMP/Cognos)
/ Student Name (Last, First)
First Name / Student First Name
Last Name / Student Last Name
UTEID / Student EID
/ Student UIN
/ SRI
DOB (mm/dd/ccyy) / DOB CCYYMMDD
email / eMail Address
phone / Primary Phone Number
/ Last Semester CCYYS
/ Transferred Hours
Hours / Hours Undertaken
? hours undertaken ("+ Current Semester Hours" in Scholastic Standing tab) /
/ Hours for GPA
/ Hours Passed
/ Hours Failed
/ Adv Placement Hours
? Core Complete (re: talk with Jen Morgan) / Core Curr SW (Y/N)
-- / First Semester CCYYS
Catalog / --
Term Admitted (Fall Admit, Spring Admit, Summer Admit; "Admit Type" in layout) / --
/ School Title
/ Major (code)
/ Major Title
/ Mode of Admission (code)
? Admit Type (FTIC, Transfer, Other; "Student Type" in layout) / Mode of Admission Title
/ First Mode (code)
/ Current Hours
UT GPA / GPA
special program /
scholastic standing (Good, Probation, Dismissed 1-3EW, Withdrawal (EW), Left (Good/Probation) / (possible from Cognos?)
class standing ("Classification" in layout; hours vs. FSE? /
Advisor /
Deadline to Declare (Semester YEAR) /
APPOINTMENTS TAB
Total Contacts (Field 5) /
appointments ("In-Person Appointments") /
email contact ("Email Contacts") /
SAN contact ("SANs") /
phone contact ("Phone Contacts") /
other advising ("Other College/Program Advising" <-- Also a named field??) /
MAJOR EXPLORATION TAB
Majors of Interest 1-5 /
Transferred (check box if declared & Transferred) /
Semester Transferred (out of UGS) /
Declared Major /
DEFUNCT/no field? - Major Exploration Activities
SCHOLASTIC STANDING TAB
see above - UT GPA / GPA
see above - ? hours undertaken ("+ Current Semester Hours" in Scholastic Standing tab) /
see above - scholastic standing (Good, Probation, Dismissed 1-3EW, Withdrawal (EW), Left (Good/Probation) / (possible from Cognos?)
Sem on Prob ("Semester on Probation") /
EW GPA ("Semester GPA to avoid dismissal") /
?-no finds Dismissal Appeal 1-4 /
?-no finds Dismissal Appeal Status 1 - 4 /
Academic Success Plan (container) /
Defunct/Missing Fields
Resources?
ACE
CMHC
EDP
other resources
Prof TA
RES
SLCC
SSD
UHS
UWC
(defunct?) Count of All Resources
Containers
Interest Assessment
scholastic probation documents (not actually a container)
Skills Assessment
Vales Assessment
Counts/Calculations
(see resources)
Count of All Contacts
Count of All Appointments
Count of Email Contacts
Count of Phone Contacts
Count of SAN Contacts
(running with restart), when sorted by Fall 2011 Advising Database::UTEID
Field (appointments)
Field 2 (email contacts)
Field 3 (SAN contact)
Field 4 (phone contact)
see above - Field 5 (sum of all contact fields)
Field 6 (other advising)
Misc
Appointment Type
Transfer Student
UT Summer School Enrollment
Usage Questions
