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.

...