Manage: Custom Reports and Glossary of Core Data Fields

When building a report, not only can you include custom form questions from forms, you can also include core data directly from our database!

Here's a run-down of what all those core data fields actually reference.

Account Table

Field	Description
id	SchoolMint account ID
email	SchoolMint account username, which is an email address or mobile number. Example: [e-mail] refers to a mobile number of [phone].
notify_to_email	N/A
preferred_contact	N/A
preferred_language	The language set on the account. Examples: EN = English, ES = Spanish
active	0 = an inactive account 1 = an active account
deleted	0 = a normal account 1 = account has been marked for deletion
created_by	The SchoolMint account username that created this account. Note that admins can create accounts on behalf of parents.
created_at	The date/time stamp in UTC at which the account was created.
updated_at	The date/time stamp in UTC at which the account was last updated.
signup_method	The method by which this account was created. Examples: Web, Mobile Web, Script (for imported accounts), iOS App, Android App.

Address Table

Field	Description
id	SchoolMint address ID
street1	Street address
street2	Apartment or unit
zipcode	ZIP/postal code
longitude	The longitude of the address.
latitude	The latitude of the address.
city_name	The city of the address.
state	The state of the address. Examples: TX, CA, NY, IL
country	The country of the address. Example: US
created_at	The date/time stamp in UTC at which the address was created.
updated_at	The date/time stamp in UTC at which the address was last updated.
status	The resulting status of address validation: valid: USPS recognized as a valid residential address; we have accurate and precise geolocation of this address. invalid_unit_number: same as valid, but the apartment or unit number is not valid. invalid_address_location: same as valid, but we do not have precise geolocation of this address business_address: USPS recognized as a valid business address. invalid_address_number: USPS does not recognize this address. missing_unit_number: USPS recognizes the address as an apartment/condominium building, but an apartment/unit number is missing. not_confirmed: it is possible that the address is not valid. When the user submitted an address, SchoolMint surfaced a valid address option, but the user chose to keep the originally submitted address. invalid_unit_number: the address is valid, but the apartment/unit number is unverifiable by USPS. [blank]: the address has not gone through SchoolMint validation. (Example: the address was imported).
location_type	We use Google Maps to geolocate addresses, and Google passes the information on the precision of that geolocation. ROOFTOP: indicates that the returned result is a precise geocode for which we have location information accurate down to street address precision. RANGE_INTERPOLATED: indicates that the returned result reflects an approximation (usually on a road) interpolated between two precise points (such as intersections). Interpolated results are generally returned when rooftop geocodes are unavailable for a street address. GEOMETRIC_CENTER: indicates that the returned result is the geometric center of a result such as a polyline (for example, a street) or polygon (region). APPROXIMATE: indicates that the returned result is approximate. [blank]: the address has not been geolocated by Google.
geolocated_by	The way in which the address was geolocated: google: geolocated by GoogleMaps [admin email]: the username of the admin who marked the location of this address on a map.
geolocated_at	The date/time stamp in UTC at which the address was geolocated.

Applications Table

Field	Description
id	SchoolMint application ID
student_id	SchoolMint student ID
status	Application status
account_id	SchoolMint account ID
grade_level	Grade level associated with the application
school_id	ID of the school associated with the application
offered_date	The date/time stamp in UTC that the application received an offer from a school
accepted_date	The date/time stamp in UTC that the application accepted an offer from a school
registration_completed_date	The date/time stamp in UTC the application registration is completed for a school
registration_verified_date	The date/time stamp in UTC the application registration is verified by an admin from a school
applicant_id	SchoolMint applicant ID of the child listed on the application
enrollment_id	SchoolMint ID for the enrollment year: 1 = 2014-2015 2 = 2015-2016 3 = 2016-2017 4 = 2017-2018 5 = 2018-2019 6 = 2019-2020 7 = 2020-2021
grade_enrollment_id	Not Recommended for Use
waitlist_number	If the application is on a waitlist, this is the application's waitlist number for the given school
lottery_result_id	Not Recommended for Use
lottery_global_number	A random number assigned to each student that does not take into account priorities or date submitted.
lottery_number	Similar to lottery_global_number except when an org opts to assign lottery numbers first. This is the application's lottery number should your org assign lottery numbers before pulling the first sub-lottery
lottery_tickets	The number of tickets that exist for the application; this is based on the sub-lottery weights that get determined from your org's priorities.
public_status
application_type	Defines the type of application: OE: Open Enrollment PE: Post Enrollment
applicant_rank	The rank of the application ie: Student has applied to 5 schools, and this applicant has ranked the designated school as "2"
created_at	The date/time stamp in UTC that the application was first created
updated_at	The date/time stamp in UTC that the application was last updated
updated_by	The email address of the last person who updated the application
status_timestamp	The date/time stamp in UTC that the application first moved into its current status
pending_waitlist	0: Not pending waitlist 1: Pending waitlist
priority_list	Not Recommended for Use
district_name	Name of the school district associated with the application
submission_date	The date/time stamp in UTC that the application was submitted
recommenders	The full name, email address, relationship, and phone number of all recommenders listed on the application. This data is displayed in the format of "recommendation_name_1":"[value]", etc.
recommendation_one	Not Recommended for Use
recommendation_one_status	Listed as either "sent" or "completed"
recommendation_two	Not Recommended for Use
recommendation_two_status	Listed as either "sent" or "completed"
recommendation_three	Not Recommended for Use
recommendation_three_status	Listed as either "sent" or "completed"
moved_to	Not Recommended for Use
moved_from	Not Recommended for Use
current_school_name	The current school of the child listed on the application
current_grade_level	The current grade level of the child listed on the application
moving_to_area	Not Recommended for Use

