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.