Introduction
...
Table A: Data Availability Chart
Source Data Set | CCCCO Access | College Access | Requires Opt-In for inclusion | ||
---|---|---|---|---|---|
DW Direct | DW | DW Direct | DW | ||
CCCApply Standard Application |
|
|
|
| |
CCCApply Noncredit Application |
|
|
|
| |
CCCApply International Application |
|
|
|
| |
California College Promise Grant Application |
|
|
|
| |
Decrypted LGBTQ Data (and Report) |
|
|
|
| |
Multiple Measures Placement Service (MMPS) |
|
|
|
| |
MyPath |
|
|
|
| |
COCI: Chancellor's Office Curriculum Inventory |
|
|
|
| |
C-ID: Course ID Numbering System |
|
|
|
| |
Canvas Data 2 (Opt-in required) |
|
|
| ||
CO-MIS |
| ||||
NOVA |
| ||||
Launchboard |
| ||||
CTEOS |
|
Panel | ||||||
---|---|---|---|---|---|---|
| ||||||
Data dictionaries for the above data sources are available on the CCC Data Warehouse documentation site. |
...
Participants, Roles, and Responsibilities
Participant | Is responsible for… |
---|---|
College/District Researcher |
|
Enabling Services (ES) College Relationship Manager (CEM) |
|
ES Implementation Configuration Engineer (ICE) |
|
College/District IT/Network Admin |
|
ES Implementation Configuration Engineer (ICE) |
|
ES Support Services |
|
Panel | ||||||
---|---|---|---|---|---|---|
| ||||||
IMPORTANT: Colleges and districts that use their own analytics/BI applications are responsible for their own support in using those tools. |
...
Panel | ||||||
---|---|---|---|---|---|---|
| ||||||
Note: The initial direct connection request should be made to your College Experience Manager. If you do not have the name of the CEM for your college, send an email to cems@ccctechcenter.org. |
...
Panel | ||||||
---|---|---|---|---|---|---|
| ||||||
The value of <misScope> can be derived from the prefix of your Data Warehouse Direct user name which is in the format of <misScope>_<firstInitial><lastName> i.e. 000_jdoe, where 000 represents the MIS scope value. An example of the resulting schema for accessing tables within the Application database = dw_apply_read_000. |
Application (Data Source) | Database Name | Query Schema Format |
---|---|---|
CCCApply Application | application | dw_apply_read_<misScope> |
CC College Promise Grant | bogfw_application | dw_apply_read_<misScope> |
CCC International Application | intl_application | dw_apply_read_<misScope> |
Multiple Measures Placement Service (MMPS) | mmps | dw_apply_read_<misScope> |
Chancellor's Office Curriculum Inventory (COCI) | coci | dw_coci_read_<misScope> |
Course Identification Numbering System (C-ID) | cid | dw_cid_read_<misScope> |
Canvas Data 2 | canvas2 | dw_canvas2_read_<misScope> |
Panel | ||||||
---|---|---|---|---|---|---|
| ||||||
Note: Data dictionaries for the above data sources are available on the CCC Data Warehouse documentation site. |
...
A: While the login credentials are intended to serve as a Service Account for the connection of local applications to the CCC Data Warehouse, individual accounts may be requested for authorized users where this is needed.
More Information: See CCC Data Warehouse - Frequently Asked Questions for more frequently asked questions.
...