Overview
This document details the Microsoft Word merge fields that can be included in Student Term (STRM) letter templates.
Contents
STRM Merge Fields
The following merge fields are available in all letters in the SPRG Administrative Function.
| New or Changed | MS Word Merge Field | Example of what prints |
|---|---|---|
|
|
AcadCareer |
"GRAC" |
|
|
AcadCareerDE |
"Rackham" |
|
|
AcadCareerDS |
"Rackham" |
|
|
Institution |
"UMICH" |
|
|
InstitutionDE |
"University of Michigan" |
|
|
InstitutionDS |
"U of Mich" |
|
|
Term |
"2210" |
|
|
TermDE |
"Fall 2018" |
|
|
TermDS |
"FA 2018" |
|
|
RegCardDate |
" " |
|
|
WithdrawCode |
"NWD" |
|
|
WithdrawCodeXL |
" " |
|
|
WithdrawCodeXS |
" " |
|
|
WithdrawReason |
" " |
|
|
WithdrawReasonXL |
" " |
|
|
WithdrawReasonXS |
" " |
|
|
WithdrawDate |
" " |
|
|
LastDateAttended |
" " |
|
|
StdntCarNbr |
"0" |
|
|
AcadProgPrimary |
"00114" |
|
|
AcadLoadAppr |
"F" |
|
|
AcadLoadApprXL |
"Full-Time" |
|
|
AcadLoadApprXS |
"Full-Time" |
|
|
AcademicLoad |
"F" |
|
|
AcademicLoadXL |
"Enrolled Full-Time" |
|
|
AcademicLoadXS |
"Full-Time" |
|
|
FaLoad |
"F" |
|
|
FaLoadXL |
"Enrolled Full-Time" |
|
|
FaLoadXS |
"Full-Time" |
|
|
AcadLevelProj |
"25" |
|
|
AcadLevelProjXL |
"Graduate Pre-Candidate" |
|
|
AcadLevelProjXS |
"G Pre-Cand" |
|
|
AcadLevelBot |
"25" |
|
|
AcadLevelBotXL |
"Graduate Pre-Candidate" |
|
|
AcadLevelBotXS |
"G Pre-Cand" |
|
|
AcadLevelEot |
"25" |
|
|
AcadLevelEotXL |
"Graduate Pre-Candidate" |
|
|
AcadLevelEotXS |
"G Pre-Cand" |
|
|
NsldsLoanYear |
"A" |
|
|
NsldsLoanYearXL |
"1st Year Graduate" |
|
|
NsldsLoanYearXS |
"Yr 1 Grad" |
|
|
OvrdAcadLvlProj |
"N" |
|
|
OvrdAcadLvlAll |
"N" |
|
|
EligToEnroll |
"Y" |
|
|
OvrdMaxUnits |
"N" |
|
|
MaxTotalUnit |
"0" |
|
|
MaxNoGpaUnit |
"0" |
|
|
MaxAuditUnit |
"0" |
|
|
MaxWaitUnit |
"0" |
|
|
MinTotalUnit |
"0" |
|
|
OvrdBillUnits |
"N" |
|
|
ProjBillUnt |
"0" |
|
|
UntTakenPrgrss |
"13" |
|
|
UntPassdPrgrss |
"13" |
|
|
UntTakenGpa |
"12" |
|
|
UntPassdGpa |
"13" |
|
|
UntTakenNogpa |
"1" |
|
|
UntPassdNogpa |
"1" |
|
|
UntInprogGpa |
"0" |
|
|
GradePoints |
"87" |
|
|
UntAudit |
"0" |
|
|
UntTrnsfr |
"0" |
|
|
TrfTakenGpa |
"0" |
|
|
TrfTakenNoGpa |
"0" |
|
|
TrfPassedGpa |
"0" |
|
|
TrfPassedNoGpa |
"0" |
|
|
TrfGradePoints |
"0" |
|
|
UntTestCredit |
"0" |
|
|
UntOther |
"0" |
|
|
UntTakenFa |
"13" |
|
|
UntPassdFa |
"13" |
|
|
UntTakenFaGpa |
"12" |
|
|
GradePointsFa |
"87" |
|
|
UntTermTot |
"13" |
|
|
ResetCumStats |
"N" |
|
|
TotTakenPrgrss |
"13" |
|
|
TotPassdPrgrss |
"13" |
|
|
TotTakenGpa |
"12" |
|
|
TotPassdGpa |
"12" |
|
|
TotTakenNogpa |
"1" |
|
|
TotPassdNogpa |
"1" |
|
|
TotInprogGpa |
"0" |
|
|
TotInprogNogpa |
"0" |
|
|
TotAudit |
"0" |
|
|
TotTrnsfr |
"0" |
|
|
TotTestCredit |
"0" |
|
|
TotOther |
"0" |
|
|
TotCumulative |
"13" |
|
|
TotGradePoints |
"87" |
|
|
TotTakenFa |
"13" |
|
|
TotPassdFa |
"13" |
|
|
TotTakenFaGpa |
"12" |
|
|
TotGrdPointsFa |
"87" |
|
|
FormOfStudy |
"ENRL" |
|
|
FormOfStudyXL |
"Class Enrollment" |
|
|
FormOfStudyXS |
"Enrollment" |
|
|
TermType |
"S" |
|
|
TermTypeXL |
"Semester Hours" |
|
|
TermTypeXS |
"Semester" |
|
|
ClassRankNbr |
"0" |
|
|
ClassRankTot |
"0" |
|
|
SelGroup |
"RACKENG" |
|
|
TuitCalcReq |
"N" |
|
|
TuitCalcDttm |
"02-MAR-2018_07:43:48_PM" |
|
|
FaStatsCalcReq |
"N" |
|
|
FaStatsCalcDttm |
" " |
|
|
FaEligibility |
"Y" |
|
|
BillingCareer |
"GRAC" |
|
|
BillingCareerXL |
"Rackham" |
|
|
BillingCareerXS |
"Rackham" |
|
|
UnitMultiplier |
"1" |
|
|
AcadYear |
"2017" |
|
|
AcadGroupAdvis |
" " |
|
|
CurResidentTerms |
"0" |
|
|
TrfResidentTerms |
"0" |
|
|
CumResidentTerms |
"0" |
|
|
RefundPct |
"0" |
|
|
RefundScheme |
" " |
|
|
ProRataEligible |
"N" |
|
|
FullyEnrlDt |
"September 24, 2017" |
|
|
EnrlOnTransDt |
"March 27, 2018" |
|
|
StatsOnTransDt |
"December 11, 2017" |
|
|
FullyGradedDt |
"January 9, 2018" |
|
|
ExtOrgID |
" " |
|
|
ExtOrgIDDE |
" " |
|
|
ExtOrgIDDS |
" " |
|
|
Country |
" " |
|
|
StudyAgreement |
" " |
|
|
StartDate |
" " |
|
|
EndDate |
" " |
|
|
MaxCrseCount |
"0" |
|
|
CurGpa |
"7.25" |
|
|
CumGpa |
"7.25" |
|
|
Registered |
" " |
|
|
RegisteredXL |
" " |
|
|
RegisteredXS |
" " |
|
|
OvrdTuitGroup |
" " |
|
|
OvrdWdrwSched |
" " |
|
|
TuitionResTerms |
"0" |
|
|
OvrdInitAddFee |
"N" |
|
|
OvrdInitEnrFee |
"Y" |
|
|
StdActnEffdt |
" " |
|
|
StdActnEffseq |
" " |
|
|
AcadStndngActn |
" " |
|
|
AcadStndngActnDE |
" " |
|
|
AcadStndngActnDS |
" " |
|
|
OverrideManual |
" " |
|
|
AcadProg |
" " |
|
|
AcadProgDE |
" " |
|
|
AcadProgDS |
" " |
|
|
AcadStndngStat |
" " |
|
|
AcadStndngStatXL |
" " |
|
|
AcadStndngStatXS |
" " |
|
|
ActionDt |
" " |
|
|
Oprid |
" " |
|
|
ProgEffdt |
"August 19, 2017" |
|
|
ProgEffseq |
"0" |
|
|
Institution |
"UMICH" |
|
|
InstitutionDE |
"University of Michigan" |
|
|
InstitutionDS |
"U of Mich" |
|
|
AcadProg1 |
"00114" |
|
|
AcadProgDE1 |
"Chemical Engineering Doc" |
|
|
AcadProgDS1 |
"Chem -Ph.D" |
|
|
ProgStatus |
"AC" |
|
|
ProgStatusXL |
"Active in Program" |
|
|
ProgStatusXS |
"Active" |
|
|
ProgAction |
"DATA" |
|
|
ProgActionDE |
"Data Change" |
|
|
ProgActionDS |
"Data Chg" |
|
|
ActionDt |
"August 19, 2017" |
|
|
ProgReason |
"SYS" |
|
|
ProgReasonDE |
"System Generated Action" |
|
|
ProgReasonDS |
"SysGenActn" |
|
|
AdmitTerm |
"2210" |
|
|
AdmitTermDE |
"Fall 2018" |
|
|
AdmitTermDS |
"FA 2018" |
|
|
ExpGradTerm |
"2250" |
|
|
ExpGradTermDE |
"Winter 2019" |
|
|
ExpGradTermDS |
"WN 2019" |
|
|
ReqTerm |
"2210" |
|
|
ReqTermDE |
"Fall 2018" |
|
|
ReqTermDS |
"FA 2018" |
|
|
AcadLoadAppr |
"F" |
|
|
AcadLoadApprXL |
"Full-Time" |
|
|
AcadLoadApprXS |
"Full-Time" |
|
|
Campus |
"A" |
|
|
CampusDE |
"Ann Arbor Campus" |
|
|
CampusDS |
"Ann Arbor" |
|
|
DegrChkoutStat |
" " |
|
|
DegrChkoutStatXL |
" " |
|
|
DegrChkoutStatXS |
" " |
|
|
CompletionTerm |
" " |
|
|
CompletionTermDE |
" " |
|
|
CompletionTermDS |
" " |
|
|
AcadProgDual |
" " |
|
|
AcadProgDualDE |
" " |
|
|
AcadProgDualDS |
" " |
|
|
JointProgAppr |
"N" |
|
|
AdmApplNbr |
"11112222" |
|
|
ApplProgNbr |
"0" |
|
|
DataFromAdmAppl |
"N" |
|
|
AcadPlan1 |
"1250PHD" |
|
|
AcadPlanDE1 |
"Chemical Engineering PhD" |
|
|
AcadPlanDS1 |
"Chem Eng" |
|
|
PlanDeclareDT1 |
"January 3, 2017" |
|
|
PlanSequence1 |
"1" |
|
|
PlanReqTerm1 |
"2210" |
|
|
PlanReqTermDE1 |
"Fall 2018" |
|
|
PlanReqTermDS1 |
"FA 2018" |
|
|
PlanCompletnTerm1 |
" " |
|
|
PlanCompletnTermDE1 |
" " |
|
|
PlanCompletnTermDS1 |
" " |
|
|
StdntDegr1 |
" " |
|
|
PlanDegChkoutStat1 |
" " |
|
|
PlanDegChkoutStatXL1 |
" " |
|
|
PlanDegChkoutStatXS1 |
" " |
|
|
AcadSubPlan11 |
" " |
|
|
AcadSubPlanDE11 |
" " |
|
|
AcadSubPlanDS11 |
" " |
|
|
SubPlanDeclareDt11 |
" " |
|
|
SubPlanReqTerm11 |
" " |
|
|
SubPlanReqTermDE11 |
" " |
|
|
SubPlanReqTermDS11 |
" " |
|
|
AcadSubPlan12 |
" " |
|
|
AcadSubPlanDE12 |
" " |
|
|
AcadSubPlanDS12 |
" " |
|
|
SubPlanDeclareDt12 |
" " |
|
|
SubPlanReqTerm12 |
" " |
|
|
SubPlanReqTermDE12 |
" " |
|
|
SubPlanReqTermDS12 |
" " |
|
|
AcadSubPlan13 |
" " |
|
|
AcadSubPlanDE13 |
" " |
|
|
AcadSubPlanDS13 |
" " |
|
|
SubPlanDeclareDt13 |
" " |
|
|
SubPlanReqTerm13 |
" " |
|
|
SubPlanReqTermDE13 |
" " |
|
|
SubPlanReqTermDS13 |
" " |
|
|
AcadSubPlan14 |
" " |
|
|
AcadSubPlanDE14 |
" " |
|
|
AcadSubPlanDS14 |
" " |
|
|
SubPlanDeclareDt14 |
" " |
|
|
SubPlanReqTerm14 |
" " |
|
|
SubPlanReqTermDE14 |
" " |
|
|
SubPlanReqTermDS14 |
" " |
|
|
AcadSubPlan15 |
" " |
|
|
AcadSubPlanDE15 |
" " |
|
|
AcadSubPlanDS15 |
" " |
|
|
SubPlanDeclareDt15 |
" " |
|
|
SubPlanReqTerm15 |
" " |
|
|
SubPlanReqTermDE15 |
" " |
|
|
SubPlanReqTermDS15 |
" " |
|
|
AcadPlan2 |
" " |
|
|
AcadPlanDE2 |
" " |
|
|
AcadPlanDS2 |
" " |
|
|
PlanDeclareDT2 |
" " |
|
|
PlanSequence2 |
" " |
|
|
PlanReqTerm2 |
" " |
|
|
PlanReqTermDE2 |
" " |
|
|
PlanReqTermDS2 |
" " |
|
|
PlanCompletnTerm2 |
" " |
|
|
PlanCompletnTermDE2 |
" " |
|
|
PlanCompletnTermDS2 |
" " |
|
|
StdntDegr2 |
" " |
|
|
PlanDegChkoutStat2 |
" " |
|
|
PlanDegChkoutStatXL2 |
" " |
|
|
PlanDegChkoutStatXS2 |
" " |
|
|
AcadSubPlan21 |
" " |
|
|
AcadSubPlanDE21 |
" " |
|
|
AcadSubPlanDS21 |
" " |
|
|
SubPlanDeclareDt21 |
" " |
|
|
SubPlanReqTerm21 |
" " |
|
|
SubPlanReqTermDE21 |
" " |
|
|
SubPlanReqTermDS21 |
" " |
|
|
AcadSubPlan22 |
" " |
|
|
AcadSubPlanDE22 |
" " |
|
|
AcadSubPlanDS22 |
" " |
|
|
SubPlanDeclareDt22 |
" " |
|
|
SubPlanReqTerm22 |
" " |
|
|
SubPlanReqTermDE22 |
" " |
|
|
SubPlanReqTermDS22 |
" " |
|
|
AcadSubPlan23 |
" " |
|
|
AcadSubPlanDE23 |
" " |
|
|
AcadSubPlanDS23 |
" " |
|
|
SubPlanDeclareDt23 |
" " |
|
|
SubPlanReqTerm23 |
" " |
|
|
SubPlanReqTermDE23 |
" " |
|
|
SubPlanReqTermDS23 |
" " |
|
|
AcadSubPlan24 |
" " |
|
|
AcadSubPlanDE24 |
" " |
|
|
AcadSubPlanDS24 |
" " |
|
|
SubPlanDeclareDt24 |
" " |
|
|
SubPlanReqTerm24 |
" " |
|
|
SubPlanReqTermDE24 |
" " |
|
|
SubPlanReqTermDS24 |
" " |
|
|
AcadSubPlan25 |
" " |
|
|
AcadSubPlanDE25 |
" " |
|
|
AcadSubPlanDS25 |
" " |
|
|
SubPlanDeclareDt25 |
" " |
|
|
SubPlanReqTerm25 |
" " |
|
|
SubPlanReqTermDE25 |
" " |
|
|
SubPlanReqTermDS25 |
" " |
|
|
AcadPlan3 |
" " |
|
|
AcadPlanDE3 |
" " |
|
|
AcadPlanDS3 |
" " |
|
|
PlanDeclareDT3 |
" " |
|
|
PlanSequence3 |
" " |
|
|
PlanReqTerm3 |
" " |
|
|
PlanReqTermDE3 |
" " |
|
|
PlanReqTermDS3 |
" " |
|
|
PlanCompletnTerm3 |
" " |
|
|
PlanCompletnTermDE3 |
" " |
|
|
PlanCompletnTermDS3 |
" " |
|
|
StdntDegr3 |
" " |
|
|
PlanDegChkoutStat3 |
" " |
|
|
PlanDegChkoutStatXL3 |
" " |
|
|
PlanDegChkoutStatXS3 |
" " |
|
|
AcadSubPlan31 |
" " |
|
|
AcadSubPlanDE31 |
" " |
|
|
AcadSubPlanDS31 |
" " |
|
|
SubPlanDeclareDt31 |
" " |
|
|
SubPlanReqTerm31 |
" " |
|
|
SubPlanReqTermDE31 |
" " |
|
|
SubPlanReqTermDS31 |
" " |
|
|
AcadSubPlan32 |
" " |
|
|
AcadSubPlanDE32 |
" " |
|
|
AcadSubPlanDS32 |
" " |
|
|
SubPlanDeclareDt32 |
" " |
|
|
SubPlanReqTerm32 |
" " |
|
|
SubPlanReqTermDE32 |
" " |
|
|
SubPlanReqTermDS32 |
" " |
|
|
AcadSubPlan33 |
" " |
|
|
AcadSubPlanDE33 |
" " |
|
|
AcadSubPlanDS33 |
" " |
|
|
SubPlanDeclareDt33 |
" " |
|
|
SubPlanReqTerm33 |
" " |
|
|
SubPlanReqTermDE33 |
" " |
|
|
SubPlanReqTermDS33 |
" " |
|
|
AcadSubPlan34 |
" " |
|
|
AcadSubPlanDE34 |
" " |
|
|
AcadSubPlanDS34 |
" " |
|
|
SubPlanDeclareDt34 |
" " |
|
|
SubPlanReqTerm34 |
" " |
|
|
SubPlanReqTermDE34 |
" " |
|
|
SubPlanReqTermDS34 |
" " |
|
|
AcadSubPlan35 |
" " |
|
|
AcadSubPlanDE35 |
" " |
|
|
AcadSubPlanDS35 |
" " |
|
|
SubPlanDeclareDt35 |
" " |
|
|
SubPlanReqTerm35 |
" " |
|
|
SubPlanReqTermDE35 |
" " |
|
|
SubPlanReqTermDS35 |
" " |
|
|
AcadPlan4 |
" " |
|
|
AcadPlanDE4 |
" " |
|
|
AcadPlanDS4 |
" " |
|
|
PlanDeclareDT4 |
" " |
|
|
PlanSequence4 |
" " |
|
|
PlanReqTerm4 |
" " |
|
|
PlanReqTermDE4 |
" " |
|
|
PlanReqTermDS4 |
" " |
|
|
PlanCompletnTerm4 |
" " |
|
|
PlanCompletnTermDE4 |
" " |
|
|
PlanCompletnTermDS4 |
" " |
|
|
StdntDegr4 |
" " |
|
|
PlanDegChkoutStat4 |
" " |
|
|
PlanDegChkoutStatXL4 |
" " |
|
|
PlanDegChkoutStatXS4 |
" " |
|
|
AcadSubPlan41 |
" " |
|
|
AcadSubPlanDE41 |
" " |
|
|
AcadSubPlanDS41 |
" " |
|
|
SubPlanDeclareDt41 |
" " |
|
|
SubPlanReqTerm41 |
" " |
|
|
SubPlanReqTermDE41 |
" " |
|
|
SubPlanReqTermDS41 |
" " |
|
|
AcadSubPlan42 |
" " |
|
|
AcadSubPlanDE42 |
" " |
|
|
AcadSubPlanDS42 |
" " |
|
|
SubPlanDeclareDt42 |
" " |
|
|
SubPlanReqTerm42 |
" " |
|
|
SubPlanReqTermDE42 |
" " |
|
|
SubPlanReqTermDS42 |
" " |
|
|
AcadSubPlan43 |
" " |
|
|
AcadSubPlanDE43 |
" " |
|
|
AcadSubPlanDS43 |
" " |
|
|
SubPlanDeclareDt43 |
" " |
|
|
SubPlanReqTerm43 |
" " |
|
|
SubPlanReqTermDE43 |
" " |
|
|
SubPlanReqTermDS43 |
" " |
|
|
AcadSubPlan44 |
" " |
|
|
AcadSubPlanDE44 |
" " |
|
|
AcadSubPlanDS44 |
" " |
|
|
SubPlanDeclareDt44 |
" " |
|
|
SubPlanReqTerm44 |
" " |
|
|
SubPlanReqTermDE44 |
" " |
|
|
SubPlanReqTermDS44 |
" " |
|
|
AcadSubPlan45 |
" " |
|
|
AcadSubPlanDE45 |
" " |
|
|
AcadSubPlanDS45 |
" " |
|
|
SubPlanDeclareDt45 |
" " |
|
|
SubPlanReqTerm45 |
" " |
|
|
SubPlanReqTermDE45 |
" " |
|
|
SubPlanReqTermDS45 |
" " |
|
|
AcadPlan5 |
" " |
|
|
AcadPlanDE5 |
" " |
|
|
AcadPlanDS5 |
" " |
|
|
PlanDeclareDT5 |
" " |
|
|
PlanSequence5 |
" " |
|
|
PlanReqTerm5 |
" " |
|
|
PlanReqTermDE5 |
" " |
|
|
PlanReqTermDS5 |
" " |
|
|
PlanCompletnTerm5 |
" " |
|
|
PlanCompletnTermDE5 |
" " |
|
|
PlanCompletnTermDS5 |
" " |
|
|
StdntDegr5 |
" " |
|
|
PlanDegChkoutStat5 |
" " |
|
|
PlanDegChkoutStatXL5 |
" " |
|
|
PlanDegChkoutStatXS5 |
" " |
|
|
AcadSubPlan51 |
" " |
|
|
AcadSubPlanDE51 |
" " |
|
|
AcadSubPlanDS51 |
" " |
|
|
SubPlanDeclareDt51 |
" " |
|
|
SubPlanReqTerm51 |
" " |
|
|
SubPlanReqTermDE51 |
" " |
|
|
SubPlanReqTermDS51 |
" " |
|
|
AcadSubPlan52 |
" " |
|
|
AcadSubPlanDE52 |
" " |
|
|
AcadSubPlanDS52 |
" " |
|
|
SubPlanDeclareDt52 |
" " |
|
|
SubPlanReqTerm52 |
" " |
|
|
SubPlanReqTermDE52 |
" " |
|
|
SubPlanReqTermDS52 |
" " |
|
|
AcadSubPlan53 |
" " |
|
|
AcadSubPlanDE53 |
" " |
|
|
AcadSubPlanDS53 |
" " |
|
|
SubPlanDeclareDt53 |
" " |
|
|
SubPlanReqTerm53 |
" " |
|
|
SubPlanReqTermDE53 |
" " |
|
|
SubPlanReqTermDS53 |
" " |
|
|
AcadSubPlan54 |
" " |
|
|
AcadSubPlanDE54 |
" " |
|
|
AcadSubPlanDS54 |
" " |
|
|
SubPlanDeclareDt54 |
" " |
|
|
SubPlanReqTerm54 |
" " |
|
|
SubPlanReqTermDE54 |
" " |
|
|
SubPlanReqTermDS54 |
" " |
|
|
AcadSubPlan55 |
" " |
|
|
AcadSubPlanDE55 |
" " |
|
|
AcadSubPlanDS55 |
" " |
|
|
SubPlanDeclareDt55 |
" " |
|
|
SubPlanReqTerm55 |
" " |
|
|
SubPlanReqTermDE55 |
" " |
|
|
SubPlanReqTermDS55 |
" " |
|
|
AdvisorRole1 |
" " |
|
|
AdvisorRoleXL1 |
" " |
|
|
AdvisorRoleXS1 |
" " |
|
|
StdntAdvisorNbr1 |
" " |
|
|
AdvrAcadProg1 |
" " |
|
|
AdvrAcadProgDE1 |
" " |
|
|
AdvrAcadProgDS1 |
" " |
|
|
AdvisorID1 |
" " |
|
|
AdvisorIDName1 |
" " |
|
|
AdvisorIDNamePrefix1 |
" " |
|
|
AdvisorIDNameSuffix1 |
" " |
|
|
AdvisorIDNameResult1 |
" " |
|
|
AdvisorIDFirstName1 |
" " |
|
|
AdvisorIDMiddleName1 |
" " |
|
|
AdvisorIDLastName1 |
" " |
|
|
AdvrAcadPlan1 |
" " |
|
|
AdvrAcadPlanDE1 |
" " |
|
|
AdvrAcadPlanDS1 |
" " |
|
|
ApproveEnrlmt1 |
" " |
|
|
ApproveGrad1 |
" " |
|
|
GradApproved1 |
" " |
|
|
CommitteeID1 |
" " |
|
|
CommitteeIDDE1 |
" " |
|
|
CommPersCd1 |
" " |
|
|
AdvisorRole2 |
" " |
|
|
AdvisorRoleXL2 |
" " |
|
|
AdvisorRoleXS2 |
" " |
|
|
StdntAdvisorNbr2 |
" " |
|
|
AdvrAcadProg2 |
" " |
|
|
AdvrAcadProgDE2 |
" " |
|
|
AdvrAcadProgDS2 |
" " |
|
|
AdvisorID2 |
" " |
|
|
AdvisorIDName2 |
" " |
|
|
AdvisorIDNamePrefix2 |
" " |
|
|
AdvisorIDNameSuffix2 |
" " |
|
|
AdvisorIDNameResult2 |
" " |
|
|
AdvisorIDFirstName2 |
" " |
|
|
AdvisorIDMiddleName2 |
" " |
|
|
AdvisorIDLastName2 |
" " |
|
|
AdvrAcadPlan2 |
" " |
|
|
AdvrAcadPlanDE2 |
" " |
|
|
AdvrAcadPlanDS2 |
" " |
|
|
ApproveEnrlmt2 |
" " |
|
|
ApproveGrad2 |
" " |
|
|
GradApproved2 |
" " |
|
|
CommitteeID2 |
" " |
|
|
CommitteeIDDE2 |
" " |
|
|
CommPersCd2 |
" " |
|
|
AdvisorRole3 |
" " |
|
|
AdvisorRoleXL3 |
" " |
|
|
AdvisorRoleXS3 |
" " |
|
|
StdntAdvisorNbr3 |
" " |
|
|
AdvrAcadProg3 |
" " |
|
|
AdvrAcadProgDE3 |
" " |
|
|
AdvrAcadProgDS3 |
" " |
|
|
AdvisorID3 |
" " |
|
|
AdvisorIDName3 |
" " |
|
|
AdvisorIDNamePrefix3 |
" " |
|
|
AdvisorIDNameSuffix3 |
" " |
|
|
AdvisorIDNameResult3 |
" " |
|
|
AdvisorIDFirstName3 |
" " |
|
|
AdvisorIDMiddleName3 |
" " |
|
|
AdvisorIDLastName3 |
" " |
|
|
AdvrAcadPlan3 |
" " |
|
|
AdvrAcadPlanDE3 |
" " |
|
|
AdvrAcadPlanDS3 |
" " |
|
|
ApproveEnrlmt3 |
" " |
|
|
ApproveGrad3 |
" " |
|
|
GradApproved3 |
" " |
|
|
CommitteeID3 |
" " |
|
|
CommitteeIDDE3 |
" " |
|
|
CommPersCd3 |
" " |
|
new |
AdvisorRole4 |
" " |
|
new |
AdvisorRoleXL4 |
" " |
|
new |
AdvisorRoleXS4 |
" " |
|
new |
StdntAdvisorNbr4 |
" " |
|
new |
AdvrAcadProg4 |
" " |
|
new |
AdvrAcadProgDE4 |
" " |
|
new |
AdvrAcadProgDS4 |
" " |
|
new |
AdvisorID4 |
" " |
|
new |
AdvisorIDName4 |
" " |
|
new |
AdvisorIDNamePrefix4 |
" " |
|
new |
AdvisorIDNameSuffix4 |
" " |
|
new |
AdvisorIDNameResult4 |
" " |
|
new |
AdvisorIDFirstName4 |
" " |
|
new |
AdvisorIDMiddleName4 |
" " |
|
new |
AdvisorIDLastName4 |
" " |
|
new |
AdvrAcadPlan4 |
" " |
|
new |
AdvrAcadPlanDE4 |
" " |
|
new |
AdvrAcadPlanDS4 |
" " |
|
new |
ApproveEnrlmt4 |
" " |
|
new |
ApproveGrad4 |
" " |
|
new |
GradApproved4 |
" " |
|
new |
CommitteeID4 |
" " |
|
new |
CommitteeIDDE4 |
" " |
|
new |
CommPersCd4 |
" " |
|
new |
AdvisorRole5 |
" " |
|
new |
AdvisorRoleXL5 |
" " |
|
new |
AdvisorRoleXS5 |
" " |
|
new |
StdntAdvisorNbr5 |
" " |
|
new |
AdvrAcadProg5 |
" " |
|
new |
AdvrAcadProgDE5 |
" " |
|
new |
AdvrAcadProgDS5 |
" " |
|
new |
AdvisorID5 |
" " |
|
new |
AdvisorIDName5 |
" " |
|
new |
AdvisorIDNamePrefix5 |
" " |
|
new |
AdvisorIDNameSuffix5 |
" " |
|
new |
AdvisorIDNameResult5 |
" " |
|
new |
AdvisorIDFirstName5 |
" " |
|
new |
AdvisorIDMiddleName5 |
" " |
|
new |
AdvisorIDLastName5 |
" " |
|
new |
AdvrAcadPlan5 |
" " |
|
new |
AdvrAcadPlanDE5 |
" " |
|
new |
AdvrAcadPlanDS5 |
" " |
|
new |
ApproveEnrlmt5 |
" " |
|
new |
ApproveGrad5 |
" " |
|
new |
GradApproved5 |
" " |
|
new |
CommitteeID5 |
" " |
|
new |
CommitteeIDDE5 |
" " |
|
new |
CommPersCd5 |
" " |
|
new |
AdvisorRole6 |
" " |
|
new |
AdvisorRoleXL6 |
" " |
|
new |
AdvisorRoleXS6 |
" " |
|
new |
StdntAdvisorNbr6 |
" " |
|
new |
AdvrAcadProg6 |
" " |
|
new |
AdvrAcadProgDE6 |
" " |
|
new |
AdvrAcadProgDS6 |
" " |
|
new |
AdvisorID6 |
" " |
|
new |
AdvisorIDName6 |
" " |
|
new |
AdvisorIDNamePrefix6 |
" " |
|
new |
AdvisorIDNameSuffix6 |
" " |
|
new |
AdvisorIDNameResult6 |
" " |
|
new |
AdvisorIDFirstName6 |
" " |
|
new |
AdvisorIDMiddleName6 |
" " |
|
new |
AdvisorIDLastName6 |
" " |
|
new |
AdvrAcadPlan6 |
" " |
|
new |
AdvrAcadPlanDE6 |
" " |
|
new |
AdvrAcadPlanDS6 |
" " |
|
new |
ApproveEnrlmt6 |
" " |
|
new |
ApproveGrad6 |
" " |
|
new |
GradApproved6 |
" " |
|
new |
CommitteeID6 |
" " |
|
new |
CommitteeIDDE6 |
" " |
|
new |
CommPersCd6 |
" " |
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 |
" " |