CCCApply International SuperGlue Data Mappings - PeopleSoft
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 | PS_CCTC_INTL_STG | CCTC_MADDR_COUNTRY |
|
currentMailingNonUsAddress | current_mailing_non_us_address | PS_CCTC_INTL_STG | CCTC_MADDR_USA |
|
currentMailingNonUsPostalCode | current_mailing_non_us_postal_code | PS_CCTC_INTL_STG | CCTC_MADDR_IZIP |
|
currentMailingNonUsProvince | current_mailing_non_us_province | PS_CCTC_INTL_STG | CCTC_MADDR_PRVINCE |
|
currentMailingSameAsPermanent | current_mailing_same_as_permanent | PS_CCTC_INTL_STG | CCTC_PERM_EQ_MAIL |
|
currentMailingState | current_mailing_state | PS_CCTC_INTL_STG | CCTC_MADDR_STATE |
|
currentMailingStreet1 | current_mailing_street_1 | PS_CCTC_INTL_STG | CCTC_MADDR_LINE1 |
|
currentMailingStreet2 | current_mailing_street_2 | PS_CCTC_INTL_STG | CCTC_MADDR_LINE2 |
|
currentMailingZipCode | current_mailing_zip_code | PS_CCTC_INTL_STG | CCTC_MADDR_POSTCD |
|
noMailingAddressHomeless | no_mailing_address_homeless | PS_CCTC_INTL_STG | CCTC_MADDR_HOMELSS |
|
noNonUsaPermAddressHomeless | no_non_usa_perm_address_homeless | PS_CCTC_INTL_STG | CCTC_INTL_ADDRHMLS |
|
dep1CountryOfBirth | dep1_country_of_birth | PS_CCTC_INTL_STG | CCTC_DP1_COB |
|
dep1DateOfBirth | dep1_date_of_birth | PS_CCTC_INTL_STG | CCTC_DP1_DOB |
|
dep1DependentId | dep1_dependent_id |
|
|
|
dep1FirstName | dep1_first_name | PS_CCTC_INTL_STG | CCTC_DP1_FN |
|
dep1Gender | dep1_gender | PS_CCTC_INTL_STG | CCTC_DP1_GNDR |
|
dep1LastName | dep1_last_name | PS_CCTC_INTL_STG | CCTC_DP1_LN |
|
dep1NoFirstName | dep1_no_first_name | PS_CCTC_INTL_STG | CCTC_DP1_NO_FN |
|
dep1Relationship | dep1_relationship | PS_CCTC_INTL_STG | CCTC_DP1_RELATION |
|
dep10CountryOfBirth | dep10_country_of_birth | PS_CCTC_INTL_STG | CCTC_DP10_COB |
|
dep10DateOfBirth | dep10_date_of_birth | PS_CCTC_INTL_STG | CCTC_DP10_DOB |
|
dep10DependentId | dep10_dependent_id |
|
|
|
dep10FirstName | dep10_first_name | PS_CCTC_INTL_STG | CCTC_DP10_FN |
|
dep10Gender | dep10_gender | PS_CCTC_INTL_STG | CCTC_DP10_GNDR |
|
dep10LastName | dep10_last_name | PS_CCTC_INTL_STG | CCTC_DP10_LN |
|
dep10NoFirstName | dep10_no_first_name | PS_CCTC_INTL_STG | CCTC_DP10_NO_FN |
|
dep10Relationship | dep10_relationship | PS_CCTC_INTL_STG | CCTC_DP10_RELATION |
|
dep2CountryOfBirth | dep2_country_of_birth | PS_CCTC_INTL_STG | CCTC_DP2_COB |
|
dep2DateOfBirth | dep2_date_of_birth | PS_CCTC_INTL_STG | CCTC_DP2_DOB |
|
dep2DependentId | dep2_dependent_id |
|
|
|
dep2FirstName | dep2_first_name | PS_CCTC_INTL_STG | CCTC_DP2_FN |
|
dep2Gender | dep2_gender | PS_CCTC_INTL_STG | CCTC_DP2_GNDR |
|
dep2LastName | dep2_last_name | PS_CCTC_INTL_STG | CCTC_DP2_LN |
|
dep2NoFirstName | dep2_no_first_name | PS_CCTC_INTL_STG | CCTC_DP2_NO_FN |
|
dep2Relationship | dep2_relationship | PS_CCTC_INTL_STG | CCTC_DP2_RELATION |
|
dep3CountryOfBirth | dep3_country_of_birth | PS_CCTC_INTL_STG | CCTC_DP3_COB |
|
dep3DateOfBirth | dep3_date_of_birth | PS_CCTC_INTL_STG | CCTC_DP3_DOB |
|
dep3DependentId | dep3_dependent_id |
|
|
|
dep3FirstName | dep3_first_name | PS_CCTC_INTL_STG | CCTC_DP3_FN |
|
dep3Gender | dep3_gender | PS_CCTC_INTL_STG | CCTC_DP3_GNDR |
|
dep3LastName | dep3_last_name | PS_CCTC_INTL_STG | CCTC_DP3_LN |
|
dep3NoFirstName | dep3_no_first_name | PS_CCTC_INTL_STG | CCTC_DP3_NO_FN |
|
dep3Relationship | dep3_relationship | PS_CCTC_INTL_STG | CCTC_DP3_RELATION |
|
dep4CountryOfBirth | dep4_country_of_birth | PS_CCTC_INTL_STG | CCTC_DP4_COB |
|
dep4DateOfBirth | dep4_date_of_birth | PS_CCTC_INTL_STG | CCTC_DP4_DOB |
|
dep4DependentId | dep4_dependent_id |
|
|
|
dep4FirstName | dep4_first_name | PS_CCTC_INTL_STG | CCTC_DP4_FN |
|
dep4Gender | dep4_gender | PS_CCTC_INTL_STG | CCTC_DP4_GNDR |
|
dep4LastName | dep4_last_name | PS_CCTC_INTL_STG | CCTC_DP4_LN |
|
dep4NoFirstName | dep4_no_first_name | PS_CCTC_INTL_STG | CCTC_DP4_NO_FN |
|
dep4Relationship | dep4_relationship | PS_CCTC_INTL_STG | CCTC_DP4_RELATION |
|
dep5CountryOfBirth | dep5_country_of_birth | PS_CCTC_INTL_STG | CCTC_DP5_COB |
|
dep5DateOfBirth | dep5_date_of_birth | PS_CCTC_INTL_STG | CCTC_DP5_DOB |
|
dep5DependentId | dep5_dependent_id |
|
|
|
dep5FirstName | dep5_first_name | PS_CCTC_INTL_STG | CCTC_DP5_FN |
|
dep5Gender | dep5_gender | PS_CCTC_INTL_STG | CCTC_DP5_GNDR |
|
dep5LastName | dep5_last_name | PS_CCTC_INTL_STG | CCTC_DP5_LN |
|
dep5NoFirstName | dep5_no_first_name | PS_CCTC_INTL_STG | CCTC_DP5_NO_FN |
|
dep5Relationship | dep5_relationship | PS_CCTC_INTL_STG | CCTC_DP5_RELATION |
|
dep6CountryOfBirth | dep6_country_of_birth | PS_CCTC_INTL_STG | CCTC_DP6_COB |
|
dep6DateOfBirth | dep6_date_of_birth | PS_CCTC_INTL_STG | CCTC_DP6_DOB |
|
dep6DependentId | dep6_dependent_id |
|
|
|
dep6FirstName | dep6_first_name | PS_CCTC_INTL_STG | CCTC_DP6_FN |
|
dep6Gender | dep6_gender | PS_CCTC_INTL_STG | CCTC_DP6_GNDR |
|
dep6LastName | dep6_last_name | PS_CCTC_INTL_STG | CCTC_DP6_LN |
|
dep6NoFirstName | dep6_no_first_name | PS_CCTC_INTL_STG | CCTC_DP6_NO_FN |
|
dep6Relationship | dep6_relationship | PS_CCTC_INTL_STG | CCTC_DP6_RELATION |
|
dep7CountryOfBirth | dep7_country_of_birth | PS_CCTC_INTL_STG | CCTC_DP7_COB |
|
dep7DateOfBirth | dep7_date_of_birth | PS_CCTC_INTL_STG | CCTC_DP7_DOB |
|
dep7DependentId | dep7_dependent_id |
|
|
|
dep7FirstName | dep7_first_name | PS_CCTC_INTL_STG | CCTC_DP7_FN |
|
dep7Gender | dep7_gender | PS_CCTC_INTL_STG | CCTC_DP7_GNDR |
|
dep7LastName | dep7_last_name | PS_CCTC_INTL_STG | CCTC_DP7_LN |
|
dep7NoFirstName | dep7_no_first_name | PS_CCTC_INTL_STG | CCTC_DP7_NO_FN |
|
dep7Relationship | dep7_relationship | PS_CCTC_INTL_STG | CCTC_DP7_RELATION |
|
dep8CountryOfBirth | dep8_country_of_birth | PS_CCTC_INTL_STG | CCTC_DP8_COB |
|
dep8DateOfBirth | dep8_date_of_birth | PS_CCTC_INTL_STG | CCTC_DP8_DOB |
|
dep8DependentId | dep8_dependent_id |
|
|
|
dep8FirstName | dep8_first_name | PS_CCTC_INTL_STG | CCTC_DP8_FN |
|
dep8Gender | dep8_gender | PS_CCTC_INTL_STG | CCTC_DP8_GNDR |
|
dep8LastName | dep8_last_name | PS_CCTC_INTL_STG | CCTC_DP8_LN |
|
dep8NoFirstName | dep8_no_first_name | PS_CCTC_INTL_STG | CCTC_DP8_NO_FN |
|
dep8Relationship | dep8_relationship | PS_CCTC_INTL_STG | CCTC_DP8_RELATION |
|
dep9CountryOfBirth | dep9_country_of_birth | PS_CCTC_INTL_STG | CCTC_DP9_COB |
|
dep9DateOfBirth | dep9_date_of_birth | PS_CCTC_INTL_STG | CCTC_DP9_DOB |
|
dep9DependentId | dep9_dependent_id |
|
|
|
dep9FirstName | dep9_first_name | PS_CCTC_INTL_STG | CCTC_DP9_FN |
|
dep9Gender | dep9_gender | PS_CCTC_INTL_STG | CCTC_DP9_GNDR |
|
dep9LastName | dep9_last_name | PS_CCTC_INTL_STG | CCTC_DP9_LN |
|
dep9NoFirstName | dep9_no_first_name | PS_CCTC_INTL_STG | CCTC_DP9_NO_FN |
|
dep9Relationship | dep9_relationship | PS_CCTC_INTL_STG | CCTC_DP9_RELATION |
|
educationalGoal | educational_goal | PS_CCTC_INTL_STG | CCTC_EDU_GOAL |
|
PS_CCTC_INTL_STG | CCTC_EMAIL |
| ||
emailVerified | email_verified | PS_CCTC_INTL_STG | CCTC_EMAIL_VER |
|
emailVerifiedTimestamp | email_verified_timestamp | PS_CCTC_INTL_STG | CCTC_EMAIL_VER_TS |
|
preferredMethodOfContact | preferred_method_of_contact | PS_CCTC_INTL_STG | CCTC_PRF_CNCT_MTHD |
|
emergencyContactAddressVerified | emergency_contact_address_verified | PS_CCTC_INTL_STG | CCTC_EMRG_ADDRVALD |
|
emergencyContactCity | emergency_contact_city | PS_CCTC_INTL_STG | CCTC_EMRG_ADDRCITY |
|
emergencyContactCountry | emergency_contact_country | PS_CCTC_INTL_STG | CCTC_EMRG_ADDRCTRY |
|
emergencyContactEmail | emergency_contact_email | PS_CCTC_INTL_STG | CCTC_EMRG_EMAIL |
|
emergencyContactFirstName | emergency_contact_first_name | PS_CCTC_INTL_STG | CCTC_EMRG_FN |
|
emergencyContactLastName | emergency_contact_last_name | PS_CCTC_INTL_STG | CCTC_EMRG_LN |
|
emergencyContactNoFirstName | emergency_contact_no_first_name | PS_CCTC_INTL_STG | CCTC_EMRG_NO_FN |
|
emergencyContactNonUsAddress | emergency_contact_non_us_address | PS_CCTC_INTL_STG | CCTC_EMRG_ADDR_USA |
|
emergencyContactNonUsPostalCode | emergency_contact_non_us_postal_code | PS_CCTC_INTL_STG | CCTC_EMRG_ADDRIZIP |
|
emergencyContactNonUsProvince | emergency_contact_non_us_province | PS_CCTC_INTL_STG | CCTC_EMRG_ADDR_PRV |
|
emergencyContactPhoneAuthTxt | emergency_contact_phone_auth_txt | PS_CCTC_INTL_STG | CCTC_EMRG_PHONESMS |
|
emergencyContactPhoneExt | emergency_contact_phone_ext | PS_CCTC_INTL_STG | CCTC_EMRG_PHONEEXT |
|
emergencyContactPhoneNumber | emergency_contact_phone_number | PS_CCTC_INTL_STG | CCTC_EMRG_PHONE |
|
emergencyContactRelationship | emergency_contact_relationship | PS_CCTC_INTL_STG | CCTC_EMRG_RELATION |
|
emergencyContactState | emergency_contact_state | PS_CCTC_INTL_STG | CCTC_EMRG_ADDRSTTE |
|
emergencyContactStreet1 | emergency_contact_street_1 | PS_CCTC_INTL_STG | CCTC_EMRG_ADDRLIN1 |
|
emergencyContactStreet2 | emergency_contact_street_2 | PS_CCTC_INTL_STG | CCTC_EMRG_ADDRLIN2 |
|
emergencyContactZipCode | emergency_contact_zip_code | PS_CCTC_INTL_STG | CCTC_EMRG_ADDRPOST |
|
engMonthsStudied | eng_months_studied | PS_CCTC_INTL_STG | CCTC_INTL_MON_ENG |
|
engProficiencyDate | eng_proficiency_date | PS_CCTC_INTL_STG | CCTC_INTL_ENGPRFDT |
|
engProficiencyOther | eng_proficiency_other | PS_CCTC_INTL_STG | CCTC_INTL_ENGPRFOT |
|
engProficiencyPrerequisite | eng_proficiency_prerequisite | PS_CCTC_INTL_STG | CCTC_INTL_ENGPRFPQ |
|
engProficiencyReq | eng_proficiency_req |
|
|
|
engProficiencyScore | eng_proficiency_score | PS_CCTC_INTL_STG | CCTC_INTL_ENGPRFSC |
|
engProficiencyShowScore | eng_proficiency_show_score | PS_CCTC_INTL_STG | CCTC_INTL_ENGPRFSS |
|
engProficiencyType | eng_proficiency_type | PS_CCTC_INTL_STG | CCTC_INTL_ENGPRFTP |
|
enrollStatus | enroll_status | PS_CCTC_INTL_STG | CCTC_APPL_ENR_STAT |
|
enrollTermCode | enroll_term_code | PS_CCTC_INTL_STG | CCTC_APPL_ENRTRMCD |
|
enrollTermDescription | enroll_term_description | PS_CCTC_INTL_STG | CCTC_APPL_ENRTRMDS |
|
esignature | esignature | PS_CCTC_INTL_STG | CCTC_ESIGNATURE |
|
expirationDate | expiration_date | PS_CCTC_INTL_STG | CCTC_ALIEN_REG_EXP |
|
faxNumberNumber | fax_number_number | PS_CCTC_INTL_STG | CCTC_FAX_NUMBER |
|
firstname | firstname | PS_CCTC_INTL_STG | CCTC_LGL_FIRST_NM |
|
gender | gender | PS_CCTC_INTL_STG | CCTC_GENDER |
|
higherLang | higher_lang |
|
|
|
highestCompDate | highest_comp_date | PS_CCTC_INTL_STG | CCTC_APPL_HRCOMPDT |
|
highestEduLevel | highest_edu_level | PS_CCTC_INTL_STG | CCTC_APPL_HREDULVL |
|
hispanic | hispanic | PS_CCTC_INTL_STG | CCTC_HISPANIC |
|
hsAddressVerified | hs_address_verified | PS_CCTC_INTL_STG | CCTC_APPL_HS_ADDRV |
|
hsCds | hs_cds | PS_CCTC_INTL_STG | CCTC_APPL_HS_CDS |
|
hsCdsFull | hs_cds_full | PS_CCTC_INTL_STG | CCTC_APPL_HS_FCDS |
|
hsCeeb | hs_ceeb | PS_CCTC_INTL_STG | CCTC_APPL_HS_CEEB |
|
hsCity | hs_city | PS_CCTC_INTL_STG | CCTC_APPL_HS_CITY |
|
hsCompDate | hs_comp_date | PS_CCTC_INTL_STG | CCTC_APPL_HSCOMPDT |
|
hsCountry | hs_country | PS_CCTC_INTL_STG | CCTC_APPL_HS_CNTRY |
|
hsDiplomaCert | hs_diploma_cert | PS_CCTC_INTL_STG | CCTC_APPL_HS_DPLMA |
|
hsDiplomaCertDate | hs_diploma_cert_date | PS_CCTC_INTL_STG | CCTC_APPL_HSDPMADT |
|
hsEduLevel | hs_edu_level | PS_CCTC_INTL_STG | CCTC_APPL_HSEDULVL |
|
hsEndDate | hs_end_date | PS_CCTC_INTL_STG | CCTC_APPL_HSENDDT |
|
hsLang | hs_lang | PS_CCTC_INTL_STG | CCTC_APPL_HSLANGCD |
|
hsName | hs_name | PS_CCTC_INTL_STG | CCTC_APPL_HS_NAME |
|
hsNonUsAddress | hs_non_us_address | PS_CCTC_INTL_STG | CCTC_APPL_HS_USA |
|
hsNonUsPostalCode | hs_non_us_postal_code | PS_CCTC_INTL_STG | CCTC_APPL_HS_IZIP |
|
hsNonUsProvince | hs_non_us_province | PS_CCTC_INTL_STG | CCTC_APPL_HS_PRVNC |
|
hsNotListed | hs_not_listed | PS_CCTC_INTL_STG | CCTC_APPL_HS_NL |
|
hsStartDate | hs_start_date | PS_CCTC_INTL_STG | CCTC_APPL_HSSTRTDT |
|
hsState | hs_state | PS_CCTC_INTL_STG | CCTC_APPL_HS_STATE |
|
hsStreet1 | hs_street_1 | PS_CCTC_INTL_STG | CCTC_APPL_HS_LINE1 |
|
hsStreet2 | hs_street_2 | PS_CCTC_INTL_STG | CCTC_APPL_HS_LINE2 |
|
hsType | hs_type | PS_CCTC_INTL_STG | CCTC_INTL_HS_TYPE |
|
hsZipCode | hs_zip_code | PS_CCTC_INTL_STG | CCTC_APPL_HSPOSTCD |
|
i20ExpirationDate | i20_expiration_date | PS_CCTC_INTL_STG | CCTC_INTL_I20EXPDT |
|
i20IssuingSchoolName | i20_issuing_school_name | PS_CCTC_INTL_STG | CCTC_INTL_I20SCHOL |
|
i94AdmissionNumber | i94_admission_number | PS_CCTC_INTL_STG | CCTC_INTL_I94_ADM |
|
i94ExpirationDate | i94_expiration_date | PS_CCTC_INTL_STG | CCTC_INTL_I94_EXP |
|
idmeConfirmationTimestamp | idme_confirmation_timestamp | PS_CCTC_INTL_STG | CCTC_IDME_CNFRM_TS | SG v.4.9.0 |
idmeOptinTimestamp | idme_optin_timestamp | PS_CCTC_INTL_STG | CCTC_IDME_OPTIN_TS | SG v.4.9.0 |
idmeWorkflowStatus | idme_workflow_status | PS_CCTC_INTL_STG | CCTC_IDME_WKFL_STS | SG v.4.9.0 |
intended4YearMajor | intended_4_year_major | PS_CCTC_INTL_STG | CCTC_INTL_4YR_MJR |
|
ipAddress | ip_address | PS_CCTC_INTL_STG | CCTC_IP_ADDRESS |
|
issueDate | issue_date | PS_CCTC_INTL_STG | CCTC_ALIEN_REG_ISS |
|
lastPage | last_page | PS_CCTC_INTL_STG | CCTC_APPL_LAST_PG |
|
lastname | lastname | PS_CCTC_INTL_STG | CCTC_LGL_LAST_NM |
|
mainPhoneAuthTxt | main_phone_auth_txt | PS_CCTC_INTL_STG | CCTC_PHONE_MAINSMS |
|
mainPhoneExt | main_phone_ext | PS_CCTC_INTL_STG | CCTC_PHONE_MAIN_EX |
|
mainPhoneNumber | main_phone_number | PS_CCTC_INTL_STG | CCTC_PHONE_MAIN |
|
mainPhoneVerified | main_phone_verified | PS_CCTC_INTL_STG | CCTC_PHONE_MN_VER |
|
mainPhoneVerifiedTimestamp | main_phone_verified_timestamp | PS_CCTC_INTL_STG | CCTC_PHONE_MN_VRTS |
|
majorCode | major_code | PS_CCTC_INTL_STG | CCTC_APPL_MJR_CD |
|
majorDescription | major_description | PS_CCTC_INTL_STG | CCTC_APPL_MJR_DS |
|
majorCategory | major_category | PS_CCTC_INTL_STG | CCTC_APPL_MJR_CAT |
|
cipCode | cip_code | PS_CCTC_INTL_STG | CCTC_APPL_MJR_CIP |
|
noI94ExpirationDate | no_i94_expiration_date | PS_CCTC_INTL_STG | CCTC_INTL_I94NOEXP |
|
noVisa | no_visa | PS_CCTC_INTL_STG | CCTC_VISA_NONE |
|
nonUsAddress | non_us_address | PS_CCTC_INTL_STG | CCTC_INTL_AGTUSA |
|
nonUsPermanentHomeAddressSameAsPermanent | non_us_permanent_home_address_same_as_permanent | PS_CCTC_INTL_STG | CCTC_INTL_ADDRSAME |
|
nonUsPermanentHomeAddressVerified | non_us_permanent_home_address_verified | PS_CCTC_INTL_STG | CCTC_INTL_ADDRVALD |
|
nonUsPermanentHomeCity | non_us_permanent_home_city | PS_CCTC_INTL_STG | CCTC_INTL_ADDRCITY |
|
nonUsPermanentHomeCountry | non_us_permanent_home_country | PS_CCTC_INTL_STG | CCTC_INTL_ADDRCTRY |
|
nonUsPermanentHomeNonUsAddress | non_us_permanent_home_non_us_address | PS_CCTC_INTL_STG | CCTC_INTL_ADDR_USA |
|
nonUsPermanentHomeNonUsPostalCode | non_us_permanent_home_non_us_postal_code | PS_CCTC_INTL_STG | CCTC_INTL_ADDRIZIP |
|
nonUsPermanentHomeNonUsProvince | non_us_permanent_home_non_us_province | PS_CCTC_INTL_STG | CCTC_INTL_ADDR_PRV |
|
nonUsPermanentHomeStreet1 | non_us_permanent_home_street_1 | PS_CCTC_INTL_STG | CCTC_INTL_ADDRLIN1 |
|
nonUsPermanentHomeStreet2 | non_us_permanent_home_street_2 | PS_CCTC_INTL_STG | CCTC_INTL_ADDRLIN2 |
|
noNonUsPermanentAddrHomeless | non_us_permanent_home_homeless | PS_CCTC_INTL_STG | CCTC_INTL_ADDRHMLS |
|
nonUsPhoneAuthTxt | non_us_phone_auth_txt | PS_CCTC_INTL_STG | CCTC_INTL_1PHNESMS |
|
nonUsPhoneExt | non_us_phone_ext | PS_CCTC_INTL_STG | CCTC_INTL_1PHNEEXT |
|
nonUsPhoneNumber | non_us_phone_number | PS_CCTC_INTL_STG | CCTC_INTL_1PHNE |
|
nonUsPostalCode | non_us_postal_code | PS_CCTC_INTL_STG | CCTC_INTL_AGTIZIP |
|
nonUsProvince | non_us_province | PS_CCTC_INTL_STG | CCTC_INTL_AGTPRVNC |
|
numberOfDependents | number_of_dependents | PS_CCTC_INTL_STG | CCTC_NBR_DEPENDENT |
|
numberOfPracticalTraining | number_of_practical_training | PS_CCTC_INTL_STG | CCTC_INTL_NBR_PT |
|
otherfirstname | otherfirstname | PS_CCTC_INTL_STG | CCTC_AKA_FIRST_NM |
|
otherlastname | otherlastname | PS_CCTC_INTL_STG | CCTC_AKA_LAST_NM |
|
othermiddlename | othermiddlename | PS_CCTC_INTL_STG | CCTC_AKA_MIDDLE_NM |
|
parentGuardianAddressVerified | parent_guardian_address_verified | PS_CCTC_INTL_STG | CCTC_PG1_ADDRVALID |
|
parentGuardianCity | parent_guardian_city | PS_CCTC_INTL_STG | CCTC_PG1_ADDR_CITY |
|
parentGuardianCountry | parent_guardian_country | PS_CCTC_INTL_STG | CCTC_PG1_ADDR_CTRY |
|
parentGuardianEmail | parent_guardian_email | PS_CCTC_INTL_STG | CCTC_PG1_EMAIL |
|
parentGuardianFirstName | parent_guardian_first_name | PS_CCTC_INTL_STG | CCTC_PG1_FIRST_NM |
|
parentGuardianLastName | parent_guardian_last_name | PS_CCTC_INTL_STG | CCTC_PG1_LAST_NM |
|
parentGuardianNoFirstName | parent_guardian_no_first_name | PS_CCTC_INTL_STG | CCTC_PG1_NO_FN |
|
parentGuardianNonUsAddress | parent_guardian_non_us_address | PS_CCTC_INTL_STG | CCTC_PG1_ADDR_USA |
|
parentGuardianNonUsPostalCode | parent_guardian_non_us_postal_code | PS_CCTC_INTL_STG | CCTC_PG1_ADDR_IZIP |
|
parentGuardianNonUsProvince | parent_guardian_non_us_province | PS_CCTC_INTL_STG | CCTC_PG1_ADDR_PRV |
|
parentGuardianPhoneAuthTxt | parent_guardian_phone_auth_txt | PS_CCTC_INTL_STG | CCTC_PG1_PHONESMS |
|
parentGuardianPhoneExt | parent_guardian_phone_ext | PS_CCTC_INTL_STG | CCTC_PG1_PHONEEXT |
|
parentGuardianPhoneNumber | parent_guardian_phone_number | PS_CCTC_INTL_STG | CCTC_PG1_PHONE |
|
parentGuardianRelationship | parent_guardian_relationship | PS_CCTC_INTL_STG | CCTC_PG1_RELATION |
|
parentGuardianState | parent_guardian_state | PS_CCTC_INTL_STG | CCTC_PG1_ADDRSTTE |
|
parentGuardianStreet1 | parent_guardian_street_1 | PS_CCTC_INTL_STG | CCTC_PG1_ADDRLIN1 |
|
parentGuardianStreet2 | parent_guardian_street_2 | PS_CCTC_INTL_STG | CCTC_PG1_ADDRLIN2 |
|
parentGuardianZipCode | parent_guardian_zip_code | PS_CCTC_INTL_STG | CCTC_PG1_ADDRPOST |
|
passportCountryOfIssuance | passport_country_of_issuance | PS_CCTC_INTL_STG | CCTC_INTL_PP_CNTRY |
|
passportExpirationDate | passport_expiration_date | PS_CCTC_INTL_STG | CCTC_INTL_PP_EXP |
|
passportNotYet | passport_not_yet | PS_CCTC_INTL_STG | CCTC_INTL_PP_NONE |
|
passportNumber | passport_number | PS_CCTC_INTL_STG | CCTC_INTL_PP_NBR |
|
permAddrAddressVerified | perm_addr_address_verified | PS_CCTC_INTL_STG | CCTC_PADDR_VALID |
|
permAddrCity | perm_addr_city | PS_CCTC_INTL_STG | CCTC_PADDR_CITY |
|
permAddrCountry | perm_addr_country | PS_CCTC_INTL_STG | CCTC_PADDR_COUNTRY |
|
permAddrNonUsAddress | perm_addr_non_us_address | PS_CCTC_INTL_STG | CCTC_PADDR_USA |
|
permAddrNonUsPostalCode | perm_addr_non_us_postal_code | PS_CCTC_INTL_STG | CCTC_PADDR_IZIP |
|
permAddrNonUsProvince | perm_addr_non_us_province | PS_CCTC_INTL_STG | CCTC_PADDR_PRVINCE |
|
permAddrState | perm_addr_state | PS_CCTC_INTL_STG | CCTC_PADDR_STATE |
|