Release Summary
Additional OpenCCCApply data fields added to the Data Warehouse Report Server (DWRS).
New self-service password reset management for DWRS users using multi-factor authentication (2FA) (non-SSO).
Implementation Notes
Two recent updates made to the Data Warehouse Report Server since January 1, 2023, including the new secure identity management system (Release v.2.2.0) and the new self-serve password reset technology (Release v.2.3.0), have impacted existing DWRS users and require some action by the user to access the DWRS.
These changes result in a new URL and sign-in process for college/district accounts using SSO, and a one-time account update for non-SSO users, such as Chancellor’s Office, CVC/OEI and other external user accounts.
Update Processes for Existing DWRS Users (v2.2.0)
IMPORTANT: Existing users should refer to Release 2023.CCCData.2.2.0 and the Update Processes for Existing DWRS Users (v.2.2.0) for steps to update your account due to recent security updates.
Due to recent security updates deployed for DWRS user authentication, existing user accounts will experience a one-time change to the sign-in process. Please see Implementation Notes in Release 2023.CCCData.2.2.0.
Additional Data Fields Available in DWRS
Fifteen previously released OpenCCCApply data fields are now available in the Data Warehouse Report Server (DWRS) for authorized users.
Colleges & districts that have implemented CCC Data Warehouse Direct Connect also have access to these data fields with no additional action required.
The following data fields are now available for ad hoc reporting:
acceptedTerms
acceptedTermsTimestamp
addressValidationOverride
addressValidationOverrideTimestamp
emailVerified
emailVerifiedTimestamp
fraudScore
fraudStatus
ip_address_at_account_creation
ip_address_at_app_creation
mailing_address_validation_override
military_veteran_consent (CalVet reporting)
mainPhoneVerified
mainPhoneVerifiedTimestamp
phoneType
preferredMethodOfContact
Data element descriptions and technical specifications are available in the CCCApply Standard & Noncredit Application Data Dictionary (v.2023).
New Password Reset Feature
Standard self-service password reset technology has been integrated with the new secure identity management system (v.2.2.0) that allows authorized Data Warehouse Report Server users who have forgotten their account password to authenticate with an alternate factor to fix their own problem instead of calling CCCTC Support for assistance.
This new feature will support the account update process for Data Warehouse Report Server users that requires new passwords for existing DWRS users (one-time).
See how this new feature supports the required update for DWRS users reset your password and re-authenticate their existing account (one-time). See Update Processes for Existing DWRS Users - instructions for existing Data Warehouse Report Server users to reset their passwords and re-authenticate following this CCC Data Warehouse v.2.3.0 production release.
About the DWRS
The Data Warehouse Report Server (DWRS) is a BI reporting tool used by the CCCTC to provide secure access to systemwide data for college & district institutional researchers and other authorized stakeholders.
To Request Access: Please contact the CCCTC Enabling Services team at crms@ccctechcenter.org to request authorized access.
Existing Users: Please refer to Release 2023.CCCData.2.2.0 for details on updating your user account due to recent security updates.
Documentation
Data element descriptions and technical specifications have been added to the CCCApply Standard & Noncredit Application Data Dictionary (v.2023).
Other related documentation: