Page Comparison

...

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.

...

• 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
FROMedu_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_infromationsociodemographic_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 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

...