Regent Award - Data Views Training Session
Data View Training Session recorded and viewable at the link below. Documents referenced during the training are also below.
Training Video
Training Documents
General
- Regent Award Data Views - Technical Guide
- In the video the presenter reviews a word document. The link above to the Technical Guide is the up-to-date reference for that information.
- Dataview Overview.xlsx
- Regent Award Data View Data Dictionary
- In the video the presenter shows this excel spreadsheet. Use the link above to download it.
SQL Queries
- academicplan_query.sql
- closedPP_withhard and soft.sql
- courseToPP.sql
- compareISIR.sql
- coa.sql
- documentVerfy_ISIRnotVerfy.sql
- EST query with pp and enrollment.sql
- findVerfDate_UsingActivityLogEntry.sql