Configuration changes. The Usage Tracking feature is enabled.
Added Academic Year to New Student Profile (URGD) in Census and SDW subject areas
Added Honors Program Indicator in Student Enrolled folder in SDW
|2023/08/25||In Financial Aid Work Study source tables, payment amount and pay rate were moved to new columns since Workday go live. Modified warehouse ETL so it is getting the data from the right column to populate the warehouse table.|
|2023/05/05||Oracle Analytics Cloud (OAC) service is migrated to Gen 2 Platform. OAC includes OAC Classics (previously known as OBIEE), and Data Visualization.|
More details on Features and Benefits can be found here:
|2022/10/01||MyWSU migrated to AWS platform. Oracle data warehouse ETL job is migrated to extract data from myWSU in AWS.|
|2022/09/01||Legacy Financial Data Warehouse is migrated from Business Objects platform to OBIEE|
|2022/07/14||Added views for Mainframe Finance|
|2022/05/19||Security changes, new views for Mainframe Accounts|
|2022/05/05||Security changes for SDW. Added views t22o Mainframe Snapshot.|
|2022/04/28||Security changes for Surveys, Modernization Crosswalks and OBIEE User Roles. Added a couple views to Mainframe Snapshot|
|2022/04/21||Security changes for Admissions subject area, new views added to Mainframe Accounts subject area|
|2022/04/14||Security changes for Census subject area, various tables added for Mainframe Accounts subject area|
|2022/03/10||Added mainframe subject areas, currently only accessible by W_BI_MAINFRAME_DEV role until user roles are ready.|
|2021/11/08||Modified Veterans Dashboard - New Multi Veteran Report. Copied 8 reports from Leonard Cassidy shared folder into the Veteran dashboard folder to place on this dashboard. Reports are in /Shared Folders/WSU Registrar/New Multi Veteran Report. Confirmed dashboard page/reports are correct per users and Leonard Cassidy.|
|2021/10/22||Added Pronouns to Student Name table in SDW.|
|2021/09/30||Added WD_FUND_FUNCTION_COMBO to Modernization Crosswalks|
|2021/09/16||Opened up Overall Low Income Indicator flag to Answers users|
|2021/09/02||Added additional table/supporting data for Student Support Model per request from Nathan Lindstedt. New table is ESG_STUDENT_SHAP and fields have been merged into the Student Support Level folder in SDW → Person Data.|
|2021/08/26||Added "Registration Appointment" folder to SDW - > Student Records per request from Sue Hopkins. Based off of data from the PS_STDNT_ENRL_APPT view in CS. Added Low Income Indicator to ISIR Summary Data folder.|
|2021/08/19||Added data dictionary entries for Student Support Model, and limited access to SSM to advisors only. Added ENRL_TOT field to PS_W_SCHEDULER_RSRV view per request from Sue Hopkins. Changed join between email address table and Bookings Data folder to outer join so that all records would show even if no matching bookings data.|
|2021/08/05||Added Mainframe Snapshot subject area, limited to AIS activity tables as requested by Bryan Titen and limited to the W_BI_MOD_SUBJ role. Opened up Student Risk folder to W_BI_ADV_STURISK role with select advisors for proof of concept as requested by Nathan Lindstedt. Added Bookings Data folder to SDW subject area → Student Records folder as requested by Anden Lewis and Supraja Jayachanradu.|
|2021/07/08||Added 2 and 4 digit CIP codes and descriptions to Census Student Degree Plan folder. Added Create Maximum Term Enrolled Flag in SDW Student Enrolled table|
|2021/06/24||In SDW Subject Area: Released myWSU accounting project (Jira: MADO) consisting of 18 tables/folders. Includes MWGLI batch and detail tables and associated lookup tables.|
|2021/06/10||In SDW Subject Area: Fixed join between ITEM_SF/ITEM_LINE_SF that had mistakenly been left in DEV RPD and caused a report owned by Leonard Cassidy to break. Verified that the report is now functioning as expected.|
|2021/05/13||In WSU MISC Subject Area: Added view "PS_W_SCHEDULER_RSRV" to facilitate a reserve-capacity specific scheduler report per request from Sue Hopkins.|
|2021/04/22||In WSU MISC Subject Area: Added "STATUS_DT" to PS_W_GRAD_TRACKING_NOTES view per request from Sue Hopkins.|
|2021/04/15||In SDW Subject Area: Changed join between ESG_GRADE_ROSTER and ESG_GRADE_RSTR_TYPE to an outer join to prevent records from falling out when brining in the roster description. Initiated by a request from Nathan Lindstedt in IR.|
|2021/04/08||changed cobblestone_id to an integer in xw_cobblestone_contracts. added class title and units to 'PS_W_SCHED_VW_FLAT. Removed all GL folders (in development) from SDW subject area before bouncing in.|
|2021/03/25||In Census added w_cip_year on tables PS_W_DEGREE, PS_W_XACAD_PLAN and PS_W_XACAD_SUBPLAN. Modified joins to the tables to include the CIP year. Added column WORKDAY_EXT_REPORTING to XW_ACCOUNTS table in Modernizaton Crosswalks.|
|2021/03/18||In the Checklist subfolder of the Person Data folder of SDW, 'Checklist Status' was renamed 'Checklist Status Code', 'Status Description' renamed to read 'Checklist Status Description' and Status Short Description' renamed 'Checklist Status Short Description'. Renamed Item Status to read 'Checklist Item Status Code' and added the columns 'Checklist Item Status Description' and 'Checklist Item Status Short Description'. Added XW_COBBLESTONE_CONTRACTS to the Modernization Crosswalks subject area.|
|2021/03/11||Added GRAD_STATUS_DESCR column to PS_W_GRAD_TRACKING_NOTES view in WSU Misc.|
|2021/03/04||Added LMS, LMS Description, Primary Instruction Section, Primary Instruction Section Description to Class folder in Student Records|
Hide ISIR Filing SSN in SDW | ISIR Control Data. Cleaned up RPD errors and warnings (92 errors and warnings → 0 defects).
|2021/01/28||Added 4 columns to xw_accounts in modernization crosswalks, changed birth date column in SDW | Person Data | New Student Profile (UGRD) to be viewable by only group|
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.
|2021/01/07||Added a snapshot date to crosswalk XW_ACCOUTS. Structure changes to 8 crosswalk tables, 1 new crosswalk table. Additions 4 columns to views PS_W_SCHEDULER_VW_FLAT and PS_W_SCHEDULER_VW for the combined sections ticket.|
|2020/12/13||Changed connection strings in RPD to reflect new prod DB instance. Set DB product features for data source to 12c (previously set to 11g, `19c is not available in the RPD yet).|
|2020/12/03||Changed 12 Modernization Crosswalk tables, various new, deleted, different data types. Added 2 new crosswalk tables. Added new column in ETL so XW_GRANT_RELATED_WORKTAGS can be joined to XW_GRANTS. Reloaded all 94 crosswalk tables from conntest MASTER_SNAP_11212020.|
|2020/11/12||Added 2 new tables to Modernization Crosswalks, plus structure changes to 2 more, reloaded 4 other crosswalk tables|
|2020/10/22||Added more STDNT_CAR_TERM info (CUM_GPA, 8 others) to Student Info in Surveys, added Chromebook and hotspot tables in Surveys, add 12 new table and various table structure changes to the Modernization Crosswalks subject area.|
|2020/10/01||Added ESG_AS_CE_STUDENT_INFO and ESG_AS_CE_COMP_LOANER tables to the Surveys subject area|
|2020/09/24||Changed Covid-19 Survey subject area name to Surveys; added survey_id to each table and join in Surveys subject area.|
|2020/09/10||Added Financial Aid Type, Description to Student Data Warehouse > Financial Aid > Financial Aid Award by Term folder.|
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/08/18||For Exam Note Report under Schedule Builder, removed Enrollment > 0 filter, and changed Approval Ind & Class Status filters to user prompt.|
|2020/08/10||Oracle Analytics Cloud upgraded to Release 5.7.0|
|2020/07/30||added UAT crosswalk table XW_LEGACY_AREA_CCH|
|2020/07/23||Updated Course Enrollment ETL logic, cleaned up data. Added join on CAMPUS between course enrollment folder and stdnt_enrl, removed campus from presentation layer in course enrollment folder.|
|2020/07/16||Add new & modified UAT crosswalk tables, Add folder Student Cancells to Student records, Changed course enrollment snapshot to count distinct rows|
|2020/06/12||Added Facility Capacity to the PS_W_SCHEDULER_VW_FLAT view under WSU MISC subject area. This was an online change due to high priority and low risk. Offline RPD's have been updated as needed to carry the change forward.|
|2020/06/04||Added term begin date, days from start, weeks from start to class/course enrollment snapshots in SDW.|
|2020/05/28||Added new tables to Modernization Crosswalk, refreshed data|
|2020/05/22||Release Covid-19 Survey reporting subject area to production.|
|2020/04/09||Modified the way enrollment reason setup table PS_ENR_RSN_TBL is extracted and joined to the Student Data Warehouse subject area | Student Records folder | Class Registration, to fix some blank description issue.|
|2020/04/02||Added enrollment snapshots to SDW subject area.|
|2020/03/05||Added Final Exam and units to PS_W_SCHED_VW_FEXM, fixed Census join on Class and Class Attributes.|
|2020/01/23||Added Room Characteristics column to CS query Schedule Builder Dashboard > Schedule Builder > Schedule Builder Data.|
|In Student Data Warehouse subject area | Student Records folder | Added two new folders "Student Patient Encounter" and "Student Patient Hours".|
|2019/10/21||Oracle upgraded OBIEE/OAC to version 105.4|
|2019/08/15||In Admissions Data Warehouse subject area | Student Email folder | Added new column "Personal Email Address". Changed hover text for "Preferred Email Address" from "Preferred WSU Email Address" to "Preferred Email Address".|
|2019/08/01||In Student Data Warehouse subject area | Student Records folder | Class folder. Added new column "Schedule Print Flag".|
|2019/07/11||Added ID Sync Log in WSU Misc subject area. Used in OBIEE User Roles Change dashboard report to monitor changes.|
|2019/06/20||In Student Data Warehouse subject area | Person Data folder | Student Name folder. Changed the NAME_DISPLAY column to "First, Last Name" and added new column "First, Middle, Last Name". In Student Data Warehouse subject area | Student Records folder | Class Notes folder. Changed "Class Notes Long Desc" to VARCHAR data type from LONGVARCHAR data type due to incompatibility of LONGVARCHAR data type with new version of OBIEE/OAC.|
|2019/05/18||Migration to OBIEE Reporting on Oracle Analytics Cloud platform.|
|2019/03/21||In Student Data Warehouse subject area | Student Records folder | Class table. Added UCORE column. This is the UCORE category of the class, such as [ARTS] for Inquiry in the Creative and Professional Arts, [HUM] for Inquiry in the Humanities. Writing in the major is included as [M]. The data is derived from class attributes.|
|2019/03/10||myWSU is migrate to Oracle Cloud Infrastructure on the weekend of 2019/03/08. OBIEE Data Warehouse jobs are changed to extract data from the new myWSU production server. Only one Admissions snapshot is skipped (snapshot date 2019-03-08). Admissions snapshot data is caught up as of 2019-03-09. Student Data Warehouse data is also caught up on the same day.|
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.
|2019/02/14||In Census subject area | Class table. Corrected an issue when using Location Desc in detail class sections reports, credit hours and FTE were inflated. The overall totals, however, were never affected.|
Technical Details: This was due to missing Term Code in the join between the underlying Class table and the Location Desc lookup table. The table join is fixed.
|2019/02/08||Scheduled Maintenance: OBIEE is unavailable from noon-1pm to apply Oracle security and maintenance patches.|
In Admissions Snapshot subject area | Student Checklist folder, added Checklist Aid Year column.
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).
In Student Data Warehouse subject area | Student Records folder, added new table “Student Apply to Graduate”.
In Census subject area, added the following new tables related to 2016 SAT Redesigned test scores:
The SAT Test prior to March 2016 is called old SAT here. The 2016 Redesigned SAT Test is called new SAT.
New Student SAT I Score – old SAT test scores
New Student SAT Score – new SAT test scores
In Census Subject Area | Class Registration table, added three new columns Last Enrollment Action Code, Action Reason Code and Action Reason Desc.