File Summary:
The Student_Data.csv file should contain all currently enrolled students. This file contains basic data about the student such as name, addresses, and phone numbers.
Formatting Note: This file has a set header row and specific formatting. The file name, column names, and column order should be exactly as indicated in the description (capitalization included). If you are unable to fill a field with data, please still include a placeholder.
Output Example with Fixed Header Row:
"Student ID"|"Preferred Name"|"First Name"|"Middle Name"|"Last Name"|"Secondary ID"|"Date of Birth"|"E-mail Address"|"Phone 1"|"Address 1"|"Phone 2"|"Address 2"|"Phone 3"|"Address 3"|"Address 4" "0001001"|"Luke"|"Lucas"|"Porter"|"Baxley"|"Q1001"|"01/02/2004"|"lpb@myUniversity.com"|"780-883-7269"|"222 Lakeshore Drive<br>Abilene, TX 12345"|"404-925-4456"|""|"325-204-5929"|"Fischer West - Room W105"|"Campus Mail - Box 1001"
"0001002"|"Marnie"|"Marnie"|"Gayle"|"Lemmons"|"Q1002"|"11/07/2004"|"mgl@myUniversity.com"|"826-443-7227"|"610 Spring Creek Drive<br>Waynesburg, PA 12345"|"819-724-9241"|""|"724-802-0816"|"Chase Hall - Room 129"|"Campus Mail - Box 1013"
"0001003"|"Anne"|"Anne"|"Faith"|"Scott"|"Q1003"|"02/02/2003"|"afs@myUniversity.com"|"759-315-2580"|"871 Lakeshore Drive<br>Abilene, TX 12345"|"114-876-8220"|""|"325-674-2993"|"Fischer East - Room E165"|"Campus Mail - Box 1003"
"0001004"|"Lucy"|"Lucy"|"Belle"|"Blakeslee"|"Q1004"|"03/02/2006"|"lbb@myUniversity.com"|"956-277-5715"|"787 Ruth Street<br> Springfield TN 67890"|"827-308-2391"|""|"615-384-7495"|"Fischer East - Room E219"|"Campus Mail - Box 1004"
"0001005"|"Chelsea"|"Chelsea"|"Savannah"|"Vlassman"|"Q1005"|"01/24/2003"|"scv@myUniversity.com"|"716-713-9011"|"461 Lakeshore Drive<br>Abilene, TX 12345"|"431-594-8175"|""|"325-669-5766"|"Chase Hall - Room 167"|"Campus Mail - Box 1005"
"0001006"|"Kelly"|"Kelly"|"Marilyn"|"Hudson"|"Q1006"|"01/25/2005"|"mkh@myUniversity.com"|"775-553-2558"|"744 Ruth Street<br> Springfield TN 67890"|"646-431-2608"|"1006 College Drive<br>Abilene, TX 12345"|""|""|"Campus Mail - Box 1006"
"0001007"|"Todd"|"Todd"|"Washington"|"Robertson"|"Q1007"|"01/21/2003"|"gtw@myUniversity.com"|"279-705-3782"|"832 Lakeshore Drive<br>Abilene, TX 12345"|"786-200-2974"|"1007 College Drive<br>Abilene, TX 12345"|""|""|"Campus Mail - Box 1007"
"0001008"|"Kirk"|"Kirk"|"Jeremy"|"Mitchell"|"Q1008"|"01/20/2003"|"jkm@myUniversity.com"|"937-857-9883"|"793 Ruth Street<br> Springfield TN 67890"|"961-413-7600"|"1008 College Drive<br>Abilene, TX 12345"|""|""|"Campus Mail - Box 1008"
"0001009"|"Suzanne"|"Suzanne"|"Kathleen"|"Dunn"|"Q1009"|"11/20/2003"|"ksd@myUniversity.com"|"985-677-7127"|"587 Lakeshore Drive<br>Abilene, TX 12345"|"535-429-1584"|""|"325-370-2043"|"Chase Hall - Room 255"|"Campus Mail - Box 1009"
...
(15 total fields)
Data Field Details:
- Student ID - The Student ID field should be unique and is used to map information and data files.
- Preferred Name - The Preferred Name field is required and is the name by which a student prefers to be known. For instance, if his first name was Lucas, but he preferred Luke, you would enter Luke in this field. If you do not have the information about the preferred name, please populate this field with their first name instead.
- First Name - Student's first name
- Middle Name - Student's middle name
- Last Name - Student's last name
- Secondary ID - This field is only used if your campus makes a distinction between the Student ID and an additional identifier. If you have no Secondary ID for a student, simply leave this field blank.
- Date of Birth - Please use the following format to ensure that age is calculated correctly:
MM/DD/YYYY. - E-mail Address - Preferably official school email address
- Contact Information Fields - You have the ability to provide up to seven contact fields (three phone numbers and four addresses):
"Phone 1"|"Address 1"|"Phone 2"|"Address 2"|"Phone 3"|"Address 3"|"Address 4"
The Phone 2 field is utilized by our system's texting feature. You must provide the student's cell phone in the output of this Phone 2 contact field.
The other contact fields can be populated with the most commonly collected and utilized information for your students. During implementation, you'll inform Pharos what information will populate the remaining fields and our team will adjust the user-side labels to match.
The contact field tag presented to the users can be customized by Pharos. Examples of commonly sent contact information for the student are: - Permanent Phone
- Permanent Address
- Local Address
- Local Phone
- ResHall/Room
- Campus Mailbox
Please note: If you are a new client, we may ask you generate a static version of the
Student_Data.csv file that contains three years of historical student data. This one-time historical pull will allow your users to search and manage students who may not be currently enrolled but are looking to re-enroll or who have recently graduated and are still being assisted by an office on campus.(This is a foundational / basic and required file.)
Comments
0 comments
Please sign in to leave a comment.