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
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;

...

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 78: apply_personal_Information_vw view}

_{Figure 89: apply_personal_sociodemographic_vw View}

...

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';

...