/
CCC Data Dictionary Details

CCC Data Dictionary Details

Current Data Dictionary Sources

Metadata Dictionary

Current Data Dictionary Links

See the second (middle) column in the table below for the Data Warehouse Data Dictionaries that are versioned and located in the Data Warehouse team Google drive. The right-most column includes links to original sources, or, as you work your way down this list, to other data sources of interest, either currently or in the future.

Note that for Data Warehouse V1 and V1.1, the data sets include: CCCApply standard, CCCApply International, CC College Promise, and MyPath.

Data Warehouse Data DictionariesData Warehouse Data Dictionary LinkOriginal Source Data Dictionary Link
CanvasCanvas Data DomainsCanvas Data Warehouse
CCCApply (CCCApply standard app, BOG Fee Waiver (i.e. College Promise), and International app)CCCApply Data Domains

Production Data Dictionaries:

CCCApply Production Data Dictionaries (Note: When navigating to this page, note that CCCApply's data dictionary is labeled as CCCApplyDataDictionary<version>.pdf, while the CC College Promise and International are labeled as 2018-2019_CCPG_Specification.pdf and CCCApplyInternationalApp<version>.pdf, respectively.

CI/QA Data Dictionaries: (i.e. not released to public yet, but actively being developed/updated):

CCCAssess CCCAssess Data Domains

Original CCC Assess Data Dictionary shared by John Hadad

And in Confluence: https://cccnext.jira.com/wiki/spaces/CCCAS/pages/147816747/Data+Dictionary+v1.3

Note: Project is deprecated and replaced by Multiple Measures Initiative

C-IDC-ID Data Dictionary (CNG)
COCICOCI Data Domains
Course ExchangeCourse Exchange Data Domains

Data fields supplied by Jeremiah as a Course Exchange database structure dump on 10/9/2017

Additional information sources:

Course Exchange API

Course Exchange Internal Documentation

Course Exchange Public Documentation (Implementation Guides)

CCC Data Dictionary Metadata (Data Source registry, Technical Data Dictionary, Element Data Dictionary)
CCC Data Dictionary Metadata
Data Warehouse
Data Warehouse Confluence page
eTranscript (API-based; has an open source version and another version that we incorporate in Course Exchange/Glue)

Confluence:

https://cccnext.jira.com/wiki/spaces/CE/pages/189956305/Required+and+Optional+PESC+Transcript+Data+Elements

MDM Glossary of Terms
MDM Glossary of Terms
MISMIS Data DomainsSource: CCCCO MIS Data Mart
MyPath (API-based)MyPath Data Domains

MyPath API Details (scroll down the linked Confluence page to view)

MyPath Domains 

Multiple Measures InitiativeMultiple Measures Domains
Project SuperGlue

Canvas SIS Integration Guide: guide that describes the process of synchronizing the CCC's SISs to Canvas, how to use the UI created specifically for this purpose in the CCC Administrator, explaining the in-house created Canvas Integration API that lets each SIS talk/map to Canvas's API, and appendices that show the SIS to Canvas mapping at the field/column level

Canvas Integration API: in-house created API that allows the CCC's SISs to synchronize data with Canvas

Canvas LMS API: the official Canvas API that was used in creating our in-house API that allows Canvas and the CCC's SISs to synchronize

Migration to API Gateway: diagrams and text showing the before and after of moving to the API Gateway model

See Bitbucket for API Gateway detailed documentation. Ben and Ashwini are spearheading a movement to include the majority of documentation close to the code (i.e. Bitbucket).

Simplified MetricsSimplified Metrics Domains

Simplified Metrics Data Element Dictionary

CCCCO Google Drive (with more items than the source Data Dictionary)

Simplified Metrics Webinar

Student Profile Attributes

8/16/18 Update:

See Detail of All Standard Apply Fields, column N and Q for MDM/SPS Pilot fields

Student Profile Attributes (the beginnings of the Student Profile Service (SPS))

Superset of data that the Student Profile Attributes (at left) are pulled from: CCCApply (Standard App) Download Client Fields (AWS source) and text file version of the same AWS source

References

Planning: 

Overview:     https://docs.google.com/document/d/1K2r47sYF4j8p88zRolNV3iwMJDpaPmq1_vJptUieLlw/edit

Tool Evaluation:  https://docs.google.com/spreadsheets/d/1ATKnTu4hCffChdR1R1tTL4d2W0WitkeEYZtqCrJQ9Sw/edit#gid=0

Data Warehouse Data Sources (and Domains): /wiki/spaces/DW/pages/175069470 

Data Lake Data Dictionary Prototyping: /wiki/spaces/CDW/pages/140050509

Data Lake Recommendations: /wiki/spaces/CDW/pages/118554729

Examples: 

CCCApply:  /wiki/spaces/OPENAPPLY/pages/5439504

Require new apps to provide data dictionaries for valid definitions.





Related content

CCC Data Dictionary Purpose
CCC Data Dictionary Purpose
More like this
Data Dictionaries
Read with this
CCCTC Data Dictionaries
CCCTC Data Dictionaries
More like this
Glue for CCCApply 6.7.0
Glue for CCCApply 6.7.0
Read with this
CCC Data Dictionary Home
CCC Data Dictionary Home
More like this