...
· 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 (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. |
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 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 |
...
Table | Purpose | Progress | |
Course Section | CCAP Indicator | In Progress, 6/25CS097 – 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
...