Data Importer: Gateway to Prep

Overview

Gateway to Prep Schools (GTP) is a third-party online application system designed to help admission candidates navigate through the application process. Through this tool, applicants are able to research schools of interest, inform schools of their interest in them, and submit applications to multiple schools.

Using the Data Importer web application (import.veracross.com/<yourschool>), Veracross is able to import data from Gateway to Prep Schools in order to create application records in Veracross.

Uploading Gateway to Prep Schools data involves two steps:

  1. Preparing the data for upload using the Gateway to Prep Schools template (csv file). This template file is accessible from the Data Importer site. Read more about the Veracross Data Importer.
  2. Uploading the data via the Veracross Data Importer app.

Preparing the Data to Upload

Prepare a comma-separated value (CSV) file containing the data for the Veracross field column listed below. This CSV file must contain a column for each Veracross field listed below and they must be in that same order. Even if no content is populated in a columns, the column must still exist as a placeholder in order for the Data Importer to properly read the file. In order to produce CSV for this import type, use the Gateway to Prep Student Profile CSV export. The fields on this export will match the fields required by this import type. Upload the CSV file using the Data Importer.

Gateway to Prep Mapping Reference

Gateway to Prep Mapping query

Veracross uses Gateway to Prep’s data dictionary to help define field mapping references. This information is then used to make initial mapping references on behalf of the school. Any fields that are ambiguous or unknown are left unmapped so the schools and their Account Manager can discuss the best mapping option for those fields. When Gateway to Prep mapping references has been set up at a school, two new queries will be available on the System homepage under the Veracross Integrations section.

  • Gateway to Prep Mapping
    This query represents the initial mapping Veracross creates based on GTP’s data dictionary. It displays a list of all GTP values and how they map to Veracross table names and descriptions. Work with the Account Manager to verify the mapping.
  • Incomplete Gateway to Prep Mapping
    This query displays a list of all unmapped GTP values. Schools should work with their Account Manager to determine if these fields need to be mapped to a Veracross value (it is possible not all will be necessary to map). Schools should communicate any changes that need to be made to the mapped references. Veracross will then add the appropriate reference to complete the mapping.

Field Mapping

Data is mapped to fields from GTP to Veracross using three import strategies:

Import Type Description
Insert Only Value will be applied to VC record only upon VC record insert.
Updated per import Value is applied to corresponding VC record replacing any existing value.
Update if blank Value is applied to corresponding VC record if the VC field in question is blank.

In the following tables, information in the “Import Type” column indicates which Veracross field is updated with data from GTP only once at initial upload, updated/replaced per import, or updated only if blank.

Candidate 

Admission Candidate Mapping

Veracross will insert new admission candidate (child) records into the database from GTP, unless it finds an existing person record using the following criteria:

  • An existing Veracross person record exists where the Legacy ID is the GTP ID (this is called Application ID field in the GTP data).
  • The data source is set to either “Gateway to Prep Candidate” or “Third Party: Gateway to Prep ID.”

Alternatively, the data import checks for cases where the first name, last name, and date of birth match data from Gateway to Prep. The matching checks against both normal person records and person records that were previously merged. If no matching person record is found, a new person record is created.

Some fields on the admission candidate record are only populated upon initial record creation; they are not synced from GTP to Veracross after initial record creation. These fields have an import type of “insert only” in the following Admissions Candidate field imports table.

Fields
The following table specifies all fields mapped from GTP to Veracross for admissions candidate records.

