...
Data Source
...
Data Dictionary
...
Data Lake (AWS S3)
...
ETL Method
...
Frequency of Upload
...
Data Warehouse
...
DW Report Server (Jasper)
...
Notes/ Comments
...
CCCApply: Application (includes Non-Credit App)
...
CCCApply Standard/CollegePromise/International App Enterprise Data Dictionary V2
...
Completed
...
AWS Data Pipeline
...
Once daily
...
Completed (Redshift)
...
Completed
...
CCCApply: International Application
...
Completed
...
AWS Data Pipeline
...
Once daily
...
Completed (Redshift)
...
Completed
...
CCCApply: College Promise
...
Completed
...
AWS Data Pipeline
...
Once daily
...
Completed (Redshift)
...
Completed
...
MyPath
...
Completed
...
AWS Kinesis Firehose
...
Once daily
...
Completed (Redshift)
...
Completed
...
Multiple Measures Placement Service (MMPS)
...
Completed
...
CCC SuperGlue
...
Once daily
...
Completed (Redshift)
...
Completed
...
Placement recommendation
...
COCI
...
Completed
...
AWS Data Pipeline
...
Once daily
...
In Progress Q4 2019/20
...
In Progress
...
C-ID
...
Completed
...
AWS Data Pipeline
...
Once daily
...
In Progress Q4 2019/20
...
In Progress
...
Canvas
...
Completed
...
CCC SuperGlue
...
Once daily
...
Completed (Redshift Spectrum)
...
In Progress
...
Individual colleges Canvas data added to existing data pipeline at request of college
...
MIS
...
Completed
...
AWS Data Pipeline
...
Once daily
...
Completed (Redshift Spectrum)
...
NA
...
Data Governance putting permission in place to enable MIS data to be shared from DW (and connected to DW Report Server)
...
Launchboard
...
Completed
...
AWS Data Pipeline
...
Once daily
...
Completed (Redshift Spectrum)
...
NA
...
Not shared outside of support for CVC/OEI at this time
...
CalPass+
...
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
The single source for all CCC Data Services and CCC Technology Center data source information and data element dictionaries. |
CCC Data Matrix
The table below provides a matrix of the CCC Data sources and corresponding data dictionaries.
Source Data Set | District/College Access | CCCCO Access | Data Element Dictionary | ||
|---|---|---|---|---|---|
DW Direct | DW Report Server | DW Direct | DW Report Server | ||
CCCApply Standard Application (including decrypted LGBTQ Data) |
|
|
|
| |
CCCApply Noncredit Application |
|
|
|
| |
CCCApply International Application |
|
|
|
| |
California College Promise Grant Application |
|
|
|
| |
Multiple Measures Placement Service (MMPS) |
|
|
|
| |
MyPath |
|
|
|
| |
COCI: Chancellor's Office Curriculum Inventory |
|
|
|
| |
C-ID: Course ID Numbering System |
|
|
|
| |
Canvas Data 2* |
|
|
|
| Canvas Data V 4.2.9 |
CCC Management Information System Data** |
|
|
|
| |
NOVA** |
|
|
|
| CCCTC has not been provided with a data dictionary for NOVA |
Launchboard** |
|
|
|
| ERP is developing a data dictionary for Launchboad, which will be added when complete. |
CTEOS** |
|
|
|
| |
*Requires district/college opt-in for inclusion. **Restricted to CCC Chancellor’s Office administrative personnel.