Emergency Contact Tables

Field	Description
id	SchoolMint contact ID
applicant_id	SchoolMint applicant ID
account_id	SchoolMint account ID
guardian_id	SchoolMint guardian ID
first_name	The first name of the emergency contact.
middle_name	The middle name of the emergency contact. Note: this value is almost always blank because it's not usually requested.
last_name	The last name of the emergency contact.
relationship	The emergency contact's relationship to the student. MO = Mother FA = Father SFA = Step Father SMO = Step Mother AU = Aunt UN = Uncle BR = Brother CO = Cousin CT = Caretaker FP = Foster Parent GP = Grandparent OT = Other SB = Sibling SI = Sister
gender	The gender of the emergency contact. Note: this value is almost always blank because it's not usually requested.
birth_date	The birthdate of the emergency contact. Note: this value is almost always blank because it's not usually requested.
is_emergency	0: this is not an emergency contact 1: this is an emergency contact
can_pickup	0: this contact is not authorized to pick up the student. 1: this contact is authorized to pick up the student. [blank]: the question was not asked.
is_custodian	0: this contact is not a custodian of the student. 1: this contact is a custodian of the student. [blank]: the question was not asked.
is_family_member	0: this contact is not a family member. 1: this contact is a family member. [blank]: the question was not asked.
email	The email address of the emergency contact.
home_phone_number	The home phone number of the emergency contact.
mobile_phone_number	The mobile phone number of the emergency contact.
work_phone_number	The work phone number of the emergency contact.
created_at	The date/time stamp in UTC at which the emergency contact was created.
updated_at	The date/time stamp in UTC at which the emergency contact was last updated.

Guardian Tables

Field	Description
id	SchoolMint guardian ID
first_name	The first name of the guardian.
middle_name	The middle name of the guardian. Note: this value is almost always blank because it's not usually requested.
last_name	The last name of the guardian.
email	The email address of the guardian.
gender	The gender of the guardian. F = Female, M = Male.
phone_number	The mobile phone number of the guardian.
home_phone_number	The home phone number of the guardian.
daytime_phone_number	The daytime phone number of the guardian.
title	The title of the guardian.  Examples: Mr., Mrs. Note: this value is almost always blank because it's not usually requested.
highest_education_level	Highest level of education attained by the guardian. NH = Not a High School Graduate HS = High School Graduate SC = Some College CG = College Graduate PG = Graduate Degree or Higher DS = Decline to State [blank] = the question was not asked.
occupation	The occupation of the guardian. Note: this value is almost always blank because it's not usually requested.
employer	The employer of the guardian.
relation	The guardian's relationship to the student. MO = Mother FA = Father SFA = Step Father SMO = Step Mother AU = Aunt UN = Uncle BR = Brother CO = Cousin CT = Caretaker FP = Foster Parent GP = Grandparent OT = Other SB = Sibling SI = Sister
primary	0: this guardian is not the primary guardian on the account. 1: this guardian is the primary and first guardian listed on the account.
contact_methods	The guardian's contact preference: ["EMAIL","SMS"] = Email and Text Message ["EMAIL"] = Email Only ["SMS"] = Text Message Only
account_id	SchoolMint account ID
address_id	SchoolMint address ID
created_at	The date/time stamp in UTC at which the guardian was created.
updated_at	The date/time stamp in UTC at which the guardian was last updated.
work_phone_number	The work phone number of the guardian.
import_code	If the guardian was imported, the import_code will be a number. Otherwise, the import_code will be blank.

Re-Enrollments Table

