The Student Journey data model, introduced in the CCC Data Warehouse with the CCC Data 3.0.0 release, consolidates student information from multiple datasets into a unified view for CCC researchers. By integrating data from various sources, it streamlines access, eliminating the need to search through multiple databases and tables. Designed for analytics, this dataset enhances how researchers view, query, and utilize the CCC Data Warehouse.

The Student Journey dataset integrates data from CCCApply and CO-MIS (post-processed files), 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 data analysis, it allows for the creation of optimized tables that improve query performance and usability.

The Student Journey model is built for adaptability, evolving to fit the needs of researchers. Future enhancements will be guided by user feedback, ensuring the dataset continues to support relevant and impactful research.  To request a future enhancement, contact your ES College Experience Manager (CEM).

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

This guide provides detailed information on the Student Journey dataset:

• overview of the data model

• data sources

• instructions on how to use it

• example queries

For information on how to use direct access to connect to the Data Warehouse see the Data Warehouse Direct Connect Access User Guide.

The Student Journey dataset is designed to:

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

• Establish clear correlations between CO-MIS (post-processed files) and CCCApply data, enabling more comprehensive analysis.

The Student Journey data model uses a canonical modeling approach to unify data from multiple sources into a single, structured framework. Instead of maintaining separate, sparsely populated tables for different data sources, this model consolidates attributes into core tables with linked satellite tables, improving data consistency and usability.

Core Tables These tables serve as the foundation of the model: Application College District Needs_and_Interests Satellite Tables Each core table is associated with satellite tables that store additional details: 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.

Open

Researchers can query the Student Journey dataset in the CCC Data Warehouse via direct access. The following tables are available:

Core Tables

• ccc__district_vw

• ccc__college_vw

• ccc__needs_and_interests_vw

Application and Student Data Tables

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

This section provides guidance on interpreting and querying the tables within the Student Journey canonical model.

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}

By querying the apply__education_vw view, researchers can access attributes related to a student's educational background and future goals. This table includes both valid values and unknown values (represented as 0), but does not contain null or blank values.

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}

_{Figure 5: Query Result}

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

_{Figure 6: Example Query}

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

_{Figure 7: Example Query}

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_sociodemographic_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 10: Marriage Information Query}

This query returns the following results:

_{Figure 11: Query Results}

For details on connecting to the Data Warehouse and accessing current datasets, refer to the Data Warehouse Direct Access User Guide. 

When connecting to the Data Warehouse using the instructions in the Data Warehouse Direct Access User Guide, use the following details for the Student Journey dataset:

• Database Name: Student_Journey

• Schema: public

All tables are stored in the public schema, eliminating the need to navigate to a specific schema based on your MIS code. Data access is automatically managed and protected.

For more details about tables and columns in the database, see the Student Journey Data Dictionary.

To validate your connection to the Student Journey dataset, follow the instructions in the Data Warehouse Direct Access User Guide and use the following SQL query to verify connection:

This query should return 10 rows, confirming successful connectivity.

Colleges are encouraged to perform additional data access tests, such as running:

In the Student Journey database, there are five views that help uniquely identify students even when multiple students may have the same name, birthday, and last four digits of their social security number. This helps ensure the correct student is matched with their application, and it also helps identify fraudulent accounts.

The match_strength column in each view indicates if there are multiple criteria that match, indicating a level of confidence that this student is correctly matched with their application.

The table below describes each view.

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.