Products
Admissions & Enrollment
After School Activities
API
Cafeteria & POS
School CRM
Data Analytics & AI
CMS
Donations
Enrollment Management System
Financial Aid Management
Finance & Accounting
Fundraising
Point of Sale
Scheduling
Student Information System
Summer School & Summer Camp
Solutions
K-12 Private and Independent Schools
K-12 Public Schools
Colleges & Universities
Medical Schools
Vocational and Technical Schools
International Schools
Dance and Theater Schools
Youth Programs
Canadian Schools
Why PCR Educator
Team
Knowledge Base
FAQ
Training and Support
School Portal
Customer Portal
PCR independent school management solution and website
Products
Admissions & Enrollment
After School Activities
API
Cafeteria & POS
School CRM
Data Analytics & AI
CMS
Donations
Enrollment Management System
Financial Aid Management
Finance & Accounting
Fundraising
Point of Sale
Scheduling
Student Information System
Summer School & Summer Camp
Solutions
K-12 Private and Independent Schools
K-12 Public Schools
Colleges & Universities
Medical Schools
Vocational and Technical Schools
International Schools
Dance and Theater Schools
Youth Programs
Canadian Schools
Why PCR Educator
Team
Knowledge Base
FAQ
Training and Support
School Portal
Customer Portal
Sign In
Demo
School CRM
Knowledge Base
Importing New Records - Household Attributes
Importing New Records - Household Attributes
Importing New Records - Household Attributes
Follow the steps for
Importing New Records
Field
Required
Type
Sample Value
Notes
Household_Id
Yes, unless lookup fields are used to identify the Household
Identifier
"123"
Must match an existing household id in the system
Attribute
_Id
No
Identifier
"456"
Must match an existing attribute id in the system
Lookup_Household_Id
No, unless Household_Id is not specified
Lookup
"789"
Must match an existing Household Id in the system
Lookup_Household_Name
No, unless Household_Id is not specified
Lookup
"Smith Family"
Lookup_Household_Address
No, unless Household_Id is not specified
Lookup
"123 Main St"
Lookup_Household_Alternate_Id
No, unless Household_Id is not specified
Lookup
"123"
Must match an existing Household Alternate Id in the system
Lookup_Parent1_First_Name
No, unless Household_Id is not specified
Lookup
"John"
Must match an existing Parent 1 First Name in the system
Lookup_Parent2_First_Name
No, unless Household_Id is not specified
Lookup
"Jane"
Must match an existing Parent 2 First Name in the system
Lookup_Parent1_Alternate_Id
No, unless Household_Id is not specified
Lookup
"456"
Must match an existing Parent1 Alternate Id in the system
Lookup_Parent2_Alternate_Id
No, unless Household_Id is not specified
Lookup
"789"
Must match an existing Parent2 Alternate Id in the system
Lookup_Category_Id
No, unless
Attribute
_Id is not specified
Lookup
"123"
Must match an existing Category Id in the system
Lookup_Category
No, unless
Attribute
_Id is not specified
Text
"Donor"
Lookup_
Attribute
_Id
No, unless
Attribute
_Id is not specified
Identifier
"456"
Must match an existing
Attribute
Id in the system
Lookup_
Attribute
No, unless
Attribute
_Id is not specified
Text
"VIP"
Attribute
_Comment
No
Text
"Long-time supporter"
Attribute
_Begin_Year
No, unless attribute is yearable
Integer
"2020/2021"
Attribute
_End_Year
No, unless attribute is yearable
Integer
"2025/2026"
See also
Importing New Records
Attribute
Linkedin
301-947-7380
sales@pcreducator.com
Schedule Demo
Please, make sure that all required fields (marked with *) are completed.
School Name
Please Enter a Maximum of 100 Characters.
*
Relation to School
*
select
Administration - Database Manager
Administration - Head of School
Administration - Registrar
Development - Director of Development
Finance - Business Manager
Finance - CFO
IT - Director of Technology
Other - Parent
Other - Staff
Other - Volunteer
Last Name
Please Enter a Maximum of 30 Characters.
*
Your First Name
Please Enter a Maximum of 20 Characters.
*
Your Email
Invalid Email
Please Enter a Maximum of 100 Characters.
*
Your Phone #
Please Enter a Maximum of 20 Characters.
*
Household
User
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.