...
| Table of Contents | ||||||
|---|---|---|---|---|---|---|
|
PeopleSoft
Field Name | Account 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_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_address | VarChar | CCTC_EMAIL_AGNT |
*Authorized Agent Email field is only collected in the CCCApply International Application.
Colleague
Field Name | Account 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_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_address | VarChar | AGENT.EMAIL |
*Authorized Agent Email field is only collected in the CCCApply International Application.
Banner
Field Name | Account Apply 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_address | VarChar | AGENT_EMAIL |
*Authorized Agent Email field is only collected in the CCCApply International Application.
...