SAM V1:import

From CIDI Wiki
Revision as of 13:31, 24 June 2009 by Ben (talk | contribs)
Jump to navigation Jump to search

There are two SAM tables that could data imported from Banner: student and class schedules. The Banner data extract format can be either a CSV file or a tab-delimited text file. Ideally the end-user should be able to run the Banner extract on demand and save the data to a local file. This local file would then be loaded by the end-user into SAM using the QuickBase import data feature.

The DSP should submit a copy of the student and class schedule data fields to their Banner IT representative. From that point the Banner IT representative can assemble a script containing all students receiving disability services. Now the DSP has a list from Banner that contains all of the fields to import into SAM. The Banner IT representative should make the script into a process that the DSP can use weekly to update SAM.

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 Banner class schedule extract should contain a single row for each class of a student. For example, if a student is taking three classes, there would be three rows of data, one for each class with the same student identifier. The class schedule extract would not contain a row for every student class in Banner, so a mechanism must be in place within Banner to identify or flag disability services students, as only the class schedules of those students should be included in the extract.

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


Class Schedule

The Banner class schedule extract should contain a single row for each class of a student. For example, if a student is taking three classes, there would be three rows of data, one for each class with the same student identifier. The class schedule extract would not contain a row for every student class in Banner, so a mechanism must be in place within Banner to identify or flag disability services students, as only the class schedules of those students should be included in the extract.

The SAM application contains the follow data elements for class schedule:

Field Name Data Type Format Possible Banner Feed
Unique Student ID (ss#) varchar   yes
Term varchar   yes
Year varchar   yes
Course varchar   yes
Description varchar   yes
Instructor varchar   yes
Instructor Phone varchar    
Instructor Email varchar    
Location varchar   yes
Monday boolean   yes
Tuesday boolean   yes
Wednesday boolean   yes
Thursday boolean   yes
Friday boolean   yes
Saturday boolean   yes
Sunday boolean   yes
StartTime timeofday HH:MM AM or PM yes
End time timeofday HH:MM AM or PM yes
Notes varchar