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 | 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 |
|
permAddrStreet1 | perm_addr_street_1 | PS_CCTC_INTL_STG | CCTC_PADDR_LINE1 |
|
permAddrStreet2 | perm_addr_street_2 | PS_CCTC_INTL_STG | CCTC_PADDR_LINE2 |
|
permAddrZipCode | perm_addr_zip_code | PS_CCTC_INTL_STG | CCTC_PADDR_POSTCD |
|
noPermAddressHomeless | no_perm_address_homeless | PS_CCTC_INTL_STG | CCTC_PADDR_HOMELSS |
|
phoneAuthTxt | phone_auth_txt | PS_CCTC_INTL_STG | CCTC_INTL_3PHNESMS |
|
phoneExt | phone_ext | PS_CCTC_INTL_STG | CCTC_INTL_3PHNEEXT |
|
phoneNumber | phone_number | PS_CCTC_INTL_STG | CCTC_INTL_3PHNE |
|
preferredFirstname | preferred_firstname | PS_CCTC_INTL_STG | CCTC_PRF_FIRST_NM |
|
preferredLastname | preferred_lastname | PS_CCTC_INTL_STG | CCTC_PRF_LAST_NM |
|
preferredMiddlename | preferred_middlename | PS_CCTC_INTL_STG | CCTC_PRF_MIDDLE_NM |
|
preferredName | preferred_name | PS_CCTC_INTL_STG | CCTC_PRF_NM_SET |
|
presentlyStudyingInUs | presently_studying_in_us | PS_CCTC_INTL_STG | CCTC_INTL_STDY_USA |
|
primaryLanguage | primary_language | PS_CCTC_INTL_STG | CCTC_LANG_CD |
|
pt1AuthorizingSchool | pt1_authorizing_school | PS_CCTC_INTL_STG | CCTC_PT1_SCHOOL_NM |
|
pt1EndDate | pt1_end_date | PS_CCTC_INTL_STG | CCTC_PT1_END_DT |
|
pt1PracticalTrainingId | pt1_practical_training_id |
| ||
pt1StartDate | pt1_start_date | PS_CCTC_INTL_STG | CCTC_PT1_START_DT |
|
pt1Type | pt1_type | PS_CCTC_INTL_STG | CCTC_PT1_TYPE |
|
pt2AuthorizingSchool | pt2_authorizing_school | PS_CCTC_INTL_STG | CCTC_PT2_SCHOOL_NM |
|
pt2EndDate | pt2_end_date | PS_CCTC_INTL_STG | CCTC_PT2_END_DT |
|
pt2PracticalTrainingId | pt2_practical_training_id |
| ||
pt2StartDate | pt2_start_date | PS_CCTC_INTL_STG | CCTC_PT2_START_DT |
|
pt2Type | pt2_type | PS_CCTC_INTL_STG | CCTC_PT2_TYPE |
|
pt3AuthorizingSchool | pt3_authorizing_school | PS_CCTC_INTL_STG | CCTC_PT3_SCHOOL_NM |
|
pt3EndDate | pt3_end_date | PS_CCTC_INTL_STG | CCTC_PT3_END_DT |
|
pt3PracticalTrainingId | pt3_practical_training_id |
| ||
pt3StartDate | pt3_start_date | PS_CCTC_INTL_STG | CCTC_PT3_START_DT |
|
pt3Type | pt3_type | PS_CCTC_INTL_STG | CCTC_PT3_TYPE |
|
pt4AuthorizingSchool | pt4_authorizing_school | PS_CCTC_INTL_STG | CCTC_PT4_SCHOOL_NM |
|
pt4EndDate | pt4_end_date | PS_CCTC_INTL_STG | CCTC_PT4_END_DT |
|
pt4PracticalTrainingId | pt4_practical_training_id |
| ||
pt4StartDate | pt4_start_date | PS_CCTC_INTL_STG | CCTC_PT4_START_DT |
|
pt4Type | pt4_type | PS_CCTC_INTL_STG | CCTC_PT4_TYPE |
|
raceEthnicity | race_ethnicity | PS_CCTC_INTL_STG | CCTC_RACE_ETH_FLGS |
|
raceEthnicFull | race_ethnic_full | PS_CCTC_INTL_STG | CCTC_RACE_ETHNIC_F |
|
raceGroup | race_group | PS_CCTC_INTL_STG | CCTC_RACE_GROUP |
|
residesInUs | resides_in_us | PS_CCTC_INTL_STG | CCTC_INTL_RESIDEUS |
|
salt | salt |
| ||
secondPhoneAuthTxt | second_phone_auth_txt | PS_CCTC_INTL_STG | CCTC_PHONE_SCNDSMS |
|
secondPhoneExt | second_phone_ext | PS_CCTC_INTL_STG | CCTC_PHONE_SCND_EX |
|
secondPhoneNumber | second_phone_number | PS_CCTC_INTL_STG | CCTC_PHONE_SCND |
|
sevisIdNumber | sevis_id_number | PS_CCTC_INTL_STG | CCTC_SEVIS_ID |
|
signature | signature |
| ||
ssn | ssn | PS_CCTC_INTL_STG | CCTC_SSN |
|
ssnNo | ssn_no | PS_CCTC_INTL_STG | CCTC_APPL_SSN_NONE |
|
ssnException | ssn_exception | PS_CCTC_INTL_STG | CCTC_APPL_SSN_EXCP |
|
ssnLast4 | ssn_last4 | PS_CCTC_INTL_STG | CCTC_SSN_LST4 |
|
ssnType | ssn_type | PS_CCTC_INTL_STG | CCTC_APPL_SSN_TYPE |
|
state | state | PS_CCTC_INTL_STG | CCTC_INTL_AGTSTATE |
|
status | status | PS_CCTC_INTL_STG | CCTC_APPL_STATUS |
|
street1 | street_1 | PS_CCTC_INTL_STG | CCTC_INTL_AGTLINE1 |
|
street2 | street_2 | PS_CCTC_INTL_STG | CCTC_INTL_AGTLINE2 |
|
suffix | suffix | PS_CCTC_INTL_STG | CCTC_LGL_SUFFIX |
|
supPageCode | sup_page_code | PS_CCTC_INTL_STG | CCTC_APPL_SQ_PG_CD |
|
termEndDate | term_end_date | PS_CCTC_INTL_STG | CCTC_TERM_END_DT |
|
termStartDate | term_start_date | PS_CCTC_INTL_STG | CCTC_TERM_START_DT |
|
tstmpCreate | tstmp_create | PS_CCTC_INTL_STG | CCTC_APPL_CRTE_TS |
|
tstmpDownload | tstmp_download | PS_CCTC_INTL_STG | CCTC_APPL_DWNLD_TS |
|
tstmpSubmit | tstmp_submit | PS_CCTC_INTL_STG | CCTC_APPL_SBMT_TS |
|
tstmpUpdate | tstmp_update | PS_CCTC_INTL_STG | CCTC_APPL_UPDT_TS |
|
visaType | visa_type | PS_CCTC_INTL_STG | CCTC_VISA_TYPE |
|
zipCode | zip_code | PS_CCTC_INTL_STG | CCTC_INTL_AGTPOST |
|
PS_CCTC_INTL_STG | STATUS_FLAG |
| ||
PS_CCTC_INTL_STG | STATUS_DTTM |
| ||
PS_CCTC_INTL_STG | DESCRLONG_NOTES |
| ||
PS_CCTC_INTL_STG | LASTUPDOPRID |
| ||
PS_CCTC_INTL_STG | LASTUPDDTTM |
|
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 |