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 | Explanation |
---|---|---|---|---|
appId | app_id | PS_CCTC_INTL_STG | CCTC_APPL_ID | See here |
cccId | ccc_id | PS_CCTC_INTL_STG | CCTC_CCCID | See here |
collegeId | college_id | PS_CCTC_INTL_STG | CCTC_MIS_CD | See here |
addressVerified | address_verified | PS_CCTC_INTL_STG | CCTC_INTL_AGTADDRV | See here |
agentEmail | agent_email | PS_CCTC_INTL_STG | CCTC_EMAIL_AGNT | See here |
agentPhoneExt | agent_phone_ext | PS_CCTC_INTL_STG | CCTC_PHONE_AGNT_EX | See here |
agentPhoneNumber | agent_phone_number | PS_CCTC_INTL_STG | CCTC_PHONE_AGNT | See here |
altNonUsPhoneAuthTxt | alt_non_us_phone_auth_txt | PS_CCTC_INTL_STG | CCTC_INTL_2PHNESMS | See here |
altNonUsPhoneExt | alt_non_us_phone_ext | PS_CCTC_INTL_STG | CCTC_INTL_2PHNEEXT | See here |
altNonUsPhoneNumber | alt_non_us_phone_number | PS_CCTC_INTL_STG | CCTC_INTL_2PHNE | See here |
appLang | app_lang | PS_CCTC_INTL_STG | CCTC_APPL_LANG_CD | See here |
authorizeAgentInfoRelease | authorize_agent_info_release | PS_CCTC_INTL_STG | CCTC_INTL_AGT_AUTH | See here |
birthdate | birthdate | PS_CCTC_INTL_STG | CCTC_BIRTHDATE | See here |
campaign1 | campaign1 | PS_CCTC_INTL_STG | CCTC_APPL_CAMPGN1 | See here |
campaign2 | campaign2 | PS_CCTC_INTL_STG | CCTC_APPL_CAMPGN2 | See here |
campaign3 | campaign3 | PS_CCTC_INTL_STG | CCTC_APPL_CAMPGN3 | See here |
citizenshipStatus | citizenship_status | PS_CCTC_INTL_STG | CCTC_CITIZENSHIP | See here |
city | city | PS_CCTC_INTL_STG | CCTC_INTL_AGTADDRC | See here |
coenrollConfirm | coenroll_confirm | PS_CCTC_INTL_STG | CCTC_APPL_CENRL_CF | See here |
col1Cds | col1_cds | PS_CCTC_INTL_STG | CCTC_APPL_CL1_CDS | See here |
col1CdsFull | col1_cds_full | PS_CCTC_INTL_STG | CCTC_APPL_CL1_FCDS | See here |
col1Ceeb | col1_ceeb | PS_CCTC_INTL_STG | CCTC_APPL_CL1_CEEB | See here |
col1City | col1_city | PS_CCTC_INTL_STG | CCTC_APPL_CL1_CITY | See here |
col1CollegeAttendedId | col1_college_attended_id | PS_CCTC_INTL_STG | CCTC_APPL_CL1_ID | See here |
col1Country | col1_country | PS_CCTC_INTL_STG | CCTC_APPL_CL1_CTRY | See here |
col1DegreeDate | col1_degree_date | PS_CCTC_INTL_STG | CCTC_APPL_CL1_DGDT | See here |
col1DegreeObtained | col1_degree_obtained | PS_CCTC_INTL_STG | CCTC_APPL_CL1_DGRE | See here |
col1EndDate | col1_end_date | PS_CCTC_INTL_STG | CCTC_APPL_CL1_END | See here |
col1ExpelledStatus | col1_expelled_status | PS_CCTC_INTL_STG | CCTC_APPL_CL1_EXP | See here |
col1Major | col1_major | PS_CCTC_INTL_STG | CCTC_APPL_CL1_MJR | See here |
col1Name | col1_name | PS_CCTC_INTL_STG | CCTC_APPL_CL1_NAME | See here |
col1NonUsProvince | col1_non_us_province | PS_CCTC_INTL_STG | CCTC_APPL_CL1_PRVN | See here |
col1NotListed | col1_not_listed | PS_CCTC_INTL_STG | CCTC_APPL_CL1_NL | See here |
col1PrimaryInstructionLanguage | col1_primary_instruction_language | PS_CCTC_INTL_STG | CCTC_APPL_CL1_LANG | See here |
col1StartDate | col1_start_date | PS_CCTC_INTL_STG | CCTC_APPL_CL1_STRT | See here |
col1State | col1_state | PS_CCTC_INTL_STG | CCTC_APPL_CL1_STTE | See here |
col2Cds | col2_cds | PS_CCTC_INTL_STG | CCTC_APPL_CL2_CDS | See here |
col2CdsFull | col2_cds_full | PS_CCTC_INTL_STG | CCTC_APPL_CL2_FCDS | See here |
col2Ceeb | col2_ceeb | PS_CCTC_INTL_STG | CCTC_APPL_CL2_CEEB | See here |
col2City | col2_city | PS_CCTC_INTL_STG | CCTC_APPL_CL2_CITY | See here |
col2CollegeAttendedId | col2_college_attended_id | PS_CCTC_INTL_STG | CCTC_APPL_CL2_ID | See here |
col2Country | col2_country | PS_CCTC_INTL_STG | CCTC_APPL_CL2_CTRY | See here |
col2DegreeDate | col2_degree_date | PS_CCTC_INTL_STG | CCTC_APPL_CL2_DGDT | See here |
col2DegreeObtained | col2_degree_obtained | PS_CCTC_INTL_STG | CCTC_APPL_CL2_DGRE | See here |
col2EndDate | col2_end_date | PS_CCTC_INTL_STG | CCTC_APPL_CL2_END | See here |
col2ExpelledStatus | col2_expelled_status | PS_CCTC_INTL_STG | CCTC_APPL_CL2_EXP | See here |
col2Major | col2_major | PS_CCTC_INTL_STG | CCTC_APPL_CL2_MJR | See here |
col2Name | col2_name | PS_CCTC_INTL_STG | CCTC_APPL_CL2_NAME | See here |
col2NonUsProvince | col2_non_us_province | PS_CCTC_INTL_STG | CCTC_APPL_CL2_PRVN | See here |
col2NotListed | col2_not_listed | PS_CCTC_INTL_STG | CCTC_APPL_CL2_NL | See here |
col2PrimaryInstructionLanguage | col2_primary_instruction_language | PS_CCTC_INTL_STG | CCTC_APPL_CL2_LANG | See here |
col2StartDate | col2_start_date | PS_CCTC_INTL_STG | CCTC_APPL_CL2_STRT | See here |
col2State | col2_state | PS_CCTC_INTL_STG | CCTC_APPL_CL2_STTE | See here |
col3Cds | col3_cds | PS_CCTC_INTL_STG | CCTC_APPL_CL3_CDS | See here |
col3CdsFull | col3_cds_full | PS_CCTC_INTL_STG | CCTC_APPL_CL3_FCDS | See here |
col3Ceeb | col3_ceeb | PS_CCTC_INTL_STG | CCTC_APPL_CL3_CEEB | See here |
col3City | col3_city | PS_CCTC_INTL_STG | CCTC_APPL_CL3_CITY | See here |
col3CollegeAttendedId | col3_college_attended_id | PS_CCTC_INTL_STG | CCTC_APPL_CL3_ID | See here |
col3Country | col3_country | PS_CCTC_INTL_STG | CCTC_APPL_CL3_CTRY | See here |
col3DegreeDate | col3_degree_date | PS_CCTC_INTL_STG | CCTC_APPL_CL3_DGDT | See here |
col3DegreeObtained | col3_degree_obtained | PS_CCTC_INTL_STG | CCTC_APPL_CL3_DGRE | See here |
col3EndDate | col3_end_date | PS_CCTC_INTL_STG | CCTC_APPL_CL3_END | See here |
col3ExpelledStatus | col3_expelled_status | PS_CCTC_INTL_STG | CCTC_APPL_CL3_EXP | See here |
col3Major | col3_major | PS_CCTC_INTL_STG | CCTC_APPL_CL3_MJR | See here |
col3Name | col3_name | PS_CCTC_INTL_STG | CCTC_APPL_CL3_NAME | See here |
col3NonUsProvince | col3_non_us_province | PS_CCTC_INTL_STG | CCTC_APPL_CL3_PRVN | See here |
col3NotListed | col3_not_listed | PS_CCTC_INTL_STG | CCTC_APPL_CL3_NL | See here |
col3PrimaryInstructionLanguage | col3_primary_instruction_language | PS_CCTC_INTL_STG | CCTC_APPL_CL3_LANG | See here |
col3StartDate | col3_start_date | PS_CCTC_INTL_STG | CCTC_APPL_CL3_STRT | See here |
col3State | col3_state | PS_CCTC_INTL_STG | CCTC_APPL_CL3_STTE | See here |
col4Cds | col4_cds | PS_CCTC_INTL_STG | CCTC_APPL_CL4_CDS | See here |
col4CdsFull | col4_cds_full | PS_CCTC_INTL_STG | CCTC_APPL_CL4_FCDS | See here |
col4Ceeb | col4_ceeb | PS_CCTC_INTL_STG | CCTC_APPL_CL4_CEEB | See here |
col4City | col4_city | PS_CCTC_INTL_STG | CCTC_APPL_CL4_CITY | See here |
col4CollegeAttendedId | col4_college_attended_id | PS_CCTC_INTL_STG | CCTC_APPL_CL4_ID | See here |
col4Country | col4_country | PS_CCTC_INTL_STG | CCTC_APPL_CL4_CTRY | See here |
col4DegreeDate | col4_degree_date | PS_CCTC_INTL_STG | CCTC_APPL_CL4_DGDT | See here |
col4DegreeObtained | col4_degree_obtained | PS_CCTC_INTL_STG | CCTC_APPL_CL4_DGRE | See here |
col4EndDate | col4_end_date | PS_CCTC_INTL_STG | CCTC_APPL_CL4_END | See here |
col4ExpelledStatus | col4_expelled_status | PS_CCTC_INTL_STG | CCTC_APPL_CL4_EXP | See here |
col4Major | col4_major | PS_CCTC_INTL_STG | CCTC_APPL_CL4_MJR | See here |
col4Name | col4_name | PS_CCTC_INTL_STG | CCTC_APPL_CL4_NAME | See here |
col4NonUsProvince | col4_non_us_province | PS_CCTC_INTL_STG | CCTC_APPL_CL4_PRVN | See here |
col4NotListed | col4_not_listed | PS_CCTC_INTL_STG | CCTC_APPL_CL4_NL | See here |
col4PrimaryInstructionLanguage | col4_primary_instruction_language | PS_CCTC_INTL_STG | CCTC_APPL_CL4_LANG | See here |
col4StartDate | col4_start_date | PS_CCTC_INTL_STG | CCTC_APPL_CL4_STRT | See here |
col4State | col4_state | PS_CCTC_INTL_STG | CCTC_APPL_CL4_STTE | See here |
collegeCompDate | college_comp_date | PS_CCTC_INTL_STG | CCTC_APPL_CLCOMPDT | See here |
collegeCount | college_count | PS_CCTC_INTL_STG | CCTC_APPL_CLG_CNT | See here |
collegeEduLevel | college_edu_level | PS_CCTC_INTL_STG | CCTC_APPL_CLEDULVL | See here |
collegeExpelledSummary | college_expelled_summary | PS_CCTC_INTL_STG | CCTC_APPL_COL_EXP | See here |
collegeName | college_name | PS_CCTC_INTL_STG | CCTC_APPL_COL_NM | See here |
company | company | PS_CCTC_INTL_STG | CCTC_INTL_AGTCMPNY | See here |
confirmation | confirmation | PS_CCTC_INTL_STG | CCTC_APPL_CFRM_NBR | See here |
consent | consent | PS_CCTC_INTL_STG | CCTC_INFO_CONSENT | See here |
contact | contact | PS_CCTC_INTL_STG | CCTC_INTL_AGTCNTCT | See here |
country | country | PS_CCTC_INTL_STG | CCTC_INTL_AGTCNTRY | See here |
countryOfBirth | country_of_birth | PS_CCTC_INTL_STG | CCTC_BIRTH_COUNTRY | See here |
countryOfCitizenship | country_of_citizenship | PS_CCTC_INTL_STG | CCTC_CITZN_COUNTRY | See here |
cryptokeyid | cryptokeyid | Not Supported | ||
currentMailingAddressOutsideUs | current_mailing_address_outside_us | Not Supported | ||
currentMailingAddressVerified | current_mailing_address_verified | PS_CCTC_INTL_STG | CCTC_MADDR_VALID | See here |
addressValidationOverride | address_validation_override | PS_CCTC_INTL_STG | CCTC_MADDR_VOVR | See here |
addressValidationOverrideTimestamp | address_validation_override_timestamp | PS_CCTC_INTL_STG | CCTC_MADDR_VOVR_TS | See here |
currentMailingCity | current_mailing_city | PS_CCTC_INTL_STG | CCTC_MADDR_CITY | See here |
currentMailingCountry | current_mailing_country | PS_CCTC_INTL_STG | CCTC_MADDR_COUNTRY | See here |
currentMailingNonUsAddress | current_mailing_non_us_address | PS_CCTC_INTL_STG | CCTC_MADDR_USA | See here |
currentMailingNonUsPostalCode | current_mailing_non_us_postal_code | PS_CCTC_INTL_STG | CCTC_MADDR_IZIP | See here |
currentMailingNonUsProvince | current_mailing_non_us_province | PS_CCTC_INTL_STG | CCTC_MADDR_PRVINCE | See here |
currentMailingSameAsPermanent | current_mailing_same_as_permanent | PS_CCTC_INTL_STG | CCTC_PERM_EQ_MAIL | See here |
currentMailingState | current_mailing_state | PS_CCTC_INTL_STG | CCTC_MADDR_STATE | See here |
currentMailingStreet1 | current_mailing_street_1 | PS_CCTC_INTL_STG | CCTC_MADDR_LINE1 | See here |
currentMailingStreet2 | current_mailing_street_2 | PS_CCTC_INTL_STG | CCTC_MADDR_LINE2 | See here |
currentMailingZipCode | current_mailing_zip_code | PS_CCTC_INTL_STG | CCTC_MADDR_POSTCD | See here |
noMailingAddressHomeless | no_mailing_address_homeless | PS_CCTC_INTL_STG | CCTC_MADDR_HOMELSS | See here |
noNonUsaPermAddressHomeless | no_non_usa_perm_address_homeless | PS_CCTC_INTL_STG | CCTC_INTL_ADDRHMLS | See here |
dep1CountryOfBirth | dep1_country_of_birth | PS_CCTC_INTL_STG | CCTC_DP1_COB | See here |
dep1DateOfBirth | dep1_date_of_birth | PS_CCTC_INTL_STG | CCTC_DP1_DOB | See here |
dep1DependentId | dep1_dependent_id |
|
| Not Supported |
dep1FirstName | dep1_first_name | PS_CCTC_INTL_STG | CCTC_DP1_FN | See here |
dep1Gender | dep1_gender | PS_CCTC_INTL_STG | CCTC_DP1_GNDR | See here |
dep1LastName | dep1_last_name | PS_CCTC_INTL_STG | CCTC_DP1_LN | See here |
dep1NoFirstName | dep1_no_first_name | PS_CCTC_INTL_STG | CCTC_DP1_NO_FN | See here |
dep1Relationship | dep1_relationship | PS_CCTC_INTL_STG | CCTC_DP1_RELATION | See here |
dep10CountryOfBirth | dep10_country_of_birth | PS_CCTC_INTL_STG | CCTC_DP10_COB | See here |
dep10DateOfBirth | dep10_date_of_birth | PS_CCTC_INTL_STG | CCTC_DP10_DOB | See here |
dep10DependentId | dep10_dependent_id |
|
| Not Supported |
dep10FirstName | dep10_first_name | PS_CCTC_INTL_STG | CCTC_DP10_FN | See here |
dep10Gender | dep10_gender | PS_CCTC_INTL_STG | CCTC_DP10_GNDR | See here |
dep10LastName | dep10_last_name | PS_CCTC_INTL_STG | CCTC_DP10_LN | See here |
dep10NoFirstName | dep10_no_first_name | PS_CCTC_INTL_STG | CCTC_DP10_NO_FN | See here |
dep10Relationship | dep10_relationship | PS_CCTC_INTL_STG | CCTC_DP10_RELATION | See here |
dep2CountryOfBirth | dep2_country_of_birth | PS_CCTC_INTL_STG | CCTC_DP2_COB | See here |
dep2DateOfBirth | dep2_date_of_birth | PS_CCTC_INTL_STG | CCTC_DP2_DOB | See here |
dep2DependentId | dep2_dependent_id |
|
| Not Supported |
dep2FirstName | dep2_first_name | PS_CCTC_INTL_STG | CCTC_DP2_FN | See here |
dep2Gender | dep2_gender | PS_CCTC_INTL_STG | CCTC_DP2_GNDR | See here |
dep2LastName | dep2_last_name | PS_CCTC_INTL_STG | CCTC_DP2_LN | See here |
dep2NoFirstName | dep2_no_first_name | PS_CCTC_INTL_STG | CCTC_DP2_NO_FN | See here |
dep2Relationship | dep2_relationship | PS_CCTC_INTL_STG | CCTC_DP2_RELATION | See here |
dep3CountryOfBirth | dep3_country_of_birth | PS_CCTC_INTL_STG | CCTC_DP3_COB | See here |
dep3DateOfBirth | dep3_date_of_birth | PS_CCTC_INTL_STG | CCTC_DP3_DOB | See here |
dep3DependentId | dep3_dependent_id |
|
| Not Supported |
dep3FirstName | dep3_first_name | PS_CCTC_INTL_STG | CCTC_DP3_FN | See here |
dep3Gender | dep3_gender | PS_CCTC_INTL_STG | CCTC_DP3_GNDR | See here |
dep3LastName | dep3_last_name | PS_CCTC_INTL_STG | CCTC_DP3_LN | See here |
dep3NoFirstName | dep3_no_first_name | PS_CCTC_INTL_STG | CCTC_DP3_NO_FN | See here |
dep3Relationship | dep3_relationship | PS_CCTC_INTL_STG | CCTC_DP3_RELATION | See here |
dep4CountryOfBirth | dep4_country_of_birth | PS_CCTC_INTL_STG | CCTC_DP4_COB | See here |
dep4DateOfBirth | dep4_date_of_birth | PS_CCTC_INTL_STG | CCTC_DP4_DOB | See here |
dep4DependentId | dep4_dependent_id |
|
| Not Supported |
dep4FirstName | dep4_first_name | PS_CCTC_INTL_STG | CCTC_DP4_FN | See here |
dep4Gender | dep4_gender | PS_CCTC_INTL_STG | CCTC_DP4_GNDR | See here |
dep4LastName | dep4_last_name | PS_CCTC_INTL_STG | CCTC_DP4_LN | See here |
dep4NoFirstName | dep4_no_first_name | PS_CCTC_INTL_STG | CCTC_DP4_NO_FN | See here |
dep4Relationship | dep4_relationship | PS_CCTC_INTL_STG | CCTC_DP4_RELATION | See here |
dep5CountryOfBirth | dep5_country_of_birth | PS_CCTC_INTL_STG | CCTC_DP5_COB | See here |
dep5DateOfBirth | dep5_date_of_birth | PS_CCTC_INTL_STG | CCTC_DP5_DOB | See here |
dep5DependentId | dep5_dependent_id |
|
| Not Supported |
dep5FirstName | dep5_first_name | PS_CCTC_INTL_STG | CCTC_DP5_FN | See here |
dep5Gender | dep5_gender | PS_CCTC_INTL_STG | CCTC_DP5_GNDR | See here |
dep5LastName | dep5_last_name | PS_CCTC_INTL_STG | CCTC_DP5_LN | See here |
dep5NoFirstName | dep5_no_first_name | PS_CCTC_INTL_STG | CCTC_DP5_NO_FN | See here |
dep5Relationship | dep5_relationship | PS_CCTC_INTL_STG | CCTC_DP5_RELATION | See here |
dep6CountryOfBirth | dep6_country_of_birth | PS_CCTC_INTL_STG | CCTC_DP6_COB | See here |
dep6DateOfBirth | dep6_date_of_birth | PS_CCTC_INTL_STG | CCTC_DP6_DOB | See here |
dep6DependentId | dep6_dependent_id |
|
| Not Supported |
dep6FirstName | dep6_first_name | PS_CCTC_INTL_STG | CCTC_DP6_FN | See here |
dep6Gender | dep6_gender | PS_CCTC_INTL_STG | CCTC_DP6_GNDR | See here |
dep6LastName | dep6_last_name | PS_CCTC_INTL_STG | CCTC_DP6_LN | See here |
dep6NoFirstName | dep6_no_first_name | PS_CCTC_INTL_STG | CCTC_DP6_NO_FN | See here |
dep6Relationship | dep6_relationship | PS_CCTC_INTL_STG | CCTC_DP6_RELATION | See here |
dep7CountryOfBirth | dep7_country_of_birth | PS_CCTC_INTL_STG | CCTC_DP7_COB | See here |
dep7DateOfBirth | dep7_date_of_birth | PS_CCTC_INTL_STG | CCTC_DP7_DOB | See here |
dep7DependentId | dep7_dependent_id |
|
| Not Supported |
dep7FirstName | dep7_first_name | PS_CCTC_INTL_STG | CCTC_DP7_FN | See here |
dep7Gender | dep7_gender | PS_CCTC_INTL_STG | CCTC_DP7_GNDR | See here |
dep7LastName | dep7_last_name | PS_CCTC_INTL_STG | CCTC_DP7_LN | See here |
dep7NoFirstName | dep7_no_first_name | PS_CCTC_INTL_STG | CCTC_DP7_NO_FN | See here |
dep7Relationship | dep7_relationship | PS_CCTC_INTL_STG | CCTC_DP7_RELATION | See here |
dep8CountryOfBirth | dep8_country_of_birth | PS_CCTC_INTL_STG | CCTC_DP8_COB | See here |
dep8DateOfBirth | dep8_date_of_birth | PS_CCTC_INTL_STG | CCTC_DP8_DOB | See here |
dep8DependentId | dep8_dependent_id |
|
| Not Supported |
dep8FirstName | dep8_first_name | PS_CCTC_INTL_STG | CCTC_DP8_FN | See here |
dep8Gender | dep8_gender | PS_CCTC_INTL_STG | CCTC_DP8_GNDR | See here |
dep8LastName | dep8_last_name | PS_CCTC_INTL_STG | CCTC_DP8_LN | See here |
dep8NoFirstName | dep8_no_first_name | PS_CCTC_INTL_STG | CCTC_DP8_NO_FN | See here |
dep8Relationship | dep8_relationship | PS_CCTC_INTL_STG | CCTC_DP8_RELATION | See here |
dep9CountryOfBirth | dep9_country_of_birth | PS_CCTC_INTL_STG | CCTC_DP9_COB | See here |
dep9DateOfBirth | dep9_date_of_birth | PS_CCTC_INTL_STG | CCTC_DP9_DOB | See here |
dep9DependentId | dep9_dependent_id |
|
| Not Supported |
dep9FirstName | dep9_first_name | PS_CCTC_INTL_STG | CCTC_DP9_FN | See here |
dep9Gender | dep9_gender | PS_CCTC_INTL_STG | CCTC_DP9_GNDR | See here |
dep9LastName | dep9_last_name | PS_CCTC_INTL_STG | CCTC_DP9_LN | See here |
dep9NoFirstName | dep9_no_first_name | PS_CCTC_INTL_STG | CCTC_DP9_NO_FN | See here |
dep9Relationship | dep9_relationship | PS_CCTC_INTL_STG | CCTC_DP9_RELATION | See here |
educationalGoal | educational_goal | PS_CCTC_INTL_STG | CCTC_EDU_GOAL | See here |
PS_CCTC_INTL_STG | CCTC_EMAIL | See here | ||
emailVerified | email_verified | PS_CCTC_INTL_STG | CCTC_EMAIL_VER | See here |
emailVerifiedTimestamp | email_verified_timestamp | PS_CCTC_INTL_STG | CCTC_EMAIL_VER_TS | See here |
preferredMethodOfContact | preferred_method_of_contact | PS_CCTC_INTL_STG | CCTC_PRF_CNCT_MTHD | See here |
emergencyContactAddressVerified | emergency_contact_address_verified | PS_CCTC_INTL_STG | CCTC_EMRG_ADDRVALD | See here |
emergencyContactCity | emergency_contact_city | PS_CCTC_INTL_STG | CCTC_EMRG_ADDRCITY | See here |
emergencyContactCountry | emergency_contact_country | PS_CCTC_INTL_STG | CCTC_EMRG_ADDRCTRY | See here |
emergencyContactEmail | emergency_contact_email | PS_CCTC_INTL_STG | CCTC_EMRG_EMAIL | See here |
emergencyContactFirstName | emergency_contact_first_name | PS_CCTC_INTL_STG | CCTC_EMRG_FN | See here |
emergencyContactLastName | emergency_contact_last_name | PS_CCTC_INTL_STG | CCTC_EMRG_LN | See here |
emergencyContactNoFirstName | emergency_contact_no_first_name | PS_CCTC_INTL_STG | CCTC_EMRG_NO_FN | See here |
emergencyContactNonUsAddress | emergency_contact_non_us_address | PS_CCTC_INTL_STG | CCTC_EMRG_ADDR_USA | See here |
emergencyContactNonUsPostalCode | emergency_contact_non_us_postal_code | PS_CCTC_INTL_STG | CCTC_EMRG_ADDRIZIP | See here |
emergencyContactNonUsProvince | emergency_contact_non_us_province | PS_CCTC_INTL_STG | CCTC_EMRG_ADDR_PRV | See here |
emergencyContactPhoneAuthTxt | emergency_contact_phone_auth_txt | PS_CCTC_INTL_STG | CCTC_EMRG_PHONESMS | See here |
emergencyContactPhoneExt | emergency_contact_phone_ext | PS_CCTC_INTL_STG | CCTC_EMRG_PHONEEXT | See here |
emergencyContactPhoneNumber | emergency_contact_phone_number | PS_CCTC_INTL_STG | CCTC_EMRG_PHONE | See here |
emergencyContactRelationship | emergency_contact_relationship | PS_CCTC_INTL_STG | CCTC_EMRG_RELATION | See here |
emergencyContactState | emergency_contact_state | PS_CCTC_INTL_STG | CCTC_EMRG_ADDRSTTE | See here |
emergencyContactStreet1 | emergency_contact_street_1 | PS_CCTC_INTL_STG | CCTC_EMRG_ADDRLIN1 | See here |
emergencyContactStreet2 | emergency_contact_street_2 | PS_CCTC_INTL_STG | CCTC_EMRG_ADDRLIN2 | See here |
emergencyContactZipCode | emergency_contact_zip_code | PS_CCTC_INTL_STG | CCTC_EMRG_ADDRPOST | See here |
engMonthsStudied | eng_months_studied | PS_CCTC_INTL_STG | CCTC_INTL_MON_ENG | See here |
engProficiencyDate | eng_proficiency_date | PS_CCTC_INTL_STG | CCTC_INTL_ENGPRFDT | See here |
engProficiencyOther | eng_proficiency_other | PS_CCTC_INTL_STG | CCTC_INTL_ENGPRFOT | See here |
engProficiencyPrerequisite | eng_proficiency_prerequisite | PS_CCTC_INTL_STG | CCTC_INTL_ENGPRFPQ | See here |
engProficiencyReq | eng_proficiency_req |
|
| Not Supported |
engProficiencyScore | eng_proficiency_score | PS_CCTC_INTL_STG | CCTC_INTL_ENGPRFSC | See here |
engProficiencyShowScore | eng_proficiency_show_score | PS_CCTC_INTL_STG | CCTC_INTL_ENGPRFSS | See here |
engProficiencyType | eng_proficiency_type | PS_CCTC_INTL_STG | CCTC_INTL_ENGPRFTP | See here |
enrollStatus | enroll_status | PS_CCTC_INTL_STG | CCTC_APPL_ENR_STAT | See here |
enrollTermCode | enroll_term_code | PS_CCTC_INTL_STG | CCTC_APPL_ENRTRMCD | See here |
enrollTermDescription | enroll_term_description | PS_CCTC_INTL_STG | CCTC_APPL_ENRTRMDS | See here |
esignature | esignature | PS_CCTC_INTL_STG | CCTC_ESIGNATURE | See here |
expirationDate | expiration_date | PS_CCTC_INTL_STG | CCTC_ALIEN_REG_EXP | See here |
faxNumberNumber | fax_number_number | PS_CCTC_INTL_STG | CCTC_FAX_NUMBER | See here |
firstname | firstname | PS_CCTC_INTL_STG | CCTC_LGL_FIRST_NM | See here |
gender | gender | PS_CCTC_INTL_STG | CCTC_GENDER | See here |
higherLang | higher_lang |
|
| Not Supported |
highestCompDate | highest_comp_date | PS_CCTC_INTL_STG | CCTC_APPL_HRCOMPDT | See here |
highestEduLevel | highest_edu_level | PS_CCTC_INTL_STG | CCTC_APPL_HREDULVL | See here |
hispanic | hispanic | PS_CCTC_INTL_STG | CCTC_HISPANIC | See here |
hsAddressVerified | hs_address_verified | PS_CCTC_INTL_STG | CCTC_APPL_HS_ADDRV | See here |
hsCds | hs_cds | PS_CCTC_INTL_STG | CCTC_APPL_HS_CDS | See here |
hsCdsFull | hs_cds_full | PS_CCTC_INTL_STG | CCTC_APPL_HS_FCDS | See here |
hsCeeb | hs_ceeb | PS_CCTC_INTL_STG | CCTC_APPL_HS_CEEB | See here |
hsCity | hs_city | PS_CCTC_INTL_STG | CCTC_APPL_HS_CITY | See here |
hsCompDate | hs_comp_date | PS_CCTC_INTL_STG | CCTC_APPL_HSCOMPDT | See here |
hsCountry | hs_country | PS_CCTC_INTL_STG | CCTC_APPL_HS_CNTRY | See here |
hsDiplomaCert | hs_diploma_cert | PS_CCTC_INTL_STG | CCTC_APPL_HS_DPLMA | See here |
hsDiplomaCertDate | hs_diploma_cert_date | PS_CCTC_INTL_STG | CCTC_APPL_HSDPMADT | See here |
hsEduLevel | hs_edu_level | PS_CCTC_INTL_STG | CCTC_APPL_HSEDULVL | See here |
hsEndDate | hs_end_date | PS_CCTC_INTL_STG | CCTC_APPL_HSENDDT | See here |
hsLang | hs_lang | PS_CCTC_INTL_STG | CCTC_APPL_HSLANGCD | See here |
hsName | hs_name | PS_CCTC_INTL_STG | CCTC_APPL_HS_NAME | See here |
hsNonUsAddress | hs_non_us_address | PS_CCTC_INTL_STG | CCTC_APPL_HS_USA | See here |
hsNonUsPostalCode | hs_non_us_postal_code | PS_CCTC_INTL_STG | CCTC_APPL_HS_IZIP | See here |
hsNonUsProvince | hs_non_us_province | PS_CCTC_INTL_STG | CCTC_APPL_HS_PRVNC | See here |
hsNotListed | hs_not_listed | PS_CCTC_INTL_STG | CCTC_APPL_HS_NL | See here |
hsStartDate | hs_start_date | PS_CCTC_INTL_STG | CCTC_APPL_HSSTRTDT | See here |
hsState | hs_state | PS_CCTC_INTL_STG | CCTC_APPL_HS_STATE | See here |
hsStreet1 | hs_street_1 | PS_CCTC_INTL_STG | CCTC_APPL_HS_LINE1 | See here |
hsStreet2 | hs_street_2 | PS_CCTC_INTL_STG | CCTC_APPL_HS_LINE2 | See here |
hsType | hs_type | PS_CCTC_INTL_STG | CCTC_INTL_HS_TYPE | See here |
hsZipCode | hs_zip_code | PS_CCTC_INTL_STG | CCTC_APPL_HSPOSTCD | See here |
i20ExpirationDate | i20_expiration_date | PS_CCTC_INTL_STG | CCTC_INTL_I20EXPDT | See here |
i20IssuingSchoolName | i20_issuing_school_name | PS_CCTC_INTL_STG | CCTC_INTL_I20SCHOL | See here |
i94AdmissionNumber | i94_admission_number | PS_CCTC_INTL_STG | CCTC_INTL_I94_ADM | See here |
i94ExpirationDate | i94_expiration_date | PS_CCTC_INTL_STG | CCTC_INTL_I94_EXP | See here |
intended4YearMajor | intended_4_year_major | PS_CCTC_INTL_STG | CCTC_INTL_4YR_MJR | See here |
ipAddress | ip_address | PS_CCTC_INTL_STG | CCTC_IP_ADDRESS | See here |
issueDate | issue_date | PS_CCTC_INTL_STG | CCTC_ALIEN_REG_ISS | See here |
lastPage | last_page | PS_CCTC_INTL_STG | CCTC_APPL_LAST_PG | See here |
lastname | lastname | PS_CCTC_INTL_STG | CCTC_LGL_LAST_NM | See here |
mainPhoneAuthTxt | main_phone_auth_txt | PS_CCTC_INTL_STG | CCTC_PHONE_MAINSMS | See here |
mainPhoneExt | main_phone_ext | PS_CCTC_INTL_STG | CCTC_PHONE_MAIN_EX | See here |
mainPhoneNumber | main_phone_number | PS_CCTC_INTL_STG | CCTC_PHONE_MAIN | See here |
mainPhoneVerified | main_phone_verified | PS_CCTC_INTL_STG | CCTC_PHONE_MN_VER | See here |
mainPhoneVerifiedTimestamp | main_phone_verified_timestamp | PS_CCTC_INTL_STG | CCTC_PHONE_MN_VRTS | See here |
majorCode | major_code | PS_CCTC_INTL_STG | CCTC_APPL_MJR_CD | See here |
majorDescription | major_description | PS_CCTC_INTL_STG | CCTC_APPL_MJR_DS | See here |
majorCategory | major_category | PS_CCTC_INTL_STG | CCTC_APPL_MJR_CAT | See here |
cipCode | cip_code | PS_CCTC_INTL_STG | CCTC_APPL_MJR_CIP | See here |
noI94ExpirationDate | no_i94_expiration_date | PS_CCTC_INTL_STG | CCTC_INTL_I94NOEXP | See here |
noVisa | no_visa | PS_CCTC_INTL_STG | CCTC_VISA_NONE | See here |
nonUsAddress | non_us_address | PS_CCTC_INTL_STG | CCTC_INTL_AGTUSA | See here |
nonUsPermanentHomeAddressSameAsPermanent | non_us_permanent_home_address_same_as_permanent | PS_CCTC_INTL_STG | CCTC_INTL_ADDRSAME | See here |
nonUsPermanentHomeAddressVerified | non_us_permanent_home_address_verified | PS_CCTC_INTL_STG | CCTC_INTL_ADDRVALD | See here |
nonUsPermanentHomeCity | non_us_permanent_home_city | PS_CCTC_INTL_STG | CCTC_INTL_ADDRCITY | See here |
nonUsPermanentHomeCountry | non_us_permanent_home_country | PS_CCTC_INTL_STG | CCTC_INTL_ADDRCTRY | See here |
nonUsPermanentHomeNonUsAddress | non_us_permanent_home_non_us_address | PS_CCTC_INTL_STG | CCTC_INTL_ADDR_USA | See here |
nonUsPermanentHomeNonUsPostalCode | non_us_permanent_home_non_us_postal_code | PS_CCTC_INTL_STG | CCTC_INTL_ADDRIZIP | See here |
nonUsPermanentHomeNonUsProvince | non_us_permanent_home_non_us_province | PS_CCTC_INTL_STG | CCTC_INTL_ADDR_PRV | See here |
nonUsPermanentHomeStreet1 | non_us_permanent_home_street_1 | PS_CCTC_INTL_STG | CCTC_INTL_ADDRLIN1 | See here |
nonUsPermanentHomeStreet2 | non_us_permanent_home_street_2 | PS_CCTC_INTL_STG | CCTC_INTL_ADDRLIN2 | See here |
noNonUsPermanentAddrHomeless | non_us_permanent_home_homeless | PS_CCTC_INTL_STG | CCTC_INTL_ADDRHMLS | See here |
nonUsPhoneAuthTxt | non_us_phone_auth_txt | PS_CCTC_INTL_STG | CCTC_INTL_1PHNESMS | See here |
nonUsPhoneExt | non_us_phone_ext | PS_CCTC_INTL_STG | CCTC_INTL_1PHNEEXT | See here |
nonUsPhoneNumber | non_us_phone_number | PS_CCTC_INTL_STG | CCTC_INTL_1PHNE | See here |
nonUsPostalCode | non_us_postal_code | PS_CCTC_INTL_STG | CCTC_INTL_AGTIZIP | See here |
nonUsProvince | non_us_province | PS_CCTC_INTL_STG | CCTC_INTL_AGTPRVNC | See here |
numberOfDependents | number_of_dependents | PS_CCTC_INTL_STG | CCTC_NBR_DEPENDENT | See here |
numberOfPracticalTraining | number_of_practical_training | PS_CCTC_INTL_STG | CCTC_INTL_NBR_PT | See here |
otherfirstname | otherfirstname | PS_CCTC_INTL_STG | CCTC_AKA_FIRST_NM | See here |
otherlastname | otherlastname | PS_CCTC_INTL_STG | CCTC_AKA_LAST_NM | See here |
othermiddlename | othermiddlename | PS_CCTC_INTL_STG | CCTC_AKA_MIDDLE_NM | See here |
parentGuardianAddressVerified | parent_guardian_address_verified | PS_CCTC_INTL_STG | CCTC_PG1_ADDRVALID | See here |
parentGuardianCity | parent_guardian_city | PS_CCTC_INTL_STG | CCTC_PG1_ADDR_CITY | See here |
parentGuardianCountry | parent_guardian_country | PS_CCTC_INTL_STG | CCTC_PG1_ADDR_CTRY | See here |
parentGuardianEmail | parent_guardian_email | PS_CCTC_INTL_STG | CCTC_PG1_EMAIL | See here |
parentGuardianFirstName | parent_guardian_first_name | PS_CCTC_INTL_STG | CCTC_PG1_FIRST_NM | See here |
parentGuardianLastName | parent_guardian_last_name | PS_CCTC_INTL_STG | CCTC_PG1_LAST_NM | See here |
parentGuardianNoFirstName | parent_guardian_no_first_name | PS_CCTC_INTL_STG | CCTC_PG1_NO_FN | See here |
parentGuardianNonUsAddress | parent_guardian_non_us_address | PS_CCTC_INTL_STG | CCTC_PG1_ADDR_USA | See here |
parentGuardianNonUsPostalCode | parent_guardian_non_us_postal_code | PS_CCTC_INTL_STG | CCTC_PG1_ADDR_IZIP | See here |
parentGuardianNonUsProvince | parent_guardian_non_us_province | PS_CCTC_INTL_STG | CCTC_PG1_ADDR_PRV | See here |
parentGuardianPhoneAuthTxt | parent_guardian_phone_auth_txt | PS_CCTC_INTL_STG | CCTC_PG1_PHONESMS | See here |
parentGuardianPhoneExt | parent_guardian_phone_ext | PS_CCTC_INTL_STG | CCTC_PG1_PHONEEXT | See here |
parentGuardianPhoneNumber | parent_guardian_phone_number | PS_CCTC_INTL_STG | CCTC_PG1_PHONE | See here |
parentGuardianRelationship | parent_guardian_relationship | PS_CCTC_INTL_STG | CCTC_PG1_RELATION | See here |
parentGuardianState | parent_guardian_state | PS_CCTC_INTL_STG | CCTC_PG1_ADDRSTTE | See here |
parentGuardianStreet1 | parent_guardian_street_1 | PS_CCTC_INTL_STG | CCTC_PG1_ADDRLIN1 | See here |
parentGuardianStreet2 | parent_guardian_street_2 | PS_CCTC_INTL_STG | CCTC_PG1_ADDRLIN2 | See here |
parentGuardianZipCode | parent_guardian_zip_code | PS_CCTC_INTL_STG | CCTC_PG1_ADDRPOST | See here |
passportCountryOfIssuance | passport_country_of_issuance | PS_CCTC_INTL_STG | CCTC_INTL_PP_CNTRY | See here |
passportExpirationDate | passport_expiration_date | PS_CCTC_INTL_STG | CCTC_INTL_PP_EXP | See here |
passportNotYet | passport_not_yet | PS_CCTC_INTL_STG | CCTC_INTL_PP_NONE | See here |
passportNumber | passport_number | PS_CCTC_INTL_STG | CCTC_INTL_PP_NBR | See here |
permAddrAddressVerified | perm_addr_address_verified | PS_CCTC_INTL_STG | CCTC_PADDR_VALID | See here |
permAddrCity | perm_addr_city | PS_CCTC_INTL_STG | CCTC_PADDR_CITY | See here |
permAddrCountry | perm_addr_country | PS_CCTC_INTL_STG | CCTC_PADDR_COUNTRY | See here |
permAddrNonUsAddress | perm_addr_non_us_address | PS_CCTC_INTL_STG | CCTC_PADDR_USA | See here |
permAddrNonUsPostalCode | perm_addr_non_us_postal_code | PS_CCTC_INTL_STG | CCTC_PADDR_IZIP | See here |
permAddrNonUsProvince | perm_addr_non_us_province | PS_CCTC_INTL_STG | CCTC_PADDR_PRVINCE | See here |
permAddrState | perm_addr_state | PS_CCTC_INTL_STG | CCTC_PADDR_STATE | See here |
permAddrStreet1 | perm_addr_street_1 | PS_CCTC_INTL_STG | CCTC_PADDR_LINE1 | See here |
permAddrStreet2 | perm_addr_street_2 | PS_CCTC_INTL_STG | CCTC_PADDR_LINE2 | See here |
permAddrZipCode | perm_addr_zip_code | PS_CCTC_INTL_STG | CCTC_PADDR_POSTCD | See here |
noPermAddressHomeless | no_perm_address_homeless | PS_CCTC_INTL_STG | CCTC_PADDR_HOMELSS | See here |
phoneAuthTxt | phone_auth_txt | PS_CCTC_INTL_STG | CCTC_INTL_3PHNESMS | See here |
phoneExt | phone_ext | PS_CCTC_INTL_STG | CCTC_INTL_3PHNEEXT | See here |
phoneNumber | phone_number | PS_CCTC_INTL_STG | CCTC_INTL_3PHNE | See here |
preferredFirstname | preferred_firstname | PS_CCTC_INTL_STG | CCTC_PRF_FIRST_NM | See here |
preferredLastname | preferred_lastname | PS_CCTC_INTL_STG | CCTC_PRF_LAST_NM | See here |
preferredMiddlename | preferred_middlename | PS_CCTC_INTL_STG | CCTC_PRF_MIDDLE_NM | See here |
preferredName | preferred_name | PS_CCTC_INTL_STG | CCTC_PRF_NM_SET | See here |
presentlyStudyingInUs | presently_studying_in_us | PS_CCTC_INTL_STG | CCTC_INTL_STDY_USA | See here |
primaryLanguage | primary_language | PS_CCTC_INTL_STG | CCTC_LANG_CD | See here |
pt1AuthorizingSchool | pt1_authorizing_school | PS_CCTC_INTL_STG | CCTC_PT1_SCHOOL_NM | See here |
pt1EndDate | pt1_end_date | PS_CCTC_INTL_STG | CCTC_PT1_END_DT | See here |
pt1PracticalTrainingId | pt1_practical_training_id | Not Supported | ||
pt1StartDate | pt1_start_date | PS_CCTC_INTL_STG | CCTC_PT1_START_DT | See here |
pt1Type | pt1_type | PS_CCTC_INTL_STG | CCTC_PT1_TYPE | See here |
pt2AuthorizingSchool | pt2_authorizing_school | PS_CCTC_INTL_STG | CCTC_PT2_SCHOOL_NM | See here |
pt2EndDate | pt2_end_date | PS_CCTC_INTL_STG | CCTC_PT2_END_DT | See here |
pt2PracticalTrainingId | pt2_practical_training_id | Not Supported | ||
pt2StartDate | pt2_start_date | PS_CCTC_INTL_STG | CCTC_PT2_START_DT | See here |
pt2Type | pt2_type | PS_CCTC_INTL_STG | CCTC_PT2_TYPE | See here |
pt3AuthorizingSchool | pt3_authorizing_school | PS_CCTC_INTL_STG | CCTC_PT3_SCHOOL_NM | See here |
pt3EndDate | pt3_end_date | PS_CCTC_INTL_STG | CCTC_PT3_END_DT | See here |
pt3PracticalTrainingId | pt3_practical_training_id | Not Supported | ||
pt3StartDate | pt3_start_date | PS_CCTC_INTL_STG | CCTC_PT3_START_DT | See here |
pt3Type | pt3_type | PS_CCTC_INTL_STG | CCTC_PT3_TYPE | See here |
pt4AuthorizingSchool | pt4_authorizing_school | PS_CCTC_INTL_STG | CCTC_PT4_SCHOOL_NM | See here |
pt4EndDate | pt4_end_date | PS_CCTC_INTL_STG | CCTC_PT4_END_DT | See here |
pt4PracticalTrainingId | pt4_practical_training_id | Not Supported | ||
pt4StartDate | pt4_start_date | PS_CCTC_INTL_STG | CCTC_PT4_START_DT | See here |
pt4Type | pt4_type | PS_CCTC_INTL_STG | CCTC_PT4_TYPE | See here |
raceEthnicity | race_ethnicity | PS_CCTC_INTL_STG | CCTC_RACE_ETH_FLGS | See here |
raceEthnicFull | race_ethnic_full | PS_CCTC_INTL_STG | CCTC_RACE_ETHNIC_F | See here |
raceGroup | race_group | PS_CCTC_INTL_STG | CCTC_RACE_GROUP | See here |
residesInUs | resides_in_us | PS_CCTC_INTL_STG | CCTC_INTL_RESIDEUS | See here |
salt | salt | Not Supported | ||
secondPhoneAuthTxt | second_phone_auth_txt | PS_CCTC_INTL_STG | CCTC_PHONE_SCNDSMS | See here |
secondPhoneExt | second_phone_ext | PS_CCTC_INTL_STG | CCTC_PHONE_SCND_EX | See here |
secondPhoneNumber | second_phone_number | PS_CCTC_INTL_STG | CCTC_PHONE_SCND | See here |
sevisIdNumber | sevis_id_number | PS_CCTC_INTL_STG | CCTC_SEVIS_ID | See here |
signature | signature | Not Supported | ||
ssn | ssn | PS_CCTC_INTL_STG | CCTC_SSN | See here |
ssnNo | ssn_no | PS_CCTC_INTL_STG | CCTC_APPL_SSN_NONE | See here |
ssnException | ssn_exception | PS_CCTC_INTL_STG | CCTC_APPL_SSN_EXCP | See here |
ssnLast4 | ssn_last4 | PS_CCTC_INTL_STG | CCTC_SSN_LST4 | See here |
ssnType | ssn_type | PS_CCTC_INTL_STG | CCTC_APPL_SSN_TYPE | See here |
state | state | PS_CCTC_INTL_STG | CCTC_INTL_AGTSTATE | See here |
status | status | PS_CCTC_INTL_STG | CCTC_APPL_STATUS | See here |
street1 | street_1 | PS_CCTC_INTL_STG | CCTC_INTL_AGTLINE1 | See here |
street2 | street_2 | PS_CCTC_INTL_STG | CCTC_INTL_AGTLINE2 | See here |
suffix | suffix | PS_CCTC_INTL_STG | CCTC_LGL_SUFFIX | See here |
supPageCode | sup_page_code | PS_CCTC_INTL_STG | CCTC_APPL_SQ_PG_CD | See here |
termEndDate | term_end_date | PS_CCTC_INTL_STG | CCTC_TERM_END_DT | See here |
termStartDate | term_start_date | PS_CCTC_INTL_STG | CCTC_TERM_START_DT | See here |
tstmpCreate | tstmp_create | PS_CCTC_INTL_STG | CCTC_APPL_CRTE_TS | See here |
tstmpDownload | tstmp_download | PS_CCTC_INTL_STG | CCTC_APPL_DWNLD_TS | See here |
tstmpSubmit | tstmp_submit | PS_CCTC_INTL_STG | CCTC_APPL_SBMT_TS | See here |
tstmpUpdate | tstmp_update | PS_CCTC_INTL_STG | CCTC_APPL_UPDT_TS | See here |
visaType | visa_type | PS_CCTC_INTL_STG | CCTC_VISA_TYPE | See here |
zipCode | zip_code | PS_CCTC_INTL_STG | CCTC_INTL_AGTPOST | See here |
PS_CCTC_INTL_STG | STATUS_FLAG | A blank value whenever a new row is created. May be optionally used by the college to track processing | ||
PS_CCTC_INTL_STG | STATUS_DTTM | Used for tracking/processing; defaults to the current date/time when a row is created, but should be updated if/when the STATUS_FLAG field is changed | ||
PS_CCTC_INTL_STG | DESCRLONG_NOTES | A blank value whenever a new row is created. May be optionally used by the college to track processing | ||
PS_CCTC_INTL_STG | LASTUPDOPRID | The default value is “CCTC” when a row is created, but this value should be updated to whichever operatorID the college’s IT department changes it to, if desired | ||
PS_CCTC_INTL_STG | LASTUPDDTTM | Last updated date/time |
Supplemental Questions Data Fields Mappings - PeopleSoft
The table below pertains to the International App Supplemental Questions fields.
CCC Field Name | PeopleSoft DB Staging Table | PeopleSoft Field Name | Explanation |
---|---|---|---|
app_id | PS_CCTC_INTLSQ_STG | CCTC_APPL_ID | See here |
supp_text_01 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_TXT_01 | See here |
supp_text_02 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_TXT_02 | See here |
supp_text_03 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_TXT_03 | See here |
supp_text_04 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_TXT_04 | See here |
supp_text_05 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_TXT_05 | See here |
supp_text_06 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_TXT_06 | See here |
supp_text_07 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_TXT_07 | See here |
supp_text_08 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_TXT_08 | See here |
supp_text_09 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_TXT_09 | See here |
supp_text_10 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_TXT_10 | See here |
supp_text_11 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_TXT_11 | See here |
supp_text_12 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_TXT_12 | See here |
supp_text_13 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_TXT_13 | See here |
supp_text_14 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_TXT_14 | See here |
supp_text_15 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_TXT_15 | See here |
supp_text_16 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_TXT_16 | See here |
supp_text_17 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_TXT_17 | See here |
supp_text_18 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_TXT_18 | See here |
supp_text_19 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_TXT_19 | See here |
supp_text_20 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_TXT_20 | See here |
supp_check_01 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_CBX_01 | See here |
supp_check_02 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_CBX_02 | See here |
supp_check_03 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_CBX_03 | See here |
supp_check_04 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_CBX_04 | See here |
supp_check_05 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_CBX_05 | See here |
supp_check_06 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_CBX_06 | See here |
supp_check_07 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_CBX_07 | See here |
supp_check_08 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_CBX_08 | See here |
supp_check_09 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_CBX_09 | See here |
supp_check_10 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_CBX_10 | See here |
supp_check_11 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_CBX_11 | See here |
supp_check_12 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_CBX_12 | See here |
supp_check_13 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_CBX_13 | See here |
supp_check_14 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_CBX_14 | See here |
supp_check_15 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_CBX_15 | See here |
supp_check_16 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_CBX_16 | See here |
supp_check_17 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_CBX_17 | See here |
supp_check_18 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_CBX_18 | See here |
supp_check_19 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_CBX_19 | See here |
supp_check_20 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_CBX_20 | See here |
supp_check_21 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_CBX_21 | See here |
supp_check_22 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_CBX_22 | See here |
supp_check_23 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_CBX_23 | See here |
supp_check_24 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_CBX_24 | See here |
supp_check_25 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_CBX_25 | See here |
supp_check_26 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_CBX_26 | See here |
supp_check_27 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_CBX_27 | See here |
supp_check_28 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_CBX_28 | See here |
supp_check_29 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_CBX_29 | See here |
supp_check_30 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_CBX_30 | See here |
supp_check_31 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_CBX_31 | See here |
supp_check_32 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_CBX_32 | See here |
supp_check_33 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_CBX_33 | See here |
supp_check_34 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_CBX_34 | See here |
supp_check_35 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_CBX_35 | See here |
supp_check_36 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_CBX_36 | See here |
supp_check_37 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_CBX_37 | See here |
supp_check_38 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_CBX_38 | See here |
supp_check_39 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_CBX_39 | See here |
supp_check_40 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_CBX_40 | See here |
supp_check_41 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_CBX_41 | See here |
supp_check_42 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_CBX_42 | See here |
supp_check_43 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_CBX_43 | See here |
supp_check_44 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_CBX_44 | See here |
supp_check_45 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_CBX_45 | See here |
supp_check_46 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_CBX_46 | See here |
supp_check_47 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_CBX_47 | See here |
supp_check_48 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_CBX_48 | See here |
supp_check_49 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_CBX_49 | See here |
supp_check_50 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_CBX_50 | See here |
supp_yesno_01 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_YN_01 | See here |
supp_yesno_02 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_YN_02 | See here |
supp_yesno_03 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_YN_03 | See here |
supp_yesno_04 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_YN_04 | See here |
supp_yesno_05 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_YN_05 | See here |
supp_yesno_06 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_YN_06 | See here |
supp_yesno_07 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_YN_07 | See here |
supp_yesno_08 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_YN_08 | See here |
supp_yesno_09 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_YN_09 | See here |
supp_yesno_10 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_YN_10 | See here |
supp_yesno_11 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_YN_11 | See here |
supp_yesno_12 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_YN_12 | See here |
supp_yesno_13 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_YN_13 | See here |
supp_yesno_14 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_YN_14 | See here |
supp_yesno_15 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_YN_15 | See here |
supp_yesno_16 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_YN_16 | See here |
supp_yesno_17 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_YN_17 | See here |
supp_yesno_18 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_YN_18 | See here |
supp_yesno_19 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_YN_19 | See here |
supp_yesno_20 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_YN_20 | See here |
supp_yesno_21 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_YN_21 | See here |
supp_yesno_22 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_YN_22 | See here |
supp_yesno_23 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_YN_23 | See here |
supp_yesno_24 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_YN_24 | See here |
supp_yesno_25 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_YN_25 | See here |
supp_yesno_26 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_YN_26 | See here |
supp_yesno_27 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_YN_27 | See here |
supp_yesno_28 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_YN_28 | See here |
supp_yesno_29 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_YN_29 | See here |
supp_yesno_30 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_YN_30 | See here |
supp_menu_01 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_MNU_01 | See here |
supp_menu_02 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_MNU_02 | See here |
supp_menu_03 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_MNU_03 | See here |
supp_menu_04 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_MNU_04 | See here |
supp_menu_05 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_MNU_05 | See here |
supp_menu_06 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_MNU_06 | See here |
supp_menu_07 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_MNU_07 | See here |
supp_menu_08 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_MNU_08 | See here |
supp_menu_09 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_MNU_09 | See here |
supp_menu_10 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_MNU_10 | See here |
supp_menu_11 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_MNU_11 | See here |
supp_menu_12 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_MNU_12 | See here |
supp_menu_13 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_MNU_13 | See here |
supp_menu_14 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_MNU_14 | See here |
supp_menu_15 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_MNU_15 | See here |
supp_menu_16 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_MNU_16 | See here |
supp_menu_17 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_MNU_17 | See here |
supp_menu_18 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_MNU_18 | See here |
supp_menu_19 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_MNU_19 | See here |
supp_menu_20 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_MNU_20 | See here |
supp_menu_21 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_MNU_21 | See here |
supp_menu_22 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_MNU_22 | See here |
supp_menu_23 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_MNU_23 | See here |
supp_menu_24 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_MNU_24 | See here |
supp_menu_25 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_MNU_25 | See here |
supp_menu_26 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_MNU_26 | See here |
supp_menu_27 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_MNU_27 | See here |
supp_menu_28 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_MNU_28 | See here |
supp_menu_29 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_MNU_29 | See here |
supp_menu_30 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_MNU_30 | See here |
supp_date_01 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_DT_01 | See here |
supp_date_02 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_DT_02 | See here |
supp_date_03 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_DT_03 | See here |
supp_date_04 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_DT_04 | See here |
supp_date_05 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_DT_05 | See here |
supp_state_01 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_ST_01 | See here |
supp_state_02 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_ST_02 | See here |
supp_state_03 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_ST_03 | See here |
supp_state_04 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_ST_04 | See here |
supp_state_05 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_ST_05 | See here |
supp_country_01 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_CT_01 | See here |
supp_country_02 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_CT_02 | See here |
supp_country_03 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_CT_03 | See here |
supp_country_04 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_CT_04 | See here |
supp_country_05 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_CT_05 | See here |
supp_phonenumber_01 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_PHN_01 | See here |
supp_phonenumber_02 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_PHN_02 | See here |
supp_phonenumber_03 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_PHN_03 | See here |
supp_phonenumber_04 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_PHN_04 | See here |
supp_phonenumber_05 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_PHN_05 | See here |
supp_secret_01 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_SCT_01 | See here |
supp_secret_02 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_SCT_02 | See here |
supp_secret_03 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_SCT_03 | See here |
supp_secret_04 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_SCT_04 | See here |
supp_secret_05 | PS_CCTC_INTLSQ_STG | CCTC_APPLSQ_SCT_05 | See here |
PS_CCTC_INTLSQ_STG | STATUS_FLAG | A single blank character whenever a new row is created. May be optionally used by the college to track processing | |
PS_CCTC_INTLSQ_STG | STATUS_DTTM | Used for tracking/processing; defaults to the current date/time when a row is created, should be updated if/when the STATUS_FLAG field is changed | |
PS_CCTC_INTLSQ_STG | DESCRLONG_NOTES | A blank value whenever a new row is created. May be optionally used by the college to track processing | |
PS_CCTC_INTLSQ_STG | LASTUPDOPRID | The default value is “CCTC” when a row is created, but this value should be updated to whichever operatorID the college’s IT department changes it to, if desired | |
PS_CCTC_INTLSQ_STG | LASTUPDDTTM | Last updated date/time |