Overview
This document details the Microsoft Word merge fields that can be included in Admissions (ADMP) letter templates. This includes optional Verification Form (VER) and Enrollment Deposit (EDR) letter templates.
Contents
ADMP Merge Fields
The following merge fields are available in all letters in the ADMP Administrative Function.
| New or Changed | MS Word Merge Field | Example of what prints |
|---|---|---|
|
AcadCareer |
"UENG" |
|
|
AcadCareerXL |
"Undergraduate Engineering" |
|
|
AcadCareerXS |
"Ugrad Engr" |
|
|
StdntCarNbr |
"0" |
|
|
AdmApplNbr |
"00446406" |
|
|
ApplDataInst |
"UMICH" |
|
|
ApplDataInstDE |
"University of Michigan" |
|
|
ApplDataInstDS |
"U of Mich" |
|
|
AdmApplCtr |
"UGA" |
|
|
AdmApplCtrXL |
"Undergraduate Admissions" |
|
|
AdmApplCtrXS |
"Ugrad Adm" |
|
|
AdmitType |
"1" |
|
|
AdmitTypeDE |
"New Freshman" |
|
|
AdmitTypeDS |
"Freshman" |
|
|
FinAidInterest |
"No" |
|
|
HousingInterest |
" " |
|
|
HousingInterestXL |
" " |
|
|
HousingInterestXS |
" " |
|
|
ApplFeeStatus |
"REC" |
|
|
ApplFeeStatusXL |
"Received" |
|
|
ApplFeeStatusXS |
"Received" |
|
|
ApplFeeDT |
"January 15, 2010" |
|
|
AcademicLevel |
"11" |
|
|
AcademicLevelXL |
"Freshman" |
|
|
AcademicLevelXS |
"Freshman" |
|
|
AdmApplMethod |
"HRD" |
|
|
AdmApplMethodXL |
"Hard Copy" |
|
|
ExtOrgDE (Last School Attended) |
"Newton North High School" |
|
|
ExtOrgCity |
"Newtonville" |
|
|
ExtOrgState |
"MA" |
|
|
RecruitID |
" " |
|
|
RecruitIDName |
" " |
|
|
RecruitIDNamePrefix |
" " |
|
|
RecruitIDNameSuffix |
" " |
|
|
RecruitIDNameResult |
" " |
|
|
RecruitIDFirstName |
" " |
|
|
RecruitIDMiddleName |
" " |
|
|
RecruitIDLastName |
" " |
|
|
ApplProgNbr1 |
"0" |
|
|
ApplProgEffDT1 |
"March 1, 2010" |
|
|
ApplProgEffSEQ1 |
"1" |
|
|
ApplProgInst1 |
"UMICH" |
|
|
ApplProgInstDE1 |
"University of Michigan" |
|
|
ApplProgInstDS1 |
"U of Mich" |
|
|
AcadProg1 |
"00007" |
|
|
AcadProgDE1 |
"Engineering UG Degree" |
|
|
AcadProgDS1 |
"UG Engin" |
|
|
ProgStatus1 |
"AC" |
|
|
ProgStatusXL1 |
"Active in Program" |
|
|
ProgStatusXS1 |
"Active" |
|
|
ProgAction1 |
"MATR" |
|
|
ProgActionDE1 |
"Matriculation" |
|
|
ProgActionDS1 |
"Matriculat" |
|
|
ActionDT1 |
"October 2, 2010" |
|
|
ProgReason1 |
" " |
|
|
ProgReasonDE1 |
" " |
|
|
ProgReasonDS1 |
" " |
|
|
AdmitTerm1 |
"1860" |
|
|
AdmitTermDE1 |
"Fall 2011" |
|
|
AdmitTermDS1 |
"FA 2011" |
|
|
Campus1 |
"A" |
|
|
CampusDE1 |
"Ann Arbor Campus" |
|
|
CampusDS1 |
"Ann Arbor" |
|
|
AcadProgDual1 |
" " |
|
|
AcadProgDualDE1 |
" " |
|
|
AcadProgDualDS1 |
" " |
|
|
JointProgAppr1 |
"N" |
|
|
AcadPlan11 |
"2900" |
|
|
AcadPlanDE11 |
"Engineering: First Year" |
|
|
AcadPlanDS11 |
"Eng-1st Yr" |
|
|
AcadPlanTransDE |
"Engineering: First Year" |
|
|
AcadSubPlan111 |
" " |
|
|
AcadSubPlanDE111 |
" " |
|
|
AcadSubPlanDS111 |
" " |
|
|
AcadSubPlanTransDE111 |
" " |
|
|
AcadSubPlan112 |
" " |
|
|
AcadSubPlanDE112 |
" " |
|
|
AcadSubPlanDS112 |
" " |
|
|
AcadSubPlanTransDE112 |
" " |
|
|
AcadPlan12 |
" " |
|
|
AcadPlanDE12 |
" " |
|
|
AcadPlanDS12 |
" " |
|
|
AcadPlanTransDE |
" " |
|
|
AcadSubPlan121 |
" " |
|
|
AcadSubPlanDE121 |
" " |
|
|
AcadSubPlanDS121 |
" " |
|
|
AcadSubPlanTransDE121 |
" " |
|
|
AcadSubPlan122 |
" " |
|
|
AcadSubPlanDE122 |
" " |
|
|
AcadSubPlanDS122 |
" " |
|
|
AcadSubPlanTransDE122 |
" " |
|
|
ApplProgNbr2 |
" " |
|
|
ApplProgEffDT2 |
" " |
|
|
ApplProgEffSEQ2 |
" " |
|
|
ApplProgInst2 |
" " |
|
|
ApplProgInstDE2 |
" " |
|
|
ApplProgInstDS2 |
" " |
|
|
AcadProg2 |
" " |
|
|
AcadProgDE2 |
" " |
|
|
AcadProgDS2 |
" " |
|
|
ProgStatus2 |
" " |
|
|
ProgStatusXL2 |
" " |
|
|
ProgStatusXS2 |
" " |
|
|
ProgAction2 |
" " |
|
|
ProgActionDE2 |
" " |
|
|
ProgActionDS2 |
" " |
|
|
ActionDT2 |
" " |
|
|
ProgReason2 |
" " |
|
|
ProgReasonDE2 |
" " |
|
|
ProgReasonDS2 |
" " |
|
|
AdmitTerm2 |
" " |
|
|
AdmitTermDE2 |
" " |
|
|
AdmitTermDS2 |
" " |
|
|
Campus2 |
" " |
|
|
CampusDE2 |
" " |
|
|
CampusDS2 |
" " |
|
|
AcadProgDual2 |
" " |
|
|
AcadProgDualDE2 |
" " |
|
|
AcadProgDualDS2 |
" " |
|
|
JointProgAppr2 |
" " |
|
|
AcadPlan21 |
" " |
|
|
AcadPlanDE21 |
" " |
|
|
AcadPlanDS21 |
" " |
|
|
AcadPlanTransDE |
" " |
|
|
AcadSubPlan211 |
" " |
|
|
AcadSubPlanDE211 |
" " |
|
|
AcadSubPlanDS211 |
" " |
|
|
AcadSubPlanTransDE211 |
" " |
|
|
AcadSubPlan212 |
" " |
|
|
AcadSubPlanDE212 |
" " |
|
|
AcadSubPlanDS212 |
" " |
|
|
AcadSubPlanTransDE212 |
" " |
|
|
AcadPlan22 |
" " |
|
|
AcadPlanDE22 |
" " |
|
|
AcadPlanDS22 |
" " |
|
|
AcadPlanTransDE |
" " |
|
|
AcadSubPlan221 |
" " |
|
|
AcadSubPlanDE221 |
" " |
|
|
AcadSubPlanDS221 |
" " |
|
|
AcadSubPlanTransDE221 |
" " |
|
|
AcadSubPlan222 |
" " |
|
|
AcadSubPlanDE222 |
" " |
|
|
AcadSubPlanDS222 |
" " |
|
|
AcadSubPlanTransDE222 |
" " |
|
|
ApplProgNbr3 |
" " |
|
|
ApplProgEffDT3 |
" " |
|
|
ApplProgEffSEQ3 |
" " |
|
|
ApplProgInst3 |
" " |
|
|
ApplProgInstDE3 |
" " |
|
|
ApplProgInstDS3 |
" " |
|
|
AcadProg3 |
" " |
|
|
AcadProgDE3 |
" " |
|
|
AcadProgDS3 |
" " |
|
|
ProgStatus3 |
" " |
|
|
ProgStatusXL3 |
" " |
|
|
ProgStatusXS3 |
" " |
|
|
ProgAction3 |
" " |
|
|
ProgActionDE3 |
" " |
|
|
ProgActionDS3 |
" " |
|
|
ActionDT3 |
" " |
|
|
ProgReason3 |
" " |
|
|
ProgReasonDE3 |
" " |
|
|
ProgReasonDS3 |
" " |
|
|
AdmitTerm3 |
" " |
|
|
AdmitTermDE3 |
" " |
|
|
AdmitTermDS3 |
" " |
|
|
Campus3 |
" " |
|
|
CampusDE3 |
" " |
|
|
CampusDS3 |
" " |
|
|
AcadProgDual3 |
" " |
|
|
AcadProgDualDE3 |
" " |
|
|
AcadProgDualDS3 |
" " |
|
|
JointProgAppr3 |
" " |
|
|
AcadPlan31 |
" " |
|
|
AcadPlanDE31 |
" " |
|
|
AcadPlanDS31 |
" " |
|
|
AcadPlanTransDE |
" " |
|
|
AcadSubPlan311 |
" " |
|
|
AcadSubPlanDE311 |
" " |
|
|
AcadSubPlanDS311 |
" " |
|
|
AcadSubPlanTransDE311 |
" " |
|
|
AcadSubPlan312 |
" " |
|
|
AcadSubPlanDE312 |
" " |
|
|
AcadSubPlanDS312 |
" " |
|
|
AcadSubPlanTransDE312 |
" " |
|
|
AcadPlan32 |
" " |
|
|
AcadPlanDE32 |
" " |
|
|
AcadPlanDS32 |
" " |
|
|
AcadPlanTransDE |
" " |
|
|
AcadSubPlan321 |
" " |
|
|
AcadSubPlanDE321 |
" " |
|
|
AcadSubPlanDS321 |
" " |
|
|
AcadSubPlanTransDE321 |
" " |
|
|
AcadSubPlan322 |
" " |
|
|
AcadSubPlanDE322 |
" " |
|
|
AcadSubPlanDS322 |
" " |
|
|
AcadSubPlanTransDE322 |
" " |
|
|
not used |
AdmCommentCd1 |
" " |
|
not used |
AdmCommentDL1 |
" " |
|
not used |
AdmCommentDE1 |
" " |
|
not used |
AdmCommentDS1 |
" " |
|
not used |
AdmCommentTerm1 |
" " |
|
not used |
AdmCommentProg1 |
" " |
|
not used |
AdmCommentBegin1 |
" " |
|
not used |
AdmCommentEnd1 |
" " |
|
not used |
AdmCommentType1 |
" " |
|
not used |
AdmCommentCd2 |
" " |
|
not used |
AdmCommentDL2 |
" " |
|
not used |
AdmCommentDE2 |
" " |
|
not used |
AdmCommentDS2 |
" " |
|
not used |
AdmCommentTerm2 |
" " |
|
not used |
AdmCommentProg2 |
" " |
|
not used |
AdmCommentBegin2 |
" " |
|
not used |
AdmCommentEnd2 |
" " |
|
not used |
AdmCommentType2 |
" " |
|
not used |
AdmCommentCd3 |
" " |
|
not used |
AdmCommentDL3 |
" " |
|
not used |
AdmCommentDE3 |
" " |
|
not used |
AdmCommentDS3 |
" " |
|
not used |
AdmCommentTerm3 |
" " |
|
not used |
AdmCommentProg3 |
" " |
|
not used |
AdmCommentBegin3 |
" " |
|
not used |
AdmCommentEnd3 |
" " |
|
not used |
AdmCommentType3 |
" " |
|
BasisAdmit1 |
" " |
|
|
BasisAdmitDL1 |
" " |
|
|
BasisAdmitDE1 |
" " |
|
|
BasisAdmitDS1 |
" " |
|
|
BasisAdmitAcadProg1 |
" " |
|
|
BasisAdmitTerm1 |
" " |
|
|
BasisAdmitBeginDt1 |
" " |
|
|
BasisAdmitEndDt1 |
" " |
|
|
BasisAdmit2 |
" " |
|
|
BasisAdmitDL2 |
" " |
|
|
BasisAdmitDE2 |
" " |
|
|
BasisAdmitDS2 |
" " |
|
|
BasisAdmitAcadProg2 |
" " |
|
|
BasisAdmitTerm2 |
" " |
|
|
BasisAdmitBeginDt2 |
" " |
|
|
BasisAdmitEndDt2 |
" " |
|
|
BasisAdmit3 |
" " |
|
|
BasisAdmitDL3 |
" " |
|
|
BasisAdmitDE3 |
" " |
|
|
BasisAdmitDS3 |
" " |
|
|
BasisAdmitAcadProg3 |
" " |
|
|
BasisAdmitTerm3 |
" " |
|
|
BasisAdmitBeginDt3 |
" " |
|
|
BasisAdmitEndDt3 |
" " |
VER Form and EDR Data Merge Fields
The following Verification Form (VER) and Enrollment Deposit Request (EDR) merge fields can be added to any ADMP letter code upon request.
| New or Changed | MS Word Merge Field | Example of what prints |
|---|---|---|
|
VER |
CurAddress1 |
"1234 Maple Ave" |
|
VER |
CurAddress2 |
" " |
|
VER |
CurAddress3 |
" " |
|
VER |
CurAddress4 |
" " |
|
VER |
CurCity |
"Ann Arbor" |
|
VER |
CurState |
"MI" |
|
VER |
CurPostal |
"48103" |
|
VER |
CurCountry |
"USA" |
|
VER |
CurAddEndDt |
"June 1, 2010" |
|
VER |
PermAddress1 |
"555 Main St" |
|
VER |
PermAddress2 |
" " |
|
VER |
PermAddress3 |
" " |
|
VER |
PermAddress4 |
" " |
|
VER |
PermCity |
"Muskegon" |
|
VER |
PermState |
"MI" |
|
VER |
PermPostal |
"49988-9875" |
|
VER |
PermCountry |
"USA" |
|
VER |
PermAddEndDt |
" " |
|
VER |
Curphone |
"555/555-9876" |
|
VER |
Permphone |
" " |
|
VER |
Residency |
"IS" |
|
VER |
ResidencyDS |
"In State" |
|
VER |
Geoloc |
"MUS" |
|
VER |
GeolocDE |
"Muskegon" |
|
VER |
GeolocDS |
"Muskegon" |
|
VER |
TestID11 |
"ACT" |
|
VER |
TestDt11 |
"04-01-2003" |
|
VER |
TestComp111 |
"COMP" |
|
VER |
Score111 |
"28" |
|
VER |
TestComp112 |
"ENGL" |
|
VER |
Score112 |
"25" |
|
VER |
TestComp113 |
"MATH" |
|
VER |
Score113 |
"31" |
|
VER |
TestComp114 |
"READ" |
|
VER |
Score114 |
"28" |
|
VER |
TestComp115 |
"SCIRE" |
|
VER |
Score115 |
"26" |
|
VER |
TestID12 |
"ACT" |
|
VER |
TestDt12 |
"02-01-2003" |
|
VER |
TestComp121 |
"COMP" |
|
VER |
Score121 |
"27" |
|
VER |
TestComp122 |
"ENGL" |
|
VER |
Score122 |
"24" |
|
VER |
TestComp123 |
"MATH" |
|
VER |
Score123 |
"30" |
|
VER |
TestComp124 |
"READ" |
|
VER |
Score124 |
"27" |
|
VER |
TestComp125 |
"SCIRE" |
|
VER |
Score125 |
"27" |
|
VER |
TestID13 |
"" |
|
VER |
TestDt13 |
"" |
|
VER |
TestComp131 |
"" |
|
VER |
Score131 |
"" |
|
VER |
TestComp132 |
"" |
|
VER |
Score132 |
"" |
|
VER |
TestComp133 |
"" |
|
VER |
Score133 |
"" |
|
VER |
TestComp134 |
"" |
|
VER |
Score134 |
"" |
|
VER |
TestComp135 |
"" |
|
VER |
Score135 |
"" |
|
VER |
TestID14 |
"" |
|
VER |
TestDt14 |
"" |
|
VER |
TestComp141 |
"" |
|
VER |
Score141 |
"" |
|
VER |
TestComp142 |
"" |
|
VER |
Score142 |
"" |
|
VER |
TestComp143 |
"" |
|
VER |
Score143 |
"" |
|
VER |
TestComp144 |
"" |
|
VER |
Score144 |
"" |
|
VER |
TestComp145 |
"" |
|
VER |
Score145 |
"" |
|
VER |
TestID15 |
"" |
|
VER |
TestDt15 |
"" |
|
VER |
TestComp151 |
"" |
|
VER |
Score151 |
"" |
|
VER |
TestComp152 |
"" |
|
VER |
Score152 |
"" |
|
VER |
TestComp153 |
"" |
|
VER |
Score153 |
"" |
|
VER |
TestComp154 |
"" |
|
VER |
Score154 |
"" |
|
VER |
TestComp155 |
"" |
|
VER |
Score155 |
"" |
|
VER |
TestID21 |
"" |
|
VER |
TestDt21 |
"" |
|
VER |
TestComp211 |
"" |
|
VER |
Score211 |
"" |
|
VER |
TestComp212 |
"" |
|
VER |
Score212 |
"" |
|
VER |
TestComp213 |
"" |
|
VER |
Score213 |
"" |
|
VER |
TestComp214 |
"" |
|
VER |
Score214 |
"" |
|
VER |
TestComp215 |
"" |
|
VER |
Score215 |
"" |
|
VER |
TestID22 |
"" |
|
VER |
TestDt22 |
"" |
|
VER |
TestComp221 |
"" |
|
VER |
Score221 |
"" |
|
VER |
TestComp222 |
"" |
|
VER |
Score222 |
"" |
|
VER |
TestComp223 |
"" |
|
VER |
Score223 |
"" |
|
VER |
TestComp224 |
"" |
|
VER |
Score224 |
"" |
|
VER |
TestComp225 |
"" |
|
VER |
Score225 |
"" |
|
VER |
TestID23 |
"" |
|
VER |
TestDt23 |
"" |
|
VER |
TestComp231 |
"" |
|
VER |
Score231 |
"" |
|
VER |
TestComp232 |
"" |
|
VER |
Score232 |
"" |
|
VER |
TestComp233 |
"" |
|
VER |
Score233 |
"" |
|
VER |
TestComp234 |
"" |
|
VER |
Score234 |
"" |
|
VER |
TestComp235 |
"" |
|
VER |
Score235 |
"" |
|
VER |
TestID24 |
"" |
|
VER |
TestDt24 |
"" |
|
VER |
TestComp241 |
"" |
|
VER |
Score241 |
"" |
|
VER |
TestComp242 |
"" |
|
VER |
Score242 |
"" |
|
VER |
TestComp243 |
"" |
|
VER |
Score243 |
"" |
|
VER |
TestComp244 |
"" |
|
VER |
Score244 |
"" |
|
VER |
TestComp245 |
"" |
|
VER |
Score245 |
"" |
|
VER |
TestID25 |
"" |
|
VER |
TestDt25 |
"" |
|
VER |
TestComp251 |
"" |
|
VER |
Score251 |
"" |
|
VER |
TestComp252 |
"" |
|
VER |
Score252 |
"" |
|
VER |
TestComp253 |
"" |
|
VER |
Score253 |
"" |
|
VER |
TestComp254 |
"" |
|
VER |
Score254 |
"" |
|
VER |
TestComp255 |
"" |
|
VER |
Score255 |
"" |
|
VER |
TestID31 |
"" |
|
VER |
TestDt31 |
"" |
|
VER |
TestComp311 |
"" |
|
VER |
Score311 |
"" |
|
VER |
TestComp312 |
"" |
|
VER |
Score312 |
"" |
|
VER |
TestComp313 |
"" |
|
VER |
Score313 |
"" |
|
VER |
TestComp314 |
"" |
|
VER |
Score314 |
"" |
|
VER |
TestComp315 |
"" |
|
VER |
Score315 |
"" |
|
VER |
TestID32 |
"" |
|
VER |
TestDt32 |
"" |
|
VER |
TestComp321 |
"" |
|
VER |
Score321 |
"" |
|
VER |
TestComp322 |
"" |
|
VER |
Score322 |
"" |
|
VER |
TestComp323 |
"" |
|
VER |
Score323 |
"" |
|
VER |
TestComp324 |
"" |
|
VER |
Score324 |
"" |
|
VER |
TestComp325 |
"" |
|
VER |
Score325 |
"" |
|
VER |
TestID33 |
"" |
|
VER |
TestDt33 |
"" |
|
VER |
TestComp331 |
"" |
|
VER |
Score331 |
"" |
|
VER |
TestComp332 |
"" |
|
VER |
Score332 |
"" |
|
VER |
TestComp333 |
"" |
|
VER |
Score333 |
"" |
|
VER |
TestComp334 |
"" |
|
VER |
Score334 |
"" |
|
VER |
TestComp335 |
"" |
|
VER |
Score335 |
"" |
|
VER |
TestID34 |
"" |
|
VER |
TestDt34 |
"" |
|
VER |
TestComp341 |
"" |
|
VER |
Score341 |
"" |
|
VER |
TestComp342 |
"" |
|
VER |
Score342 |
"" |
|
VER |
TestComp343 |
"" |
|
VER |
Score343 |
"" |
|
VER |
TestComp344 |
"" |
|
VER |
Score344 |
"" |
|
VER |
TestComp345 |
"" |
|
VER |
Score345 |
"" |
|
VER |
TestID35 |
"" |
|
VER |
TestDt35 |
"" |
|
VER |
TestComp351 |
"" |
|
VER |
Score351 |
"" |
|
VER |
TestComp352 |
"" |
|
VER |
Score352 |
"" |
|
VER |
TestComp353 |
"" |
|
VER |
Score353 |
"" |
|
VER |
TestComp354 |
"" |
|
VER |
Score354 |
"" |
|
VER |
TestComp355 |
"" |
|
VER |
Score355 |
"" |
|
VER |
TestID41 |
"" |
|
VER |
TestDt41 |
"" |
|
VER |
TestComp411 |
"" |
|
VER |
Score411 |
"" |
|
VER |
TestComp412 |
"" |
|
VER |
Score412 |
"" |
|
VER |
TestComp413 |
"" |
|
VER |
Score413 |
"" |
|
VER |
TestComp414 |
"" |
|
VER |
Score414 |
"" |
|
VER |
TestComp415 |
"" |
|
VER |
Score415 |
"" |
|
VER |
TestID42 |
"" |
|
VER |
TestDt42 |
"" |
|
VER |
TestComp421 |
"" |
|
VER |
Score421 |
"" |
|
VER |
TestComp422 |
"" |
|
VER |
Score422 |
"" |
|
VER |
TestComp423 |
"" |
|
VER |
Score423 |
"" |
|
VER |
TestComp424 |
"" |
|
VER |
Score424 |
"" |
|
VER |
TestComp425 |
"" |
|
VER |
Score425 |
"" |
|
VER |
TestID43 |
"" |
|
VER |
TestDt43 |
"" |
|
VER |
TestComp431 |
"" |
|
VER |
Score431 |
"" |
|
VER |
TestComp432 |
"" |
|
VER |
Score432 |
"" |
|
VER |
TestComp433 |
"" |
|
VER |
Score433 |
"" |
|
VER |
TestComp434 |
"" |
|
VER |
Score434 |
"" |
|
VER |
TestComp435 |
"" |
|
VER |
Score435 |
"" |
|
VER |
TestID44 |
"" |
|
VER |
TestDt44 |
"" |
|
VER |
TestComp441 |
"" |
|
VER |
Score441 |
"" |
|
VER |
TestComp442 |
"" |
|
VER |
Score442 |
"" |
|
VER |
TestComp443 |
"" |
|
VER |
Score443 |
"" |
|
VER |
TestComp444 |
"" |
|
VER |
Score444 |
"" |
|
VER |
TestComp445 |
"" |
|
VER |
Score445 |
"" |
|
VER |
TestID45 |
"" |
|
VER |
TestDt45 |
"" |
|
VER |
TestComp451 |
"" |
|
VER |
Score451 |
"" |
|
VER |
TestComp452 |
"" |
|
VER |
Score452 |
"" |
|
VER |
TestComp453 |
"" |
|
VER |
Score453 |
"" |
|
VER |
TestComp454 |
"" |
|
VER |
Score454 |
"" |
|
VER |
TestComp455 |
"" |
|
VER |
Score455 |
"" |
|
VER |
TransLoc1 |
"UGA" |
|
VER |
TransLocDE1 |
"Undergraduate Admissions" |
|
VER |
TransOrgID11 |
"000023481" |
|
VER |
TransOrgName11 |
"Reeths Puffer High School" |
|
VER |
TransType11 |
"OFF" |
|
VER |
TransTypeXS11 |
"Official" |
|
VER |
TransStatus11 |
"P" |
|
VER |
TransStatusXS11 |
"In Prog" |
|
VER |
TransRcvdDT11 |
"06-19-2003" |
|
VER |
TransOrgID12 |
"" |
|
VER |
TransOrgName12 |
"" |
|
VER |
TransType12 |
"" |
|
VER |
TransTypeXS12 |
"" |
|
VER |
TransStatus12 |
"" |
|
VER |
TransStatusXS12 |
"" |
|
VER |
TransRcvdDT12 |
"" |
|
VER |
TransOrgID13 |
"" |
|
VER |
TransOrgName13 |
"" |
|
VER |
TransType13 |
"" |
|
VER |
TransTypeXS13 |
"" |
|
VER |
TransStatus13 |
"" |
|
VER |
TransStatusXS13 |
"" |
|
VER |
TransRcvdDT13 |
"" |
|
VER |
TransOrgID14 |
"" |
|
VER |
TransOrgName14 |
"" |
|
VER |
TransType14 |
"" |
|
VER |
TransTypeXS14 |
"" |
|
VER |
TransStatus14 |
"" |
|
VER |
TransStatusXS14 |
"" |
|
VER |
TransRcvdDT14 |
"" |
|
VER |
TransOrgID15 |
"" |
|
VER |
TransOrgName15 |
"" |
|
VER |
TransType15 |
"" |
|
VER |
TransTypeXS15 |
"" |
|
VER |
TransStatus15 |
"" |
|
VER |
TransStatusXS15 |
"" |
|
VER |
TransRcvdDT15 |
"" |
|
VER |
TransLoc2 |
"" |
|
VER |
TransLocDE2 |
"" |
|
VER |
TransOrgID21 |
"" |
|
VER |
TransOrgName21 |
"" |
|
VER |
TransType21 |
"" |
|
VER |
TransTypeXS21 |
"" |
|
VER |
TransStatus21 |
"" |
|
VER |
TransStatusXS21 |
"" |
|
VER |
TransRcvdDT21 |
"" |
|
VER |
TransOrgID22 |
"" |
|
VER |
TransOrgName22 |
"" |
|
VER |
TransType22 |
"" |
|
VER |
TransTypeXS22 |
"" |
|
VER |
TransStatus22 |
"" |
|
VER |
TransStatusXS22 |
"" |
|
VER |
TransRcvdDT22 |
"" |
|
VER |
TransOrgID23 |
"" |
|
VER |
TransOrgName23 |
"" |
|
VER |
TransType23 |
"" |
|
VER |
TransTypeXS23 |
"" |
|
VER |
TransStatus23 |
"" |
|
VER |
TransStatusXS23 |
"" |
|
VER |
TransRcvdDT23 |
"" |
|
VER |
TransOrgID24 |
"" |
|
VER |
TransOrgName24 |
"" |
|
VER |
TransType24 |
"" |
|
VER |
TransTypeXS24 |
"" |
|
VER |
TransStatus24 |
"" |
|
VER |
TransStatusXS24 |
"" |
|
VER |
TransRcvdDT24 |
"" |
|
VER |
TransOrgID25 |
"" |
|
VER |
TransOrgName25 |
"" |
|
VER |
TransType25 |
"" |
|
VER |
TransTypeXS25 |
"" |
|
VER |
TransStatus25 |
"" |
|
VER |
TransStatusXS25 |
"" |
|
VER |
TransRcvdDT25 |
"" |
|
VER |
SchoolID1 |
"" |
|
VER |
SchoolName1 |
"" |
|
VER |
CeebCode1 |
"" |
|
VER |
DataSource1 |
"" |
|
VER |
Degree1 |
"" |
|
VER |
DegreeDE1 |
"" |
|
VER |
DegreeDT1 |
"" |
|
VER |
ExtSubjArea11 |
"" |
|
VER |
FieldofStudy11 |
"" |
|
VER |
ExtSubjArea21 |
"" |
|
VER |
FieldofStudy21 |
"" |
|
VER |
SchoolID2 |
"" |
|
VER |
SchoolName2 |
"" |
|
VER |
CeebCode2 |
"" |
|
VER |
DataSource2 |
"" |
|
VER |
Degree2 |
"" |
|
VER |
DegreeDE2 |
"" |
|
VER |
DegreeDT2 |
"" |
|
VER |
ExtSubjArea12 |
"" |
|
VER |
FieldofStudy12 |
"" |
|
VER |
ExtSubjArea22 |
"" |
|
VER |
FieldofStudy22 |
"" |
|
VER |
SchoolID3 |
"" |
|
VER |
SchoolName3 |
"" |
|
VER |
CeebCode3 |
"" |
|
VER |
DataSource3 |
"" |
|
VER |
Degree3 |
"" |
|
VER |
DegreeDE3 |
"" |
|
VER |
DegreeDT3 |
"" |
|
VER |
ExtSubjArea13 |
"" |
|
VER |
FieldofStudy13 |
"" |
|
VER |
ExtSubjArea23 |
"" |
|
VER |
FieldofStudy23 |
"" |
|
VER |
SchoolID4 |
"" |
|
VER |
SchoolName4 |
"" |
|
VER |
CeebCode4 |
"" |
|
VER |
DataSource4 |
"" |
|
VER |
Degree4 |
"" |
|
VER |
DegreeDE4 |
"" |
|
VER |
DegreeDT4 |
"" |
|
VER |
ExtSubjArea14 |
"" |
|
VER |
FieldofStudy14 |
"" |
|
VER |
ExtSubjArea24 |
"" |
|
VER |
FieldofStudy24 |
"" |
|
VER |
GenlMatlGroup1 |
"" |
|
VER |
GenlMatlType1 |
"" |
|
VER |
MatlTypeDescr1 |
"" |
|
VER |
GenlMatlNbr1 |
"" |
|
VER |
DtRecvd1 |
"" |
|
VER |
AuditionType1 |
"" |
|
VER |
PortfolioType1 |
"" |
|
VER |
EssayTopic1 |
"" |
|
VER |
GenlIntvwType1 |
"" |
|
VER |
RecommType1 |
"" |
|
VER |
RecommName1 |
"" |
|
VER |
RecommTitle1 |
"" |
|
VER |
RecommOrgName1 |
"" |
|
VER |
MatlDescr1 |
"" |
|
VER |
GenlMatlGroup2 |
"" |
|
VER |
GenlMatlType2 |
"" |
|
VER |
MatlTypeDescr2 |
"" |
|
VER |
GenlMatlNbr2 |
"" |
|
VER |
DtRecvd2 |
"" |
|
VER |
AuditionType2 |
"" |
|
VER |
PortfolioType2 |
"" |
|
VER |
EssayTopic2 |
"" |
|
VER |
GenlIntvwType2 |
"" |
|
VER |
RecommType2 |
"" |
|
VER |
RecommName2 |
"" |
|
VER |
RecommTitle2 |
"" |
|
VER |
RecommOrgName2 |
"" |
|
VER |
MatlDescr2 |
"" |
|
VER |
GenlMatlGroup3 |
"" |
|
VER |
GenlMatlType3 |
"" |
|
VER |
MatlTypeDescr3 |
"" |
|
VER |
GenlMatlNbr3 |
"" |
|
VER |
DtRecvd3 |
"" |
|
VER |
AuditionType3 |
"" |
|
VER |
PortfolioType3 |
"" |
|
VER |
EssayTopic3 |
"" |
|
VER |
GenlIntvwType3 |
"" |
|
VER |
RecommType3 |
"" |
|
VER |
RecommName3 |
"" |
|
VER |
RecommTitle3 |
"" |
|
VER |
RecommOrgName3 |
"" |
|
VER |
MatlDescr3 |
"" |
|
VER |
MultiEthStatus |
"Multiethnic" |
|
VER |
MultiEthEthCd1 |
"AFRAMER" |
|
VER |
MultiEthEthDE1 |
"African-American" |
|
VER |
MultiEthEthCd2 |
"INDONES" |
|
VER |
MultiEthEthDE2 |
"Indonesian" |
|
VER |
MultiEthEthCd3 |
" " |
|
VER |
MultiEthEthDE3 |
" " |
|
VER New |
RecommenderRecommTypeDescr1 |
"Counselor" |
|
VER New |
RecommenderRecommTypeDescr2 |
"Teacher" |
|
VER New |
RecommenderRecommTypeDescr3 |
"Other" |
|
VER New |
RecommenderName1 |
"Smith,Joe S" |
|
VER New |
RecommenderName2 |
"Hershey,Jane A" |
|
VER New |
RecommenderName3 |
" " |
|
VER New |
RecommenderEmailAddr1 |
"joesmith@school.edu" |
|
VER New |
RecommenderEmailAddr2 |
"janehersh@college.edu" |
|
VER New |
RecommenderEmailAddr3 |
" " |
|
EDR and VER |
DepDueDt |
"May 1, 2003" |
|
EDR and VER |
DepDueAmount |
"$ 200.00" |
|
EDR and VER |
ScanDueAmount |
"0020000" |
|
VER |
StudGroup1 |
"" |
|
VER |
StudGroupDE1 |
"" |
|
VER |
StudGroup2 |
"" |
|
VER |
StudGroupDE2 |
"" |
|
VER |
StudGroup3 |
"" |
|
VER |
StudGroupDE3 |
"" |
|
VER |
AdmInterest1 |
"Physics" |
|
VER |
AdmInterest2 |
"Aerospace Engineering" |
|
VER |
AdmInterest3 |
" " |
|
VER |
AdmInterest4 |
" " |
|
VER |
AdmInterest5 |
" " |
|
VER |
PrntLvlEd |
" " |
|
VER |
EstGrossIn |
" " |
|
VER |
NumberDeps |
" " |
|
VER |
SinglePar |
" " |
Base Merge Fields
The following merge fields are available in all letters, regardless of the Administrative Function.
| New or Changed | MS Word Merge Field | Example of what prints |
|---|---|---|
|
LetterPrintedDT |
"December 16, 2010" |
|
|
OrigCommYN |
"Y" |
|
|
CCsYN |
"N" |
|
|
ID |
"51822899" |
|
|
Seq3C |
"2" |
|
|
SAIDType |
"P" |
|
|
not used |
JointComm |
"N" |
|
CommEmplIDRelated |
" " |
|
|
CommDTTM |
"12-DEC-2010_11:01:08_AM" |
|
|
CommCategory |
"BUSARQ" |
|
|
CommCategoryDE |
"BUS-Req Addl Miss Mat/Info" |
|
|
CommCategoryDS |
"BUS-ReqInf" |
|
|
CommContext |
"BUSMIL" |
|
|
CommContextDE |
"Missing Informatn Ltr-Chklst" |
|
|
CommContextDS |
"MisInfLtr" |
|
|
CommMethod |
"L" |
|
|
CommMethodXL |
"Letter" |
|
|
CommMethodXS |
"Letter" |
|
|
CommDeptID |
"380000" |
|
|
CommDeptIDDE |
"School of Business Admin" |
|
|
IncludeEncl |
"Y" |
|
|
EnclCd1 |
"XXA" |
|
|
EnclCdDE1 |
"Test Enclose Code Letter" |
|
|
EnclCdDS1 |
"Encl Code" |
|
|
EnclType1 |
"S" |
|
|
EnclTypeXL1 |
"Softcopy" |
|
|
EnclTypeXS1 |
"Softcopy" |
|
|
EnclComment1 |
"Sample Enclosure comment. This text is entered under Enclosures on the Communication Management 1 Page." |
|
|
EnclCd2 |
" " |
|
|
EnclCdDE2 |
" " |
|
|
EnclCdDS2 |
" " |
|
|
EnclType2 |
" " |
|
|
EnclTypeXL2 |
" " |
|
|
EnclTypeXS2 |
" " |
|
|
EnclComment2 |
" " |
|
|
EnclCd3 |
" " |
|
|
EnclCdDE3 |
" " |
|
|
EnclCdDS3 |
" " |
|
|
EnclType3 |
" " |
|
|
EnclTypeXL3 |
" " |
|
|
EnclTypeXS3 |
" " |
|
|
EnclComment3 |
" " |
|
|
EnclCd4 |
" " |
|
|
EnclCdDE4 |
" " |
|
|
EnclCdDS4 |
" " |
|
|
EnclType4 |
" " |
|
|
EnclTypeXL4 |
" " |
|
|
EnclTypeXS4 |
" " |
|
|
EnclComment4 |
" " |
|
|
EnclCd5 |
" " |
|
|
EnclCdDE5 |
" " |
|
|
EnclCdDS5 |
" " |
|
|
EnclType5 |
" " |
|
|
EnclTypeXL5 |
" " |
|
|
EnclTypeXS5 |
" " |
|
|
EnclComment5 |
" " |
|
|
EnclCd6 |
" " |
|
|
EnclCdDE6 |
" " |
|
|
EnclCdDS6 |
" " |
|
|
EnclType6 |
" " |
|
|
EnclTypeXL6 |
" " |
|
|
EnclTypeXS6 |
" " |
|
|
EnclComment6 |
" " |
|
|
EnclCd7 |
" " |
|
|
EnclCdDE7 |
" " |
|
|
EnclCdDS7 |
" " |
|
|
EnclType7 |
" " |
|
|
EnclTypeXL7 |
" " |
|
|
EnclTypeXS7 |
" " |
|
|
EnclComment7 |
" " |
|
|
EnclCd8 |
" " |
|
|
EnclCdDE8 |
" " |
|
|
EnclCdDS8 |
" " |
|
|
EnclType8 |
" " |
|
|
EnclTypeXL8 |
" " |
|
|
EnclTypeXS8 |
" " |
|
|
EnclComment8 |
" " |
|
|
EnclCd9 |
" " |
|
|
EnclCdDE9 |
" " |
|
|
EnclCdDS9 |
" " |
|
|
EnclType9 |
" " |
|
|
EnclTypeXL9 |
" " |
|
|
EnclTypeXS9 |
" " |
|
|
EnclComment9 |
" " |
|
|
EnclCd10 |
" " |
|
|
EnclCdDE10 |
" " |
|
|
EnclCdDS10 |
" " |
|
|
EnclType10 |
" " |
|
|
EnclTypeXL10 |
" " |
|
|
EnclTypeXS10 |
" " |
|
|
EnclComment10 |
" " |
|
|
EnclosureCount |
"1" |
|
|
CommOrgContact |
"0" |
|
|
CommOrgLocation |
"0" |
|
|
CommOrgDepartment |
"0" |
|
|
CommComments |
"Sample Communication Comments. This text is entered on the Communication Management 1 page." |
|
|
CommSignerId |
"30305678" |
|
|
SigNameType |
"PRI" |
|
|
SigNamePart |
"U" |
|
|
SigName |
"Test,John B" |
|
|
SigNamePrefix |
" " |
|
|
SigLastNameSrch |
"TEST" |
|
|
SigFirstNameSrch |
"JOHN" |
|
|
SigNameSuffix |
" " |
|
|
SigNameResult |
"John B Test" |
|
|
SigFirstName |
"John" |
|
|
SigMiddleName |
"B" |
|
|
SigLastName |
"Test" |
|
|
SigNameTitle |
" " |
|
|
CommSignerTitle |
"Assistant Director" |
|
|
SignerEmail |
"johntest@umich.edu" |
|
|
Disabled |
"No" |
|
|
MarStatusXL |
"Unknown" |
|
|
MarStatusXS |
"Unknown" |
|
|
BirthDate |
"May 25, 1986" |
|
|
BirthPlace |
"Toulouse" |
|
|
BirthCountryDE |
"France" |
|
|
BirthStateDE |
" " |
|
|
CitizenShipStatusDE |
"Non-Resident Alien" |
|
|
CitizenShipStatusDS |
"Non Res." |
|
|
CitizenshipCountry |
"FRA" |
|
|
CitizenshipCountryDE |
"France" |
|
|
VisaPermitType |
"J1" |
|
|
VisaPermitTypeDE |
"Exchange Visitor" |
|
|
CampusID |
"FATESTXX" |
|
|
SINOA |
"000399999" |
|
|
DisabledVet |
"No" |
|
|
EthnicGroupXL |
"Black/African-American" |
|
|
EthnicGroupXS |
"Black" |
|
|
MilitaryStatXL |
"Not indicated" |
|
|
MilitaryStatXS |
"Not Indic." |
|
|
SIN |
" " |
|
|
CanAboriginal |
"No" |
|
|
CanVisblMinorityXL |
"Not a Visible Minority" |
|
|
CanVisblMinorityXS |
"Not Visibl" |
|
|
Sex |
"M" |
|
|
SexXS |
"Male" |
|
|
not used |
OrgDescr |
" " |
|
not used |
OrgDescr50 |
" " |
|
not used |
OrgDescrShort |
" " |
|
not used |
OrgLocation |
" " |
|
SalutNameType |
"PRF" |
|
|
SalutNamePart |
"U" |
|
|
SalutName |
"Thomas,Theodore A" |
|
|
SalutNamePrefix |
" " |
|
|
SalutNamePrefixDE |
" " |
|
|
SalutNamePrefixDS |
" " |
|
|
SalutLastNameSrch |
"THOMAS" |
|
|
SalutFirstNameSrch |
"THEODORE" |
|
|
SalutNameSuffix |
" " |
|
|
SalutNameSuffixDE |
" " |
|
|
SalutNameSuffixDS |
" " |
|
|
SalutNameResult |
"Theodore A Thomas" |
|
|
SalutNameResult2 |
" " |
|
|
SalutFirstName |
"Theodore" |
|
|
SalutMiddleName |
"A" |
|
|
SalutLastName |
"Thomas" |
|
|
AddrNameType |
"PRF" |
|
|
New |
SalutNameInitials |
|
|
New |
SalutNameRoyalPrefix |
|
|
New |
SalutNameRoyalSuffix |
|
|
New |
SalutSecondLastName |
|
|
New |
SalutSecondLastSrch |
|
|
New |
SalutNameAc |
|
|
New |
SalutPrefFirstName |
|
|
New |
SalutPartnerLastName |
|
|
New |
SalutPartnerRoyPrefx |
|
|
not used |
SalutLastNamePrefNld |
|
|
New |
SalutNameDisplay |
“Theodore A Thomas” |
|
New |
SalutNameFormal |
“Theodore A Thomas” |
|
not used |
SalutInitialsNld |
|
|
not used |
SalutFirstNameNld |
|
|
not used |
SalutLastNameNld |
|
|
AddrNamePart |
"U" |
|
|
AddrName |
"Thomas,Theodore A" |
|
|
AddrNamePrefix |
" " |
|
|
AddrNamePrefixDE |
" " |
|
|
AddrNamePrefixDS |
" " |
|
|
AddrLastNameSrch |
"THOMAS" |
|
|
AddrFirstNameSrch |
"THEODORE" |
|
|
AddrNameSuffix |
" " |
|
|
AddrNameSuffixDE |
" " |
|
|
AddrNameSuffixDS |
" " |
|
|
AddrNameResult |
"Theodore A Thomas" |
|
|
AddrNameResult2 |
" " |
|
|
AddrFirstName |
"Theodore" |
|
|
AddrMiddleName |
"A" |
|
|
AddrLastName |
"Thomas" |
|
|
New |
AddrNameInitials |
|
|
New |
AddrNameRoyalPrefix |
|
|
New |
AddrNameRoyalSuffix |
|
|
New |
AddrSecondLastName |
|
|
New |
AddrSecondLastSearch |
|
|
New |
AddrNameAc |
|
|
New |
AddrPrefFirstName |
|
|
New |
AddrPartnerLastName |
|
|
New |
AddrPartnerRoyPrefix |
|
|
not used |
AddrLastNamePrefNld |
|
|
New |
AddrNameDisplay |
“Theodore A Thomas” |
|
New |
AddrNameFormal |
“Theodore A Thomas” |
|
not used |
AddrInitialsNld |
|
|
not used |
AddrFirstNameNld |
|
|
not used |
AddrLastNameNld |
|
|
not used |
OrgContactName |
" " |
|
not used |
OrgJobTitle |
" " |
|
not used |
OrgDeptDE |
" " |
|
not used |
OrgDeptDS |
" " |
|
not used |
OrgLocationDE |
" " |
|
not used |
OrgLocationDS |
" " |
|
Line1 |
"Theodore A Thomas" |
|
|
Line2 |
"5678 Brookview" |
|
|
Line3 |
"Ann Arbor MI 48103" |
|
|
Line4 |
" " |
|
|
Line5 |
" " |
|
|
Line6 |
" " |
|
|
Line7 |
" " |
|
|
Line8 |
" " |
|
|
Line9 |
" " |
|
|
Line10 |
" " |
|
|
Line11 |
" " |
|
|
AddressUsageType |
"Address" |
|
|
Address1 |
"5678 Brookview" |
|
|
Address2 |
" " |
|
|
Address3 |
" " |
|
|
Address4 |
" " |
|
|
City |
"Ann Arbor" |
|
|
InCityLimit |
" " |
|
|
County |
" " |
|
|
State |
"MI" |
|
|
StateDE |
"Michigan" |
|
|
Postal |
"48103" |
|
|
PostalSort |
"481030000000" |
|
|
Postal5 |
"48103" |
|
|
Country |
" " |
|
|
CountryDE |
"United States" |
|
|
not used |
Num1 |
" " |
|
not used |
Num2 |
" " |
|
HouseType |
" " |
|
|
not used |
AddrField1 |
" " |
|
not used |
AddrField2 |
" " |
|
not used |
AddrField3 |
" " |
|
not used |
GeoCode |
" " |
|
EmailID |
"theodorethomas@coolmail.com" |
|
|
NUW1EmailID |
"theodorethomas@coolmail.com" |
|
|
CC1 |
" " |
|
|
CC2 |
" " |
|
|
CC3 |
" " |
|
|
CC4 |
" " |
|
|
CC5 |
" " |
|
|
RecipientRelationNbr |
" " |
|
|
RecipientIDRelated |
" " |
|
|
RecipientName |
" " |
Checklist Data
Up to 50 checklist items can be extracted per letter. For each checklist item, the data file shows the Item Status (e.g. “I” for Initiated) along with a 30-character, a 10-character, and an optional 2000-character description. Merge fields are present for all 50 items even when the items are blank.
| New or Changed | MS Word Merge Field | Example of what prints |
|---|---|---|
|
ItemStatus1 |
"I" |
|
|
not used |
AssocID1 |
" " |
|
not used |
AssocName1 |
" " |
|
ItemDE1 |
"Calculus Required" |
|
|
ItemDS1 |
"Calc Req" |
|
|
ItemDL1 |
"Please note your admission is based on the condition you take a calculus course before enrolling next fall. This course can be taken at any institution offering a college-level course covering integral and differential calculus. You must earn a grade of C or better and provide us with a transcript by August 15, 2018. If not received by that date, we will withdraw our offer of admission." |
|
|
ItemStatus2 |
" " |
|
|
not used |
AssocID2 |
" " |
|
not used |
AssocName2 |
" " |
|
ItemDE2 |
" " |
|
|
ItemDS2 |
" " |
|
|
ItemDL2 |
" " |
|
|
...same 6 fields repeated for a total of 50 items. |
||
|
ItemStatus50 |
" " |
|
|
not used |
AssocID50 |
" " |
|
not used |
AssocName50 |
" " |
|
ItemDE50 |
" " |
|
|
ItemDS50 |
" " |
|
|
ItemDL50 |
" " |