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

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

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