Field	Description
id	SchoolMint re-enrollment ID
account_id	SchoolMint account ID of the given re-enrollment record
sis_id	SIS ID of the re-enrollment record; since re-enrollment records come from the SIS, this is the SIS's internal ID (ie: PowerSchool's DCID)
sis_local_id	Local ID of the re-enrollment record from the SIS; this can vary from SIS to SIS (ie: PowerSchool's student number)
organization_id	SchoolMint internal ID for an organization
student_first_name	Student's first name on the re-enrollment record
student_last_name	Student's last name on the re-enrollment record
school_id	SchoolMint school ID
grade	Grade level of the re-enrollment record
classroom_code	Not Recommended for Use
grade_enrollment_id	Not Recommended for Use
contact_phone	Phone number associated with the contact of the re-enrollment record. This contact is most likely the primary guardian.
contact_email	Email address associated with the contact of the re-enrollment record. This contact is most likely the primary guardian.
status	Status of the re-enrollment record. The status can be one of the following: completed no_started progress not_returning verified
previous_status	Previous status of the re-enrollment. The previous status can be one of the following: completed undecided progress no_started
access_code	The associated access code for logging into the guardian SchoolMint account
enrollment_id	SchoolMint ID for the enrollment year: 1 = 2014-2015 2 = 2015-2016 3 = 2016-2017 4 = 2017-2018 5 = 2018-2019 6 = 2019-2020 7 = 2020-2021
applicant_id	SchoolMint ID of the applicant
created_at	The date/time stamp in UTC the re-enrollment record was created in SchoolMint
updated_at	The date/time stamp in UTC of the last update to the re-enrollment record in SchoolMint
decline_reason	The reason why a re-enrollment record declined their offer to return
sm_sis_student_id	Not Recommended for Use
completed_date	The date/time stamp in UTC at which the re-enrollment is completed
verified_date	The date/time stamp in UTC at which the re-enrollment is verified

Sibling Tables

Field	Description
id	SchoolMint sibling ID
student_id	SchoolMint student ID
applicant_id	SchoolMint applicant ID
name	The full name of the sibling.
attending_grade	The grade level of the sibling. This grade level only applies to attending and applying siblings.
birth_date	The sibling's date of birth.  This birthdate is usually collected for attending siblings.
graduated_year	The sibling's approximate date of graduation. This data is only collected for graduated siblings.
sibling_status	The status of the sibling. attending: the sibling has a brother or sister currently attending a school in this organization. graduated: the sibling has a brother or sister who graduated from a school in this organization. applying: the sibling has a brother or sister applying to a school in this organization
created_at	The date/time stamp in UTC at which the sibling was created.
updated_at	The date/time stamp in UTC at which the sibling was last updated.
school_id	The SchoolMint school ID of the school the sibling is attending or graduated from.

School Table

(only for Application-type reports)

Field	Description
id	SchoolMint school ID
name	School Name This information is configured in Settings > Add and Manage Schools.
group	Group This information is configured in Settings > Add and Manage Schools.
website	School Website This information is configured in Settings > Add and Manage Schools.
address_id	The SchoolMint address ID for this school.
from_email_address	The "Reply-To Email Address" for this school's automated trigger messages. Example: when making an offer to a student, an email could be sent to the student's guardian, and if that guardian replies to the email, this from_email_address is the email address it would go to. This information is configured in Settings > Manage Text Message and Email Templates
from_email_name	The "From Name" for this school's automated trigger messages. Example: when making an offer to a student, an email could be sent to the student's guardian, and the from_email_name shows up as who the email is from. This information is configured in Settings > Manage Text Message and Email Templates
direct_registration	0: Submitting an application puts the application into Submitted or Waitlisted status. 1: Submitting an application will allow the parent to go directly into the registration packet.
accepts_applications	0: the school is hidden on the Select Schools page in the application flow. 1: the school is shown on the Select Schools page in the application flow.
created_at	The date/time stamp in UTC at which the school was created.
updated_at	The date/time stamp in UTC at which the school was last updated.
nces_school_id	School NCES ID  This information is configured in Settings > Add and Manage Schools.
sis_school_number	The school's number or ID in your student information system (SIS).
enrollment_flow	The enrollment flow for which this SchoolMint school was set up. Examples: registration, lottery (choice), transfer, or [blank] (no specific enrollment flow).

Student Table

Field	Description
id	SchoolMint Student ID
applicant_id	SchoolMint ID of the applicant
account_id	SchoolMint ID of the account
account2_id	If a student is associated with more than one account, this is the ID of the second account
account3_id	If a student is associated with more than one account, this is the ID of the third account
account4_id	If a student is associated with more than one account, this is the ID of the fourth account
enrollment_status	The enrollment status of the student
account_login	The login of the student's guardian's account
account_language	The preferred language of the account holder
first_name	Student's first name
last_name	Student's last name
birth_date	Student's DoB
gender	Student's gender
current_school_id	ID of the current school attended by the student
current_school_name	Name of the current school attended by the student
current_grade_level	Grade of the current school attended by the student
student_id	SchoolMint ID of the student
phone_number	Student's phone number
lives_with	Lists who the student lives with as an abbreviation: MO = Mother FA = Father SFA = Step Father SMO = Step Mother AU = Aunt UN = Uncle BR = Brother CO = Cousin CT = Caretaker FP = Foster Parent GP = Grandparent OT = Other SB = Sibling SI = Sister
first_learned_language	Not Recommended for Use
home_use_language	Not Recommended for Use
student_most_used_language	Not Recommended for Use
free_reduced_lunch	0: Not eligible for free/reduced lunch 1: Eligible for free/reduced lunch
extra_support_language	0: Not eligible for extra language support 1: Eligible for extra language support
first_to_college	0: Not the first to college 1: First to go to college
student_enrolled_individualized_education_program	0: Student is not enrolled in an individualized education program 1: Student enrolled in individualized education program
student_health_conditions	0: No health conditions for the student 1: Student has health conditions
student_special_education_services	0: Student has special education services 1: Student does not have special education services
individualized_education_program_previous_school	Name of the previous school in which the student participated in an individualized education program
individualized_education_program_approximate_date	Date of the individualized education program
birth_city	Student's birth city
hispanic	0: Not Hispanic 1: Hispanic
usa_first_enrolled	The date the student was first enrolled in a school in the US
doctor_name	Student's doctor's name
doctor_number	Student's doctor's phone number
health_plan	Student's health insurance plan
medical_number	Do Not Use - To Be Removed
home_phone_number	Student's home phone number
nycph	0: Student is not NYCPH eligible 1: NYCPH eligible
snap_tanf	0: Student is not SNAP/TANF eligible 1: SNAP/TANF eligible
unaccompanied_youth	0: Student is not an unaccompanied youth 1: Student is an unaccompanied youth
failing_school	0: Student is not failing school 1: Student is failing school
discovery_reason_name	How the student heard about the school
parent_board_member	0: Student's parent is not a board member 1: Student's parent is a board member
parent_board_name	Name of the parent who is a board member
parent_staff_member	0: Student's parent is not a staff member 1: Student's parent is a staff member
parent_staff_name	Name of the parent who is a staff member
has_previously_attended_school	0: Student has not previously attended school 1: Student has previously attended school
sis_export_status Field Not Available - Currently Under Construction	Indicates the status of the student record in relation to being exported out of SchoolMint for the purposes of sending the record to the SIS. Export status includes: not_exported exported downloaded
sis_last_sync_label Field Not Available - Currently Under Construction	If the student record has been exported from SchoolMint and into the SIS, then it will be associated with particular sync. This field is the label associated with that sync log record.
sis_exported_at Field Not Available - Currently Under Construction	The date/time stamp in UTC of the sync label
created_at	The date/time stamp in UTC that the student was created
updated_at	The date/time stamp in UTC that the student was last updated
sis_id	SIS ID of the re-enrollment record; since re-enrollment records come from the SIS, this is the SIS's internal ID (ie: PowerSchool's DCID)
sis_local_id	Local ID of the re-enrollment record from the SIS; this can vary from SIS to SIS (ie: PowerSchool's student number)
classroom_code	Not Recommended for Use
tuition_amount_due	Not Recommended for Use
depositing_amount	Not Recommended for Use
financial_aid_amount	Not Recommended for Use
start_date	Not Recommended for Use
end_date	Not Recommended for Use
homeless_shelter	0: Student does not live in a homeless shelter 1: Student lives in a homeless shelter
homeless_shelter_address	Address of the homeless shelter
guidance_counselor	Name, email, and phone number of the student's guidance counselor. This data is displayed in the format of "guidance_counselor_name_1":"[value]", etc.
school_next_year	Student's school for the next school year
grade_next_year	Student's grade for the next school year
financial_info	0: Financial information is not present for the student 1: Financial information is present for the student
address_reviewed_by	Email address of the admin who reviewed the student's address
address_reviewed_at	The date/time stamp in UTC when the address was reviewed
activated_at	The date/time stamp in UTC when the student was activated in SchoolMint
parent_staff_school_name	If the parent is a staff member, this is the school they are associated with
household_size	Size of the student's household
creation_method	Indicates how the student record was created in SchoolMint. Can be created within the UI, through a re-enrollment import, an application import, or via Interest Tracker
attending_sibling	0: Student does not have a sibling attending the school 1: Student has a sibling attending the school
graduated_sibling	0: Student has no sibling who graduated from the school 1: Student has a sibling who graduated from the school
monthly_household_income	Not Recommended for Use

------------------------------------------------------------------------------------------------------

Still have questions? Email us at [e-mail].