Importing Data for Existing Records - Students
Follow the steps for Importing Data for Existing Records
Field Required Type Sample Values Notes
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.

Schedule Demo
Please, make sure that all required fields (marked with *) are completed.
    School Name *
    Relation to School *
    select
    Last Name *
    Your First Name *
    Your Email *
    Your Phone # *
    PCR Educator School Information System is an online database engineered for schools and universities to deliver the highest level of flexibility, unique experience, transparent communication and customized design.