DED Update Log

Hello Institutional Effectiveness Community!  As our SDCCD_IRD is a work in progress so is our Data Element Dictionary.  This document will help outline our DED updates process and log.

·         The Atlassian page will be screened on a weekly basis for any comments by our IE community.

·         Any data element issues shall be brought to the appropriate district RPA’s attention to resolve.

·         All changes will be reflected in the individual data element’s ‘Known Issues, Related Details, and Other Notes’ and ‘DED Entry Last Updated’ date will be updated.

·         Below will include a list of known data elements issues with a description and progress towards resolution.  There will also be a list of data element updates, data elements under construction and a list of some useful file pathways related to the DED and IRD.

·         Email communication about data element issues shall be saved in the Shared drive for posterity: R:\Datamart\DED_SDCCD_IRD\DED Communication

·         Initially this DED page will be refreshed on an as needed basis but eventually it shall be updated and maintained every six months.

IRD Refresh Cycle (last updated 11/10/20, anticipated until February 2021)

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 (Term 2207)

All Tables from 2195, 2197, 2203

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

Data Element Issues

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 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

Data Element Updates

DED #

Comment

Date

CS030

CS034 is relevant to positive attendance hours.

7/1/20

CS069

CS070

CS071

All three of these data elements are going to have to be updated.  CS70 and CS71 are being repurposed and CS069 is most likely being redefined.

7/1/20

SB015

SB016

SB015 syntax has been provided for appropriate identification of Filipino students.  SB016 description has been corrected.

8/20/20

CS006

A new subject has been added, EXAM, for Challenge exams related to AB705 and right to placement.  These are placeholders and are not considered real enrollments.  They should be excluded.  They are listed in Offerno = 9.

8/20/20

Data Elements Under Construction

Table

Purpose

Progress

Course Section

CS097 – CE Distance Education Hours

CS098 – CCAP (values: Yes or null)

CS099 – ACP (values: Yes or null)

Anticipated for week of 11/16/20

Enrollment

EN030 – Enrollment Designation: (UGRD value: Hnrs  - for honors class, CE/CEHS value: Comp – meaning unclear)

EN031 – CE Distance Education Hours

EN032 – Start Date of Class

EN033 – End Date of a Class

Anticipated for week of 11/16/20

Relevant File Pathways

Purpose

Pathway

IRD Check-in documents

R:\Patrick\IRD Check ins

IRD Training

R:\Campus Solutions Migration\Rethinking and Retesting Datamart\Connections info

R:\Campus Solutions Migration\Rethinking and Retesting Datamart\Hyperion Testing SDCCD_IRD\Meeting Recordings

R:\Campus Solutions Migration\Rethinking and Retesting Datamart\Hyperion Testing SDCCD_IRD\Shared Library for Summer Immersion IRD Workgroup)

R:\Campus Solutions Migration\Rethinking and Retesting Datamart\Hyperion Testing SDCCD_IRD\Logistics

Legacy DED

R:\Datamart\DED_SDCCD_IRD\DED_Legacy

IRD DED (static excel) and DED communication

R:\Datamart\DED_SDCCD_IRD\DED_SDCCD_IRD

Some Syntax

R:\Campus Solutions Portal\CS Syntax

IRD Desired Field List

R:\Campus Solutions Portal\IRD Desired Fields List