Difference between revisions of "Student"
Jump to navigation
Jump to search
(New page: ==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 pl...) |
(No difference)
|
Latest revision as of 14:06, 25 June 2009
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 | |
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 |