SuperGlue for Apply: New Data Fields for SSS Version 1.0
- Patricia Donohue
- Jane Linder
The new OpenCCC Account System (2.0) is part of the Student Success Suite (SSS) products and services. The tables below display the new OpenCCC 2.0 data fields that will be delivered exclusively via SuperGlue for Apply in the SSS Joint Release Version 1.0.
These new fields are only delivered to colleges via SuperGlue and are not delivered via the CCCApply Download Client. This aligns with the phase-out plan for the CCCApply Download Client first announced in September 2021.
Contents:
New Data Fields for SuperGlue for Apply
The following data fields are being implemented in the SSS Joint 1.0 release (fall 2021) that will require action from colleges receiving their CCCApply data directly via SuperGlue. The majority of these new fields are part of the new OpenCCC 2.0 system, and one new field was added to the CCCApply International Application.
Note: These fields are now active in the College Adapter; however, data will not be delivered until the OpenCCC 2.0 product launch (SSS Joint Release V.1.0). As such, these fields will be blank/null until then.
SuperGlue Staging Tables
PeopleSoft
Field Name | Apply DB Name | Type | Glue for Standard App | Glue for International | Glue for CC Promise |
CCTC_APPL_STG | CCTC_INTL_STG | CCTC_PMGT_STG | |||
Email Verified | emailVerified | boolean | CCTC_EMAIL_VER | CCTC_EMAIL_VER | CCTC_EMAIL_VER |
Email Verified Timestamp | emailVerifiedTimestamp | VarChar | CCTC_EMAIL_VER_TS | CCTC_EMAIL_VER_TS | CCTC_EMAIL_VER_TS |
Phone Verified | mainphoneVerified | boolean | CCTC_PHONE_MN_VER | CCTC_PHONE_MN_VER | CCTC_PHONE_MN_VER |
|---|---|---|---|---|---|
Phone Verified Timestamp | mainphoneVerifiedTimestamp | VarChar | CCTC_PHONE_MN_VRTS | CCTC_PHONE_MN_VRTS | CCTC_PHONE_MN_VRTS |
Preferred Contact Method | preferredMethodOfContact | VarChar | CCTC_PRF_CNCT_MTHD | CCTC_PRF_CNCT_MTHD | CCTC_PRF_CNCT_MTHD |
Address Validation Override | addressValidationOverride | boolean | CCTC_MADDR_VOVR | CCTC_MADDR_VOVR | CCTC_MADDR_VOVR |
Address Validation Override Timestamp | addressValidationOverrideTimestamp | VarChar | CCTC_MADDR_VOVR_TS | CCTC_MADDR_VOVR_TS | CCTC_MADDR_VOVR_TS |
Authorized Agent Email* | agent_email_address | VarChar |
| CCTC_EMAIL_AGNT |
|
*Authorized Agent Email field is only collected in the CCCApply International Application.
Colleague
Field Name | Apply DB Name | Type | Glue for Standard App | Glue for International | Glue for CC Promise |
XCTC.CCC.APPLY.APPL | XCTC.CCC.APPLY.INTL.APPL | XCTC.CCPG.APPL | |||
Email Verified | emailVerified | boolean | EMAIL.VERIFIED | EMAIL.VERIFIED | EMAIL.VERIFIED |
Email Verified Timestamp | emailVerifiedTimestamp | VarChar | EMAIL.VERIFIED.DATE, EMAIL.VERIFIED.TIME | EMAIL.VERIFIED.DATE, EMAIL.VERIFIED.TIME | EMAIL.VERIFIED.DATE, EMAIL.VERIFIED.TIME |
Phone Verified | mainphoneVerified | boolean | MAINPHONE.VERIFIED | MAINPHONE.VERIFIED | MAINPHONE.VERIFIED |
|---|---|---|---|---|---|
Phone Verified Timestamp | mainphoneVerifiedTimestamp | VarChar | MAINPHONE.VRFD.DATE, MAINPHONE.VRFD.TIME | MAINPHONE.VRFD.DATE, MAINPHONE.VRFD.TIME | MAINPHONE.VRFD.DATE, MAINPHONE.VRFD.TIME |
Preferred Contact Method | preferredMethodOfContact | VarChar | PREFERRED.METHOD.CON | PREFERRED.METHOD.CON | PREFERRED.METHOD.CON |
Address Validation Override | addressValidationOverride | boolean | ADDRESS.VALIDATION.O | ADDRESS.VALIDATION.O | ADDRESS.VALIDATION.O |
Address Validation Override Timestamp | addressValidationOverrideTimestamp | VarChar | ADDRESS.VALID.O.DATE, ADDRESS.VALID.O.TIME | ADDRESS.VALID.O.DATE, ADDRESS.VALID.O.TIME | ADDRESS.VALID.O.DATE, ADDRESS.VALID.O.TIME |
Authorized Agent Email* | agent_email_address | VarChar |
| AGENT.EMAIL |
|
*Authorized Agent Email field is only collected in the CCCApply International Application.
Banner
Field Name | Apply DB Name | Type | Glue for Standard App | Glue for International | Glue for CC Promise |
SZRAPLY | SZRINTL | SZRPGRT | |||
Email Verified | emailVerified | boolean | EMAIL_VERIFIED | EMAIL_VERIFIED | EMAIL_VERIFIED |
Email Verified Timestamp | emailVerifiedTimestamp | VarChar | EMAIL_VERIFIED_TSTMP | EMAIL_VERIFIED_TSTMP | EMAIL_VERIFIED_TSTMP |
Phone Verified | mainphoneVerified | boolean | PHONE_VERIFIED | PHONE_VERIFIED | PHONE_VERIFIED |
|---|---|---|---|---|---|
Phone Verified Timestamp | mainphoneVerifiedTimestamp | VarChar | PHONE_VERIFIED_TSTMP | PHONE_VERIFIED_TSTMP | PHONE_VERIFIED_TSTMP |
Preferred Contact Method | preferredMethodOfContact | VarChar | PREF_CONTACT_METHOD | PREF_CONTACT_METHOD | PREF_CONTACT_METHOD |
Address Validation Override | addressValidationOverride | boolean | ADDRESS_VAL_OVERRIDE | ADDRESS_VAL_OVERRIDE | ADDRESS_VAL_OVERRIDE |
Address Validation Override Timestamp | addressValidationOverrideTimestamp | VarChar | ADDRESS_VAL_OVER_TSTMP | ADDRESS_VAL_OVER_TSTMP | ADDRESS_VAL_OVER_TSTMP |
Authorized Agent Email* | agentEmailAddress | VarChar |
| AGENT_EMAIL |
|
*Authorized Agent Email field is only collected in the CCCApply International Application.
What do colleges using SuperGlue for Apply have to do?
To start receiving data from the new SSS V.1.0 fields, colleges receiving CCCApply data directly from SuperGlue for Glue will need to perform the steps outlined below.
Collaborate with the CCCTC Enabling Service team (crms@ccctechcenter.org) to:
Add the new fields to their SIS staging tables
Schedule update of the SuperGlue V.4.1 college adapter version that supports the new OpenCCC 2.0 and CCCApply 6.9.0.
Notes:
Production version of the SG V.4.1 college adapter was released in September 2021.
College IT staff may need to update any college-specific processing required to move the new data from the staging tables into SIS core tables/forms.
When do colleges using SuperGlue for Apply need to make these changes?
The SuperGlue College Adapter (V.4.1) was released into production in September 2021 in advance of the upcoming SSS Joint Release 1.0. Once the deployment is complete, colleges can begin receiving this data.