GTP Field Veracross Person Field Import Type
application_id Legacy ID Insert Only
app_fn First Name Insert Only
app_mn Middle Name Insert Only
app_ln Last Name Insert Only
app_nickname Preferred Name Insert Only
app_suffix Name Suffix Insert Only
cityofbirth + stateofbirth + countryofbirth Place of Birth Insert Only
app_dob1 / app_dob2 / app_dob3 Date of Birth Insert Only
app_sex Gender Insert Only
race_african_amer Ethnicity Insert Only
race_african Ethnicity Insert Only
race_asian_amer Ethnicity Insert Only
race_asian Ethnicity Insert Only
race_hispanic Ethnicity Insert Only
race_mexican Ethnicity Insert Only
race_mideastern Ethnicity Insert Only
race_native_amer Ethnicity Insert Only
race_hawaiian Ethnicity Insert Only
race_puertorican Ethnicity Insert Only
race_white Ethnicity Insert Only
race_other Ethnicity Insert Only
race_noresponse Ethnicity Insert Only
app_email Email 1 Updated if blank
app_ph Phone Home Updated if blank
app_cellph Phone Mobile Updated if blank
grade_current Current Grade Insert only*
year_applying_for Year Applying For Insert only*
grade_applying_for Grade Applying For Insert only*
residential_status Resident Status Applying For insert only*

* Note: Information in the fields current grade, year applying for, grade applying for, and resident status applying for is updated during the first data sync (insert only) for Candidate information for the year they are applying for. Schools do have the ability to manually override these imported values and all future data imports will not override these changes. For example: a candidate applies for next year and the data from GTP to Veracross populates the “year applying for” field as next year, but later the school decides to admit this candidate for the current year as a mid-year admit and thus manually updates the “year applying for” field on the Candidate record to the current year. Rerunning the upload will not override the school’s manually changed value to the mid-year date.

Candidate Language

Veracross will insert any new language records, that do not exist, into the database from GTP.  When a new language record is added in Veracross, the “primary code” and the “language spoken at home” field are both set to true.

The field on the candidate language record is only populated upon initial record creation; it is not synced from GTP to Veracross after initial record creation. This field has an import type of “insert only” in the following Candidate Language field imports table.

Fields
The following table specifies all fields mapped from GTP to Veracross for person language records.

GTP Field Veracross Language Field Import Type
homelanguage Language Insert Only

Candidate Citizenships

Veracross will insert any new citizenship records, that do not exist, into the database from GTP.

Fields
The following table specifies all fields mapped from GTP to Veracross for person citizenship records.

GTP Field Veracross Citizenship Field Import Type
citizenship country Insert Only
dualcitizenshiporigin country Insert Only
uspermresident country Insert Only
othercitizenship country Insert Only
othercitizenship2 country Insert Only

Candidate Role

By default, Veracross adds the “Prospect” role to all candidates from GTP if they do not currently have the prospect, applicant, or future student roles. However, if the “imported as completed” Admission Checklists include ALL Admission Checklists flagged as “Required for Application,” then two things are triggered in the system: a) an Application record is created for the Applicant (inheriting data from the Candidate Admission record above), b) the “Prospect” role becomes “Applicant.”

Candidate Household Mapping

Veracross will insert new household records into the database from GTP unless it finds an existing household record using the following criteria in this order:

  1. If an existing candidate record was found in the above Candidate mapping, and this candidate had a household specified, this existing household will be used for the candidate’s household.
  2. Otherwise, If the candidate did not have a household specified yet, then existing Veracross household data will be reviewed where the Veracross Household Legacy ID matches GTP ID and the data source is “Gateway to Prep Candidate Household.”

The mapping checks against both normal household records and records that were previously merged. If it does not find a match, a new household record is created. All fields on the household record are synced ONLY upon initial record creation. These fields have an import type of “insert only” in the following Candidate Household field imports table.

Fields
The following table specifies all fields mapped from GTP to Veracross for candidate person household records.

GTP Field Veracross Household Field Import Type
application_id Legacy ID Insert Only
app_ln Household Name Insert Only
app_address Address 1 Insert Only
app_address2 Address 2 Insert Only
app_address3 Address 3 Insert Only
app_city City Insert Only
app_state State/Province Insert Only
app_zip_pcode Postal Code Insert Only
app_country Country Insert Only

Parents

Parent Mapping

Veracross will insert new parent records into the database from GTP unless an existing person record is found using the following criteria:

  • The existing person’s Veracross Legacy ID matches the GTP ID.
  • The data source is set to “Gateway to Prep Parent.”

