Updated: July 14, 2021
...
Source Data Set | CCCCO Access | College Access | Requires Opt-In for inclusion | Introduced in Release Version | ||
|---|---|---|---|---|---|---|
DW Direct | DW | DW Direct | DW | |||
CCCApply Standard Application |
|
|
|
| CCC Data 2.0 | |
CCCApply Noncredit Application |
|
|
|
| CCC Data 2.0 | |
CCCApply International Application |
|
|
|
| CCC Data 2.0 | |
California College Promise Grant Application |
|
|
|
| CCC Data 2.0 | |
Decrypted LGBTQ Data (and Report) |
|
|
|
| CCC Data 2.0 | |
Multiple Measures Placement Service (MMPS) |
|
|
|
| CCC Data 2.0 | |
COCI: Chancellor's Office Curriculum Inventory |
|
|
|
| CCC Data 2.1 | |
C-ID: Course ID Numbering System |
|
|
|
| CCC Data 2.1 | |
CANVAS (Opt-in) |
|
|
|
|
| CCC Data 2.1 |
CO-MIS |
|
|
|
| CCC Data 2.1 | |
NOVA |
|
|
|
| CCC Data 2.1 | |
Launchboard |
|
|
|
| CCC Data 2.1 | |
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
Data dictionaries for the above data sources are available on the CCC Data Warehouse documentation site. |
...
Table B: Application Database Names
| Info |
|---|
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 would represent their 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 | canvas | canvas_rs_<misScope> |
| Info |
|---|
Note: Data dictionaries for the above data sources are available on the CCC Data Warehouse documentation site. |
...