| fsu torches | | florida state university |
  FSUID Home > Project Documentation > Project History > 09/20/2005 | Home | Search | Help | Contact || Home || Search || Help || Contact |


References


LDAP/eDir Documents
LDAP
Windows AD LDAP Schema

 

   
 

The Change for Audit Students
 

I finished a change to our CARS to FSUID bridge this morning.  
Audit students will now show as current students.  What follows is how I look them up:

select TERM, YEAR from fssas.term_info where current_date between start_date and end_date
Gets the current Term and Year

select STUDENT_ID from FSSAS.AUDIT_COURSES where YEAR = '$currentYear' and TERM = '$currentTerm' and STUDENT_ID = '$ssn'
Returns a record if the ssn provided is for a current audit student.

select LAST_NAME, FIRST_NAME, MIDDLE_INIT, SUFFIX from FSSAS.AUDIT_MASTER where STUDENT_ID = '$ssn'
Grabs the student's name

From here, assuming the student has an FSU card (the card type does not matter) they will be eligible for a CARS account and FSUID.

Please let me know if you have any questions and thanks to Doug for helping me out with this.

--Donny
     
FSU | UCS | IS | OMNI | FSUCard | Comments | ©Copyright
| florida state university |