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