(301) 947-7380
99.987% uptime·0 security breaches·35+ years in education·Built and supported in the U.S.
Posted August 26, 2021
Follow the steps for Importing New Records.

Field Required Type Sample Values Notes
*Login Yes Text "abc@school.org" If using Google SSO, use full google username such as abc@school.org.
*Password Yes Text "abc123$!" Password should not be shared via email; instead send a link to a reset password page so users can create their own passwords
*Email Yes Text "abc@school.org"  
UserDisplayName No Text "John Doe"  
AlternateId No Text "1234"  
StudentId Yes for student logins unless you use lookup fields to identify the student record Identifier "1234"  
(StudentLastName) No Lookup "Smith"  
(StudentFirstName) No Lookup "John"  
(StudentMiddleName) No Lookup "Adam"  
(StudentPreferredName) No Lookup "Joe"  
(StudentSex) No Lookup "Male"  
(StudentAlternateId) No Lookup "1234"  
HouseholdId Yes for parent, staff, and adult student logins unless you use lookup fields to identify the household record Identifier "1234" Adult students are those students who enroll to the school on their own instead of by their parents. For staff logins, HouseholdId and HouseholdIndicator identify the staff member's contact in their Staff Household, and the user receives the staff association automatically from that contact.
HouseholdIndicator Yes for household logins Datasource Data "P" Valid values are P for contact 1 (Primary) and S for contact 2 (Secondary).
(HouseholdName) No Lookup "Smith Family"  
(HouseholdAddress) No Lookup "5 Choke Cherry"  
(HouseholdCity) No Lookup "Austin"  
(HouseholdState) No Lookup "TX"  
(HouseholdZip) No Lookup "12345"  
(HouseholdCountry) No Lookup "United States"  
(HouseholdPhone) No Lookup "123-456-7890"  
(HouseholdEmail) No Lookup "abc@gmail.com"  
(ParentFirstName) No Lookup "John"  
(ParentMiddleName) No Lookup "Adam"  
(ParentLastName) No Lookup "Doe"  
(ParentSex) No Lookup "Male"  
(ParentAlternateId) No Lookup "12345"  
RoleName1 No Datasource Data "Faculty Full" See Roles Dictionary for more information
SchoolId1 No Identifier "1" See School Division for more information
(SchoolName1) No Datasource Data "Bistmar Lower School"

Note: A user that includes both a Student record and a Household record is one person: an of-age student who belongs to their own household. The household must list the student as its Self contact. Staff logins receive both their staff and household associations from the Staff Household, so those records are always connected.

Note: School Name, School id, and Role columns are repeated so that a user can be assigned to multiple School Divisions and roles.

Note: If no HouseholdIndicator is specified and the parent lookup fields identify exactly one contact, the indicator is filled in from that match. Each household login must have an indicator, either specified in the file or identified from the parent name.

See also
PCR Educator
School Operations Platform

One platform for K-12 schools, higher education, performing arts institutions, and health science programs since 1989.

PCR Educator on Capterra: 4.7 out of 5 stars
Platform
    Solutions
      Resources
        Company
          © 1989-2026 PCR Educator, Inc.Silver Spring, MD · U.S.A. · (301) 947-7380