Household Demographic Data
id
name
mailing_title
letter_salutation
parish
mailing_street_address_1
mailing_street_address_2
mailing_city
mailing_state
mailing_postal_code
mailing_country
billing_street_address_1
billing_street_address_2
billing_city
billing_state
billing_postal_code
billing_country
school_year_joined
share_address
share_phone
primary_email
secondary_email
home_phone_number
work_phone_number
work_phone_number_extension
cell_phone_number
primary_language
contact_preference
envelope_number
TADSID
Household Contacts
id
contact_id
First Name
Last Name
household_id
primary_contact
primary_flag
TADSID
home_address_same_as_household
Staff Demographics
id
first_name
middle_name
last_name
preferred_name
prefix
suffix
gender
employee_status
birth_date
home_street_address_1
home_street_address_2
home_city
home_state
home_postal_code
home_country
billing_street_address_1
billing_street_address_2
billing_city
billing_state
billing_postal_code
billing_country
seasonal_address_1
seasonal_street_address_2
seasonal_city
seasonal_state
seasonal_postal_code
seasonal_country
seasonal_start_month
seasonal_start_year
seasonal_end_month
seasonal_end_year
home_phone_number
work_phone
work_phone_extension
cell_phone
primary_phone_number
personal_email
school_email
work_email
title
title_change_date
employee_type
employee_credential
education_credential
teaching_license
teaching_license_expiration
background_check
background_check_type
background_check_date
full_time_equivalency
school_level_elementary
school_level_middle_school
school_level_high_school
parking_spot
safe_environment_check_type
safe_environment_check_type_date
ethnicity
religion
citizenship_status
marital_status
rank
salary
deceased
lunch_account_number
language
start_date
Student Demographics
id
primary_household_id
secondary_household_id
tertiary_household_id
student_number
first_name
middle_name
last_name
status
grade
suffix
preferred_name
birth_place
birth_date
birth_certificate_number
gender
citizenship_status
ethnicity
religion
language
parish
primary_student
home_internet_access
address_1
address_2
city_1
state_1
postal_code_1
county_1
country_1
primary_phone_number_type
home_phone_number
cell_phone
work_phone_number
work_phone_number_extension
personal_email
school_email
primary_email_address_type
alternate_id
barcode_number
school_district
graduation_year
locker_number
locker_combination
approved_area
subsidized_transportation
lunch_account_id
state_id
TADSID
Student Contact
id
contact_id
student_id
contact_relationship
emergency_contact
sort_order
custody_status
Organization Person (Donor Management)
id
person_id
organization_id
relationship_category
education
school_type
graduated
graduation_year
school_name_graduation
title
profession
Primary_Contact
Current_Employer
Membership
title
Primary_Contact
Person Relationship (Donor Management)
Person Relationship ID
Person_One_ID
Person_Two_ID
relationship(person_2_is__of_person_1)