Last Update: 10/07/21
Tip |
---|
The new OpenCCC Account System (v.2.0: This chart displays the data field mappings for the new OpenCCC Account ) 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 |
---|
Note: the The following fields are active from the college adaptor viewpoint, in the College Adapter; however, CCCApply data will not be sending them delivered until the OpenCCC 2.0 releaseproduct launch (SSS Joint Releas V.1.0). As such, these fields will be blank/null until then. |
Table of Contents | ||||||
---|---|---|---|---|---|---|
|
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 |
...