CCCApply International SuperGlue Data Mappings - PeopleSoft
- Patricia Donohue
The tables below pertain to the CCCApply International application.
Contents
International Data Fields Table Mapping - PeopleSoft
For more details, see the CCCApply International Application data dictionary.
College Adaptor Payload Name | CCC Field Name | PeopleSoft DB Staging Table | PeopleSoft Field Name | VERSION Release |
|---|---|---|---|---|
appId | app_id | PS_CCTC_INTL_STG | CCTC_APPL_ID |
|
cccId | ccc_id | PS_CCTC_INTL_STG | CCTC_CCCID |
|
collegeId | college_id | PS_CCTC_INTL_STG | CCTC_MIS_CD |
|
addressVerified | address_verified | PS_CCTC_INTL_STG | CCTC_INTL_AGTADDRV |
|
agentEmail | agent_email | PS_CCTC_INTL_STG | CCTC_EMAIL_AGNT |
|
agentPhoneExt | agent_phone_ext | PS_CCTC_INTL_STG | CCTC_PHONE_AGNT_EX |
|
agentPhoneNumber | agent_phone_number | PS_CCTC_INTL_STG | CCTC_PHONE_AGNT |
|
altNonUsPhoneAuthTxt | alt_non_us_phone_auth_txt | PS_CCTC_INTL_STG | CCTC_INTL_2PHNESMS |
|
altNonUsPhoneExt | alt_non_us_phone_ext | PS_CCTC_INTL_STG | CCTC_INTL_2PHNEEXT |
|
altNonUsPhoneNumber | alt_non_us_phone_number | PS_CCTC_INTL_STG | CCTC_INTL_2PHNE |
|
appLang | app_lang | PS_CCTC_INTL_STG | CCTC_APPL_LANG_CD |
|
authorizeAgentInfoRelease | authorize_agent_info_release | PS_CCTC_INTL_STG | CCTC_INTL_AGT_AUTH |
|
birthdate | birthdate | PS_CCTC_INTL_STG | CCTC_BIRTHDATE |
|
campaign1 | campaign1 | PS_CCTC_INTL_STG | CCTC_APPL_CAMPGN1 |
|
campaign2 | campaign2 | PS_CCTC_INTL_STG | CCTC_APPL_CAMPGN2 |
|
campaign3 | campaign3 | PS_CCTC_INTL_STG | CCTC_APPL_CAMPGN3 |
|
citizenshipStatus | citizenship_status | PS_CCTC_INTL_STG | CCTC_CITIZENSHIP |
|
city | city | PS_CCTC_INTL_STG | CCTC_INTL_AGTADDRC |
|
coenrollConfirm | coenroll_confirm | PS_CCTC_INTL_STG | CCTC_APPL_CENRL_CF |
|
col1Cds | col1_cds | PS_CCTC_INTL_STG | CCTC_APPL_CL1_CDS |
|
col1CdsFull | col1_cds_full | PS_CCTC_INTL_STG | CCTC_APPL_CL1_FCDS |
|
col1Ceeb | col1_ceeb | PS_CCTC_INTL_STG | CCTC_APPL_CL1_CEEB |
|
col1City | col1_city | PS_CCTC_INTL_STG | CCTC_APPL_CL1_CITY |
|
col1CollegeAttendedId | col1_college_attended_id | PS_CCTC_INTL_STG | CCTC_APPL_CL1_ID |
|
col1Country | col1_country | PS_CCTC_INTL_STG | CCTC_APPL_CL1_CTRY |
|
col1DegreeDate | col1_degree_date | PS_CCTC_INTL_STG | CCTC_APPL_CL1_DGDT |
|
col1DegreeObtained | col1_degree_obtained | PS_CCTC_INTL_STG | CCTC_APPL_CL1_DGRE |
|
col1EndDate | col1_end_date | PS_CCTC_INTL_STG | CCTC_APPL_CL1_END |
|
col1ExpelledStatus | col1_expelled_status | PS_CCTC_INTL_STG | CCTC_APPL_CL1_EXP |
|
col1Major | col1_major | PS_CCTC_INTL_STG | CCTC_APPL_CL1_MJR |
|
col1Name | col1_name | PS_CCTC_INTL_STG | CCTC_APPL_CL1_NAME |
|
col1NonUsProvince | col1_non_us_province | PS_CCTC_INTL_STG | CCTC_APPL_CL1_PRVN |
|
col1NotListed | col1_not_listed | PS_CCTC_INTL_STG | CCTC_APPL_CL1_NL |
|
col1PrimaryInstructionLanguage | col1_primary_instruction_language | PS_CCTC_INTL_STG | CCTC_APPL_CL1_LANG |
|
col1StartDate | col1_start_date | PS_CCTC_INTL_STG | CCTC_APPL_CL1_STRT |
|
col1State | col1_state | PS_CCTC_INTL_STG | CCTC_APPL_CL1_STTE |
|
col2Cds | col2_cds | PS_CCTC_INTL_STG | CCTC_APPL_CL2_CDS |
|
col2CdsFull | col2_cds_full | PS_CCTC_INTL_STG | CCTC_APPL_CL2_FCDS |
|
col2Ceeb | col2_ceeb | PS_CCTC_INTL_STG | CCTC_APPL_CL2_CEEB |
|
col2City | col2_city | PS_CCTC_INTL_STG | CCTC_APPL_CL2_CITY |
|
col2CollegeAttendedId | col2_college_attended_id | PS_CCTC_INTL_STG | CCTC_APPL_CL2_ID |
|
col2Country | col2_country | PS_CCTC_INTL_STG | CCTC_APPL_CL2_CTRY |
|
col2DegreeDate | col2_degree_date | PS_CCTC_INTL_STG | CCTC_APPL_CL2_DGDT |
|
col2DegreeObtained | col2_degree_obtained | PS_CCTC_INTL_STG | CCTC_APPL_CL2_DGRE |
|
col2EndDate | col2_end_date | PS_CCTC_INTL_STG | CCTC_APPL_CL2_END |
|
col2ExpelledStatus | col2_expelled_status | PS_CCTC_INTL_STG | CCTC_APPL_CL2_EXP |
|
col2Major | col2_major | PS_CCTC_INTL_STG | CCTC_APPL_CL2_MJR |
|
col2Name | col2_name | PS_CCTC_INTL_STG | CCTC_APPL_CL2_NAME |
|
col2NonUsProvince | col2_non_us_province | PS_CCTC_INTL_STG | CCTC_APPL_CL2_PRVN |
|
col2NotListed | col2_not_listed | PS_CCTC_INTL_STG | CCTC_APPL_CL2_NL |
|
col2PrimaryInstructionLanguage | col2_primary_instruction_language | PS_CCTC_INTL_STG | CCTC_APPL_CL2_LANG |
|
col2StartDate | col2_start_date | PS_CCTC_INTL_STG | CCTC_APPL_CL2_STRT |
|
col2State | col2_state | PS_CCTC_INTL_STG | CCTC_APPL_CL2_STTE |
|
col3Cds | col3_cds | PS_CCTC_INTL_STG | CCTC_APPL_CL3_CDS |
|
col3CdsFull | col3_cds_full | PS_CCTC_INTL_STG | CCTC_APPL_CL3_FCDS |
|
col3Ceeb | col3_ceeb | PS_CCTC_INTL_STG | CCTC_APPL_CL3_CEEB |
|
col3City | col3_city | PS_CCTC_INTL_STG | CCTC_APPL_CL3_CITY |
|
col3CollegeAttendedId | col3_college_attended_id | PS_CCTC_INTL_STG | CCTC_APPL_CL3_ID |
|
col3Country | col3_country | PS_CCTC_INTL_STG | CCTC_APPL_CL3_CTRY |
|
col3DegreeDate | col3_degree_date | PS_CCTC_INTL_STG | CCTC_APPL_CL3_DGDT |
|
col3DegreeObtained | col3_degree_obtained | PS_CCTC_INTL_STG | CCTC_APPL_CL3_DGRE |
|
col3EndDate | col3_end_date | PS_CCTC_INTL_STG | CCTC_APPL_CL3_END |
|
col3ExpelledStatus | col3_expelled_status | PS_CCTC_INTL_STG | CCTC_APPL_CL3_EXP |
|
col3Major | col3_major | PS_CCTC_INTL_STG | CCTC_APPL_CL3_MJR |
|
col3Name | col3_name | PS_CCTC_INTL_STG | CCTC_APPL_CL3_NAME |
|
col3NonUsProvince | col3_non_us_province | PS_CCTC_INTL_STG | CCTC_APPL_CL3_PRVN |
|
col3NotListed | col3_not_listed | PS_CCTC_INTL_STG | CCTC_APPL_CL3_NL |
|
col3PrimaryInstructionLanguage | col3_primary_instruction_language | PS_CCTC_INTL_STG | CCTC_APPL_CL3_LANG |
|
col3StartDate | col3_start_date | PS_CCTC_INTL_STG | CCTC_APPL_CL3_STRT |
|
col3State | col3_state | PS_CCTC_INTL_STG | CCTC_APPL_CL3_STTE |
|
col4Cds | col4_cds | PS_CCTC_INTL_STG | CCTC_APPL_CL4_CDS |
|
col4CdsFull | col4_cds_full | PS_CCTC_INTL_STG | CCTC_APPL_CL4_FCDS |
|
col4Ceeb | col4_ceeb | PS_CCTC_INTL_STG | CCTC_APPL_CL4_CEEB |
|
col4City | col4_city | PS_CCTC_INTL_STG | CCTC_APPL_CL4_CITY |
|
col4CollegeAttendedId | col4_college_attended_id | PS_CCTC_INTL_STG | CCTC_APPL_CL4_ID |
|
col4Country | col4_country | PS_CCTC_INTL_STG | CCTC_APPL_CL4_CTRY |
|
col4DegreeDate | col4_degree_date | PS_CCTC_INTL_STG | CCTC_APPL_CL4_DGDT |
|
col4DegreeObtained | col4_degree_obtained | PS_CCTC_INTL_STG | CCTC_APPL_CL4_DGRE |
|
col4EndDate | col4_end_date | PS_CCTC_INTL_STG | CCTC_APPL_CL4_END |
|
col4ExpelledStatus | col4_expelled_status | PS_CCTC_INTL_STG | CCTC_APPL_CL4_EXP |
|
col4Major | col4_major | PS_CCTC_INTL_STG | CCTC_APPL_CL4_MJR |
|
col4Name | col4_name | PS_CCTC_INTL_STG | CCTC_APPL_CL4_NAME |
|
col4NonUsProvince | col4_non_us_province | PS_CCTC_INTL_STG | CCTC_APPL_CL4_PRVN |
|
col4NotListed | col4_not_listed | PS_CCTC_INTL_STG | CCTC_APPL_CL4_NL |
|
col4PrimaryInstructionLanguage | col4_primary_instruction_language | PS_CCTC_INTL_STG | CCTC_APPL_CL4_LANG |
|
col4StartDate | col4_start_date | PS_CCTC_INTL_STG | CCTC_APPL_CL4_STRT |
|
col4State | col4_state | PS_CCTC_INTL_STG | CCTC_APPL_CL4_STTE |
|
collegeCompDate | college_comp_date | PS_CCTC_INTL_STG | CCTC_APPL_CLCOMPDT |
|
collegeCount | college_count | PS_CCTC_INTL_STG | CCTC_APPL_CLG_CNT |
|
collegeEduLevel | college_edu_level | PS_CCTC_INTL_STG | CCTC_APPL_CLEDULVL |
|
collegeExpelledSummary | college_expelled_summary | PS_CCTC_INTL_STG | CCTC_APPL_COL_EXP |
|
collegeName | college_name | PS_CCTC_INTL_STG | CCTC_APPL_COL_NM |
|
company | company | PS_CCTC_INTL_STG | CCTC_INTL_AGTCMPNY |
|
confirmation | confirmation | PS_CCTC_INTL_STG | CCTC_APPL_CFRM_NBR |
|
consent | consent | PS_CCTC_INTL_STG | CCTC_INFO_CONSENT |
|
contact | contact | PS_CCTC_INTL_STG | CCTC_INTL_AGTCNTCT |
|
country | country | PS_CCTC_INTL_STG | CCTC_INTL_AGTCNTRY |
|
countryOfBirth | country_of_birth | PS_CCTC_INTL_STG | CCTC_BIRTH_COUNTRY |
|
countryOfCitizenship | country_of_citizenship | PS_CCTC_INTL_STG | CCTC_CITZN_COUNTRY |
|
cryptokeyid | cryptokeyid |
| ||
currentMailingAddressOutsideUs | current_mailing_address_outside_us |
| ||
currentMailingAddressVerified | current_mailing_address_verified | PS_CCTC_INTL_STG | CCTC_MADDR_VALID |
|
addressValidationOverride | address_validation_override | PS_CCTC_INTL_STG | CCTC_MADDR_VOVR |
|
addressValidationOverrideTimestamp | address_validation_override_timestamp | PS_CCTC_INTL_STG | CCTC_MADDR_VOVR_TS |
|
currentMailingCity | current_mailing_city | PS_CCTC_INTL_STG | CCTC_MADDR_CITY |
|
currentMailingCountry | current_mailing_country |