Skip to main content

Power BI Report - Graduate Admission Report

Contact
TechnicalReport UserUpdates 1 Example
  • Department: OIT
Office User:of slate@clarkson.eduthe Dean - Technical User 2 Example
    Department: Graduate AdmissionsCRC User: Amy Nevin Org Chart Link: https://directories.clarkson.edu/orgchart/index.php?username=anevin Data Structure Updates
      Department: OIT User: helpdesk@clarkson.edu
      Slate ProcessesDefinitions
      • FormsAcademic 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
            MailingsApps
            • Mailing 1 Name - Link
            • Mailing 2 Name - Link
            QueriesComp. Apps
            • Query 1 Name - Link
            • Query 2 Name - Link
            Source FormatsAdmits
            • Source Format 1 Name - Link
            Other Slate Objects 1Denies
            • Other Slate Object 1 Name - Link
            Other Slate Objects 2Paids
            • 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
              Back to top