University System of Georgia
Use these template guides below as you build out imports in your instance. These guides below correspond to templates that can be found in the Global Template section of the Imports + Exports feature. If there are any additional steps you need to follow to complete the template, they will be noted in the notes column below.
GA Match - Request Information
New database
23 rows
| Name | Calculated Field? | Element451 Slug Name | Notes | Row |
|---|---|---|---|---|
| First Name | No | user-first-name | 1 | |
| Last Name | No | user-last-name | 2 | |
| Home Address - Street 1 | No | user-addresses-home-street1 | 3 | |
| Home Address - City | No | user-addresses-home-city | 4 | |
| Home Address - State | No | user-addresses-home-state | No additional action needed. Transformation is expecting Alpha 2 format. Ex. GA, MO, NC, etc.. | 5 |
| Home Address - Zip Code | No | user-addresses-home-zip | 6 | |
| Phone Cell - Number | No | user-phone-cell-number | 7 | |
| High School - Ceeb | No | user-education-highschools-ceeb | 8 | |
| High School - Name | No | user-education-highschools-name | 9 | |
| No | user-email-address | 10 | ||
| Date of Inquiry | No | 11 | ||
| SSN | No | user-ssn | 12 | |
| GTID (Georgia Test Identifier) | No | user-identities-georgiatestingid | 13 | |
| Date of Birth | No | user-dob | No additional action needed. Transformation is expecting date to be in mdY format. Ex. 01012025. | 14 |
| Future Field 4 | No | 15 | ||
| Future Field 5 | No | 16 | ||
| Intended Term | Yes | user-education-term | Calculated Field. Required next steps: You will want to hard code the intended term you want the students to have. The formula needs to have the GUID found in your terms data source around quotations. Generic Example: "subdom.terms.1234" | 17 |
| Intended Student Type | Yes | user-education-student-type | Calculated Field. Required next steps: You will want to hard code the intended student type you want the students to have. The formula needs to have the value found in your student type data source around quotations. Generic Example: "F" This is assuming our data source is storing the single character code as the value and the data source stores Freshman as F. | 18 |
| Date of Inquiry Date | Yes | user-milestones-prospect-date | Calculated Field. No additional actions needed. This formula takes the date the import is ran and adds four hours to adjust for the timezone difference. DATE_ADD("hour", 4, DATE_READ(DATE_DEFAULT("m/d/Y"), "m/d/Y")) | 19 |
| Date of Inquiry Term | Yes | user-milestones-prospect-term | Calculated Field. Required next steps: You will want to hard code the intended term you want the students to have. The formula needs to have the GUID found in your terms data source around quotations. Generic Example: "subdom.terms.1234" | 20 |
| Source Code | Yes | user-sources-source-code | Calculated Field. Required next steps: You will want to hard code the source code you want the students to have. The formula needs to have the Guid/Taxonomy Code found under Contacts>Categories>Source Code in quotations. Screenshot 2025-03-10 at 2.36.36 PM.png Generic Example: "subdom.taxonomy.12345678" | 21 |
| Source Segment | Yes | user-sources-source-code-segment | Calculated Field. Required next steps: You will want to hard code the source segment code you want the students to have. The formula needs to have the Guid/Taxonomy Code found under Contacts>Categories>Source Code>Whatever Source has the Segments in quotations. Screenshot 2025-03-10 at 2.38.15 PM.png Generic Example: "subdom.taxonomy.12345678" | 22 |
| Source Date | Yes | user-sources-source-code-date | Calculated Field. No additional actions needed. This formula takes the date the import is ran and adds four hours to adjust for the timezone difference. DATE_ADD("hour", 4, DATE_READ(DATE_DEFAULT("m/d/Y"), "m/d/Y")) | 23 |
GA Match - Claim Your Spot
New database
37 rows
| Name | Calculated Field? | Element451 Slug Name | Notes | Row |
|---|---|---|---|---|
| SSN | No | user-ssn | 1 | |
| First Name | No | user-first-name | 2 | |
| Last Name | No | user-last-name | 3 | |
| Date of Birth | No | user-dob | No additional action needed. Transformation is expecting date to be in mdY format. Ex. 01012025. | 4 |
| Home Address - Street 1 | No | user-addresses-home-street1 | 5 | |
| Home Address - City | No | user-addresses-home-city | 6 | |
| Home Address - State | No | user-addresses-home-state | No additional action needed. Transformation is expecting Alpha 2 format. Ex. GA, MO, NC, etc.. | 7 |
| Home Address - Zip Code | No | user-addresses-home-zip | 8 | |
| Phone Cell - Number | No | user-phone-cell-number | 9 | |
| High School - Ceeb | No | user-education-highschools-ceeb | 10 | |
| High School - Name | No | user-education-highschools-name | 11 | |
| No | user-email-address | 12 | ||
| SAT Composite Score | No | user-unofficial-tests-nsat-composite-score | 13 | |
| SAT Test Date | No | user-unofficial-tests-nsat-date | No additional action needed. Transformation is expecting date to be in mdY format. Ex. 01012025. | 14 |
| SAT Reading | No | user-unofficial-tests-nsat-reading-score | 15 | |
| SAT Writing | No | user-unofficial-tests-nsat-writing-scores | 16 | |
| SAT Mathmatics | No | user-unofficial-tests-nsat-math-score | 17 | |
| ACT Composite Score | No | user-unofficial-tests-act-composite-score | 18 | |
| ACT Test Date | No | user-unofficial-tests-act-date | No additional action needed. Transformation is expecting date to be in mdY format. Ex. 01012025. | 19 |
| ACT English | No | user-unofficial-tests-act-english-score | 20 | |
| ACT Reading | No | user-unofficial-tests-act-reading-score | 21 | |
| ACT Mathmatics | No | user-unofficial-tests-act-math-score | 22 | |
| ACT Science | No | user-unofficial-tests-act-science-score | 23 | |
| Date of Inquiry | No | 24 | ||
| GTID (Georgia Test Identifier) | No | user-identities-georgiatestingid | 25 | |
| Unverified HOPE GPA | No | user-education-highschools-gpa | 26 | |
| Future Field 3 | No | 27 | ||
| Future Field 4 | No | 28 | ||
| Future Field 5 | No | 29 | ||
| Intended Term | Yes | user-education-term | Calculated Field. Required next steps: You will want to hard code the intended term you want the students to have. The formula needs to have the GUID found in your terms data source around quotations. Generic Example: "subdom.terms.1234" | 30 |
| Intended Student Type | Yes | user-education-student-type | Calculated Field. Required next steps: You will want to hard code the intended student type you want the students to have. The formula needs to have the value found in your student type data source around quotations. Generic Example: "F" This is assuming our data source is storing the single character code as the value and the data source stores Freshman as F. | 31 |
| Date of Inquiry Date | Yes | user-milestones-prospect-date | Calculated Field. No additional actions needed. This formula takes the date the import is ran and adds four hours to adjust for the timezone difference. DATE_ADD("hour", 4, DATE_READ(DATE_DEFAULT("m/d/Y"), "m/d/Y")) | 32 |
| Date of Inquiry Term | Yes | user-milestones-prospect-term | Calculated Field. Required next steps: You will want to hard code the intended term you want the students to have. The formula needs to have the GUID found in your terms data source around quotations. Generic Example: "subdom.terms.1234" | 33 |
| GPA Official? | Yes | user-education-highschools-gpa_official | Calculated Field. No additional steps needed. It sets the GPA to unofficial. "false" | 34 |
| Source Code | Yes | user-sources-source-code | Calculated Field. Required next steps: You will want to hard code the source code you want the students to have. The formula needs to have the Guid/Taxonomy Code found under Contacts>Categories>Source Code in quotations. Screenshot 2025-03-10 at 2.36.36 PM.png Generic Example: "subdom.taxonomy.12345678" | 35 |
| Source Segment | Yes | user-sources-source-code-segment | Calculated Field. Required next steps: You will want to hard code the source segment code you want the students to have. The formula needs to have the Guid/Taxonomy Code found under Contacts>Categories>Source Code>Whatever Source has the Segments in quotations. Screenshot 2025-03-10 at 2.38.15 PM.png Generic Example: "subdom.taxonomy.12345678" | 36 |
| Source Date | Yes | user-sources-source-code-date | Calculated Field. No additional actions needed. This formula takes the date the import is ran and adds four hours to adjust for the timezone difference. DATE_ADD("hour", 4, DATE_READ(DATE_DEFAULT("m/d/Y"), "m/d/Y")) | 37 |
Was this page helpful?