Last Update: 10/07/21
The new OpenCCC Account System (v.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 via SuperGlue for Apply in the SSS Joint Release Version 1.0.
New SSS Data Fields for SuperGlue for Apply
Note: The following fields are active in the College Adapter; however, data will not be delivered until the OpenCCC 2.0 product launch (SSS Joint Releas V.1.0). As such, these fields will be blank/null until then.
PeopleSoft
Field Name | Account 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 | email_verified | boolean | CCTC_EMAIL_VER | CCTC_EMAIL_VER | CCTC_EMAIL_VER |
Email Verified Timestamp | email.verified_timestamp | VarChar | CCTC_EMAIL_VER_TS | CCTC_EMAIL_VER_TS | CCTC_EMAIL_VER_TS |
Phone Verified | mainphone_verified | boolean | CCTC_PHONE_MN_VER | CCTC_PHONE_MN_VER | CCTC_PHONE_MN_VER |
---|---|---|---|---|---|
Phone Verified Timestamp | mainphone_verified_timestamp | VarChar | CCTC_PHONE_MN_VRTS | CCTC_PHONE_MN_VRTS | CCTC_PHONE_MN_VRTS |
Preferred Contact Method | preferred_method_of_contact | VarChar | CCTC_PRF_CNCT_MTHD | CCTC_PRF_CNCT_MTHD | CCTC_PRF_CNCT_MTHD |
Address Validation Override | address_validation_override | boolean | CCTC_MADDR_VOVR | CCTC_MADDR_VOVR | CCTC_MADDR_VOVR |
Address Validation Override Timestamp | address_validation_override_timestamp | VarChar | CCTC_MADDR_VOVR_TS | CCTC_MADDR_VOVR_TS | CCTC_MADDR_VOVR_TS |
Authorized Agent Email* | agent_email | VarChar | CCTC_EMAIL_AGNT |
*Authorized Agent Email field is only collected in the CCCApply International Application.
Colleague
Field Name | Account 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 | email_verified | boolean | EMAIL.VERIFIED | EMAIL.VERIFIED | EMAIL.VERIFIED |
Email Verified Timestamp | email.verified_timestamp | VarChar | EMAIL.VERIFIED.DATE, EMAIL.VERIFIED.TIME | EMAIL.VERIFIED.DATE, EMAIL.VERIFIED.TIME | EMAIL.VERIFIED.DATE, EMAIL.VERIFIED.TIME |
Phone Verified | mainphone_verified | boolean | MAINPHONE.VERIFIED | MAINPHONE.VERIFIED | MAINPHONE.VERIFIED |
---|---|---|---|---|---|
Phone Verified Timestamp | mainphone_verified_timestamp | VarChar | MAINPHONE.VRFD.DATE, MAINPHONE.VRFD.TIME | MAINPHONE.VRFD.DATE, MAINPHONE.VRFD.TIME | MAINPHONE.VRFD.DATE, MAINPHONE.VRFD.TIME |
Preferred Contact Method | preferred_method_of_contact | VarChar | PREFERRED.METHOD.CON | PREFERRED.METHOD.CON | PREFERRED.METHOD.CON |
Address Validation Override | address_validation_override | boolean | ADDRESS.VALIDATION.O | ADDRESS.VALIDATION.O | ADDRESS.VALIDATION.O |
Address Validation Override Timestamp | address_validation_override_timestamp | 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 | VarChar | AGENT.EMAIL |
*Authorized Agent Email field is only collected in the CCCApply International Application.
Banner
Field Name | Account DB Name | Type | Glue for Standard App | Glue for International | Glue for CC Promise |
SZRAPLY | SZRINTL | SZRPGRT | |||
Email Verified | email_verified | boolean | EMAIL_VERIFIED | EMAIL_VERIFIED | EMAIL_VERIFIED |
Email Verified Timestamp | email.verified_timestamp | VarChar | EMAIL_VERIFIED_TSTMP | EMAIL_VERIFIED_TSTMP | EMAIL_VERIFIED_TSTMP |
Phone Verified | mainphone_verified | boolean | PHONE_VERIFIED | PHONE_VERIFIED | PHONE_VERIFIED |
---|---|---|---|---|---|
Phone Verified Timestamp | mainphone_verified_timestamp | VarChar | PHONE_VERIFIED_TSTMP | PHONE_VERIFIED_TSTMP | PHONE_VERIFIED_TSTMP |
Preferred Contact Method | preferred_method_of_contact | VarChar | PREF_CONTACT_METHOD | PREF_CONTACT_METHOD | PREF_CONTACT_METHOD |
Address Validation Override | address_validation_override | boolean | ADDRESS_VAL_OVERRIDE | ADDRESS_VAL_OVERRIDE | ADDRESS_VAL_OVERRIDE |
Address Validation Override Timestamp | address_validation_override_timestamp | VarChar | ADDRESS_VAL_OVER_TSTMP | ADDRESS_VAL_OVER_TSTMP | ADDRESS_VAL_OVER_TSTMP |
Authorized Agent Email* | agent_email | VarChar | AGENT_EMAIL |
*Authorized Agent Email field is only collected in the CCCApply International Application.