| Household_ID |
No |
Key Id Field |
"1" |
|
| Household_Name |
Yes |
Text |
"Jackson Family" |
|
| Parent1_First_Name |
No |
Text |
"John" |
|
| Parent1_Last_Name |
Yes, if Parent2_Last_name is not specified |
Text |
"Madden" |
|
| Parent2_First_Name |
No |
Text |
"Bob" |
|
| Parent2_Last_Name |
Yes, if Parent1_Last_Name is not specified |
Text |
"Dole" |
|
| Send_Mail_Yes_No |
No |
Datasource Data |
"Y" or "N" |
Used for "Send Mail" in Admin->Households->Details->Household Details. Note: While this field is not technically required, if there is any doubt about how this field should be specified for a household record set it to Y. |
| Carpool_Yes_No |
No |
Datasource Data |
"Y" or "N" |
|
| Safe_Party_Yes_No |
No |
Datasource Data |
"Y" or "N" |
Used for "Safe Party" in Admin->Households->Details->Household Details. |
| Household_Web_Publish_Yes_No |
No |
Datasource Data |
"Y" or "N" |
Used for "Publish on online directory" in Admin->Households->Details->Household Details. |
| Household_Alternate_ID |
No |
Text |
"23532asd23" |
Must be a set of alphanumeric characters. |
| Household_Salutation |
No |
Text |
"Mr. and Mrs Jones" |
|
| Household_Alernate_Salutation |
No |
Text |
"John and Samantha" |
|
| Household_Addressee1 |
No |
Text |
"Mr H. Jones and Mrs. Q Jones", "Mr. Squall Leonhart" |
|
| Household_Addressee2 |
No |
Text |
"Mrs. Quistis Trepe" |
|
| Household_Address1 |
No |
Text |
"23 Summer Parkway" |
|
| Household_Address2 |
No |
Text |
"Apt 123" |
Used if you need more room for an address. |
| Household_Address3 |
No |
Text |
"Ontario" |
Additional room for an address. |
| Household_City |
No |
Text |
"Baltimore" |
|
| Household_State |
No |
Datasource Data |
"TX" |
|
| Household_Zip |
No |
Text |
"43562", "34532-3323" |
|
| Household_Country |
No |
Datasource Data |
"USA" |
|
| Household_County_District |
No |
Text |
"Dallas" |
|
| Household_Phone |
No |
Text |
"(635) 1234-007" |
|
| Household_Email |
No |
Text |
"bigemail38@hotmail.com" |
|
| Parent1_Type |
No |
Datasource Data |
"Mother", "Stepfather", "Guardian" |
Household Details>Parent1 Type |
| Parent1_First_Name |
No |
Text |
"Zell" |
|
| Parent1_Middle_Name |
No |
Text |
"Balamb" |
|
| Parent1_Preferred_Name |
No |
Text |
"Kristy" |
|
| Parent1_Previous_Last_Name |
No |
Text |
"Dincht" |
|
| Parent1_Suffix |
No |
Text |
"Jr." |
Household Details>Parent1 Suffix |
| Parent1_Sex |
No |
Datasource Data |
"Male" |
Household Details->Parent1 Gender |
| Parent1_Title |
No |
Datasource Data |
"Mr." |
|
| Parent1_Birthdate |
No |
Date |
"1964/01/12" |
|
| Parent1_Deceased_Date |
No |
Date |
"2015/03/16" |
|
| Parent1_Citizenship |
No |
Datasource Data |
"USA" |
|
| Parent1_Native_Language |
No |
Datasource Data |
"German" |
|
| Parent1_Birthplace |
No |
Text |
"Germany" |
|
| Parent1_alternate_ID |
No |
Text |
"23152a42" |
|
| Parent1_Email |
No |
Text |
"Sammytomson@gmail.com" |
|
| Parent1_Email1_Type |
No |
Datasource Data |
"Work" |
|
| Parent1_Phone1 |
No |
Text |
"(234) 234-2235" |
|
| Parent1_Phone1_Type |
No |
Datasource Data |
"Mobile" |
|
| Parent1_Employer |
No |
Text |
"PCR Educator" |
|
| Parent1_Position |
No |
Text |
"Chief Engineer" |
|
| Parent1_Industry |
No |
Datasource Data |
"Software Technology" |
|
| Parent1_Work_Address1 |
No |
Text |
"23 Summer Parkway" |
|
| Parent1_Work_Address2 |
No |
Text |
"Apt 123" |
Used if you need more room for an address. |
| Parent1_Work_Address3 |
No |
Text |
"Ontario" |
Additional room for an address. |
| Parent1_Work_City |
No |
Text |
"Albany" |
|
| Parent1_Work_State |
No |
Datasource Data |
"NY" |
|
| Parent1_Work_Zip |
No |
Text |
"22345", "22234-2345" |
|
| Parent1_Work_Country |
No |
Datasource Data |
"USA" |
|
| Parent1_pincode |
No |
Integer |
"32234" |
Used for check in/check out. Generally needed for afterschool activities. |
| Parent1_Year_Grad |
No |
Integer |
2003 |
|
| Parent1_Elementary_School |
No |
Text |
"North Olive Elementary" |
|
| Parent1_Elementary_School_Degree |
No |
Text |
"Elementary School Diploma" |
|
| Parent1_Elementary_School_Gradyr |
No |
Integer |
"1973" |
|
| Parent1_Middle_School |
No |
Text |
"Hamilton Middle" |
|
| Parent1_Middle_School_Degree |
No |
Text |
"Middle School Diploma" |
|
| Parent1_Middle_School_Gradyr |
No |
Integer |
"1976" |
|
| Parent1_High_School |
No |
Text |
"Moonglade Community High School" |
|
| Parent1_High_School_Degree |
No |
Text |
"High School Diploma" |
|
| Parent1_High_School_Gradyr |
No |
Integer |
"1980" |
|
| Parent1_Undergrad_School |
No |
Text |
"Florida State University" |
|
| Parent1_Undergrad_School_Degree |
No |
Text |
"Bachelors of Science in Mechanical Engineering" |
|
| Parent1_Undergrad_School_Gradyr |
No |
Integer |
"1984" |
|
| Parent1_Grad_School1 |
No |
Text |
"Harvard University" |
|
| Parent1_Grad_School_Degree1 |
No |
Text |
"Master of Applied Science" |
|
| Parent1_Grad_School_Gradyr1 |
No |
Integer |
"1986" |
|
| Parent1_Grad_School2 |
No |
Text |
"Massachusetts Institute of Technology" |
|
| Parent1_Grad_School_Degree2 |
No |
Text |
Doctor of Engineering |
|
| Parent1_Grad_School_Gradyr2 |
No |
Integer |
"1990" |
|
| Physician_Name |
No |
Text |
"Dr.John Smith" |
|
| Physician_Phone |
No |
Text |
"(342) 234-2342" |
|
| Physician_Practice_Name |
No |
Text |
"John's Doctor House" |
Used in Admin->Households->Details->Household Details->Medial Info Practice Name |
| Insurance_Name |
No |
Text |
"HealthyUSA" |
|
| Insurance_Num |
No |
Integer |
"23424" |
|
| Insurance_Group_Num |
No |
Integer |
"12345678900" |
|
| Insurance_Primary_Holder_Name |
No |
Text |
"Zell Dincht" |
|
| Insurance_Primary_Holder_Employer |
No |
Text |
"PCR Educator" |
Used in Admin->Households->Details->Household Details->Medial Info Primary Holder Employer |
| Dentist_Name |
No |
Text |
"Vance McTeeth" |
|
| Dentist_Phone |
No |
Text |
"(353) 757-3234" |
|
| Bond_Id |
No |
Identifier |
"234323452" |
Exclusive for Canada. Used for Canada Learning Bond |
| Bond_Date_Issued |
No |
Date |
"2010/03/02" |
Exclusive for Canada. Date Learning Bond was issued |
| Bond_Desc |
No |
Decimal |
"$1300" |
Exclusive for Canada. Value/Description of the Learning Bond. |
| Emergency1_Title |
No |
Text |
"Mrs." |
|
| Emergency1_Type |
No |
Datasource Data |
"Grandmother" |
|
| Emergency1_Relationship |
No |
Datasource Data |
"Grandfather" |
|
| Emergency1_First_Name |
No |
Text |
"Edea" |
|
| Emergency1_Last_Name |
No |
Text |
"Kramer" |
|
| Emergency1_Ok_To_Pickup |
No |
Datasource Data |
"Y" or "N" |
Used for "Can Pickup" in Admin->Households->Details->Household Details->Emergency Contacts |
| Emergency1_Pincode |
No |
Integer |
36452 |
Pincode used for Check in/Check Out. |
| Emergency1_Phone1 |
No |
Text |
"(635) 235-2356" |
|
| Emergency1_Phone1_Type |
No |
Datasource Data |
"Cell" |
|
| Descriptors_Address1_Descriptor_type_ID |
No |
Identifier |
"32" |
Household Attribute Type Id |
| Descriptors_Address1_category |
No |
Lookup |
"Tuition Package" |
If the attribute ID is unknown, provide the house attribute category in this field. The system will use the category and attribute description to find the attribute ID. |
| Descriptors_Address1_attribute_desc |
No |
Lookup |
"Update payment info" |
If the attribute ID is unknown, provide the house attribute description in this field. The system will use the category and attribute description to find the attribute ID. |
| Descriptors_Address1_year |
No |
Integer |
"20202021" |
"Must be in the format of 8 digits. (XXXXYYYY). If attribute timing is set to "global", leave this blank." |
| Descriptors_Address1_descriptor_comment |
No |
Text |
"Use payment info on file" |
A comment relating to the attribute. |