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

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

 

email

email

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