Last Update: 10/07/21
OpenCCC 2.0: This chart displays the data field mappings for the new OpenCCC Account fields that will be delivered via SuperGlue for Apply in the SSS Joint Release 1.0.
New OpenCCC Fields for SuperGlue for Apply
Note: the following fields are active from the college adaptor viewpoint, however, CCCApply will not be sending them until the OpenCCC 2.0 release. 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 only pertains to 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 only pertains to the CCCApply International Application.
Banner
Field Name | Account DB Name | Type | Glue for Standard App | Glue for International | Glue for CC Promise |
Email Verified | email_verified | boolean | |||
Email Verified Timestamp | email.verified_timestamp | VarChar | |||
Phone Verified | mainphone_verified | boolean | |||
---|---|---|---|---|---|
Phone Verified Timestamp | mainphone_verified_timestamp | VarChar | |||
Preferred Contact Method | preferred_method_of_contact | VarChar | |||
Address Validation Override | address_validation_override | boolean | |||
Address Validation Override Timestamp | address_validation_override_timestamp | VarChar | |||
Authorized Agent Email* | agent_email | VarChar |
*Authorized Agent Email only pertains to the CCCApply International Application.