Alternatively, the relationship between the parent and the candidate is used to match parent records. Veracross will look for a relationship where the parent’s first name and last name matches the GTP parent’s first and last name, and the relationship to the candidate in Veracross is identical to the relationship coming from GTP.

If no matching record is found, a new person record for the parents is created. Note, parents must have a first and last name specified to create a new record. Some fields on the parent records are synced ONLY upon initial record creation. These fields have an import type of “insert only” in the following Parents field import table.

Fields
The following table specifies all fields mapped from GTP to Veracross for parent person records.

GTP Field Veracross Person Field Import Type
application_id Legacy ID Insert Only
parent1courtesytitle Name Prefix Insert Only
parent1first First Name Insert Only
parent1middle Middle Name Insert Only
parent1last Last Name Insert Only
parent1suffix Name Suffix Insert Only
parent1occupation Job Title Insert Only
parent1alive Date of Death Insert Only
parent1birthplace Place of Birth Insert Only
parent1homeemail Email 1 Update if blank
parent1workphone Phone business Update if blank
parent1cellphone Phone Mobile Update if blank
parent2courtesytitle Name Prefix Insert Only
parent2first First Name Insert Only
parent2middle Middle Name Insert Only
parent2last Last Name Insert Only
parent2suffix Name Suffix Insert Only
parent2occupation Job Title Insert Only
parent2alive Date of Death Insert Only
parent2birthplace Place of Birth Insert Only
parent2homeemail Email 1 Update if blank
parent2workphone Phone business Update if blank
parent2cellphone Phone Mobile Update if blank
parent3courtesytitle Name Prefix Insert Only
parent3first First Name Insert Only
parent3middle Middle Name Insert Only
parent3last Last Name Insert Only
parent3suffix Name Suffix Insert Only
parent3occupation Job Title Insert Only
parent3alive Date of Death Insert Only
parent3birthplace Place of Birth Insert Only
parent3homeemail Email 1 Update if blank
parent3workphone Phone business Update if blank
parent3cellphone Phone Mobile Update if blank
parent4courtesytitle Name Prefix Insert Only
parent4first First Name Insert Only
parent4middle Middle Name Insert Only
parent4last Last Name Insert Only
parent4suffix Name Suffix Insert Only
parent4occupation Job Title Insert Only
parent4alive Date of Death Insert Only
parent4birthplace Place of Birth Insert Only
parent4homeemail Email 1 Update if blank
parent4workphone Phone business Update if blank
parent4cellphone Phone Mobile Update if blank

Parent Household Mapping

GTP stores household address data for parents in two places: Household 1 fields and Household 2 fields. Parents 1 and 2 use data from Household 1 fields, and Parents 3 and 4 use data from Household 2 fields.

Veracross will insert new parent household records into the database from GTP unless an existing parent household record is found using the following criteria:

  • The existing Veracross household Legacy ID matches the GTP ID.
  • The data source is set to “Gateway to Prep Parent Household.”

Alternatively, the related candidate’s household is used for Parents 1 and 2 (Household 1) if the candidate’s household address matches the parent’s address. If the address in Household 1 is blank, it is also set to the candidate’s household address.

If no matching record is found, a new household record is created.

All fields on the household record are synced ONLY upon initial record creation. These fields have an import type of “insert only” in the following Parents Household field import table.

Fields
The following table specifies all fields mapped from GTP to Veracross for parent household records.

GTP Field Veracross Household Field Import Type
application_id Legacy ID Insert Only
parent1last Household Name Insert Only
household1address1 Address 1 Insert Only
household1address2 Address 2 Insert Only
household1address3 Address 3 Insert Only
household1city City Insert Only
household1state State/Province Insert Only
household1zip Postal Code Insert Only
household1country Country Insert Only
household1homephone Phone Insert Only
parent2last Household Name Insert Only
household2address1 Address 1 Insert Only
household2address2 Address 2 Insert Only
household2address3 Address 3 Insert Only
household2city City Insert Only
household2state State/Province Insert Only
household2zip Postal Code Insert Only
household2country Country Insert Only
household2homephone Phone Insert Only

Parent Employer Mapping

