Overview
This article goes over how one may generate a Diploma List of the Registrar Office
Resolution
Internal Only
1. In SQL Server Management Studio connect to server sql12-n1.
2. Execute procedures isrsdb.dbo.DiplomaCertficates, isrsdb.dbo.DiplomaCertificatesGrad, isrsdb.dbo.DiplomaDegreeGrad, isrsdb.dbo.DiplomaDegreesUndergrad.
3. Paste results to Excel worksheets.
4. In Excel format column tech_id to 8 digits with leading zeros and column deg_level to 2 digits with leading zeros.
5. Save workbook.