...

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:

...

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

...

_{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','hs_city', 'hs_state')
 ))application' 
   AND cae.field = 'hs_edu_level' 
   and ca.tstmp_create > '2025-01-01' group by source, appccc_id;

...

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_infromationsociodemographic_vw 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 910: 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 1011: 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.

...