Veracross will insert new organization records for the parent’s employer into the databases from GTP, unless it finds an existing organization record using the following criteria:

  • An existing Veracross organization record exists where the Legacy ID is the GTP ID.
  • The data source is set to either “GTP Parent Employer.”

Alternatively, Veracross will look for existing employer organizations where the employer name in GTP matches the organization name in Veracross and the GTP employer address matches the organization’s “Address Line 1” in Veracross.

If no matching record is found, a new organization record will be inserted with an organization type of “Business.”

All fields on the organization record are synced ONLY upon initial record creation. These fields have an import type of “insert only” in the following Parents Employers organization field import table.

Fields
The following table specifies all fields mapped from GTP to Veracross for parent employer organization records.

GTP Field Veracross Person Field Import Type
application_id Legacy ID Insert Only
parent1employer Organization Name Insert Only
parent1businessaddress Address 1 Insert Only
parent2employer Organization Name Insert Only
parent2businessaddress Address 1 Insert Only
parent3employer Organization Name Insert Only
parent3businessaddress Address 1 Insert Only
parent4employer Organization Name Insert Only
parent4businessaddress Address 1 Insert Only

Parent Employer Relationship Mapping

Once a organization record is either found or created, a parent receives the “employer” relationship with their employer organization.

All fields on the parent employer relationship record are synced ONLY upon initial record creation. These fields have an import type of “insert only” in the following Parents Employer Relationship field import table.

Fields
The following table specifies all fields mapped from GTP to Veracross for parent employer relationship records.

GTP Field Veracross Person Field Import Type
parent1businessaddress Address 1 Insert Only
parent1occupation Title Insert Only
parent1workphone Phone Insert Only
parent2businessaddress Address 1 Insert Only
parent2occupation Title Insert Only
parent2workphone Phone Insert Only
parent3businessaddress Address 1 Insert Only
parent3occupation Title Insert Only
parent3workphone Phone Insert Only
parent4businessaddress Address 1 Insert Only
parent4occupation Title Insert Only
parent4workphone Phone Insert Only

Candidate/Parent Relationship Mapping

Veracross will insert new candidate parent relationship records if the relationship does not exist.

Note on Import Type “Updated per import”
If the records do exist, but the relationship in Veracross is either “non-specified,” “unspecified relative,” or “other” Veracross will update the candidate parent relationship and legal custody on the Veracross relationship record from the GTP data. 

If the candidate parent relationship in Veracross already matches the relationship from GTP, no updates will be made.

Fields
The following table specifies all fields mapped from GTP to Veracross for candidate/parent relationship records.

GTP Field Veracross Person Relationships Field Import Type
parent1type Relationship Updated per import (see note)
legal1 Legal Custody Updated per import (see note)
parent2type Relationship Updated per import (see note)
legal2 Legal Custody Updated per import (see note)
parent3type Relationship Updated per import (see note)
legal3 Legal Custody Updated per import (see note)
parent4type Relationship Updated per import (see note)
legal4 Legal Custody Updated per import (see note)

Siblings

Candidate Sibling Mapping

Veracross will insert new person records for the candidate’s sibling into the database from GTP unless an existing person record is found using the following criteria:

  • The existing person’s Veracross Legacy ID matches the GTP ID.
  • The data source is set to “GTP Sibling.”

The mapping checks against both normal person records and records that were previously merged.

Alternatively, the relationship between the sibling and the candidate is used to match sibling records. The sibling’s first name and last name and their gender must match the GTP sibling’s first and last name, and gender and the relationship to the candidate in Veracross is one of the following: “brother, sister, step brother, step-sister, half brother, half sister, brother-in-law, and sister-in-law.

If it does not find a match, a new person record is created. All fields on the person record are synced ONLY upon initial record creation. These fields have an import type of “insert only” in the following Candidate Sibling field import table.

Fields
The following table specifies all fields mapped from GTP to Veracross for candidate sibling person records.

