Advisor Cognos/FileMaker Project

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

Layouts

Advisee List - ON

General Information: Individual Record - ON

Appointments: Individual Records - now tabbed?

Scholastic Standing: Individual Record - now tabbed?

Wayfinder: Individual Record - now tabbed?

Fall 2011 Advising Database - basic default layout

Layout #7 - garbage?

EID Databse - empty table?

Usage Questions