Overview
This document details the Microsoft Word merge fields that can be included in Prospect (PROS) letter templates.
Contents
PROS Merge Fields
The following merge fields are available in all letters in the PROS Administrative Function.
| New or Changed | MS Word Merge Field | Example of what prints |
|---|---|---|
|
AcadCareer |
"UENG" |
|
|
AcadCareerXL |
"Undergraduate Engineering" |
|
|
AcadCareerXS |
"Ugrad Engr" |
|
|
PrspctCarInst |
"UMICH" |
|
|
PrspctCarInstDE |
"University of Michigan" |
|
|
PrspctCarInstDS |
"U of Mich" |
|
|
AdmitTerm |
"2210" |
|
|
AdmitTermDE |
"Fall 2018" |
|
|
AdmitTermDS |
"FA 2018" |
|
|
AdmitType |
"4" |
|
|
AdmitTypeDE |
"New Transfer or New Grad" |
|
|
AdmitTypeDS |
"NwTr/NwGr" |
|
|
PrspctCarRecrCtr |
"ENGT" |
|
|
PrspctCarRecrCtrDE |
"Engineering Transfer" |
|
|
PrspctCarRecrCtrDS |
"Eng Trans" |
|
|
LastSchAttend |
" " |
|
|
LastSchAttendDE |
" " |
|
|
LastSchAttendDS |
" " |
|
|
FinAidInterest |
"No" |
|
|
AcadLoadAppr |
" " |
|
|
AcadLoadApprXL |
" " |
|
|
AcadLoadApprXS |
" " |
|
|
RecruitID |
" " |
|
|
RecruitIDName |
" " |
|
|
RecruitIDNamePrefix |
" " |
|
|
RecruitIDNameSuffix |
" " |
|
|
RecruitIDNameResult |
" " |
|
|
RecruitIDFirstName |
" " |
|
|
RecruitIDMiddleName |
" " |
|
|
AcademicLevel |
"13" |
|
|
AcademicLevelXL |
"Junior" |
|
|
AcademicLevelXS |
"Junior" |
|
|
PrspctCarCampus |
"A" |
|
|
PrspctCarCampusDE |
"Ann Arbor Campus" |
|
|
PrspctCarCampusDS |
"Ann Arbor" |
|
|
AdmRefrlSrce |
" " |
|
|
AdmRefrlSrceDE |
" " |
|
|
AdmRefrlSrceDS |
" " |
|
|
AdmRefrlSrceDT |
" " |
|
|
HousingInterest |
"D" |
|
|
HousingInterestXL |
"Dormitory" |
|
|
HousingInterestXS |
"Dorm" |
|
|
AcadProg1 |
"00007" |
|
|
AcadProgDE1 |
"Engineering UG Degree" |
|
|
AcadProgDS1 |
"UG Engin" |
|
|
PrspctProgRecrCtr1 |
"RACK" |
|
|
PrspctProgRecrCtrDE1 |
"Rackham Graduate School" |
|
|
PrspctProgRecrCtrDS1 |
"Rack" |
|
|
PrspctProgCampus1 |
"A" |
|
|
PrspctProgCampusDE1 |
"Ann Arbor Campus" |
|
|
PrspctProgCampusDS1 |
"Ann Arbor" |
|
|
AcadPlan11 |
"2900" |
|
|
AcadPlanDE11 |
"Engineering: First Year" |
|
|
AcadPlanDS11 |
"Eng-1st Yr" |
|
|
AcadSubPlan111 |
" " |
|
|
AcadSubPlanDE111 |
" " |
|
|
AcadSubPlanDS111 |
" " |
|
|
AcadSubPlan112 |
" " |
|
|
AcadSubPlanDE112 |
" " |
|
|
AcadSubPlanDS112 |
" " |
|
|
AcadPlan12 |
" " |
|
|
AcadPlanDE12 |
" " |
|
|
AcadPlanDS12 |
" " |
|
|
AcadSubPlan121 |
" " |
|
|
AcadSubPlanDE121 |
" " |
|
|
AcadSubPlanDS121 |
" " |
|
|
AcadSubPlan122 |
" " |
|
|
AcadSubPlanDE122 |
" " |
|
|
AcadSubPlanDS122 |
" " |
|
|
AcadProg2 |
" " |
|
|
AcadProgDE2 |
" " |
|
|
AcadProgDS2 |
" " |
|
|
PrspctProgRecrCtr2 |
" " |
|
|
PrspctProgRecrCtrDE2 |
" " |
|
|
PrspctProgRecrCtrDS2 |
" " |
|
|
PrspctProgCampus2 |
" " |
|
|
PrspctProgCampusDS2 |
" " |
|
|
AcadPlan21 |
" " |
|
|
AcadPlanDE21 |
" " |
|
|
AcadPlanDS21 |
" " |
|
|
AcadSubPlan211 |
" " |
|
|
AcadSubPlanDE211 |
" " |
|
|
AcadSubPlanDS211 |
" " |
|
|
AcadSubPlan212 |
" " |
|
|
AcadSubPlanDE212 |
" " |
|
|
AcadSubPlanDS212 |
" " |
|
|
AcadPlan22 |
" " |
|
|
AcadPlanDE22 |
" " |
|
|
AcadPlanDS22 |
" " |
|
|
AcadSubPlan221 |
" " |
|
|
AcadSubPlanDE221 |
" " |
|
|
AcadSubPlanDS221 |
" " |
|
|
AcadSubPlan222 |
" " |
|
|
AcadSubPlanDE222 |
" " |
|
|
AcadSubPlanDS222 |
" " |
|
|
AcadProg3 |
" " |
|
|
AcadProgDE3 |
" " |
|
|
AcadProgDS3 |
" " |
|
|
PrspctProgRecrCtr3 |
" " |
|
|
PrspctProgRecrCtrDE3 |
" " |
|
|
PrspctProgRecrCtrDS3 |
" " |
|
|
PrspctProgCampus3 |
" " |
|
|
PrspctProgCampusDE3 |
" " |
|
|
PrspctProgCampusDS3 |
" " |
|
|
AcadPlan31 |
" " |
|
|
AcadPlanDE31 |
" " |
|
|
AcadPlanDS31 |
" " |
|
|
AcadSubPlan311 |
" " |
|
|
AcadSubPlanDE311 |
" " |
|
|
AcadSubPlanDS311 |
" " |
|
|
AcadSubPlan312 |
" " |
|
|
AcadSubPlanDE312 |
" " |
|
|
AcadSubPlanDS312 |
" " |
|
|
AcadPlan32 |
" " |
|
|
AcadPlanDE32 |
" " |
|
|
AcadPlanDS32 |
" " |
|
|
AcadSubPlan321 |
" " |
|
|
AcadSubPlanDE321 |
" " |
|
|
AcadSubPlanDS321 |
" " |
|
|
AcadSubPlan322 |
" " |
|
|
AcadSubPlanDE322 |
" " |
|
|
AcadSubPlanDS322 |
" " |
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 |
"January 1, 2018" |
|
|
OrigCommYN |
"Y" |
|
|
CCsYN |
"N" |
|
|
ID |
"12345678" |
|
|
Seq3C |
"2" |
|
|
SAIDType |
"P" |
|
|
not used |
JointComm |
"N" |
|
CommEmplIDRelated |
" " |
|
|
CommDTTM |
"01-JAN-2018_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 |
"98765432" |
|
|
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, 1995" |
|
|
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 |
"123 Main St." |
|
|
Line3 |
"Ann Arbor MI 48103" |
|
|
Line4 |
" " |
|
|
Line5 |
" " |
|
|
Line6 |
" " |
|
|
Line7 |
" " |
|
|
Line8 |
" " |
|
|
Line9 |
" " |
|
|
Line10 |
" " |
|
|
Line11 |
" " |
|
|
AddressUsageType |
"Address" |
|
|
Address1 |
"123 Main St." |
|
|
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@mail.com" |
|
|
NUW1EmailID |
"theodorethomas@mail.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 |
" " |