GTP Field Veracross Person Field Import Type
application_id Legacy ID Insert Only
siblingnamefirst_0 First Name Insert Only
siblingnamemiddle_0 Middle Name Insert Only
siblingnamelast_0 Last Name Insert Only
siblingsex_0 Gender Insert Only
siblingnamefirst_1 First Name Insert Only
siblingnamemiddle_1 Middle Name Insert Only
siblingnamelast_1 Last Name Insert Only
siblingsex_1 Gender Insert Only
siblingnamefirst_2 First Name Insert Only
siblingnamemiddle_2 Middle Name Insert Only
siblingnamelast_2 Last Name Insert Only
siblingsex_2 Gender Insert Only
siblingnamefirst_3 First Name Insert Only
siblingnamemiddle_3 Middle Name Insert Only
siblingnamelast_3 Last Name Insert Only
siblingsex_3 Gender Insert Only

Candidate/Sibling Relationship Mapping

Veracross will insert new candidate sibling relationship records if the relationship does not exist. All sibling relationships get a brother/sister relationship to the candidate depending on the sibling’s gender. If the sibling has no gender, they get an “unspecified relative” relationship.

If the records do exist, but the relationship in Veracross is either “non-specified,” “unspecified relative,” or “other” Veracross will update the candidate/sibling relationship to brother or sister depending on the sibling’s gender.  

Current School 

Candidate Current School Mapping

Veracross will insert new school organization records for the candidate’s current school into the databases from GTP, unless it finds an existing school organization record using the following criteria:

  • An existing Veracross organization record exists where the Legacy ID is the GTP ID.
  • The data source is set to either “GTP Current School.”

Alternatively, Veracross will look for existing school organizations where the school name in GTP matches the organization name in Veracross and the GTP school address matches the organization’s “Address Line 1” and city in Veracross.

If no matching record is found, a new organization record will be inserted. All fields on the organization record are synced ONLY upon initial record creation. These fields have an import type of “insert only” in the following Candidate Current School field import table.

Fields
The following table specifies all fields mapped from GTP to Veracross for candidate current school organization records.

GTP Field Veracross Organization Field Import Type
application_id Legacy ID Insert Only
school_name Organization Name Insert Only
school_type Industry Insert Only
school_address1 Address 1 Insert Only
school_address2 Address 2 Insert Only
school_address3 Address 3 Insert Only
school_city City Insert Only
school_state State/Province Insert Only
school_zipcode Postal Code Insert Only
school_country Country Insert Only

Candidate Current School Relationship Mapping

Once an organization record is either found or created, a candidate receives the “current school” relationship with their current school. 

Fields
The following table specifies all fields mapped from GTP to Veracross for candidate current school relationship records.

GTP Field Veracross Organization Relationship Field Import Type
school_yearsattended Notes Insert Only

Other Admission Record Mapping

Candidate Admission Mapping

Veracross inserts the following fields from GTP onto the Person Admission record in Veracross:

GTP Field Veracross Person Field Import Type
year_applying_for Year Applying For Insert Only
year_applying_for Month Applying For Insert Only
grade_applying_for Grade Applying For Insert Only
residential_status Resident Status Applying For Insert Only

Candidate Test Scores Mapping

New test scores records are created from GTP to Veracross. Included test types are: ACT, ISEE, PSAT, SAT, SSAT, and TOEFL. In order for the test score data for each of these test types to be imported, the standardized test type record in Veracross must be enabled. Learn more about test type configuration in Veracross

All fields on the candidate test scores record are only populated upon initial record creation; they are not synced from GTP to Veracross after initial record creation. These fields have an import type of “insert only” in the following Candidate Test Scores field imports table.

Fields
The following table specifies all fields mapped from GTP to Veracross for person test scores records.

GTP Field Veracross Standardized Test Field Import Type
test_act Test Type Insert Only
test_act_datem / 1 / test_act_datey Test Date Insert Only
test_isee Test Type Insert Only
test_isee_datem / 1 / test_isee_datey Test Date Insert Only
test_psat Test Type Insert Only
test_psat_datem / 1 / test_psat_datey Test Date Insert Only
test_sat Test Type Insert Only
test_sat_datem / 1 / test_sat_datey Test Date Insert Only
test_ssat Test Type Insert Only
test_ssat_datem / 1 / test_ssat_datey Test Date Insert Only
test_toefl Test Type Insert Only
test_toefl_datem / 1 / test_toefl_datey Test Date Insert Only

