Template Name: CommonAppFY_2023_2024 Last Updated Date: 13/08/2024(dd/MM/yyyy) Updates for Anthology Reach 2024.3 release : ------------------------------------------------------------------------------------ Field Mappings: 1.Template Category Column Added for all the field Mappings 2. Mapping Type updated to Configuration for Row 268,269,270,271(see CommonAppFY_2023_2024_FieldMappings_ChangeLog_2024.2.xlsx file to see the newly updated values(marked in orange)) Data Mappings: 1. Template Category Column Added for all the Data Mappings ------------------------------------------------------------------------------------- Updates for Anthology Reach 4.3 release : ------------------------------------------------------------------------------------ Field Mappings: 1.New Import Statistics Batch Size mapping is added(See the CommonAppFY_2023_2024_FieldMappings_ChangeLog_4.3.xlsx file to add the mapping). ------------------------------------------------------------------------------------- Updates for Anthology Reach 4.2 release: ------------------------------------------------------------------------------------ Field Mappings: 1. Updated template type from “CommonAppFY_2021_2022” to “CommonAppFY_2023_2024”. 2. External field names updated for some Existing mappings(See ChangeLog file for the list of updated mappings). 3. New placeholder mappings have been added with Inactive status for the Fields which do not exist ootb in Reach. Data Mappings: 1. Updated template type from “CommonAppFY_2021_2022” to “CommonAppFY_2023_2024”. 2. New data mappings added for the required fields. ------------------------------------------------------------------------------------------------------- **********Note:please check "CommonAppFY_2023_2024_DataMappings_ChangeLog.xlsx" or "CommonAppFY_2023_2024_FieldMappings_Changelog_4.2.xlsx" for more details on the updates of respective mappings**************** ------------------------------------------------------------------------------------------------------- The information below is intended to assist in the initial configuration of the Import Template. Below you will find a listing of rows for the Field and Data Mappings that we recommend reviewing for a specific environment prior to importing. Field Mappings ---------------------------------- Row 8: Parameter contains the default value of Student for the Contact Type Contact for Record Type of contact. Row 9: Parameter contains the default value of Import for the Created Source Contact for Record Type of contact. Row 25: Parameter contains the default value of Official Test Scores for the Source Category for Record Type of contact. Row 26: Parameter contains the default value of External Upload for the Source Method Contact for Record Type of contact. Row 39: Parameter contains the default value of Primary for the Address Type Address1 for Record Type of Address 1. Row 42: Parameter contains the default value of Import for the Created Source Address1 for Record Type of Address 1. Row 43: Parameter contains the default value of Primary for the Mail Type for Record Type of Address 1. Row 44: Parameter contains the default value of contact for the parentidtype for Record Type of Address 1. Row 53: Parameter contains the default value of CommonAppDefaultApplicationDefinitionVersion for the Application Definition Version for Record Type of ApplicationRegistration 1. Row 55: Parameter contains the default value of In-Progress for the Application Registration Status for Record Type of ApplicationRegistration 1. Row 57: Parameter contains the default value of Yes for the Application Submitted for Record Type of ApplicationRegistration 1. Row 60: Parameter contains the default value of Import for the Created Source ApplicationRegistration1 for Record Type of ApplicationRegistration 1. Row 68: Parameter contains the default value of In-Progress for the Application Status for Record Type of Application 1. Row 69: Parameter contains the default value of Import for the Created Source for Record Type of Application 1. Row 70: Parameter contains the default value of CommonAppDefaultApplicationProgram for the Program for Record Type of Application 1. Row 71: Parameter contains the default value of CommonAppDefaultApplicationProgramVersion for the Program Version for Record Type of Application 1. Row 75: Parameter contains the default value of mshied_areaofinterest for the EntityType-AreaOfInterest for Record Type of AreaofInterest 1. Row 82: Parameter contains the default value of Import for the Source Of Record Activity1 for Record Type of ExtraCurricularParticipant 1. Row 89: Parameter contains the default value of Import for the Source Of Record Activity10 for Record Type of ExtraCurricularParticipant 10. Row 96: Parameter contains the default value of Import for the Source Of Record Activity2 for Record Type of ExtraCurricularParticipant 2. Row 103: Parameter contains the default value of Import for the Source Of Record Activity3 for Record Type of ExtraCurricularParticipant 3. Row 110: Parameter contains the default value of Import for the Source Of Record Activity4 for Record Type of ExtraCurricularParticipant 4. Row 117: Parameter contains the default value of Import for the Source Of Record Activity5 for Record Type of ExtraCurricularParticipant 5. Row 124: Parameter contains the default value of Import for the Source Of Record Activity6 for Record Type of ExtraCurricularParticipant 6. Row 131: Parameter contains the default value of Import for the Source Of Record Activity7 for Record Type of ExtraCurricularParticipant 7. Row 138: Parameter contains the default value of Import for the Source Of Record Activity8 for Record Type of ExtraCurricularParticipant 8. Row 145: Parameter contains the default value of Import for the Source Of Record Activity9 for Record Type of ExtraCurricularParticipant 9. Row 146: Parameter contains the default value of Legal Guardian for the Contact Type LegalGuardian1 for Record Type of LegalGuardian 1. Row 147: Parameter contains the default value of Import for the Created Source LegalGuardian1 for Record Type of LegalGuardian 1. Row 153: Parameter contains the default value of Official Test Scores for the Source Category LegalGuardian1 for Record Type of LegalGuardian 1. Row 154: Parameter contains the default value of External Upload for the Source Method LegalGuardian1 for Record Type of LegalGuardian 1. Row 158: Parameter contains the default value of Import for the Created Source LegalGuardian1 for Record Type of LegalGuardian.1.Experience.1. Row 159: Parameter contains the default value of Other for the ExperienceType LegalGuardian1 for Record Type of LegalGuardian.1.Experience.1. Row 162: Parameter contains the default value of Parent for the Contact Type Parent1 for Record Type of Parent 1. Row 163: Parameter contains the default value of Import for the Created Source Parent1 for Record Type of Parent 1. Row 170: Parameter contains the default value of Official Test Scores for the Source Category Parent1 for Record Type of Parent 1. Row 171: Parameter contains the default value of External Upload for the Source Method Parent1 for Record Type of Parent 1. Row 175: Parameter contains the default value of Import for the Created Source Parent1 for Record Type of Parent.1.Experience.1. Row 176: Parameter contains the default value of Other for the ExperienceType Parent1 for Record Type of Parent.1.Experience.1. Row 179: Parameter contains the default value of Parent for the Contact Type Parent2 for Record Type of Parent 2. Row 180: Parameter contains the default value of Import for the Created Source Parent2 for Record Type of Parent 2. Row 187: Parameter contains the default value of Official Test Scores for the Source Category Parent2 for Record Type of Parent 2. Row 188: Parameter contains the default value of External Upload for the Source Method Parent2 for Record Type of Parent 2. Row 192: Parameter contains the default value of Import for the Created Source Parent2 for Record Type of Parent.2.Experience.1. Row 193: Parameter contains the default value of Other for the ExperienceType Parent2 for Record Type of Parent.2.Experience.1. Row 198: Parameter contains the default value of Import for the Created Source PreviousEducation1 for Record Type of PreviousEducation.1. Row 201: Parameter contains the default value of CommonAppDefaultEducationLevel for the Grade Level for Record Type of PreviousEducation.1. Row 203: Parameter contains the default value of Sibling for the Contact Type Sibling1 for Record Type of Sibling 1. Row 204: Parameter contains the default value of Import for the Created Source Sibling1 for Record Type of Sibling 1. Row 207: Parameter contains the default value of Official Test Scores for the Source Category Sibling1 for Record Type of Sibling 1. Row 208: Parameter contains the default value of External Upload for the Source Method for Record Type of Sibling 1. Row 209: Parameter contains the default value of Sibling for the Contact Type Sibling2 for Record Type of Sibling 2. Row 210: Parameter contains the default value of Import for the Created Source Sibling2 for Record Type of Sibling 2. Row 213: Parameter contains the default value of Official Test Scores for the Source Category Sibling2 for Record Type of Sibling 2. Row 214: Parameter contains the default value of External Upload for the Source Method Sibling2 for Record Type of Sibling 2. Row 215: Parameter contains the default value of Sibling for the Contact Type Sibling3 for Record Type of Sibling 3. Row 216: Parameter contains the default value of Import for the Created Source Sibling3 for Record Type of Sibling 3. Row 219: Parameter contains the default value of Official Test Scores for the Source Category Sibling3 for Record Type of Sibling 3. Row 220: Parameter contains the default value of External Upload for the Source Method Sibling3 for Record Type of Sibling 3. Row 221: Parameter contains the default value of Sibling for the Contact Type Sibling4 for Record Type of Sibling 4. Row 222: Parameter contains the default value of Import for the Created Source Sibling4 for Record Type of Sibling 4. Row 225: Parameter contains the default value of Official Test Scores for the Source Category Sibling4 for Record Type of Sibling 4. Row 226: Parameter contains the default value of External Upload for the Source Method Sibling4 for Record Type of Sibling 4. Row 227: Parameter contains the default value of Sibling for the Contact Type Sibling5 for Record Type of Sibling 5. Row 228: Parameter contains the default value of Import for the Created Source Sibling5 for Record Type of Sibling 5. Row 231: Parameter contains the default value of Official Test Scores for the Source Category Sibling5 for Record Type of Sibling 5. Row 232: Parameter contains the default value of External Upload for the Source Method Sibling5 for Record Type of Sibling 5. Row 237: Parameter contains the default value of Import for the ACTScores-Created Source TestScore for Record Type of TestScore 1. Row 238: Parameter contains the default value of Self - Reported for the ACTScores-Test Source for Record Type of TestScore 1. Row 239: Parameter contains the default value of ACT for the ACTScores-Test Type for Record Type of TestScore 1. Row 244: Parameter contains the default value of Import for the SATRW-Created Source TestScore for Record Type of TestScore2. Row 245: Parameter contains the default value of Self - Reported for the SATRW-Test Source for Record Type of TestScore 2. Row 246: Parameter contains the default value of SAT for the SATRW-Test Type for Record Type of TestScore 2. Row 251: Parameter contains the default value of Import for the SATMATH-Created Source TestScore for Record Type of TestScore 3. Row 252: Parameter contains the default value of Self - Reported for the SATMATH-Test Source for Record Type of TestScore 3. Row 253: Parameter contains the default value of SAT for the SATMATH-Test Type for Record Type of TestScore 3. Row 258: Parameter contains the default value of Import for the TOEFL iBT Total-Created Source for Record Type of TestScore 4. Row 259: Parameter contains the default value of Self - Reported for the TOEFL iBT Total-Test Source for Record Type of TestScore 4. Row 260: Parameter contains the default value of TOEFL for the TOEFL iBT Total-Test Type for Record Type of TestScore 4. Row 265: Parameter contains the default value of Import for the DuolingoTotal-Created Source for Record Type of TestScore 5. Row 266: Parameter contains the default value of Self - Reported for the DuolingoTotal-Test Source for Record Type of TestScore 5. Row 267: Parameter contains the default value of Duolingo for the DuolingoTotal-Test Type for Record Type of TestScore 5. TEMPLATE SETTINGS MAPPINGS ---------------------------------------------------------- Row 268: Internal Option value contains the default value of 0 which will not display the enhanced import statistics in the log. Update to a value of 1 to enable. Row 269: Internal Option value contains the default value of 1 for Import Row Batch Size which sets the system to select one row at a time from the import batch to process Row 270: Internal Option Value contains the default value of 100 which sets the system to work with 100 records per batch from the file. DATA MAPPINGS ------------------------------------------------------------ Dataset mappings are provided for the following dataset names. External Option Display and External Option Value match to the values provided in the source layout. CommonAppFYGenderIdentity CommonAppFYPronouns Ethnic Group Race VisaType USArmedForceStatus MilitaryBranch MaritalStatus PermanentHome ContinueInCollege ActivityType Occupation IsDeceased GPAScale CommonAppFYCitizenshipStatus Citizenship Gender FerpaWaiver