| Info |
|---|
The CVC/OEI Enrollment Report is a report in the CCC Data Warehouse Report Server (DWRS). |
...
Query data exclusively for colleges participating in the CVC/OEI Course Exchange program.
Export report data in multiple formats, including CSV.
About the
...
The DWRS is a secure, easy-to-use report generator tool that pulls data from the CCC Data Warehouse.
| Note |
|---|
[ add note regarding data and functionality restrictions for CVC/OEI authorized college users ] |
The CCC Data Warehouse is a structured source of master data that can be used to generate the data marts and reports and analytics that end-users need.
The Data Warehouse Report Server is powered by TIBCO JasperReports, a Java-based open-source reporting tool. JasperReports, connected to the CCC Data Warehouse, allows for advanced reporting usage and provides extensive help that you can access from the Help link.
...
CVC/OEI Enrollment Report
The CVC/OEI Enrollment Report is titled “Full Application Report By CCCID and MIS Code” and is based on the “Full Application Report” as found in the CCCApply Report Center.
The report does not include LGBTQ data (note that the Full Application Report contains a field labeled as “orientation” which indicates whether the applicant completed a college orientation and is not related to data found in the LGBTQ report), and contains the last 4 digits of the SSN (and not the full decrypted number available to Researchers in the DWRS).
| Note |
|---|
The CVC/OEI Enrollment Report is generated from CCCApply data in the CCC Data Warehouse which is updated nightly, and is not based on real-time production data as found in the CCCApply Report Center. |
| Info |
|---|
For more information, see the CCC Data Warehouse Report Server User Guide. |
User Authorization & Authentication
Access to the CVC/OEI Enrollment Report in the DWRSrequires an authorized user account with two-factor authentication to ensure the privacy and security of the Data Warehouse Report Server.
Requesting Access to the CVC/OEI Report
Account access will be requested by a single point of contact at CVC/OEI (identified as John Hadad), who will make the request as an email to crms@ccctechcenter.org which is to include the name, title, and email address for the individual(s) for whom access is being requested (or access to be removed).
CVC/OEI Enrollment Report
The CVC/OEI Enrollment Report is titled “Full Application Report By CCCID and MIS Code” and is based on the “Full Application Report” as found in the CCCApply Report Center. Note that this report is generated from CCC Apply data located in the CCC Data Warehouse which is updated nightly, and is not based on real-time production data as found in the CCC Apply Report Center.
The report does not include LGBTQ data (note that the Full Application Report contains a field labeled as “orientation” which indicates whether the applicant completed a college orientation and is not related to data found in the LGBTQ report), and contains the last 4 digits of the SSN (and not the full decrypted number available to Researchers in the DWRS). ), who will make the request as an email to crms@ccctechcenter.org which is to include the name, title, and email address for the individual(s) for whom access is being requested (or access to be removed).
Input/Output
Input to the report is the applicants CCCID and the target colleges MIS code.
...
Authenticator for Mac and Windows Chrome browsers is available free from the Chrome Web Store. This app installs very quickly to your desktop (recommended) as well as your phone, and includes a lot of great features that promote security and usability. NOTE: The entire download and install process takes less than one minute.
To Install the Chrome Authenticator:
...
When you run a report, it opens in the interactive Report Viewer. With the Viewer, you can personalize and refine the displayed report data. If the report has input controls, you run the report with one set of data and then another.
| Note |
|---|
IMPORTANT: There is a 20K row limit on all reports that are run. When building a Table report, ensure there is one or more filters configured to limit the report data to display under 20,000 rows. |
Use the following steps to access your reports once you are logged in to the Data Warehouse Report Server.
...
You can filter information in your view based on a date range relative to the current system date. You can accomplish this using date-based filters, and entering a text expression describing the relative date or date span you want to display, using the format <Keyword>+/-<Number> where:
Keyword indicates the time span you want to use. Options include: DAY, WEEK, MONTH, QUARTER, SEMI, and YEAR. An option used by itself (without +/-<Number>) gives the current value for that option.
+ or - indicates whether the time span occurs before or after the chosen date.
Number indicates the number of the above-mentioned time spans you want to include in the filter.
...