Candidate Interests Mapping

Most GTP interest data maps to the interests notes field on the person interest record. Each unique field is labeled in the interest notes field according to the field in GTP (for example: hpw field maps to the interests notes field and is labeled as “hours per week” in Veracross).

Any new interests that do not exist in Veracross for this candidate will be inserted.

All fields on the candidate interest record are only populated upon initial record creation; they are not synced from GTP to Veracross after initial record creation. These fields have an import type of “insert only” in the following Candidate Interests field imports table.

Fields
The following table specifies all fields mapped from GTP to Veracross for person interest records.

GTP Field Veracross Person Interest Field Import Type
application_id Legacy ID Insert Only
activity_0 Interest Insert Only
activityyears_0 Years Experience Insert Only
activityinvolvement_0 Notes Insert Only
activityother_0 Notes Insert Only
hpw_0 Notes Insert Only
participate_0 Notes Insert Only
position_0 Notes Insert Only
activity_1 Interest Insert Only
activityyears_1 Years Experience Insert Only
activityinvolvement_1 Notes Insert Only
activityother_1 Notes Insert Only
hpw_1 Notes Insert Only
participate_1 Notes Insert Only
position_1 Notes Insert Only
activity_2 Interest Insert Only
activityyears_2 Years Experience Insert Only
activityinvolvement_2 Notes Insert Only
activityother_2 Notes Insert Only
hpw_2 Notes Insert Only
participate_2 Notes Insert Only
position_2 Notes Insert Only
activity_3 Interest Insert Only
activityyears_3 Years Experience Insert Only
activityinvolvement_3 Notes Insert Only
activityother_3 Notes Insert Only
hpw_3 Notes Insert Only
participate_3 Notes Insert Only
position_3 Notes Insert Only
activity_4 Interest Insert Only
activityyears_4 Years Experience Insert Only
activityinvolvement_4 Notes Insert Only
activityother_4 Notes Insert Only
hpw_4 Notes Insert Only
participate_4 Notes Insert Only
position_4 Notes Insert Only
activity_5 Interest Insert Only
activityyears_5 Years Experience Insert Only
activityinvolvement_5 Notes Insert Only
activityother_5 Notes Insert Only
hpw_5 Notes Insert Only
participate_5 Notes Insert Only
position_5 Notes Insert Only
activity_6 Interest Insert Only
activityyears_6 Years Experience Insert Only
activityinvolvement_6 Notes Insert Only
activityother_6 Notes Insert Only
hpw_6 Notes Insert Only
participate_6 Notes Insert Only
position_6 Notes Insert Only
activity_7 Interest Insert Only
activityyears_7 Years Experience Insert Only
activityinvolvement_7 Notes Insert Only
activityother_7 Notes Insert Only
hpw_7 Notes Insert Only
participate_7 Notes Insert Only
position_7 Notes Insert Only
activity_8 Interest Insert Only
activityyears_8 Years Experience Insert Only
activityinvolvement_8 Notes Insert Only
activityother_8 Notes Insert Only
hpw_8 Notes Insert Only
participate_8 Notes Insert Only
position_8 Notes Insert Only

Candidate Application Received Record Mapping

Data import will create an individual event record with the event type “application received” if it does not already exist in Veracross.

Fields
The following table specifies all fields mapped from GTP to Veracross for the individual event records.

GTP Field Veracross Person Field Import Type
year_applying_for Inquiry School Year Insert Only
grade_applying_for Grade Level Insert Only
submission_date Event Date Updated per import

Candidate Admission Checklist

When inserting candidate records, Veracross creates a set of Admission Checklist Items that apply to them. During the Gateway to Prep import, the system will mark as complete any checklist item specified as a Gateway To Prep checklist item (via the Gateway to Prep Mapping (see above)), setting the Completed Date to the GTP submission date. 

