Power BI Report - Graduate Admission Report

Contact

• Report Updates
  • Department: Institutional Effectiveness
  • Org Chart Link: https://www.clarkson.edu/organizational-chart?depart=86
• Report Updates 
  • Department: Office of the Dean - CRC
  • User: Amy Nevin
  • Org Chart Link: https://directories.clarkson.edu/orgchart/index.php?username=anevin
• Data Structure Updates
  • Department: OIT
  • User: helpdesk@clarkson.edu

Definitions

• Academic Year
  • Definition: An academic year spans Summer to Spring. Academic Year 2023-24 includes Summer 2023, Summer Quarter 2023, Fall 2023, Fall Quarter 2023, Winter Quarter 2024, Spring 2024 and Spring Quarter 2024. 
  • SQL Logic: Populated by getting the ACAD_YEAR field from PS_TERM_TBL. Visually its changing the display to show CONCAT(ACAD_YEAR-1 ,'-', SUBSTRING(ACAD_YEAR, 2, 2)
• Academic Career
  • Definition: 
  • SQL Logic: SELECT ACAD_CAREER, DESCR FROM PS_ACAD_CAR_TBL where ACAD_CAREER IN (SELECT DISTINCT ACAD_CAREER FROM PS_CU_GRAD_ADM)
• Academic Program
• Academic Plan
• Student Types
  • International
  • Domestic
• Prospects
  • Form 1 Name - Link
  • Form 2 Name - Link
    
• Apps
  • Mailing 1 Name - Link
  • Mailing 2 Name - Link
• Comp. Apps
  • Query 1 Name - Link
  • Query 2 Name - Link
• Admits
  • Source Format 1 Name - Link
• Denies
  • Other Slate Object 1 Name - Link
• Paids
  • Other Slate Object 2 Name - Link
• Declines
• Matrics
• Melt
• Grads

Instructions

1. Instruction 1
2. Instruction 2
3. Instruction 3
4. Instruction 4
5. Instruction 5