Student

From CIDI Wiki
Jump to navigation Jump to search

Student

The Banner student extract should contain a single row for each student. The student extract would not contain a row for every student in Banner, so a mechanism must be in place within Banner to identify or flag disability services students, as only those students should be included in the extract.

The SAM application contains the follow data elements for student:

Field Name Data Type Notes Possible Banner Feed
Student ID varchar Unique Student ID (ss#/School ID) yes
Status varchar   yes
Last Name varchar   yes
First Name varchar   yes
Middle Name varchar   yes
Preferred Name varchar The name the Student prefers yes
Address varchar   Yes
City varchar   Yes
State varchar   Yes
Zip Code varchar   Yes
Alternate Address varchar   Yes
City varchar   Yes
State varchar   Yes
Zip Code varchar   Yes
Email varchar   Yes
Alternate Email Varchar   Yes
Phone Number varchar 10 digit number without formatting is preferred Yes
Phone Type varchar Home, Cell, Fax, etc. Yes
Alternative Phone Number varchar 10 digit number without formatting is preferred Yes
Alternative Type varchar Home, Cell, Fax, etc. Yes
Gender varchar Male, Female, etc. Yes
Date Of Birth date MM/DD/YYYY Yes
Ethnicity varchar Caucasian, African American, Hispanic, Etc. Yes
US Citizen boolean   Yes/no
Emergency Contact Name varchar    
Emergency Contact Phone Number varchar 10 digit number without formatting is preferred  
Emergency Phone Type varchar Home, Cell, Fax, etc.  
Campus varchar    
Service Provider varchar    
Primary campus student attends varchar    
Academic Level varchar Freshmen, Sophomore, Junior, Senior, Graduate, etc. Yes
Enrollment varchar Enrolled, Graduated, Transferred, Withdrawn, etc. Yes