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.

 

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

  1. Collaborate with the CCCTC Enabling Service team (crms@ccctechcenter.org) to:

    1. Add the new fields to their SIS staging tables

    2. 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.