Fields
The following table specifies all fields mapped from GTP to Veracross for the person admission checklist item records.

GTP Field Veracross Admission Checklist Field Import Type
submission_date Completed Date Updated per Import

Candidate Financial Aid

Veracross will update the “requesting financial aid” field for a candidate if it is specified in GTP. This update only occurs if the requesting financial aid data was previously not specified in Veracross.

Fields
The following table specifies all fields mapped from GTP to Veracross for the person financial aid records.

GTP Field Veracross Financial Aid Field Import Type
financialaid Requesting Financial Aid Updated if blank*

* Note: the data import will only update this information if what exists in Veracross is “False,” i.e., not requesting Financial Aid, and what exists in GTP is “True,” i.e., the candidate is requesting Financial Aid.

Data Sync Log

Veracross will insert a record to the Admission History Log table every time the sync is run for an admissions candidate. This record will have an event type of “Gateway to Prep Sync,” and the system will store the raw information received from the Gateway to Prep import on the log record in the Formatted Data field.

Fields Not Imported

  • alienregnum
  • app_sex_identify
  • candidatedate
  • candidatesignature
  • candidatewaiver
  • citizenshipformscountry
  • citizenshipformsrequired
  • esignature
  • house1address1
  • house1address2
  • house1address3
  • house1city
  • house1country
  • house1homephone
  • house1state
  • house1zip
  • house2address1
  • house2address2
  • house2address3
  • house2city
  • house2country
  • house2homephone
  • house2state
  • house2zip
  • legacyname_0
  • legacyname_1
  • legacyname_2
  • legacyname_3
  • legacyrelationship_0
  • legacyrelationship_1
  • legacyrelationship_2
  • legacyrelationship_3
  • legacyrelationshipother_0
  • legacyrelationshipother_1
  • legacyrelationshipother_2
  • legacyrelationshipother_3
  • legacyschool_0
  • legacyschool_1
  • legacyschool_2
  • legacyschool_3
  • legacyyear_0
  • legacyyear_1
  • legacyyear_2
  • legacyyear_3
  • linkinfo
  • linkinfo_1
  • multimed_category
  • multimed_category_1
  • multimed_link
  • multimed_link_1
  • na_box_b
  • na_box_d
  • na_box_h
  • oschool_date1_0
  • oschool_date1_1
  • oschool_date1_2
  • oschool_date2_0
  • oschool_date2_1
  • oschool_date2_2
  • oschool_location_0
  • oschool_location_1
  • oschool_location_2
  • oschool_name_0
  • oschool_name_1
  • oschool_name_2
  • parent1college
  • parent1degreereceived
  • parent1fax
  • parent1graddegreereceived
  • parent1gradschool
  • parent1secondaryschool
  • parent1waiver
  • parent1waiverdate
  • parent1waiversignature
  • parent2college
  • parent2degreereceived
  • parent2fax
  • parent2graddegreereceived
  • parent2gradschool
  • parent2secondaryschool
  • parent2waiver
  • parent2waiverdate
  • parent2waiversignature
  • parent3college
  • parent3degreereceived
  • parent3fax
  • parent3graddegreereceived
  • parent3gradschool
  • parent3secondaryschool
  • parent4college
  • parent4degreereceived
  • parent4fax
  • parent4graddegreereceived
  • parent4gradschool
  • parent4secondaryschool
  • parentmaritalstatus
  • printpreviewed
  • race_african_amer_other
  • race_african_other
  • race_asian_amer_other
  • race_asian_other
  • race_hawaiian_other
  • race_hispanic_other
  • race_mexican_other
  • race_mideastern_other
  • race_other_other
  • race_puertorican_other
  • race_white_other
  • sbage_0
  • sbage_1
  • sbage_2
  • sbage_3
  • school_endsaftergrade
  • siblingcollege_0
  • siblingcollege_1
  • siblingcollege_2
  • siblingcollege_3
  • tribalaffiliation
  • tribalenrolled
  • txtactivities
  • txtinfo
  • uploadaddtlinfo
  • visatype
print

Related Articles