/
SuperGlue for Apply: New Data Fields for SSS Version 1.0

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