| Inquiry_Id |
No |
Key ID Field |
"1234" |
If one row has this column populated, all rows must have this column populated |
| Academic_Year |
Yes |
Datasource Data |
"20212022" |
|
| Inquiry_Last_Name |
Yes |
Text |
"Smith" |
|
| Inquiry_First_Name |
Yes |
Text |
"John" |
|
| Inquiry_Middle_Name |
No |
Text |
"Kipp" |
|
| Inquiry_Preferred_Name |
No |
Text |
"Johnny" |
|
| Birthdate |
Yes |
Date |
"2000/01/01" |
|
| Birthplace |
No |
Text |
"Anytown, USA" |
|
| Sex |
Yes |
Datasource data |
"Male" |
This field is named "Sex" in the import but displays as "Gender" in the database. |
| Personal_Pronoun_Id |
No |
Identifier |
"1" |
Create a DAT query to identify the id values. |
| Lookup_Personal_Pronoun |
No |
Lookup |
"He" |
The lookup will check across subject, object, and possessive pronoun values to find a match. |
| Citizen_Of |
No |
Datasource data |
"Canada" |
|
| Native_Lang |
No |
Datasource data |
"English" |
|
| Ethnic_Group |
No |
Datasource data |
"Asian" |
|
| Phone |
No |
Text |
"123-456-7890" |
|
| Email |
No |
Text |
"Jsmith@gmail.com" |
|
| Current_School |
No |
Datasource data |
"Lincoln High School" |
|
| |
|
|
|
|
| Inquiry_Source |
No |
Datasource data |
"Facebook" |
|
| |
|
|
|
|
| Current_Parish |
No |
Datasource data |
"St Marys" |
|
| Legacy_Code |
No |
Datasource data |
"Parent" |
|
| Day_Or_Boarding |
No |
Datasource data |
"Day" |
|
| |
|
|
"Boarding" |
|
| |
|
|
"Virtual" |
|
| ESL_Yes_or_No |
No |
Datasource data |
"Y" or "N" |
|
| International_Yes_or_No |
Yes |
Datasource data |
"Y" or "N" |
|
| Financial_Aid_Yes_Or_No |
No |
Datasource data |
"Y" or "N" |
|
| Religion |
No |
Datasource data |
"Catholic" |
|
| Additional_Testing_Yes_No |
No |
Datasource data |
"Y" or "N" |
|
| Academic_Support_Yes_No |
No |
Datasource data |
"Y" or "N" |
|
| Inquiry_Suffix |
No |
Text |
"Jr." |
|
| preferred_student_id |
No |
Integer |
"12345" |
|
| campus |
No |
Datasource data |
"Main" |
|
| applying_grade_level_id |
Yes, if Applying_For_Grade not populated |
Identifier |
"2" |
See Grade Level for more info |
| applying_for_grade |
Yes, if Applying_Grade_Level_ID not populated |
Lookup |
"K" |
|
| current_grade_level_id |
No |
Identifier |
"1" |
|
| current_grade |
No |
Lookup |
"PK" |
|
| primary_household_id |
Yes |
Identifier |
"12345" |
Connects the inquiry record to an already existing household as their Primary Parent household.
For adult inquiries, this household will represent inquiries themselves (their address, contact information) as opposed to their parents. |
| primary_household_relationship |
Yes |
Datasource Data |
"Parent", "Self" |
Only the two sample values are permitted. |
| secondary_household_id |
No |
Identifier |
"12345" |
Connects the inquiry record to an already existing household as their Secondary Parent household. |
| secondary_household_relationship |
Yes, if the secondary household is specified |
Datasource Data |
"Parent", "Grandparent", "Self" |
Only the three sample values are permitted. |
| billing_household_id |
Yes |
Identifier |
"12345" |
Connects the inquiry record to an already existing household as their Billing household.
Note: The billing household id must match primary or secondary household id |
| Action1_Description |
No |
Lookup |
"Inquiry" |
|
| Action1_Type_Id |
No |
Lookup |
"12" |
|
| Action1_Academic_Year |
Yes, if Action1_Description or Action1_Type_ID are entered |
Datasource Data |
"20212022" |
|
| Action1_Date |
Yes, if Action1_Description or Action1_Type_ID are entered |
Date |
"2020/01/24" |
|
| Action1_Applying_Grade_Level_Id |
Yes, if Action1_Description or Action1_Type_ID are entered and Action1_Applying_For_Grade is blank. |
Identifier |
"1" |
|
| Action1_Applying_For_Grade |
Yes, if Action1_Description or Action1_Type_ID are entered and Action1_Applying_Grade_Level_Id is blank. |
Datasource Data |
"PK" |
|
| Action1_Comment |
No |
Text |
"Contacted via phone" |
|