...
Tip |
---|
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. |
...
Note |
---|
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 Releas Release V.1.0). As such, these fields will be blank/null until then. |
...
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 | email_verifiedemailVerified | boolean | CCTC_EMAIL_VER | CCTC_EMAIL_VER | CCTC_EMAIL_VER |
Email Verified Timestamp | email.verified_timestampemailVerifiedTimestamp | VarChar | CCTC_EMAIL_VER_TS | CCTC_EMAIL_VER_TS | CCTC_EMAIL_VER_TS |
Phone Verified | mainphone_verifiedmainphoneVerified | boolean | CCTC_PHONE_MN_VER | CCTC_PHONE_MN_VER | CCTC_PHONE_MN_VER |
---|---|---|---|---|---|
Phone Verified Timestamp | mainphone_verified_timestampmainphoneVerifiedTimestamp | VarChar | CCTC_PHONE_MN_VRTS | CCTC_PHONE_MN_VRTS | CCTC_PHONE_MN_VRTS |
Preferred Contact Method | preferred_method_of_contactpreferredMethodOfContact | VarChar | CCTC_PRF_CNCT_MTHD | CCTC_PRF_CNCT_MTHD | CCTC_PRF_CNCT_MTHD |
Address Validation Override | address_validation_overrideaddressValidationOverride | boolean | CCTC_MADDR_VOVR | CCTC_MADDR_VOVR | CCTC_MADDR_VOVR |
Address Validation Override Timestamp | address_validation_override_timestampaddressValidationOverrideTimestamp | VarChar | CCTC_MADDR_VOVR_TS | CCTC_MADDR_VOVR_TS | CCTC_MADDR_VOVR_TS |
Authorized Agent Email* | agent_email_address | VarChar | CCTC_EMAIL_AGNT |
...
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 | email_verifiedemailVerified | boolean | EMAIL.VERIFIED | EMAIL.VERIFIED | EMAIL.VERIFIED |
Email Verified Timestamp | email.verified_timestampemailVerifiedTimestamp | VarChar | EMAIL.VERIFIED.DATE, EMAIL.VERIFIED.TIME | EMAIL.VERIFIED.DATE, EMAIL.VERIFIED.TIME | EMAIL.VERIFIED.DATE, EMAIL.VERIFIED.TIME |
Phone Verified | mainphone_verifiedmainphoneVerified | boolean | MAINPHONE.VERIFIED | MAINPHONE.VERIFIED | MAINPHONE.VERIFIED |
---|---|---|---|---|---|
Phone Verified Timestamp | mainphone_verified_timestampmainphoneVerifiedTimestamp | 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_contactpreferredMethodOfContact | VarChar | PREFERRED.METHOD.CON | PREFERRED.METHOD.CON | PREFERRED.METHOD.CON |
Address Validation Override | address_validation_overrideaddressValidationOverride | boolean | ADDRESS.VALIDATION.O | ADDRESS.VALIDATION.O | ADDRESS.VALIDATION.O |
Address Validation Override Timestamp | address_validation_override_timestampaddressValidationOverrideTimestamp | 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 |
...
Field Name | Apply DB Name | Type | Glue for Standard App | Glue for International | Glue for CC Promise |
SZRAPLY | SZRINTL | SZRPGRT | |||
Email Verified | email_verifiedemailVerified | boolean | EMAIL_VERIFIED | EMAIL_VERIFIED | EMAIL_VERIFIED |
Email Verified Timestamp | email.verified_timestampemailVerifiedTimestamp | VarChar | EMAIL_VERIFIED_TSTMP | EMAIL_VERIFIED_TSTMP | EMAIL_VERIFIED_TSTMP |
Phone Verified | mainphone_verifiedmainphoneVerified | boolean | PHONE_VERIFIED | PHONE_VERIFIED | PHONE_VERIFIED |
---|---|---|---|---|---|
Phone Verified Timestamp | mainphone_verified_timestampmainphoneVerifiedTimestamp | VarChar | PHONE_VERIFIED_TSTMP | PHONE_VERIFIED_TSTMP | PHONE_VERIFIED_TSTMP |
Preferred Contact Method | preferred_method_of_contactpreferredMethodOfContact | VarChar | PREF_CONTACT_METHOD | PREF_CONTACT_METHOD | PREF_CONTACT_METHOD |
Address Validation Override | address_validation_overrideaddressValidationOverride | boolean | ADDRESS_VAL_OVERRIDE | ADDRESS_VAL_OVERRIDE | ADDRESS_VAL_OVERRIDE |
Address Validation Override Timestamp | address_validation_override_timestampaddressValidationOverrideTimestamp | VarChar | ADDRESS_VAL_OVER_TSTMP | ADDRESS_VAL_OVER_TSTMP | ADDRESS_VAL_OVER_TSTMP |
Authorized Agent Email* | agent_email_addressagentEmailAddress | VarChar | AGENT_EMAIL |
*Authorized Agent Email field is only collected in the CCCApply International Application.
...
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.
Note |
---|
IMPORTANT: Beginning with the upcoming SSS Joint Release 1.0, data for the new OpenCCC Account System 2.0 data fields will only be available to CCC colleges via SuperGlue for Apply. New and changed data fields will not be delivered via the CCCApply Download Client, nor will the new data fields be accessible in the CCCApply Report Center immediately following the SSS Joint Release 1.0. |
...