SuperGlue for Apply: New Data Fields for SSS Version 1.0
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 Internationa |