| Lookup_Student_Id |
Yes if other Lookup_*** fields are not populated |
Lookup |
"12345" |
|
| Lookup_Student_Last_Name |
Yes if Lookup_Student_ID is not populated |
Lookup |
"Smith" |
|
| Lookup_Student_First_Name |
Yes if Lookup_Student_ID is not populated |
Lookup |
"John" |
|
| Lookup_Birthdate |
Yes if Lookup_Student_ID is not populated |
Lookup |
"1/1/2000" |
|
| Student_First_Name |
Yes, if this field needs to be updated |
Data |
"John" |
|
| Student_Middle_Name |
Yes, if this field needs to be updated |
Data |
"Pittock" |
|
| Student_Last_Name |
Yes, if this field needs to be updated |
Data |
"Smith" |
|
| Student_NickName |
Yes, if this field needs to be updated |
Data |
"Johnny" |
|
| Birthdate |
Yes, if this field needs to be updated |
Data |
"1/1/2000" |
|
| Sex |
Yes, if this field needs to be updated |
Datasource data |
"Male" "Female" |
This field is named "Sex" in the import but displays as "Gender" in the database. The values used must match the values found in the system. Custom values can be added. |
| Phone |
Yes, if this field needs to be updated |
Data |
"(123)-456-7890" |
|
| Email |
Yes, if this field needs to be updated |
Data |
"jsmith@gmail.com" |
|
| Current_Parish |
Yes, if this field needs to be updated |
Datasource Data |
"St. Mary's Catholic Church" |
The possible values are populated by the school by clicking on "Parish" in an Admin > Students > Details page. |
| Day_Or_Boarding |
Yes, if this field needs to be updated |
Datasource Data |
"Day"
"Boarding"
"Virtual" |
|
| ESL_Yes_Or_No |
Yes, if this field needs to be updated |
Datasource Data |
"Y" or "N" |
|
| International_Yes_Or_No |
Yes, if this field needs to be updated |
Datasource Data |
"Y" or "N" |
|
| Previous_School |
Yes, if this field needs to be updated |
Datasource Data |
"Grant High School" |
The possible values are populated by the school by clicking on "Previous Schools" in an Admin > Students > Details page. |
| Financial_Aid_Yes_Or_No |
Yes, if this field needs to be updated |
Datasource Data |
"Y" or "N" |
|
| Birthplace |
Yes, if this field needs to be updated |
Data |
"Washington" |
|
| Citizen_Of |
Yes, if this field needs to be updated |
Datasource Data |
"USA" |
The possible values are populated by the school by clicking on "Citizenship" in an Admin > Students > Details page. |
| Native_Lang |
Yes, if this field needs to be updated |
Datasource Data |
"Dutch" |
The possible values are populated by the school by clicking on "Native Language" in an Admin > Students > Details page. |
| Ethnic_Group |
Yes, if this field needs to be updated |
Datasource Data |
"African American" |
The possible values are populated by the school by clicking on "Ethnic Group" in an Admin > Students > Details page. |
| Locker_Number |
Yes, if this field needs to be updated |
Data |
"1B" |
|
| Locker_Combination |
Yes, if this field needs to be updated |
Data |
"06-01-45" |
|
| Religion |
Yes, if this field needs to be updated |
Datasource Data |
"Christian" |
The possible values are populated by the school by clicking on "Religion" in an Admin > Students > Details page. |
| Inquiry_ID |
Yes, if this field needs to be updated |
Identifier |
"12345" |
Links the student record to an already existing inquiry record. |
| Legacy_Code |
Yes, if this field needs to be updated |
Datasource Data |
"Mother" |
The possible values are populated by the school by clicking on "Religion" in an Admin > Students > Details > Priorities page. |
| Alternate_ID |
Yes, if this field needs to be updated |
Data |
"a1B45" |
|
| Auditorium_Seat |
Yes, if this field needs to be updated |
Data |
"123b" |
|
| Car_License_Plate |
Yes, if this field needs to be updated |
Data |
"B351A" |
|
| Car_Parking_Registration |
Yes, if this field needs to be updated |
Data |
"5GBA" |
|
| Car_Year |
Yes, if this field needs to be updated |
Data |
2007 |
|
| Car_Make |
Yes, if this field needs to be updated |
Data |
"Toyota" |
|
| Car_Model |
Yes, if this field needs to be updated |
Data |
"Corolla" |
|
| Car_Color |
Yes, if this field needs to be updated |
Data |
"Red" |
|
| Student_Suffix |
Yes, if this field needs to be updated |
Data |
"Jr" |
|
| Care_Card_Number |
Yes, if this field needs to be updated |
Data |
"9281 051 185" |
For British Columbia only |
| BC_Pen |
Yes, if this field needs to be updated |
Data |
"129451214" |
For British Columbia only |
| BC_School_Funding_Code |
Yes, if this field needs to be updated |
Datasource Data |
"First Nations - 20" |
For British Columbia only |
| BC_Band_of_Residence_Code |
Yes, if this field needs to be updated |
Datasource Data |
"Adams Lake - 684" |
For British Columbia only |
| BC_Aboriginal_Ancestry_Yes_No |
Yes, if this field needs to be updated |
Data |
"Y" or "N" |
For British Columbia only |
| BC_French_Lang_Program_Code |
Yes, if this field needs to be updated |
Datasource Data |
|
For British Columbia only |
| Campus |
Yes, if this field needs to be updated |
Datasource Data |
"Main" |
The possible values are populated by the school by clicking on "Campus" in an Admin > Students > Details page. |
| Dorm_Room_ID |
Yes, if this field needs to be updated |
Identifier |
"5" |
|
| Student_Dorm_Room_Number |
Yes, if this field needs to be updated |
Lookup |
"5A" |
|
| Student_Dorm_Building |
Yes, if this field needs to be updated |
Lookup |
"Building A" |
|
| Student_Dorm_Lunch_Table |
Yes, if this field needs to be updated |
Datasource Data |
"Table A" |
The possible values are populated by the school by clicking on "Lunch Table" in an Admin > Students > Details page. |
| Dorm_Room_NY_ID |
Yes, if this field needs to be updated |
Identifier |
"5" |
|
| Student_Dorm_Room_NY_Number |
Yes, if this field needs to be updated |
Lookup |
"5A" |
|
| Student_Dorm_NY_Building |
Yes, if this field needs to be updated |
Lookup |
"Building C" |
|
| Driving_License |
Yes, if this field needs to be updated |
Data |
"123DAV" |
|
| Car2_Color |
Yes, if this field needs to be updated |
Data |
"Green" |
|
| Car2_License_Plate |
Yes, if this field needs to be updated |
Data |
"1B34A" |
|
| Car2_Make |
Yes, if this field needs to be updated |
Data |
"Toyota" |
|
| Car2_Model |
Yes, if this field needs to be updated |
Data |
"Corolla" |
|
| Car2_Parking_Registration |
Yes, if this field needs to be updated |
Data |
"1b3d" |
|
| Car2_Year |
Yes, if this field needs to be updated |
Data |
2017 |
|
| Student_Selection_End_Date |
Yes, if this field needs to be updated |
Data |
"1/1/2023" |
|
| Day_Or_Boarding_NY |
Yes, if this field needs to be updated |
Data |
"Day"
"Boarding"
"Virtual" |
|
| International_Yes_Or_No_NY |
Yes, if this field needs to be updated |
Data |
"Y" or "N" |
|
| BC_School_Funding_Code_NY |
Yes, if this field needs to be updated |
Datasource Data |
"First Nations - 20" |
For British Columbia only |
| Grade_Level_ID |
Yes, if this field needs to be updated |
Identifier |
"1" |
|
| Grade_Level_Code |
Yes, if this field needs to be updated |
Lookup |
"PK" |
|
| Next_Grade_Level_ID |
Yes, if this field needs to be updated |
Identifier |
"1" |
|
| Next_Grade_Level_Code |
Yes, if this field needs to be updated |
Lookup |
"PK" |
|
| Pincode |
Yes, if this field needs to be updated |
Data |
"1234" |
Must pass the requirements set in Security>Maintenance>Application Setup |
| Year_Grad |
Yes, if this field needs to be updated |
Data |
"2024" |
Planned graduation year. |