SAH-LMS-SubmissionEvent-View

Epic:  

• Assignment Due At Date
• Quiz Submission Due At Date

SAH-Demographics-View & SAH-Demographics-IR-View

Epic:  

• College Attended Release Restriction
• Current Academic Term Code
• Date of Birth Release Restriction
• Dates of Attendance Release Restriction
• Degree honors Received Release Restriction
• Degrees Received Release Restriction
• Graduate Attempted Units Current Cumulative
• Graduate Completed Units Current Cumulative
• Graduate Grade Point Units Current Cumulative
• Graduate Grade Points Current Cumulative
• Graduate Passed Units Current Cumulative
• International Directory Release Restriction
• Major Release Restriction
• Nat'l Student Clearing House Release Restriction = we are actively working to load this field so it may be empty for a few days during UAT
• Next Academic Term Code
• Officially Recognized Activities Release Restriction
• Permanent Mailing Address Release Restriction
• Permanent Telephone Release Restriction
• Prior Fall Term Code
• Prior Spring Term Code
• Prior Winter Term Code
• Student Classification First
• Student Name Release Restriction
• Student Personal Pronoun
• UCSD Alumni or Development Release Restriction
• UCSD Directory Release Restriction
• UG Attempted Units Current Cumulative
• UG Campus Email Release Restriction
• UG Completed Units Current Cumulative
• UG Current Address Release Restriction
• UG Current Telephone Number Release Restriction
• UG Grade Point Units Current Cumulative
• UG Grade Points Current Cumulative
• UG Passed Units Current Cumulative

These new fields will also be seen in the following views as they are joined with SAH-Demographics-View. See SAH Quick Start Guides for the full list of views.

SAH-StudentStatsPerTerm-View & SAH-StudentStatsPerTermCensus-View

Epic:  

• Attempted Units Term
• Attempted Units Term Cumulative
• Completed Units Term
• Completed Units Term Cumulative
• GPA Term
• GPA Term Cumulative
• Grade Point Units Term
• Grade Point Units Term Cumulative
• Grade Points Term
• Grade Points Term Cumulative
• Passed Units Term
• Passed Units Term Cumulative

These new fields will also be seen in the following views as they are joined with SAH-StudentStatsPerTerm-View or SAH-StudentStatsPerTermCensus-View.  See SAH Quick Start Guides for the full list of views.

Data in UAT is not ready to be shared with end customers, is not considered completely validated and can change suddenly.  For optimal customer satisfaction, do not connect your production solutions to packages / data sources that are in UAT.  If you choose to share UAT items with end customer, be explicit that the data and report is in UAT and can change suddenly or be broken by UAT changes.

• Cognos: Use the packages in Cognos DEV > Student Activity Hub > Student Activity Hub Packages UAT to build your report and select Hana QA.  Do not select Hana Prod as the report will fail.  Using Hana QA will allow you to see the below enhancements with Production data. 
• Tableau: Sign into Tableau on your Tableau desktop tool and open your report.  Add a new data source with the same name and -QA at the end of the title.  Using this data source will allow you to see the below enhancements with Production data.
• Hana QA:  SAH data in Hana QA is production data loaded daily, just like in Hana PROD.

If you find an issue, please include in your email to busintel@ucsd.edu the following:

• What browser are you using?
• What environment are you using?  Cognos DEV, QA or PROD?  Or Tableau?
• What data source / package are you using?
• What results were you expecting?