(Note: DRAFT in PROGRESS. Currently in the process of merging new content with this existing content from the DW Direct Access User Guide. That draft work is being done outside of Confluence, but I’ve added the basis doc here. The existing technical content here is being revised, deleted from, and added to, using new technical info from Jack Thompson. I have a separate draft of Jack’s new data model user guide content. Jack also needs to create and send me additional technical info, per our working meeting.)
...
CCCApply: Application (Credit and Non-Credit App)
CCCApply: International Application
California College Promise Grant Application
Multiple Measures Placement Service (MMPS)
MyPath Data
Canvas Data (Opt-in required)
Chancellors Office Curriculum Inventory (COCI)
Course Identification Numbering System (C-ID)
NOVA (CCCCO Only)
Launchboard (CCCCO Only)
MIS (CCCCO Only)
CTEOS (CCCCO Only)
Table A: Data Availability Chart
...
Source Data Set
...
CCCCO Access
...
College Access
...
Requires Opt-In for inclusion
...
DW Direct
Connection
...
DW
Report Server
...
DW Direct
Connection
...
DW
Report Server
...
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
...
...
...
...
...
...
| panelIconId | atlassian-info |
|---|---|
| panelIcon | :info: |
| bgColor | #F4F5F7 |
...
...
Implementation Process
When a request is received from an authorized individual at a college or district office (often the Dean overseeing institutional research), the CCCTC Enabling Services (ES) team will work directly with the college IT group to configure a custom site-to-site VPN based on the system used by the college. Enabling Services will then establish a secure direct access connection to the CCC Data Warehouse from the college (or district). After successful implementation and query validations, the ES Support team will be able to provide post-implementation (live) support through the CCCTechnology.info support channel.
...
| 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. |
...