Page Comparison

Problem / Issue

Per the recent changes to MIS reporting (see memo from Todd Hoig, March 1, 2018) - additional data fields, currently unavailable via CCCApply, need to be made available to colleges. The CCCApply Steering Committee has called for these fields to be added to the CCCApply Download Client and the CCC Report Center as soon as possible so that colleges can begin reporting this data for Summer 2018 term.

In addition, if the AB620 fields are made available, the onscreen text that appears to students in CCCApply would need to be amended to accurately disclose who has access to the data and how that data is compiled and used. 

Fields that MIS expect to download:

MIS Amended to include new reporting elements (SB amended)

• Sexual Orientation (Want added to downloads, (encrypted) but keep it out of the Report Center) (Adjust the onscreen language)
• Transgender (Want added to the downloads, (encrypted) but keep it out of the Report Center) (Adjust the onscreen language)
• CCCID - You're already getting this now.
• SSID (maybe needed for the on-boarding process) Need support from the CO (Ask Tim to take the lead on this). 
• Apprenticeship status (different levels of apprenticeship and adult ed (maybe part of the AEBG stuff) SB23 - look at this via DED
• memo180302.docx
• SB35.pdf

requirements recently mandated by the CCCCO MIS division (see Memo 3.01.18), CCCApply is being asked to comply with certain requirements regarding data fields that are currently either not being collected, or are being collected but are currently restricted from download (restricted from access) to the CCC colleges based on data sharing agreement restrictions or existing data handling security concerns. Several of the new reporting requirements include adding or amending CCCApply in some way, or will require CCCApply to make previously restricted data fields (AB620) available, or may require CCCApply to actually remove questions - assuming the data can be collected at different points in the matriculation process. These data requirements and solutions are currently being reviewed and approved by the CCCApply Steering Committee, the CCCCO, and the CCC Tech Center.

This change request captures details pertaining to the MIS requirements listed below:

CCCApply should be revised to comply with MIS reporting requirements outlined in the Memo 03.01.18, which include the elements below:

• Sexual Orientation (See Approved Change Solution: /wiki/spaces/OPENAPPLY/pages/173501157)
• Transgender  (See Approved Change Solution: 2018-16R: Make AB620 Data Fields Available to Colleges Using Project Glue)
• CCCID - NOTE:  Colleges are already downloading this field through CCCApply now. 
• SSID - (NOTE:  Currently this field is restricted from access/download via CCCApply per a data sharing agreement with the CDE. However, this agreement is currently being reviewed and petitioned to be revised in order to comply with MIS and new CCGI + MMAP web service agreement, currently under-development.) 
• Apprenticeship status (NOTE:  This field is not required from CCCApply.) being reviewed by Steering and the CO to better understand if CCCApply is the best vehicle to collect and store this data. See below for details. ) Allow different types 
• See Other fields that follow Adult Ed (data elements) -

•  which appear to be a large list of questions that will add a great deal of questions to the application

Not yet updated on the CO MIS website (should be updated by August 2018)

Questions to the Apply development team (via Tim/Patty)

• How quickly could we get the AB620 fields into the downloads?
• How quickly could we get the AB620 fields into the Report Center?  NOT APPROVED
• If we added these fields into the RC, would colleges be able to run a report going back to November 2017?

Need a way for researchers and admissions to get that data from Report Center (user accounts). 
Need it for the Summer 2018 (so each college needs this data based on their Summer term dates). 

NEED to prepare change requirements
Onscreen language that needs to be reviewed:

• This information is only used for summary demographic reporting.
• Your responses are kept private and secure.
• Providing this information is optional.
• It is not available to admissions personnel and will not be used for a discriminatory purpose.

Proposed Solution

UPDATE: 4.26.18

Per direction from Omid P., access to the sensitive and currently encrypted AB620 data fields should NOT be added to the download client or the CCC Report Center, as both instruments have been deemed insecure for transmission of this data.  

The approved solutions are:

1. Deliver CCCApply data (including unecrypted LGBTQ fields) to participating colleges via the Glue College Adaptor. Development is underway to implement this solution as early as June 29, 2018. 
2. Allow approved researchers access to the data via the new Data Warehouse system, due to be launched in conjunction with the late June release.

Colleges can access the data via the Data Warehouse while integrating the Glue College Adaptor.

For the second part of this request, to update the onscreen text/language of disclosure to students about access and use of the data will be DEFERRED - until the two alternative distribution systems have been implemented to best determine the requirements for update of this text.

Supporting Documentation

New MIS Data Elements & Reporting Changes

SB Student Basic Data Reporting

1. SB23 STUDENT-APPRENTICESHIP-STATUS has been amended
2. SB34 STUDENT-CCC-ID has been added
3. SB35 STUDENT-SS-ID has been added
4. SB36 STUDENT-TRANSGENDER has been added
5. SB37 STUDENT-SEXUAL-ORIENTATION has been added

SC Student CalWORKs Data Reporting

A new element has been added.

SC18 ELIGIBILITY-TIME-LIMIT-STATUS has been added

(To support Adult Ed.)

SG Special Populations Data Reporting

SF and FA Student Financial Aid Reporting

An existing element has been amended.

Coming for 2018-19: New award program coming. Won't affect CCCApply or Promise Grant applications, but is coming.:

SA Student Assessment Data Reporting

• SA07 STUDENT-EDUCATIONAL-FUNCTION-LEVEL has been added

Using federal instruments, used to track student progress. Shouldn't affect CCCApply.

Solutions

Relative to the remaining new data elements being added or amended, the review process has begun to determine which of these affect CCCApply and which, if any, will require changes to our existing application specification.  

Questions for Steering Review:

1. What additional data fields are required beyond the bulleted list in the SB - Student Basic Data section above?

   Per meeting 5/17/18 - the majority of these data elements are not required to be collected through CCCApply.  The SB data set (4 of 5 elements) could come from Apply and each is specified above.

2. How will the Apprenticeship data be collected?
   Per meeting 5/17/18 - this field is collected via other means outside of CCCApply.
3. Is CCCApply the best avenue to collect this data?
   Though AEGB may want these collected through Apply, most will not be collected via Apply at this time.

Supporting Documentation

memo180302.docx

fwccccomisupdate.zip

SB35.pdf