...

Contents

...

Benefits for Researchers

The Student Journey dataset integrates data from CCCApply and CO-MIS, providing researchers with a more comprehensive and accessible view of student information.

With the CCC Data 3.0.0 release, this new database consolidates datasets and simplifies access permissions, eliminating the need to navigate multiple sources. Designed specifically for analyticsdata analysis, it offers allows for the creation of optimized tables that improve query performance and usability.

...

Note: Existing databases and tables outside the Student Journey dataset remain unchanged and will continue to be supported.

Scope of this User Guide

This guide provides detailed information on the Student Journey dataset, including an overview of the data model, data sources, and instructions on how to use it, complete with example queries.

For direct access to the Data Warehouse and information on available datasets, refer to the Data Warehouse Direct Connect Access User Guide at: [CCC Data Warehouse Public Documentation - Confluence].

Student Journey Goals

The Student Journey dataset is designed to:

• Improve the usability and accessibility of student data for researchers.

• Establish clear correlations between CO-MIS and CCCApply data, enabling more comprehensive analysis.

...

• Education

• Contact_Information

• Personal_Information

• Personal_Sociodemographic

Consult the Student Journey Database Data Dictionary to identify the source, table, description, and example values for each data field.

Description of the Schema

...

• apply__mis_associative_entity_vw

• apply__application_vw

• apply__college_attended_vw

• apply__contact_information_vw

• apply__education_vw

• apply__needs_and_interests_vw

• apply__personal_information_vw

• apply__personal_sociodemographic_vw

• student_journey__dictionary_mvw

These tables consolidate data from multiple sources and follow a canonicalized structure to ensure consistency and ease of use.

...

To analyze educational attainment, researchers can use the apply__application_vw and apply__education_vwtables, as this attribute is linked to each student’s college application. The following examples demonstrate how to retrieve this information.

_{Figure 1: Application Table}

The application table includes fields common to all application data sources. The source field specifies the origin of each record, as shown in the table below.

_{Figure 2: Application Source}

The application_education table, linked to the source field, provides additional details on educational background and goals, as shown below.

_{Figure 3: Application Education Table}

...

To determine how many submitted applications include an edu_goal, researchers can perform a left join between the application and application_education tables using the query below.

_{Figure 4: Example Query}

SELECT count(*) as num_applications
  FROM apply__application_vw ca
LEFT JOIN apply__education_vw cae
    ON (ca.app_id = cae.app_id)
WHERE ca.source = 'stnd_application' 
   AND cae.field = 'hs_edu_level' ;

_{Figure 5: Query Result}

To generate a report on educational attainment by student, use the following query:

_{Figure 6: Example Query}

(
SELECT source, appccc_id,max(value)  as   hs_name, hs_city, hs_state
FROM_edu_level
  FROM apply__application_vw ca
LEFT JOIN apply__education_vw cae
PIVOT  (  ON (ca.app_id  max(value= cae.app_id)
FORWHERE fieldca.source IN= ('hsstnd_name',application' 
   AND cae.field = 'hs_city', 'hs_state')
 ))edu_level' 
   and ca.tstmp_create > '2025-01-01' group by source, appccc_id;

Example Query 2: Student Sociodemographic Information

To generate a report on student sociodemographic information, use the following query.

_{Figure 7: Example Query}

SELECT ccc_id,max(value)  as   hs_edu_level
  FROM apply__application_vw ca
LEFT JOIN apply__education_vw cae
    ON (ca.app_id = cae.app_id)
WHERE ca.source = 'stnd_application' 
   AND cae.field = 'hs_edu_level' 
   and ca.tstmp_create > '2025-01-01' group by ccc_id;

This requires data from the apply__application_vw and apply__personal_information_vw tables.

_{Figure 8: apply_personal_Information_vw view}

_{Figure 9: apply_personal_}infromation_{sociodemographic_vw View}

Figure 8: apply_personal_sociodemographic View

By querying these tables, researchers can access attributes related to a student's sociodemographic status. For example, to determine how many students indicated they were married when completing their application, use the following query.

_Figure 9_{10: Marriage Information Query}

SELECT pi.app_id,sd.field,sd.value ,pi.value last_name FROM apply__personal_sociodemographic_vw sd inner join
apply__personal_information_vw pi on pi.app_id=sd.app_id where sd.field='married_or_rdp'
and pi.field='lastname';

This query returns the following results:

_Figure 10_{11: Query Results}

...

For details on connecting to the Data Warehouse and accessing current datasets, refer to the Data Warehouse Direct Connect Access User Guide at: [CCC Data Warehouse Public Documentation - Confluence].. 

Student Journey Application Database Name and Schema Format

...

select * from student_journey.public.apply__mis_associative_entity limit 10;

General Data Warehouse Help

If you need assistance with the CCC Data Warehouse, visit the http://CCCTechnology.info  support channel. There, you can receive help from the Enabling Services Support (ESS) team and collaborate with other colleges and districts on using the CCC Data Warehouse.

...