Encoura Template Guide
Encoura Standard Export Layout (Import into Element451)#
Encoura resources can be found here: https://help.encoura.org/article/Data-Center/encoura-standard-export-layout (opens in a new tab)
New database
110 rows
| Name | Element Notes | Element451 Slug | Row |
|---|---|---|---|
| State Province | 11 | ||
| ACT Major Code 2 | 73 | ||
| Tag 3 | 108 | ||
| College Activity 1 | 54 | ||
| Affinity Primary Address | 101 | ||
| Plans after HS 2 | 40 | ||
| International Postal Code | 20 | ||
| High School Name | Scoped to High School School Type | user-education-schools-name-* | 37 |
| Academic Interest 4 | 71 | ||
| College Activity 4 | 57 | ||
| CIP Code 1 | 76 | ||
| HS Course Track 1 | 46 | ||
| Zip Code | Scoped to Home Address Type | user-addresses-zip-* | 13 |
| Parent/Guardian 2 First Name | Scoped to Position 2 | user-family-first-name-* | 96 |
| Smart Plus Score | 83 | ||
| Carrier Route | 21 | ||
| College Activity 8 | 61 | ||
| Academic Interest 1 | 68 | ||
| College Activity 13 | 66 | ||
| State Abbreviation | Scoped to Home Address Type | user-addresses-state-* | 12 |
| Plans after HS 4 | 42 | ||
| Plans after HS 3 | 41 | ||
| Graduation Year | 34 | ||
| College Activity 6 | 59 | ||
| Order Number | 105 | ||
| Country | 15 | ||
| OOS Travel Score | 85 | ||
| Address 2 | Scoped to Home Address Type | user-addresses-street2-* | 9 |
| First Generation | 31 | ||
| Country Code | 16 | ||
| ACT Major Code 1 | 72 | ||
| Parent/Guardian 1 First Name | Scoped to Position 1 | user-family-first-name-* | 93 |
| Denominational College 2 | 45 | ||
| HS Course Track 6 | 51 | ||
| Birth Date | 27 | ||
| Check Digit | 22 | ||
| user-email-address | 24 | ||
| Parent/Guardian 2 Last Name | Scoped to Position 2 | user-family-last-name-* | 97 |
| Record Type | 103 | ||
| ZIP 4 | 14 | ||
| College Activity 12 | 65 | ||
| ACT Major Code 4 | 75 | ||
| Denominational College 1 | 44 | ||
| College Activity 14 | 67 | ||
| Academic Interest 2 | 69 | ||
| College Activity 3 | 56 | ||
| Opportunity Score | 84 | ||
| Campus Environment | 43 | ||
| Search Name | 104 | ||
| Student PIN | 3 | ||
| Address 1 | Scoped to Home Address Type | user-addresses-street1-* | 8 |
| College Activity 7 | 60 | ||
| 200mi Travel Score | 86 | ||
| Career Interest 1 | 80 | ||
| Mindset | 87 | ||
| Affinity Unique ID | 99 | ||
| HS Course Track 4 | 49 | ||
| Race Details | 30 | ||
| HS course Track 8 | 53 | ||
| Class Rank | 33 | ||
| County Name | Scoped to Home Address Type | user-addresses-county-* | 19 |
| Encoura ID | user-identities-encouraid | 2 | |
| Middle Name | user-middle-name | 5 | |
| Career Interest 3 | 82 | ||
| First Name | user-first-name | 4 | |
| College Activity 5 | 58 | ||
| HS Course Track 2 | 47 | ||
| Calculation: HS Grad Date - Default to June 1 | Encoura sends just a year and Element451 stores graduation as a full date. This formula takes the year and adds June 1st to it. DATE_READ(CONCAT("06/01/",[C34]),"m/d/Y") | user-education-schools-graduate_date-* | 110 |
| College Activity 2 | 55 | ||
| HS Course Track 3 | 48 | ||
| HS Course Track 7 | 52 | ||
| CIP Code 2 | 77 | ||
| Parent/Guardian 1 Last Name | Scoped to Position 1 | user-family-last-name-* | 94 |
| ACT Major Code 3 | 74 | ||
| Data Source | 1 | ||
| AOS Schedule Visit | 90 | ||
| Gender | 28 | ||
| CIP Code 3 | 78 | ||
| Race Ethnicity | 29 | ||
| Mobile Phone | user-phone-cell-number | 26 | |
| High School Type | 38 | ||
| Calculation: Date Of Birth | Encoura sends DOB with no delimiters. This formula adds a leading 0 if needed to have the date properly interpreted. DATE_READ(PAD([C27], "0", 8),"mdY") | user-dob | 109 |
| Tag 1 | 106 | ||
| Tag 2 | 107 | ||
| Affinity Last Name | 100 | ||
| HS Course Track 5 | 50 | ||
| Delivery Point | 23 | ||
| High School MDR | 36 | ||
| Career Interest 2 | 81 | ||
| College Activity 10 | 63 | ||
| County Code | 18 | ||
| Suffix | 7 | ||
| Parent/Guardian 1 Email | Scoped to Position 1 | user-family-email-* | 95 |
| AOS Application | 89 | ||
| College Activity 11 | 64 | ||
| AOS Is Updated | 92 | ||
| Affinity 5-digit ZIP code | 102 | ||
| Parent/Guardian 2 Email | Scoped to Position 2 | user-family-email-* | 98 |
| CIP Code 4 | 79 | ||
| College Activity 9 | 62 | ||
| Academic Interest 3 | 70 | ||
| Country Code Alpha | Scoped to Home Address Type | user-addresses-country-* | 17 |
| High School Code | Scoped to High School School Type | user-education-schools-ceeb-* | 35 |
| Mobile Phone Country Code | user-phone-cell-country-code | 25 | |
| Last Name | user-last-name | 6 | |
| Visited Campus | 91 | ||
| GPA | Scoped to High School School Type | user-education-schools-gpa-* | 32 |
| City | Scoped to Home Address Type | user-addresses-city-* | 10 |
| Plans after HS 1 | 39 | ||
| AOS Inquiry | 88 |
Was this page helpful?