Student Term (STRM) Merge Fields

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

" "