Business problem:  

Admission letters are used by our program offices to inform their applicants of their application decisions like admit, deny, admit-pending, admit with merit scholarships, etc. 

To meet the dynamic nature of scholarship terms in the admission letters,  we leverage advanced find queries by the LRM Admin account "lrmadmin,"  AL-Texts by program offices, letter-generation, and decision-publishing background processes in the LRM to make the whole process configurable and sustainable. 

LRM solution: 

The LRM team should maintain the queries to keep them updated with the approved scholarships

For AL-Text editing, the program office should review this article: Build Admission Letters (AL) with Advanced Find Queries and AL-Texts in LRM

To test the AL generation process, you need to create an application with "wsbtest" as the applicant's last name, admit the application with merit in case of scholarships, populate the scholarship fields in the merit section of the application, click the "Create Decision Letter" to generate the decision letter and review the letter in the secure document to verify the content.   

When clicked, the "Create Decision Letter" program will invoke the advanced-find queries to find the set of applications that meet the query certain criteria,  then it will look at the whole AL-Text entity to gather the associated AL-Texts to generate admission letters for those applications. 

BBA BEL/DA Scholarships/Queries/AL-Texts

The following table gathered BBA scholarships, their associated AL-Texts, and queries to make the BBA BEL, DA application decisions with merit scholarship possible: 


Scholarship Names (Triggers the appropriate AL Text)Type of scholarshipLRM AL TEXT - SalutationAL Text BodyAL Text Accept instructionsQuery ImageAL Text Signature BlockApplication NumberReviewed/status
Business Emerging Leaders Scholarship4 year Tuition and feesBBA Direct - Admit SalutationBBA Direct - BEL Admit with MeritBBA Direct - Admit with Merit


BBA Direct - Admit Signature BlockWSBA00000057636Verified in Production
Wisconsin Undergraduate Business Program ScholarshipOne year - non renewableBBA Direct - Admit SalutationBBA Direct - Admit with Merit 1 Year Nonrenewable (formerly BBA Direct-Admit with Merit 1 Year)New  - BBA Direct - Admit with Merit-July accept

 

BBA Direct - Admit Signature BlockWSBA00000057638Verified in Production
Nathan Brand Family Scholarship in Business8 semester award - renew annuallyBBA Direct - Admit SalutationBBA Direct-Admit with Merit-RenewableBBA Direct - Admit with Merit

BBA Direct - Admit Signature BlockWSBA00000057639Verified in Production
Melinda J. Mount ScholarshipWSBA00000057640Verified in Production
Peter A. Leidel Business ScholarshipWSBA00000057641Verified in Production
 Bruce R. Ellig Scholarship in BusinessWSBA00000057642Verified in Production
Curt S. Culver ScholarshipWSBA00000057643Verified in Production
Marotte Family Scholarship in BusinessWSBA00000079832Verified in Production
Campion Family Scholarship WSBA00000079832Verified in Production
Becker Family Scholarship

Kirk Larsen and Kristine Cherek Scholarship WSBA00000079832Verified in Production
Nathan Brand Family Scholarship in Business

Wisconsin School of Business Minority Scholarship WSBA00000079832Verified in Production
Wisconsin School of Business Diversity, Equity, and Inclusion Renewable Scholarship

Rath Foundation Academic Undergraduate ScholarshipFull Cost of AttendanceBBA Direct - Admit SalutationBBA Direct - Admit with Merit Full TuitionBBA Direct - Admit with Merit

BBA Direct - Admit Signature BlockWSBA00000057644Verified in Production
Wisconsin Undergraduate Business Program 2 year Scholarship4 semester award - renew annuallyBBA Direct - Admit SalutationBBA Direct-Admit with Merit-2 Year-RenewableBBA Direct - Admit with Merit-July accept


BBA Direct - Admit Signature BlockWSBA00000057645Verified in Production
Baird Scholarship in Business8 semester award - renew annually with internship bundled in itBBA Direct - Admit Salutation
BBA Direct - Admit with Merit




Wisconsin Undergraduate Business Program Scholarship

WSB Undergraduate Business Scholarship


Wisconsin Undergraduate Business Program 2 year Scholarship



BBA Direct - Admit Salutation
BBA Direct - Admit with Merit-July accept

BBA Direct - Admit with Merit - July Accept





Recurring Process: 

Every year, the LRM and the undergraduate office should review the process to accommodate new scholarships or existing ones with different terms.