OBIEE - Change Log - Maintenance

2025/01/09

Updates to O365 subject area to release OKTA MFA Discontinuation of Phone SMS/Voice Support data

2024/12/05

Added Region Sub-Region, etc to Student Demographics table in census, Added Grad Prof columns to SDW Student Degree Plan

2024/11/25

Added column PRIMARY_ROLE_EMPLOYEE ('Y','N') to O365_EMPLOYEE_DIM and O365_MAILBOX_EMPL_DIM tables + Logic to set the flag = 'N' for Appointed/Hourly/Assistantship employees and students.

2024/11/14

Added UCORE to Student Transfer Course folder in SDW, Added Maximum Term Eligible to Enroll Flag to Student Enrolled folder in SDW, changed logic in the "Unique Headcount for C and Above *" columns to include 'NH' in the Course Grade Official filter, Added ACCT_TTL_LAST_AVAILABLE to FDS_ACCOUNT table and applied it in the RPD for faster & more accurate queries

2024/10/17

Enhanced Student Financials Dashboard GL data, set nulls to 'No CIP Code' for CIP code description inside the RPD

2024/10/10

Added CIP code description, Substatus to Acad Prog/Plan/Sub-Plan tables,  Added 2 columns to ESG_SCHEDULER_VIEW (Units_Maximum, Units_Minimum

2024/09/26

Migrate the dataset, tables, subject area and Visualization to OAC Prod

2024/09/05

Added new first generation calculation in SDW, fixed low income indicator calculation in RPD

2024/08/29

Removed Bookings folder from SDW Student records area

2024/08/22

Implemented outer join for Admissions fact to dimension tables.  Added logic for overall_low_income flag to handle NULL to zero conversion

2024/07/25

Added Service Indicator Comments in Service Indicator table in Student Data Warehouse.

Added student primary program and plan flag based on highest level of degree.

Corrected join in Academic Standing Status Description in Student Data Warehouse.

Added student graduate assistantship data in student data warehouse

Corrected the key columns to non-nullable in Admissions Details academic program and plan and crosswalk in Admissions Snapshot subject area.

Added double-column logic in data model so the prompts in MyWSU Accounting Feed dashboard work much faster.  Added index to the dataset to the report runs much faster.

Added Invest in Cougs dataset in Student Data Warehouse, and added dashboard.

Corrected the missing date join in Admissions Snapshot between fact table and admissions evaluation table so it would show the relevant data at that point in time instead of the entire history.

Corrected Admissions Snapshot Basis Admit data to not use admit term in the join.  Students sometimes defer a term to enroll, and their admit basis may show a different term from the admissions term.  We cannot use the term in the join.  

Added field International_Domestic_Flag to "Student Application Program" and "Student Enrolled":
CASE WHEN "Student Application Program"."WA Residency" = 'NON-D' THEN International_Domestic_Flag = Domestic
CASE WHEN "Student Application Program"."WA Residency" = 'NON-I' THEN International_Domestic_Flag = International
CASE WHEN "Student Application Program"."WA Residency" = 'RES' THEN International_Domestic_Flag = Domestic

CASE WHEN "Student Enrolled Program"."WA Residency" = 'NON-D' THEN International_Domestic_Flag = Domestic
CASE WHEN "Student Enrolled Program"."WA Residency" = 'NON-I' THEN International_Domestic_Flag = International
CASE WHEN "Student Enrolled Program"."WA Residency" = 'RES' THEN International_Domestic_Flag = Domestic

Fixed non-nullable key columns in Adm Snapshot tables (residency, relationship, person_type2)

Added new table SYSADM.ESG_NAMES_DEG_PRF_PRI.This is a variation of the names table.  Each student has 1 name in this table with priority of Degree, Preferred, Primary.  1 term, 1 student, 1 record.  (source table: names)

Modified table SYSADM.ESG_NAMES_PRF_PRI_DEG_FR to SYSADM.ESG_NAMES_PRF_PRI. This is a variation of the names table.  Each student has 1 name in this table with priority of Preferred, Primary.  1 term, 1 student, 1 record.  (source table: names)

Added term code to Student Support Level folder in SDW.  Added Grad Prof columns to Admissions Detail and SDW Academic Plan.  Supporting Tables folder Academic Program - Plan - SubPlan - Degree has most of the columns from the 4 tables, more will be added soon.

Added new table SYSADM.ESG_NAMES_PRF_PRI_DEG_FR .This is a variation of the names table.  Each student has 1 name in this table with priority of Preferred, Primary, Degree, Former.  1 term, 1 student, 1 record.  (source table: names)

Legacy Student Data Warehouse is migrated from Business Objects platform to OBIEE

Added REGION, SUBREGION, INTERMEDIATE-REGION to PS_COUNTRY_TBL@prdetl (sysadm.esg_country_tbl)

Admissions Snapshot subject area.  Rebuilt the fact table, and isir table to improve performance.

Configuration changes. The Usage Tracking feature is enabled. 

Added Academic Year to New Student Profile (URGD) in Census and SDW subject areas
Added Adjusted Admit Type Category Desc to New Student Profile (URGD) in Census and SDW subject areas
Modified logic of derived Graduate and Professional Primary Program Level columns in Student Enrolled folder in Census on certificated programs classification

Added Honors Program Indicator in Student Enrolled folder in SDW
Added derived Graduate and Professional Primary Program Level columns in Student Enrolled folder in Census
Added Early Academic Referral System data in SDW

Hide ISIR Filing SSN in SDW | ISIR Control Data.  Cleaned up RPD errors and warnings (92 errors and warnings → 0 defects).

W_BI_DOB.  Also added a new index to the admissions fact table to speed up processing and lookups between it and the calendar table.  Changed two joins in the rpd, acad_prog and acad_plan term tables.  Joining to the prog_plan snapshot table now instead of directly to the fact table to minimize the optimizer cost of the joins.

Added Session Description to the following reports: 

OBIEE > Dashboards > WSU Data Validation > Teacher Assignment > Group Taught Not 100% Load

OBIEE > Dashboards > WSU Data Validation > Teacher Assignment > Group Taught Primary Instructor

2020/01/09

In Student Data Warehouse subject area | Student Records folder | Class Instructor Individual Taught table.  Logic is modified so all instructors defined in the individualized sections (regardless of whether the instructor is assigned with a student or not) are now included in the table.  Previously only instructors assigned with students are listed.  This change allows early data checking soonest as sections are created and instructors assigned.  Therefore the list of instructors can be validated by departments prior to students signing up for the individualized sections.

In Admissions Snapshot subject area | Student Checklist folder, added Checklist Aid Year column.
In Student Data Warehouse subject area | Person Data | Student Checklist folder, added Checklist Aid Year column.
e.g. if the checklist item is FA2_SC (Scholarship application), then Checklist Aid Year would be the aid year of the student filed scholarship application for.  It is not the necessarily the same as the aid year the student filed FAFSA.

In Census subject area | Student Enrolled folder, added Withdraw Date, and Last Date Attended columns (right below withdraw code/reason columns) and Career Full-time Indicator, Career Full-Time Part-Time, Dual Career Indicator columns (at the end).
We are now having students with dual careers configured in myWSU starting Spring 2018, e.g. PHAR and BUSN.  For those students, the new career specific columns would indicate if the students are full time or part time in the career respectively.  The original IPEDS full time part time columns now has the logic of combining the total credit hours of each dual career student and report if the student is full time or part time overall in one primary career.  This logic is for counting overall university unique headcount enrollment and students full time enrollment status (in preparation especially for Census enrollment reporting).  All dual enrollment data of the students are still retained as it is, as of the snapshot date.

In Student Data Warehouse subject area | Student Records folder, added new table “Student Apply to Graduate”.
In Student Data Warehouse subject area | Student Records folder | Student Enrolled table, added new column MAX TERM FLAG at the end of “Student Enrolled” table.
Student Apply to Graduate table contains the latest data (as of last night) of the students who have applied to graduate.  It is joined into the subject area so you can retrieve all the enrollment, status across all terms of the students. 
Max Term Flag is provided so data users can use it filter out only the enrollment data as of the max term activated term.  This is especially useful if they want to retrieve only the latest cumulative GPA, and the academic program/plan the student would be graduating in.  They can simply use Max Term Flag = Y as a filter.

In Census subject area, added the following new tables related to 2016 SAT Redesigned test scores:
New Student BESTR Score
New Student Avalue Score
New Student SAT Score
New Student SAT Sup Score

The SAT Test prior to March 2016 is called old SAT here.  The 2016 Redesigned SAT Test is called new SAT.
Here is an explanation of those new tables and the related ones (for clarify):

New Student SAT I Score – old SAT test scores
New Student BEST Score – the best score of old SAT, ACT converted into old SAT, and new SAT converted into old SAT
New Student QValue Score – BEST score + high school GPA * 400

New Student SAT Score – new SAT test scores
New Student SAT Sup Score – new SAT Supplementary test scores
New Student BESTR Score – the best score of new SAT, ACT converted into the new SAT, and old SAT converted into new SAT
New Student AValue Score – BESTR score + high school GPA * 400

In Census Subject Area | Class Registration table, added three new columns Last Enrollment Action Code, Action Reason Code and Action Reason Desc.
These will enable you to do some analysis based on the reasons students gave us as to why they dropped/withdrew a class.  Data is available in end of term snapshots, starting this last Fall 2017.