Page Comparison

Tables

Refreshed

Course Section, Enrollment, Faculty, Student Basic

5x a week, Monday-Friday (Terms 2207, 2213)

Once a week, on Mondays (Term 2205)

Awards, DSPS, EOPS, SSSP

Once a week, on Mondays (Terms 2205, 2207, 2213)

Student Skill Level (snapshot)

Student Basic Effective Dated Fields (snapshot)

Taken once a week, on Mondays (mostly)Term 2207)

All Tables from 2195, 2197, 2203

On an adhoc basis, based on workflow that incorporates data element and database updates. Probably once a month.

DED #

Issue

Progress

SB107

SB109

SB111

SB113

Skill level - It is unclear how to determine the exact term that reflects the student’s skill level as it appears the score is being updated during a term instead of after.  The effective dating system is acting as an action counter and cannot be used as an effective date.  A snapshot table is being has been created.

In Progress, 6/25/20

CS015

Waitlist Total – Course waitlists totals appears to have a different business practice after opening day that resets them.  It shows fewer students than if you total waitlists by course using the enrollment table.  This is being investigated now.

In Progress, 6/25/20

SB046

This element states Highest Education rom Application for CE students and is expected to be blank for UGRD.  However, UGRD is populating and these values match the first digit of SB049, App_Ugrdhighed.  The value labels and logic are being investigated now.

In Progress, 6/25/20

SB083

Age in Datamart 1 is calculated differently than in Datamart 2.  Please refer to the specific element for more information.

Interim solution proposed, 8/20/20

Financial Aid Indicator

There is no defined financial aid indicator.  An addendum financial aid query is being pulled and can be found at R:\Patrick\FinAid

In Progress, 8/20/20

Some Application Fields

Not all students are populating application data.  Refer to R:\Missing App Data for some resources.  This is being investigated now.

In Progress, 8/6/20